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 'Flavio alfaro') ) 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.country like 'Manabí') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and ( (class_ads.region like 'Flavio alfaro') )
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-09 17:03:16' 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.country like 'Manabí') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and ( (class_ads.region like 'Flavio alfaro') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) 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.country like 'Manabí') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and ( (class_ads.region like 'Flavio alfaro') ) and `category_id` in (1)
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.country like 'Manabí') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and ( (class_ads.region like 'Flavio alfaro') ) and `category_id` in (5)
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.country like 'Manabí') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and ( (class_ads.region like 'Flavio alfaro') ) and `category_id` in (4)
select count(DISTINCT class_ads.`id`) from class_ads where class_ads.active=1 and ( (class_ads.country like 'Manabí') ) and ( (class_ads.make like 'Mazda') ) and ( () ) and ( (class_ads.region like 'Flavio alfaro') ) and `category_id` in (7)
Error path: rodatiautos.ec/vehiculos/autos/?country=manab%C3%AD&make=mazda&model=0®ion=flavio+alfaro

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

Filtrar la búsqueda

¡Tu solicitud no generó resultados!
Mazda Flavio alfaro Manabí

BUSCAR POR MARCA:

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