Souper Bowl of Caring Videos
SELECT V.id, V.title, V.description, COUNT(video_id) AS "views", V.date_added, G.oname, G.id
FROM resources.videos AS V
LEFT JOIN resources.videos_watched as W ON W.video_id = V.id
LEFT JOIN webdb.group_profiles AS G ON G.id = V.cong_id
WHERE V.approved=1 AND
V.id IN (104, 103, 81, 66, 53, 0, 59, 76, 77, 67)
GROUP BY V.id
Popular Movies
Recently Added