create view wos_tzgg_con as select dbbinzhou_bincheng.wos_xxzy_con.`id` as `id`,dbbinzhou_bincheng.wos_xxzy_con.`title` as `title`,dbbinzhou_bincheng.wos_xxzy_con.`code` as `code`,FROM_UNIXTIME(dbbinzhou_bincheng.wos_xxzy_con.`dtime`) as
dtime ,dbbinzhou_bincheng.wos_xxzy_con.`source` as `source` from dbbinzhou_bincheng.wos_xxzy_con where dbbinzhou_bincheng.wos_xxzy_con.`catid`=10 and dbbinzhou_bincheng.wos_xxzy_con.`iffb`=1 union select dbbinzhou_xxgkbc.yun_news.`id` as
`id`,dbbinzhou_xxgkbc.yun_news.`title` as `title`,dbbinzhou_xxgkbc.yun_news.`code` as `code`,dbbinzhou_xxgkbc.yun_news.`pickerdate` as dtime ,dbbinzhou_xxgkbc.yun_news.`source` as `source` from dbbinzhou_xxgkbc.yun_news ,
dbbinzhou_xxgkbc.yun_news_tag where dbbinzhou_xxgkbc.yun_news.`iffb`=1 and dbbinzhou_xxgkbc.yun_news_tag.`tcode`='N1cdd8493bd59851f9f2213a9b3a844f6' and dbbinzhou_xxgkbc.yun_news_tag.`ncode`=dbbinzhou_xxgkbc.yun_news.`code`