Created by Vancouver Film School student Pedro Eboli through the VFS Classical Animation program. To read an interview with Pedro, visit http://www.vfs.com/blog/2008/06/17/better-living-through-ani

Created by Vancouver Film School student Pedro Eboli through the VFS Classical Animation program. To read an interview with Pedro, visit http://www.vfs.com/blog/2008/06/17/better-living-through-ani (Less)

[0.27 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` = 1723 AND r.`staff_review_id` IS NOT NULL AND r.is_published_review = 1 AND r.is_deleted_review = 0) GROUP BY `1`