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 (`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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () )
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-01 08:43:21' 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`country` like 'Argentina' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`country` like 'Chile' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`country` like 'Colombia' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`country` like 'Ecuador' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`country` like 'México' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`country` like 'Perú' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (class_ads.`country` like 'Venezuela' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and class_ads.category_id = 1 and ( (class_ads.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) 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.condition_vehicles like 'Usado') ) and ( (class_ads.fuel like 'Hibrido' or class_ads.fuel like 'otro') ) and ( (class_ads.make like 'Chevrolet') ) and ( () ) and (`traccion` like '4x4' )
Error path: rodaticars.com/vehiculos/automoviles/?condition_vehicles=usado&fuel=hibrido%7Cotro&make=chevrolet&model=0

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

Filtrar la búsqueda

¡Tu solicitud no generó resultados!
Chevrolet Automóviles

BUSCAR POR MARCA:

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