Support:Queries: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Hendrik Brummermann |
imported>Hendrik Brummermann |
||
| (15 intermediate revisions by the same user not shown) | |||
| Line 19: | Line 19: | ||
=== Merge all characters into an account === |
=== Merge all characters into an account === |
||
1. Learn the |
1. Learn the names of the original account and new account: |
||
<pre> |
<pre> |
||
| 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; |
||