|
SELECT xgdb.title,xgdb.id,xgdscreens.filename, MATCH(xgdb.keywords) AGAINST ('') as Relevance
FROM `xgdb`
left join xgdscreens on xgdscreens.id=xgdb.image
WHERE xgdb.title!='Zoo Tycoon: Dinosaur Digs' and MATCH(xgdb.keywords)
AGAINST ('' IN BOOLEAN MODE) group by title HAVING Relevance>2 ORDER BY Relevance desc limit 5
|