{"action":"opened","issue":{"url":"https://api.github.com/repos/JETTA-AT/irs-IVT/issues/2","repository_url":"https://api.github.com/repos/JETTA-AT/irs-IVT","labels_url":"https://api.github.com/repos/JETTA-AT/irs-IVT/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/JETTA-AT/irs-IVT/issues/2/comments","events_url":"https://api.github.com/repos/JETTA-AT/irs-IVT/issues/2/events","html_url":"https://github.com/JETTA-AT/irs-IVT/issues/2","id":185555838,"number":2,"title":"自动化视频库问题处理","user":{"login":"JETTA-AT","id":17901414,"avatar_url":"https://avatars.githubusercontent.com/u/17901414?v=3","gravatar_id":"","url":"https://api.github.com/users/JETTA-AT","html_url":"https://github.com/JETTA-AT","followers_url":"https://api.github.com/users/JETTA-AT/followers","following_url":"https://api.github.com/users/JETTA-AT/following{/other_user}","gists_url":"https://api.github.com/users/JETTA-AT/gists{/gist_id}","starred_url":"https://api.github.com/users/JETTA-AT/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JETTA-AT/subscriptions","organizations_url":"https://api.github.com/users/JETTA-AT/orgs","repos_url":"https://api.github.com/users/JETTA-AT/repos","events_url":"https://api.github.com/users/JETTA-AT/events{/privacy}","received_events_url":"https://api.github.com/users/JETTA-AT/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/JETTA-AT/irs-IVT/milestones/1","html_url":"https://github.com/JETTA-AT/irs-IVT/milestones/IVT_V2","labels_url":"https://api.github.com/repos/JETTA-AT/irs-IVT/milestones/1/labels","id":2096404,"number":1,"title":"IVT_V2","description":"2.视频库问题处理（缺失 偏小 合并）","creator":{"login":"JETTA-AT","id":17901414,"avatar_url":"https://avatars.githubusercontent.com/u/17901414?v=3","gravatar_id":"","url":"https://api.github.com/users/JETTA-AT","html_url":"https://github.com/JETTA-AT","followers_url":"https://api.github.com/users/JETTA-AT/followers","following_url":"https://api.github.com/users/JETTA-AT/following{/other_user}","gists_url":"https://api.github.com/users/JETTA-AT/gists{/gist_id}","starred_url":"https://api.github.com/users/JETTA-AT/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JETTA-AT/subscriptions","organizations_url":"https://api.github.com/users/JETTA-AT/orgs","repos_url":"https://api.github.com/users/JETTA-AT/repos","events_url":"https://api.github.com/users/JETTA-AT/events{/privacy}","received_events_url":"https://api.github.com/users/JETTA-AT/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":0,"state":"open","created_at":"2016-10-27T02:02:55Z","updated_at":"2016-10-27T02:07:34Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2016-10-27T02:07:33Z","updated_at":"2016-10-27T02:07:33Z","closed_at":null,"body":"\r\n--相关查询与修改\r\n/*\r\n\r\nselect  * from ivt_librarydata.dbo.originaldata where moviename like '%洗冤录%'\r\n\r\nselect top 100 * from ivt_librarydata.dbo.originalshowdata where 节目名 like '%美女与极品%'\r\n\r\nupdate ivt_librarydata.dbo.originaldata set Movietype='电视剧' where id =164001\r\n\r\ndelete from ivt_librarydata.dbo.originalshowdata where showid=4721\r\ndelete from ivt_librarydata.dbo.originaldata where id=164000\r\nupdate ivt_librarydata.dbo.originaldata set moviename='洗冤录 I' where id in(55757)\r\n\r\n技术需求：\r\n抗数字干扰，12、十二\r\n新增按钮\r\n添加刷新标题功能\r\n自动失败后将，只需要加入一个参数即可（完成）电影电视剧合并综艺（完成）自动拆分字段（完成）合并修改指令（完成）\r\n*/\r\n\r\n\r\n/*\r\n--更新视图\r\nUSE [ivt_maindata]\r\nGO\r\n\r\nALTER VIEW [dbo].[ivt_mergesdata]\r\nAS\r\n\r\nSELECT     url_id, url, media_id, di_catinfo, di_title, di_shorttitle, cate_id, cate_name, title_id\r\nFROM       ivt_maindata.dbo.ivt_websdata_w_201640\r\nUNION ALL\r\nSELECT     url_id, url, media_id, '', videonamecode, newvideoname, cate_id, newvideocate, title_id\r\nFROM       ivt_maindata.dbo.ivt_appsdata_w_201640\r\n\r\nexec sp_refreshview ivt_mergesdata\r\n\r\nGO\r\n*/\r\n\r\n--合并漏洞：合并会带来--当首次执行电影/电视剧时，综艺的临时表不存在，修改时报错\r\n--临时补漏方法：先找一组综艺执行，生成临时再正常执行电影/电视剧，并修改\r\n/*------->修改指令（合并）--------------\r\nupdate ta set ta.movie_id=tb.movie_id \r\nfrom ivt_maindata.dbo.ivt_datatomovie ta inner join #tmp_1 tb on ta.url_id=tb.url_id and ta.Movie_ID<>tb.movie_id\r\n\t\r\ninsert into ivt_maindata.dbo.ivt_datatomovie(url_id,movie_id,type_id)\r\nselect distinct url_id,movie_id,101 from #tmp_1\r\nwhere url_id not in(select url_id from ivt_maindata.dbo.ivt_splitpreview) and url_id not in(select url_id from ivt_maindata.dbo.ivt_datatomovie)\r\n\r\n\r\nupdate ta set ta.show_id=tb.showid \r\nfrom ivt_maindata.dbo.ivt_datatoarts ta\r\n\tinner join #tmp_2 tb on ta.url_id=tb.url_id and ta.Show_ID<>tb.showid\r\n\t\r\ninsert into ivt_maindata.dbo.ivt_datatoarts(url_id,show_id,type_id)\r\nselect distinct url_id,showid,101 from #tmp_2\r\nwhere url_id not in(select url_id from ivt_maindata.dbo.ivt_datatoarts)\r\n--------------------------------------------*/\r\n--update IVT_MainData.dbo.ivt_websdata_w_201640 set di_shorttitle='猎灵师之镇魂石' where url_id in (60780011,60780012,61131649)\r\n--select  * from ivt_librarydata.dbo.originaldata where moviename like '%使徒行者%'\r\n\r\n--可以将excl中两个单元格中内容复制下来，放入下面字段中，会自动拆分\r\ndeclare @string varchar(1000)='电视剧\t再见布莱克先生'\r\n\r\n--手动id查询（默认为空，当影视库查询出来的不唯一，手工判断适当的id填入下方）\r\ndeclare @id bigint = ''\r\n\r\n\r\n\r\ndeclare @movie_name nvarchar(1000)--电影/电视剧/综艺名称\r\ndeclare @movietype nvarchar(1000)--类型：电影/电视剧/综艺\r\n--拆分\r\nselect @movietype = left(@string,NULLIF(CHARINDEX('\t',@string,1),0)-1)\r\nselect @movie_name = right(@string,len(@string)-NULLIF(CHARINDEX('\t',@string,1),0))\r\n\r\n\r\n--select top 100 * from #tmp_1  --电影/电视剧\r\n--select top 100 * from #tmp_2  --综艺\r\n\r\n---------------------------------------------------------------------------------------------------------\r\n\r\n/************电影电视剧***********/\r\n\r\n--检查视图ivt_maindata.dbo.ivt_mergesdata 是否修改为当前周\r\n\r\n--select top 100 * from ivt_maindata.dbo.IVT_Media\r\n\r\nif(@id = 0)\r\nbegin \r\n\tif(@movietype='电视剧' or @movietype='电影' )\r\n\tbegin\r\n\t\tselect  @id=id from ivt_librarydata.dbo.originaldata   \r\n\t\twhere --movieCount<>0 and\r\n\t\t moviename like '%'+@movie_name+'%'\r\n\t\tand movietype = @movietype\r\n\r\n\t\tif (@@rowcount<>1)\r\n\t\tbegin\r\n\t\t\tselect * from ivt_librarydata.dbo.originaldata   \r\n\t\t\twhere moviename like '%'+@movie_name+'%'\r\n\t\t\t\tand movietype = @movietype\r\n\t\t\t\tand movieCount<>0\r\n\t\tend\r\n\t\telse \r\n\t\tbegin\r\n\t\t\tif object_id('tempdb.dbo.#tmp_1') is not null drop table #tmp_1\r\n\t\t\tselect distinct ta.url_id,id movie_id,moviename,ta.di_title,ta.di_shorttitle,url into #tmp_1\r\n\t\t\tfrom ivt_maindata.dbo.ivt_mergesdata ta --inner join IVT_SplitInfo tc on ta.url_id=tc.URL_ID\r\n\t\t\t\tcross join ivt_librarydata.dbo.originaldata tb\r\n\t\t\twhere (\r\n\t\t\t\tta.di_shorttitle like '%'+@movie_name+'%'\r\n\t\t\t\tor ta.di_title  like '%'+@movie_name+'%'\r\n\t\r\n\t\t\t)\r\n\r\n\t\t\tand cate_name = @movietype\r\n\t\t\tand tb.id=@id  \r\n\t\t\t--and ta.media_id  In(1)\r\n\t\t\tand ta.di_title not like '%预告%' and ta.di_title not like '%預告%' and ta.di_title not like '%纪录片%' \r\n\t\t\tand ta.di_title not like '%宣传%' and ta.di_title not like '%片花%'\r\n\t\t\tand ta.di_title not like '%特辑%' and ta.di_title not like '%花絮%'\r\n\t\t\tand ta.di_title not like '%发布会%'and ta.di_title not like '%片头曲%'\r\n\t\t\tand ta.di_title not like '%片尾曲%'and ta.di_title not like '%主题曲%'\r\n\t\t\tand ta.di_title not like '%片花%'\r\n\t\t\tand ta.di_title not like '%片段%'\r\n\r\n\t\t\tand ta.di_title not like '%剧透%'and ta.di_title not like '%穿帮%'\r\n\r\n\t\t\tand ta.di_shorttitle not like '%预告%' and ta.di_shorttitle not like '%預告%' and ta.di_shorttitle not like '%纪录片%' \r\n\t\t\tand ta.di_shorttitle not like '%宣传%' and ta.di_shorttitle not like '%片花%'\r\n\t\t\tand ta.di_shorttitle not like '%特辑%' and ta.di_shorttitle not like '%花絮%'\r\n\t\t\tand ta.di_shorttitle not like '%发布会%'and ta.di_shorttitle not like '%片头曲%'\r\n\t\t\tand ta.di_shorttitle not like '%片尾曲%'and ta.di_shorttitle not like '%主题曲%'\r\n\t\t\tand ta.di_shorttitle not like '%片花%'\r\n\r\n\t\t\r\n\t\t\tand  ta.di_title not like '%星映话%'\r\n\t\t\tand  ta.di_title not like '%独家日志%'\r\n\t\t\tand  ta.di_title not like '%吟档剧场%'\r\n\t\t\tand  ta.di_title not like '%星访谈%'\r\n\t\t\tand  ta.di_title not like '%快问快答%'\r\n\t\t\tand  ta.di_title not like '%剧能侃%'\r\n\t\t\tand  ta.di_title not like '%姐在片场%'\r\n\t\t\tand  ta.di_title not like '%剧有戏%'\r\n\t\t\tand  ta.di_title not like '%饭制%'\r\n\t\t\tand  ta.di_title not like '%周周见%'\r\n\t\t\tand  ta.di_title not like '%姐不能忍%'\r\n\t\t\tand  ta.di_title not like '%剧刀叨%'\r\n\r\n\t\t\tselect *  from #tmp_1 ta left join ivt_maindata.dbo.ivt_datatomovie tb on ta.url_id=tb.url_id\r\n\t\t\t--两张临时表，#tmp_1 & #tmp_2 当一张生成时，清掉另外一张，可以将修改语句合并，避免误操作\r\n\t\t\tif object_id('tempdb..#tmp_2') is not null truncate table #tmp_2\r\n\t\tend\r\n\tend\r\n\telse if(@movietype='综艺' )\r\n\tbegin\r\n\t\tselect @id=ShowID from  ivt_librarydata.dbo.originalshowdata  --where ShowID=1666\r\n\t\twhere 节目名 like '%'+@movie_name+'%'\r\n\t\t\r\n\t\tif (@@rowcount<>1)\r\n\t\tbegin\r\n\t\t\tselect * from  ivt_librarydata.dbo.originalshowdata  --where ShowID=1666\r\n\t\t\twhere 节目名 like '%'+@movie_name+'%'\r\n\t\tend\r\n\t\telse \r\n\t\tbegin\r\n\t\t\tif object_id('tempdb..#tmp_2') is not null drop table #tmp_2\r\n\t\t\tselect distinct url_id,showid,节目名,cate_name,di_title,di_shorttitle,ta.url into #tmp_2 from ivt_maindata.dbo.ivt_mergesdata ta\r\n\t\t\t\tcross join ivt_librarydata.dbo.originalshowdata tb\r\n\t\t\twhere (di_title like '%'+@movie_name+'%' \r\n\t\t\tor  di_shorttitle  like '%'+@movie_name+'%' \r\n\t\t\t)\r\n \r\n\t\t\tand cate_name = @movietype\r\n\t\t\tand tb.showid=@id\r\n\t\t\t--and ta.media_id IN(19,24)\r\n\r\n\t\t\tand ta.di_title not like '%预告%' and ta.di_title not like '%預告%' \r\n\t\t\tand ta.di_title not like '%宣传%' and ta.di_title not like '%片花%'\r\n\t\t\tand ta.di_title not like '%花絮%'\r\n\t\t\tand ta.di_title not like '%片段%'\r\n\r\n\t\t\tand ta.di_shorttitle not like '%预告%' and ta.di_shorttitle not like '%預告%' \r\n\t\t\tand ta.di_shorttitle not like '%宣传%' and ta.di_shorttitle not like '%片花%'\r\n\t\t\tand ta.di_shorttitle not like '%花絮%'\r\n\t\t\tand ta.di_shorttitle not like '%片段%'\r\n\r\n\t\t\tselect * from #tmp_2 ta left join ivt_maindata.dbo.ivt_datatoarts tb on ta.url_id=tb.url_id\r\n\t\t\tif object_id('tempdb.dbo.#tmp_1') is not null truncate table #tmp_1\r\n\t\tend\r\n\tend\r\nend\r\n------------手动查找ID-------------\r\nelse --@id<>0 手动查找ID\r\n\tbegin\r\n\tif(@movietype='电视剧' or @movietype='电影' )\r\n\t\tbegin\r\n\t\t\tif object_id('tempdb.dbo.#tmp_1') is not null truncate table #tmp_1--drop table #tmp_1\r\n\t\t\tinsert into #tmp_1\r\n\t\t\tselect distinct ta.url_id,id movie_id,moviename,ta.di_title,ta.di_shorttitle,url --into #tmp_1\r\n\t\t\tfrom ivt_maindata.dbo.ivt_mergesdata ta --inner join IVT_SplitInfo tc on ta.url_id=tc.URL_ID\r\n\t\t\t\tcross join ivt_librarydata.dbo.originaldata tb\r\n\t\t\twhere (\r\n\t\t\t\tta.di_shorttitle like '%'+@movie_name+'%'\r\n\t\t\t\tor ta.di_title  like '%'+@movie_name+'%'\r\n\t\t\t\t\r\n\t\t\t)\r\n\r\n\t\t\tand cate_name = @movietype\r\n\t\t\tand tb.id=@id  \r\n\t\t\t--and ta.media_id NOT In(22)\r\n\t\t\tand ta.di_title not like '%预告%' and ta.di_title not like '%預告%' and ta.di_title not like '%纪录片%' \r\n\t\t\tand ta.di_title not like '%宣传%' and ta.di_title not like '%片花%'\r\n\t\t\tand ta.di_title not like '%特辑%' and ta.di_title not like '%花絮%'\r\n\t\t\tand ta.di_title not like '%发布会%'and ta.di_title not like '%片头曲%'\r\n\t\t\tand ta.di_title not like '%片尾曲%'and ta.di_title not like '%主题曲%'\r\n\t\t\tand ta.di_title not like '%片花%'\r\n\t\t\tand ta.di_title not like '%片段%'\r\n\r\n\t\t\tand ta.di_title not like '%剧透%'and ta.di_title not like '%穿帮%'\r\n\r\n\t\t\tand ta.di_shorttitle not like '%预告%' and ta.di_shorttitle not like '%預告%' and ta.di_shorttitle not like '%纪录片%' \r\n\t\t\tand ta.di_shorttitle not like '%宣传%' and ta.di_shorttitle not like '%片花%'\r\n\t\t\tand ta.di_shorttitle not like '%特辑%' and ta.di_shorttitle not like '%花絮%'\r\n\t\t\tand ta.di_shorttitle not like '%发布会%'and ta.di_shorttitle not like '%片头曲%'\r\n\t\t\tand ta.di_shorttitle not like '%片尾曲%'and ta.di_shorttitle not like '%主题曲%'\r\n\t\t\tand ta.di_shorttitle not like '%片花%'\r\n\r\n\r\n\t\t\tand  ta.di_title not like '%星映话%'\r\n\t\t\tand  ta.di_title not like '%独家日志%'\r\n\t\t\tand  ta.di_title not like '%吟档剧场%'\r\n\t\t\tand  ta.di_title not like '%星访谈%'\r\n\t\t\tand  ta.di_title not like '%快问快答%'\r\n\t\t\tand  ta.di_title not like '%剧能侃%'\r\n\t\t\tand  ta.di_title not like '%姐在片场%'\r\n\t\t\tand  ta.di_title not like '%剧有戏%'\r\n\t\t\tand  ta.di_title not like '%饭制%'\r\n\t\t\tand  ta.di_title not like '%周周见%'\r\n\t\t\tand  ta.di_title not like '%姐不能忍%'\r\n\t\t\tand  ta.di_title not like '%剧刀叨%'\r\n\r\n\t\t\tselect *  from #tmp_1 ta left join ivt_maindata.dbo.ivt_datatomovie tb on ta.url_id=tb.url_id\r\n\t\t\tif object_id('tempdb..#tmp_2') is not null truncate table #tmp_2\r\n\t\tend\r\n\telse if(@movietype='综艺' )\r\n\t\tbegin\r\n\t\t\tif object_id('tempdb..#tmp_2') is not null truncate table #tmp_2\r\n\t\t\tinsert into #tmp_2 \r\n\t\t\tselect distinct url_id,showid,节目名,cate_name,di_title,di_shorttitle,ta.url  from ivt_maindata.dbo.ivt_mergesdata ta\r\n\t\t\t\tcross join ivt_librarydata.dbo.originalshowdata tb\r\n\t\t\twhere (di_title like '%'+@movie_name+'%' \r\n\t\t\tor  di_shorttitle  like '%'+@movie_name+'%' \r\n\t\t\t)\r\n \r\n\t\t\tand cate_name = @movietype\r\n\t\t\tand tb.showid=@id\r\n\t\t\t--and ta.media_id IN(19,24)\r\n\r\n\t\t\tand ta.di_title not like '%预告%' and ta.di_title not like '%預告%' \r\n\t\t\tand ta.di_title not like '%宣传%' and ta.di_title not like '%片花%'\r\n\t\t\tand ta.di_title not like '%花絮%'\r\n\t\t\tand ta.di_title not like '%片段%'\r\n\r\n\t\t\tand ta.di_shorttitle not like '%预告%' and ta.di_shorttitle not like '%預告%' \r\n\t\t\tand ta.di_shorttitle not like '%宣传%' and ta.di_shorttitle not like '%片花%'\r\n\t\t\tand ta.di_shorttitle not like '%花絮%'\r\n\t\t\tand ta.di_shorttitle not like '%片段%'\r\n\r\n\t\t\tselect * from #tmp_2 ta left join ivt_maindata.dbo.ivt_datatoarts tb on ta.url_id=tb.url_id\r\n\t\t\tif object_id('tempdb.dbo.#tmp_1') is not null truncate table #tmp_1\r\n\t\tend\r\n\tend\r\n/***电影电视剧**人工判断->修改指令\r\n\r\nupdate ta set ta.movie_id=tb.movie_id \r\nfrom ivt_datatomovie ta\r\n\tinner join #tmp tb on ta.url_id=tb.url_id and ta.Movie_ID<>tb.movie_id\r\n\t\r\n\t\r\ninsert into ivt_datatomovie(url_id,movie_id,type_id)\r\nselect distinct url_id,movie_id,101 from #tmp\r\nwhere \r\nurl_id not in(select url_id from ivt_splitpreview)\r\nand url_id not in(select url_id from ivt_datatomovie)\r\n\r\n*/\r\n\r\n--select * from ivt_maindata.dbo.ivt_websdata_w_201633\r\n--where di_shorttitle like'%陆垚知马俐-电影-高清在线观看%'\r\n--and di_shorttitle<>'陆垚知马俐'\r\n\r\n--update ivt_maindata.dbo.ivt_websdata_w_201633\r\n--set di_shorttitle='陆垚知马俐'\r\n--where di_shorttitle like'%陆垚知马俐-电影-高清在线观看%'\r\n--and di_shorttitle<>'陆垚知马俐'\r\n\r\n\r\n---------------------------------------------------------------------------------------------------\r\n/*\r\n/************综艺***********/\r\n\r\n\r\n\telse if(@movietype='综艺')\r\n\tbegin\r\n\t\tselect * from  ivt_librarydata.dbo.originalshowdata  --where ShowID=1666\r\n\t\twhere 节目名 like '%家有儿女第二部%'\r\n               \r\n\r\n\r\n\t\tdrop table #tmp3\r\n\t\tselect distinct url_id,showid,节目名,cate_name,di_title,di_shorttitle,ta.url into #tmp3 from ivt_mergesdata ta\r\n\t\t\tcross join ivt_librarydata.dbo.originalshowdata tb\r\n\t\twhere (di_title like '%波士堂' \r\n\t\t--and di_title like '%花絮%' \r\n\t\tor  di_shorttitle  like '%波士堂%'\r\n\r\n\t\t )\r\n \r\n\t\tand cate_name='综艺' \r\n\t\tand tb.showid=1664\r\n\t\t--and ta.media_id IN(19,24)\r\n\r\n\t\tand ta.di_title not like '%预告%' and ta.di_title not like '%預告%' \r\n\t\tand ta.di_title not like '%宣传%' and ta.di_title not like '%片花%'\r\n\t\tand ta.di_title not like '%花絮%'\r\n\t\tand ta.di_title not like '%片段%'\r\n\r\n\t\tand ta.di_shorttitle not like '%预告%' and ta.di_shorttitle not like '%預告%' \r\n\t\tand ta.di_shorttitle not like '%宣传%' and ta.di_shorttitle not like '%片花%'\r\n\t\tand ta.di_shorttitle not like '%花絮%'\r\n\t\tand ta.di_shorttitle not like '%片段%'\r\n\t\t--and di_shorttitle in('极速前进')\r\n\r\n\r\n\r\n\r\n\t\tselect * from #tmp3 ta left join ivt_maindata.dbo.ivt_datatoarts tb on ta.url_id=tb.url_id\r\n\t\t--select * from ivt_maindata.dbo.IVT_Media\r\n\r\n\t\tend\r\n\telse \r\n\tprint 'error! 不存在'\r\n\r\n/***综艺**人工判断->修改指令\r\n\r\nupdate ta set ta.show_id=tb.showid \r\nfrom ivt_datatoarts ta\r\n\tinner join #tmp3 tb on ta.url_id=tb.url_id and ta.Show_ID<>tb.showid\r\n\t\r\ninsert into ivt_datatoarts(url_id,show_id,type_id)\r\nselect distinct url_id,showid,101 from #tmp3\r\nwhere url_id not in(select url_id from ivt_datatoarts)\r\n\r\n*/\r\n\r\n\r\n---------------------------------------------------------------------------------------------------\r\n\r\n\r\n/*\r\n\r\n\r\n---------------------------------------------------------------------------------------\r\n--一个URL_ID 同时入库 IVT_DataToMovie（电影电视剧）IVT_DataToArts （综艺）\r\n\r\nselect * from ivt_maindata.dbo.IVT_DataToMovie\r\nwhere URL_ID IN(SELECT URL_ID FROM  ivt_maindata.dbo.IVT_DataToArts )\r\n\r\nselect * from ivt_maindata.dbo.IVT_DataToArts \r\nwhere URL_ID IN(SELECT URL_ID FROM  ivt_maindata.dbo.IVT_DataToMovie )\r\n\r\n\r\ndelete from ivt_maindata.dbo.IVT_DataToMovie\r\nwhere URL_ID IN(SELECT URL_ID FROM  ivt_maindata.dbo.IVT_DataToArts )\r\n\r\ndelete from ivt_maindata.dbo.IVT_DataToArts \r\nwhere URL_ID IN(SELECT URL_ID FROM  ivt_maindata.dbo.IVT_DataToMovie )\r\n\r\n---------------------------------------------------------------------------------------\r\n\r\n\r\n select * from dbo.ivt_websdata_w_201633\r\n where media_id=19 and cate_name='综艺'\r\n\r\n */\r\n */"}}
{"actor":{"display_login":"JETTA-AT"}}