San Cristobal de la Laguna en Tenerife

select id_elemento, tipo, MATCH (titulo, keywords) AGAINST ( 'san cristobal de la laguna en ') AS Score FROM indices WHERE MATCH (titulo, keywords) AGAINST ( 'san cristobal de la laguna en ') AND (tipo='articulo' or tipo='subcateg' or tipo='foto') AND (`categoria` = '48') ORDER BY Score DESC LIMIT 0, 6