PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table rsbl_orders_list (id int primary key, det_id int, order_status varchar(2) ); insert into rsbl_orders_list values (1148526,12052517,'NW'); insert into rsbl_orders_list values (1148594,12052517,'WP'); insert into rsbl_orders_list values (1148397,12053064,'NW'); insert into rsbl_orders_list values (1148741,12053064,'WP'); insert into rsbl_orders_list values (1148462,12054629,'WP'); insert into rsbl_orders_list values (1148669,12054629,'NW'); insert into rsbl_orders_list values (1148519,12055541,'WP'); insert into rsbl_orders_list values (1148575,12055541,'NW'); insert into rsbl_orders_list values (1148391,12055737,'CP'); insert into rsbl_orders_list values (1148823,12055737,'NW'); insert into rsbl_orders_list values (1148548,12069635,'WP'); insert into rsbl_orders_list values (1148603,12069635,'NW'); insert into rsbl_orders_list values (1148447,12245289,'WP'); insert into rsbl_orders_list values (1148650,12245289,'NW'); insert into rsbl_orders_list values (1148497,12245648,'NW'); insert into rsbl_orders_list values (1148702,12245648,'WP'); insert into rsbl_orders_list values (1148392,12247299,'WP'); insert into rsbl_orders_list values (1148743,12247299,'NW'); insert into rsbl_orders_list values (1148389,12248107,'WP'); insert into rsbl_orders_list values (1148755,12248107,'NW'); insert into rsbl_orders_list values (1148486,12248267,'NW'); insert into rsbl_orders_list values (1148621,12248267,'CP'); insert into rsbl_orders_list values (1148351,12254549,'WP'); insert into rsbl_orders_list values (1148813,12254549,'NW'); insert into rsbl_orders_list values (1148538,12260918,'WP'); insert into rsbl_orders_list values (1148622,12260918,'NW'); insert into rsbl_orders_list values (1148353,12264457,'NW'); insert into rsbl_orders_list values (1148816,12264457,'WP'); insert into rsbl_orders_list values (1148481,12264493,'NW'); insert into rsbl_orders_list values (1148694,12264493,'WP'); insert into rsbl_orders_list values (1148457,12275501,'CP'); insert into rsbl_orders_list values (1148591,12275501,'NW'); insert into rsbl_orders_list values (1148844,12284530,'WP'); insert into rsbl_orders_list values (1148889,12284530,'NW'); insert into rsbl_orders_list values (1148470,12285815,'WP'); insert into rsbl_orders_list values (1148697,12285815,'NW'); insert into rsbl_orders_list values (1148826,12295811,'WP'); insert into rsbl_orders_list values (1148876,12295811,'NW'); insert into rsbl_orders_list values (1148821,12301178,'NW'); insert into rsbl_orders_list values (1148884,12301178,'WP'); insert into rsbl_orders_list values (1148395,12305341,'NW'); insert into rsbl_orders_list values (1148742,12305341,'WP'); insert into rsbl_orders_list values (1148800,12320601,'WP'); insert into rsbl_orders_list values (1148869,12320601,'NW'); insert into rsbl_orders_list values (1148500,12326776,'WP'); insert into rsbl_orders_list values (1148704,12326776,'NW'); insert into rsbl_orders_list values (1148524,12329416,'NW'); insert into rsbl_orders_list values (1148601,12329416,'WP'); insert into rsbl_orders_list values (1148555,12329417,'NW'); insert into rsbl_orders_list values (1148645,12329417,'WP'); insert into rsbl_orders_list values (1148383,12329418,'WP'); insert into rsbl_orders_list values (1148725,12329418,'NW'); insert into rsbl_orders_list values (1148465,12331048,'NW'); insert into rsbl_orders_list values (1148700,12331048,'WP'); insert into rsbl_orders_list values (1148562,12331093,'NW'); insert into rsbl_orders_list values (1148631,12331093,'WP'); insert into rsbl_orders_list values (1148476,12331123,'NW'); insert into rsbl_orders_list values (1148691,12331123,'WP'); insert into rsbl_orders_list values (1148460,12331156,'WP'); insert into rsbl_orders_list values (1148668,12331156,'NW'); insert into rsbl_orders_list values (1148407,12331188,'NW'); insert into rsbl_orders_list values (1148766,12331188,'WP'); insert into rsbl_orders_list values (1148341,12331208,'WP'); insert into rsbl_orders_list values (1148793,12331208,'NW'); insert into rsbl_orders_list values (1148815,12331241,'WP'); insert into rsbl_orders_list values (1148888,12331241,'NW'); insert into rsbl_orders_list values (1148563,12331275,'WP'); insert into rsbl_orders_list values (1148633,12331275,'NW'); insert into rsbl_orders_list values (1148454,12331301,'WP'); insert into rsbl_orders_list values (1148681,12331301,'NW'); insert into rsbl_orders_list values (1148795,12331332,'WP'); insert into rsbl_orders_list values (1148870,12331332,'NW'); insert into rsbl_orders_list values (1148378,12331367,'NW'); insert into rsbl_orders_list values (1148729,12331367,'WP'); insert into rsbl_orders_list values (1148531,12331403,'NW'); insert into rsbl_orders_list values (1148587,12331403,'WP'); insert into rsbl_orders_list values (1148403,12331433,'WP'); insert into rsbl_orders_list values (1148737,12331433,'NW'); insert into rsbl_orders_list values (1148438,12331465,'NW'); insert into rsbl_orders_list values (1148658,12331465,'WP'); insert into rsbl_orders_list values (1148516,12331516,'WP'); insert into rsbl_orders_list values (1148570,12331516,'NW'); insert into rsbl_orders_list values (1148398,12331551,'WP'); insert into rsbl_orders_list values (1148744,12331551,'NW'); insert into rsbl_orders_list values (1148426,12331579,'NW'); insert into rsbl_orders_list values (1148777,12331579,'WP'); insert into rsbl_orders_list values (1148372,12331622,'WP'); insert into rsbl_orders_list values (1148734,12331622,'NW'); insert into rsbl_orders_list values (1148547,12331677,'WP'); insert into rsbl_orders_list values (1148612,12331677,'NW'); insert into rsbl_orders_list values (1148545,12331706,'NW'); insert into rsbl_orders_list values (1148617,12331706,'WP'); insert into rsbl_orders_list values (1148452,12331763,'NW'); insert into rsbl_orders_list values (1148679,12331763,'WP'); insert into rsbl_orders_list values (1148828,12331790,'WP'); insert into rsbl_orders_list values (1148875,12331790,'NW'); insert into rsbl_orders_list values (1148478,12331825,'NW'); insert into rsbl_orders_list values (1148690,12331825,'WP'); insert into rsbl_orders_list values (1148834,12338216,'NW'); insert into rsbl_orders_list values (1148892,12338216,'WP'); insert into rsbl_orders_list values (1148359,12341042,'NW'); insert into rsbl_orders_list values (1148866,12341042,'WP'); insert into rsbl_orders_list values (1148514,12347420,'WP'); insert into rsbl_orders_list values (1148578,12347420,'NW'); insert into rsbl_orders_list values (1148352,12350501,'WP'); insert into rsbl_orders_list values (1148814,12350501,'NW'); insert into rsbl_orders_list values (1148342,12351663,'NW'); insert into rsbl_orders_list values (1148827,12351663,'WP'); insert into rsbl_orders_list values (1148367,12351664,'WP'); insert into rsbl_orders_list values (1148851,12351664,'NW'); insert into rsbl_orders_list values (1148331,12351665,'NW'); insert into rsbl_orders_list values (1148808,12351665,'WP'); insert into rsbl_orders_list values (1148364,12354323,'NW'); insert into rsbl_orders_list values (1148857,12354323,'WP'); insert into rsbl_orders_list values (1148819,12356053,'WP'); insert into rsbl_orders_list values (1148883,12356053,'NW'); insert into rsbl_orders_list values (1148423,12356178,'WP'); insert into rsbl_orders_list values (1148788,12356178,'NW'); insert into rsbl_orders_list values (1148425,12356201,'CP'); insert into rsbl_orders_list values (1148855,12356201,'NW'); insert into rsbl_orders_list values (1148451,12356217,'WP'); insert into rsbl_orders_list values (1148678,12356217,'NW'); insert into rsbl_orders_list values (1148436,12362548,'WP'); insert into rsbl_orders_list values (1148656,12362548,'NW'); insert into rsbl_orders_list values (1148546,12364367,'WP'); insert into rsbl_orders_list values (1148618,12364367,'NW'); insert into rsbl_orders_list values (1148346,12367230,'NW'); insert into rsbl_orders_list values (1148825,12367230,'WP'); insert into rsbl_orders_list values (1148386,12371848,'NW'); insert into rsbl_orders_list values (1148806,12371848,'CP'); insert into rsbl_orders_list values (1148415,12371866,'CP'); insert into rsbl_orders_list values (1148845,12371866,'NW'); insert into rsbl_orders_list values (1148512,12374911,'WP'); insert into rsbl_orders_list values (1148577,12374911,'NW'); insert into rsbl_orders_list values (1148853,12376310,'NW'); insert into rsbl_orders_list values (1148898,12376310,'WP'); insert into rsbl_orders_list values (1148355,12376700,'WP'); insert into rsbl_orders_list values (1148842,12376700,'NW'); insert into rsbl_orders_list values (1148404,12378573,'WP'); insert into rsbl_orders_list values (1148770,12378573,'NW'); insert into rsbl_orders_list values (1148371,12378575,'WP'); insert into rsbl_orders_list values (1148733,12378575,'NW'); insert into rsbl_orders_list values (1148513,12384471,'WP'); insert into rsbl_orders_list values (1148579,12384471,'NW'); insert into rsbl_orders_list values (1148362,12385097,'WP'); insert into rsbl_orders_list values (1148862,12385097,'NW'); insert into rsbl_orders_list values (1148420,12385104,'WP'); insert into rsbl_orders_list values (1148786,12385104,'NW'); insert into rsbl_orders_list values (1148560,12385227,'NW'); insert into rsbl_orders_list values (1148630,12385227,'WP'); insert into rsbl_orders_list values (1150967,12390264,'WP'); insert into rsbl_orders_list values (1150968,12390264,'NW'); insert into rsbl_orders_list values (1148836,12392020,'NW'); insert into rsbl_orders_list values (1148895,12392020,'WP'); insert into rsbl_orders_list values (1148422,12392232,'NW'); insert into rsbl_orders_list values (1148787,12392232,'WP'); insert into rsbl_orders_list values (1148566,12393452,'WP'); insert into rsbl_orders_list values (1148636,12393452,'NW'); insert into rsbl_orders_list values (1148445,12394660,'WP'); insert into rsbl_orders_list values (1148648,12394660,'NW'); insert into rsbl_orders_list values (1148450,12394932,'WP'); insert into rsbl_orders_list values (1148677,12394932,'NW'); insert into rsbl_orders_list values (1148480,12396889,'NW'); insert into rsbl_orders_list values (1148693,12396889,'WP'); insert into rsbl_orders_list values (1148329,12398168,'NW'); insert into rsbl_orders_list values (1148803,12398168,'WP'); insert into rsbl_orders_list values (1148459,12399673,'NW'); insert into rsbl_orders_list values (1148666,12399673,'WP'); insert into rsbl_orders_list values (1148564,12400779,'WP'); insert into rsbl_orders_list values (1148637,12400779,'NW'); insert into rsbl_orders_list values (1148489,12401875,'NW'); insert into rsbl_orders_list values (1148628,12401875,'CP'); insert into rsbl_orders_list values (1148428,12403388,'WP'); insert into rsbl_orders_list values (1148779,12403388,'NW'); insert into rsbl_orders_list values (1148525,12403970,'WP'); insert into rsbl_orders_list values (1148602,12403970,'NW'); insert into rsbl_orders_list values (1148536,12404006,'NW'); insert into rsbl_orders_list values (1148620,12404006,'WP'); insert into rsbl_orders_list values (1148505,12404307,'NW'); insert into rsbl_orders_list values (1148584,12404307,'WP'); insert into rsbl_orders_list values (1148543,12406427,'WP'); insert into rsbl_orders_list values (1148615,12406427,'NW'); insert into rsbl_orders_list values (1148345,12406849,'WP'); insert into rsbl_orders_list values (1148824,12406849,'NW'); insert into rsbl_orders_list values (1148433,12410250,'NW'); insert into rsbl_orders_list values (1148773,12410250,'WP'); insert into rsbl_orders_list values (1148416,12411183,'WP'); insert into rsbl_orders_list values (1148759,12411183,'NW'); insert into rsbl_orders_list values (1227051,12430366,'CP'); insert into rsbl_orders_list values (1227102,12430366,'WZ'); insert into rsbl_orders_list values (1227046,12430367,'WZ'); insert into rsbl_orders_list values (1227111,12430367,'CP'); insert into rsbl_orders_list values (1159910,12452922,'CP'); insert into rsbl_orders_list values (1162646,12452922,'CP'); insert into rsbl_orders_list values (1154784,12486838,'CP'); insert into rsbl_orders_list values (1158722,12486838,'CP'); insert into rsbl_orders_list values (1176963,12586879,'CP'); insert into rsbl_orders_list values (1180804,12586879,'CP'); insert into rsbl_orders_list values (1227070,12606946,'WZ'); insert into rsbl_orders_list values (1227115,12606946,'CP'); insert into rsbl_orders_list values (1227015,12606947,'WZ'); insert into rsbl_orders_list values (1227085,12606947,'CP'); insert into rsbl_orders_list values (1151524,12607799,'WZ'); insert into rsbl_orders_list values (1151539,12607799,'WZ'); insert into rsbl_orders_list values (1151564,12607800,'WZ'); insert into rsbl_orders_list values (1151605,12607800,'WZ'); insert into rsbl_orders_list values (1227029,12619587,'WZ'); insert into rsbl_orders_list values (1227092,12619587,'CP'); insert into rsbl_orders_list values (1227047,12619588,'WZ'); insert into rsbl_orders_list values (1227110,12619588,'CP'); insert into rsbl_orders_list values (1227012,12621421,'CP'); insert into rsbl_orders_list values (1227084,12621421,'WZ'); insert into rsbl_orders_list values (1227068,12621422,'CP'); insert into rsbl_orders_list values (1227126,12621422,'WZ'); insert into rsbl_orders_list values (1227031,12623411,'CP'); insert into rsbl_orders_list values (1227097,12623411,'WZ'); insert into rsbl_orders_list values (1227058,12623412,'CP'); insert into rsbl_orders_list values (1227108,12623412,'WZ'); insert into rsbl_orders_list values (1231970,12630862,'CP'); insert into rsbl_orders_list values (1232129,12630862,'CP'); insert into rsbl_orders_list values (1232362,12630863,'CP'); insert into rsbl_orders_list values (1232525,12630863,'CP'); insert into rsbl_orders_list values (1232209,12630871,'CP'); insert into rsbl_orders_list values (1232351,12630871,'CP'); insert into rsbl_orders_list values (1232535,12630872,'CP'); insert into rsbl_orders_list values (1232678,12630872,'CP'); insert into rsbl_orders_list values (1207346,12654522,'WP'); insert into rsbl_orders_list values (1209039,12654522,'WP'); insert into rsbl_orders_list values (1207674,12688331,'WP'); insert into rsbl_orders_list values (1209457,12688331,'WP'); insert into rsbl_orders_list values (1211909,12790384,'WP'); insert into rsbl_orders_list values (1213707,12790384,'WP'); insert into rsbl_orders_list values (1221730,12802149,'WP'); insert into rsbl_orders_list values (1222310,12802149,'WP'); insert into rsbl_orders_list values (1272728,12850908,'CP'); insert into rsbl_orders_list values (1272736,12850908,'WZ'); insert into rsbl_orders_list values (1272730,12850909,'CP'); insert into rsbl_orders_list values (1272734,12850909,'WZ'); insert into rsbl_orders_list values (1272741,12850910,'WZ'); insert into rsbl_orders_list values (1272753,12850910,'CP'); insert into rsbl_orders_list values (1272747,12850919,'CP'); insert into rsbl_orders_list values (1272763,12850919,'WZ'); insert into rsbl_orders_list values (1272750,12850920,'CP'); insert into rsbl_orders_list values (1272761,12850920,'WZ'); insert into rsbl_orders_list values (1241854,12895158,'WP'); insert into rsbl_orders_list values (1243644,12895158,'WP'); insert into rsbl_orders_list values (1239334,12916475,'WP'); insert into rsbl_orders_list values (1272640,12916475,'WP'); insert into rsbl_orders_list values (1250134,12927916,'WP'); insert into rsbl_orders_list values (1254376,12927916,'WP'); insert into rsbl_orders_list values (1246474,13026803,'WP'); insert into rsbl_orders_list values (1249491,13026803,'WP'); insert into rsbl_orders_list values (1246880,13032927,'WP'); insert into rsbl_orders_list values (1248656,13032927,'WP'); insert into rsbl_orders_list values (1353776,13064041,'CP'); insert into rsbl_orders_list values (1373195,13064041,'CP'); insert into rsbl_orders_list values (1371597,13064042,'CP'); insert into rsbl_orders_list values (1371905,13064042,'CP'); insert into rsbl_orders_list values (1276579,13108884,'WP'); insert into rsbl_orders_list values (1277533,13108884,'WP'); insert into rsbl_orders_list values (1315233,13129850,'WP'); insert into rsbl_orders_list values (1316213,13129850,'WP'); insert into rsbl_orders_list values (1297814,13141298,'WP'); insert into rsbl_orders_list values (1299809,13141298,'WP'); insert into rsbl_orders_list values (1307136,13240115,'WP'); insert into rsbl_orders_list values (1311588,13240115,'WP'); insert into rsbl_orders_list values (1292489,13259195,'WP'); insert into rsbl_orders_list values (1294452,13259195,'WP'); insert into rsbl_orders_list values (1351827,13325834,'WP'); insert into rsbl_orders_list values (1352083,13325834,'WP'); insert into rsbl_orders_list values (1343436,13346661,'WP'); insert into rsbl_orders_list values (1345078,13346661,'WP'); insert into rsbl_orders_list values (1339285,13357448,'WP'); insert into rsbl_orders_list values (1340862,13357448,'WP'); insert into rsbl_orders_list values (1319048,13385766,'WP'); insert into rsbl_orders_list values (1351259,13385766,'WP'); insert into rsbl_orders_list values (1426291,13410252,'WP'); insert into rsbl_orders_list values (1426309,13410252,'CP'); insert into rsbl_orders_list values (1334877,13455272,'WP'); insert into rsbl_orders_list values (1336562,13455272,'WP'); insert into rsbl_orders_list values (1371692,13476231,'WP'); insert into rsbl_orders_list values (1372017,13476231,'WP'); insert into rsbl_orders_list values (1407086,13665199,'WP'); insert into rsbl_orders_list values (1409255,13665199,'WP'); insert into rsbl_orders_list values (1420683,13667787,'WP'); insert into rsbl_orders_list values (1421093,13667787,'WP'); insert into rsbl_orders_list values (1417920,13688070,'WP'); insert into rsbl_orders_list values (1418322,13688070,'WP'); insert into rsbl_orders_list values (1417163,13724812,'WP'); insert into rsbl_orders_list values (1418992,13724812,'WP'); insert into rsbl_orders_list values (1393621,13729355,'WP'); insert into rsbl_orders_list values (1425676,13729355,'WP'); insert into rsbl_orders_list values (1453004,13907339,'WP'); insert into rsbl_orders_list values (1458357,13907339,'WP'); insert into rsbl_orders_list values (1461872,13910020,'WP'); insert into rsbl_orders_list values (1462610,13910020,'WP'); insert into rsbl_orders_list values (1461754,13928252,'WP'); insert into rsbl_orders_list values (1462564,13928252,'WP'); insert into rsbl_orders_list values (1434275,13944574,'WP'); insert into rsbl_orders_list values (1436924,13944574,'WP'); insert into rsbl_orders_list values (1466959,13968549,'WP'); insert into rsbl_orders_list values (1469292,13968549,'WP'); insert into rsbl_orders_list values (1594638,14112615,'WZ'); insert into rsbl_orders_list values (1594641,14112615,'CP'); insert into rsbl_orders_list values (1594637,14112616,'CP'); insert into rsbl_orders_list values (1594640,14112616,'WZ'); insert into rsbl_orders_list values (1520774,14187018,'WP'); insert into rsbl_orders_list values (1524738,14187018,'WP'); insert into rsbl_orders_list values (1493389,14189720,'WP'); insert into rsbl_orders_list values (1493773,14189720,'WP'); insert into rsbl_orders_list values (1514688,14226472,'WP'); insert into rsbl_orders_list values (1518665,14226472,'WP'); insert into rsbl_orders_list values (1529880,14232756,'WP'); insert into rsbl_orders_list values (1531067,14232756,'WP'); insert into rsbl_orders_list values (1514237,14259475,'WP'); insert into rsbl_orders_list values (1518156,14259475,'WP'); insert into rsbl_orders_list values (1594633,14297777,'WP'); insert into rsbl_orders_list values (1594636,14297777,'CP'); insert into rsbl_orders_list values (1594776,14318832,'WZ'); insert into rsbl_orders_list values (1595621,14318832,'CP'); insert into rsbl_orders_list values (1596085,14318833,'WZ'); insert into rsbl_orders_list values (1596932,14318833,'CP'); insert into rsbl_orders_list values (1596033,14318834,'CP'); insert into rsbl_orders_list values (1596921,14318834,'WZ'); insert into rsbl_orders_list values (1596597,14318835,'WZ'); insert into rsbl_orders_list values (1597066,14318835,'CP'); insert into rsbl_orders_list values (1596039,14318836,'WZ'); insert into rsbl_orders_list values (1596919,14318836,'CP'); insert into rsbl_orders_list values (1594878,14319346,'WZ'); insert into rsbl_orders_list values (1595355,14319346,'CP'); insert into rsbl_orders_list values (1596647,14319675,'CP'); insert into rsbl_orders_list values (1597145,14319675,'WZ'); insert into rsbl_orders_list values (1596294,14319782,'CP'); insert into rsbl_orders_list values (1596841,14319782,'WZ'); insert into rsbl_orders_list values (1595196,14321510,'WZ'); insert into rsbl_orders_list values (1595672,14321510,'CP'); insert into rsbl_orders_list values (1596503,14333967,'CP'); insert into rsbl_orders_list values (1597291,14333967,'WZ'); insert into rsbl_orders_list values (1595291,14337023,'CP'); insert into rsbl_orders_list values (1595785,14337023,'WZ'); insert into rsbl_orders_list values (1553853,14470009,'WP'); insert into rsbl_orders_list values (1556560,14470009,'WP'); insert into rsbl_orders_list values (1563333,14472723,'EC'); insert into rsbl_orders_list values (1567202,14472723,'EC'); insert into rsbl_orders_list values (1591632,14516705,'EC'); insert into rsbl_orders_list values (1592824,14516705,'EC'); insert into rsbl_orders_list values (1554409,14529754,'WP'); insert into rsbl_orders_list values (1556292,14529754,'WP'); insert into rsbl_orders_list values (1553877,14545146,'WP'); insert into rsbl_orders_list values (1556530,14545146,'WP'); insert into rsbl_orders_list values (1670008,14826711,'EC'); insert into rsbl_orders_list values (1691230,14826711,'CP'); insert into rsbl_orders_list values (1757723,14896529,'CP'); insert into rsbl_orders_list values (1757786,14896529,'WZ'); insert into rsbl_orders_list values (1757820,14896530,'CP'); insert into rsbl_orders_list values (1757848,14896530,'WZ'); insert into rsbl_orders_list values (1757817,14907491,'WZ'); insert into rsbl_orders_list values (1757844,14907491,'CP'); insert into rsbl_orders_list values (1757836,14907492,'WZ'); insert into rsbl_orders_list values (1757878,14907492,'CP'); insert into rsbl_orders_list values (1706614,14985170,'EC'); insert into rsbl_orders_list values (1706704,14985170,'WP'); insert into rsbl_orders_list values (1708876,14993029,'EC'); insert into rsbl_orders_list values (1708892,14993029,'CP'); insert into rsbl_orders_list values (1708842,14993074,'EC'); insert into rsbl_orders_list values (1708893,14993074,'CP'); insert into rsbl_orders_list values (1706641,14999889,'EC'); insert into rsbl_orders_list values (1706700,14999889,'CP'); insert into rsbl_orders_list values (1708797,15008904,'CP'); insert into rsbl_orders_list values (1708944,15008904,'EC'); insert into rsbl_orders_list values (1708839,15008937,'EC'); insert into rsbl_orders_list values (1708898,15008937,'CP'); insert into rsbl_orders_list values (1706644,15019236,'EC'); insert into rsbl_orders_list values (1706710,15019236,'WP'); insert into rsbl_orders_list values (1706601,15032936,'WP'); insert into rsbl_orders_list values (1706695,15032936,'EC'); insert into rsbl_orders_list values (1708830,15044149,'CP'); insert into rsbl_orders_list values (1708930,15044149,'EC'); insert into rsbl_orders_list values (1708849,15044188,'EC'); insert into rsbl_orders_list values (1708902,15044188,'CP'); insert into rsbl_orders_list values (1708834,15045895,'EC'); insert into rsbl_orders_list values (1708939,15045895,'CP'); insert into rsbl_orders_list values (1708802,15045934,'EC'); insert into rsbl_orders_list values (1708949,15045934,'CP'); insert into rsbl_orders_list values (1708809,15048214,'WP'); insert into rsbl_orders_list values (1708909,15048214,'EC'); insert into rsbl_orders_list values (1708860,15048262,'CP'); insert into rsbl_orders_list values (1708916,15048262,'EC'); insert into rsbl_orders_list values (1757713,15064217,'CP'); insert into rsbl_orders_list values (1757896,15064217,'EC'); insert into rsbl_orders_list values (1757711,15115164,'WZ'); insert into rsbl_orders_list values (1757755,15115164,'CP'); insert into rsbl_orders_list values (1757806,15115165,'WZ'); insert into rsbl_orders_list values (1757867,15115165,'CP'); insert into rsbl_orders_list values (1865071,15116081,'CP'); insert into rsbl_orders_list values (1865074,15116081,'WZ'); insert into rsbl_orders_list values (1865075,15116082,'CP'); insert into rsbl_orders_list values (1865078,15116082,'WZ'); insert into rsbl_orders_list values (1865069,15116083,'CP'); insert into rsbl_orders_list values (1865073,15116083,'WZ'); insert into rsbl_orders_list values (1865070,15116084,'CP'); insert into rsbl_orders_list values (1865072,15116084,'WZ'); insert into rsbl_orders_list values (1865076,15116085,'CP'); insert into rsbl_orders_list values (1865080,15116085,'WZ'); insert into rsbl_orders_list values (1757706,15135452,'WZ'); insert into rsbl_orders_list values (1757753,15135452,'CP'); insert into rsbl_orders_list values (1757741,15135453,'CP'); insert into rsbl_orders_list values (1757777,15135453,'WZ'); insert into rsbl_orders_list values (1757766,15255413,'EC'); insert into rsbl_orders_list values (1757833,15255413,'CP'); insert into rsbl_orders_list values (1757779,15257816,'WP'); insert into rsbl_orders_list values (1757852,15257816,'EC'); insert into rsbl_orders_list values (1757730,15264789,'EC'); insert into rsbl_orders_list values (1757804,15264789,'WP'); insert into rsbl_orders_list values (1757791,15303566,'EC'); insert into rsbl_orders_list values (1757858,15303566,'WP'); insert into rsbl_orders_list values (1757710,15304786,'EC'); insert into rsbl_orders_list values (1757895,15304786,'CP'); insert into rsbl_orders_list values (1757787,15304787,'CP'); insert into rsbl_orders_list values (1757815,15304787,'EC'); insert into rsbl_orders_list values (1757763,15306197,'WP'); insert into rsbl_orders_list values (1757889,15306197,'EC'); insert into rsbl_orders_list values (1757784,15311087,'WP'); insert into rsbl_orders_list values (1757862,15311087,'EC'); insert into rsbl_orders_list values (1757743,15333914,'EC'); insert into rsbl_orders_list values (1757864,15333914,'CP'); insert into rsbl_orders_list values (2210714,17155436,'WZ'); insert into rsbl_orders_list values (2210722,17155436,'CP'); insert into rsbl_orders_list values (2210696,17155437,'CP'); insert into rsbl_orders_list values (2210704,17155437,'WZ'); insert into rsbl_orders_list values (2264630,17582073,'CP'); insert into rsbl_orders_list values (2264689,17582073,'WZ'); insert into rsbl_orders_list values (2264734,17582074,'CP'); insert into rsbl_orders_list values (2264818,17582074,'WZ'); insert into rsbl_orders_list values (2264598,17582079,'CP'); insert into rsbl_orders_list values (2264673,17582079,'WZ'); insert into rsbl_orders_list values (2264764,17582080,'WZ'); insert into rsbl_orders_list values (2264834,17582080,'CP'); insert into rsbl_orders_list values (2264750,17589280,'WZ'); insert into rsbl_orders_list values (2264844,17589280,'CP'); insert into rsbl_orders_list values (2264597,17589281,'WZ'); insert into rsbl_orders_list values (2264674,17589281,'CP'); insert into rsbl_orders_list values (2264653,17589282,'WZ'); insert into rsbl_orders_list values (2264707,17589282,'CP'); insert into rsbl_orders_list values (2264647,17589283,'CP'); insert into rsbl_orders_list values (2264719,17589283,'WZ'); insert into rsbl_orders_list values (2264596,17589284,'CP'); insert into rsbl_orders_list values (2264672,17589284,'WZ'); insert into rsbl_orders_list values (2264760,17589285,'CP'); insert into rsbl_orders_list values (2264830,17589285,'WZ'); insert into rsbl_orders_list values (269,17812979,'CP'); insert into rsbl_orders_list values (2359934,17812979,'CP'); insert into rsbl_orders_list values (270,17812980,'CP'); insert into rsbl_orders_list values (2359828,17812980,'CP'); insert into rsbl_orders_list values (40,17993035,'CP'); insert into rsbl_orders_list values (2359970,17993035,'CP'); insert into rsbl_orders_list values (41,17993036,'CP'); insert into rsbl_orders_list values (2359889,17993036,'CP'); insert into rsbl_orders_list values (97,17993808,'CP'); insert into rsbl_orders_list values (2359949,17993808,'CP'); insert into rsbl_orders_list values (98,17993809,'CP'); insert into rsbl_orders_list values (2359909,17993809,'CP'); insert into rsbl_orders_list values (27,17993888,'CP'); insert into rsbl_orders_list values (2359867,17993888,'CP'); insert into rsbl_orders_list values (28,17993889,'CP'); insert into rsbl_orders_list values (2359968,17993889,'CP'); insert into rsbl_orders_list values (33,17994816,'CP'); insert into rsbl_orders_list values (2359856,17994816,'CP'); insert into rsbl_orders_list values (34,17994817,'CP'); insert into rsbl_orders_list values (2359881,17994817,'CP'); insert into rsbl_orders_list values (35,17994818,'CP'); insert into rsbl_orders_list values (2359865,17994818,'CP'); insert into rsbl_orders_list values (36,17994819,'CP'); insert into rsbl_orders_list values (2359879,17994819,'CP'); insert into rsbl_orders_list values (53,18008306,'WZ'); insert into rsbl_orders_list values (2360132,18008306,'WZ'); insert into rsbl_orders_list values (72,18008451,'CP'); insert into rsbl_orders_list values (2359939,18008451,'CP'); insert into rsbl_orders_list values (73,18008452,'CP'); insert into rsbl_orders_list values (2360009,18008452,'CP'); insert into rsbl_orders_list values (74,18008453,'CP'); insert into rsbl_orders_list values (2359886,18008453,'CP'); insert into rsbl_orders_list values (100,18008508,'CP'); insert into rsbl_orders_list values (2359829,18008508,'CP'); insert into rsbl_orders_list values (59,18008552,'CP'); insert into rsbl_orders_list values (2359930,18008552,'CP'); insert into rsbl_orders_list values (375,18008567,'CP'); insert into rsbl_orders_list values (2359932,18008567,'CP'); insert into rsbl_orders_list values (327,18008575,'CP'); insert into rsbl_orders_list values (2359981,18008575,'CP'); insert into rsbl_orders_list values (122,18008577,'CP'); insert into rsbl_orders_list values (2359864,18008577,'CP'); insert into rsbl_orders_list values (191,18008635,'CP'); insert into rsbl_orders_list values (2359842,18008635,'CP'); insert into rsbl_orders_list values (283,18008682,'CP'); insert into rsbl_orders_list values (2359882,18008682,'CP'); insert into rsbl_orders_list values (173,18008683,'CP'); insert into rsbl_orders_list values (2359871,18008683,'CP'); insert into rsbl_orders_list values (282,18008685,'CP'); insert into rsbl_orders_list values (2359820,18008685,'CP'); insert into rsbl_orders_list values (124,18008689,'CP'); insert into rsbl_orders_list values (2359954,18008689,'CP'); insert into rsbl_orders_list values (271,18008691,'CP'); insert into rsbl_orders_list values (2359895,18008691,'CP'); insert into rsbl_orders_list values (21,18008693,'CP'); insert into rsbl_orders_list values (2359847,18008693,'CP'); insert into rsbl_orders_list values (163,18008694,'CP'); insert into rsbl_orders_list values (2359861,18008694,'CP'); insert into rsbl_orders_list values (301,18008700,'CP'); insert into rsbl_orders_list values (2359875,18008700,'CP'); insert into rsbl_orders_list values (201,18008701,'CP'); insert into rsbl_orders_list values (2359948,18008701,'CP'); insert into rsbl_orders_list values (113,18008703,'CP'); insert into rsbl_orders_list values (2359898,18008703,'CP'); insert into rsbl_orders_list values (321,18008704,'CP'); insert into rsbl_orders_list values (2359998,18008704,'CP'); insert into rsbl_orders_list values (137,18008705,'CP'); insert into rsbl_orders_list values (2359990,18008705,'CP'); insert into rsbl_orders_list values (188,18008706,'CP'); insert into rsbl_orders_list values (2359830,18008706,'CP'); insert into rsbl_orders_list values (274,18008707,'CP'); insert into rsbl_orders_list values (2359941,18008707,'CP'); insert into rsbl_orders_list values (293,18008708,'CP'); insert into rsbl_orders_list values (2359883,18008708,'CP'); insert into rsbl_orders_list values (140,18008709,'CP'); insert into rsbl_orders_list values (2359931,18008709,'CP'); insert into rsbl_orders_list values (178,18008710,'CP'); insert into rsbl_orders_list values (2359835,18008710,'CP'); insert into rsbl_orders_list values (247,18008711,'CP'); insert into rsbl_orders_list values (2359821,18008711,'CP'); insert into rsbl_orders_list values (352,18008712,'CP'); insert into rsbl_orders_list values (2359973,18008712,'CP'); insert into rsbl_orders_list values (116,18008713,'CP'); insert into rsbl_orders_list values (2359874,18008713,'CP'); insert into rsbl_orders_list values (222,18008715,'CP'); insert into rsbl_orders_list values (2359988,18008715,'CP'); insert into rsbl_orders_list values (310,18008716,'CP'); insert into rsbl_orders_list values (2359926,18008716,'CP'); insert into rsbl_orders_list values (45,18008718,'CP'); insert into rsbl_orders_list values (2359923,18008718,'CP'); insert into rsbl_orders_list values (214,18008720,'CP'); insert into rsbl_orders_list values (2359942,18008720,'CP'); insert into rsbl_orders_list values (281,18008721,'CP'); insert into rsbl_orders_list values (2359866,18008721,'CP'); insert into rsbl_orders_list values (194,18008722,'CP'); insert into rsbl_orders_list values (2360006,18008722,'CP'); insert into rsbl_orders_list values (312,18008727,'CP'); insert into rsbl_orders_list values (2359888,18008727,'CP'); insert into rsbl_orders_list values (316,18008731,'CP'); insert into rsbl_orders_list values (2359897,18008731,'CP'); insert into rsbl_orders_list values (117,18008734,'CP'); insert into rsbl_orders_list values (2359910,18008734,'CP'); insert into rsbl_orders_list values (204,18008737,'CP'); insert into rsbl_orders_list values (2359852,18008737,'CP'); insert into rsbl_orders_list values (351,18008740,'CP'); insert into rsbl_orders_list values (2359989,18008740,'CP'); insert into rsbl_orders_list values (355,18008746,'CP'); insert into rsbl_orders_list values (2359824,18008746,'CP'); insert into rsbl_orders_list values (345,18008751,'CP'); insert into rsbl_orders_list values (2360001,18008751,'CP'); insert into rsbl_orders_list values (218,18008756,'CP'); insert into rsbl_orders_list values (2359978,18008756,'CP'); insert into rsbl_orders_list values (213,18008763,'CP'); insert into rsbl_orders_list values (2359982,18008763,'CP'); insert into rsbl_orders_list values (347,18008767,'CP'); insert into rsbl_orders_list values (2359836,18008767,'CP'); insert into rsbl_orders_list values (138,18008770,'CP'); insert into rsbl_orders_list values (2359860,18008770,'CP'); insert into rsbl_orders_list values (42,18008781,'CP'); insert into rsbl_orders_list values (2359986,18008781,'CP'); insert into rsbl_orders_list values (9,18008789,'CP'); insert into rsbl_orders_list values (2359967,18008789,'CP'); insert into rsbl_orders_list values (329,18008790,'CP'); insert into rsbl_orders_list values (2359855,18008790,'CP'); insert into rsbl_orders_list values (256,18008795,'CP'); insert into rsbl_orders_list values (2360008,18008795,'CP'); insert into rsbl_orders_list values (335,18008796,'CP'); insert into rsbl_orders_list values (2359957,18008796,'CP'); insert into rsbl_orders_list values (128,18008798,'CP'); insert into rsbl_orders_list values (2359983,18008798,'CP'); insert into rsbl_orders_list values (302,18008801,'CP'); insert into rsbl_orders_list values (2359922,18008801,'CP'); insert into rsbl_orders_list values (109,18008803,'CP'); insert into rsbl_orders_list values (2359846,18008803,'CP'); insert into rsbl_orders_list values (95,18008806,'CP'); insert into rsbl_orders_list values (2359827,18008806,'CP'); insert into rsbl_orders_list values (120,18008810,'CP'); insert into rsbl_orders_list values (2359929,18008810,'CP'); insert into rsbl_orders_list values (337,18008811,'CP'); insert into rsbl_orders_list values (2359966,18008811,'CP'); insert into rsbl_orders_list values (308,18008816,'CP'); insert into rsbl_orders_list values (2359884,18008816,'CP'); insert into rsbl_orders_list values (251,18008827,'CP'); insert into rsbl_orders_list values (2360007,18008827,'CP'); insert into rsbl_orders_list values (90,18008830,'CP'); insert into rsbl_orders_list values (2359907,18008830,'CP'); insert into rsbl_orders_list values (208,18008835,'CP'); insert into rsbl_orders_list values (2359908,18008835,'CP'); insert into rsbl_orders_list values (207,18008845,'CP'); insert into rsbl_orders_list values (2359977,18008845,'CP'); insert into rsbl_orders_list values (159,18008850,'CP'); insert into rsbl_orders_list values (2359845,18008850,'CP'); insert into rsbl_orders_list values (286,18008855,'CP'); insert into rsbl_orders_list values (2359918,18008855,'CP'); insert into rsbl_orders_list values (324,18008858,'CP'); insert into rsbl_orders_list values (2359995,18008858,'CP'); insert into rsbl_orders_list values (26,18008859,'CP'); insert into rsbl_orders_list values (2359992,18008859,'CP'); insert into rsbl_orders_list values (154,18008860,'CP'); insert into rsbl_orders_list values (2359904,18008860,'CP'); insert into rsbl_orders_list values (164,18008862,'CP'); insert into rsbl_orders_list values (2359854,18008862,'CP'); insert into rsbl_orders_list values (262,18008866,'CP'); insert into rsbl_orders_list values (2359945,18008866,'CP'); insert into rsbl_orders_list values (179,18008868,'CP'); insert into rsbl_orders_list values (2359850,18008868,'CP'); insert into rsbl_orders_list values (162,18008875,'CP'); insert into rsbl_orders_list values (2359887,18008875,'CP'); insert into rsbl_orders_list values (326,18008885,'CP'); insert into rsbl_orders_list values (2359955,18008885,'CP'); insert into rsbl_orders_list values (322,18008888,'CP'); insert into rsbl_orders_list values (2359902,18008888,'CP'); insert into rsbl_orders_list values (227,18008892,'CP'); insert into rsbl_orders_list values (2359935,18008892,'CP'); insert into rsbl_orders_list values (346,18008895,'CP'); insert into rsbl_orders_list values (2359831,18008895,'CP'); insert into rsbl_orders_list values (51,18008898,'CP'); insert into rsbl_orders_list values (2359839,18008898,'CP'); insert into rsbl_orders_list values (264,18008902,'CP'); insert into rsbl_orders_list values (2359868,18008902,'CP'); insert into rsbl_orders_list values (206,18008903,'CP'); insert into rsbl_orders_list values (2359919,18008903,'CP'); insert into rsbl_orders_list values (22,18008912,'CP'); insert into rsbl_orders_list values (2359849,18008912,'CP'); insert into rsbl_orders_list values (339,18008923,'CP'); insert into rsbl_orders_list values (2359971,18008923,'CP'); insert into rsbl_orders_list values (187,18008929,'CP'); insert into rsbl_orders_list values (2359870,18008929,'CP'); insert into rsbl_orders_list values (141,18008937,'CP'); insert into rsbl_orders_list values (2359972,18008937,'CP'); insert into rsbl_orders_list values (209,18008945,'CP'); insert into rsbl_orders_list values (2359900,18008945,'CP'); insert into rsbl_orders_list values (89,18008951,'CP'); insert into rsbl_orders_list values (2359901,18008951,'CP'); insert into rsbl_orders_list values (315,18008958,'CP'); insert into rsbl_orders_list values (2359946,18008958,'CP'); insert into rsbl_orders_list values (344,18008962,'CP'); insert into rsbl_orders_list values (2359838,18008962,'CP'); insert into rsbl_orders_list values (156,18008967,'CP'); insert into rsbl_orders_list values (2359906,18008967,'CP'); insert into rsbl_orders_list values (229,18008991,'CP'); insert into rsbl_orders_list values (2359920,18008991,'CP'); insert into rsbl_orders_list values (68,18008993,'CP'); insert into rsbl_orders_list values (2359863,18008993,'CP'); insert into rsbl_orders_list values (232,18008995,'CP'); insert into rsbl_orders_list values (2359893,18008995,'CP'); insert into rsbl_orders_list values (237,18008997,'CP'); insert into rsbl_orders_list values (2359851,18008997,'CP'); insert into rsbl_orders_list values (403,18008999,'CP'); insert into rsbl_orders_list values (2359837,18008999,'CP'); insert into rsbl_orders_list values (404,18009000,'CP'); insert into rsbl_orders_list values (2359962,18009000,'CP'); insert into rsbl_orders_list values (405,18009001,'CP'); insert into rsbl_orders_list values (2359979,18009001,'CP'); insert into rsbl_orders_list values (406,18009002,'CP'); insert into rsbl_orders_list values (2359912,18009002,'CP'); insert into rsbl_orders_list values (407,18009003,'CP'); insert into rsbl_orders_list values (2359987,18009003,'CP'); insert into rsbl_orders_list values (408,18009004,'CP'); insert into rsbl_orders_list values (2359996,18009004,'CP'); insert into rsbl_orders_list values (409,18009005,'CP'); insert into rsbl_orders_list values (2359958,18009005,'CP'); insert into rsbl_orders_list values (410,18009006,'CP'); insert into rsbl_orders_list values (2359914,18009006,'CP'); insert into rsbl_orders_list values (411,18009007,'CP'); insert into rsbl_orders_list values (2359991,18009007,'CP'); insert into rsbl_orders_list values (412,18009008,'CP'); insert into rsbl_orders_list values (2359891,18009008,'CP'); insert into rsbl_orders_list values (413,18009009,'CP'); insert into rsbl_orders_list values (2359916,18009009,'CP'); insert into rsbl_orders_list values (414,18009010,'CP'); insert into rsbl_orders_list values (2359880,18009010,'CP'); insert into rsbl_orders_list values (415,18009011,'CP'); insert into rsbl_orders_list values (2359947,18009011,'CP'); insert into rsbl_orders_list values (416,18009012,'CP'); insert into rsbl_orders_list values (2359843,18009012,'CP'); insert into rsbl_orders_list values (417,18009013,'CP'); insert into rsbl_orders_list values (2360000,18009013,'CP'); insert into rsbl_orders_list values (418,18009014,'CP'); insert into rsbl_orders_list values (2359876,18009014,'CP'); insert into rsbl_orders_list values (419,18009015,'CP'); insert into rsbl_orders_list values (2359903,18009015,'CP'); insert into rsbl_orders_list values (420,18009016,'CP'); insert into rsbl_orders_list values (2359960,18009016,'CP'); insert into rsbl_orders_list values (421,18009017,'CP'); insert into rsbl_orders_list values (2359925,18009017,'CP'); insert into rsbl_orders_list values (422,18009018,'CP'); insert into rsbl_orders_list values (2359959,18009018,'CP'); insert into rsbl_orders_list values (423,18009019,'CP'); insert into rsbl_orders_list values (2359952,18009019,'CP'); insert into rsbl_orders_list values (424,18009020,'CP'); insert into rsbl_orders_list values (2359933,18009020,'CP'); insert into rsbl_orders_list values (425,18009021,'CP'); insert into rsbl_orders_list values (2359936,18009021,'CP'); insert into rsbl_orders_list values (426,18009022,'CP'); insert into rsbl_orders_list values (2359825,18009022,'CP'); insert into rsbl_orders_list values (427,18009023,'CP'); insert into rsbl_orders_list values (2359892,18009023,'CP'); insert into rsbl_orders_list values (428,18009024,'CP'); insert into rsbl_orders_list values (2359969,18009024,'CP'); insert into rsbl_orders_list values (429,18009025,'CP'); insert into rsbl_orders_list values (2359878,18009025,'CP'); insert into rsbl_orders_list values (430,18009026,'CP'); insert into rsbl_orders_list values (2360010,18009026,'CP'); insert into rsbl_orders_list values (431,18009027,'CP'); insert into rsbl_orders_list values (2359911,18009027,'CP'); insert into rsbl_orders_list values (432,18009028,'CP'); insert into rsbl_orders_list values (2359943,18009028,'CP'); insert into rsbl_orders_list values (433,18009029,'CP'); insert into rsbl_orders_list values (2359823,18009029,'CP'); insert into rsbl_orders_list values (434,18009030,'CP'); insert into rsbl_orders_list values (2359944,18009030,'CP'); insert into rsbl_orders_list values (435,18009031,'CP'); insert into rsbl_orders_list values (2359965,18009031,'CP'); insert into rsbl_orders_list values (436,18009032,'CP'); insert into rsbl_orders_list values (2359832,18009032,'CP'); insert into rsbl_orders_list values (437,18009033,'CP'); insert into rsbl_orders_list values (2359841,18009033,'CP'); insert into rsbl_orders_list values (438,18009034,'CP'); insert into rsbl_orders_list values (2359985,18009034,'CP'); insert into rsbl_orders_list values (439,18009035,'CP'); insert into rsbl_orders_list values (2359913,18009035,'CP'); insert into rsbl_orders_list values (440,18009036,'CP'); insert into rsbl_orders_list values (2359890,18009036,'CP'); insert into rsbl_orders_list values (441,18009037,'CP'); insert into rsbl_orders_list values (2359819,18009037,'CP'); insert into rsbl_orders_list values (442,18009038,'CP'); insert into rsbl_orders_list values (2359840,18009038,'CP'); insert into rsbl_orders_list values (443,18009039,'CP'); insert into rsbl_orders_list values (2359937,18009039,'CP'); insert into rsbl_orders_list values (444,18009040,'CP'); insert into rsbl_orders_list values (2360004,18009040,'CP'); insert into rsbl_orders_list values (445,18009041,'CP'); insert into rsbl_orders_list values (2359844,18009041,'CP'); insert into rsbl_orders_list values (446,18009042,'CP'); insert into rsbl_orders_list values (2359938,18009042,'CP'); insert into rsbl_orders_list values (447,18009043,'CP'); insert into rsbl_orders_list values (2359872,18009043,'CP'); insert into rsbl_orders_list values (448,18009044,'CP'); insert into rsbl_orders_list values (2359940,18009044,'CP'); insert into rsbl_orders_list values (449,18009045,'CP'); insert into rsbl_orders_list values (2359848,18009045,'CP'); insert into rsbl_orders_list values (450,18009046,'CP'); insert into rsbl_orders_list values (2360003,18009046,'CP'); insert into rsbl_orders_list values (451,18009047,'CP'); insert into rsbl_orders_list values (2359984,18009047,'CP'); insert into rsbl_orders_list values (452,18009048,'CP'); insert into rsbl_orders_list values (2359927,18009048,'CP'); insert into rsbl_orders_list values (453,18009049,'CP'); insert into rsbl_orders_list values (2359877,18009049,'CP'); insert into rsbl_orders_list values (454,18009050,'CP'); insert into rsbl_orders_list values (2359869,18009050,'CP'); insert into rsbl_orders_list values (455,18009051,'CP'); insert into rsbl_orders_list values (2359857,18009051,'CP'); insert into rsbl_orders_list values (456,18009052,'CP'); insert into rsbl_orders_list values (2359885,18009052,'CP'); insert into rsbl_orders_list values (457,18009053,'CP'); insert into rsbl_orders_list values (2360005,18009053,'CP'); insert into rsbl_orders_list values (458,18009054,'CP'); insert into rsbl_orders_list values (2359980,18009054,'CP'); insert into rsbl_orders_list values (459,18009055,'CP'); insert into rsbl_orders_list values (2359974,18009055,'CP'); insert into rsbl_orders_list values (460,18009056,'CP'); insert into rsbl_orders_list values (2359924,18009056,'CP'); insert into rsbl_orders_list values (461,18009057,'CP'); insert into rsbl_orders_list values (2359826,18009057,'CP'); insert into rsbl_orders_list values (462,18009058,'CP'); insert into rsbl_orders_list values (2359950,18009058,'CP'); insert into rsbl_orders_list values (239,18009059,'CP'); insert into rsbl_orders_list values (2359858,18009059,'CP'); insert into rsbl_orders_list values (463,18009061,'CP'); insert into rsbl_orders_list values (2359915,18009061,'CP'); insert into rsbl_orders_list values (464,18009062,'CP'); insert into rsbl_orders_list values (2359822,18009062,'CP'); insert into rsbl_orders_list values (465,18009063,'CP'); insert into rsbl_orders_list values (2359994,18009063,'CP'); insert into rsbl_orders_list values (242,18009064,'CP'); insert into rsbl_orders_list values (2359961,18009064,'CP'); insert into rsbl_orders_list values (243,18009066,'CP'); insert into rsbl_orders_list values (2359975,18009066,'CP'); insert into rsbl_orders_list values (244,18009068,'CP'); insert into rsbl_orders_list values (2359853,18009068,'CP'); insert into rsbl_orders_list values (166,18009070,'CP'); insert into rsbl_orders_list values (2359899,18009070,'CP'); insert into rsbl_orders_list values (10,18009072,'CP'); insert into rsbl_orders_list values (2359956,18009072,'CP'); insert into rsbl_orders_list values (233,18009084,'CP'); insert into rsbl_orders_list values (2359951,18009084,'CP'); insert into rsbl_orders_list values (230,18009127,'CP'); insert into rsbl_orders_list values (2359921,18009127,'CP'); insert into rsbl_orders_list values (114,18009129,'CP'); insert into rsbl_orders_list values (2359997,18009129,'CP'); insert into rsbl_orders_list values (236,18009131,'CP'); insert into rsbl_orders_list values (2359834,18009131,'CP'); insert into rsbl_orders_list values (234,18009133,'CP'); insert into rsbl_orders_list values (2359905,18009133,'CP'); insert into rsbl_orders_list values (235,18009135,'CP'); insert into rsbl_orders_list values (2360002,18009135,'CP'); insert into rsbl_orders_list values (111,18009137,'CP'); insert into rsbl_orders_list values (2359953,18009137,'CP'); insert into rsbl_orders_list values (241,18009139,'CP'); insert into rsbl_orders_list values (2359894,18009139,'CP'); insert into rsbl_orders_list values (43,18009141,'CP'); insert into rsbl_orders_list values (2360078,18009141,'CP'); insert into rsbl_orders_list values (245,18009143,'CP'); insert into rsbl_orders_list values (2359999,18009143,'CP'); insert into rsbl_orders_list values (252,18009145,'CP'); insert into rsbl_orders_list values (2359964,18009145,'CP'); insert into rsbl_orders_list values (197,18009147,'CP'); insert into rsbl_orders_list values (2359873,18009147,'CP'); insert into rsbl_orders_list values (219,18009149,'CP'); insert into rsbl_orders_list values (2359993,18009149,'CP'); insert into rsbl_orders_list values (402,18009208,'CP'); insert into rsbl_orders_list values (2359963,18009208,'CP'); insert into rsbl_orders_list values (46,18009245,'CP'); insert into rsbl_orders_list values (2359896,18009245,'CP'); insert into rsbl_orders_list values (47,18009246,'CP'); insert into rsbl_orders_list values (2359917,18009246,'CP'); insert into rsbl_orders_list values (48,18009247,'CP'); insert into rsbl_orders_list values (2359859,18009247,'CP'); insert into rsbl_orders_list values (106,18009270,'CP'); insert into rsbl_orders_list values (2359833,18009270,'CP'); insert into rsbl_orders_list values (107,18009271,'CP'); insert into rsbl_orders_list values (2359862,18009271,'CP'); insert into rsbl_orders_list values (220,18009298,'WZ'); insert into rsbl_orders_list values (2359976,18009298,'WZ'); insert into rsbl_orders_list values (221,18009299,'WZ'); insert into rsbl_orders_list values (2359928,18009299,'WZ'); insert into rsbl_orders_list values (3,18009335,'WP'); insert into rsbl_orders_list values (2360104,18009335,'WP'); insert into rsbl_orders_list values (7,18009336,'WP'); insert into rsbl_orders_list values (2360137,18009336,'WP'); insert into rsbl_orders_list values (384,18009355,'WP'); insert into rsbl_orders_list values (2360040,18009355,'WP'); insert into rsbl_orders_list values (399,18009405,'WP'); insert into rsbl_orders_list values (2360032,18009405,'WP'); insert into rsbl_orders_list values (467,18009412,'WP'); insert into rsbl_orders_list values (2360058,18009412,'WP'); insert into rsbl_orders_list values (377,18009434,'WP'); insert into rsbl_orders_list values (2360048,18009434,'WP'); insert into rsbl_orders_list values (202,18009542,'CP'); insert into rsbl_orders_list values (2360116,18009542,'CP'); insert into rsbl_orders_list values (157,18009544,'CP'); insert into rsbl_orders_list values (2360089,18009544,'CP'); insert into rsbl_orders_list values (175,18009548,'CP'); insert into rsbl_orders_list values (2360067,18009548,'CP'); insert into rsbl_orders_list values (284,18009550,'CP'); insert into rsbl_orders_list values (2360046,18009550,'CP'); insert into rsbl_orders_list values (307,18009552,'CP'); insert into rsbl_orders_list values (2360139,18009552,'CP'); insert into rsbl_orders_list values (353,18009554,'CP'); insert into rsbl_orders_list values (2360093,18009554,'CP'); insert into rsbl_orders_list values (115,18009557,'CP'); insert into rsbl_orders_list values (2360091,18009557,'CP'); insert into rsbl_orders_list values (354,18009559,'CP'); insert into rsbl_orders_list values (2360083,18009559,'CP'); insert into rsbl_orders_list values (240,18009570,'CP'); insert into rsbl_orders_list values (2360129,18009570,'CP'); insert into rsbl_orders_list values (50,18009571,'CP'); insert into rsbl_orders_list values (2360041,18009571,'CP'); insert into rsbl_orders_list values (248,18009572,'CP'); insert into rsbl_orders_list values (2360038,18009572,'CP'); insert into rsbl_orders_list values (108,18009575,'CP'); insert into rsbl_orders_list values (2360065,18009575,'CP'); insert into rsbl_orders_list values (261,18009585,'CP'); insert into rsbl_orders_list values (2360019,18009585,'CP'); insert into rsbl_orders_list values (44,18009588,'CP'); insert into rsbl_orders_list values (2360037,18009588,'CP'); insert into rsbl_orders_list values (104,18009593,'CP'); insert into rsbl_orders_list values (2360080,18009593,'CP'); insert into rsbl_orders_list values (23,18009599,'CP'); insert into rsbl_orders_list values (2360138,18009599,'CP'); insert into rsbl_orders_list values (328,18009601,'CP'); insert into rsbl_orders_list values (2360108,18009601,'CP'); insert into rsbl_orders_list values (69,18009602,'CP'); insert into rsbl_orders_list values (2360054,18009602,'CP'); insert into rsbl_orders_list values (125,18009603,'CP'); insert into rsbl_orders_list values (2360034,18009603,'CP'); insert into rsbl_orders_list values (260,18009608,'CP'); insert into rsbl_orders_list values (2360068,18009608,'CP'); insert into rsbl_orders_list values (289,18009610,'CP'); insert into rsbl_orders_list values (2360095,18009610,'CP'); insert into rsbl_orders_list values (160,18009611,'CP'); insert into rsbl_orders_list values (2360136,18009611,'CP'); insert into rsbl_orders_list values (123,18009613,'CP'); insert into rsbl_orders_list values (2360075,18009613,'CP'); insert into rsbl_orders_list values (205,18009615,'CP'); insert into rsbl_orders_list values (2360049,18009615,'CP'); insert into rsbl_orders_list values (184,18009621,'CP'); insert into rsbl_orders_list values (2360084,18009621,'CP'); insert into rsbl_orders_list values (226,18009629,'CP'); insert into rsbl_orders_list values (2360085,18009629,'CP'); insert into rsbl_orders_list values (105,18009631,'CP'); insert into rsbl_orders_list values (2360102,18009631,'CP'); insert into rsbl_orders_list values (142,18009633,'CP'); insert into rsbl_orders_list values (2360079,18009633,'CP'); insert into rsbl_orders_list values (228,18009634,'CP'); insert into rsbl_orders_list values (2360100,18009634,'CP'); insert into rsbl_orders_list values (91,18009640,'CP'); insert into rsbl_orders_list values (2360027,18009640,'CP'); insert into rsbl_orders_list values (275,18009642,'CP'); insert into rsbl_orders_list values (2360023,18009642,'CP'); insert into rsbl_orders_list values (287,18009644,'CP'); insert into rsbl_orders_list values (2360059,18009644,'CP'); insert into rsbl_orders_list values (119,18009649,'CP'); insert into rsbl_orders_list values (2360135,18009649,'CP'); insert into rsbl_orders_list values (49,18009650,'CP'); insert into rsbl_orders_list values (2360036,18009650,'CP'); insert into rsbl_orders_list values (146,18009656,'CP'); insert into rsbl_orders_list values (2360115,18009656,'CP'); insert into rsbl_orders_list values (231,18009661,'CP'); insert into rsbl_orders_list values (2360039,18009661,'CP'); insert into rsbl_orders_list values (268,18009663,'CP'); insert into rsbl_orders_list values (2360072,18009663,'CP'); insert into rsbl_orders_list values (127,18009666,'CP'); insert into rsbl_orders_list values (2360124,18009666,'CP'); insert into rsbl_orders_list values (62,18009667,'CP'); insert into rsbl_orders_list values (2360015,18009667,'CP'); insert into rsbl_orders_list values (171,18009668,'CP'); insert into rsbl_orders_list values (2360056,18009668,'CP'); insert into rsbl_orders_list values (306,18009671,'CP'); insert into rsbl_orders_list values (2360117,18009671,'CP'); insert into rsbl_orders_list values (155,18009678,'CP'); insert into rsbl_orders_list values (2360025,18009678,'CP'); insert into rsbl_orders_list values (348,18009683,'CP'); insert into rsbl_orders_list values (2360042,18009683,'CP'); insert into rsbl_orders_list values (180,18009684,'CP'); insert into rsbl_orders_list values (2360013,18009684,'CP'); insert into rsbl_orders_list values (278,18009689,'CP'); insert into rsbl_orders_list values (2360086,18009689,'CP'); insert into rsbl_orders_list values (266,18009693,'CP'); insert into rsbl_orders_list values (2360071,18009693,'CP'); insert into rsbl_orders_list values (225,18009695,'CP'); insert into rsbl_orders_list values (2360099,18009695,'CP'); insert into rsbl_orders_list values (189,18009704,'CP'); insert into rsbl_orders_list values (2360069,18009704,'CP'); insert into rsbl_orders_list values (273,18009706,'CP'); insert into rsbl_orders_list values (2360126,18009706,'CP'); insert into rsbl_orders_list values (249,18009710,'CP'); insert into rsbl_orders_list values (2360020,18009710,'CP'); insert into rsbl_orders_list values (134,18009717,'CP'); insert into rsbl_orders_list values (2360081,18009717,'CP'); insert into rsbl_orders_list values (190,18009719,'CP'); insert into rsbl_orders_list values (2360051,18009719,'CP'); insert into rsbl_orders_list values (349,18009720,'CP'); insert into rsbl_orders_list values (2360113,18009720,'CP'); insert into rsbl_orders_list values (60,18009724,'CP'); insert into rsbl_orders_list values (2360070,18009724,'CP'); insert into rsbl_orders_list values (292,18009727,'CP'); insert into rsbl_orders_list values (2360073,18009727,'CP'); insert into rsbl_orders_list values (92,18009728,'CP'); insert into rsbl_orders_list values (2360092,18009728,'CP'); insert into rsbl_orders_list values (317,18009730,'CP'); insert into rsbl_orders_list values (2360119,18009730,'CP'); insert into rsbl_orders_list values (165,18009733,'CP'); insert into rsbl_orders_list values (2360052,18009733,'CP'); insert into rsbl_orders_list values (471,18009740,'CP'); insert into rsbl_orders_list values (2360114,18009740,'CP'); insert into rsbl_orders_list values (255,18009742,'CP'); insert into rsbl_orders_list values (2360030,18009742,'CP'); insert into rsbl_orders_list values (210,18009750,'CP'); insert into rsbl_orders_list values (2360055,18009750,'CP'); insert into rsbl_orders_list values (149,18009751,'CP'); insert into rsbl_orders_list values (2360112,18009751,'CP'); insert into rsbl_orders_list values (39,18009754,'CP'); insert into rsbl_orders_list values (2360090,18009754,'CP'); insert into rsbl_orders_list values (176,18009758,'CP'); insert into rsbl_orders_list values (2360125,18009758,'CP'); insert into rsbl_orders_list values (288,18009764,'CP'); insert into rsbl_orders_list values (2360057,18009764,'CP'); insert into rsbl_orders_list values (318,18009765,'CP'); insert into rsbl_orders_list values (2360121,18009765,'CP'); insert into rsbl_orders_list values (319,18009770,'CP'); insert into rsbl_orders_list values (2360045,18009770,'CP'); insert into rsbl_orders_list values (118,18009771,'CP'); insert into rsbl_orders_list values (2360077,18009771,'CP'); insert into rsbl_orders_list values (333,18009772,'CP'); insert into rsbl_orders_list values (2360128,18009772,'CP'); insert into rsbl_orders_list values (477,18009774,'CP'); insert into rsbl_orders_list values (2360106,18009774,'CP'); insert into rsbl_orders_list values (223,18009775,'CP'); insert into rsbl_orders_list values (2360105,18009775,'CP'); insert into rsbl_orders_list values (129,18009776,'CP'); insert into rsbl_orders_list values (2360061,18009776,'CP'); insert into rsbl_orders_list values (294,18009777,'CP'); insert into rsbl_orders_list values (2360062,18009777,'CP'); insert into rsbl_orders_list values (172,18009779,'CP'); insert into rsbl_orders_list values (2360134,18009779,'CP'); insert into rsbl_orders_list values (364,18009780,'CP'); insert into rsbl_orders_list values (2360094,18009780,'CP'); insert into rsbl_orders_list values (303,18009781,'CP'); insert into rsbl_orders_list values (2360066,18009781,'CP'); insert into rsbl_orders_list values (148,18009783,'CP'); insert into rsbl_orders_list values (2360110,18009783,'CP'); insert into rsbl_orders_list values (183,18009785,'CP'); insert into rsbl_orders_list values (2360031,18009785,'CP'); insert into rsbl_orders_list values (177,18009786,'CP'); insert into rsbl_orders_list values (2360018,18009786,'CP'); insert into rsbl_orders_list values (320,18009788,'CP'); insert into rsbl_orders_list values (2360047,18009788,'CP'); insert into rsbl_orders_list values (57,18009790,'CP'); insert into rsbl_orders_list values (2360021,18009790,'CP'); insert into rsbl_orders_list values (265,18009794,'CP'); insert into rsbl_orders_list values (2360101,18009794,'CP'); insert into rsbl_orders_list values (280,18009798,'CP'); insert into rsbl_orders_list values (2360050,18009798,'CP'); insert into rsbl_orders_list values (277,18009799,'CP'); insert into rsbl_orders_list values (2360044,18009799,'CP'); insert into rsbl_orders_list values (279,18009801,'CP'); insert into rsbl_orders_list values (2360123,18009801,'CP'); insert into rsbl_orders_list values (309,18009807,'CP'); insert into rsbl_orders_list values (2360111,18009807,'CP'); insert into rsbl_orders_list values (195,18009808,'CP'); insert into rsbl_orders_list values (2360098,18009808,'CP'); insert into rsbl_orders_list values (330,18009814,'CP'); insert into rsbl_orders_list values (2360033,18009814,'CP'); insert into rsbl_orders_list values (400,18009846,'WZ'); insert into rsbl_orders_list values (2360043,18009846,'WZ'); insert into rsbl_orders_list values (401,18009847,'WZ'); insert into rsbl_orders_list values (2360087,18009847,'WZ'); insert into rsbl_orders_list values (380,18009855,'WZ'); insert into rsbl_orders_list values (2360109,18009855,'WZ'); insert into rsbl_orders_list values (381,18009856,'WZ'); insert into rsbl_orders_list values (2360063,18009856,'WZ'); insert into rsbl_orders_list values (382,18009857,'WZ'); insert into rsbl_orders_list values (2360088,18009857,'WZ'); insert into rsbl_orders_list values (383,18009858,'WZ'); insert into rsbl_orders_list values (2360017,18009858,'WZ'); insert into rsbl_orders_list values (238,18009859,'CP'); insert into rsbl_orders_list values (2360127,18009859,'CP'); insert into rsbl_orders_list values (64,18009883,'WZ'); insert into rsbl_orders_list values (2360014,18009883,'WZ'); insert into rsbl_orders_list values (65,18009884,'WZ'); insert into rsbl_orders_list values (2360012,18009884,'WZ'); insert into rsbl_orders_list values (66,18009885,'WZ'); insert into rsbl_orders_list values (2360133,18009885,'WZ'); insert into rsbl_orders_list values (387,18009887,'WZ'); insert into rsbl_orders_list values (2360064,18009887,'WZ'); insert into rsbl_orders_list values (388,18009888,'WZ'); insert into rsbl_orders_list values (2360076,18009888,'WZ'); insert into rsbl_orders_list values (395,18009930,'WZ'); insert into rsbl_orders_list values (2360028,18009930,'WZ'); insert into rsbl_orders_list values (396,18009931,'WZ'); insert into rsbl_orders_list values (2360026,18009931,'WZ'); insert into rsbl_orders_list values (397,18009932,'WZ'); insert into rsbl_orders_list values (2360029,18009932,'WZ'); insert into rsbl_orders_list values (398,18009933,'WZ'); insert into rsbl_orders_list values (2360016,18009933,'WZ'); insert into rsbl_orders_list values (75,18009942,'WZ'); insert into rsbl_orders_list values (2360103,18009942,'WZ'); insert into rsbl_orders_list values (76,18009943,'WZ'); insert into rsbl_orders_list values (2360053,18009943,'WZ'); insert into rsbl_orders_list values (77,18009944,'WZ'); insert into rsbl_orders_list values (2360074,18009944,'WZ'); insert into rsbl_orders_list values (78,18009945,'WZ'); insert into rsbl_orders_list values (2360060,18009945,'WZ'); insert into rsbl_orders_list values (79,18009946,'WZ'); insert into rsbl_orders_list values (2360024,18009946,'WZ'); insert into rsbl_orders_list values (80,18009947,'WZ'); insert into rsbl_orders_list values (2360118,18009947,'WZ'); insert into rsbl_orders_list values (81,18009948,'WZ'); insert into rsbl_orders_list values (2360097,18009948,'WZ'); insert into rsbl_orders_list values (82,18009949,'WZ'); insert into rsbl_orders_list values (2360035,18009949,'WZ'); insert into rsbl_orders_list values (83,18009950,'WZ'); insert into rsbl_orders_list values (2360131,18009950,'WZ'); insert into rsbl_orders_list values (84,18009951,'WZ'); insert into rsbl_orders_list values (2360022,18009951,'WZ'); insert into rsbl_orders_list values (85,18009952,'WZ'); insert into rsbl_orders_list values (2360120,18009952,'WZ'); insert into rsbl_orders_list values (86,18009953,'WZ'); insert into rsbl_orders_list values (2360122,18009953,'WZ'); insert into rsbl_orders_list values (87,18009954,'WZ'); insert into rsbl_orders_list values (2360107,18009954,'WZ'); insert into rsbl_orders_list values (466,18009969,'WZ'); insert into rsbl_orders_list values (2360011,18009969,'WZ'); insert into rsbl_orders_list values (378,18009982,'WZ'); insert into rsbl_orders_list values (2360082,18009982,'WZ'); insert into rsbl_orders_list values (8,18009985,'WZ'); insert into rsbl_orders_list values (2360199,18009985,'WZ'); insert into rsbl_orders_list values (379,18010031,'WZ'); insert into rsbl_orders_list values (2360229,18010031,'WZ'); insert into rsbl_orders_list values (474,18010036,'WZ'); insert into rsbl_orders_list values (2360130,18010036,'WZ'); insert into rsbl_orders_list values (475,18010037,'WZ'); insert into rsbl_orders_list values (2360096,18010037,'WZ'); insert into rsbl_orders_list values (295,18010054,'WZ'); insert into rsbl_orders_list values (2360159,18010054,'WZ'); insert into rsbl_orders_list values (296,18010055,'WZ'); insert into rsbl_orders_list values (2360226,18010055,'WZ'); insert into rsbl_orders_list values (297,18010056,'WZ'); insert into rsbl_orders_list values (2360186,18010056,'WZ'); insert into rsbl_orders_list values (298,18010057,'WZ'); insert into rsbl_orders_list values (2360149,18010057,'WZ'); insert into rsbl_orders_list values (299,18010058,'WZ'); insert into rsbl_orders_list values (2360176,18010058,'WZ'); insert into rsbl_orders_list values (300,18010059,'WZ'); insert into rsbl_orders_list values (2360155,18010059,'WZ'); insert into rsbl_orders_list values (468,18010078,'WZ'); insert into rsbl_orders_list values (2360174,18010078,'WZ'); insert into rsbl_orders_list values (476,18010097,'CP'); insert into rsbl_orders_list values (2360224,18010097,'CP'); insert into rsbl_orders_list values (376,18010105,'WP'); insert into rsbl_orders_list values (2360225,18010105,'WP'); insert into rsbl_orders_list values (385,18010107,'WP'); insert into rsbl_orders_list values (2360193,18010107,'WP'); insert into rsbl_orders_list values (61,18010117,'WP'); insert into rsbl_orders_list values (2360172,18010117,'WP'); insert into rsbl_orders_list values (130,18010179,'WP'); insert into rsbl_orders_list values (2360231,18010179,'WP'); insert into rsbl_orders_list values (131,18010180,'WP'); insert into rsbl_orders_list values (2360198,18010180,'WP'); insert into rsbl_orders_list values (472,18010200,'WP'); insert into rsbl_orders_list values (2360140,18010200,'WP'); insert into rsbl_orders_list values (473,18010201,'WP'); insert into rsbl_orders_list values (2360148,18010201,'WP'); insert into rsbl_orders_list values (102,18010286,'WP'); insert into rsbl_orders_list values (2360178,18010286,'WP'); insert into rsbl_orders_list values (103,18010287,'WP'); insert into rsbl_orders_list values (2360179,18010287,'WP'); insert into rsbl_orders_list values (145,18010355,'CP'); insert into rsbl_orders_list values (2360190,18010355,'CP'); insert into rsbl_orders_list values (147,18010357,'CP'); insert into rsbl_orders_list values (2360238,18010357,'CP'); insert into rsbl_orders_list values (304,18010364,'CP'); insert into rsbl_orders_list values (2360206,18010364,'CP'); insert into rsbl_orders_list values (305,18010365,'CP'); insert into rsbl_orders_list values (2360218,18010365,'CP'); insert into rsbl_orders_list values (198,18010366,'CP'); insert into rsbl_orders_list values (2360163,18010366,'CP'); insert into rsbl_orders_list values (96,18010370,'CP'); insert into rsbl_orders_list values (2360143,18010370,'CP'); insert into rsbl_orders_list values (200,18010376,'CP'); insert into rsbl_orders_list values (2360230,18010376,'CP'); insert into rsbl_orders_list values (168,18010385,'CP'); insert into rsbl_orders_list values (2360183,18010385,'CP'); insert into rsbl_orders_list values (276,18010389,'CP'); insert into rsbl_orders_list values (2360182,18010389,'CP'); insert into rsbl_orders_list values (55,18010392,'CP'); insert into rsbl_orders_list values (2360236,18010392,'CP'); insert into rsbl_orders_list values (361,18010400,'CP'); insert into rsbl_orders_list values (2360141,18010400,'CP'); insert into rsbl_orders_list values (196,18010402,'CP'); insert into rsbl_orders_list values (2360181,18010402,'CP'); insert into rsbl_orders_list values (311,18010403,'CP'); insert into rsbl_orders_list values (2360185,18010403,'CP'); insert into rsbl_orders_list values (58,18010404,'CP'); insert into rsbl_orders_list values (2360171,18010404,'CP'); insert into rsbl_orders_list values (478,18010405,'CP'); insert into rsbl_orders_list values (2360195,18010405,'CP'); insert into rsbl_orders_list values (215,18010408,'CP'); insert into rsbl_orders_list values (2360227,18010408,'CP'); insert into rsbl_orders_list values (313,18010421,'CP'); insert into rsbl_orders_list values (2360205,18010421,'CP'); insert into rsbl_orders_list values (479,18010423,'CP'); insert into rsbl_orders_list values (2360213,18010423,'CP'); insert into rsbl_orders_list values (199,18010431,'CP'); insert into rsbl_orders_list values (2360215,18010431,'CP'); insert into rsbl_orders_list values (325,18010434,'CP'); insert into rsbl_orders_list values (2360158,18010434,'CP'); insert into rsbl_orders_list values (70,18010438,'CP'); insert into rsbl_orders_list values (2360214,18010438,'CP'); insert into rsbl_orders_list values (193,18010443,'CP'); insert into rsbl_orders_list values (2360180,18010443,'CP'); insert into rsbl_orders_list values (169,18010444,'CP'); insert into rsbl_orders_list values (2360233,18010444,'CP'); insert into rsbl_orders_list values (363,18010445,'CP'); insert into rsbl_orders_list values (2360203,18010445,'CP'); insert into rsbl_orders_list values (357,18010448,'CP'); insert into rsbl_orders_list values (2360188,18010448,'CP'); insert into rsbl_orders_list values (203,18010454,'CP'); insert into rsbl_orders_list values (2360220,18010454,'CP'); insert into rsbl_orders_list values (112,18010456,'CP'); insert into rsbl_orders_list values (2360166,18010456,'CP'); insert into rsbl_orders_list values (267,18010458,'CP'); insert into rsbl_orders_list values (2360152,18010458,'CP'); insert into rsbl_orders_list values (143,18010462,'CP'); insert into rsbl_orders_list values (2360216,18010462,'CP'); insert into rsbl_orders_list values (25,18010465,'CP'); insert into rsbl_orders_list values (2360235,18010465,'CP'); insert into rsbl_orders_list values (192,18010466,'CP'); insert into rsbl_orders_list values (2360161,18010466,'CP'); insert into rsbl_orders_list values (290,18010471,'CP'); insert into rsbl_orders_list values (2360153,18010471,'CP'); insert into rsbl_orders_list values (217,18010479,'CP'); insert into rsbl_orders_list values (2360191,18010479,'CP'); insert into rsbl_orders_list values (365,18010484,'CP'); insert into rsbl_orders_list values (2360210,18010484,'CP'); insert into rsbl_orders_list values (367,18010487,'CP'); insert into rsbl_orders_list values (2360208,18010487,'CP'); insert into rsbl_orders_list values (186,18010494,'CP'); insert into rsbl_orders_list values (2360170,18010494,'CP'); insert into rsbl_orders_list values (150,18010501,'CP'); insert into rsbl_orders_list values (2360204,18010501,'CP'); insert into rsbl_orders_list values (291,18010502,'CP'); insert into rsbl_orders_list values (2360202,18010502,'CP'); insert into rsbl_orders_list values (340,18010512,'CP'); insert into rsbl_orders_list values (2360243,18010512,'CP'); insert into rsbl_orders_list values (20,18010518,'CP'); insert into rsbl_orders_list values (2360221,18010518,'CP'); insert into rsbl_orders_list values (24,18010523,'CP'); insert into rsbl_orders_list values (2360146,18010523,'CP'); insert into rsbl_orders_list values (285,18010525,'CP'); insert into rsbl_orders_list values (2360223,18010525,'CP'); insert into rsbl_orders_list values (170,18010526,'CP'); insert into rsbl_orders_list values (2360242,18010526,'CP'); insert into rsbl_orders_list values (144,18010527,'CP'); insert into rsbl_orders_list values (2360240,18010527,'CP'); insert into rsbl_orders_list values (323,18010530,'CP'); insert into rsbl_orders_list values (2360169,18010530,'CP'); insert into rsbl_orders_list values (93,18010531,'CP'); insert into rsbl_orders_list values (2360162,18010531,'CP'); insert into rsbl_orders_list values (342,18010542,'CP'); insert into rsbl_orders_list values (2360207,18010542,'CP'); insert into rsbl_orders_list values (258,18010545,'CP'); insert into rsbl_orders_list values (2360157,18010545,'CP'); insert into rsbl_orders_list values (32,18010549,'CP'); insert into rsbl_orders_list values (2360219,18010549,'CP'); insert into rsbl_orders_list values (167,18010553,'CP'); insert into rsbl_orders_list values (2360150,18010553,'CP'); insert into rsbl_orders_list values (362,18010561,'CP'); insert into rsbl_orders_list values (2360239,18010561,'CP'); insert into rsbl_orders_list values (272,18010568,'CP'); insert into rsbl_orders_list values (2360241,18010568,'CP'); insert into rsbl_orders_list values (54,18010578,'CP'); insert into rsbl_orders_list values (2360244,18010578,'CP'); insert into rsbl_orders_list values (359,18010609,'CP'); insert into rsbl_orders_list values (2360211,18010609,'CP'); insert into rsbl_orders_list values (343,18010611,'CP'); insert into rsbl_orders_list values (2360165,18010611,'CP'); insert into rsbl_orders_list values (358,18010617,'CP'); insert into rsbl_orders_list values (2360167,18010617,'CP'); insert into rsbl_orders_list values (338,18010619,'CP'); insert into rsbl_orders_list values (2360189,18010619,'CP'); insert into rsbl_orders_list values (341,18010625,'CP'); insert into rsbl_orders_list values (2360177,18010625,'CP'); insert into rsbl_orders_list values (136,18010628,'CP'); insert into rsbl_orders_list values (2360212,18010628,'CP'); insert into rsbl_orders_list values (360,18010629,'CP'); insert into rsbl_orders_list values (2360164,18010629,'CP'); insert into rsbl_orders_list values (331,18010644,'CP'); insert into rsbl_orders_list values (2360196,18010644,'CP'); insert into rsbl_orders_list values (99,18010646,'CP'); insert into rsbl_orders_list values (2360154,18010646,'CP'); insert into rsbl_orders_list values (350,18010649,'CP'); insert into rsbl_orders_list values (2360209,18010649,'CP'); insert into rsbl_orders_list values (38,18010657,'CP'); insert into rsbl_orders_list values (2360144,18010657,'CP'); insert into rsbl_orders_list values (121,18010658,'CP'); insert into rsbl_orders_list values (2360201,18010658,'CP'); insert into rsbl_orders_list values (336,18010663,'CP'); insert into rsbl_orders_list values (2360200,18010663,'CP'); insert into rsbl_orders_list values (17,18010667,'CP'); insert into rsbl_orders_list values (2360145,18010667,'CP'); insert into rsbl_orders_list values (6,18010670,'CP'); insert into rsbl_orders_list values (2360228,18010670,'CP'); insert into rsbl_orders_list values (356,18010673,'CP'); insert into rsbl_orders_list values (2360232,18010673,'CP'); insert into rsbl_orders_list values (101,18010721,'CP'); insert into rsbl_orders_list values (2360187,18010721,'CP'); insert into rsbl_orders_list values (37,18010724,'CP'); insert into rsbl_orders_list values (2360184,18010724,'CP'); insert into rsbl_orders_list values (11,18010730,'CP'); insert into rsbl_orders_list values (2360194,18010730,'CP'); insert into rsbl_orders_list values (71,18010731,'CP'); insert into rsbl_orders_list values (2360168,18010731,'CP'); insert into rsbl_orders_list values (224,18010733,'CP'); insert into rsbl_orders_list values (2360173,18010733,'CP'); insert into rsbl_orders_list values (13,18010739,'CP'); insert into rsbl_orders_list values (2360197,18010739,'CP'); insert into rsbl_orders_list values (372,18010766,'WZ'); insert into rsbl_orders_list values (2360237,18010766,'WZ'); insert into rsbl_orders_list values (373,18010767,'WZ'); insert into rsbl_orders_list values (2360156,18010767,'WZ'); insert into rsbl_orders_list values (374,18010768,'WZ'); insert into rsbl_orders_list values (2360217,18010768,'WZ'); insert into rsbl_orders_list values (469,18010783,'WZ'); insert into rsbl_orders_list values (2360222,18010783,'WZ'); insert into rsbl_orders_list values (470,18010784,'WZ'); insert into rsbl_orders_list values (2360160,18010784,'WZ'); insert into rsbl_orders_list values (15,18010785,'WZ'); insert into rsbl_orders_list values (2360192,18010785,'WZ'); insert into rsbl_orders_list values (29,18010799,'WZ'); insert into rsbl_orders_list values (2360142,18010799,'WZ'); insert into rsbl_orders_list values (30,18010800,'WZ'); insert into rsbl_orders_list values (2360151,18010800,'WZ'); insert into rsbl_orders_list values (151,18010869,'WZ'); insert into rsbl_orders_list values (2360147,18010869,'WZ'); insert into rsbl_orders_list values (152,18010870,'WZ'); insert into rsbl_orders_list values (2360175,18010870,'WZ'); insert into rsbl_orders_list values (153,18010871,'WZ'); insert into rsbl_orders_list values (2360234,18010871,'WZ'); insert into rsbl_orders_list values (1,18010937,'WP'); insert into rsbl_orders_list values (2360263,18010937,'WP'); insert into rsbl_orders_list values (4,18010938,'WP'); insert into rsbl_orders_list values (2360292,18010938,'WP'); insert into rsbl_orders_list values (31,18010945,'WP'); insert into rsbl_orders_list values (2360294,18010945,'WP'); insert into rsbl_orders_list values (63,18010948,'WP'); insert into rsbl_orders_list values (2360255,18010948,'WP'); insert into rsbl_orders_list values (94,18010949,'WP'); insert into rsbl_orders_list values (2360247,18010949,'WP'); insert into rsbl_orders_list values (14,18010967,'WP'); insert into rsbl_orders_list values (2360297,18010967,'WP'); insert into rsbl_orders_list values (314,18011010,'WP'); insert into rsbl_orders_list values (2360274,18011010,'WP'); insert into rsbl_orders_list values (389,18011022,'WP'); insert into rsbl_orders_list values (2360285,18011022,'WP'); insert into rsbl_orders_list values (390,18011026,'WP'); insert into rsbl_orders_list values (2360295,18011026,'WP'); insert into rsbl_orders_list values (16,18011027,'WP'); insert into rsbl_orders_list values (2360296,18011027,'WP'); insert into rsbl_orders_list values (161,18011031,'WP'); insert into rsbl_orders_list values (2360269,18011031,'WP'); insert into rsbl_orders_list values (257,18011042,'WP'); insert into rsbl_orders_list values (2360283,18011042,'WP'); insert into rsbl_orders_list values (386,18011046,'WP'); insert into rsbl_orders_list values (2360245,18011046,'WP'); insert into rsbl_orders_list values (392,18011119,'WP'); insert into rsbl_orders_list values (2360289,18011119,'WP'); insert into rsbl_orders_list values (263,18011132,'WP'); insert into rsbl_orders_list values (2360256,18011132,'WP'); insert into rsbl_orders_list values (133,18011142,'CP'); insert into rsbl_orders_list values (2360275,18011142,'CP'); insert into rsbl_orders_list values (135,18011321,'CP'); insert into rsbl_orders_list values (2360280,18011321,'CP'); insert into rsbl_orders_list values (158,18011373,'CP'); insert into rsbl_orders_list values (2360267,18011373,'CP'); insert into rsbl_orders_list values (139,18011484,'CP'); insert into rsbl_orders_list values (2360261,18011484,'CP'); insert into rsbl_orders_list values (246,18011531,'CP'); insert into rsbl_orders_list values (2360284,18011531,'CP'); insert into rsbl_orders_list values (391,18011603,'CP'); insert into rsbl_orders_list values (2360276,18011603,'CP'); insert into rsbl_orders_list values (110,18011622,'CP'); insert into rsbl_orders_list values (2360257,18011622,'CP'); insert into rsbl_orders_list values (393,18011692,'CP'); insert into rsbl_orders_list values (2360268,18011692,'CP'); insert into rsbl_orders_list values (394,18011712,'CP'); insert into rsbl_orders_list values (2360251,18011712,'CP'); insert into rsbl_orders_list values (181,18011748,'CP'); insert into rsbl_orders_list values (2360266,18011748,'CP'); insert into rsbl_orders_list values (182,18011766,'CP'); insert into rsbl_orders_list values (2360258,18011766,'CP'); insert into rsbl_orders_list values (185,18011898,'CP'); insert into rsbl_orders_list values (2360262,18011898,'CP'); insert into rsbl_orders_list values (371,18011953,'CP'); insert into rsbl_orders_list values (2360281,18011953,'CP'); insert into rsbl_orders_list values (253,18011969,'CP'); insert into rsbl_orders_list values (2360290,18011969,'CP'); insert into rsbl_orders_list values (259,18012063,'CP'); insert into rsbl_orders_list values (2360259,18012063,'CP'); insert into rsbl_orders_list values (88,18012079,'CP'); insert into rsbl_orders_list values (2360277,18012079,'CP'); insert into rsbl_orders_list values (5,18012438,'CP'); insert into rsbl_orders_list values (2360293,18012438,'CP'); insert into rsbl_orders_list values (369,18012486,'CP'); insert into rsbl_orders_list values (2360248,18012486,'CP'); insert into rsbl_orders_list values (254,18012567,'CP'); insert into rsbl_orders_list values (2360270,18012567,'CP'); insert into rsbl_orders_list values (126,18012719,'CP'); insert into rsbl_orders_list values (2360278,18012719,'CP'); insert into rsbl_orders_list values (332,18012754,'CP'); insert into rsbl_orders_list values (2360271,18012754,'CP'); insert into rsbl_orders_list values (52,18012756,'CP'); insert into rsbl_orders_list values (2360252,18012756,'CP'); insert into rsbl_orders_list values (132,18012884,'CP'); insert into rsbl_orders_list values (2360282,18012884,'CP'); insert into rsbl_orders_list values (174,18012929,'CP'); insert into rsbl_orders_list values (2360286,18012929,'CP'); insert into rsbl_orders_list values (368,18013159,'CP'); insert into rsbl_orders_list values (2360264,18013159,'CP'); insert into rsbl_orders_list values (250,18013201,'CP'); insert into rsbl_orders_list values (2360273,18013201,'CP'); insert into rsbl_orders_list values (366,18013256,'CP'); insert into rsbl_orders_list values (2360272,18013256,'CP'); insert into rsbl_orders_list values (2,18013275,'CP'); insert into rsbl_orders_list values (2360246,18013275,'CP'); insert into rsbl_orders_list values (334,18013379,'CP'); insert into rsbl_orders_list values (2360253,18013379,'CP'); insert into rsbl_orders_list values (216,18013440,'CP'); insert into rsbl_orders_list values (2360260,18013440,'CP'); insert into rsbl_orders_list values (211,18013456,'CP'); insert into rsbl_orders_list values (2360254,18013456,'CP'); insert into rsbl_orders_list values (56,18013930,'CP'); insert into rsbl_orders_list values (2360249,18013930,'CP'); insert into rsbl_orders_list values (12,18013966,'CP'); insert into rsbl_orders_list values (2360287,18013966,'CP'); insert into rsbl_orders_list values (67,18013970,'CP'); insert into rsbl_orders_list values (2360250,18013970,'CP'); insert into rsbl_orders_list values (370,18014019,'CP'); insert into rsbl_orders_list values (2360288,18014019,'CP'); insert into rsbl_orders_list values (212,18014089,'CP'); insert into rsbl_orders_list values (2360265,18014089,'CP'); insert into rsbl_orders_list values (18,18014148,'WZ'); insert into rsbl_orders_list values (2360291,18014148,'WZ'); insert into rsbl_orders_list values (19,18014149,'WZ'); insert into rsbl_orders_list values (2360279,18014149,'WZ'); insert into rsbl_orders_list values (2556553,19771434,'CP'); insert into rsbl_orders_list values (2556554,19771434,'WZ'); insert into rsbl_orders_list values (2556555,19771435,'CP'); insert into rsbl_orders_list values (2556556,19771435,'WZ'); insert into rsbl_orders_list values (2556557,19771436,'CP'); insert into rsbl_orders_list values (2556558,19771436,'WZ'); insert into rsbl_orders_list values (2556563,19771437,'CP'); insert into rsbl_orders_list values (2556564,19771437,'WZ'); insert into rsbl_orders_list values (2556565,19771438,'CP'); insert into rsbl_orders_list values (2556566,19771438,'WZ'); insert into rsbl_orders_list values (2556567,19771439,'CP'); insert into rsbl_orders_list values (2556568,19771439,'WZ'); insert into rsbl_orders_list values (2556569,19866797,'CP'); insert into rsbl_orders_list values (2556570,19866797,'WP'); insert into rsbl_orders_list values (2556571,19866798,'CP'); insert into rsbl_orders_list values (2556572,19866798,'WP'); insert into rsbl_orders_list values (2959271,21546317,'EC'); insert into rsbl_orders_list values (2959272,21546317,'WP'); insert into rsbl_orders_list values (2959236,21617897,'EC'); insert into rsbl_orders_list values (2959237,21617897,'WP'); insert into rsbl_orders_list values (2959232,21622683,'CP'); insert into rsbl_orders_list values (2959233,21622683,'EC'); insert into rsbl_orders_list values (3218491,22373719,'CP'); insert into rsbl_orders_list values (3218492,22373719,'EC'); insert into rsbl_orders_list values (3218493,22373719,'WP'); insert into rsbl_orders_list values (3218494,22373720,'CP'); insert into rsbl_orders_list values (3218495,22373720,'EC'); insert into rsbl_orders_list values (3218496,22373720,'WP'); insert into rsbl_orders_list values (3215728,22476643,'CP'); insert into rsbl_orders_list values (3215729,22476643,'WZ'); insert into rsbl_orders_list values (3215730,22476644,'CP'); insert into rsbl_orders_list values (3215731,22476644,'WZ'); insert into rsbl_orders_list values (3215710,22514526,'EC'); insert into rsbl_orders_list values (3215711,22514526,'WP'); insert into rsbl_orders_list values (3215720,22534997,'EC'); insert into rsbl_orders_list values (3215721,22534997,'WP'); insert into rsbl_orders_list values (3215724,22536272,'EC'); insert into rsbl_orders_list values (3215725,22536272,'WP'); insert into rsbl_orders_list values (3215716,22576698,'EC'); insert into rsbl_orders_list values (3215717,22576698,'WP'); insert into rsbl_orders_list values (3215764,22586763,'EC'); insert into rsbl_orders_list values (3215765,22586763,'WP'); insert into rsbl_orders_list values (3215772,22589863,'EC'); insert into rsbl_orders_list values (3215773,22589863,'WP'); insert into rsbl_orders_list values (3215768,22591713,'EC'); insert into rsbl_orders_list values (3215769,22591713,'WP'); insert into rsbl_orders_list values (3215706,22607432,'EC'); insert into rsbl_orders_list values (3215707,22607432,'WP'); insert into rsbl_orders_list values (3215760,22613646,'EC'); insert into rsbl_orders_list values (3215761,22613646,'WP'); insert into rsbl_orders_list values (3215754,22630379,'EC'); insert into rsbl_orders_list values (3215755,22630379,'WP'); insert into rsbl_orders_list values (3215750,22631538,'EC'); insert into rsbl_orders_list values (3215751,22631538,'WP'); insert into rsbl_orders_list values (3215740,22652307,'EC'); insert into rsbl_orders_list values (3215741,22652307,'WP'); insert into rsbl_orders_list values (3215736,22663705,'EC'); insert into rsbl_orders_list values (3215737,22663705,'WP'); insert into rsbl_orders_list values (3215732,22663778,'EC'); insert into rsbl_orders_list values (3215733,22663778,'WP'); insert into rsbl_orders_list values (3215746,22672146,'EC'); insert into rsbl_orders_list values (3215747,22672146,'WP'); insert into rsbl_orders_list values (3267420,22689562,'CP'); insert into rsbl_orders_list values (3267421,22689562,'WZ'); insert into rsbl_orders_list values (3267422,22689563,'CP'); insert into rsbl_orders_list values (3267423,22689563,'WZ'); insert into rsbl_orders_list values (3267424,22753184,'EC'); insert into rsbl_orders_list values (3267425,22753184,'WP'); insert into rsbl_orders_list values (3473173,23456403,'CP'); insert into rsbl_orders_list values (3473174,23456403,'WZ'); insert into rsbl_orders_list values (3473175,23456404,'CP'); insert into rsbl_orders_list values (3473176,23456404,'WZ'); insert into rsbl_orders_list values (3473177,23456465,'CP'); insert into rsbl_orders_list values (3473178,23456465,'WZ'); insert into rsbl_orders_list values (3473179,23456466,'CP'); insert into rsbl_orders_list values (3473180,23456466,'WZ'); insert into rsbl_orders_list values (3473181,23562177,'EC'); insert into rsbl_orders_list values (3473182,23562177,'WP'); insert into rsbl_orders_list values (3473183,23562212,'EC'); insert into rsbl_orders_list values (3473184,23562212,'WP'); insert into rsbl_orders_list values (3528104,24044942,'CP'); insert into rsbl_orders_list values (3528105,24044942,'CP'); SELECT det_id, order_status, COUNT(*) AS duplicate_count FROM rsbl_orders_list GROUP BY det_id, order_status HAVING COUNT(*) > 1;
Copy Clear
Copy Format Clear
<?php use Carbon\Carbon; $now = Carbon::now()->format('d/m/Y'); /* printf("Today is %s\nCurrent PHP version: %s \n\n", $now, phpversion()); $query = "SELECT VERSION() as version;"; // get DB version using PDO $stmt = $pdo->prepare($query); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); printf('DB version (PDO): %s ' . PHP_EOL, $row['version']); // Run query using mysqli $result = $mysqli->query($query); $version = $result->fetch_object(); printf('DB version (mysqli): %s ' . PHP_EOL, $version->version); exit;*/ $q="select count(*) as t, det_id from rsbl_orders_list group by det_id having count(*) >1 and det_id not in (12452922,12486838,12586879,12607799,12607800,12630862,12630863,12630871,12630872,12654522,12688331,12790384,12802149,12895158,12916475,12927916,13026803,13032927,13064041,13064042,13108884,13129850,13141298,13240115,13259195,13325834,13346661,13357448,13385766,13455272,13476231,13665199,13667787,13688070,13724812,13729355,13907339,13910020,13928252,13944574,13968549,14187018,14189720,14226472,14232756,14259475,14470009,14472723,14516705,14529754,14545146,17812979,17812980,17993035,17993036,17993808,17993809,17993888,17993889,17994816,17994817,17994818,17994819,18008306,18008451,18008452,18008453,18008508,18008552,18008567,18008575,18008577,18008635,18008682,18008683,18008685,18008689,18008691,18008693,18008694,18008700,18008701,18008703,18008704,18008705,18008706,18008707,18008708,18008709,18008710,18008711,18008712,18008713,18008715,18008716,18008718,18008720,18008721,18008722,18008727,18008731,18008734,18008737,18008740,18008746,18008751,18008756,18008763,18008767,18008770,18008781,18008789,18008790,18008795,18008796,18008798,18008801,18008803,18008806,18008810,18008811,18008816,18008827,18008830,18008835,18008845,18008850,18008855,18008858,18008859,18008860,18008862,18008866,18008868,18008875,18008885,18008888,18008892,18008895,18008898,18008902,18008903,18008912,18008923,18008929,18008937,18008945,18008951,18008958,18008962,18008967,18008991,18008993,18008995,18008997,18008999,18009000,18009001,18009002,18009003,18009004,18009005,18009006,18009007,18009008,18009009,18009010,18009011,18009012,18009013,18009014,18009015,18009016,18009017,18009018,18009019,18009020,18009021,18009022,18009023,18009024,18009025,18009026,18009027,18009028,18009029,18009030,18009031,18009032,18009033,18009034,18009035,18009036,18009037,18009038,18009039,18009040,18009041,18009042,18009043,18009044,18009045,18009046,18009047,18009048,18009049,18009050,18009051,18009052,18009053,18009054,18009055,18009056,18009057,18009058,18009059,18009061,18009062,18009063,18009064,18009066,18009068,18009070,18009072,18009084,18009127,18009129,18009131,18009133,18009135,18009137,18009139,18009141,18009143,18009145,18009147,18009149,18009208,18009245,18009246,18009247,18009270,18009271,18009298,18009299,18009335,18009336,18009355,18009405,18009412,18009434,18009542,18009544,18009548,18009550,18009552,18009554,18009557,18009559,18009570,18009571,18009572,18009575,18009585,18009588,18009593,18009599,18009601,18009602,18009603,18009608,18009610,18009611,18009613,18009615,18009621,18009629,18009631,18009633,18009634,18009640,18009642,18009644,18009649,18009650,18009656,18009661,18009663,18009666,18009667,18009668,18009671,18009678,18009683,18009684,18009689,18009693,18009695,18009704,18009706,18009710,18009717,18009719,18009720,18009724,18009727,18009728,18009730,18009733,18009740,18009742,18009750,18009751,18009754,18009758,18009764,18009765,18009770,18009771,18009772,18009774,18009775,18009776,18009777,18009779,18009780,18009781,18009783,18009785,18009786,18009788,18009790,18009794,18009798,18009799,18009801,18009807,18009808,18009814,18009846,18009847,18009855,18009856,18009857,18009858,18009859,18009883,18009884,18009885,18009887,18009888,18009930,18009931,18009932,18009933,18009942,18009943,18009944,18009945,18009946,18009947,18009948,18009949,18009950,18009951,18009952,18009953,18009954,18009969,18009982,18009985,18010031,18010036,18010037,18010054,18010055,18010056,18010057,18010058,18010059,18010078,18010097,18010105,18010107,18010117,18010179,18010180,18010200,18010201,18010286,18010287,18010355,18010357,18010364,18010365,18010366,18010370,18010376,18010385,18010389,18010392,18010400,18010402,18010403,18010404,18010405,18010408,18010421,18010423,18010431,18010434,18010438,18010443,18010444,18010445,18010448,18010454,18010456,18010458,18010462,18010465,18010466,18010471,18010479,18010484,18010487,18010494,18010501,18010502,18010512,18010518,18010523,18010525,18010526,18010527,18010530,18010531,18010542,18010545,18010549,18010553,18010561,18010568,18010578,18010609,18010611,18010617,18010619,18010625,18010628,18010629,18010644,18010646,18010649,18010657,18010658,18010663,18010667,18010670,18010673,18010721,18010724,18010730,18010731,18010733,18010739,18010766,18010767,18010768,18010783,18010784,18010785,18010799,18010800,18010869,18010870,18010871,18010937,18010938,18010945,18010948,18010949,18010967,18011010,18011022,18011026,18011027,18011031,18011042,18011046,18011119,18011132,18011142,18011321,18011373,18011484,18011531,18011603,18011622,18011692,18011712,18011748,18011766,18011898,18011953,18011969,18012063,18012079,18012438,18012486,18012567,18012719,18012754,18012756,18012884,18012929,18013159,18013201,18013256,18013275,18013379,18013440,18013456,18013930,18013966,18013970,18014019,18014089,18014148,18014149,24044942) order by det_id;"; $stmt = $pdo->prepare($q); $stmt->execute(); $rows = query_array($stmt, $q); $to_delete=array(); foreach($rows as $r){ $q2="select * from rsbl_orders_list where det_id=".$r["det_id"]; $stmt = $pdo->prepare($q2); $stmt->execute(); $rows2 = query_array($stmt, $q2); $id_ok= (!is_null(array_column($rows2, 'id', 'order_status')['CP']) ? array_column($rows2, 'id', 'order_status')['CP'] : ( !is_null(array_column($rows2, 'id', 'order_status')['WZ']) ? array_column($rows2, 'id', 'order_status')['WZ'] : ( !is_null(array_column($rows2, 'id', 'order_status')['EC']) ? array_column($rows2, 'id', 'order_status')['EC'] : ( !is_null(array_column($rows2, 'id', 'order_status')['WP']) ? array_column($rows2, 'id', 'order_status')['WP'] : ( !is_null(array_column($rows2, 'id', 'order_status')['NW']) ? array_column($rows2, 'id', 'order_status')['NW'] : "ERRORE") ) ) )); //echo $r["det_id"]." ".$result."\n"; if($id_ok!="ERRORE"){ foreach($rows2 as $r2) if($r2["id"]!=$id_ok) $to_delete[]=$r2["id"]; } else echo $r["det_id"]." ERRORE\n"; } echo (json_encode($to_delete)); function query_array($db,$q){ $res = $db->fetchAll(PDO::FETCH_ASSOC); //var_dump($res); if (!$res){ echo "Errore in query: $q \n"; var_dump($db->errorInfo()); exit(1); } $lista=array(); foreach ($res as $row){ $lista[]=$row; } return $lista; }
Show:  
Copy Clear