| 0.0058 |
SELECT `plays`.`user_id`, `username`, count(*) total_plays
FROM `plays`
JOIN `users` ON `plays`.`user_id` = `users`.`id`
WHERE `plays`.`created` > date_sub(current_timestamp, interval 1 month)
GROUP BY `plays`.`user_id`, `username`
ORDER BY `total_plays` DESC
LIMIT 5
|
| 0.0025 |
SELECT `plays`.`user_id`, `username`, count(*) total_plays
FROM `plays`
JOIN `users` ON `plays`.`user_id` = `users`.`id`
WHERE `plays`.`created` > date_sub(current_timestamp, interval 1 month)
GROUP BY `plays`.`user_id`, `username`
ORDER BY `total_plays` DESC
LIMIT 20
|
| 0.0001 |
SELECT `users_groups`.`group_id` as `id`, `groups`.`name`, `groups`.`description`
FROM `users_groups`
JOIN `groups` ON `users_groups`.`group_id`=`groups`.`id`
WHERE `users_groups`.`user_id` IS NULL
|
