SELECT t1.est_id, t1.icon, t1.est_name, t1.est_street, t1.est_city, t1.est_state, t1.est_zip, t1.est_phone, t1.accnt_type, t1.percentoffcard, t2.est_type, t4.cuisine_type, t5.music_type FROM est_overview AS t1, type_of_est as t2, type_of_cuisine as t4, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Pizza' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Subs' AND t1.est_id = t5.est_id AND t5.music_type = 'Big Band/Swing ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Search is temporary unavailable.
Pizza Big Band/Swing Music Subs Food in the Twin Cities | Twincitiesfun.com
Pizza Big Band/Swing Music Subs Food in the Twin Cities