Support:Queries: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Hendrik Brummermann |
imported>Hendrik Brummermann |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 96: | Line 96: | ||
SELECT left(timedate, 10) As day, source, param1, count(*) As cnt |
SELECT left(timedate, 10) As day, source, param1, count(*) As cnt |
||
FROM gameEvents |
FROM gameEvents |
||
WHERE event='use' AND timedate>date_sub(CURDATE(), INTERVAL |
WHERE event='use' AND timedate>date_sub(CURDATE(), INTERVAL 30 day) |
||
GROUP BY day, param1, source ORDER BY cnt DESC |
GROUP BY day, param1, source ORDER BY cnt DESC |
||
LIMIT 50; |
LIMIT 50; |
||