select   data.*,main.subject,main.cdate,main.webURL,main.webNewWin,main.show_type,main.imagexml from 201700071_lang_content data,201700071_product main where main.id = data.id and main.tb = data.tb and main.lang = data.lang and data.tb=2 and data.lang='en' and data.fn_name='product2' and data.columnname='RWDproduct0011' and data.description like '%<show><![CDATA[Y]]></show>%' and (main.inuse = '1' or (main.inuse ='2' and main.sdate <= '2017-10-17' and main.edate >='2017-10-17')) order by main.seq desc

select cateId,  data.*,main.subject,main.cdate,main.webURL,main.webNewWin,main.show_type,main.imagexml from 201700071_lang_content data,201700071_product main where main.id = data.id and main.tb = data.tb and main.lang = data.lang and data.tb=1 and data.lang='en' and data.fn_name='product1' and data.columnname='RWDproduct0011' and data.description like '%<show><![CDATA[Y]]></show>%' and (main.inuse = '1' or (main.inuse ='2' and main.sdate <= '2017-10-17' and main.edate >='2017-10-17')) order by main.seq desc