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

next 2 Muzik Events view all
Danza ft Pawsa & Alisha at Tank

Danza ft Pawsa & Alisha

  • Tank Sheffield
  • Saturday 9th November
  • Another huge Danza event ft Pawsa & Alisha!
    94 attending
    Danza ft Gorgon City & Sosa at Tank

    Danza ft Gorgon City & Sosa

    • Tank Sheffield
    • Saturday 23rd November
    • Danza welcome Gorgon City & Sosa to Tank!
      174 attending
      view events
      about Muzik
      A group for all Muzik Events

      •  

      Muzik News view all news

      Muzik Artists view all artists

      • Gorgon City

        Next Playing At:
        Danza ft Gorgon City & Sosa (23rd November)

        Gorgon City Gorgon City
      • ALISHA

        Next Playing At:
        Danza ft Pawsa & Alisha (9th November)

        ALISHA ALISHA
      • SOSA

        Next Playing At:
        Danza ft Gorgon City & Sosa (23rd November)

        SOSA SOSA

      Discuss Muzik