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 8,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
Comboy Autos
(809) 547-2250 / (809) 996-9070
Avenida Romulo Betancourt 493, Mirador Norte Santo Domingo, República Dominicana
MIEMBRO DE: 
Dautosa
(809) 372-0124 / (829) 542-6337
Autopista Duarte Km 9 1/2, Proximo a Carrefour, Villa Marina Santo Domingo Oeste, República Dominicana
MIEMBRO DE:
EBR Auto Import
(809) 692-3401 / (829) 958-7700
Autopista 30 de Mayo Esquina Calle 2da No. 1, Mar Azul Santo Domingo, República Dominicana
MIEMBRO DE:
Formany Auto Import
(829) 687-7756 / (849) 650-8256
Calle 3era No. 27, a 1 minuto de Repuestos Dat-Colt, Isabel Aguiar, Industrial Herrera Santo Domingo Oeste, República Dominicana
MIEMBRO DE: 
Frankel Auto Import
(809) 884-3948 / (829) 940-3695
Avenida San Vicente de Paúl No. 328, Alma Rosa II Santo Domingo Este, República Dominicana
MIEMBRO DE:
Gerson y Melvin Auto Import
(809) 570-6325 / (829) 292-1719
Km 6 1/2 autopista canabacoa, Canabacoa Santiago, República Dominicana
MIEMBRO DE:
J&E Auto Móvil
(809) 362-2481 / (809) 901-9585
Avenida Gustvo Mejia Ricar NO.193, Ensanche Quisquella Santo Domingo, República Dominicana
MIEMBRO DE:
JA López Auto Import
(809) 476-9670 / (829) 278-4173
Avenida Sabana Larga No. 85, Alma Rosa I Santo Domingo Este, República Dominicana
MIEMBRO DE: 
