Colours group

Keep track of Colours events, tickets and news - all in one place. Join this group now for updates as they happen!

SELECT artists.* , MIN(iEventDate) as firstEventDate, EventName as firstEventName, ListingInstance.iListingInstance as firstEventILID FROM artists INNER JOIN artistListing ON artists.artistID = artistListing.artistID INNER JOIN Listings ON Listings.ListingID = artistListing.ListingID INNER JOIN ListingInstance ON ListingInstance.iListingID = Listings.ListingID INNER JOIN ListingPromotionBrand ON ListingPromotionBrand.listingID = Listings.ListingID WHERE 1=1 AND Listings.active=1 and iEventDate >= CURDATE() AND promotionBrandID = 8434 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0

next 3 Colours Events view all
Gunz For Hire - Blood Brothers Feat Gunz for Hire Ran-D DJ Adaro at O2 Academy Glasgow

Gunz For Hire - Blood Brothers Feat Gunz for Hire Ran-D DJ Adaro

  • O2 Academy Glasgow Glasgow
  • Friday 27th September
  • Hardstyle Superheroes Present Gunz for Hire - Blood Brothers Feat Gunz for Hire Ran-D DJ Adaro
    173 attending
    A Night of Ibiza Trance Classics at SWG3 Studio Warehouse

    A Night of Ibiza Trance Classics

    • SWG3 Studio Warehouse Glasgow
    • Saturday 28th September
    • For the next instalment of A Night of Trance classics... Ibiza Trance Classics
      110 attending
      STREETrave Classical at O2 Academy Glasgow

      STREETrave Classical

      • O2 Academy Glasgow Glasgow
      • Saturday 12th October
      • Colours classical celebrates 30 years of STREETrave classic this October!
        view events
        about Colours
        Colours is Scotland's longest running dance promoter bringing the world's best DJs to Scotland's best venues.

        •  

        Colours News view all news

        Colours Artists view all artists

        • Gunz For Hire

          Next Playing At:
          Gunz For Hire - Blood Brothers Feat Gunz for Hire Ran-D DJ Adaro (27th September)

          Gunz For Hire Gunz For Hire

        Discuss Colours