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