cana-mig-formats.sql

update na_comdef_meetings_main set formats = replace(formats, '53', '2') where id_bigint in (949,933,871,850,781,699,683,642,978,490,482,627,895,1201,789,1330);
update na_comdef_meetings_main set formats = replace(formats, '55', '4') where id_bigint in (289,293,962,961,960,959,958,957,941,940,933,904,843,827,821,819,820,787,774,732,726,716,707,703,697,683,658,660,641,634,633,619,600,597,571,566,978,551,541,542,490,473,472,468,460,461,445,1231,980,966,673,950,1035,754,478,1055,853,948,701,629,909,1043,1063,1234,1235,1236,968,1079,599,944,1154,1155,1156,1157,1158,1159,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1207,1208,1209,1210,1211,1212,1213,1264,1232,1233,885,1323,1324,496,1332);
update na_comdef_meetings_main set formats = replace(formats, '56', '5') where id_bigint in (843,786,784,617,606,566,558,556,532,531,445,484);
update na_comdef_meetings_main set formats = replace(formats, '57', '6') where id_bigint in (662,1012);
/*update na_comdef_meetings_main set formats = replace(formats, '58', '7') where id_bigint in ();*/
update na_comdef_meetings_main set formats = replace(formats, '59', '8') where id_bigint in (891,609,856,787,636,638,566,553,541,538,539,536,535,490,473,443,980,1041,596,451,552,1182,1063,672,1217,1216,1305,1214,599,1306,895,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1148,1149,1150,1151,1152,704,944,1160,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1190,1191,761,1196,1197,1198,1199,1200,1201,678,1218,1219,1220,1264,592,1253,1254,1255,1256,1257,1267,885,1307,1308,1330,496);
update na_comdef_meetings_main set formats = replace(formats, '61', '10') where id_bigint in (901,548);
/*update na_comdef_meetings_main set formats = replace(formats, '62', '11') where id_bigint in ();*/
update na_comdef_meetings_main set formats = replace(formats, '67', '16') where id_bigint in (953,697,657,556,531,446,950,1160,462);
update na_comdef_meetings_main set formats = replace(formats, '69', '18') where id_bigint in (1042,508);
/*update na_comdef_meetings_main set formats = replace(formats, '71', '20') where id_bigint in ();*/
/*update na_comdef_meetings_main set formats = replace(formats, '72', '21') where id_bigint in ();*/
/*update na_comdef_meetings_main set formats = replace(formats, '75', '24') where id_bigint in ();*/
/*update na_comdef_meetings_main set formats = replace(formats, '79', '28') where id_bigint in ();*/
update na_comdef_meetings_main set formats = replace(formats, '98', '47') where id_bigint in (959,952,942,941,940,901,488,894,881,877,880,857,831,821,734,487,485,477,476,475,474,473,472,979,934,478,833,484,1204,1205);
/*update na_comdef_meetings_main set formats = replace(formats, '86', '35') where id_bigint in ();*/
update na_comdef_meetings_main set formats = replace(formats, '101', '50') where id_bigint in (209,162,163,165,170,996,196,273,276,284,187,293,310,311,320,351,372,432,1044,973,1081,1082,357,1088,1089,1090,1091,83,40,981,172,253,46,251,235,200,86,173,1083,984,88,210,1084,271,239,178,1085,219,1092,974,181,982,1086,1093,230,1087,1094,189,281,168,248,154,1100,1101,1102,256,177,1103,1104,252,1106,1107,1108,1109,1110,1112,1113,1114,1115,1333,1119,1121,1122,1123,1124,1295,1296,1293,1299,1298,1297,1294);

delete from na_comdef_formats where shared_id_bigint in (53, 55, 56, 57, 58, 59, 61, 62, 67, 69, 71, 72, 75, 79, 86, 98, 101, 91, 95, 90, 63, 93, 88, 94, 93, 92);

select group_concat(distinct id_bigint) from na_comdef_meetings_main a inner join 
na_comdef_formats b on find_in_set(b.shared_id_bigint, a.formats)
where b.shared_id_bigint in (53, 55, 56, 57, 58, 59, 61, 62, 67, 69, 71, 72, 75, 79, 86, 98, 101);

select * from na_comdef_formats where lang_enum in ('en', 'fr') and shared_id_bigint in (53, 55, 56, 57, 58, 59, 61, 62, 67, 69, 71, 72, 75, 79, 86, 98, 101);
select * from na_comdef_formats where lang_enum in ('en', 'fr') and shared_id_bigint in (2, 4, 5, 6, 7, 8, 10, 11, 16, 18, 20, 21, 24, 28, 47, 35, 50);