select data.*,main.subject,main.cdate,main.webURL,main.webNewWin,main.show_type,main.imagexml from 201600204_lang_content data,201600204_product main where main.id = data.id and main.tb = data.tb and main.lang = data.lang and data.tb=3 and data.lang='cn' and data.fn_name='product3' 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 data.*,main.subject,main.cdate,main.webURL,main.webNewWin,main.show_type,main.imagexml from 201600204_lang_content data,201600204_product main where main.id = data.id and main.tb = data.tb and main.lang = data.lang and data.tb=4 and data.lang='cn' and data.fn_name='product4' 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
