将一个栏目下资源拷贝到另外800个目标栏目（存在excel中）下

最新推荐文章于 2021-12-04 22:21:43 发布

黯然√邂逅

最新推荐文章于 2021-12-04 22:21:43 发布

阅读量86

点赞数 1

本文链接：https://blog.csdn.net/qq_44804874/article/details/108588176

版权

insert into ColumnAndRes (ColumnID,ResType,ResNo,SortNo,Status,CreatedTime,UpdateTime,CarriorStatus) 

select 112551,1,ResNo,SortNo-1000,1,NOW(),NOW(),"111" 
from ColumnAndRes 
where ResType="1" and ColumnID="303237" AND `Status`=1 AND ResNo NOT IN
(SELECT ResNo FROM ColumnAndRes WHERE ColumnID=112551)

表结构
使用存储过程写：

DROP PROCEDURE IF EXISTS temp_ResourcesComplement;    #如果存在指定存储过程则删除它
DELIMITER //            # 定义存储过程结束符，
CREATE PROCEDURE temp_ResourcesComplement(v_Tcolumnid  VARCHAR(200))
BEGIN
	#Routine body goes here...

            /*定义变量*/

						DECLARE v_ResNo  VARCHAR(200);
						DECLARE v_Count INT;
						DECLARE v_SortNo INT;
						
						
            /*用户控制循环是否结束*/
            DECLARE done_id INT;
            /*定义游标*/
            DECLARE cursor_item CURSOR FOR select ResNo from ColumnAndRes where ResType="1" and ColumnID="303237" AND `Status`=1;
            /*当游标到达尾部的时候,mysql自动设置为done=1*/
            DECLARE CONTINUE HANDLER FOR NOT FOUND SET done_id = 1;
            /*打开游标*/
            OPEN cursor_item;
            /*循环开始*/
            cursor_loop_shop :LOOP
            /*移动游标并赋值*/
                FETCH cursor_item INTO v_ResNo;
            /*游标到达尾部，退出循环*/
                    IF done_id = 1 THEN
                        LEAVE cursor_loop_shop;
                    END IF;
            /*循环输出信息 do something*/
						/*插入之前判断是否符合插入条件*/		
						select count(*) INTO v_Count from ColumnAndRes WHERE ColumnID=v_Tcolumnid and ResType="1" and resno=v_ResNo;		
						IF   v_Count = 1  THEN
									SELECT v_Count,v_ResNo;
						ELSE 
									SELECT MIN(sortno) INTO v_SortNo from ColumnAndRes WHERE  ColumnID=v_Tcolumnid and ResType="1";
											IF   v_SortNo is null THEN
												SET v_SortNo=0;
											END IF;
									SELECT v_SortNo;
						      insert into ColumnAndRes 
										(ColumnID,ResType,ResNo,SortNo,Status,CreatedTime,UpdateTime,CarriorStatus) 
									VALUES 
										(v_Tcolumnid,1,v_ResNo,v_SortNo-1,'1',now(),now(),'111');
						END IF;


            /*循环结束*/
            END LOOP cursor_loop_shop;
            /*关闭游标*/
            CLOSE cursor_item;

END//


