Advertisement
pisio

Untitled

Feb 26th, 2014
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.51 KB | None | 0 0
  1. SELECT *, 1 AS TYPE ,
  2. (SELECT COUNT(`vote_videos`.`id`) FROM `vote_videos`  WHERE `vote_videos`.`session_id` = '435c19e04b62ee1010cd3d22f6988bc0' AND `vote_videos`.`video_id` = `videos`.`id` AND `sessions`.`is_active` ) AS is_voted,
  3. (SELECT COUNT(`vote_videos`.`id`) FROM `vote_videos` INNER JOIN `sessions` WHERE  `sessions`.`session_id`='435c19e04b62ee1010cd3d22f6988bc0' AND
  4.  `vote_videos`.`video_id` = `videos`.`id` AND
  5.  `sessions`.`is_active` )-1 AS votes
  6. FROM `videos` WHERE `active` = '1' ORDER BY `votes` DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement