Costa Oeste de Estados Unidos Clima

select id_elemento, tipo, MATCH (titulo, keywords) AGAINST ( 'costa oeste estados unidos clima') AS Score FROM indices WHERE MATCH (titulo, keywords) AGAINST ( 'costa oeste estados unidos clima') AND (tipo='articulo' or tipo='subcateg' or tipo='foto') and keywords like '%costa%' and keywords like '%oeste%' and keywords like '%%' and keywords like '%estados%' and keywords like '%unidos%' and keywords like '%clima%' ORDER BY Score DESC LIMIT 0, 6