Bodeguita Del Medio Playa Del Carmen

select id_elemento, tipo, MATCH (titulo, keywords) AGAINST ( 'bodeguita medio playa carmen') AS Score FROM indices WHERE MATCH (titulo, keywords) AGAINST ( 'bodeguita medio playa carmen') AND (tipo='articulo' or tipo='subcateg' or tipo='foto') and keywords like '%bodeguita%' and keywords like '%%' and keywords like '%medio%' and keywords like '%playa%' and keywords like '%%' and keywords like '%carmen%' ORDER BY Score DESC LIMIT 0, 6