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