SELECT `customer_teaser`.*, (SELECT COUNT(1) AS total
FROM (
SELECT
`customer_teaser`.`id`
FROM
`fl_dealers_recomendados`, `customer_teaser`
WHERE
`customer_teaser`.`id` = `fl_dealers_recomendados`.`id_dealer` AND `customer_teaser`.`state` IN(1,3)
AND (`customer_teaser`.`accounttype_id` = 10) AND (`customer_teaser`.`id` NOT IN (17,680))
) AS Result) AS total
FROM `fl_dealers_recomendados`, `customer_teaser`
WHERE `customer_teaser`.`id` = `fl_dealers_recomendados`.`id_dealer` AND `customer_teaser`.`state` IN(1,3)
AND (`customer_teaser`.`accounttype_id` = 10) AND (`customer_teaser`.`id` NOT IN (17,680)) ORDER BY `customer_teaser`.`compania` ASC LIMIT 16,8;
SELECT `customer_teaser`.*, (SELECT COUNT(1) AS total
FROM (
SELECT
`customer_teaser`.`id`
FROM
`fl_dealers_recomendados`, `customer_teaser`
WHERE
`customer_teaser`.`id` = `fl_dealers_recomendados`.`id_dealer` AND `customer_teaser`.`state` IN(1,3)
AND (`customer_teaser`.`accounttype_id` = 10) AND (`customer_teaser`.`id` NOT IN (17,680))
) AS Result) AS total
FROM `fl_dealers_recomendados`, `customer_teaser`
WHERE `customer_teaser`.`id` = `fl_dealers_recomendados`.`id_dealer` AND `customer_teaser`.`state` IN(1,3)
AND (`customer_teaser`.`accounttype_id` = 10) AND (`customer_teaser`.`id` NOT IN (17,680)) ORDER BY `customer_teaser`.`compania` ASC
JA Vehículos
(809) 806-2020 / (829) 716-0304
Calle 19 No. 9, El Embrujo 1ro, Santiago, República Dominicana
MIEMBRO DE: 
Jacksonville Auto Import
(809) 594-0158 / (809) 844-5029
Avenida Las Americas No. 22 (Entre La Venezuela y El Puente), Ensanche Ozama Santo Domingo Este, República Dominicana
MIEMBRO DE: 
Japana Motors
(809) 883-2001 / (809) 883-2001
Avenida 27 de Febrero No. 515 (Entre Privada y Caonabo), Manganagua Santo Domingo, República Dominicana
MIEMBRO DE: 
Jomi Motors
(809) 563-4812 / (829) 287-8686
Doctor Defilló #49, Ensanche quisqueya Santo Domingo, República Dominicana
MIEMBRO DE:
Kelwin Autos
(809) 766-5949 / (829) 539-6123
Calle José Cabrera No. 71, Ensanche Ozama Santo Domingo Este, República Dominicana
MIEMBRO DE:
KIKI Auto
(809) 622-2328 / (809) 805-9008
Avenida Jacobo Majluta No 70, Marañon II, Villa Mella. Santo Domingo Norte, República Dominicana
MIEMBRO DE:
Molina Auto Import
(829) 537-9301 / (829) 723-4265
Calle 2da No. 59, próximo a la avenida España y la marina, Los Mameyes, Santo Domingo Este, República Dominicana
MIEMBRO DE:
Montate
(809) 723-5600 / (809) 723-5600
Santo Domingo, Distrito Nacional Santo Domingo, República Dominicana
MIEMBRO DE:
