Which locations have Bingo (1953), machine id 846?

[RyanTG]

Machine ID: 846

[RyanTG]

Additionally, which locations have these three machines:

712 901 907

[RyanTG]

Which locations have 911

[RyanTG]

And 996 (note to self, this name seems incomplete; contact admin to check on it)

[RyanTG]

aaaand 997

[RyanTG]

1046

[RyanTG]

1313

[RyanTG]

1212

[RyanTG]

1206

[RyanTG]

793 1142

[RyanTG]

1135 852

[RyanTG]

1115

[scottwainstock]

SQL> select r.name as region_name, l.name as location_name, m.name as machine_name, m.id as machine_id from location_machine_xrefs x inner join locations l on (l.id = x.location_id) inner join machines m on (m.id = x.machine_id) inner join regions r on (l.region_id = r.id) where machine_id in (846, 712, 901, 907, 911, 996, 997, 1046, 1313, 1212, 1206, 793, 1142, 1135, 852, 1115) order by region_name, location_name, machine_name; +----------------------------------------------------------------------------+ | region_name | location_name | machine_name | machine_id | +----------------------------------------------------------------------------+ | austin | Pinballz Arcade | Star Trek | 712 | | austin | Pinballz Arcade | Star Trek (Bally) | 907 | | bayarea | Pacific Pinball Museum | Egg Head | 1313 | | bayarea | Pacific Pinball Museum | Foto Finish | 1212 | | bc | Crackerz | Star Trek | 901 | | boston | Pinball Wizard | Star Trek | 712 | | champaign | Zanzabar | Star Trek (Bally) | 907 | | chicago | Galloping Ghost Arcade | Sea Devil | 1115 | | colorado | 3 Kings Tavern | 8 Ball Deluxe | 1206 | | colorado | Moe's Original Bar B Que | Star Trek | 712 | | la | Pins and Needles | Grand Prix | 793 | | nebraska | Mix Barcade | 8 Ball Deluxe | 1206 | | nyc | Amsterdam Billiards and Bar | Star Trek (Bally) | 907 | | pittsburgh | Games N At | Star Trek | 712 | | portland | C-Bar | 8 Ball Deluxe | 1206 | | seattle | Dorky's Arcade | Elvira | 911 | | seattle | Duck Island Ale House | Elvira | 911 | | seattle | Seattle Pinball Museum | Pinball | 1046 | | seattle | The Grizzled Wizard | Elvira | 911 | | seattle | Tiger Lounge | Grand Prix | 793 | | spokane | Bolo's Bar & Grll | Elvira | 911 | | twincities | Blainebrook | 8 Ball Deluxe | 1206 | +----------------------------------------------------------------------------+

[RyanTG]

Notes to self:

| austin | Pinballz Arcade | Star Trek | 712 | | austin | Pinballz Arcade | Star Trek (Bally) | 907 | | bayarea | Pacific Pinball Museum | Egg Head | 1313 | DELETED | bayarea | Pacific Pinball Museum | Foto Finish | 1212 | DELETED | bc | Crackerz | Star Trek | 901 | | boston | Pinball Wizard | Star Trek | 712 | | champaign | Zanzabar | Star Trek (Bally) | 907 | | chicago | Galloping Ghost Arcade | Sea Devil | 1115 | COOL | colorado | 3 Kings Tavern | 8 Ball Deluxe | 1206 | DELETED | colorado | Moe's Original Bar B Que | Star Trek | 712 | | la | Pins and Needles | Grand Prix | 793 | COOL | nebraska | Mix Barcade | 8 Ball Deluxe | 1206 | DELETED | nyc | Amsterdam Billiards and Bar | Star Trek (Bally) | 907 | | pittsburgh | Games N At | Star Trek | 712 | | portland | C-Bar | 8 Ball Deluxe | 1206 | DELETED | seattle | Dorky's Arcade | Elvira | 911 | DELETED | seattle | Duck Island Ale House | Elvira | 911 | DELETED | seattle | Seattle Pinball Museum | Pinball | 1046 | DELETED | seattle | The Grizzled Wizard | Elvira | 911 | DELETED | seattle | Tiger Lounge | Grand Prix | 793 | COOL | spokane | Bolo's Bar & Grll | Elvira | 911 | DELETED | twincities | Blainebrook | 8 Ball Deluxe | 1206 | DELETED

| seattle | Bridle Trails New York Pizza | Football | 1461 (emailed pizza shop to figure out which machine this is)

1135