transmission group

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 = 8862 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0

next 2 transmission Events view all
Trancelate presents 25 Years of Scot Project at The Classic Grand

Trancelate presents 25 Years of Scot Project

  • The Classic Grand Glasgow
  • Saturday 9th November
  • Trancelate presents 25 Years of Scot Project with a world exclusive 3 hour producer set
    117 attending
    Addiction White at The Bank Bar And Nightclub

    Addiction White

    • The Bank Bar And Nightclub Perth
    • Saturday 7th December
    • We Proudly Present Addiction White an event purveying the finest quality Trance... Brought to you by an array of the finest trance artists
      view events
      about transmission

      Wave of events at Albert Hall Manchester

      The Warehouse Project, Trof, Drop the Mustard, Metropolis, Chibuku and more, come together to present Transmission at The Albert Hall. Four months of events at Manchester’s most unique venue.

      •  

      transmission News view all news

      transmission Artists view all artists

      • Christina Novelli

        Next Playing At:
        Addiction White (7th December)

        Christina Novelli Christina Novelli
      • Anne Savage

        Next Playing At:
        Addiction White (7th December)

        Anne Savage Anne Savage
      • Scot Project

        Next Playing At:
        Trancelate presents 25 Years of Scot Project (9th November)

        Scot Project Scot Project

      Discuss transmission