[3.16 ms] SELECT COUNT(DISTINCT(r.review_id)) AS `cnt`, `vr`.`video_id`, `cr`.`channel_id`, `ur`.`user_id`, `mr`.`movie_id`, 1 FROM `reviews` AS `r`
LEFT JOIN `video__reviews` AS `vr` ON vr.review_id = r.review_id
LEFT JOIN `channel__reviews` AS `cr` ON cr.review_id = r.review_id
LEFT JOIN `user__reviews` AS `ur` ON ur.review_id = r.review_id
LEFT JOIN `movie__reviews` AS `mr` ON mr.review_id = r.review_id WHERE (1 AND r.`review_type_id` = 1 AND vr.`video_id` = 2119 AND r.`staff_review_id` IS NOT NULL AND r.is_published_review = 1 AND r.is_deleted_review = 0) GROUP BY `1`