Support:Queries: Difference between revisions

Content deleted Content added
imported>Hendrik Brummermann
No edit summary
imported>Hendrik Brummermann
Line 103:
FROM gameEvents
WHERE (source='[character1]' OR source='[character2]') AND event='use' GROUP BY source, event, day ORDER BY day;
</source>
 
=== Checking if someone is a bot (alternative) ===
 
<source lang="SQL">
SELECT source, left(timedate, 13) As hour, count(*) As cnt
FROM gameEvents
WHERE source in ('marquis') GROUP BY hour ORDER BY id DESC LIMIT 500;
</source>