Avila Magica Horarios y Tarifas 2010

select id_elemento, tipo, MATCH (titulo, keywords) AGAINST ( 'avila magica horarios tarifas 2010') AS Score FROM indices WHERE MATCH (titulo, keywords) AGAINST ( 'avila magica horarios tarifas 2010') AND (tipo='articulo' or tipo='subcateg' or tipo='foto') and keywords like '%avila%' and keywords like '%magica%' and keywords like '%horarios%' and keywords like '%%' and keywords like '%tarifas%' and keywords like '%2010%' ORDER BY Score DESC LIMIT 0, 6