SKA GIGS IN HADDISCOE

Norfolk Gig Guide is your guide to ska gigs in haddiscoe.

If you love ska gigs, ska bands and go to ska venues in and around the haddiscoe area and want to keep informed about the ska scene for haddiscoe then search through our pages and find what ska music is playing at a venue near haddiscoe.

If you play in a ska band in the haddiscoe, Norfolk area then why not register with Norfolk Gig Guide so other ska enthusiasts can find out what you're up to and where your ska band is playing.

If you have a ska venue in the haddiscoe, Norfolk then why not also register with Norfolk Gig Guide so ska enthusiasts can find out what ska bands are playing in haddiscoe 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 '%haddiscoe%' OR gig_info LIKE '%haddiscoe%' OR gig_address LIKE '%haddiscoe%') AND ( gig_band LIKE '%ska%' OR gig_info LIKE '%ska%' OR gig_musicStyle LIKE '%ska%') 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 ska is thriving in haddiscoe!!