SELECT v.vid_id, COUNT(*) AS ord FROM videos AS v LEFT JOIN video_comments AS vc
						   ON v.vid_id = vc.vid_id WHERE 1  AND v.converted='1' AND v.broadcast = 0  AND v.approved='1' 
						   GROUP BY v.vid_id ORDER BY ord DESC:Unknown column 'vc.vid_id' in 'on clause'