SELECT artists.artistID, artists.name, 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 artists.active=1 AND Listings.active=1 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 prev 61-120 of 660 121-180 next 181-240 of 660