SELECT v.* FROM video v INNER JOIN viddomains vd ON v.VID = vd.VID LEFT JOIN video_comments_count vc ON v.VID = vc.VID WHERE vd.domainid=14 and vd.domainchannel like '%|180|%' and v.type='public' and active = '1' AND ( ucase(a.title) like '%PERSIAN%' or ucase(a.title) like '%FARSI%' ) ORDER BY vc.count DESC