SELECT v.vid_id, b.item_id AS ex, COUNT(*) AS ord FROM videos AS v LEFT JOIN bookmarks AS b
						   ON v.vid_id = b.item_id WHERE 1  AND v.converted='1' AND v.broadcast = 0  AND v.approved='1' 
						   AND b.type = 'video'
						   GROUP BY v.vid_id ORDER BY ord DESC, CASE WHEN ( ex > 0 ) THEN 0 ELSE 1 END LIMIT 0,10:Unknown column 'b.type' in 'where clause'