Art Management™
Web Services for Artists
Show |
Entry Fee |
Slides Due |
Notify |
Art Due |
Art Ret'nd |
Jurors |
|
Could not execute query SELECT shows.ShowID, shows.ShowName, shows.ShowURL, shows.ShowCity, shows.ShowState, shows.AwardMoney, shows.EntryFee, UNIX_TIMESTAMP(ShowDate.DTStart) AS ShowStart, UNIX_TIMESTAMP(ShowDate.DTEnd) AS ShowEnd, UNIX_TIMESTAMP(Slides.DTStart) AS SlidesDue FROM ((shows INNER JOIN events AS ShowDate ON shows.ShowID = ShowDate.ShowID) INNER JOIN events AS Slides ON shows.ShowID = Slides.ShowID) WHERE ShowDate.EventType = "Show" AND Slides.EventType = "Slide Submission" AND ShowDate.DTEnd > "2021-02-25" ORDER BY SlidesDue DESC