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