Code: Select all
(SELECT group_concat(custom_name) FROM rot_groups_data WHERE rot_groups_data.site_id = 16 and rot_groups_data.group_id IN \
(SELECT group_id FROM rot_gallery_stats1 WHERE rot_gallery_stats1.gallery_id = gi.gallery_id AND group_id != 0) \
) as group_names_16,
Code: Select all
(SELECT group_concat(custom_name) FROM rot_groups_data WHERE rot_groups_data.site_id = 16 and rot_groups_data.group_id IN \
(SELECT group_id FROM rot_gallery_stats16 WHERE rot_gallery_stats16.gallery_id = gi.gallery_id AND group_id != 0) \
) as group_names_16,