Mallorca.como Llegar a Valldemossa

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