Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT `games_tags_map`.`game_id` as 'game_id', GROUP_CONCAT(`games_tags_map`.`tag_id`) as 'tags'
- FROM `games_tags_map`
- LEFT JOIN `games_tags` on `games_tags`.id = `games_tags_map`.`tag_id`
- GROUP BY `games_tags_map`.game_id
- SELECT `games`.`id` AS 'id' from `games`
- SELECT `games`.`id` AS 'id',
- t.`tags` as `tags`
- FROM `games`
- LEFT JOIN (
- SELECT `games_tags_map`.`game_id` as 'game_id', GROUP_CONCAT(`games_tags_map`.`tag_id`) as 'tags'
- FROM `games_tags_map`
- LEFT JOIN `games_tags` on `games_tags`.id = `games_tags_map`.`tag_id`
- GROUP BY `games_tags_map`.game_id
- ) t ON t.`game_id`=`games`.`id`
- SELECT `games`.`id` AS 'id',
- GROUP_CONCAT(DISTINCT `games_tags`.`tag`) AS 'tags'
- FROM `games`
- LEFT JOIN `games_tags_map` ON `games`.`id` = `games_tags_map`.`game_id`
- LEFT JOIN `games_tags` ON `games_tags`.`id` = `games_tags_map`.`tag_id`
- WHERE `games`.`active`=1
- GROUP BY `games`.`id`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement