/* getAll 1 (busqueda) - getAll - http://www.casinuevo.net/carro-gemelar-zoom-asalvo.html */ SELECT l.nombre localidad_nombre,l.url_nombre localidad_nombre_url, a.*,u.tienda,u.facebook_uid,u.tlf_verificado,u.telefono , (+IF(LOWER(a.keywords_busqueda) like LOWER('%carro%') OR LOWER('carro%') OR LOWER('%carro'),1,0) +IF(LOWER(a.keywords_busqueda) like LOWER('%carros%') OR LOWER('carros%') OR LOWER('%carros'),1,0) +IF(LOWER(a.nombre) like LOWER('%carros%') OR LOWER('carros%') OR LOWER('%carros'),1,0) +IF(LOWER(a.nombre) like LOWER('%carro%') OR LOWER('carro%') OR LOWER('%carro'),1,0) +IF(LOWER(a.nombre) like LOWER('%carro%') OR LOWER('carro%') OR LOWER('%carro'),1,0) +IF(LOWER(a.keywords_busqueda) like LOWER('%carro gemelar%') OR LOWER('carro gemelar%') OR LOWER('%carro gemelar'),1,0) +IF(LOWER(a.keywords_busqueda) like LOWER('%gemelares%') OR LOWER('gemelares%') OR LOWER('%gemelares'),1,0) +IF(LOWER(a.nombre) like LOWER('%gemelares%') OR LOWER('gemelares%') OR LOWER('%gemelares'),1,0) +IF(LOWER(a.nombre) like LOWER('%gemelar%') OR LOWER('gemelar%') OR LOWER('%gemelar'),1,0) +IF(LOWER(a.nombre) like LOWER('%carro gemelar%') OR LOWER('carro gemelar%') OR LOWER('%carro gemelar'),1,0) +IF(LOWER(a.keywords_busqueda) like LOWER('%carro gemelar zoom%') OR LOWER('carro gemelar zoom%') OR LOWER('%carro gemelar zoom'),1,0) +IF(LOWER(a.keywords_busqueda) like LOWER('%zoomes%') OR LOWER('zoomes%') OR LOWER('%zoomes'),1,0) +IF(LOWER(a.nombre) like LOWER('%zoomes%') OR LOWER('zoomes%') OR LOWER('%zoomes'),1,0) +IF(LOWER(a.nombre) like LOWER('%zoom%') OR LOWER('zoom%') OR LOWER('%zoom'),1,0) +IF(LOWER(a.nombre) like LOWER('%carro gemelar zoom%') OR LOWER('carro gemelar zoom%') OR LOWER('%carro gemelar zoom'),1,0) +IF(LOWER(a.keywords_busqueda) like LOWER('%carro gemelar zoom asalvo%') OR LOWER('carro gemelar zoom asalvo%') OR LOWER('%carro gemelar zoom asalvo'),1,0) +IF(LOWER(a.keywords_busqueda) like LOWER('%asalvos%') OR LOWER('asalvos%') OR LOWER('%asalvos'),1,0) +IF(LOWER(a.nombre) like LOWER('%asalvos%') OR LOWER('asalvos%') OR LOWER('%asalvos'),1,0) +IF(LOWER(a.nombre) like LOWER('%asalvo%') OR LOWER('asalvo%') OR LOWER('%asalvo'),1,0) +IF(LOWER(a.nombre) like LOWER('%carro gemelar zoom asalvo%') OR LOWER('carro gemelar zoom asalvo%') OR LOWER('%carro gemelar zoom asalvo'),1,0) +IF(patrocinado1 IS NOT NULL OR patrocinado2 IS NOT NULL,5,0) -IF(LENGTH(a.descript)>2200,2,0) ) as rank FROM anuncios a LEFT JOIN localidades l ON a.id_localidad = l.id INNER JOIN usuarios u ON u.id = a.id_usuario WHERE 1 AND id_subcategoria != 0 AND website = 'C' AND a.id_categoria !=321 AND id_subcategoria != '330' AND id_subcategoria != '260' AND (MATCH (a.keywords_busqueda) AGAINST ('+carro +gemelar +zoom +asalvo' IN BOOLEAN MODE)) order by rank desc, modificado desc LIMIT 0 , 30