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>
| |||