Cova D’en Xoroi

select id_elemento, tipo, MATCH (titulo, keywords) AGAINST ( 'cova d&rsquoen xoroi') AS Score FROM indices WHERE MATCH (titulo, keywords) AGAINST ( 'cova d&rsquoen xoroi') AND (tipo='articulo' or tipo='subcateg' or tipo='foto') and keywords like '%cova%' and keywords like '%d&rsquoen%' and keywords like '%xoroi%' ORDER BY Score DESC LIMIT 0, 6