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 32,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
Ram Mega Autos
(829) 887-2427 / (829) 887-2427
Avenida Ortega y Gasset No. 27 Esquina Mauricio Báez, (Frente a la Plaza de la Salud),, Ensanche la Fe Santo Domingo, República Dominicana
MIEMBRO DE: 
Rodriguez Auto Venta
(809) 561-3503 / (809) 440-7811
Prolongacion 27 de Febrero No. 5, Residencial Alameda Santo Domingo Oeste, República Dominicana
MIEMBRO DE:
Solo Auto Import
(809) 363-0303 / (829) 570-7817
Avenida Nunez de Caceres No. 802, Las Castellanas Santo Domingo, República Dominicana
MIEMBRO DE:
Somos Autos Paul Perez
(809) 735-1919 / (809) 735-1919
Carretera Luperón Km 6 1/2, Gurabo Santiago, República Dominicana
MIEMBRO DE: 
Then Autos
(809) 273-6200 / (809) 303-6200
Avenida Venezuela No. 81, Ensanche Ozama Santo Domingo Este, República Dominicana
MIEMBRO DE:
Trebol Auto Import
(829) 590-5974 / (809) 889-3686
Calle Cruz Maria Reyes No. 24 A, Cancino I Santo Domingo Este, República Dominicana
MIEMBRO DE: 
Valmed Auto Import
(829) 430-8672 / (809) 706-4453
Av. Charles de Gaulle No. 16, Reparto Los Tres Ojos Santo Domingo Este, República Dominicana
MIEMBRO DE:
Yoja Auto Import
(809) 533-5763 / (849) 253-3322
Autopista 30 de mayo No. 13b, Marginal Sur Santo Domingo, República Dominicana
MIEMBRO DE:
