SELECT `tb_videos`.*, COALESCE(GROUP_CONCAT(DISTINCT tb_category.name ORDER BY tb_category.name ASC SEPARATOR ', '), '') AS category_name FROM `tb_videos` LEFT JOIN `tb_videos_models` ON `tb_videos`.`id` = `tb_videos_models`.`video_id` LEFT JOIN `tb_models` ON `tb_videos_models`.`model_id` = `tb_models`.`id` LEFT JOIN `tb_videos_categories` ON `tb_videos`.`id` = `tb_videos_categories`.`video_id` LEFT JOIN `tb_category` ON `tb_videos_categories`.`category_id` = `tb_category`.`category_id` LEFT JOIN `tb_videos_categories` as `vcat` ON `tb_videos`.`id` = `vcat`.`video_id` AND `vcat`.`category_id` = 277 WHERE `tb_videos_models`.`model_id` IN ('778') AND `tb_videos_categories`.`category_id` IN ('279','312','395','339','287','320','333','321','369','347','385','309','283','310','371','364') AND `vcat`.`video_id` IS NULL AND `tb_videos`.`id` != '1215' AND `tb_videos`.`status` = 1 GROUP BY `tb_videos`.`id` ORDER BY `tb_videos`.`id` DESC LIMIT 22