select * from viewshowvenue WHERE (cityname='leicester') AND showdate BETWEEN '2022-02-04' AND '2023-02-20' AND active = 1 AND showdate > getdate() ORDER BY showdate