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.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') )
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-05-31 00:37:46' 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Amazonas' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Ancash' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Apurimac' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Arequipa' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Ayacucho' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Cajamarca' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Callao' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Cusco' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Huancavelica' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Huanuco' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Ica' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Junin' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'La Libertad' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Lambayeque' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Lima' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Loreto' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Madre de Dios' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Moquegua' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Pasco' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Piura' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Puno' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'San Martin' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Tacna' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Tumbes' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`region` like 'Ucayali' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like '1500' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like '3500' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Agile' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Alto' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Astra' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Astro' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Avalanche' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Aveo' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'B-10' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'B-20' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Beat' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Bel Air' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Beretta' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Blazer' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Bolt' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Bolt EV' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'C-15' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'C-1500' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'C-20' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'C-30' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'C-35' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'C10' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'C100' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Camaro' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Caprice' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Captiva' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Cavalier' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Celta' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Century' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Chevette' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Chevy' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Chevy Nova' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Chevy Pick Up' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Chevy Van' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Cheyenne' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Classic' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Cobalt' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Colorado' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Combo' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Corsa' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Corsica' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Corvette' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Cruze' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Cutlass' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'D-Max' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'D20' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Epica' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Equinox' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Esteem' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Express' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Gemini' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Grand Blazer' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Grand Vitara' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Groove' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'HHR' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Impala' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Joy' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Lumina' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'LUV' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'LUV D-MAX' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Luv Grand 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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Malibu' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Marajo' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Matiz' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Meriva' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Montana' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Monte Carlo' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Monza' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'N200' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'N300' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'N400' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Onix' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Opala' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Optra' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Orlando' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Pick-Up' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Prisma' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Record Sprint' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'S10' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Sail' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Saturn' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Savana' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Sierra' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Silverado' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Sonic' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Sonora' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Spark' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Spark GT' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Spin' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Sprint' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Suburban' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Tahoe' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Tornado' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Tracker' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Trailblazer' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Traverse' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Trax' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Trooper' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Uplander' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Vanette' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Vectra' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Venture' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Vivant' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Volt' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Wagon R' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'WFR' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Work Truck' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (class_ads.`model` like 'Zafira' )
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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) 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.country like 'Perú') ) and ( (class_ads.fuel like 'Hibrido') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and ( (class_ads.region like 'Puno') ) and (`traccion` like '4x4' )
Error path: rodaticars.com/vehiculos/automoviles/?country=per%C3%BA&fuel=hibrido&make=chevrolet&model=0®ion=puno

Se encontraron 0 anuncios en Chevrolet Automóviles Puno Perú. Mira todos los anuncios de Chevrolet Automóviles Puno Perú y encuentra el que necesitas, con los mejores precios de vendedores particulares y profesionales. Compra y vende Chevrolet Automóviles Puno Perú y nunca dejes de buscar. En Rodati nos encargamos de acercarte los mejores anuncios de Chevrolet Automóviles Puno Perú.

Filtrar la búsqueda

¡Tu solicitud no generó resultados!
Chevrolet Automóviles Puno Perú

BUSCAR POR MARCA:

AcuraAgraleAlfa RomeoArraAsia MotorsAston MartinAudiAutorradBaicBentleyBMWBrillianceBuickBYDCadillacChanaChanganChangheCheryChevroletChireyChryslerCitroenCupraDaewooDaihatsuDFM DongfengDFSKDodgeDongfengDomyDS AUTOMOBILESExeedFAWFerrariFiatFordFotonGAC GonowGeelyGMCGreat WallHafeiHaimaHavalHigerHondaHuanghai SGHummerHyundaiInfinitiIsuzuIvecoJACJaguarJeepJetourJinbeiJMCKaiyiKenboKeytonKIAKing LongKYCLadaLamborghiniLanciaLand RoverLandwindLexusLifanLincolnLotusMahindraMaseratiMaxusMazdaMercedes BenzMcLarenMercuryMGMINIMitsubishiNissanOmodaOpelPeugeotPontiacPorscheProtonRAMRenaultRolls-RoyceRoverSaabSamsungSaturnSeatSeresSero ElectricSEVSkodaShineraySMASmartSoueastSsangYongSubaruSuzukiSWM MotorsTATATeslaToyotaUAZVolkswagenVolvoZNAZotyeZX
Ve arriba