La Toscana Madrid Restaurante

select id_elemento, tipo, MATCH (titulo, keywords) AGAINST ( ' restaurante') AS Score FROM indices WHERE MATCH (titulo, keywords) AGAINST ( ' restaurante') AND (tipo='articulo' or tipo='subcateg' or tipo='foto') AND (`categoria` = '10' OR `categoria` = '35') ORDER BY Score DESC LIMIT 0, 6