|
Hostar Marine Transport Systems 1 Kendrick Road Wareham, Massachusetts 02571 P: 508-295-2900 |
Page 1 of 1, showing 1 records out of 1 total, starting on record 1, ending on 1
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `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 `zone_id` = 32 AND `type` = 'dealer' AND `is_active` = '1' AND `is_new` = 0 ORDER BY `Dealer`.`name` asc LIMIT 20 | 1 | 1 | 0 | |
| 2 | SELECT `Zone`.`id`, `Zone`.`code`, `Zone`.`name` FROM `airtighthubs`.`zones` AS `Zone` WHERE `Zone`.`id` = 32 LIMIT 1 | 1 | 1 | 0 | |
| 3 | SELECT `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` FROM `airtighthubs`.`dealers` AS `Dealer` WHERE `Dealer`.`zone_id` = (32) | 1 | 1 | 0 |