Mine

SELECTa.`title`, a.url, a.img, b.sitesid, a.img, a.mpg, a.mpg, a.avi, a.wmv, a.flv, b.uri, b.idimg,match(a.title, a.stripped, a.url) against ('test') as SCORE, statFROM sites AS aRIGHT join img AS b on a.sitesid = b.sitesidWHERE match(a.title, a.stripped, a.url) against('test')AND (width / height BETWEEN 0.6 AND 1.4)AND (width > 400 OR height > 400)AND EXISTS (SELECT * FROM sites AS q WHERE stat = 'A' AND img > 14)GROUP BY b.sitesidORDER BY SCORE DESCLIMIT 100