User talk:Kymara: Difference between revisions

== paperchase check ==

<source lang="sql">

select source, param2 from gameEvents

where event = 'quest'

and param1 = 'paper_chase_2013'

and param2 like 'done%'

order by round(substring_index(substring_index(param2,';',2),';',-1));

</source>

== sokoban check ==

<source lang = "sql">

select `char`, `round`, score as timetaken, (1000000*round - score) as points from

(SELECT

source AS `char`,

least(max(round(substring_index(substring_index(param2,';',2),';',-1))),59) AS `round`,

max(round(substring_index(substring_index(param2,';',3),';',-1))) AS `score`

FROM gameEvents

WHERE event = 'quest'

AND param1 = 'sokoban'

AND param2 LIKE 'done%'

GROUP BY source ) t

order by points desc

limit 10;

</source>