PinballRebel.com Pinball Locator      

New Search
Add Location
Search criteria:  City like Cleveland, Country is United States, State is OH
Query: select loc.locationnumber, loc.busname, loc.address, loc.city, loc.state, loc.zipcode, loc.url, loc.gamecount, loc.country, loc.metroarea, loc.date, loc.notes, loc.latitude, loc.longitude, loc.phone, loc.locationtype, (select typename from locationtypes lt where loc.locationtype = lt.locationtype) typename, games.pinname, games.notes as gamenotes, games.date as gamedate, games.recordnumber from locations loc left join (select * from games where deleted = '' or deleted is null) games on loc.locationnumber = games.locationnumber where (loc.deleted = '' or loc.deleted is null) and loc.city like '%Cleveland%' and loc.country = 'United States' and loc.state = 'OH' order by loc.busname asc, loc.address asc, games.pinname asc
Sorry, no records were found!