home

Dealers

JR's Jeeps
 

Cars:

 
CJ7
 
Wrangler
 
Scout
 
 

Salesmen:

 
 
Joe Smith
 
 
Jane Rogers
Vince's Volkswagens
 

Cars:

 
GTI
 
Beetle
 
Golf
 
Cabriolet
 
 

Salesmen:

 
 
Joe Smith
Corey's Cryslers
 

Cars:

 
La Baron
 
 

Salesmen:

 
 
Jane Rogers
 
 
Stan Getz
Patrick's Pontiacs
 

Cars:

 
Firebird
 
Freebird
 
 

Salesmen:

 
 
Joe Smith
 
 
Jane Rogers
 
 
Stan Getz
 
 
Robert Plant
(db2) 3 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `dealers`220
2DESCRIBE `dealers_salesmen`330
3SELECT `Dealer`.`id`, `Dealer`.`name` FROM `dealers` AS `Dealer` WHERE 1 = 1 440
(default) 2 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `cars`330
2SELECT `Car`.`id`, `Car`.`name`, `Car`.`dealer_id` FROM `cars` AS `Car` WHERE `Car`.`dealer_id` IN (1, 2, 3, 4) 10100
(db3) 2 queries took 23 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `salesmen`221
2SELECT `Salesman`.`id`, `Salesman`.`name`, `DealersSalesman`.`id`, `DealersSalesman`.`dealer_id`, `DealersSalesman`.`salesman_id` FROM `salesmen` AS `Salesman` JOIN `vinceall_cakedb2`.`dealers_salesmen` AS `DealersSalesman` ON (`DealersSalesman`.`salesman_id` IN (1, 2, 3, 4) AND `DealersSalesman`.`dealer_id` = `Salesman`.`id`) 9922