| SELECT v.id,v.video_filename,UNIX_TIMESTAMP(v.added) AS 'unix_added',COUNT(vc.id) AS 'comment_count' FROM miphoto_videos AS v LEFT JOIN miphoto_video_comments AS vc ON (v.id=vc.video_id) WHERE v.userid=22416 AND v.video_filename!='' AND v.converted=1 AND v.approved=1 AND (vc.approved=1 OR vc.approved IS NULL) GROUP BY v.id ORDER BY v.added DESC LIMIT 0, 30 |