SELECT * FROM tag_video AS tv, tags AS t, video AS v WHERE tv.tag_id = t.id AND t.tag = 'cut' AND v.type = 'public' AND v.approve =1 AND v.active =1 AND v.VID=tv.vid group by tv.vid ORDER BY v.title LIMIT 0, 4