python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-05 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 05 mtr_id : dashboard_places : SCCU_cam6 date : 2026-05 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam6' and date like '%2026-05%') and created_at like '%2026-05%'))); nb_day : (4, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 202 and month(ded.date) = 05 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 202 and month(ded.date) = 05 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%052026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-05-01 : dt_date_just_month_year : 2026-05-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-05-01" AND ded.date <= "2026-05-31" SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (2986784,2986988,2987464,2988030,2988554,2988976,2989494,2989940,2990146) AND dr.mtr_portfolio_id=ptp.mtr_portfolio_id_1 AND dr.qualite >= 0 AND mpp.mtr_portfolio_id=ptp.mtr_portfolio_id_2 AND pcr.portfolio_id=ptp.mtr_portfolio_id_1 AND h.hashtag_id = pcr.hashtag_id AND ptp.type = pcr.hashtag_type AND mpp.hide_status = 0 AND ptp.hashtag_id=h.hashtag_id group by h.hashtag, dr.hashtag, ptp.type; VR TODO TO BETTER PARSE ! ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010868579867819453, 'nb_photo': 5594, 'list_port_cont': '31045334,31045366,31045407,31045455,31045486,31045523,31045992,31046082,31046321,31046785,31046816,31046852,31047779,31047816,31047845,31047882,31047931,31047964,31048007,31048044,31048067,31048108,31048146,31048183,31048225,31048256,31048291,31048374,31048404,31049443,31049479,31049508,31049549,31049925,31050097,31050154,31050423,31050691,31050950,31050983,31051273,31051519,31051556,31051582,31051628,31051656,31051691,31051748,31051771,31051821,31051849,31052984,31053024,31053066,31053134,31053168,31053645,31053749,31053784,31054273,31054308,31054585,31054626,31054671,31055073,31055118,31055145,31055468,31055739,31055912,31056073,31056332,31056550,31056570,31056825,31057108,31057263,31057511,31057709,31057759,31057866,31058280,31058534,31058728,31058812,31059058,31059132,31059519,31059681,31059970,31060073,31060287,31060494,31060659,31060889,31061095,31061269,31061307,31061595,31061753,31062040,31062256,31062528,31062614,31063150,31063360,31063521,31063657,31063868,31063912,31064248,31064371,31064500,3106470', 'assoc_port': '31044708:31056825,31044709:31046321,31044710:31051519,31044711:31045334,31044712:31045366,31044713:31045407,31044714:31046082,31044715:31045455,31044716:31045486,31044717:31045523,31045590:31051556,31045591:31051582,31045592:31051628,31045593:31051656,31045594:31051691,31045595:31051771,31045596:31045992,31046064:31051748,31046065:31051821,31046066:31051849,31046295:31046785,31046296:31046816,31046297:31046852,31047156:31047779,31047158:31047816,31047159:31047845,31047160:31047882,31047161:31047931,31047162:31047964,31047281:31048007,31047282:31048044,31047283:31048067,31047335:31048108,31047336:31048146,31047337:31048183,31047338:31048225,31047655:31048256,31047656:31048291,31047657:31048374,31047658:31048404,31049364:31049443,31049365:31049479,31049366:31049549,31049367:31049508,31049385:31049925,31050029:31050097,31050030:31050154,31050374:31050423,31050605:31050691,31050879:31050950,31050880:31050983,31051242:31051273,31052863:31052984,31052864:31053024,31052865:31053066,31052866:31053134,31052867:3105316', 'assoc_mat': '31044708:autre:4230:31056825,31044709:autre:4230:31046321,31044710:autre:4230:31051519,31044711:autre:4230:31045334,31044712:autre:4230:31045366,31044713:autre:4230:31045407,31044714:autre:4230:31046082,31044715:autre:4230:31045455,31044716:autre:4230:31045486,31044717:autre:4230:31045523,31045590:autre:4230:31051556,31045591:autre:4230:31051582,31045592:autre:4230:31051628,31045593:autre:4230:31051656,31045594:autre:4230:31051691,31045595:autre:4230:31051771,31045596:autre:4230:31045992,31046064:autre:4230:31051748,31046065:autre:4230:31051821,31046066:autre:4230:31051849,31046295:autre:4230:31046785,31046296:autre:4230:31046816,31046297:autre:4230:31046852,31047156:autre:4230:31047779,31047158:autre:4230:31047816,31047159:autre:4230:31047845,31047160:autre:4230:31047882,31047161:autre:4230:31047931,31047162:autre:4230:31047964,31047281:autre:4230:31048007,31047282:autre:4230:31048044,31047283:autre:4230:31048067,31047335:autre:4230:31048108,31047336:autre:4230:31048146,31047337:autre:4230:31048183,31047338:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03848269750496583, 'nb_photo': 25658, 'list_port_cont': '31045330,31045365,31045403,31045458,31045489,31045528,31046002,31046081,31046333,31046786,31046821,31046862,31047788,31047826,31047861,31047895,31047930,31047958,31048000,31048035,31048083,31048112,31048143,31048182,31048228,31048265,31048301,31048369,31048408,31049441,31049485,31049505,31049553,31049927,31050095,31050166,31050434,31050700,31050946,31050976,31051277,31051506,31051557,31051592,31051631,31051663,31051697,31051747,31051777,31051813,31051859,31052988,31053021,31053061,31053140,31053180,31053660,31053761,31053793,31054268,31054305,31054597,31054639,31054675,31055083,31055112,31055154,31055472,31055748,31055917,31056077,31056336,31056541,31056578,31056820,31057111,31057274,31057517,31057712,31057770,31057872,31058291,31058539,31058740,31058820,31059072,31059134,31059510,31059672,31059964,31060003,31060070,31060297,31060506,31060668,31060899,31061099,31061283,31061319,31061603,31061759,31062038,31062252,31062536,31062607,31063152,31063354,31063523,31063656,31063871,31063903,31064257,31064382,3106450', 'assoc_port': '31044708:31056820,31044709:31046333,31044710:31051506,31044711:31045330,31044712:31045365,31044713:31045403,31044714:31046081,31044715:31045458,31044716:31045489,31044717:31045528,31045590:31051557,31045591:31051592,31045592:31051631,31045593:31051663,31045594:31051697,31045595:31051777,31045596:31046002,31046064:31051747,31046065:31051813,31046066:31051859,31046295:31046786,31046296:31046821,31046297:31046862,31047156:31047788,31047158:31047826,31047159:31047861,31047160:31047895,31047161:31047930,31047162:31047958,31047281:31048000,31047282:31048035,31047283:31048083,31047335:31048112,31047336:31048143,31047337:31048182,31047338:31048228,31047655:31048265,31047656:31048301,31047657:31048369,31047658:31048408,31049364:31049441,31049365:31049485,31049366:31049553,31049367:31049505,31049385:31049927,31050029:31050095,31050030:31050166,31050374:31050434,31050605:31050700,31050879:31050946,31050880:31050976,31051242:31051277,31052863:31052988,31052864:31053021,31052865:31053061,31052866:31053140,31052867:3105318', 'assoc_mat': '31044708:carton:4230:31056820,31044709:carton:4230:31046333,31044710:carton:4230:31051506,31044711:carton:4230:31045330,31044712:carton:4230:31045365,31044713:carton:4230:31045403,31044714:carton:4230:31046081,31044715:carton:4230:31045458,31044716:carton:4230:31045489,31044717:carton:4230:31045528,31045590:carton:4230:31051557,31045591:carton:4230:31051592,31045592:carton:4230:31051631,31045593:carton:4230:31051663,31045594:carton:4230:31051697,31045595:carton:4230:31051777,31045596:carton:4230:31046002,31046064:carton:4230:31051747,31046065:carton:4230:31051813,31046066:carton:4230:31051859,31046295:carton:4230:31046786,31046296:carton:4230:31046821,31046297:carton:4230:31046862,31047156:carton:4230:31047788,31047158:carton:4230:31047826,31047159:carton:4230:31047861,31047160:carton:4230:31047895,31047161:carton:4230:31047930,31047162:carton:4230:31047958,31047281:carton:4230:31048000,31047282:carton:4230:31048035,31047283:carton:4230:31048083,31047335:carton:4230:31048112,31047336:carton:4230:31048143,3104'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010840947767881129, 'nb_photo': 477, 'list_port_cont': '31045329,31045371,31045397,31045447,31045482,31045532,31046004,31046084,31046317,31046773,31046810,31046850,31047775,31047823,31047855,31047919,31047968,31047999,31048068,31048106,31048147,31048188,31048223,31048268,31048298,31048364,31049446,31049518,31049542,31049923,31050429,31051266,31051502,31051548,31051584,31051630,31051668,31051733,31051817,31051861,31052989,31053030,31053055,31053139,31053182,31053661,31053746,31053791,31054258,31054299,31054586,31054624,31054674,31055070,31055110,31055142,31055470,31055919,31056088,31056546,31056573,31057102,31057267,31057509,31057769,31057859,31058281,31058523,31058741,31058824,31059063,31059974,31060071,31060292,31060904,31061101,31061312,31061598,31061752,31062034,31062249,31062529,31062604,31063144,31063646,31063870,31063904,31064260,31064380,31064737,31064992,31065258,31065277,31065791,31065884,31066454,31066579,31067114,31067160,31067455,31067797,31067834,31067910,31068185,31068422,31069146,31069416,31069651,31070299,31070371,31071092,31071381,31071620,3107168', 'assoc_port': '31044709:31046317,31044710:31051502,31044711:31045329,31044712:31045371,31044713:31045397,31044714:31046084,31044715:31045447,31044716:31045482,31044717:31045532,31045590:31051548,31045591:31051584,31045592:31051630,31045593:31051668,31045596:31046004,31046064:31051733,31046065:31051817,31046066:31051861,31046295:31046773,31046296:31046810,31046297:31046850,31047156:31047775,31047158:31047823,31047159:31047855,31047161:31047919,31047162:31047968,31047281:31047999,31047283:31048068,31047335:31048106,31047336:31048147,31047337:31048188,31047338:31048223,31047655:31048268,31047656:31048298,31047657:31048364,31049364:31049446,31049366:31049542,31049367:31049518,31049385:31049923,31050374:31050429,31051242:31051266,31052863:31052989,31052864:31053030,31052865:31053055,31052866:31053139,31052867:31053182,31053549:31053661,31053550:31053746,31053551:31053791,31053983:31054258,31053984:31054299,31054417:31054586,31054418:31054624,31054419:31054674,31054958:31055070,31054959:31055142,31054960:31055110,31055391:3105547', 'assoc_mat': '31044709:metal:4230:31046317,31044710:metal:4230:31051502,31044711:metal:4230:31045329,31044712:metal:4230:31045371,31044713:metal:4230:31045397,31044714:metal:4230:31046084,31044715:metal:4230:31045447,31044716:metal:4230:31045482,31044717:metal:4230:31045532,31045590:metal:4230:31051548,31045591:metal:4230:31051584,31045592:metal:4230:31051630,31045593:metal:4230:31051668,31045596:metal:4230:31046004,31046064:metal:4230:31051733,31046065:metal:4230:31051817,31046066:metal:4230:31051861,31046295:metal:4230:31046773,31046296:metal:4230:31046810,31046297:metal:4230:31046850,31047156:metal:4230:31047775,31047158:metal:4230:31047823,31047159:metal:4230:31047855,31047161:metal:4230:31047919,31047162:metal:4230:31047968,31047281:metal:4230:31047999,31047283:metal:4230:31048068,31047335:metal:4230:31048106,31047336:metal:4230:31048147,31047337:metal:4230:31048188,31047338:metal:4230:31048223,31047655:metal:4230:31048268,31047656:metal:4230:31048298,31047657:metal:4230:31048364,31049364:metal:4230:31049446,31049366:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16688144712453887, 'nb_photo': 146910, 'list_port_cont': '31045325,31045368,31045405,31045461,31045497,31045535,31046003,31046089,31046334,31046784,31046826,31046856,31047778,31047819,31047857,31047892,31047936,31047962,31048002,31048046,31048072,31048117,31048154,31048187,31048226,31048266,31048305,31048371,31048402,31049449,31049477,31049521,31049551,31049928,31050096,31050168,31050424,31050706,31050941,31050987,31051270,31051515,31051547,31051581,31051623,31051669,31051705,31051742,31051778,31051815,31051852,31052976,31053031,31053058,31053133,31053178,31053656,31053754,31053787,31054272,31054309,31054595,31054637,31054677,31055082,31055107,31055149,31055462,31055742,31055921,31056090,31056330,31056547,31056586,31056827,31057107,31057261,31057519,31057706,31057774,31057871,31058286,31058527,31058738,31058819,31059062,31059144,31059520,31059677,31059972,31060004,31060074,31060291,31060497,31060669,31060903,31061091,31061284,31061317,31061602,31061750,31062044,31062257,31062532,31062617,31063155,31063356,31063527,31063650,31063873,31063909,31064254,31064379,3106450', 'assoc_port': '31044708:31056827,31044709:31046334,31044710:31051515,31044711:31045325,31044712:31045368,31044713:31045405,31044714:31046089,31044715:31045461,31044716:31045497,31044717:31045535,31045590:31051547,31045591:31051581,31045592:31051623,31045593:31051669,31045594:31051705,31045595:31051778,31045596:31046003,31046064:31051742,31046065:31051815,31046066:31051852,31046295:31046784,31046296:31046826,31046297:31046856,31047156:31047778,31047158:31047819,31047159:31047857,31047160:31047892,31047161:31047936,31047162:31047962,31047281:31048002,31047282:31048046,31047283:31048072,31047335:31048117,31047336:31048154,31047337:31048187,31047338:31048226,31047655:31048266,31047656:31048305,31047657:31048371,31047658:31048402,31049364:31049449,31049365:31049477,31049366:31049551,31049367:31049521,31049385:31049928,31050029:31050096,31050030:31050168,31050374:31050424,31050605:31050706,31050879:31050941,31050880:31050987,31051242:31051270,31052863:31052976,31052864:31053031,31052865:31053058,31052866:31053133,31052867:3105317', 'assoc_mat': '31044708:papier:4230:31056827,31044709:papier:4230:31046334,31044710:papier:4230:31051515,31044711:papier:4230:31045325,31044712:papier:4230:31045368,31044713:papier:4230:31045405,31044714:papier:4230:31046089,31044715:papier:4230:31045461,31044716:papier:4230:31045497,31044717:papier:4230:31045535,31045590:papier:4230:31051547,31045591:papier:4230:31051581,31045592:papier:4230:31051623,31045593:papier:4230:31051669,31045594:papier:4230:31051705,31045595:papier:4230:31051778,31045596:papier:4230:31046003,31046064:papier:4230:31051742,31046065:papier:4230:31051815,31046066:papier:4230:31051852,31046295:papier:4230:31046784,31046296:papier:4230:31046826,31046297:papier:4230:31046856,31047156:papier:4230:31047778,31047158:papier:4230:31047819,31047159:papier:4230:31047857,31047160:papier:4230:31047892,31047161:papier:4230:31047936,31047162:papier:4230:31047962,31047281:papier:4230:31048002,31047282:papier:4230:31048046,31047283:papier:4230:31048072,31047335:papier:4230:31048117,31047336:papier:4230:31048154,3104'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003579996038482788, 'nb_photo': 657, 'list_port_cont': '31045323,31045370,31045408,31045453,31045492,31045530,31046086,31046328,31046789,31046813,31047789,31047821,31047969,31048006,31048047,31048153,31048190,31048224,31048255,31048292,31049439,31049480,31049550,31049930,31050098,31050169,31050438,31050951,31050990,31051265,31051514,31051558,31051591,31051622,31051670,31051702,31051779,31051820,31051856,31052986,31053025,31053065,31053131,31053755,31053799,31054270,31054678,31055071,31057116,31057273,31057520,31057714,31057763,31057875,31058293,31058530,31058735,31058821,31059141,31059509,31059973,31060067,31060498,31060665,31060893,31061285,31061589,31061761,31062042,31062618,31063158,31063363,31063526,31063654,31063864,31063916,31064504,31064744,31066459,31066505,31066584,31067851,31068428,31068618,31070151,31070308,31070379,31070576,31070855,31071388,31071608,31071686,31071979,31072284,31072520,31072689,31072924,31072970,31073354,31074121,31074242,31074784,31075032,31075570,31075650,31075911,31076143,31076371,31076609,31076890,31077048,31077215,31077449,3107764', 'assoc_port': '31044709:31046328,31044710:31051514,31044711:31045323,31044712:31045370,31044713:31045408,31044714:31046086,31044715:31045453,31044716:31045492,31044717:31045530,31045590:31051558,31045591:31051591,31045592:31051622,31045593:31051670,31045594:31051702,31045595:31051779,31046065:31051820,31046066:31051856,31046295:31046789,31046296:31046813,31047156:31047789,31047158:31047821,31047162:31047969,31047281:31048006,31047282:31048047,31047336:31048153,31047337:31048190,31047338:31048224,31047655:31048255,31047656:31048292,31049364:31049439,31049365:31049480,31049366:31049550,31049385:31049930,31050029:31050098,31050030:31050169,31050374:31050438,31050879:31050951,31050880:31050990,31051242:31051265,31052863:31052986,31052864:31053025,31052865:31053065,31052866:31053131,31053550:31053755,31053551:31053799,31053983:31054270,31054419:31054678,31054958:31055071,31056721:31057714,31057007:31057116,31057171:31057273,31057400:31057520,31057736:31057763,31057737:31057875,31058058:31058735,31058218:31058293,31058398:3105853', 'assoc_mat': '31044709:pehd:4230:31046328,31044710:pehd:4230:31051514,31044711:pehd:4230:31045323,31044712:pehd:4230:31045370,31044713:pehd:4230:31045408,31044714:pehd:4230:31046086,31044715:pehd:4230:31045453,31044716:pehd:4230:31045492,31044717:pehd:4230:31045530,31045590:pehd:4230:31051558,31045591:pehd:4230:31051591,31045592:pehd:4230:31051622,31045593:pehd:4230:31051670,31045594:pehd:4230:31051702,31045595:pehd:4230:31051779,31046065:pehd:4230:31051820,31046066:pehd:4230:31051856,31046295:pehd:4230:31046789,31046296:pehd:4230:31046813,31047156:pehd:4230:31047789,31047158:pehd:4230:31047821,31047162:pehd:4230:31047969,31047281:pehd:4230:31048006,31047282:pehd:4230:31048047,31047336:pehd:4230:31048153,31047337:pehd:4230:31048190,31047338:pehd:4230:31048224,31047655:pehd:4230:31048255,31047656:pehd:4230:31048292,31049364:pehd:4230:31049439,31049365:pehd:4230:31049480,31049366:pehd:4230:31049550,31049385:pehd:4230:31049930,31050029:pehd:4230:31050098,31050030:pehd:4230:31050169,31050374:pehd:4230:31050438,31050879:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01869743690711632, 'nb_photo': 7138, 'list_port_cont': '31045336,31045367,31045404,31045454,31045491,31045533,31046001,31046091,31046326,31046788,31046822,31046854,31047786,31047817,31047858,31047891,31047924,31047970,31048008,31048037,31048081,31048115,31048144,31048186,31048229,31048264,31048303,31048367,31048415,31049440,31049476,31049510,31049559,31049931,31050093,31050170,31050432,31050704,31050942,31050989,31051271,31051513,31051554,31051595,31051617,31051667,31051703,31051743,31051776,31051819,31051848,31052979,31053027,31053054,31053130,31053173,31053659,31053763,31053786,31054267,31054314,31054598,31054625,31054682,31055074,31055117,31055155,31055475,31055750,31055908,31056080,31056334,31056543,31056581,31056830,31057115,31057275,31057522,31057713,31057765,31057870,31058292,31058537,31058731,31058822,31059060,31059146,31059507,31059679,31059968,31060011,31060077,31060286,31060504,31060655,31060896,31061102,31061273,31061315,31061596,31061760,31062045,31062260,31062526,31062609,31063151,31063362,31063529,31063658,31063872,31063911,31064263,31064381,3106450', 'assoc_port': '31044708:31056830,31044709:31046326,31044710:31051513,31044711:31045336,31044712:31045367,31044713:31045404,31044714:31046091,31044715:31045454,31044716:31045491,31044717:31045533,31045590:31051554,31045591:31051595,31045592:31051617,31045593:31051667,31045594:31051703,31045595:31051776,31045596:31046001,31046064:31051743,31046065:31051819,31046066:31051848,31046295:31046788,31046296:31046822,31046297:31046854,31047156:31047786,31047158:31047817,31047159:31047858,31047160:31047891,31047161:31047924,31047162:31047970,31047281:31048008,31047282:31048037,31047283:31048081,31047335:31048115,31047336:31048144,31047337:31048186,31047338:31048229,31047655:31048264,31047656:31048303,31047657:31048367,31047658:31048415,31049364:31049440,31049365:31049476,31049366:31049559,31049367:31049510,31049385:31049931,31050029:31050093,31050030:31050170,31050374:31050432,31050605:31050704,31050879:31050942,31050880:31050989,31051242:31051271,31052863:31052979,31052864:31053027,31052865:31053054,31052866:31053130,31052867:3105317', 'assoc_mat': '31044708:pet_clair:4230:31056830,31044709:pet_clair:4230:31046326,31044710:pet_clair:4230:31051513,31044711:pet_clair:4230:31045336,31044712:pet_clair:4230:31045367,31044713:pet_clair:4230:31045404,31044714:pet_clair:4230:31046091,31044715:pet_clair:4230:31045454,31044716:pet_clair:4230:31045491,31044717:pet_clair:4230:31045533,31045590:pet_clair:4230:31051554,31045591:pet_clair:4230:31051595,31045592:pet_clair:4230:31051617,31045593:pet_clair:4230:31051667,31045594:pet_clair:4230:31051703,31045595:pet_clair:4230:31051776,31045596:pet_clair:4230:31046001,31046064:pet_clair:4230:31051743,31046065:pet_clair:4230:31051819,31046066:pet_clair:4230:31051848,31046295:pet_clair:4230:31046788,31046296:pet_clair:4230:31046822,31046297:pet_clair:4230:31046854,31047156:pet_clair:4230:31047786,31047158:pet_clair:4230:31047817,31047159:pet_clair:4230:31047858,31047160:pet_clair:4230:31047891,31047161:pet_clair:4230:31047924,31047162:pet_clair:4230:31047970,31047281:pet_clair:4230:31048008,31047282:pet_clair:4230:31048037,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0016432782734386794, 'nb_photo': 281, 'list_port_cont': '31045360,31045402,31045456,31045493,31045527,31046085,31046327,31046855,31047932,31047972,31048038,31048119,31049517,31050094,31050165,31050708,31050979,31051275,31051508,31051550,31051629,31051660,31051707,31051741,31051784,31051851,31052990,31053029,31053059,31053136,31053171,31053649,31053759,31053794,31056082,31056328,31056549,31056579,31056828,31057112,31057270,31057510,31057703,31057773,31057873,31058287,31058736,31058816,31059971,31060293,31060901,31061597,31061756,31062041,31062261,31062537,31062613,31063157,31063359,31063528,31063655,31063913,31064252,31064375,31064745,31064998,31065327,31065885,31065918,31067128,31067847,31068195,31068744,31069152,31070143,31070298,31070859,31071098,31071375,31071611,31071694,31071972,31072287,31072522,31072934,31072971,31073773,31075021,31075253,31075569,31075642,31076146,31076360,31076604,31076887,31077049,31077213,31077460,31077634,31077873,31078216,31078413,31078633,31078839,31078873,31079233,31079457,31079665,31079889,31080170,31080410,31080702,31081186', 'assoc_port': '31044708:31056828,31044709:31046327,31044710:31051508,31044712:31045360,31044713:31045402,31044714:31046085,31044715:31045456,31044716:31045493,31044717:31045527,31045590:31051550,31045592:31051629,31045593:31051660,31045594:31051707,31045595:31051784,31046064:31051741,31046066:31051851,31046297:31046855,31047161:31047932,31047162:31047972,31047282:31048038,31047335:31048119,31049367:31049517,31050029:31050094,31050030:31050165,31050605:31050708,31050880:31050979,31051242:31051275,31052863:31052990,31052864:31053029,31052865:31053059,31052866:31053136,31052867:31053171,31053549:31053649,31053550:31053759,31053551:31053794,31056017:31056082,31056238:31056328,31056471:31056549,31056473:31056579,31056721:31057703,31057007:31057112,31057171:31057270,31057400:31057510,31057736:31057773,31057737:31057873,31058058:31058736,31058218:31058287,31058621:31058816,31059661:31059971,31060226:31060293,31060802:31060901,31061534:31061597,31061703:31061756,31061977:31062041,31062153:31062261,31062439:31062537,31062440:3106261', 'assoc_mat': '31044708:pet_fonce:4230:31056828,31044709:pet_fonce:4230:31046327,31044710:pet_fonce:4230:31051508,31044712:pet_fonce:4230:31045360,31044713:pet_fonce:4230:31045402,31044714:pet_fonce:4230:31046085,31044715:pet_fonce:4230:31045456,31044716:pet_fonce:4230:31045493,31044717:pet_fonce:4230:31045527,31045590:pet_fonce:4230:31051550,31045592:pet_fonce:4230:31051629,31045593:pet_fonce:4230:31051660,31045594:pet_fonce:4230:31051707,31045595:pet_fonce:4230:31051784,31046064:pet_fonce:4230:31051741,31046066:pet_fonce:4230:31051851,31046297:pet_fonce:4230:31046855,31047161:pet_fonce:4230:31047932,31047162:pet_fonce:4230:31047972,31047282:pet_fonce:4230:31048038,31047335:pet_fonce:4230:31048119,31049367:pet_fonce:4230:31049517,31050029:pet_fonce:4230:31050094,31050030:pet_fonce:4230:31050165,31050605:pet_fonce:4230:31050708,31050880:pet_fonce:4230:31050979,31051242:pet_fonce:4230:31051275,31052863:pet_fonce:4230:31052990,31052864:pet_fonce:4230:31053029,31052865:pet_fonce:4230:31053059,31052866:pet_fonce:4230:31053136,3'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(2986784,2986988,2987464,2988030,2988554,2988976,2989494,2989940,2990146)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081554, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045334,31045366,31045407,31045455,31045486,31045523,31045992,31046082,31046321,31046785,31046816,31046852,31047779,31047816,31047845,31047882,31047931,31047964,31048007,31048044,31048067,31048108,31048146,31048183,31048225,31048256,31048291,31048374,31048404,31049443,31049479,31049508,31049549,31049925,31050097,31050154,31050423,31050691,31050950,31050983,31051273,31051519,31051556,31051582,31051628,31051656,31051691,31051748,31051771,31051821,31051849,31052984,31053024,31053066,31053134,31053168,31053645,31053749,31053784,31054273,31054308,31054585,31054626,31054671,31055073,31055118,31055145,31055468,31055739,31055912,31056073,31056332,31056550,31056570,31056825,31057108,31057263,31057511,31057709,31057759,31057866,31058280,31058534,31058728,31058812,31059058,31059132,31059519,31059681,31059970,31060073,31060287,31060494,31060659,31060889,31061095,31061269,31061307,31061595,31061753,31062040,31062256,31062528,31062614,31063150,31063360,31063521,31063657,31063868,31063912,31064248,31064371,31064500,3106470 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081555, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045330,31045365,31045403,31045458,31045489,31045528,31046002,31046081,31046333,31046786,31046821,31046862,31047788,31047826,31047861,31047895,31047930,31047958,31048000,31048035,31048083,31048112,31048143,31048182,31048228,31048265,31048301,31048369,31048408,31049441,31049485,31049505,31049553,31049927,31050095,31050166,31050434,31050700,31050946,31050976,31051277,31051506,31051557,31051592,31051631,31051663,31051697,31051747,31051777,31051813,31051859,31052988,31053021,31053061,31053140,31053180,31053660,31053761,31053793,31054268,31054305,31054597,31054639,31054675,31055083,31055112,31055154,31055472,31055748,31055917,31056077,31056336,31056541,31056578,31056820,31057111,31057274,31057517,31057712,31057770,31057872,31058291,31058539,31058740,31058820,31059072,31059134,31059510,31059672,31059964,31060003,31060070,31060297,31060506,31060668,31060899,31061099,31061283,31061319,31061603,31061759,31062038,31062252,31062536,31062607,31063152,31063354,31063523,31063656,31063871,31063903,31064257,31064382,3106450 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081556, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045329,31045371,31045397,31045447,31045482,31045532,31046004,31046084,31046317,31046773,31046810,31046850,31047775,31047823,31047855,31047919,31047968,31047999,31048068,31048106,31048147,31048188,31048223,31048268,31048298,31048364,31049446,31049518,31049542,31049923,31050429,31051266,31051502,31051548,31051584,31051630,31051668,31051733,31051817,31051861,31052989,31053030,31053055,31053139,31053182,31053661,31053746,31053791,31054258,31054299,31054586,31054624,31054674,31055070,31055110,31055142,31055470,31055919,31056088,31056546,31056573,31057102,31057267,31057509,31057769,31057859,31058281,31058523,31058741,31058824,31059063,31059974,31060071,31060292,31060904,31061101,31061312,31061598,31061752,31062034,31062249,31062529,31062604,31063144,31063646,31063870,31063904,31064260,31064380,31064737,31064992,31065258,31065277,31065791,31065884,31066454,31066579,31067114,31067160,31067455,31067797,31067834,31067910,31068185,31068422,31069146,31069416,31069651,31070299,31070371,31071092,31071381,31071620,3107168 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081557, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045325,31045368,31045405,31045461,31045497,31045535,31046003,31046089,31046334,31046784,31046826,31046856,31047778,31047819,31047857,31047892,31047936,31047962,31048002,31048046,31048072,31048117,31048154,31048187,31048226,31048266,31048305,31048371,31048402,31049449,31049477,31049521,31049551,31049928,31050096,31050168,31050424,31050706,31050941,31050987,31051270,31051515,31051547,31051581,31051623,31051669,31051705,31051742,31051778,31051815,31051852,31052976,31053031,31053058,31053133,31053178,31053656,31053754,31053787,31054272,31054309,31054595,31054637,31054677,31055082,31055107,31055149,31055462,31055742,31055921,31056090,31056330,31056547,31056586,31056827,31057107,31057261,31057519,31057706,31057774,31057871,31058286,31058527,31058738,31058819,31059062,31059144,31059520,31059677,31059972,31060004,31060074,31060291,31060497,31060669,31060903,31061091,31061284,31061317,31061602,31061750,31062044,31062257,31062532,31062617,31063155,31063356,31063527,31063650,31063873,31063909,31064254,31064379,3106450 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081558, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045323,31045370,31045408,31045453,31045492,31045530,31046086,31046328,31046789,31046813,31047789,31047821,31047969,31048006,31048047,31048153,31048190,31048224,31048255,31048292,31049439,31049480,31049550,31049930,31050098,31050169,31050438,31050951,31050990,31051265,31051514,31051558,31051591,31051622,31051670,31051702,31051779,31051820,31051856,31052986,31053025,31053065,31053131,31053755,31053799,31054270,31054678,31055071,31057116,31057273,31057520,31057714,31057763,31057875,31058293,31058530,31058735,31058821,31059141,31059509,31059973,31060067,31060498,31060665,31060893,31061285,31061589,31061761,31062042,31062618,31063158,31063363,31063526,31063654,31063864,31063916,31064504,31064744,31066459,31066505,31066584,31067851,31068428,31068618,31070151,31070308,31070379,31070576,31070855,31071388,31071608,31071686,31071979,31072284,31072520,31072689,31072924,31072970,31073354,31074121,31074242,31074784,31075032,31075570,31075650,31075911,31076143,31076371,31076609,31076890,31077048,31077215,31077449,3107764 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081559, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045336,31045367,31045404,31045454,31045491,31045533,31046001,31046091,31046326,31046788,31046822,31046854,31047786,31047817,31047858,31047891,31047924,31047970,31048008,31048037,31048081,31048115,31048144,31048186,31048229,31048264,31048303,31048367,31048415,31049440,31049476,31049510,31049559,31049931,31050093,31050170,31050432,31050704,31050942,31050989,31051271,31051513,31051554,31051595,31051617,31051667,31051703,31051743,31051776,31051819,31051848,31052979,31053027,31053054,31053130,31053173,31053659,31053763,31053786,31054267,31054314,31054598,31054625,31054682,31055074,31055117,31055155,31055475,31055750,31055908,31056080,31056334,31056543,31056581,31056830,31057115,31057275,31057522,31057713,31057765,31057870,31058292,31058537,31058731,31058822,31059060,31059146,31059507,31059679,31059968,31060011,31060077,31060286,31060504,31060655,31060896,31061102,31061273,31061315,31061596,31061760,31062045,31062260,31062526,31062609,31063151,31063362,31063529,31063658,31063872,31063911,31064263,31064381,3106450 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081560, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045360,31045402,31045456,31045493,31045527,31046085,31046327,31046855,31047932,31047972,31048038,31048119,31049517,31050094,31050165,31050708,31050979,31051275,31051508,31051550,31051629,31051660,31051707,31051741,31051784,31051851,31052990,31053029,31053059,31053136,31053171,31053649,31053759,31053794,31056082,31056328,31056549,31056579,31056828,31057112,31057270,31057510,31057703,31057773,31057873,31058287,31058736,31058816,31059971,31060293,31060901,31061597,31061756,31062041,31062261,31062537,31062613,31063157,31063359,31063528,31063655,31063913,31064252,31064375,31064745,31064998,31065327,31065885,31065918,31067128,31067847,31068195,31068744,31069152,31070143,31070298,31070859,31071098,31071375,31071611,31071694,31071972,31072287,31072522,31072934,31072971,31073773,31075021,31075253,31075569,31075642,31076146,31076360,31076604,31076887,31077049,31077213,31077460,31077634,31077873,31078216,31078413,31078633,31078839,31078873,31079233,31079457,31079665,31079889,31080170,31080410,31080702,31081186 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31081554,31081555,31081556,31081557,31081558,31081559,31081560?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2026-05-01' and date <= '2026-05-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((703,),), 'unwanted_material_monthly_percentage': ((0.7869534073300316,),), 'material_repartition': (('incineration', 703),), 'material_dict': {'incineration': 703}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 5, 9), 0.7314678600477017, 1), (datetime.date(2026, 5, 10), 0.7978820747930804, 3), (datetime.date(2026, 5, 11), 0.809549608663312, 4), (datetime.date(2026, 5, 12), 0.8320448741535217, 3), (datetime.date(2026, 5, 13), 0.7940725996229108, 4), (datetime.date(2026, 5, 14), 0.8345934495224177, 4), (datetime.date(2026, 5, 15), 0.8160990689054678, 3), (datetime.date(2026, 5, 16), 0.6986428269389483, 4), (datetime.date(2026, 5, 17), 0.72033516947332, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 5, 9), 0.7314678600477017, 1), (datetime.date(2026, 5, 10), 0.7978820747930804, 3), (datetime.date(2026, 5, 11), 0.809549608663312, 4), (datetime.date(2026, 5, 12), 0.8320448741535217, 3), (datetime.date(2026, 5, 13), 0.7940725996229108, 4), (datetime.date(2026, 5, 14), 0.8345934495224177, 4), (datetime.date(2026, 5, 15), 0.8160990689054678, 3), (datetime.date(2026, 5, 16), 0.6986428269389483, 4), (datetime.date(2026, 5, 17), 0.72033516947332, 3))}, 'quality_array': [['-8.119855299263582', '09052026'], ['-7.533130618852553', '10052026'], ['-7.7276414927526105', '11052026'], ['-7.501854631720644', '12052026'], ['-7.705057532501817', '13052026'], ['-7.72437595231998', '14052026'], ['-7.632140033614754', '15052026'], ['-7.945496573301978', '16052026'], ['-8.208203444687102', '17052026']], 'number_of_batch': ((200,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010868579867819453, 'nb_photo': 5594, 'list_port_cont': '31045334,31045366,31045407,31045455,31045486,31045523,31045992,31046082,31046321,31046785,31046816,31046852,31047779,31047816,31047845,31047882,31047931,31047964,31048007,31048044,31048067,31048108,31048146,31048183,31048225,31048256,31048291,31048374,31048404,31049443,31049479,31049508,31049549,31049925,31050097,31050154,31050423,31050691,31050950,31050983,31051273,31051519,31051556,31051582,31051628,31051656,31051691,31051748,31051771,31051821,31051849,31052984,31053024,31053066,31053134,31053168,31053645,31053749,31053784,31054273,31054308,31054585,31054626,31054671,31055073,31055118,31055145,31055468,31055739,31055912,31056073,31056332,31056550,31056570,31056825,31057108,31057263,31057511,31057709,31057759,31057866,31058280,31058534,31058728,31058812,31059058,31059132,31059519,31059681,31059970,31060073,31060287,31060494,31060659,31060889,31061095,31061269,31061307,31061595,31061753,31062040,31062256,31062528,31062614,31063150,31063360,31063521,31063657,31063868,31063912,31064248,31064371,31064500,3106470', 'assoc_port': '31044708:31056825,31044709:31046321,31044710:31051519,31044711:31045334,31044712:31045366,31044713:31045407,31044714:31046082,31044715:31045455,31044716:31045486,31044717:31045523,31045590:31051556,31045591:31051582,31045592:31051628,31045593:31051656,31045594:31051691,31045595:31051771,31045596:31045992,31046064:31051748,31046065:31051821,31046066:31051849,31046295:31046785,31046296:31046816,31046297:31046852,31047156:31047779,31047158:31047816,31047159:31047845,31047160:31047882,31047161:31047931,31047162:31047964,31047281:31048007,31047282:31048044,31047283:31048067,31047335:31048108,31047336:31048146,31047337:31048183,31047338:31048225,31047655:31048256,31047656:31048291,31047657:31048374,31047658:31048404,31049364:31049443,31049365:31049479,31049366:31049549,31049367:31049508,31049385:31049925,31050029:31050097,31050030:31050154,31050374:31050423,31050605:31050691,31050879:31050950,31050880:31050983,31051242:31051273,31052863:31052984,31052864:31053024,31052865:31053066,31052866:31053134,31052867:3105316', 'assoc_mat': '31044708:autre:4230:31056825,31044709:autre:4230:31046321,31044710:autre:4230:31051519,31044711:autre:4230:31045334,31044712:autre:4230:31045366,31044713:autre:4230:31045407,31044714:autre:4230:31046082,31044715:autre:4230:31045455,31044716:autre:4230:31045486,31044717:autre:4230:31045523,31045590:autre:4230:31051556,31045591:autre:4230:31051582,31045592:autre:4230:31051628,31045593:autre:4230:31051656,31045594:autre:4230:31051691,31045595:autre:4230:31051771,31045596:autre:4230:31045992,31046064:autre:4230:31051748,31046065:autre:4230:31051821,31046066:autre:4230:31051849,31046295:autre:4230:31046785,31046296:autre:4230:31046816,31046297:autre:4230:31046852,31047156:autre:4230:31047779,31047158:autre:4230:31047816,31047159:autre:4230:31047845,31047160:autre:4230:31047882,31047161:autre:4230:31047931,31047162:autre:4230:31047964,31047281:autre:4230:31048007,31047282:autre:4230:31048044,31047283:autre:4230:31048067,31047335:autre:4230:31048108,31047336:autre:4230:31048146,31047337:autre:4230:31048183,31047338:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03848269750496583, 'nb_photo': 25658, 'list_port_cont': '31045330,31045365,31045403,31045458,31045489,31045528,31046002,31046081,31046333,31046786,31046821,31046862,31047788,31047826,31047861,31047895,31047930,31047958,31048000,31048035,31048083,31048112,31048143,31048182,31048228,31048265,31048301,31048369,31048408,31049441,31049485,31049505,31049553,31049927,31050095,31050166,31050434,31050700,31050946,31050976,31051277,31051506,31051557,31051592,31051631,31051663,31051697,31051747,31051777,31051813,31051859,31052988,31053021,31053061,31053140,31053180,31053660,31053761,31053793,31054268,31054305,31054597,31054639,31054675,31055083,31055112,31055154,31055472,31055748,31055917,31056077,31056336,31056541,31056578,31056820,31057111,31057274,31057517,31057712,31057770,31057872,31058291,31058539,31058740,31058820,31059072,31059134,31059510,31059672,31059964,31060003,31060070,31060297,31060506,31060668,31060899,31061099,31061283,31061319,31061603,31061759,31062038,31062252,31062536,31062607,31063152,31063354,31063523,31063656,31063871,31063903,31064257,31064382,3106450', 'assoc_port': '31044708:31056820,31044709:31046333,31044710:31051506,31044711:31045330,31044712:31045365,31044713:31045403,31044714:31046081,31044715:31045458,31044716:31045489,31044717:31045528,31045590:31051557,31045591:31051592,31045592:31051631,31045593:31051663,31045594:31051697,31045595:31051777,31045596:31046002,31046064:31051747,31046065:31051813,31046066:31051859,31046295:31046786,31046296:31046821,31046297:31046862,31047156:31047788,31047158:31047826,31047159:31047861,31047160:31047895,31047161:31047930,31047162:31047958,31047281:31048000,31047282:31048035,31047283:31048083,31047335:31048112,31047336:31048143,31047337:31048182,31047338:31048228,31047655:31048265,31047656:31048301,31047657:31048369,31047658:31048408,31049364:31049441,31049365:31049485,31049366:31049553,31049367:31049505,31049385:31049927,31050029:31050095,31050030:31050166,31050374:31050434,31050605:31050700,31050879:31050946,31050880:31050976,31051242:31051277,31052863:31052988,31052864:31053021,31052865:31053061,31052866:31053140,31052867:3105318', 'assoc_mat': '31044708:carton:4230:31056820,31044709:carton:4230:31046333,31044710:carton:4230:31051506,31044711:carton:4230:31045330,31044712:carton:4230:31045365,31044713:carton:4230:31045403,31044714:carton:4230:31046081,31044715:carton:4230:31045458,31044716:carton:4230:31045489,31044717:carton:4230:31045528,31045590:carton:4230:31051557,31045591:carton:4230:31051592,31045592:carton:4230:31051631,31045593:carton:4230:31051663,31045594:carton:4230:31051697,31045595:carton:4230:31051777,31045596:carton:4230:31046002,31046064:carton:4230:31051747,31046065:carton:4230:31051813,31046066:carton:4230:31051859,31046295:carton:4230:31046786,31046296:carton:4230:31046821,31046297:carton:4230:31046862,31047156:carton:4230:31047788,31047158:carton:4230:31047826,31047159:carton:4230:31047861,31047160:carton:4230:31047895,31047161:carton:4230:31047930,31047162:carton:4230:31047958,31047281:carton:4230:31048000,31047282:carton:4230:31048035,31047283:carton:4230:31048083,31047335:carton:4230:31048112,31047336:carton:4230:31048143,3104'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010840947767881129, 'nb_photo': 477, 'list_port_cont': '31045329,31045371,31045397,31045447,31045482,31045532,31046004,31046084,31046317,31046773,31046810,31046850,31047775,31047823,31047855,31047919,31047968,31047999,31048068,31048106,31048147,31048188,31048223,31048268,31048298,31048364,31049446,31049518,31049542,31049923,31050429,31051266,31051502,31051548,31051584,31051630,31051668,31051733,31051817,31051861,31052989,31053030,31053055,31053139,31053182,31053661,31053746,31053791,31054258,31054299,31054586,31054624,31054674,31055070,31055110,31055142,31055470,31055919,31056088,31056546,31056573,31057102,31057267,31057509,31057769,31057859,31058281,31058523,31058741,31058824,31059063,31059974,31060071,31060292,31060904,31061101,31061312,31061598,31061752,31062034,31062249,31062529,31062604,31063144,31063646,31063870,31063904,31064260,31064380,31064737,31064992,31065258,31065277,31065791,31065884,31066454,31066579,31067114,31067160,31067455,31067797,31067834,31067910,31068185,31068422,31069146,31069416,31069651,31070299,31070371,31071092,31071381,31071620,3107168', 'assoc_port': '31044709:31046317,31044710:31051502,31044711:31045329,31044712:31045371,31044713:31045397,31044714:31046084,31044715:31045447,31044716:31045482,31044717:31045532,31045590:31051548,31045591:31051584,31045592:31051630,31045593:31051668,31045596:31046004,31046064:31051733,31046065:31051817,31046066:31051861,31046295:31046773,31046296:31046810,31046297:31046850,31047156:31047775,31047158:31047823,31047159:31047855,31047161:31047919,31047162:31047968,31047281:31047999,31047283:31048068,31047335:31048106,31047336:31048147,31047337:31048188,31047338:31048223,31047655:31048268,31047656:31048298,31047657:31048364,31049364:31049446,31049366:31049542,31049367:31049518,31049385:31049923,31050374:31050429,31051242:31051266,31052863:31052989,31052864:31053030,31052865:31053055,31052866:31053139,31052867:31053182,31053549:31053661,31053550:31053746,31053551:31053791,31053983:31054258,31053984:31054299,31054417:31054586,31054418:31054624,31054419:31054674,31054958:31055070,31054959:31055142,31054960:31055110,31055391:3105547', 'assoc_mat': '31044709:metal:4230:31046317,31044710:metal:4230:31051502,31044711:metal:4230:31045329,31044712:metal:4230:31045371,31044713:metal:4230:31045397,31044714:metal:4230:31046084,31044715:metal:4230:31045447,31044716:metal:4230:31045482,31044717:metal:4230:31045532,31045590:metal:4230:31051548,31045591:metal:4230:31051584,31045592:metal:4230:31051630,31045593:metal:4230:31051668,31045596:metal:4230:31046004,31046064:metal:4230:31051733,31046065:metal:4230:31051817,31046066:metal:4230:31051861,31046295:metal:4230:31046773,31046296:metal:4230:31046810,31046297:metal:4230:31046850,31047156:metal:4230:31047775,31047158:metal:4230:31047823,31047159:metal:4230:31047855,31047161:metal:4230:31047919,31047162:metal:4230:31047968,31047281:metal:4230:31047999,31047283:metal:4230:31048068,31047335:metal:4230:31048106,31047336:metal:4230:31048147,31047337:metal:4230:31048188,31047338:metal:4230:31048223,31047655:metal:4230:31048268,31047656:metal:4230:31048298,31047657:metal:4230:31048364,31049364:metal:4230:31049446,31049366:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16688144712453887, 'nb_photo': 146910, 'list_port_cont': '31045325,31045368,31045405,31045461,31045497,31045535,31046003,31046089,31046334,31046784,31046826,31046856,31047778,31047819,31047857,31047892,31047936,31047962,31048002,31048046,31048072,31048117,31048154,31048187,31048226,31048266,31048305,31048371,31048402,31049449,31049477,31049521,31049551,31049928,31050096,31050168,31050424,31050706,31050941,31050987,31051270,31051515,31051547,31051581,31051623,31051669,31051705,31051742,31051778,31051815,31051852,31052976,31053031,31053058,31053133,31053178,31053656,31053754,31053787,31054272,31054309,31054595,31054637,31054677,31055082,31055107,31055149,31055462,31055742,31055921,31056090,31056330,31056547,31056586,31056827,31057107,31057261,31057519,31057706,31057774,31057871,31058286,31058527,31058738,31058819,31059062,31059144,31059520,31059677,31059972,31060004,31060074,31060291,31060497,31060669,31060903,31061091,31061284,31061317,31061602,31061750,31062044,31062257,31062532,31062617,31063155,31063356,31063527,31063650,31063873,31063909,31064254,31064379,3106450', 'assoc_port': '31044708:31056827,31044709:31046334,31044710:31051515,31044711:31045325,31044712:31045368,31044713:31045405,31044714:31046089,31044715:31045461,31044716:31045497,31044717:31045535,31045590:31051547,31045591:31051581,31045592:31051623,31045593:31051669,31045594:31051705,31045595:31051778,31045596:31046003,31046064:31051742,31046065:31051815,31046066:31051852,31046295:31046784,31046296:31046826,31046297:31046856,31047156:31047778,31047158:31047819,31047159:31047857,31047160:31047892,31047161:31047936,31047162:31047962,31047281:31048002,31047282:31048046,31047283:31048072,31047335:31048117,31047336:31048154,31047337:31048187,31047338:31048226,31047655:31048266,31047656:31048305,31047657:31048371,31047658:31048402,31049364:31049449,31049365:31049477,31049366:31049551,31049367:31049521,31049385:31049928,31050029:31050096,31050030:31050168,31050374:31050424,31050605:31050706,31050879:31050941,31050880:31050987,31051242:31051270,31052863:31052976,31052864:31053031,31052865:31053058,31052866:31053133,31052867:3105317', 'assoc_mat': '31044708:papier:4230:31056827,31044709:papier:4230:31046334,31044710:papier:4230:31051515,31044711:papier:4230:31045325,31044712:papier:4230:31045368,31044713:papier:4230:31045405,31044714:papier:4230:31046089,31044715:papier:4230:31045461,31044716:papier:4230:31045497,31044717:papier:4230:31045535,31045590:papier:4230:31051547,31045591:papier:4230:31051581,31045592:papier:4230:31051623,31045593:papier:4230:31051669,31045594:papier:4230:31051705,31045595:papier:4230:31051778,31045596:papier:4230:31046003,31046064:papier:4230:31051742,31046065:papier:4230:31051815,31046066:papier:4230:31051852,31046295:papier:4230:31046784,31046296:papier:4230:31046826,31046297:papier:4230:31046856,31047156:papier:4230:31047778,31047158:papier:4230:31047819,31047159:papier:4230:31047857,31047160:papier:4230:31047892,31047161:papier:4230:31047936,31047162:papier:4230:31047962,31047281:papier:4230:31048002,31047282:papier:4230:31048046,31047283:papier:4230:31048072,31047335:papier:4230:31048117,31047336:papier:4230:31048154,3104'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003579996038482788, 'nb_photo': 657, 'list_port_cont': '31045323,31045370,31045408,31045453,31045492,31045530,31046086,31046328,31046789,31046813,31047789,31047821,31047969,31048006,31048047,31048153,31048190,31048224,31048255,31048292,31049439,31049480,31049550,31049930,31050098,31050169,31050438,31050951,31050990,31051265,31051514,31051558,31051591,31051622,31051670,31051702,31051779,31051820,31051856,31052986,31053025,31053065,31053131,31053755,31053799,31054270,31054678,31055071,31057116,31057273,31057520,31057714,31057763,31057875,31058293,31058530,31058735,31058821,31059141,31059509,31059973,31060067,31060498,31060665,31060893,31061285,31061589,31061761,31062042,31062618,31063158,31063363,31063526,31063654,31063864,31063916,31064504,31064744,31066459,31066505,31066584,31067851,31068428,31068618,31070151,31070308,31070379,31070576,31070855,31071388,31071608,31071686,31071979,31072284,31072520,31072689,31072924,31072970,31073354,31074121,31074242,31074784,31075032,31075570,31075650,31075911,31076143,31076371,31076609,31076890,31077048,31077215,31077449,3107764', 'assoc_port': '31044709:31046328,31044710:31051514,31044711:31045323,31044712:31045370,31044713:31045408,31044714:31046086,31044715:31045453,31044716:31045492,31044717:31045530,31045590:31051558,31045591:31051591,31045592:31051622,31045593:31051670,31045594:31051702,31045595:31051779,31046065:31051820,31046066:31051856,31046295:31046789,31046296:31046813,31047156:31047789,31047158:31047821,31047162:31047969,31047281:31048006,31047282:31048047,31047336:31048153,31047337:31048190,31047338:31048224,31047655:31048255,31047656:31048292,31049364:31049439,31049365:31049480,31049366:31049550,31049385:31049930,31050029:31050098,31050030:31050169,31050374:31050438,31050879:31050951,31050880:31050990,31051242:31051265,31052863:31052986,31052864:31053025,31052865:31053065,31052866:31053131,31053550:31053755,31053551:31053799,31053983:31054270,31054419:31054678,31054958:31055071,31056721:31057714,31057007:31057116,31057171:31057273,31057400:31057520,31057736:31057763,31057737:31057875,31058058:31058735,31058218:31058293,31058398:3105853', 'assoc_mat': '31044709:pehd:4230:31046328,31044710:pehd:4230:31051514,31044711:pehd:4230:31045323,31044712:pehd:4230:31045370,31044713:pehd:4230:31045408,31044714:pehd:4230:31046086,31044715:pehd:4230:31045453,31044716:pehd:4230:31045492,31044717:pehd:4230:31045530,31045590:pehd:4230:31051558,31045591:pehd:4230:31051591,31045592:pehd:4230:31051622,31045593:pehd:4230:31051670,31045594:pehd:4230:31051702,31045595:pehd:4230:31051779,31046065:pehd:4230:31051820,31046066:pehd:4230:31051856,31046295:pehd:4230:31046789,31046296:pehd:4230:31046813,31047156:pehd:4230:31047789,31047158:pehd:4230:31047821,31047162:pehd:4230:31047969,31047281:pehd:4230:31048006,31047282:pehd:4230:31048047,31047336:pehd:4230:31048153,31047337:pehd:4230:31048190,31047338:pehd:4230:31048224,31047655:pehd:4230:31048255,31047656:pehd:4230:31048292,31049364:pehd:4230:31049439,31049365:pehd:4230:31049480,31049366:pehd:4230:31049550,31049385:pehd:4230:31049930,31050029:pehd:4230:31050098,31050030:pehd:4230:31050169,31050374:pehd:4230:31050438,31050879:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01869743690711632, 'nb_photo': 7138, 'list_port_cont': '31045336,31045367,31045404,31045454,31045491,31045533,31046001,31046091,31046326,31046788,31046822,31046854,31047786,31047817,31047858,31047891,31047924,31047970,31048008,31048037,31048081,31048115,31048144,31048186,31048229,31048264,31048303,31048367,31048415,31049440,31049476,31049510,31049559,31049931,31050093,31050170,31050432,31050704,31050942,31050989,31051271,31051513,31051554,31051595,31051617,31051667,31051703,31051743,31051776,31051819,31051848,31052979,31053027,31053054,31053130,31053173,31053659,31053763,31053786,31054267,31054314,31054598,31054625,31054682,31055074,31055117,31055155,31055475,31055750,31055908,31056080,31056334,31056543,31056581,31056830,31057115,31057275,31057522,31057713,31057765,31057870,31058292,31058537,31058731,31058822,31059060,31059146,31059507,31059679,31059968,31060011,31060077,31060286,31060504,31060655,31060896,31061102,31061273,31061315,31061596,31061760,31062045,31062260,31062526,31062609,31063151,31063362,31063529,31063658,31063872,31063911,31064263,31064381,3106450', 'assoc_port': '31044708:31056830,31044709:31046326,31044710:31051513,31044711:31045336,31044712:31045367,31044713:31045404,31044714:31046091,31044715:31045454,31044716:31045491,31044717:31045533,31045590:31051554,31045591:31051595,31045592:31051617,31045593:31051667,31045594:31051703,31045595:31051776,31045596:31046001,31046064:31051743,31046065:31051819,31046066:31051848,31046295:31046788,31046296:31046822,31046297:31046854,31047156:31047786,31047158:31047817,31047159:31047858,31047160:31047891,31047161:31047924,31047162:31047970,31047281:31048008,31047282:31048037,31047283:31048081,31047335:31048115,31047336:31048144,31047337:31048186,31047338:31048229,31047655:31048264,31047656:31048303,31047657:31048367,31047658:31048415,31049364:31049440,31049365:31049476,31049366:31049559,31049367:31049510,31049385:31049931,31050029:31050093,31050030:31050170,31050374:31050432,31050605:31050704,31050879:31050942,31050880:31050989,31051242:31051271,31052863:31052979,31052864:31053027,31052865:31053054,31052866:31053130,31052867:3105317', 'assoc_mat': '31044708:pet_clair:4230:31056830,31044709:pet_clair:4230:31046326,31044710:pet_clair:4230:31051513,31044711:pet_clair:4230:31045336,31044712:pet_clair:4230:31045367,31044713:pet_clair:4230:31045404,31044714:pet_clair:4230:31046091,31044715:pet_clair:4230:31045454,31044716:pet_clair:4230:31045491,31044717:pet_clair:4230:31045533,31045590:pet_clair:4230:31051554,31045591:pet_clair:4230:31051595,31045592:pet_clair:4230:31051617,31045593:pet_clair:4230:31051667,31045594:pet_clair:4230:31051703,31045595:pet_clair:4230:31051776,31045596:pet_clair:4230:31046001,31046064:pet_clair:4230:31051743,31046065:pet_clair:4230:31051819,31046066:pet_clair:4230:31051848,31046295:pet_clair:4230:31046788,31046296:pet_clair:4230:31046822,31046297:pet_clair:4230:31046854,31047156:pet_clair:4230:31047786,31047158:pet_clair:4230:31047817,31047159:pet_clair:4230:31047858,31047160:pet_clair:4230:31047891,31047161:pet_clair:4230:31047924,31047162:pet_clair:4230:31047970,31047281:pet_clair:4230:31048008,31047282:pet_clair:4230:31048037,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0016432782734386794, 'nb_photo': 281, 'list_port_cont': '31045360,31045402,31045456,31045493,31045527,31046085,31046327,31046855,31047932,31047972,31048038,31048119,31049517,31050094,31050165,31050708,31050979,31051275,31051508,31051550,31051629,31051660,31051707,31051741,31051784,31051851,31052990,31053029,31053059,31053136,31053171,31053649,31053759,31053794,31056082,31056328,31056549,31056579,31056828,31057112,31057270,31057510,31057703,31057773,31057873,31058287,31058736,31058816,31059971,31060293,31060901,31061597,31061756,31062041,31062261,31062537,31062613,31063157,31063359,31063528,31063655,31063913,31064252,31064375,31064745,31064998,31065327,31065885,31065918,31067128,31067847,31068195,31068744,31069152,31070143,31070298,31070859,31071098,31071375,31071611,31071694,31071972,31072287,31072522,31072934,31072971,31073773,31075021,31075253,31075569,31075642,31076146,31076360,31076604,31076887,31077049,31077213,31077460,31077634,31077873,31078216,31078413,31078633,31078839,31078873,31079233,31079457,31079665,31079889,31080170,31080410,31080702,31081186', 'assoc_port': '31044708:31056828,31044709:31046327,31044710:31051508,31044712:31045360,31044713:31045402,31044714:31046085,31044715:31045456,31044716:31045493,31044717:31045527,31045590:31051550,31045592:31051629,31045593:31051660,31045594:31051707,31045595:31051784,31046064:31051741,31046066:31051851,31046297:31046855,31047161:31047932,31047162:31047972,31047282:31048038,31047335:31048119,31049367:31049517,31050029:31050094,31050030:31050165,31050605:31050708,31050880:31050979,31051242:31051275,31052863:31052990,31052864:31053029,31052865:31053059,31052866:31053136,31052867:31053171,31053549:31053649,31053550:31053759,31053551:31053794,31056017:31056082,31056238:31056328,31056471:31056549,31056473:31056579,31056721:31057703,31057007:31057112,31057171:31057270,31057400:31057510,31057736:31057773,31057737:31057873,31058058:31058736,31058218:31058287,31058621:31058816,31059661:31059971,31060226:31060293,31060802:31060901,31061534:31061597,31061703:31061756,31061977:31062041,31062153:31062261,31062439:31062537,31062440:3106261', 'assoc_mat': '31044708:pet_fonce:4230:31056828,31044709:pet_fonce:4230:31046327,31044710:pet_fonce:4230:31051508,31044712:pet_fonce:4230:31045360,31044713:pet_fonce:4230:31045402,31044714:pet_fonce:4230:31046085,31044715:pet_fonce:4230:31045456,31044716:pet_fonce:4230:31045493,31044717:pet_fonce:4230:31045527,31045590:pet_fonce:4230:31051550,31045592:pet_fonce:4230:31051629,31045593:pet_fonce:4230:31051660,31045594:pet_fonce:4230:31051707,31045595:pet_fonce:4230:31051784,31046064:pet_fonce:4230:31051741,31046066:pet_fonce:4230:31051851,31046297:pet_fonce:4230:31046855,31047161:pet_fonce:4230:31047932,31047162:pet_fonce:4230:31047972,31047282:pet_fonce:4230:31048038,31047335:pet_fonce:4230:31048119,31049367:pet_fonce:4230:31049517,31050029:pet_fonce:4230:31050094,31050030:pet_fonce:4230:31050165,31050605:pet_fonce:4230:31050708,31050880:pet_fonce:4230:31050979,31051242:pet_fonce:4230:31051275,31052863:pet_fonce:4230:31052990,31052864:pet_fonce:4230:31053029,31052865:pet_fonce:4230:31053059,31052866:pet_fonce:4230:31053136,3'}), 'main_stat': {'nb_photos': 703}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31081554,31081555,31081556,31081557,31081558,31081559,31081560?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-05', 0.7869534073300316),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((703,),), 'unwanted_material_monthly_percentage': ((0.7869534073300316,),), 'material_repartition': (('incineration', 703),), 'material_dict': {'incineration': 703}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 5, 9), 0.7314678600477017, 1), (datetime.date(2026, 5, 10), 0.7978820747930804, 3), (datetime.date(2026, 5, 11), 0.809549608663312, 4), (datetime.date(2026, 5, 12), 0.8320448741535217, 3), (datetime.date(2026, 5, 13), 0.7940725996229108, 4), (datetime.date(2026, 5, 14), 0.8345934495224177, 4), (datetime.date(2026, 5, 15), 0.8160990689054678, 3), (datetime.date(2026, 5, 16), 0.6986428269389483, 4), (datetime.date(2026, 5, 17), 0.72033516947332, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 5, 9), 0.7314678600477017, 1), (datetime.date(2026, 5, 10), 0.7978820747930804, 3), (datetime.date(2026, 5, 11), 0.809549608663312, 4), (datetime.date(2026, 5, 12), 0.8320448741535217, 3), (datetime.date(2026, 5, 13), 0.7940725996229108, 4), (datetime.date(2026, 5, 14), 0.8345934495224177, 4), (datetime.date(2026, 5, 15), 0.8160990689054678, 3), (datetime.date(2026, 5, 16), 0.6986428269389483, 4), (datetime.date(2026, 5, 17), 0.72033516947332, 3))}, 'quality_array': [['-8.119855299263582', '09052026'], ['-7.533130618852553', '10052026'], ['-7.7276414927526105', '11052026'], ['-7.501854631720644', '12052026'], ['-7.705057532501817', '13052026'], ['-7.72437595231998', '14052026'], ['-7.632140033614754', '15052026'], ['-7.945496573301978', '16052026'], ['-8.208203444687102', '17052026']], 'number_of_batch': ((200,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010868579867819453, 'nb_photo': 5594, 'list_port_cont': '31045334,31045366,31045407,31045455,31045486,31045523,31045992,31046082,31046321,31046785,31046816,31046852,31047779,31047816,31047845,31047882,31047931,31047964,31048007,31048044,31048067,31048108,31048146,31048183,31048225,31048256,31048291,31048374,31048404,31049443,31049479,31049508,31049549,31049925,31050097,31050154,31050423,31050691,31050950,31050983,31051273,31051519,31051556,31051582,31051628,31051656,31051691,31051748,31051771,31051821,31051849,31052984,31053024,31053066,31053134,31053168,31053645,31053749,31053784,31054273,31054308,31054585,31054626,31054671,31055073,31055118,31055145,31055468,31055739,31055912,31056073,31056332,31056550,31056570,31056825,31057108,31057263,31057511,31057709,31057759,31057866,31058280,31058534,31058728,31058812,31059058,31059132,31059519,31059681,31059970,31060073,31060287,31060494,31060659,31060889,31061095,31061269,31061307,31061595,31061753,31062040,31062256,31062528,31062614,31063150,31063360,31063521,31063657,31063868,31063912,31064248,31064371,31064500,3106470', 'assoc_port': '31044708:31056825,31044709:31046321,31044710:31051519,31044711:31045334,31044712:31045366,31044713:31045407,31044714:31046082,31044715:31045455,31044716:31045486,31044717:31045523,31045590:31051556,31045591:31051582,31045592:31051628,31045593:31051656,31045594:31051691,31045595:31051771,31045596:31045992,31046064:31051748,31046065:31051821,31046066:31051849,31046295:31046785,31046296:31046816,31046297:31046852,31047156:31047779,31047158:31047816,31047159:31047845,31047160:31047882,31047161:31047931,31047162:31047964,31047281:31048007,31047282:31048044,31047283:31048067,31047335:31048108,31047336:31048146,31047337:31048183,31047338:31048225,31047655:31048256,31047656:31048291,31047657:31048374,31047658:31048404,31049364:31049443,31049365:31049479,31049366:31049549,31049367:31049508,31049385:31049925,31050029:31050097,31050030:31050154,31050374:31050423,31050605:31050691,31050879:31050950,31050880:31050983,31051242:31051273,31052863:31052984,31052864:31053024,31052865:31053066,31052866:31053134,31052867:3105316', 'assoc_mat': '31044708:autre:4230:31056825,31044709:autre:4230:31046321,31044710:autre:4230:31051519,31044711:autre:4230:31045334,31044712:autre:4230:31045366,31044713:autre:4230:31045407,31044714:autre:4230:31046082,31044715:autre:4230:31045455,31044716:autre:4230:31045486,31044717:autre:4230:31045523,31045590:autre:4230:31051556,31045591:autre:4230:31051582,31045592:autre:4230:31051628,31045593:autre:4230:31051656,31045594:autre:4230:31051691,31045595:autre:4230:31051771,31045596:autre:4230:31045992,31046064:autre:4230:31051748,31046065:autre:4230:31051821,31046066:autre:4230:31051849,31046295:autre:4230:31046785,31046296:autre:4230:31046816,31046297:autre:4230:31046852,31047156:autre:4230:31047779,31047158:autre:4230:31047816,31047159:autre:4230:31047845,31047160:autre:4230:31047882,31047161:autre:4230:31047931,31047162:autre:4230:31047964,31047281:autre:4230:31048007,31047282:autre:4230:31048044,31047283:autre:4230:31048067,31047335:autre:4230:31048108,31047336:autre:4230:31048146,31047337:autre:4230:31048183,31047338:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03848269750496583, 'nb_photo': 25658, 'list_port_cont': '31045330,31045365,31045403,31045458,31045489,31045528,31046002,31046081,31046333,31046786,31046821,31046862,31047788,31047826,31047861,31047895,31047930,31047958,31048000,31048035,31048083,31048112,31048143,31048182,31048228,31048265,31048301,31048369,31048408,31049441,31049485,31049505,31049553,31049927,31050095,31050166,31050434,31050700,31050946,31050976,31051277,31051506,31051557,31051592,31051631,31051663,31051697,31051747,31051777,31051813,31051859,31052988,31053021,31053061,31053140,31053180,31053660,31053761,31053793,31054268,31054305,31054597,31054639,31054675,31055083,31055112,31055154,31055472,31055748,31055917,31056077,31056336,31056541,31056578,31056820,31057111,31057274,31057517,31057712,31057770,31057872,31058291,31058539,31058740,31058820,31059072,31059134,31059510,31059672,31059964,31060003,31060070,31060297,31060506,31060668,31060899,31061099,31061283,31061319,31061603,31061759,31062038,31062252,31062536,31062607,31063152,31063354,31063523,31063656,31063871,31063903,31064257,31064382,3106450', 'assoc_port': '31044708:31056820,31044709:31046333,31044710:31051506,31044711:31045330,31044712:31045365,31044713:31045403,31044714:31046081,31044715:31045458,31044716:31045489,31044717:31045528,31045590:31051557,31045591:31051592,31045592:31051631,31045593:31051663,31045594:31051697,31045595:31051777,31045596:31046002,31046064:31051747,31046065:31051813,31046066:31051859,31046295:31046786,31046296:31046821,31046297:31046862,31047156:31047788,31047158:31047826,31047159:31047861,31047160:31047895,31047161:31047930,31047162:31047958,31047281:31048000,31047282:31048035,31047283:31048083,31047335:31048112,31047336:31048143,31047337:31048182,31047338:31048228,31047655:31048265,31047656:31048301,31047657:31048369,31047658:31048408,31049364:31049441,31049365:31049485,31049366:31049553,31049367:31049505,31049385:31049927,31050029:31050095,31050030:31050166,31050374:31050434,31050605:31050700,31050879:31050946,31050880:31050976,31051242:31051277,31052863:31052988,31052864:31053021,31052865:31053061,31052866:31053140,31052867:3105318', 'assoc_mat': '31044708:carton:4230:31056820,31044709:carton:4230:31046333,31044710:carton:4230:31051506,31044711:carton:4230:31045330,31044712:carton:4230:31045365,31044713:carton:4230:31045403,31044714:carton:4230:31046081,31044715:carton:4230:31045458,31044716:carton:4230:31045489,31044717:carton:4230:31045528,31045590:carton:4230:31051557,31045591:carton:4230:31051592,31045592:carton:4230:31051631,31045593:carton:4230:31051663,31045594:carton:4230:31051697,31045595:carton:4230:31051777,31045596:carton:4230:31046002,31046064:carton:4230:31051747,31046065:carton:4230:31051813,31046066:carton:4230:31051859,31046295:carton:4230:31046786,31046296:carton:4230:31046821,31046297:carton:4230:31046862,31047156:carton:4230:31047788,31047158:carton:4230:31047826,31047159:carton:4230:31047861,31047160:carton:4230:31047895,31047161:carton:4230:31047930,31047162:carton:4230:31047958,31047281:carton:4230:31048000,31047282:carton:4230:31048035,31047283:carton:4230:31048083,31047335:carton:4230:31048112,31047336:carton:4230:31048143,3104'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010840947767881129, 'nb_photo': 477, 'list_port_cont': '31045329,31045371,31045397,31045447,31045482,31045532,31046004,31046084,31046317,31046773,31046810,31046850,31047775,31047823,31047855,31047919,31047968,31047999,31048068,31048106,31048147,31048188,31048223,31048268,31048298,31048364,31049446,31049518,31049542,31049923,31050429,31051266,31051502,31051548,31051584,31051630,31051668,31051733,31051817,31051861,31052989,31053030,31053055,31053139,31053182,31053661,31053746,31053791,31054258,31054299,31054586,31054624,31054674,31055070,31055110,31055142,31055470,31055919,31056088,31056546,31056573,31057102,31057267,31057509,31057769,31057859,31058281,31058523,31058741,31058824,31059063,31059974,31060071,31060292,31060904,31061101,31061312,31061598,31061752,31062034,31062249,31062529,31062604,31063144,31063646,31063870,31063904,31064260,31064380,31064737,31064992,31065258,31065277,31065791,31065884,31066454,31066579,31067114,31067160,31067455,31067797,31067834,31067910,31068185,31068422,31069146,31069416,31069651,31070299,31070371,31071092,31071381,31071620,3107168', 'assoc_port': '31044709:31046317,31044710:31051502,31044711:31045329,31044712:31045371,31044713:31045397,31044714:31046084,31044715:31045447,31044716:31045482,31044717:31045532,31045590:31051548,31045591:31051584,31045592:31051630,31045593:31051668,31045596:31046004,31046064:31051733,31046065:31051817,31046066:31051861,31046295:31046773,31046296:31046810,31046297:31046850,31047156:31047775,31047158:31047823,31047159:31047855,31047161:31047919,31047162:31047968,31047281:31047999,31047283:31048068,31047335:31048106,31047336:31048147,31047337:31048188,31047338:31048223,31047655:31048268,31047656:31048298,31047657:31048364,31049364:31049446,31049366:31049542,31049367:31049518,31049385:31049923,31050374:31050429,31051242:31051266,31052863:31052989,31052864:31053030,31052865:31053055,31052866:31053139,31052867:31053182,31053549:31053661,31053550:31053746,31053551:31053791,31053983:31054258,31053984:31054299,31054417:31054586,31054418:31054624,31054419:31054674,31054958:31055070,31054959:31055142,31054960:31055110,31055391:3105547', 'assoc_mat': '31044709:metal:4230:31046317,31044710:metal:4230:31051502,31044711:metal:4230:31045329,31044712:metal:4230:31045371,31044713:metal:4230:31045397,31044714:metal:4230:31046084,31044715:metal:4230:31045447,31044716:metal:4230:31045482,31044717:metal:4230:31045532,31045590:metal:4230:31051548,31045591:metal:4230:31051584,31045592:metal:4230:31051630,31045593:metal:4230:31051668,31045596:metal:4230:31046004,31046064:metal:4230:31051733,31046065:metal:4230:31051817,31046066:metal:4230:31051861,31046295:metal:4230:31046773,31046296:metal:4230:31046810,31046297:metal:4230:31046850,31047156:metal:4230:31047775,31047158:metal:4230:31047823,31047159:metal:4230:31047855,31047161:metal:4230:31047919,31047162:metal:4230:31047968,31047281:metal:4230:31047999,31047283:metal:4230:31048068,31047335:metal:4230:31048106,31047336:metal:4230:31048147,31047337:metal:4230:31048188,31047338:metal:4230:31048223,31047655:metal:4230:31048268,31047656:metal:4230:31048298,31047657:metal:4230:31048364,31049364:metal:4230:31049446,31049366:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16688144712453887, 'nb_photo': 146910, 'list_port_cont': '31045325,31045368,31045405,31045461,31045497,31045535,31046003,31046089,31046334,31046784,31046826,31046856,31047778,31047819,31047857,31047892,31047936,31047962,31048002,31048046,31048072,31048117,31048154,31048187,31048226,31048266,31048305,31048371,31048402,31049449,31049477,31049521,31049551,31049928,31050096,31050168,31050424,31050706,31050941,31050987,31051270,31051515,31051547,31051581,31051623,31051669,31051705,31051742,31051778,31051815,31051852,31052976,31053031,31053058,31053133,31053178,31053656,31053754,31053787,31054272,31054309,31054595,31054637,31054677,31055082,31055107,31055149,31055462,31055742,31055921,31056090,31056330,31056547,31056586,31056827,31057107,31057261,31057519,31057706,31057774,31057871,31058286,31058527,31058738,31058819,31059062,31059144,31059520,31059677,31059972,31060004,31060074,31060291,31060497,31060669,31060903,31061091,31061284,31061317,31061602,31061750,31062044,31062257,31062532,31062617,31063155,31063356,31063527,31063650,31063873,31063909,31064254,31064379,3106450', 'assoc_port': '31044708:31056827,31044709:31046334,31044710:31051515,31044711:31045325,31044712:31045368,31044713:31045405,31044714:31046089,31044715:31045461,31044716:31045497,31044717:31045535,31045590:31051547,31045591:31051581,31045592:31051623,31045593:31051669,31045594:31051705,31045595:31051778,31045596:31046003,31046064:31051742,31046065:31051815,31046066:31051852,31046295:31046784,31046296:31046826,31046297:31046856,31047156:31047778,31047158:31047819,31047159:31047857,31047160:31047892,31047161:31047936,31047162:31047962,31047281:31048002,31047282:31048046,31047283:31048072,31047335:31048117,31047336:31048154,31047337:31048187,31047338:31048226,31047655:31048266,31047656:31048305,31047657:31048371,31047658:31048402,31049364:31049449,31049365:31049477,31049366:31049551,31049367:31049521,31049385:31049928,31050029:31050096,31050030:31050168,31050374:31050424,31050605:31050706,31050879:31050941,31050880:31050987,31051242:31051270,31052863:31052976,31052864:31053031,31052865:31053058,31052866:31053133,31052867:3105317', 'assoc_mat': '31044708:papier:4230:31056827,31044709:papier:4230:31046334,31044710:papier:4230:31051515,31044711:papier:4230:31045325,31044712:papier:4230:31045368,31044713:papier:4230:31045405,31044714:papier:4230:31046089,31044715:papier:4230:31045461,31044716:papier:4230:31045497,31044717:papier:4230:31045535,31045590:papier:4230:31051547,31045591:papier:4230:31051581,31045592:papier:4230:31051623,31045593:papier:4230:31051669,31045594:papier:4230:31051705,31045595:papier:4230:31051778,31045596:papier:4230:31046003,31046064:papier:4230:31051742,31046065:papier:4230:31051815,31046066:papier:4230:31051852,31046295:papier:4230:31046784,31046296:papier:4230:31046826,31046297:papier:4230:31046856,31047156:papier:4230:31047778,31047158:papier:4230:31047819,31047159:papier:4230:31047857,31047160:papier:4230:31047892,31047161:papier:4230:31047936,31047162:papier:4230:31047962,31047281:papier:4230:31048002,31047282:papier:4230:31048046,31047283:papier:4230:31048072,31047335:papier:4230:31048117,31047336:papier:4230:31048154,3104'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003579996038482788, 'nb_photo': 657, 'list_port_cont': '31045323,31045370,31045408,31045453,31045492,31045530,31046086,31046328,31046789,31046813,31047789,31047821,31047969,31048006,31048047,31048153,31048190,31048224,31048255,31048292,31049439,31049480,31049550,31049930,31050098,31050169,31050438,31050951,31050990,31051265,31051514,31051558,31051591,31051622,31051670,31051702,31051779,31051820,31051856,31052986,31053025,31053065,31053131,31053755,31053799,31054270,31054678,31055071,31057116,31057273,31057520,31057714,31057763,31057875,31058293,31058530,31058735,31058821,31059141,31059509,31059973,31060067,31060498,31060665,31060893,31061285,31061589,31061761,31062042,31062618,31063158,31063363,31063526,31063654,31063864,31063916,31064504,31064744,31066459,31066505,31066584,31067851,31068428,31068618,31070151,31070308,31070379,31070576,31070855,31071388,31071608,31071686,31071979,31072284,31072520,31072689,31072924,31072970,31073354,31074121,31074242,31074784,31075032,31075570,31075650,31075911,31076143,31076371,31076609,31076890,31077048,31077215,31077449,3107764', 'assoc_port': '31044709:31046328,31044710:31051514,31044711:31045323,31044712:31045370,31044713:31045408,31044714:31046086,31044715:31045453,31044716:31045492,31044717:31045530,31045590:31051558,31045591:31051591,31045592:31051622,31045593:31051670,31045594:31051702,31045595:31051779,31046065:31051820,31046066:31051856,31046295:31046789,31046296:31046813,31047156:31047789,31047158:31047821,31047162:31047969,31047281:31048006,31047282:31048047,31047336:31048153,31047337:31048190,31047338:31048224,31047655:31048255,31047656:31048292,31049364:31049439,31049365:31049480,31049366:31049550,31049385:31049930,31050029:31050098,31050030:31050169,31050374:31050438,31050879:31050951,31050880:31050990,31051242:31051265,31052863:31052986,31052864:31053025,31052865:31053065,31052866:31053131,31053550:31053755,31053551:31053799,31053983:31054270,31054419:31054678,31054958:31055071,31056721:31057714,31057007:31057116,31057171:31057273,31057400:31057520,31057736:31057763,31057737:31057875,31058058:31058735,31058218:31058293,31058398:3105853', 'assoc_mat': '31044709:pehd:4230:31046328,31044710:pehd:4230:31051514,31044711:pehd:4230:31045323,31044712:pehd:4230:31045370,31044713:pehd:4230:31045408,31044714:pehd:4230:31046086,31044715:pehd:4230:31045453,31044716:pehd:4230:31045492,31044717:pehd:4230:31045530,31045590:pehd:4230:31051558,31045591:pehd:4230:31051591,31045592:pehd:4230:31051622,31045593:pehd:4230:31051670,31045594:pehd:4230:31051702,31045595:pehd:4230:31051779,31046065:pehd:4230:31051820,31046066:pehd:4230:31051856,31046295:pehd:4230:31046789,31046296:pehd:4230:31046813,31047156:pehd:4230:31047789,31047158:pehd:4230:31047821,31047162:pehd:4230:31047969,31047281:pehd:4230:31048006,31047282:pehd:4230:31048047,31047336:pehd:4230:31048153,31047337:pehd:4230:31048190,31047338:pehd:4230:31048224,31047655:pehd:4230:31048255,31047656:pehd:4230:31048292,31049364:pehd:4230:31049439,31049365:pehd:4230:31049480,31049366:pehd:4230:31049550,31049385:pehd:4230:31049930,31050029:pehd:4230:31050098,31050030:pehd:4230:31050169,31050374:pehd:4230:31050438,31050879:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01869743690711632, 'nb_photo': 7138, 'list_port_cont': '31045336,31045367,31045404,31045454,31045491,31045533,31046001,31046091,31046326,31046788,31046822,31046854,31047786,31047817,31047858,31047891,31047924,31047970,31048008,31048037,31048081,31048115,31048144,31048186,31048229,31048264,31048303,31048367,31048415,31049440,31049476,31049510,31049559,31049931,31050093,31050170,31050432,31050704,31050942,31050989,31051271,31051513,31051554,31051595,31051617,31051667,31051703,31051743,31051776,31051819,31051848,31052979,31053027,31053054,31053130,31053173,31053659,31053763,31053786,31054267,31054314,31054598,31054625,31054682,31055074,31055117,31055155,31055475,31055750,31055908,31056080,31056334,31056543,31056581,31056830,31057115,31057275,31057522,31057713,31057765,31057870,31058292,31058537,31058731,31058822,31059060,31059146,31059507,31059679,31059968,31060011,31060077,31060286,31060504,31060655,31060896,31061102,31061273,31061315,31061596,31061760,31062045,31062260,31062526,31062609,31063151,31063362,31063529,31063658,31063872,31063911,31064263,31064381,3106450', 'assoc_port': '31044708:31056830,31044709:31046326,31044710:31051513,31044711:31045336,31044712:31045367,31044713:31045404,31044714:31046091,31044715:31045454,31044716:31045491,31044717:31045533,31045590:31051554,31045591:31051595,31045592:31051617,31045593:31051667,31045594:31051703,31045595:31051776,31045596:31046001,31046064:31051743,31046065:31051819,31046066:31051848,31046295:31046788,31046296:31046822,31046297:31046854,31047156:31047786,31047158:31047817,31047159:31047858,31047160:31047891,31047161:31047924,31047162:31047970,31047281:31048008,31047282:31048037,31047283:31048081,31047335:31048115,31047336:31048144,31047337:31048186,31047338:31048229,31047655:31048264,31047656:31048303,31047657:31048367,31047658:31048415,31049364:31049440,31049365:31049476,31049366:31049559,31049367:31049510,31049385:31049931,31050029:31050093,31050030:31050170,31050374:31050432,31050605:31050704,31050879:31050942,31050880:31050989,31051242:31051271,31052863:31052979,31052864:31053027,31052865:31053054,31052866:31053130,31052867:3105317', 'assoc_mat': '31044708:pet_clair:4230:31056830,31044709:pet_clair:4230:31046326,31044710:pet_clair:4230:31051513,31044711:pet_clair:4230:31045336,31044712:pet_clair:4230:31045367,31044713:pet_clair:4230:31045404,31044714:pet_clair:4230:31046091,31044715:pet_clair:4230:31045454,31044716:pet_clair:4230:31045491,31044717:pet_clair:4230:31045533,31045590:pet_clair:4230:31051554,31045591:pet_clair:4230:31051595,31045592:pet_clair:4230:31051617,31045593:pet_clair:4230:31051667,31045594:pet_clair:4230:31051703,31045595:pet_clair:4230:31051776,31045596:pet_clair:4230:31046001,31046064:pet_clair:4230:31051743,31046065:pet_clair:4230:31051819,31046066:pet_clair:4230:31051848,31046295:pet_clair:4230:31046788,31046296:pet_clair:4230:31046822,31046297:pet_clair:4230:31046854,31047156:pet_clair:4230:31047786,31047158:pet_clair:4230:31047817,31047159:pet_clair:4230:31047858,31047160:pet_clair:4230:31047891,31047161:pet_clair:4230:31047924,31047162:pet_clair:4230:31047970,31047281:pet_clair:4230:31048008,31047282:pet_clair:4230:31048037,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0016432782734386794, 'nb_photo': 281, 'list_port_cont': '31045360,31045402,31045456,31045493,31045527,31046085,31046327,31046855,31047932,31047972,31048038,31048119,31049517,31050094,31050165,31050708,31050979,31051275,31051508,31051550,31051629,31051660,31051707,31051741,31051784,31051851,31052990,31053029,31053059,31053136,31053171,31053649,31053759,31053794,31056082,31056328,31056549,31056579,31056828,31057112,31057270,31057510,31057703,31057773,31057873,31058287,31058736,31058816,31059971,31060293,31060901,31061597,31061756,31062041,31062261,31062537,31062613,31063157,31063359,31063528,31063655,31063913,31064252,31064375,31064745,31064998,31065327,31065885,31065918,31067128,31067847,31068195,31068744,31069152,31070143,31070298,31070859,31071098,31071375,31071611,31071694,31071972,31072287,31072522,31072934,31072971,31073773,31075021,31075253,31075569,31075642,31076146,31076360,31076604,31076887,31077049,31077213,31077460,31077634,31077873,31078216,31078413,31078633,31078839,31078873,31079233,31079457,31079665,31079889,31080170,31080410,31080702,31081186', 'assoc_port': '31044708:31056828,31044709:31046327,31044710:31051508,31044712:31045360,31044713:31045402,31044714:31046085,31044715:31045456,31044716:31045493,31044717:31045527,31045590:31051550,31045592:31051629,31045593:31051660,31045594:31051707,31045595:31051784,31046064:31051741,31046066:31051851,31046297:31046855,31047161:31047932,31047162:31047972,31047282:31048038,31047335:31048119,31049367:31049517,31050029:31050094,31050030:31050165,31050605:31050708,31050880:31050979,31051242:31051275,31052863:31052990,31052864:31053029,31052865:31053059,31052866:31053136,31052867:31053171,31053549:31053649,31053550:31053759,31053551:31053794,31056017:31056082,31056238:31056328,31056471:31056549,31056473:31056579,31056721:31057703,31057007:31057112,31057171:31057270,31057400:31057510,31057736:31057773,31057737:31057873,31058058:31058736,31058218:31058287,31058621:31058816,31059661:31059971,31060226:31060293,31060802:31060901,31061534:31061597,31061703:31061756,31061977:31062041,31062153:31062261,31062439:31062537,31062440:3106261', 'assoc_mat': '31044708:pet_fonce:4230:31056828,31044709:pet_fonce:4230:31046327,31044710:pet_fonce:4230:31051508,31044712:pet_fonce:4230:31045360,31044713:pet_fonce:4230:31045402,31044714:pet_fonce:4230:31046085,31044715:pet_fonce:4230:31045456,31044716:pet_fonce:4230:31045493,31044717:pet_fonce:4230:31045527,31045590:pet_fonce:4230:31051550,31045592:pet_fonce:4230:31051629,31045593:pet_fonce:4230:31051660,31045594:pet_fonce:4230:31051707,31045595:pet_fonce:4230:31051784,31046064:pet_fonce:4230:31051741,31046066:pet_fonce:4230:31051851,31046297:pet_fonce:4230:31046855,31047161:pet_fonce:4230:31047932,31047162:pet_fonce:4230:31047972,31047282:pet_fonce:4230:31048038,31047335:pet_fonce:4230:31048119,31049367:pet_fonce:4230:31049517,31050029:pet_fonce:4230:31050094,31050030:pet_fonce:4230:31050165,31050605:pet_fonce:4230:31050708,31050880:pet_fonce:4230:31050979,31051242:pet_fonce:4230:31051275,31052863:pet_fonce:4230:31052990,31052864:pet_fonce:4230:31053029,31052865:pet_fonce:4230:31053059,31052866:pet_fonce:4230:31053136,3'}), 'main_stat': {'nb_photos': 703}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31081554,31081555,31081556,31081557,31081558,31081559,31081560?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-05', 0.7869534073300316),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_05_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.09%', 5594], 'carton': ['carton', '3.85%', 25658], 'metal': ['metal', '0.11%', 477], 'papier': ['papier', '16.69%', 146910], 'pehd': ['pehd', '0.36%', 657], 'pet_clair': ['pet_clair', '1.87%', 7138], 'pet_fonce': ['pet_fonce', '0.16%', 281]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_05_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.18user 2.79system 0:07.35elapsed 67%CPU (0avgtext+0avgdata 186688maxresident)k 2584inputs+280outputs (24major+34456minor)pagefaults 0swaps