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