select * from viewshowvenue WHERE (cityname='leicester') AND showdate BETWEEN '2025-10-16' AND '2025-10-20' AND active = 1 AND showdate > getdate() ORDER BY showdate