CALL temp_ResourcesComplement("240677");
CALL temp_ResourcesComplement("242235");
CALL temp_ResourcesComplement("114323");
CALL temp_ResourcesComplement("46128");
CALL temp_ResourcesComplement("243113");
CALL temp_ResourcesComplement("243101");
CALL temp_ResourcesComplement("111045");
CALL temp_ResourcesComplement("243697");
CALL temp_ResourcesComplement("46515");
CALL temp_ResourcesComplement("117131");
CALL temp_ResourcesComplement("112551");
CALL temp_ResourcesComplement("116317");
CALL temp_ResourcesComplement("304413");
CALL temp_ResourcesComplement("242793");
CALL temp_ResourcesComplement("110257");
CALL temp_ResourcesComplement("108539");
CALL temp_ResourcesComplement("114329");
CALL temp_ResourcesComplement("48108");
CALL temp_ResourcesComplement("46051");
CALL temp_ResourcesComplement("110821");
CALL temp_ResourcesComplement("110033");
CALL temp_ResourcesComplement("48113");
CALL temp_ResourcesComplement("315493");
CALL temp_ResourcesComplement("304417");
CALL temp_ResourcesComplement("311569");
CALL temp_ResourcesComplement("304389");
CALL temp_ResourcesComplement("308141");
CALL temp_ResourcesComplement("312597");
CALL temp_ResourcesComplement("116161");
CALL temp_ResourcesComplement("243843");
CALL temp_ResourcesComplement("318645");
CALL temp_ResourcesComplement("304905");
CALL temp_ResourcesComplement("315061");
CALL temp_ResourcesComplement("307329");
CALL temp_ResourcesComplement("306461");
CALL temp_ResourcesComplement("304029");
CALL temp_ResourcesComplement("318361");
CALL temp_ResourcesComplement("241459");
CALL temp_ResourcesComplement("243457");
CALL temp_ResourcesComplement("313361");
CALL temp_ResourcesComplement("311585");
CALL temp_ResourcesComplement("312589");
CALL temp_ResourcesComplement("242995");
CALL temp_ResourcesComplement("115875");
CALL temp_ResourcesComplement("116027");
CALL temp_ResourcesComplement("245637");
CALL temp_ResourcesComplement("308681");
CALL temp_ResourcesComplement("308237");
CALL temp_ResourcesComplement("243001");
CALL temp_ResourcesComplement("114331");
CALL temp_ResourcesComplement("244455");
CALL temp_ResourcesComplement("46011");
CALL temp_ResourcesComplement("304897");
CALL temp_ResourcesComplement("312441");
CALL temp_ResourcesComplement("317045");
CALL temp_ResourcesComplement("308257");
CALL temp_ResourcesComplement("304393");
CALL temp_ResourcesComplement("309537");
CALL temp_ResourcesComplement("110103");
CALL temp_ResourcesComplement("115391");
CALL temp_ResourcesComplement("46027");
CALL temp_ResourcesComplement("311069");
CALL temp_ResourcesComplement("309005");
CALL temp_ResourcesComplement("317785");
CALL temp_ResourcesComplement("241457");
CALL temp_ResourcesComplement("241335");
CALL temp_ResourcesComplement("112549");
CALL temp_ResourcesComplement("318125");
CALL temp_ResourcesComplement("307173");
CALL temp_ResourcesComplement("312429");
CALL temp_ResourcesComplement("307165");
CALL temp_ResourcesComplement("311081");
CALL temp_ResourcesComplement("318309");
CALL temp_ResourcesComplement("318305");
CALL temp_ResourcesComplement("314009");
CALL temp_ResourcesComplement("314025");
CALL temp_ResourcesComplement("313357");
CALL temp_ResourcesComplement("242769");
CALL temp_ResourcesComplement("240831");
CALL temp_ResourcesComplement("304473");
CALL temp_ResourcesComplement("305293");
CALL temp_ResourcesComplement("242575");
CALL temp_ResourcesComplement("240683");
CALL temp_ResourcesComplement("116867");
CALL temp_ResourcesComplement("242143");
CALL temp_ResourcesComplement("313369");
CALL temp_ResourcesComplement("311921");
CALL temp_ResourcesComplement("245345");
CALL temp_ResourcesComplement("243087");
CALL temp_ResourcesComplement("305797");
CALL temp_ResourcesComplement("317781");
CALL temp_ResourcesComplement("305793");
CALL temp_ResourcesComplement("318061");
CALL temp_ResourcesComplement("117939");
CALL temp_ResourcesComplement("313753");
CALL temp_ResourcesComplement("304409");
CALL temp_ResourcesComplement("305837");
CALL temp_ResourcesComplement("307157");
CALL temp_ResourcesComplement("304481");
CALL temp_ResourcesComplement("315829");
CALL temp_ResourcesComplement("318513");
CALL temp_ResourcesComplement("317945");
CALL temp_ResourcesComplement("303665");
CALL temp_ResourcesComplement("314013");
CALL temp_ResourcesComplement("314021");
CALL temp_ResourcesComplement("243003");
CALL temp_ResourcesComplement("243969");
CALL temp_ResourcesComplement("240991");
CALL temp_ResourcesComplement("104885");
CALL temp_ResourcesComplement("118193");
CALL temp_ResourcesComplement("118181");
CALL temp_ResourcesComplement("46066");
CALL temp_ResourcesComplement("309861");
CALL temp_ResourcesComplement("312433");
CALL temp_ResourcesComplement("244251");
CALL temp_ResourcesComplement("244547");
CALL temp_ResourcesComplement("304525");
CALL temp_ResourcesComplement("312989");
CALL temp_ResourcesComplement("312601");
CALL temp_ResourcesComplement("318117");
CALL temp_ResourcesComplement("244087");
CALL temp_ResourcesComplement("314005");
CALL temp_ResourcesComplement("305845");
CALL temp_ResourcesComplement("317029");
CALL temp_ResourcesComplement("305297");
CALL temp_ResourcesComplement("242135");
CALL temp_ResourcesComplement("242137");
CALL temp_ResourcesComplement("243103");
CALL temp_ResourcesComplement("39003");
CALL temp_ResourcesComplement("117293");
CALL temp_ResourcesComplement("46216");
CALL temp_ResourcesComplement("118337");
CALL temp_ResourcesComplement("115895");
CALL temp_ResourcesComplement("305305");
CALL temp_ResourcesComplement("118185");
CALL temp_ResourcesComplement("115619");
CALL temp_ResourcesComplement("312993");
CALL temp_ResourcesComplement("245337");
CALL temp_ResourcesComplement("307153");
CALL temp_ResourcesComplement("244411");
CALL temp_ResourcesComplement("243951");
CALL temp_ResourcesComplement("312609");
CALL temp_ResourcesComplement("316169");
CALL temp_ResourcesComplement("312593");
CALL temp_ResourcesComplement("317817");
CALL temp_ResourcesComplement("305765");
CALL temp_ResourcesComplement("317733");
CALL temp_ResourcesComplement("306449");
CALL temp_ResourcesComplement("308249");
CALL temp_ResourcesComplement("311913");
CALL temp_ResourcesComplement("118555");
CALL temp_ResourcesComplement("308661");
CALL temp_ResourcesComplement("305789");
CALL temp_ResourcesComplement("307685");
CALL temp_ResourcesComplement("243715");
CALL temp_ResourcesComplement("317257");
CALL temp_ResourcesComplement("242601");
CALL temp_ResourcesComplement("241167");
CALL temp_ResourcesComplement("240833");
CALL temp_ResourcesComplement("308573");
CALL temp_ResourcesComplement("244249");
CALL temp_ResourcesComplement("116523");
CALL temp_ResourcesComplement("307169");
CALL temp_ResourcesComplement("246089");
CALL temp_ResourcesComplement("243947");
CALL temp_ResourcesComplement("315085");
CALL temp_ResourcesComplement("305773");
CALL temp_ResourcesComplement("318517");
CALL temp_ResourcesComplement("304397");
CALL temp_ResourcesComplement("310345");
CALL temp_ResourcesComplement("303673");
CALL temp_ResourcesComplement("309841");
CALL temp_ResourcesComplement("316181");
CALL temp_ResourcesComplement("316185");
CALL temp_ResourcesComplement("318069");
CALL temp_ResourcesComplement("314253");
CALL temp_ResourcesComplement("241693");
CALL temp_ResourcesComplement("241175");
CALL temp_ResourcesComplement("244457");
CALL temp_ResourcesComplement("315589");
CALL temp_ResourcesComplement("116937");
CALL temp_ResourcesComplement("116637");
CALL temp_ResourcesComplement("317745");
CALL temp_ResourcesComplement("115883");
CALL temp_ResourcesComplement("115891");
CALL temp_ResourcesComplement("118177");
CALL temp_ResourcesComplement("305745");
CALL temp_ResourcesComplement("311565");
CALL temp_ResourcesComplement("311573");
CALL temp_ResourcesComplement("311065");
CALL temp_ResourcesComplement("304405");
CALL temp_ResourcesComplement("241467");
CALL temp_ResourcesComplement("241347");
CALL temp_ResourcesComplement("312997");
CALL temp_ResourcesComplement("311933");
CALL temp_ResourcesComplement("317737");
CALL temp_ResourcesComplement("318353");
CALL temp_ResourcesComplement("118435");
CALL temp_ResourcesComplement("241171");
CALL temp_ResourcesComplement("305849");
CALL temp_ResourcesComplement("308665");
CALL temp_ResourcesComplement("305749");
CALL temp_ResourcesComplement("243713");
CALL temp_ResourcesComplement("314033");
CALL temp_ResourcesComplement("303373");
CALL temp_ResourcesComplement("240985");
CALL temp_ResourcesComplement("240983");
CALL temp_ResourcesComplement("242141");
CALL temp_ResourcesComplement("317485");
CALL temp_ResourcesComplement("305301");
CALL temp_ResourcesComplement("308569");
CALL temp_ResourcesComplement("111449");
CALL temp_ResourcesComplement("116627");
CALL temp_ResourcesComplement("107553");
CALL temp_ResourcesComplement("116763");
CALL temp_ResourcesComplement("117075");
CALL temp_ResourcesComplement("114963");
CALL temp_ResourcesComplement("46610");
CALL temp_ResourcesComplement("305309");
CALL temp_ResourcesComplement("112181");
CALL temp_ResourcesComplement("313349");
CALL temp_ResourcesComplement("242395");
CALL temp_ResourcesComplement("304889");
CALL temp_ResourcesComplement("310693");
CALL temp_ResourcesComplement("304881");
CALL temp_ResourcesComplement("244897");
CALL temp_ResourcesComplement("317249");
CALL temp_ResourcesComplement("307677");
CALL temp_ResourcesComplement("308677");
CALL temp_ResourcesComplement("307161");
CALL temp_ResourcesComplement("303669");
CALL temp_ResourcesComplement("308669");
CALL temp_ResourcesComplement("305757");
CALL temp_ResourcesComplement("308673");
CALL temp_ResourcesComplement("305753");
CALL temp_ResourcesComplement("314029");
CALL temp_ResourcesComplement("308253");
CALL temp_ResourcesComplement("313761");
CALL temp_ResourcesComplement("241455");
CALL temp_ResourcesComplement("241169");
CALL temp_ResourcesComplement("241107");
CALL temp_ResourcesComplement("243093");
CALL temp_ResourcesComplement("242893");
CALL temp_ResourcesComplement("241329");
CALL temp_ResourcesComplement("241461");
CALL temp_ResourcesComplement("10019");
CALL temp_ResourcesComplement("105301");
CALL temp_ResourcesComplement("48109");
CALL temp_ResourcesComplement("242157");
CALL temp_ResourcesComplement("244163");
CALL temp_ResourcesComplement("116861");
CALL temp_ResourcesComplement("10020");
CALL temp_ResourcesComplement("116521");
CALL temp_ResourcesComplement("46575");
CALL temp_ResourcesComplement("305313");
CALL temp_ResourcesComplement("51260");
CALL temp_ResourcesComplement("51267");
CALL temp_ResourcesComplement("48103");
CALL temp_ResourcesComplement("115113");
CALL temp_ResourcesComplement("246081");
CALL temp_ResourcesComplement("304033");
CALL temp_ResourcesComplement("304045");
CALL temp_ResourcesComplement("309509");
CALL temp_ResourcesComplement("245669");
CALL temp_ResourcesComplement("243693");
CALL temp_ResourcesComplement("241111");
CALL temp_ResourcesComplement("317413");
CALL temp_ResourcesComplement("313749");
CALL temp_ResourcesComplement("317741");
CALL temp_ResourcesComplement("118557");
CALL temp_ResourcesComplement("312421");
CALL temp_ResourcesComplement("242771");
CALL temp_ResourcesComplement("305809");
CALL temp_ResourcesComplement("309857");
CALL temp_ResourcesComplement("307645");
CALL temp_ResourcesComplement("305805");
CALL temp_ResourcesComplement("318357");
CALL temp_ResourcesComplement("314017");
CALL temp_ResourcesComplement("310729");
CALL temp_ResourcesComplement("317433");
CALL temp_ResourcesComplement("315081");
CALL temp_ResourcesComplement("315437");
CALL temp_ResourcesComplement("318649");
CALL temp_ResourcesComplement("242999");
CALL temp_ResourcesComplement("242603");
CALL temp_ResourcesComplement("241161");
CALL temp_ResourcesComplement("240841");
CALL temp_ResourcesComplement("244901");
CALL temp_ResourcesComplement("242139");
CALL temp_ResourcesComplement("243327");
CALL temp_ResourcesComplement("242599");
CALL temp_ResourcesComplement("244081");
CALL temp_ResourcesComplement("48111");
CALL temp_ResourcesComplement("242573");
CALL temp_ResourcesComplement("242159");
CALL temp_ResourcesComplement("308577");
CALL temp_ResourcesComplement("110453");
CALL temp_ResourcesComplement("115381");
CALL temp_ResourcesComplement("46237");
CALL temp_ResourcesComplement("116331");
CALL temp_ResourcesComplement("304037");
CALL temp_ResourcesComplement("115633");
CALL temp_ResourcesComplement("115635");
CALL temp_ResourcesComplement("111971");
CALL temp_ResourcesComplement("312437");
CALL temp_ResourcesComplement("305833");
CALL temp_ResourcesComplement("304885");
CALL temp_ResourcesComplement("244543");
CALL temp_ResourcesComplement("304041");
CALL temp_ResourcesComplement("241465");
CALL temp_ResourcesComplement("243845");
CALL temp_ResourcesComplement("317565");
CALL temp_ResourcesComplement("317033");
CALL temp_ResourcesComplement("305761");
CALL temp_ResourcesComplement("240993");
CALL temp_ResourcesComplement("317037");
CALL temp_ResourcesComplement("311873");
CALL temp_ResourcesComplement("243089");
CALL temp_ResourcesComplement("318065");
CALL temp_ResourcesComplement("240839");
CALL temp_ResourcesComplement("317261");
CALL temp_ResourcesComplement("317417");
CALL temp_ResourcesComplement("305817");
CALL temp_ResourcesComplement("317437");
CALL temp_ResourcesComplement("310717");
CALL temp_ResourcesComplement("241775");
CALL temp_ResourcesComplement("241777");
CALL temp_ResourcesComplement("242595");
CALL temp_ResourcesComplement("244415");
CALL temp_ResourcesComplement("241341");
CALL temp_ResourcesComplement("313661");
CALL temp_ResourcesComplement("241791");
CALL temp_ResourcesComplement("48114");
CALL temp_ResourcesComplement("308585");
CALL temp_ResourcesComplement("111665");
CALL temp_ResourcesComplement("117553");
CALL temp_ResourcesComplement("116333");
CALL temp_ResourcesComplement("46611");
CALL temp_ResourcesComplement("116191");
CALL temp_ResourcesComplement("117679");
CALL temp_ResourcesComplement("46068");
CALL temp_ResourcesComplement("46069");
CALL temp_ResourcesComplement("46067");
CALL temp_ResourcesComplement("46065");
CALL temp_ResourcesComplement("46063");
CALL temp_ResourcesComplement("312977");
CALL temp_ResourcesComplement("313353");
CALL temp_ResourcesComplement("311073");
CALL temp_ResourcesComplement("245641");
CALL temp_ResourcesComplement("311917");
CALL temp_ResourcesComplement("244247");
CALL temp_ResourcesComplement("304485");
CALL temp_ResourcesComplement("311941");
CALL temp_ResourcesComplement("243461");
CALL temp_ResourcesComplement("317041");
CALL temp_ResourcesComplement("318297");
CALL temp_ResourcesComplement("309009");
CALL temp_ResourcesComplement("317025");
CALL temp_ResourcesComplement("310689");
CALL temp_ResourcesComplement("310697");
CALL temp_ResourcesComplement("118319");
CALL temp_ResourcesComplement("303661");
CALL temp_ResourcesComplement("305769");
CALL temp_ResourcesComplement("305821");
CALL temp_ResourcesComplement("307689");
CALL temp_ResourcesComplement("318349");
CALL temp_ResourcesComplement("317245");
CALL temp_ResourcesComplement("305813");
CALL temp_ResourcesComplement("315093");
CALL temp_ResourcesComplement("243325");
CALL temp_ResourcesComplement("242045");
CALL temp_ResourcesComplement("242047");
CALL temp_ResourcesComplement("242043");
CALL temp_ResourcesComplement("241165");
CALL temp_ResourcesComplement("312945");
CALL temp_ResourcesComplement("241331");
CALL temp_ResourcesComplement("243583");
CALL temp_ResourcesComplement("242569");
CALL temp_ResourcesComplement("242629");
CALL temp_ResourcesComplement("118441");
CALL temp_ResourcesComplement("115065");
CALL temp_ResourcesComplement("116515");
CALL temp_ResourcesComplement("110023");
CALL temp_ResourcesComplement("114965");
CALL temp_ResourcesComplement("116761");
CALL temp_ResourcesComplement("242891");
CALL temp_ResourcesComplement("46137");
CALL temp_ResourcesComplement("115297");
CALL temp_ResourcesComplement("115621");
CALL temp_ResourcesComplement("240549");
CALL temp_ResourcesComplement("118547");
CALL temp_ResourcesComplement("313005");
CALL temp_ResourcesComplement("313365");
CALL temp_ResourcesComplement("310713");
CALL temp_ResourcesComplement("246085");
CALL temp_ResourcesComplement("245341");
CALL temp_ResourcesComplement("244905");
CALL temp_ResourcesComplement("244413");
CALL temp_ResourcesComplement("244409");
CALL temp_ResourcesComplement("314261");
CALL temp_ResourcesComplement("311085");
CALL temp_ResourcesComplement("317821");
CALL temp_ResourcesComplement("311925");
CALL temp_ResourcesComplement("311881");
CALL temp_ResourcesComplement("311885");
CALL temp_ResourcesComplement("309025");
CALL temp_ResourcesComplement("318301");
CALL temp_ResourcesComplement("311893");
CALL temp_ResourcesComplement("243319");
CALL temp_ResourcesComplement("312425");
CALL temp_ResourcesComplement("317441");
CALL temp_ResourcesComplement("314037");
CALL temp_ResourcesComplement("317777");
CALL temp_ResourcesComplement("243095");
CALL temp_ResourcesComplement("241695");
CALL temp_ResourcesComplement("318653");
CALL temp_ResourcesComplement("241101");
CALL temp_ResourcesComplement("241325");
CALL temp_ResourcesComplement("243847");
CALL temp_ResourcesComplement("241339");
CALL temp_ResourcesComplement("241345");
CALL temp_ResourcesComplement("242673");
CALL temp_ResourcesComplement("243253");
CALL temp_ResourcesComplement("318085");
CALL temp_ResourcesComplement("242161");
CALL temp_ResourcesComplement("114407");
CALL temp_ResourcesComplement("115235");
CALL temp_ResourcesComplement("240747");
CALL temp_ResourcesComplement("115879");
CALL temp_ResourcesComplement("118427");
CALL temp_ResourcesComplement("118063");
CALL temp_ResourcesComplement("116201");
CALL temp_ResourcesComplement("318241");
CALL temp_ResourcesComplement("117081");
CALL temp_ResourcesComplement("116961");
CALL temp_ResourcesComplement("240539");
CALL temp_ResourcesComplement("116373");
CALL temp_ResourcesComplement("117233");
CALL temp_ResourcesComplement("118191");
CALL temp_ResourcesComplement("313757");
CALL temp_ResourcesComplement("311089");
CALL temp_ResourcesComplement("311577");
CALL temp_ResourcesComplement("304533");
CALL temp_ResourcesComplement("245649");
CALL temp_ResourcesComplement("304401");
CALL temp_ResourcesComplement("244407");
CALL temp_ResourcesComplement("243581");
CALL temp_ResourcesComplement("243839");
CALL temp_ResourcesComplement("314641");
CALL temp_ResourcesComplement("317557");
CALL temp_ResourcesComplement("243463");
CALL temp_ResourcesComplement("312605");
CALL temp_ResourcesComplement("243579");
CALL temp_ResourcesComplement("243465");
CALL temp_ResourcesComplement("318521");
CALL temp_ResourcesComplement("307673");
CALL temp_ResourcesComplement("243099");
CALL temp_ResourcesComplement("118439");
CALL temp_ResourcesComplement("309849");
CALL temp_ResourcesComplement("242993");
CALL temp_ResourcesComplement("317421");
CALL temp_ResourcesComplement("241773");
CALL temp_ResourcesComplement("242041");
CALL temp_ResourcesComplement("244103");
CALL temp_ResourcesComplement("242901");
CALL temp_ResourcesComplement("242585");
CALL temp_ResourcesComplement("241109");
CALL temp_ResourcesComplement("240981");
CALL temp_ResourcesComplement("241177");
CALL temp_ResourcesComplement("241337");
CALL temp_ResourcesComplement("240987");
CALL temp_ResourcesComplement("240663");
CALL temp_ResourcesComplement("308597");
CALL temp_ResourcesComplement("243767");
CALL temp_ResourcesComplement("243765");
CALL temp_ResourcesComplement("308581");
CALL temp_ResourcesComplement("242773");
CALL temp_ResourcesComplement("115743");
CALL temp_ResourcesComplement("116511");
CALL temp_ResourcesComplement("240679");
CALL temp_ResourcesComplement("117115");
CALL temp_ResourcesComplement("116631");
CALL temp_ResourcesComplement("118313");
CALL temp_ResourcesComplement("113413");
CALL temp_ResourcesComplement("114305");
CALL temp_ResourcesComplement("116031");
CALL temp_ResourcesComplement("243605");
CALL temp_ResourcesComplement("114277");
CALL temp_ResourcesComplement("117235");
CALL temp_ResourcesComplement("112401");
CALL temp_ResourcesComplement("311877");
CALL temp_ResourcesComplement("244893");
CALL temp_ResourcesComplement("304893");
CALL temp_ResourcesComplement("243841");
CALL temp_ResourcesComplement("305841");
CALL temp_ResourcesComplement("243577");
CALL temp_ResourcesComplement("241113");
CALL temp_ResourcesComplement("314649");
CALL temp_ResourcesComplement("311889");
CALL temp_ResourcesComplement("241173");
CALL temp_ResourcesComplement("241351");
CALL temp_ResourcesComplement("241349");
CALL temp_ResourcesComplement("305781");
CALL temp_ResourcesComplement("318121");
CALL temp_ResourcesComplement("244909");
CALL temp_ResourcesComplement("242897");
CALL temp_ResourcesComplement("242765");
CALL temp_ResourcesComplement("242589");
CALL temp_ResourcesComplement("244259");
CALL temp_ResourcesComplement("241105");
CALL temp_ResourcesComplement("305785");
CALL temp_ResourcesComplement("244085");
CALL temp_ResourcesComplement("303345");
CALL temp_ResourcesComplement("242987");
CALL temp_ResourcesComplement("242795");
CALL temp_ResourcesComplement("114469");
CALL temp_ResourcesComplement("240669");
CALL temp_ResourcesComplement("240675");
CALL temp_ResourcesComplement("117111");
CALL temp_ResourcesComplement("118071");
CALL temp_ResourcesComplement("117541");
CALL temp_ResourcesComplement("116199");
CALL temp_ResourcesComplement("116925");
CALL temp_ResourcesComplement("115613");
CALL temp_ResourcesComplement("117799");
CALL temp_ResourcesComplement("108001");
CALL temp_ResourcesComplement("307229");
CALL temp_ResourcesComplement("118545");
CALL temp_ResourcesComplement("117669");
CALL temp_ResourcesComplement("118189");
CALL temp_ResourcesComplement("305825");
CALL temp_ResourcesComplement("244889");
CALL temp_ResourcesComplement("244253");
CALL temp_ResourcesComplement("243945");
CALL temp_ResourcesComplement("317253");
CALL temp_ResourcesComplement("315077");
CALL temp_ResourcesComplement("243005");
CALL temp_ResourcesComplement("118315");
CALL temp_ResourcesComplement("307681");
CALL temp_ResourcesComplement("308589");
CALL temp_ResourcesComplement("242989");
CALL temp_ResourcesComplement("240655");
CALL temp_ResourcesComplement("115611");
CALL temp_ResourcesComplement("240665");
CALL temp_ResourcesComplement("116753");
CALL temp_ResourcesComplement("116751");
CALL temp_ResourcesComplement("115887");
CALL temp_ResourcesComplement("117659");
CALL temp_ResourcesComplement("117661");
CALL temp_ResourcesComplement("116323");
CALL temp_ResourcesComplement("116307");
CALL temp_ResourcesComplement("115383");
CALL temp_ResourcesComplement("118065");
CALL temp_ResourcesComplement("114853");
CALL temp_ResourcesComplement("114837");
CALL temp_ResourcesComplement("116635");
CALL temp_ResourcesComplement("118309");
CALL temp_ResourcesComplement("117429");
CALL temp_ResourcesComplement("116927");
CALL temp_ResourcesComplement("116939");
CALL temp_ResourcesComplement("117243");
CALL temp_ResourcesComplement("116393");
CALL temp_ResourcesComplement("117229");
CALL temp_ResourcesComplement("117237");
CALL temp_ResourcesComplement("245333");
CALL temp_ResourcesComplement("244549");
CALL temp_ResourcesComplement("304901");
CALL temp_ResourcesComplement("244105");
CALL temp_ResourcesComplement("241333");
CALL temp_ResourcesComplement("317429");
CALL temp_ResourcesComplement("243575");
CALL temp_ResourcesComplement("317241");
CALL temp_ResourcesComplement("308181");
CALL temp_ResourcesComplement("317729");
CALL temp_ResourcesComplement("243323");
CALL temp_ResourcesComplement("241463");
CALL temp_ResourcesComplement("317805");
CALL temp_ResourcesComplement("112333");
CALL temp_ResourcesComplement("116327");
CALL temp_ResourcesComplement("108705");
CALL temp_ResourcesComplement("105135");
CALL temp_ResourcesComplement("304025");
CALL temp_ResourcesComplement("114409");
CALL temp_ResourcesComplement("113543");
CALL temp_ResourcesComplement("116643");
CALL temp_ResourcesComplement("311165");
CALL temp_ResourcesComplement("46240");
CALL temp_ResourcesComplement("115629");
CALL temp_ResourcesComplement("113761");
CALL temp_ResourcesComplement("118553");
CALL temp_ResourcesComplement("242145");
CALL temp_ResourcesComplement("313001");
CALL temp_ResourcesComplement("317949");
CALL temp_ResourcesComplement("308185");
CALL temp_ResourcesComplement("243711");
CALL temp_ResourcesComplement("316513");
CALL temp_ResourcesComplement("240843");
CALL temp_ResourcesComplement("240835");
CALL temp_ResourcesComplement("242591");
CALL temp_ResourcesComplement("314621");
CALL temp_ResourcesComplement("113455");
CALL temp_ResourcesComplement("308593");
CALL temp_ResourcesComplement("118437");
CALL temp_ResourcesComplement("46268");
CALL temp_ResourcesComplement("115097");
CALL temp_ResourcesComplement("112305");
CALL temp_ResourcesComplement("46225");
CALL temp_ResourcesComplement("116929");
CALL temp_ResourcesComplement("115631");
CALL temp_ResourcesComplement("303269");
CALL temp_ResourcesComplement("115133");
CALL temp_ResourcesComplement("115109");
CALL temp_ResourcesComplement("244111");
CALL temp_ResourcesComplement("107487");
CALL temp_ResourcesComplement("118559");
CALL temp_ResourcesComplement("316505");
CALL temp_ResourcesComplement("242593");
CALL temp_ResourcesComplement("244101");
CALL temp_ResourcesComplement("116755");
CALL temp_ResourcesComplement("46271");
CALL temp_ResourcesComplement("114953");
CALL temp_ResourcesComplement("114957");
CALL temp_ResourcesComplement("113201");
CALL temp_ResourcesComplement("243729");
CALL temp_ResourcesComplement("240667");
CALL temp_ResourcesComplement("117665");
CALL temp_ResourcesComplement("114855");
CALL temp_ResourcesComplement("114857");
CALL temp_ResourcesComplement("115753");
CALL temp_ResourcesComplement("117935");
CALL temp_ResourcesComplement("114413");
CALL temp_ResourcesComplement("117545");
CALL temp_ResourcesComplement("115257");
CALL temp_ResourcesComplement("116193");
CALL temp_ResourcesComplement("110437");
CALL temp_ResourcesComplement("117073");
CALL temp_ResourcesComplement("114717");
CALL temp_ResourcesComplement("112109");
CALL temp_ResourcesComplement("46018");
CALL temp_ResourcesComplement("115099");
CALL temp_ResourcesComplement("243469");
CALL temp_ResourcesComplement("112001");
CALL temp_ResourcesComplement("46214");
CALL temp_ResourcesComplement("114991");
CALL temp_ResourcesComplement("114961");
CALL temp_ResourcesComplement("115881");
CALL temp_ResourcesComplement("115897");
CALL temp_ResourcesComplement("115405");
CALL temp_ResourcesComplement("115889");
CALL temp_ResourcesComplement("117549");
CALL temp_ResourcesComplement("118059");
CALL temp_ResourcesComplement("114411");
CALL temp_ResourcesComplement("115255");
CALL temp_ResourcesComplement("117435");
CALL temp_ResourcesComplement("46238");
CALL temp_ResourcesComplement("117071");
CALL temp_ResourcesComplement("115625");
CALL temp_ResourcesComplement("116935");
CALL temp_ResourcesComplement("116513");
CALL temp_ResourcesComplement("116519");
CALL temp_ResourcesComplement("116033");
CALL temp_ResourcesComplement("10587");
CALL temp_ResourcesComplement("117685");
CALL temp_ResourcesComplement("117671");
CALL temp_ResourcesComplement("117255");
CALL temp_ResourcesComplement("117251");
CALL temp_ResourcesComplement("116397");
CALL temp_ResourcesComplement("48239");
CALL temp_ResourcesComplement("309521");
CALL temp_ResourcesComplement("243949");
CALL temp_ResourcesComplement("114289");
CALL temp_ResourcesComplement("114985");
CALL temp_ResourcesComplement("240661");
CALL temp_ResourcesComplement("240671");
CALL temp_ResourcesComplement("116759");
CALL temp_ResourcesComplement("115401");
CALL temp_ResourcesComplement("117663");
CALL temp_ResourcesComplement("116321");
CALL temp_ResourcesComplement("117103");
CALL temp_ResourcesComplement("115397");
CALL temp_ResourcesComplement("115387");
CALL temp_ResourcesComplement("115389");
CALL temp_ResourcesComplement("117107");
CALL temp_ResourcesComplement("118067");
CALL temp_ResourcesComplement("114863");
CALL temp_ResourcesComplement("111345");
CALL temp_ResourcesComplement("117941");
CALL temp_ResourcesComplement("114417");
CALL temp_ResourcesComplement("110091");
CALL temp_ResourcesComplement("114479");
CALL temp_ResourcesComplement("114483");
CALL temp_ResourcesComplement("118311");
CALL temp_ResourcesComplement("110815");
CALL temp_ResourcesComplement("117431");
CALL temp_ResourcesComplement("46243");
CALL temp_ResourcesComplement("117083");
CALL temp_ResourcesComplement("109393");
CALL temp_ResourcesComplement("112559");
CALL temp_ResourcesComplement("112557");
CALL temp_ResourcesComplement("110361");
CALL temp_ResourcesComplement("115627");
CALL temp_ResourcesComplement("116517");
CALL temp_ResourcesComplement("10022");
CALL temp_ResourcesComplement("115135");
CALL temp_ResourcesComplement("116029");
CALL temp_ResourcesComplement("111595");
CALL temp_ResourcesComplement("112413");
CALL temp_ResourcesComplement("240545");
CALL temp_ResourcesComplement("114699");
CALL temp_ResourcesComplement("117683");
CALL temp_ResourcesComplement("117667");
CALL temp_ResourcesComplement("116339");
CALL temp_ResourcesComplement("115067");
CALL temp_ResourcesComplement("117245");
CALL temp_ResourcesComplement("117247");
CALL temp_ResourcesComplement("117271");
CALL temp_ResourcesComplement("118179");
CALL temp_ResourcesComplement("111521");
CALL temp_ResourcesComplement("244109");
CALL temp_ResourcesComplement("318525");
CALL temp_ResourcesComplement("318073");
CALL temp_ResourcesComplement("39079");
CALL temp_ResourcesComplement("112331");
CALL temp_ResourcesComplement("112315");
CALL temp_ResourcesComplement("112313");
CALL temp_ResourcesComplement("112797");
CALL temp_ResourcesComplement("112311");
CALL temp_ResourcesComplement("112303");
CALL temp_ResourcesComplement("112307");
CALL temp_ResourcesComplement("111043");
CALL temp_ResourcesComplement("318501");
CALL temp_ResourcesComplement("39004");
CALL temp_ResourcesComplement("114595");
CALL temp_ResourcesComplement("114579");
CALL temp_ResourcesComplement("51134");
CALL temp_ResourcesComplement("51138");
CALL temp_ResourcesComplement("114555");
CALL temp_ResourcesComplement("51155");
CALL temp_ResourcesComplement("116335");
CALL temp_ResourcesComplement("118429");
CALL temp_ResourcesComplement("118431");
CALL temp_ResourcesComplement("114073");
CALL temp_ResourcesComplement("115393");
CALL temp_ResourcesComplement("46143");
CALL temp_ResourcesComplement("46139");
CALL temp_ResourcesComplement("46126");
CALL temp_ResourcesComplement("46595");
CALL temp_ResourcesComplement("46593");
CALL temp_ResourcesComplement("110965");
CALL temp_ResourcesComplement("51100");
CALL temp_ResourcesComplement("108639");
CALL temp_ResourcesComplement("110579");
CALL temp_ResourcesComplement("114845");
CALL temp_ResourcesComplement("109021");
CALL temp_ResourcesComplement("39128");
CALL temp_ResourcesComplement("114471");
CALL temp_ResourcesComplement("112295");
CALL temp_ResourcesComplement("51254");
CALL temp_ResourcesComplement("10359");
CALL temp_ResourcesComplement("51268");
CALL temp_ResourcesComplement("51275");
CALL temp_ResourcesComplement("51277");
CALL temp_ResourcesComplement("114443");
CALL temp_ResourcesComplement("116205");
CALL temp_ResourcesComplement("51283");
CALL temp_ResourcesComplement("51284");
CALL temp_ResourcesComplement("106409");
CALL temp_ResourcesComplement("46272");
CALL temp_ResourcesComplement("46267");
CALL temp_ResourcesComplement("110809");
CALL temp_ResourcesComplement("46251");
CALL temp_ResourcesComplement("46241");
CALL temp_ResourcesComplement("46231");
CALL temp_ResourcesComplement("46229");
CALL temp_ResourcesComplement("46227");
CALL temp_ResourcesComplement("46217");
CALL temp_ResourcesComplement("46218");
CALL temp_ResourcesComplement("110425");
CALL temp_ResourcesComplement("110411");
CALL temp_ResourcesComplement("110403");
CALL temp_ResourcesComplement("110407");
CALL temp_ResourcesComplement("116195");
CALL temp_ResourcesComplement("108149");
CALL temp_ResourcesComplement("111301");
CALL temp_ResourcesComplement("110451");
CALL temp_ResourcesComplement("110439");
CALL temp_ResourcesComplement("117077");
CALL temp_ResourcesComplement("117079");
CALL temp_ResourcesComplement("112567");
CALL temp_ResourcesComplement("10419");
CALL temp_ResourcesComplement("112573");
CALL temp_ResourcesComplement("112571");
CALL temp_ResourcesComplement("111227");
CALL temp_ResourcesComplement("112555");
CALL temp_ResourcesComplement("110377");
CALL temp_ResourcesComplement("112553");
CALL temp_ResourcesComplement("111217");
CALL temp_ResourcesComplement("112543");
CALL temp_ResourcesComplement("112541");
CALL temp_ResourcesComplement("109379");
CALL temp_ResourcesComplement("111203");
CALL temp_ResourcesComplement("111209");
CALL temp_ResourcesComplement("116973");
CALL temp_ResourcesComplement("113463");
CALL temp_ResourcesComplement("112107");
CALL temp_ResourcesComplement("112105");
CALL temp_ResourcesComplement("112103");
CALL temp_ResourcesComplement("112101");
CALL temp_ResourcesComplement("116941");
CALL temp_ResourcesComplement("115609");
CALL temp_ResourcesComplement("112579");
CALL temp_ResourcesComplement("112575");
CALL temp_ResourcesComplement("112581");
CALL temp_ResourcesComplement("114337");
CALL temp_ResourcesComplement("51395");
CALL temp_ResourcesComplement("115237");
CALL temp_ResourcesComplement("112189");
CALL temp_ResourcesComplement("112187");
CALL temp_ResourcesComplement("48102");
CALL temp_ResourcesComplement("114287");
CALL temp_ResourcesComplement("51318");
CALL temp_ResourcesComplement("51320");
CALL temp_ResourcesComplement("51321");
CALL temp_ResourcesComplement("51323");
CALL temp_ResourcesComplement("109767");
CALL temp_ResourcesComplement("51339");
CALL temp_ResourcesComplement("116035");
CALL temp_ResourcesComplement("111625");
CALL temp_ResourcesComplement("107107");
CALL temp_ResourcesComplement("114707");
CALL temp_ResourcesComplement("48138");
CALL temp_ResourcesComplement("48133");
CALL temp_ResourcesComplement("111643");
CALL temp_ResourcesComplement("48117");
CALL temp_ResourcesComplement("113763");
CALL temp_ResourcesComplement("112893");
CALL temp_ResourcesComplement("115515");
CALL temp_ResourcesComplement("112053");
CALL temp_ResourcesComplement("112051");
CALL temp_ResourcesComplement("46558");
CALL temp_ResourcesComplement("46555");
CALL temp_ResourcesComplement("10594");
CALL temp_ResourcesComplement("46524");
CALL temp_ResourcesComplement("10579");
CALL temp_ResourcesComplement("112087");
CALL temp_ResourcesComplement("10551");
CALL temp_ResourcesComplement("48218");
CALL temp_ResourcesComplement("111907");
CALL temp_ResourcesComplement("111905");
CALL temp_ResourcesComplement("111901");
CALL temp_ResourcesComplement("51412");
CALL temp_ResourcesComplement("46021");
CALL temp_ResourcesComplement("114171");
CALL temp_ResourcesComplement("10031");
CALL temp_ResourcesComplement("110653");
CALL temp_ResourcesComplement("318481");
CALL temp_ResourcesComplement("48242");
CALL temp_ResourcesComplement("46052");

DROP PROCEDURE  IF EXISTS  temp_ResourcesComplement;