Hoteles con Encanto en Granada Centro

select id_elemento, tipo, MATCH (titulo, keywords) AGAINST ( 'hoteles con encanto en centro') AS Score FROM indices WHERE MATCH (titulo, keywords) AGAINST ( 'hoteles con encanto en centro') AND tipo='hotel' AND (`categoria` = '31') ORDER BY Score DESC LIMIT 0, 6