Database query error. The error was: errno : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like '4x4'' at line 1
SQL query/queries : select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') )
select distinct class_ads.*, class_ads.id as adid, date_format(class_ads.`date_added`,'%d-%m-%Y') as date_nice, date_format(class_ads.`date_updated`,'%d-%m-%Y') as date_updated_nice, date_format(class_ads.`date_expires`,'%d-%m-%Y') as date_expires_nice, UNIX_TIMESTAMP(class_ads.`date_added`) as `time_added`, UNIX_TIMESTAMP(class_ads.`date_updated`) as `time_updated`, (class_ads.date_expires < '2024-06-03 06:15:24' and class_ads.date_expires!='0000-00-00 00:00:00' and class_ads.active=0) as expired , class_slugs.slug from class_ads use index (active_2) inner join class_slugs on class_ads.id=class_slugs.object_id where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and class_slugs.`type`='listing' order by `featured` desc, date_added desc limit 0, 20
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Antofagasta' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Araucanía' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Arica y Parinacota' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Atacama' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Aysén' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'BioBío' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Coquimbo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Los Lagos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Los Ríos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Magallanes' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Maule' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Metropolitana de Santiago' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Ñuble' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'O\'Higgins' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Tarapacá' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Valparaíso' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '320' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '330' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '520' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '530' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '620' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '630' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Cargo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Dura Truck' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Foison' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Foison Box' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Foison Cargo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Foison ONE' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Livan' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'M7' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Mamut' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Myway' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Truck' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Van' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'X50' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'X60' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'X7' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'X70' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Convertible' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Coupe' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Wagon' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Hatchback' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Minivan' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Pickup' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Sedan' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'SUV' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Van' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`condition_vehicles` like 'Usado' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`condition_vehicles` like 'Nuevo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`transmission` like 'Manual' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`transmission` like 'Automático' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Diesel' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Electrico' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Gas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Gasolina' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Hibrido' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Otro' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`doors` like '2' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`doors` like '3' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`doors` like '4' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`doors` like '5' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '2' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '3' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '4' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '5' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '6' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '7' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '+7' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Amarillo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Azul' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Beige' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Blanco' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Café' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Celeste' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Dorado' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Gris' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Naranjo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Negro' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Plata' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Rojo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Verde' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Vino' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Violeta' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like 'Delantera' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like 'Trasera' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like '4WD' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like 'AWD' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like '4x4' )
Error path: rodaticars.com/vehiculos/automoviles/?bodystyle=van&country=chile&make=lifan&model=0&nro_de_pasajeros=7
SQL query/queries : select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') )
select distinct class_ads.*, class_ads.id as adid, date_format(class_ads.`date_added`,'%d-%m-%Y') as date_nice, date_format(class_ads.`date_updated`,'%d-%m-%Y') as date_updated_nice, date_format(class_ads.`date_expires`,'%d-%m-%Y') as date_expires_nice, UNIX_TIMESTAMP(class_ads.`date_added`) as `time_added`, UNIX_TIMESTAMP(class_ads.`date_updated`) as `time_updated`, (class_ads.date_expires < '2024-06-03 06:15:24' and class_ads.date_expires!='0000-00-00 00:00:00' and class_ads.active=0) as expired , class_slugs.slug from class_ads use index (active_2) inner join class_slugs on class_ads.id=class_slugs.object_id where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and class_slugs.`type`='listing' order by `featured` desc, date_added desc limit 0, 20
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Antofagasta' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Araucanía' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Arica y Parinacota' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Atacama' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Aysén' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'BioBío' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Coquimbo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Los Lagos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Los Ríos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Magallanes' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Maule' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Metropolitana de Santiago' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Ñuble' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'O\'Higgins' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Tarapacá' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`region` like 'Valparaíso' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '320' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '330' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '520' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '530' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '620' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like '630' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Cargo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Dura Truck' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Foison' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Foison Box' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Foison Cargo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Foison ONE' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Livan' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'M7' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Mamut' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Myway' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Truck' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'Van' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'X50' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'X60' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'X7' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (class_ads.`model` like 'X70' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Convertible' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Coupe' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Wagon' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Hatchback' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Minivan' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Pickup' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Sedan' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'SUV' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`bodystyle` like 'Van' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`condition_vehicles` like 'Usado' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`condition_vehicles` like 'Nuevo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`transmission` like 'Manual' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`transmission` like 'Automático' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Diesel' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Electrico' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Gas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Gasolina' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Hibrido' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`fuel` like 'Otro' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`doors` like '2' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`doors` like '3' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`doors` like '4' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`doors` like '5' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '2' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '3' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '4' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '5' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '6' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '7' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and (`nro_de_pasajeros` like '+7' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Amarillo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Azul' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Beige' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Blanco' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Café' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Celeste' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Dorado' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Gris' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Naranjo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Negro' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Plata' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Rojo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Verde' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Vino' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`color` like 'Violeta' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like 'Delantera' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like 'Trasera' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like '4WD' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like 'AWD' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.bodystyle like 'Van') ) and ( (class_ads.country like 'Chile') ) and ( (class_ads.make like 'Lifan') ) and ( () ) and ( (class_ads.nro_de_pasajeros like '7') ) and (`traccion` like '4x4' )
Error path: rodaticars.com/vehiculos/automoviles/?bodystyle=van&country=chile&make=lifan&model=0&nro_de_pasajeros=7
Lifan Automóviles Chile
0 anuncios en Lifan Automóviles Chile
Ver: Lista Foto
Se encontraron 0 anuncios en Lifan Automóviles Chile. Mira todos los anuncios de Lifan Automóviles Chile y encuentra el que necesitas, con los mejores precios de vendedores particulares y profesionales. Compra y vende Lifan Automóviles Chile y nunca dejes de buscar. En Rodati nos encargamos de acercarte los mejores anuncios de Lifan Automóviles Chile.
Filtrar la búsqueda
¡Tu solicitud no generó resultados!