TRUNCATE table qrtz.ljbos_sitedata;
INSERT into qrtz.ljbos_sitedata
select sn.PKID,sn.COPYRIGHTID,sn.PRODUCTID,sn.SENDTYPE,sn.SITENAME,NULL,sn.SNEDDATE
from tyqk_dispatch.tb_sendrecords_info_new sn 
where sn.SNEDDATE>=subdate(CURDATE(),1) and sn.SENDTYPE<>'CRBTRESLUT';
commit ;
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_synctagsevt_info t on l.uuid=t.uuid set l.rdate=t.receivedate ;  -- 标签
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_tagtemplateevt_info p on l.uuid=p.uuid set l.rdate=p.receivedate ;  -- 标签模板
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_catalog_info ca on l.uuid=ca.uuid set l.rdate=ca.receivedate ;  -- 编目
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_syncmaterialevt_info m on l.uuid=m.uuid set l.rdate=m.receivedate ; -- 素材类(歌曲、专辑、艺人)
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_mv_material mm on l.uuid=mm.uuid set l.rdate=mm.receivedate ;   -- MV素材
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_impproduct_info i on l.uuid=i.uuid set l.rdate=i.receivedate ;  -- 彩铃
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_vrbtdeploy_impproduct i on l.uuid=i.uuid set l.rdate=i.receivedate ;  -- 视频彩铃
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_synccontentcallring_info y on l.uuid=y.uuid set l.rdate=y.receivedate ; -- 振铃
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_synccontentfullmusic_info y on l.uuid=y.uuid set l.rdate=y.receivedate ; -- 全曲
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_synccontentwalkman_info y on l.uuid=y.uuid set l.rdate=y.receivedate ; -- 随身听
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_synccontentlossless_info y on l.uuid=y.uuid set l.rdate=y.receivedate ; -- 无损
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_synccontentmigu_info y on l.uuid=y.uuid set l.rdate=y.receivedate ; -- 爱唱
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_deploymvevt_info mv on l.uuid=mv.uuid set l.rdate=mv.receivedate ; -- MV
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_dalbum_info da on l.uuid=da.uuid set l.rdate=da.receivedate ; -- 数字专辑
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_song_material sm on l.uuid=sm.uuid set l.rdate=sm.receivedate ; -- REST歌曲
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_album_material am on l.uuid=am.uuid set l.rdate=am.receivedate ; -- REST专辑
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_artist_material rm on l.uuid=rm.uuid set l.rdate=rm.receivedate ; -- REST歌曲
UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_tag_template p on l.uuid=p.uuid set l.rdate=p.receivedate ;  -- REST标签模板
-- UPDATE qrtz.ljbos_sitedata l join tyqk_dispatch.tb_rbtresult_info r on l.uuid=r.uuid set l.rdate=i.receivedate ;  -- 彩铃成功率
COMMIT ;