User talk:Kymara: Difference between revisions

Content deleted Content added

Revision as of 15:13, 8 November 2013 view source imported>Kymara →paperchase check ← Older edit		Latest revision as of 17:13, 21 November 2013 view source imported>Kymara →sokoban check
(17 intermediate revisions by the same user not shown)
Line 537: == sokoban check == <source lang = "sql"> select `char`, `round`, score as timetaken, (1000000*round - score) as points from ~~select~~ (SELECT source asAS `char`, max(round(substring_index(substring_index(param2,';',2),';',-1))) as `round`, ▼ least(max(round(substring_index(substring_index(param2,';',32),';',-1))),59) asAS `~~score~~round`, ▲ max(round(substring_index(substring_index(param2,';',23),';',-1))) asAS `~~round~~score`, ~~from~~FROM gameEvents ~~where event = 'quest'~~ ~~and~~WHERE ~~param1~~event = '~~sokoban~~quest' ~~and~~AND ~~param2~~param1 ~~like~~= '~~done%~~sokoban' AND param2 LIKE 'done%' ~~group~~GROUP byBY source ) t order by ~~round~~points desc; ~~</sql>~~ limit 10; </source>