Find a Dealer

Click on the state to see a listing of dealers in that area.
US Map

(default) 2 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Dealer`.`id`, `Dealer`.`type`, `Dealer`.`name`, `Dealer`.`contact`, `Dealer`.`address1`, `Dealer`.`address2`, `Dealer`.`city`, `Dealer`.`zone_id`, `Dealer`.`zip`, `Dealer`.`website`, `Dealer`.`phone`, `Dealer`.`fax`, `Dealer`.`comments`, `Dealer`.`is_new`, `Dealer`.`is_active`, `Dealer`.`created`, `Dealer`.`modified`, `Zone`.`id`, `Zone`.`code`, `Zone`.`name` FROM `airtighthubs`.`dealers` AS `Dealer` LEFT JOIN `airtighthubs`.`zones` AS `Zone` ON (`Dealer`.`zone_id` = `Zone`.`id`) WHERE 1 = 1 ORDER BY `Dealer`.`name` asc LIMIT 2020201
2SELECT COUNT(*) AS `count` FROM `airtighthubs`.`dealers` AS `Dealer` LEFT JOIN `airtighthubs`.`zones` AS `Zone` ON (`Dealer`.`zone_id` = `Zone`.`id`) WHERE 1 = 1111