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 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 910 61-120 next 121-180 of 910