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 `category_id` in (7)' at line 1
SQL query/queries : select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) 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-05-29 11:32:35' and class_ads.date_expires!='0000-00-00 00:00:00' and class_ads.active=0) as expired , class_slugs.slug from class_ads inner join class_slugs on class_ads.id=class_slugs.object_id where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) 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.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Aguascalientes' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Amazonas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Amazonas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Amazonas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Ancash' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Antioquia' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Antofagasta' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Anzoátegui' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Apure' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Apurimac' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Aragua' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Arauca' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Araucanía' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Arequipa' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Arica y Parinacota' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Atacama' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Atlántico' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Ayacucho' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Aysén' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Azuay' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Baja California' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Baja California Sur' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Barinas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'BioBío' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Bogotá D.C.' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Bolívar' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Bolívar' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Bolívar' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Boyacá' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Buenos Aires Costa Atlántica' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Buenos Aires GBA Norte' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Buenos Aires GBA Oeste' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Buenos Aires GBA Sur' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Buenos Aires Interior' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Cajamarca' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Caldas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Callao' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Campeche' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Cañar' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Capital Federal' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Caquetá' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Carabobo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Carchi' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Casanare' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Catamarca' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Cauca' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Cesar' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Chaco' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Chiapas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Chihuahua' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Chimborazo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Chocó' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Chubut' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Ciudad de México' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Coahuila' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Cojedes' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Colima' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Coquimbo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Córdoba' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Córdoba' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Corrientes' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Cotopaxi' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Cundinamarca' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Cusco' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Delta Amacuro' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Distrito Capital' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Durango' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'El Oro' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Entre Ríos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Esmeraldas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Estado de México' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Falcón' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Formosa' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Galápagos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Guainía' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Guanajuato' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Guárico' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Guaviare' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Guayas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Guerrero' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Hidalgo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Huancavelica' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Huanuco' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Huila' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Ica' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Imbabura' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Jalisco' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Jujuy' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Junin' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'La Guaira' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'La Guajira' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) 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.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'La Pampa' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'La Rioja' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Lambayeque' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Lara' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Lima' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Loja' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Loreto' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Los Lagos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Los Ríos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Los Ríos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) 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.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Magallanes' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Magdalena' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Manabí' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Maule' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Mendoza' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Mérida' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Meta' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Metropolitana de Santiago' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Michoacán' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Miranda' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Misiones' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Monagas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Moquegua' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Morelos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Morona Santiago' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Napo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Nariño' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Nayarit' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Neuquén' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Norte de Santander' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Ñuble' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Nueva Esparta' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Nuevo León' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'O\'Higgins' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Oaxaca' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Orellana' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Pasco' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Pastaza' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Pichincha' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Piura' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Portuguesa' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Puebla' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Puno' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Putumayo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Querétaro' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Quindío' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Quintana Roo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Río Negro' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Risaralda' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Salta' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'San Andrés y Providencia' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'San Juan' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'San Luis' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'San Luis Potosí' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) 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.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Santa Cruz' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Santa Elena' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Santa Fe' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Santander' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Santiago del Estero' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Santo Domingo de los Tsáchilas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Sinaloa' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Sonora' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Sucre' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Sucre' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Sucumbíos' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Tabasco' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Táchira' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Tacna' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Tamaulipas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Tarapacá' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Tierra del Fuego' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Tlaxcala' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Tolima' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Trujillo' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Tucumán' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Tumbes' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Tungurahua' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Ucayali' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Valle del Cauca' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Valparaíso' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Vaupés' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Veracruz' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Vichada' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Yaracuy' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Yucatán' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Zacatecas' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Zamora Chinchipe' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and (class_ads.`region` like 'Zulia' )
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and `category_id` in (1)
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and `category_id` in (5)
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and `category_id` in (4)
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Light truck' or class_ads.bodystyle like 'sedán') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and `category_id` in (7)
Error path: rodatiautos.ec/vehiculos/autos/?bodystyle=light+truck%7Csed%C3%A1n&country=pichincha&make=mazda&model=0

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

Filtrar la búsqueda

¡Tu solicitud no generó resultados!
Mazda Pichincha

BUSCAR POR MARCA:

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