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 = 9374 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Set up by Mixed In Sheffield it is a place for music/art Industries.Recording,engineering,production of music with rehersal facilities.Photo shoots for album covers and all the myriad of music industry related activities.
Mixed In Sheffield is a proud supporter of Emmaus and does a great deal of work on a charity basis to further the good of the lives of people in Sheffield.
We are an organisation dedicated to the people of Sheffield, to promoting, nurturing, developing and connecting talent.Our mission is to spread the message that Sheffield IS Music and we do music on a scale that would suprise many people.
We punch well above our weight in many areas of the creative arts....let us help show you how and why. MIS.x