SELECT d.* FROM 201700702_edcontent d WHERE d.tb=1 and d.lang = 'en' and (d.inuse = '1' or (d.inuse ='2' and d.sdate <= '2018-08-20' and d.edate >='2018-08-20')) order by d.seq desc