User talk:Kymara: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara |
imported>Kymara |
||
| (13 intermediate revisions by the same user not shown) | |||
| Line 537: | Line 537: | ||
== sokoban check == |
== sokoban check == |
||
<source lang = "sql"> |
<source lang = "sql"> |
||
select `char`, `round`, score as timetaken, (1000000*round - score) as points from |
|||
select |
|||
(SELECT |
|||
source |
source AS `char`, |
||
| ⚫ | |||
max(round(substring_index(substring_index(param2,';', |
least(max(round(substring_index(substring_index(param2,';',2),';',-1))),59) AS `round`, |
||
| ⚫ | |||
FROM gameEvents |
|||
where event = 'quest' |
|||
WHERE event = 'quest' |
|||
AND param1 = 'sokoban' |
|||
AND param2 LIKE 'done%' |
|||
GROUP BY source ) t |
|||
order by |
order by points desc |
||
</sql> |
|||
limit 10; |
|||
</source> |
|||