select * from viewshowvenue WHERE (cityname='leicester') AND (heading like '%vegas%') AND showdate BETWEEN '2025-02-05' AND '2025-02-24' AND active = 1 AND showdate > getdate() ORDER BY showdate