Que Ver en San Cristobal de la Laguna en Tenerife.

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