Database query error. The error was: errno : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) and ( (class_ads.region like 'Quito') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) and ( () ) and ( (class_ads.region like 'Quito') )
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 10:57:11' 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) and ( () ) and ( (class_ads.region like 'Quito') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) 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 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) and ( () ) and ( (class_ads.region like 'Quito') ) and `category_id` in (1)
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) and ( () ) and ( (class_ads.region like 'Quito') ) and `category_id` in (5)
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) and ( () ) and ( (class_ads.region like 'Quito') ) and `category_id` in (4)
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.bodystyle like 'Pick-up') ) and ( (class_ads.country like 'Pichincha') ) and ( (class_ads.make like 'Kia rio') ) and ( () ) and ( (class_ads.region like 'Quito') ) and `category_id` in (7)
Error path: rodatiautos.ec/vehiculos/autos/?bodystyle=pick-up&country=pichincha&make=kia+rio&model=0®ion=quito

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

Filtrar la búsqueda

¡Tu solicitud no generó resultados!
Kia rio Quito Pichincha

BUSCAR POR MARCA:

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