If you love Live Music gigs, Live Music bands and go to Live Music venues in and
around the Norfolk area and want to keep informed about the Live Music scene
for Norfolk then search through our pages and find what Live Music music is
playing at
a venue near Norfolk.
If you play in a Live Music band in the Norfolk, Norfolk area then why not register with Norfolk Gig Guide so other Live Music enthusiasts can find out what you're up to and where your Live Music band is playing.
If you have a Live Music venue in the Norfolk, Norfolk then why not also register with Norfolk Gig Guide so Live Music enthusiasts can find out what Live Music bands are playing in Norfolk 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 '%Norfolk%' OR gig_info LIKE '%Norfolk%' OR gig_address LIKE '%Norfolk%') AND ( gig_band LIKE '%Live Music%' OR gig_info LIKE '%Live Music%' OR gig_musicStyle LIKE '%Live Music%') 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 Live Music is thriving in Norfolk!!
