Skip to content

Instantly share code, notes, and snippets.

@RyanTG

RyanTG/pbm-top20.txt

Created January 17, 2020 22:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save RyanTG/11b4f4442c6efc4cc58ca8eaaa8c5eaf to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save RyanTG/11b4f4442c6efc4cc58ca8eaaa8c5eaf to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. RyanTG created this gist Jan 17, 2020.
    24 changes: 24 additions & 0 deletions pbm-top20.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,24 @@
    select name,street,city,state,country,count(distinct x.machine_id) from locations l inner join location_machine_xrefs x on x.location_id=l.id group by 1,2,3,4,5 order by 6 desc limit 20;
    name | street | city | state | country | count
    ----------------------------------------------------------------------+---------------------------------------------------------+-------------------+------------------+---------+-------
    Pinball Perfection | 231 Perry Highway | Westview | PA | US | 284
    Pinball Hall of Fame | 1610 E Tropicana Ave | Las Vegas | NV | US | 204
    Pinball PA/Pennsylvania Coin Operated Gaming Hall of Fame and Museum | 2284 Brodhead Road, Suite 10b | Hopewell Township | PA | US | 187
    Freddy's Pinball Paradise | 44 Bisseser Stra▀e | Echzell | HE | DE | 169
    Game Galaxy | 3 S Lowry St | Smyrna | TN | US | 136
    Flipper- und Arcademuseum Seligenstadt | 6 Wilhelm-Leuschner-Stra▀e | Seligenstadt | HE | DE | 126
    Next Level Pinball Museum | 1458 Northeast 25th Avenue | Hillsboro | OR | US | 119
    The SILVER BALL PLANET | BIG STEP 3rd Floor, 1-6-14, Nishi Shinsaibashi, Chuo-ku | Osaka | Osaka Prefecture | JP | 112
    Silverball Museum | 1000 Ocean Ave | Asbury Park | NJ | US | 111
    Clubhouse NFV | 5 Turbinestraat | Veenendaal | UT | NL | 110
    The Pinball Palace | 3303 Hopkins Avenue | Brunswick | GA | US | 95
    Dutch Pinball Museum | Paul Nijghkade 19-K | Rotterdam | ZH | NL | 92
    Silverball Museum Delray Beach | 19 NE 3rd Ave | Delray Beach | FL | US | 87
    Pacific Pinball Museum | 1510 Webster St | Alameda | CA | US | 86
    Wizard's World | 14613 Lima Rd. | Fort Wayne | IN | US | 82
    Pinballz Arcade | 8940 Research Blvd | Austin | TX | US | 78
    Pocketeer Billiards and Bar | 2444 Clinton St | Buffalo | NY | US | 78
    TitleTown Pinball | 800 O Keefe Road | De Pere | WI | US | 77
    Recbar | 10301 Taylorsville Road | Louisville | KY | US | 73
    Pinball Gallery | 81 Lancaster Ave | Malvern | PA | US | 70
    (20 rows)