| 0.0005 |
SELECT *
FROM `games`
JOIN `games_folders` ON `games`.`game_id` = `games_folders`.`game_id`
WHERE `slug` = 'folders'
|
| 0.0003 |
SELECT *
FROM `folders`
WHERE `slug` = 'zombie-rpg'
|
| 0.0006 |
SELECT *
FROM `games`
JOIN `games_folders` ON `games`.`game_id` = `games_folders`.`game_id`
WHERE `published` = 1
AND `games_folders`.`folder_id` = 6
ORDER BY `games`.`game_id` DESC
LIMIT 9999999
|
| 0.0006 |
SELECT *
FROM `games`
JOIN `games_folders` ON `games`.`game_id` = `games_folders`.`game_id`
WHERE `published` = 1
AND `games_folders`.`folder_id` = 6
ORDER BY `games`.`game_id` DESC
LIMIT 30
|
| 0.0003 |
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
|
