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 '%|181|%' and v.type='public' and active = '1' AND ( ucase(a.title) like '%HINDI%' ) ORDER BY vc.count DESC