User talk:Kymara: Difference between revisions

Jump to navigation Jump to search
← Older edit
Content deleted Content added
imported>Kymara
No edit summary
imported>Kymara
 
(21 intermediate revisions by the same user not shown)
Line 535: Line 535:
order by round(substring_index(substring_index(param2,';',2),';',-1));
order by round(substring_index(substring_index(param2,';',2),';',-1));
</source>
</source>
== sokoban check ==

<source lang = "sql">
<source lang = "sql">
select `char`, `round`, score as timetaken, (1000000*round - score) as points from
select
(SELECT
source as `char`,
source AS `char`,
⚫
max(round(substring_index(substring_index(param2,';',2),';',-1))) as `round`,
max(round(substring_index(substring_index(param2,';',3),';',-1))) as `score`
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
FROM gameEvents
where event = 'quest'
and param1 = 'sokoban'
WHERE event = 'quest'
and param2 like 'done%'
AND param1 = 'sokoban'
AND param2 LIKE 'done%'
group by source
GROUP BY source ) t
order by round desc;
order by points desc
</sql>
limit 10;
</source>
Retrieved from "https://meet.konsthol.eu/w/index.php?title=User_talk:Kymara"