Warning: Use of undefined constant USER_ID - assumed 'USER_ID' (this will throw an Error in a future version of PHP) in /home/vhosts/david.skiddle.com/httpdocs/artists/all_artists.php on line 24
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 <= DATE_ADD(CURDATE(), INTERVAL 1 WEEK) GROUP BY artists.artistID ORDER BY artistRank ASC Artists performing this week
Coronavirus update: View cancelled events here

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