De Noche en Mallorca. Noche en Palma

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