scottwainstock
commented
11 years ago dd688gfpe3a289=> select m.name, l.name, r.name from location_machine_xrefs lmx inner join locations l on (l.id = lmx.location_id) inner join machines m on (lmx.machine_id = m.id) inner join regions r on (l.region_id = r.id) where machine_id in (1591, 1606, 1624) order by m.name, r.name; name | name | name ------------------------------------+---------------------------------------------+-------------- Metallica | Legionnaire Saloon, The | bayarea Metallica | Pacific Pinball Museum | bayarea Metallica | Mauna Loa Club | bayarea Metallica | Pub 340 | bc Metallica | Headquarters Beercade | chicago Metallica | Hollywood Park | chicago Metallica | Gameworks | chicago Metallica | Emporium Arcade Bar | chicago Metallica | Enchanted Castle (Lombard) | chicago Metallica | Bottom Lounge | chicago Metallica | South-A-Philly | jacksonville Metallica | Skylark | nyc Metallica | Ace's Break Away & Play (Downtown) | pittsburgh Metallica | Lutz Tavern | portland Metallica | The Know | portland Metallica | The Standard | portland Metallica | My Father's Place | portland Metallica | Beulahland | portland Metallica | Killer Burger | portland Metallica | Grand Central Restaurant and Bowling Lounge | portland Metallica | Dublin Down | portland Metallica | Stryker's Arcade | portland Metallica | Dorky's Arcade | seattle Metallica | Scotiabank Theatre | toronto Metallica | The Done Right Inn | toronto Metallica | Mackenzie | twincities Metallica (Master of Puppets - LE) | Mortimer's | twincities Metallica (Pro) | Scandia Family Fun Center (RP) | bayarea Metallica (Pro) | Metropole Pub | bc Metallica (Pro) | Cinemark Movies 8 | dfw Metallica (Pro) | Pallazzo's New York Pizza | la Metallica (Pro) | Century Roseville 14 and XD | sacramento Metallica (Pro) | Century 16 Theaters | sacramento Metallica (Pro) | Blainebrook | twincities (34 rows)
Can you tell me which locations have these machines:
1591 1606 1624