Norfolk and Norwich Music & Entertainment - Norfolk and Norwich Gigs
PUNK GIGS IN AYLSHAM
Norfolk Gig Guide is your guide to punk gigs in Aylsham.
If you love punk gigs, punk bands and go to punk venues in and
around the Aylsham area and want to keep informed about the punk scene
for Aylsham then search through our pages and find what punk music is
playing at
a venue near Aylsham.
If you play in a punk band in the Aylsham, Norfolk area then why not register with Norfolk Gig Guide so other punk enthusiasts can find out what you're up to and where your punk band is playing.
If you have a punk venue in the Aylsham, Norfolk then why not also register with Norfolk Gig Guide so punk enthusiasts can find out what punk bands are playing in Aylsham this week.
SELECT gigs.gig_ID, gigs.gig_date, gigs.gig_info, gigs.gig_status, gigs.gig_times, gigs.gig_band_id, gigs.gig_venue_id, gigs.gig_band, gigs.gig_venue, gigs.gig_adminID, (band_cats.cat_singular) AS band_cat, (venue_cats.cat_singular) AS venue_cat, (band.password_style) AS style, (venue.password_style) AS address, gig_address, gig_musicStyle, (band.password_fullTitle) AS band, (venue.password_fullTitle) AS venue FROM gigs INNER JOIN passwords AS band ON band.password_ID = gigs.gig_band_id INNER JOIN passwords AS venue ON venue.password_ID = gigs.gig_venue_id INNER JOIN categories AS band_cats ON band.password_status = band_cats.cat_id INNER JOIN categories AS venue_cats ON venue.password_status = venue_cats.cat_id WHERE gig_status <= 3 AND gig_status > 0 AND ( gig_venue LIKE '%Aylsham%' OR gig_info LIKE '%Aylsham%' OR gig_address LIKE '%Aylsham%') AND ( gig_band LIKE '%punk%' OR gig_info LIKE '%punk%' OR gig_musicStyle LIKE '%punk%') ORDER BY gig_date, gig_times, RAND(SECOND(gig_entryDate)) ASC LIMIT 0, 40
Registering with Norfolk Gig Guide and using all the services is free, simple
and instant so why not let the world know that punk is thriving in Aylsham!!