User talk:Kymara: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara →paperchase check: new section |
imported>Kymara No edit summary |
||
| 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> |
||
<source lang = "sql"> |
|||
select |
|||
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` |
|||
from gameEvents |
|||
where event = 'quest' |
|||
and param1 = 'sokoban' |
|||
and param2 like 'done%' |
|||
group by source |
|||
order by round desc; |
|||
</sql> |
|||