SELECT v.*, video_view.viewnumber, video_view.viewtime FROM video v INNER JOIN viddomains vd ON v.VID = vd.VID INNER JOIN video_view ON v.VID = video_view.VID LEFT JOIN video_comments_count vc ON v.VID = vc.VID WHERE vd.domainid=14 and v.type='public' and active = '1' and ( ( ucase(video.title) like '%ENGLISH%')) ORDER BY vc.count DESC