Palacio Real de la Granja de San Ildefonso

select id_elemento, tipo, MATCH (titulo, keywords) AGAINST ( 'palacio real granja san ildefonso') AS Score FROM indices WHERE MATCH (titulo, keywords) AGAINST ( 'palacio real granja san ildefonso') AND (tipo='articulo' or tipo='subcateg' or tipo='foto') and keywords like '%palacio%' and keywords like '%real%' and keywords like '%%' and keywords like '%%' and keywords like '%granja%' and keywords like '%%' and keywords like '%san%' and keywords like '%ildefonso%' ORDER BY Score DESC LIMIT 0, 6