SELECT artists.artistID,, artists.image , GROUP_CONCAT(DISTINCT Ent.Name SEPARATOR ', ') as EventList 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 Ent ON Ent.EntID = Listings.EntID WHERE AND and iEventDate >= CURDATE() AND iEventDate <= DATE_ADD(CURDATE(), INTERVAL 1 WEEK) GROUP BY artists.artistID ORDER BY artistRank ASC Artists performing this week

artists with events this week

search for artists

Enter an artist's name below or use our A-Z feature to browse artists

Showing artists: 1-60 of 442 61-120 next 121-180 of 442