select * from viewshowvenue WHERE (cityname='leicester') AND showdate BETWEEN '2021-02-01' AND '2021-02-28' AND active = 1 AND showdate > getdate() ORDER BY showdate