Support:Queries: Difference between revisions
Content deleted Content added
imported>Hendrik Brummermann |
imported>Hendrik Brummermann |
||
| (16 intermediate revisions by the same user not shown) | |||
Line 19:
=== Merge all characters into an account ===
1. Learn the
<pre>
Line 96:
SELECT left(timedate, 10) As day, source, param1, count(*) As cnt
FROM gameEvents
WHERE event='use' AND timedate>date_sub(CURDATE(), INTERVAL
GROUP BY day, param1, source ORDER BY cnt DESC
LIMIT 50;
| |||