Benutzer-Werkzeuge

Webseiten-Werkzeuge


extern:ttoppler

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen gezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
extern:ttoppler [2016/01/03 12:46]
bruno
extern:ttoppler [2016/01/03 12:48] (aktuell)
bruno
Zeile 18: Zeile 18:
 [[mysql:​localhost:​web200:​x4OO179w:​usr_web200_2|SELECT max(app) as app, max(cnt) as total_today,​ max(newcnt) as new_today FROM score_today_cnt WHERE app = '​ttoppler'​ UNION ALL SELECT '',​ '',​ ''​ LIMIT 15|10]] [[mysql:​localhost:​web200:​x4OO179w:​usr_web200_2|SELECT max(app) as app, max(cnt) as total_today,​ max(newcnt) as new_today FROM score_today_cnt WHERE app = '​ttoppler'​ UNION ALL SELECT '',​ '',​ ''​ LIMIT 15|10]]
  
-==== 100 Best Results ====+==== 1000 Best Results ====
  
-[[mysql:​localhost:​web200:​x4OO179w:​usr_web200_2|SELECT @i := @i + 1 AS no, app, name, cid, points, date(ifnull(updated,​ created)) as date FROM (select @i:=0) x, score_all WHERE app = '​ttoppler'​ order by points desc limit 500|10]]+[[mysql:​localhost:​web200:​x4OO179w:​usr_web200_2|SELECT @i := @i + 1 AS no, app, name, cid, points, date(ifnull(updated,​ created)) as date FROM (select @i:=0) x, score_all WHERE app = '​ttoppler'​ order by points desc limit 1000|10]]
  
 {{tag>​app googleplay store game frog pond prince sql abfrage query}} {{tag>​app googleplay store game frog pond prince sql abfrage query}}
extern/ttoppler.txt · Zuletzt geändert: 2016/01/03 12:48 von bruno