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_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -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-08 _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 : (5, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # 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 : (5, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # 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 : 203 month : 08 mtr_id : dashboard_places : SCCU_cam8 date : 2026-08 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_cam8' and date like '%2026-08%') and created_at like '%2026-08%'))); nb_day : (5, 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 = 203 and month(ded.date) = 08 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 = 203 and month(ded.date) = 08 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 = 203 and mp.name like '%082026%' and cps.thcl = 1533 GROUP BY sbstr ; Erreur dans le nom de portfolio du batch invalid literal for int() with base 10: 'SCCU' after number_of_batch date_start : 2026-08-01 : dt_date_just_month_year : 2026-08-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_cam8" 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-08-01" AND ded.date <= "2026-08-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 (2987112,2987342,2987532,2987668,2988218,2988690,2989192,2989720,2990228,2990722,2991234,2991764,2992364,2993108) 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.011340222567907798, 'nb_photo': 4484, 'list_port_cont': '31045154,31045202,31045230,31045285,31045328,31045350,31047258,31047415,31047842,31047889,31048289,31048318,31048372,31048538,31048977,31050063,31050322,31050562,31050906,31051006,31051340,31051589,31051787,31052001,31052042,31052358,31052609,31052837,31053050,31053573,31053616,31053819,31053975,31054271,31054540,31054799,31055055,31055299,31055546,31055787,31056018,31056285,31056537,31056769,31056979,31057235,31057446,31057659,31057698,31057959,31058206,31058442,31058699,31059009,31059168,31059410,31059668,31059888,31060136,31060406,31060639,31060911,31061170,31061609,31061859,31062109,31062230,31062468,31062686,31063005,31063205,31063231,31063357,31063674,31063856,31064074,31064366,31064482,31064694,31064730,31065203,31065442,31065684,31065999,31066274,31066480,31066682,31066881,31067076,31067385,31067590,31067755,31068034,31068235,31068436,31068487,31068652,31069000,31069192,31069432,31069720,31069959,31070181,31070299,31070640,31070894,31071161,31071276,31071454,31071697,31071953,31072155,31072365,3107266', 'assoc_port': '31044266:31045154,31044453:31045202,31044466:31045230,31044500:31045350,31044540:31045285,31044541:31045328,31045510:31047258,31047372:31047415,31047765:31047889,31047766:31047842,31048156:31048318,31048157:31048289,31048360:31048372,31048443:31048538,31048901:31048977,31049899:31050063,31050103:31050322,31050355:31050562,31050597:31050906,31050882:31051006,31051165:31051340,31051373:31051589,31051623:31051787,31051836:31052042,31051837:31052001,31052146:31052358,31052393:31052609,31052642:31052837,31052885:31053050,31053101:31053573,31053358:31053616,31053642:31053819,31053850:31053975,31054029:31054271,31054321:31054540,31054576:31054799,31054836:31055055,31055095:31055299,31055341:31055546,31055586:31055787,31055824:31056018,31056067:31056285,31056327:31056537,31056568:31056769,31056811:31056979,31057020:31057235,31057270:31057446,31057487:31057698,31057488:31057659,31057793:31057959,31058035:31058206,31058283:31058442,31058531:31058699,31058775:31059009,31058999:31059168,31059246:31059410,31059492:3105966', 'assoc_mat': '31044266:autre:4230:31045154,31044453:autre:4230:31045202,31044466:autre:4230:31045230,31044500:autre:4230:31045350,31044540:autre:4230:31045285,31044541:autre:4230:31045328,31045510:autre:4230:31047258,31047372:autre:4230:31047415,31047765:autre:4230:31047889,31047766:autre:4230:31047842,31048156:autre:4230:31048318,31048157:autre:4230:31048289,31048360:autre:4230:31048372,31048443:autre:4230:31048538,31048901:autre:4230:31048977,31049899:autre:4230:31050063,31050103:autre:4230:31050322,31050355:autre:4230:31050562,31050597:autre:4230:31050906,31050882:autre:4230:31051006,31051165:autre:4230:31051340,31051373:autre:4230:31051589,31051623:autre:4230:31051787,31051836:autre:4230:31052042,31051837:autre:4230:31052001,31052146:autre:4230:31052358,31052393:autre:4230:31052609,31052642:autre:4230:31052837,31052885:autre:4230:31053050,31053101:autre:4230:31053573,31053358:autre:4230:31053616,31053642:autre:4230:31053819,31053850:autre:4230:31053975,31054029:autre:4230:31054271,31054321:autre:4230:31054540,31054576:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03589963348073788, 'nb_photo': 17764, 'list_port_cont': '31045165,31045203,31045238,31045288,31045339,31045356,31047266,31047427,31047849,31047893,31048294,31048330,31048366,31048531,31048974,31050069,31050318,31050570,31050895,31051023,31051328,31051581,31051789,31052003,31052040,31052353,31052604,31052850,31053057,31053559,31053613,31053809,31053990,31054283,31054532,31054793,31055061,31055298,31055553,31055795,31056022,31056290,31056531,31056780,31056983,31057234,31057443,31057646,31057693,31057953,31058196,31058445,31058695,31059013,31059169,31059406,31059670,31059892,31060144,31060408,31060647,31060922,31061162,31061364,31061613,31061864,31062116,31062240,31062475,31062680,31063006,31063203,31063238,31063368,31063675,31063866,31064077,31064369,31064491,31064701,31064742,31065197,31065450,31065676,31065998,31066282,31066487,31066683,31066887,31067068,31067398,31067599,31067761,31068041,31068236,31068441,31068481,31068657,31069001,31069186,31069438,31069736,31069970,31070172,31070301,31070653,31070889,31071158,31071285,31071458,31071711,31071957,31072159,3107237', 'assoc_port': '31044266:31045165,31044453:31045203,31044466:31045238,31044500:31045356,31044540:31045288,31044541:31045339,31045510:31047266,31047372:31047427,31047765:31047893,31047766:31047849,31048156:31048330,31048157:31048294,31048360:31048366,31048443:31048531,31048901:31048974,31049899:31050069,31050103:31050318,31050355:31050570,31050597:31050895,31050882:31051023,31051165:31051328,31051373:31051581,31051623:31051789,31051836:31052040,31051837:31052003,31052146:31052353,31052393:31052604,31052642:31052850,31052885:31053057,31053101:31053559,31053358:31053613,31053642:31053809,31053850:31053990,31054029:31054283,31054321:31054532,31054576:31054793,31054836:31055061,31055095:31055298,31055341:31055553,31055586:31055795,31055824:31056022,31056067:31056290,31056327:31056531,31056568:31056780,31056811:31056983,31057020:31057234,31057270:31057443,31057487:31057693,31057488:31057646,31057793:31057953,31058035:31058196,31058283:31058445,31058531:31058695,31058775:31059013,31058999:31059169,31059246:31059406,31059492:3105967', 'assoc_mat': '31044266:carton:4230:31045165,31044453:carton:4230:31045203,31044466:carton:4230:31045238,31044500:carton:4230:31045356,31044540:carton:4230:31045288,31044541:carton:4230:31045339,31045510:carton:4230:31047266,31047372:carton:4230:31047427,31047765:carton:4230:31047893,31047766:carton:4230:31047849,31048156:carton:4230:31048330,31048157:carton:4230:31048294,31048360:carton:4230:31048366,31048443:carton:4230:31048531,31048901:carton:4230:31048974,31049899:carton:4230:31050069,31050103:carton:4230:31050318,31050355:carton:4230:31050570,31050597:carton:4230:31050895,31050882:carton:4230:31051023,31051165:carton:4230:31051328,31051373:carton:4230:31051581,31051623:carton:4230:31051789,31051836:carton:4230:31052040,31051837:carton:4230:31052003,31052146:carton:4230:31052353,31052393:carton:4230:31052604,31052642:carton:4230:31052850,31052885:carton:4230:31053057,31053101:carton:4230:31053559,31053358:carton:4230:31053613,31053642:carton:4230:31053809,31053850:carton:4230:31053990,31054029:carton:4230:31054283,3105'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010002787437836049, 'nb_photo': 389, 'list_port_cont': '31045156,31045200,31045233,31045294,31045336,31045358,31047267,31047844,31047891,31048328,31048370,31050311,31050560,31050903,31051327,31051579,31052600,31053056,31053601,31053980,31054534,31055057,31055303,31055544,31055790,31056019,31056529,31056775,31056966,31057441,31058451,31059155,31059889,31060648,31060926,31061158,31061352,31061865,31063004,31063861,31064356,31066691,31067065,31067394,31067745,31068031,31068240,31068474,31070654,31070891,31071160,31071281,31071446,31071706,31071944,31072157,31072361,31072660,31072777,31073068,31073514,31073979,31074244,31074574,31075269,31075449,31075930,31076365,31076524,31076747,31076952,31077972,31078693,31079783,31080099,31080265,31080551,31080726,31081165,31081301,31081585,31082047,31082285,31082561,31082788,31082973,31083194,31083445,31083651,31083894,31084100,31084124,31084370,31084423,31084680,31084861,31084996,31085209,31085380,31085668,31085943,31086147,31086399,31086644,31086938,31087143,31087831,31088044,31088288,31088444,31088697,31088940,31089197,3108922', 'assoc_port': '31044266:31045156,31044453:31045200,31044466:31045233,31044500:31045358,31044540:31045294,31044541:31045336,31045510:31047267,31047765:31047891,31047766:31047844,31048156:31048328,31048360:31048370,31050103:31050311,31050355:31050560,31050597:31050903,31051165:31051327,31051373:31051579,31052393:31052600,31052885:31053056,31053358:31053601,31053850:31053980,31054321:31054534,31054836:31055057,31055095:31055303,31055341:31055544,31055586:31055790,31055824:31056019,31056327:31056529,31056568:31056775,31056811:31056966,31057270:31057441,31058283:31058451,31058999:31059155,31059709:31059889,31060480:31060648,31060718:31060926,31060958:31061158,31061200:31061352,31061650:31061865,31062796:31063004,31063744:31063861,31064153:31064356,31066524:31066691,31066934:31067065,31067152:31067394,31067667:31067745,31067839:31068031,31068078:31068240,31068279:31068474,31070436:31070654,31070688:31070891,31070938:31071160,31071196:31071281,31071328:31071446,31071536:31071706,31071782:31071944,31072025:31072157,31072196:3107236', 'assoc_mat': '31044266:metal:4230:31045156,31044453:metal:4230:31045200,31044466:metal:4230:31045233,31044500:metal:4230:31045358,31044540:metal:4230:31045294,31044541:metal:4230:31045336,31045510:metal:4230:31047267,31047765:metal:4230:31047891,31047766:metal:4230:31047844,31048156:metal:4230:31048328,31048360:metal:4230:31048370,31050103:metal:4230:31050311,31050355:metal:4230:31050560,31050597:metal:4230:31050903,31051165:metal:4230:31051327,31051373:metal:4230:31051579,31052393:metal:4230:31052600,31052885:metal:4230:31053056,31053358:metal:4230:31053601,31053850:metal:4230:31053980,31054321:metal:4230:31054534,31054836:metal:4230:31055057,31055095:metal:4230:31055303,31055341:metal:4230:31055544,31055586:metal:4230:31055790,31055824:metal:4230:31056019,31056327:metal:4230:31056529,31056568:metal:4230:31056775,31056811:metal:4230:31056966,31057270:metal:4230:31057441,31058283:metal:4230:31058451,31058999:metal:4230:31059155,31059709:metal:4230:31059889,31060480:metal:4230:31060648,31060718:metal:4230:31060926,31060958:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.14543452819657324, 'nb_photo': 74348, 'list_port_cont': '31045167,31045199,31045237,31045299,31045324,31045355,31047260,31047423,31047856,31047888,31048285,31048327,31048376,31048537,31048980,31050073,31050326,31050569,31050900,31051013,31051333,31051586,31051799,31052004,31052046,31052359,31052601,31052851,31053052,31053561,31053618,31053817,31053988,31054282,31054527,31054797,31055056,31055308,31055547,31055796,31056034,31056289,31056532,31056773,31056982,31057228,31057442,31057658,31057689,31057958,31058208,31058452,31058702,31059018,31059166,31059409,31059656,31059890,31060137,31060400,31060634,31060914,31061156,31061368,31061603,31061871,31062113,31062232,31062478,31062683,31063003,31063193,31063228,31063367,31063680,31063860,31064065,31064373,31064496,31064700,31064733,31065205,31065458,31065673,31065997,31066281,31066481,31066687,31066886,31067080,31067391,31067587,31067756,31068046,31068242,31068440,31068485,31068651,31069002,31069191,31069428,31069732,31069966,31070177,31070310,31070645,31070898,31071152,31071283,31071450,31071708,31071949,31072161,3107237', 'assoc_port': '31044266:31045167,31044453:31045199,31044466:31045237,31044500:31045355,31044540:31045299,31044541:31045324,31045510:31047260,31047372:31047423,31047765:31047888,31047766:31047856,31048156:31048327,31048157:31048285,31048360:31048376,31048443:31048537,31048901:31048980,31049899:31050073,31050103:31050326,31050355:31050569,31050597:31050900,31050882:31051013,31051165:31051333,31051373:31051586,31051623:31051799,31051836:31052046,31051837:31052004,31052146:31052359,31052393:31052601,31052642:31052851,31052885:31053052,31053101:31053561,31053358:31053618,31053642:31053817,31053850:31053988,31054029:31054282,31054321:31054527,31054576:31054797,31054836:31055056,31055095:31055308,31055341:31055547,31055586:31055796,31055824:31056034,31056067:31056289,31056327:31056532,31056568:31056773,31056811:31056982,31057020:31057228,31057270:31057442,31057487:31057689,31057488:31057658,31057793:31057958,31058035:31058208,31058283:31058452,31058531:31058702,31058775:31059018,31058999:31059166,31059246:31059409,31059492:3105965', 'assoc_mat': '31044266:papier:4230:31045167,31044453:papier:4230:31045199,31044466:papier:4230:31045237,31044500:papier:4230:31045355,31044540:papier:4230:31045299,31044541:papier:4230:31045324,31045510:papier:4230:31047260,31047372:papier:4230:31047423,31047765:papier:4230:31047888,31047766:papier:4230:31047856,31048156:papier:4230:31048327,31048157:papier:4230:31048285,31048360:papier:4230:31048376,31048443:papier:4230:31048537,31048901:papier:4230:31048980,31049899:papier:4230:31050073,31050103:papier:4230:31050326,31050355:papier:4230:31050569,31050597:papier:4230:31050900,31050882:papier:4230:31051013,31051165:papier:4230:31051333,31051373:papier:4230:31051586,31051623:papier:4230:31051799,31051836:papier:4230:31052046,31051837:papier:4230:31052004,31052146:papier:4230:31052359,31052393:papier:4230:31052601,31052642:papier:4230:31052851,31052885:papier:4230:31053052,31053101:papier:4230:31053561,31053358:papier:4230:31053618,31053642:papier:4230:31053817,31053850:papier:4230:31053988,31054029:papier:4230:31054282,3105'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018318709636072513, 'nb_photo': 195, 'list_port_cont': '31045159,31045205,31045241,31045297,31045332,31045345,31047892,31048325,31048539,31050070,31050327,31050567,31050905,31051021,31051334,31051582,31051794,31052010,31052041,31052356,31052606,31052854,31053061,31053566,31053614,31053808,31053985,31054276,31054537,31054796,31055058,31055306,31055549,31055797,31056032,31056292,31056522,31056767,31056974,31057230,31057437,31057697,31058704,31059006,31059171,31059414,31059894,31060140,31060641,31060919,31063235,31068244,31071162,31072368,31073521,31073758,31073807,31076950,31077195,31077965,31078416,31079776,31080107,31080276,31082050,31082294,31083886,31088709,31088953,31089204,31089235,31089434,31089867,31090259,31090541,31090782,31091232,31091772,31092218,31093123,31093315,31093559,31094130,31095139,31096493,31096965,31097001,31097121,31098449,31098575,31098820,31098965,31099401,31099644,31100126', 'assoc_port': '31044266:31045159,31044453:31045205,31044466:31045241,31044500:31045345,31044540:31045297,31044541:31045332,31047765:31047892,31048156:31048325,31048443:31048539,31049899:31050070,31050103:31050327,31050355:31050567,31050597:31050905,31050882:31051021,31051165:31051334,31051373:31051582,31051623:31051794,31051836:31052041,31051837:31052010,31052146:31052356,31052393:31052606,31052642:31052854,31052885:31053061,31053101:31053566,31053358:31053614,31053642:31053808,31053850:31053985,31054029:31054276,31054321:31054537,31054576:31054796,31054836:31055058,31055095:31055306,31055341:31055549,31055586:31055797,31055824:31056032,31056067:31056292,31056327:31056522,31056568:31056767,31056811:31056974,31057020:31057230,31057270:31057437,31057487:31057697,31058531:31058704,31058775:31059006,31058999:31059171,31059246:31059414,31059709:31059894,31059969:31060140,31060480:31060641,31060718:31060919,31063037:31063235,31068078:31068244,31070938:31071162,31072196:31072368,31073357:31073521,31073598:31073758,31073599:3107380', 'assoc_mat': '31044266:pehd:4230:31045159,31044453:pehd:4230:31045205,31044466:pehd:4230:31045241,31044500:pehd:4230:31045345,31044540:pehd:4230:31045297,31044541:pehd:4230:31045332,31047765:pehd:4230:31047892,31048156:pehd:4230:31048325,31048443:pehd:4230:31048539,31049899:pehd:4230:31050070,31050103:pehd:4230:31050327,31050355:pehd:4230:31050567,31050597:pehd:4230:31050905,31050882:pehd:4230:31051021,31051165:pehd:4230:31051334,31051373:pehd:4230:31051582,31051623:pehd:4230:31051794,31051836:pehd:4230:31052041,31051837:pehd:4230:31052010,31052146:pehd:4230:31052356,31052393:pehd:4230:31052606,31052642:pehd:4230:31052854,31052885:pehd:4230:31053061,31053101:pehd:4230:31053566,31053358:pehd:4230:31053614,31053642:pehd:4230:31053808,31053850:pehd:4230:31053985,31054029:pehd:4230:31054276,31054321:pehd:4230:31054537,31054576:pehd:4230:31054796,31054836:pehd:4230:31055058,31055095:pehd:4230:31055306,31055341:pehd:4230:31055549,31055586:pehd:4230:31055797,31055824:pehd:4230:31056032,31056067:pehd:4230:31056292,31056327:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012476847884658153, 'nb_photo': 5208, 'list_port_cont': '31045162,31045204,31045242,31045295,31045334,31045347,31047255,31047429,31047854,31047881,31048297,31048323,31048374,31048535,31048981,31050076,31050319,31050568,31050909,31051018,31051336,31051590,31051784,31052007,31052044,31052355,31052611,31052843,31053064,31053569,31053612,31053814,31053989,31054277,31054528,31054795,31055050,31055305,31055556,31055785,31056033,31056291,31056538,31056777,31056971,31057233,31057447,31057657,31057691,31057957,31058204,31058450,31058703,31059019,31059165,31059417,31059667,31059893,31060149,31060405,31060637,31060915,31061168,31061362,31061602,31061873,31062108,31062241,31062483,31062689,31063002,31063198,31063237,31063364,31063669,31063871,31064071,31064367,31064498,31064703,31064740,31065206,31065452,31065678,31065996,31066277,31066483,31066684,31066891,31067077,31067393,31067602,31067757,31068045,31068245,31068448,31068476,31068653,31068992,31069188,31069439,31069735,31069971,31070178,31070304,31070644,31070897,31071150,31071291,31071461,31071702,31071952,31072151,3107236', 'assoc_port': '31044266:31045162,31044453:31045204,31044466:31045242,31044500:31045347,31044540:31045295,31044541:31045334,31045510:31047255,31047372:31047429,31047765:31047881,31047766:31047854,31048156:31048323,31048157:31048297,31048360:31048374,31048443:31048535,31048901:31048981,31049899:31050076,31050103:31050319,31050355:31050568,31050597:31050909,31050882:31051018,31051165:31051336,31051373:31051590,31051623:31051784,31051836:31052044,31051837:31052007,31052146:31052355,31052393:31052611,31052642:31052843,31052885:31053064,31053101:31053569,31053358:31053612,31053642:31053814,31053850:31053989,31054029:31054277,31054321:31054528,31054576:31054795,31054836:31055050,31055095:31055305,31055341:31055556,31055586:31055785,31055824:31056033,31056067:31056291,31056327:31056538,31056568:31056777,31056811:31056971,31057020:31057233,31057270:31057447,31057487:31057691,31057488:31057657,31057793:31057957,31058035:31058204,31058283:31058450,31058531:31058703,31058775:31059019,31058999:31059165,31059246:31059417,31059492:3105966', 'assoc_mat': '31044266:pet_clair:4230:31045162,31044453:pet_clair:4230:31045204,31044466:pet_clair:4230:31045242,31044500:pet_clair:4230:31045347,31044540:pet_clair:4230:31045295,31044541:pet_clair:4230:31045334,31045510:pet_clair:4230:31047255,31047372:pet_clair:4230:31047429,31047765:pet_clair:4230:31047881,31047766:pet_clair:4230:31047854,31048156:pet_clair:4230:31048323,31048157:pet_clair:4230:31048297,31048360:pet_clair:4230:31048374,31048443:pet_clair:4230:31048535,31048901:pet_clair:4230:31048981,31049899:pet_clair:4230:31050076,31050103:pet_clair:4230:31050319,31050355:pet_clair:4230:31050568,31050597:pet_clair:4230:31050909,31050882:pet_clair:4230:31051018,31051165:pet_clair:4230:31051336,31051373:pet_clair:4230:31051590,31051623:pet_clair:4230:31051784,31051836:pet_clair:4230:31052044,31051837:pet_clair:4230:31052007,31052146:pet_clair:4230:31052355,31052393:pet_clair:4230:31052611,31052642:pet_clair:4230:31052843,31052885:pet_clair:4230:31053064,31053101:pet_clair:4230:31053569,31053358:pet_clair:4230:31053612,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012998685849173579, 'nb_photo': 151, 'list_port_cont': '31045201,31045239,31045337,31045354,31047426,31048536,31050071,31050325,31050563,31050908,31051017,31051798,31052036,31052347,31052605,31052844,31053571,31053608,31053981,31054279,31054539,31055053,31055554,31055793,31056028,31056981,31057692,31060644,31060927,31063356,31063868,31064076,31064362,31064495,31064739,31065455,31066283,31066479,31069183,31070312,31070888,31071710,31071942,31072158,31072376,31072656,31073769,31074481,31074871,31075657,31076742,31076949,31077485,31077971,31079725,31079777,31080565,31080970,31081163,31081308,31081801,31082043,31082293,31082783,31085942,31086156,31086648,31088051,31088291,31089195,31089865,31089998,31090252,31090535,31090786,31091520,31093322,31095960,31096212,31096497,31096964,31097002,31097130,31097476,31098461,31098572,31098819,31098959,31099404,31099649,31100127', 'assoc_port': '31044453:31045201,31044466:31045239,31044500:31045354,31044541:31045337,31047372:31047426,31048443:31048536,31049899:31050071,31050103:31050325,31050355:31050563,31050597:31050908,31050882:31051017,31051623:31051798,31051836:31052036,31052146:31052347,31052393:31052605,31052642:31052844,31053101:31053571,31053358:31053608,31053850:31053981,31054029:31054279,31054321:31054539,31054836:31055053,31055341:31055554,31055586:31055793,31055824:31056028,31056811:31056981,31057487:31057692,31060480:31060644,31060718:31060927,31063312:31063356,31063744:31063868,31063911:31064076,31064153:31064362,31064401:31064495,31064571:31064739,31065247:31065455,31066062:31066283,31066313:31066479,31069030:31069183,31070217:31070312,31070688:31070888,31071536:31071710,31071782:31071942,31072025:31072158,31072196:31072376,31072451:31072656,31073598:31073769,31074319:31074481,31074651:31074871,31075522:31075657,31076575:31076742,31076817:31076949,31077264:31077485,31077766:31077971,31079527:31079725,31079755:31079777,31080316:3108056', 'assoc_mat': '31044453:pet_fonce:4230:31045201,31044466:pet_fonce:4230:31045239,31044500:pet_fonce:4230:31045354,31044541:pet_fonce:4230:31045337,31047372:pet_fonce:4230:31047426,31048443:pet_fonce:4230:31048536,31049899:pet_fonce:4230:31050071,31050103:pet_fonce:4230:31050325,31050355:pet_fonce:4230:31050563,31050597:pet_fonce:4230:31050908,31050882:pet_fonce:4230:31051017,31051623:pet_fonce:4230:31051798,31051836:pet_fonce:4230:31052036,31052146:pet_fonce:4230:31052347,31052393:pet_fonce:4230:31052605,31052642:pet_fonce:4230:31052844,31053101:pet_fonce:4230:31053571,31053358:pet_fonce:4230:31053608,31053850:pet_fonce:4230:31053981,31054029:pet_fonce:4230:31054279,31054321:pet_fonce:4230:31054539,31054836:pet_fonce:4230:31055053,31055341:pet_fonce:4230:31055554,31055586:pet_fonce:4230:31055793,31055824:pet_fonce:4230:31056028,31056811:pet_fonce:4230:31056981,31057487:pet_fonce:4230:31057692,31060480:pet_fonce:4230:31060644,31060718:pet_fonce:4230:31060927,31063312:pet_fonce:4230:31063356,31063744:pet_fonce:4230:31063868,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(2987112,2987342,2987532,2987668,2988218,2988690,2989192,2989720,2990228,2990722,2991234,2991764,2992364,2993108)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048704, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045154,31045202,31045230,31045285,31045328,31045350,31047258,31047415,31047842,31047889,31048289,31048318,31048372,31048538,31048977,31050063,31050322,31050562,31050906,31051006,31051340,31051589,31051787,31052001,31052042,31052358,31052609,31052837,31053050,31053573,31053616,31053819,31053975,31054271,31054540,31054799,31055055,31055299,31055546,31055787,31056018,31056285,31056537,31056769,31056979,31057235,31057446,31057659,31057698,31057959,31058206,31058442,31058699,31059009,31059168,31059410,31059668,31059888,31060136,31060406,31060639,31060911,31061170,31061609,31061859,31062109,31062230,31062468,31062686,31063005,31063205,31063231,31063357,31063674,31063856,31064074,31064366,31064482,31064694,31064730,31065203,31065442,31065684,31065999,31066274,31066480,31066682,31066881,31067076,31067385,31067590,31067755,31068034,31068235,31068436,31068487,31068652,31069000,31069192,31069432,31069720,31069959,31070181,31070299,31070640,31070894,31071161,31071276,31071454,31071697,31071953,31072155,31072365,3107266 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048705, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045165,31045203,31045238,31045288,31045339,31045356,31047266,31047427,31047849,31047893,31048294,31048330,31048366,31048531,31048974,31050069,31050318,31050570,31050895,31051023,31051328,31051581,31051789,31052003,31052040,31052353,31052604,31052850,31053057,31053559,31053613,31053809,31053990,31054283,31054532,31054793,31055061,31055298,31055553,31055795,31056022,31056290,31056531,31056780,31056983,31057234,31057443,31057646,31057693,31057953,31058196,31058445,31058695,31059013,31059169,31059406,31059670,31059892,31060144,31060408,31060647,31060922,31061162,31061364,31061613,31061864,31062116,31062240,31062475,31062680,31063006,31063203,31063238,31063368,31063675,31063866,31064077,31064369,31064491,31064701,31064742,31065197,31065450,31065676,31065998,31066282,31066487,31066683,31066887,31067068,31067398,31067599,31067761,31068041,31068236,31068441,31068481,31068657,31069001,31069186,31069438,31069736,31069970,31070172,31070301,31070653,31070889,31071158,31071285,31071458,31071711,31071957,31072159,3107237 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048706, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045156,31045200,31045233,31045294,31045336,31045358,31047267,31047844,31047891,31048328,31048370,31050311,31050560,31050903,31051327,31051579,31052600,31053056,31053601,31053980,31054534,31055057,31055303,31055544,31055790,31056019,31056529,31056775,31056966,31057441,31058451,31059155,31059889,31060648,31060926,31061158,31061352,31061865,31063004,31063861,31064356,31066691,31067065,31067394,31067745,31068031,31068240,31068474,31070654,31070891,31071160,31071281,31071446,31071706,31071944,31072157,31072361,31072660,31072777,31073068,31073514,31073979,31074244,31074574,31075269,31075449,31075930,31076365,31076524,31076747,31076952,31077972,31078693,31079783,31080099,31080265,31080551,31080726,31081165,31081301,31081585,31082047,31082285,31082561,31082788,31082973,31083194,31083445,31083651,31083894,31084100,31084124,31084370,31084423,31084680,31084861,31084996,31085209,31085380,31085668,31085943,31086147,31086399,31086644,31086938,31087143,31087831,31088044,31088288,31088444,31088697,31088940,31089197,3108922 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048707, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045167,31045199,31045237,31045299,31045324,31045355,31047260,31047423,31047856,31047888,31048285,31048327,31048376,31048537,31048980,31050073,31050326,31050569,31050900,31051013,31051333,31051586,31051799,31052004,31052046,31052359,31052601,31052851,31053052,31053561,31053618,31053817,31053988,31054282,31054527,31054797,31055056,31055308,31055547,31055796,31056034,31056289,31056532,31056773,31056982,31057228,31057442,31057658,31057689,31057958,31058208,31058452,31058702,31059018,31059166,31059409,31059656,31059890,31060137,31060400,31060634,31060914,31061156,31061368,31061603,31061871,31062113,31062232,31062478,31062683,31063003,31063193,31063228,31063367,31063680,31063860,31064065,31064373,31064496,31064700,31064733,31065205,31065458,31065673,31065997,31066281,31066481,31066687,31066886,31067080,31067391,31067587,31067756,31068046,31068242,31068440,31068485,31068651,31069002,31069191,31069428,31069732,31069966,31070177,31070310,31070645,31070898,31071152,31071283,31071450,31071708,31071949,31072161,3107237 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048708, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045159,31045205,31045241,31045297,31045332,31045345,31047892,31048325,31048539,31050070,31050327,31050567,31050905,31051021,31051334,31051582,31051794,31052010,31052041,31052356,31052606,31052854,31053061,31053566,31053614,31053808,31053985,31054276,31054537,31054796,31055058,31055306,31055549,31055797,31056032,31056292,31056522,31056767,31056974,31057230,31057437,31057697,31058704,31059006,31059171,31059414,31059894,31060140,31060641,31060919,31063235,31068244,31071162,31072368,31073521,31073758,31073807,31076950,31077195,31077965,31078416,31079776,31080107,31080276,31082050,31082294,31083886,31088709,31088953,31089204,31089235,31089434,31089867,31090259,31090541,31090782,31091232,31091772,31092218,31093123,31093315,31093559,31094130,31095139,31096493,31096965,31097001,31097121,31098449,31098575,31098820,31098965,31099401,31099644,31100126 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048709, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045162,31045204,31045242,31045295,31045334,31045347,31047255,31047429,31047854,31047881,31048297,31048323,31048374,31048535,31048981,31050076,31050319,31050568,31050909,31051018,31051336,31051590,31051784,31052007,31052044,31052355,31052611,31052843,31053064,31053569,31053612,31053814,31053989,31054277,31054528,31054795,31055050,31055305,31055556,31055785,31056033,31056291,31056538,31056777,31056971,31057233,31057447,31057657,31057691,31057957,31058204,31058450,31058703,31059019,31059165,31059417,31059667,31059893,31060149,31060405,31060637,31060915,31061168,31061362,31061602,31061873,31062108,31062241,31062483,31062689,31063002,31063198,31063237,31063364,31063669,31063871,31064071,31064367,31064498,31064703,31064740,31065206,31065452,31065678,31065996,31066277,31066483,31066684,31066891,31067077,31067393,31067602,31067757,31068045,31068245,31068448,31068476,31068653,31068992,31069188,31069439,31069735,31069971,31070178,31070304,31070644,31070897,31071150,31071291,31071461,31071702,31071952,31072151,3107236 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048710, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045201,31045239,31045337,31045354,31047426,31048536,31050071,31050325,31050563,31050908,31051017,31051798,31052036,31052347,31052605,31052844,31053571,31053608,31053981,31054279,31054539,31055053,31055554,31055793,31056028,31056981,31057692,31060644,31060927,31063356,31063868,31064076,31064362,31064495,31064739,31065455,31066283,31066479,31069183,31070312,31070888,31071710,31071942,31072158,31072376,31072656,31073769,31074481,31074871,31075657,31076742,31076949,31077485,31077971,31079725,31079777,31080565,31080970,31081163,31081308,31081801,31082043,31082293,31082783,31085942,31086156,31086648,31088051,31088291,31089195,31089865,31089998,31090252,31090535,31090786,31091520,31093322,31095960,31096212,31096497,31096964,31097002,31097130,31097476,31098461,31098572,31098819,31098959,31099404,31099649,31100127 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31048704,31048705,31048706,31048707,31048708,31048709,31048710?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=203 and date >='2026-08-01' and date <= '2026-08-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((608,),), 'unwanted_material_monthly_percentage': ((0.8198140261622744,),), 'material_repartition': (('incineration', 607),), 'material_dict': {'incineration': 607}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 8, 14), 0.6790808035311233, 3), (datetime.date(2026, 8, 15), 0.7924065073408638, 1), (datetime.date(2026, 8, 16), 0.8687405483073283, 1), (datetime.date(2026, 8, 17), 0.9019965048464774, 1), (datetime.date(2026, 8, 22), 0.6226730284352368, 2), (datetime.date(2026, 8, 23), 0.7312612639007766, 2), (datetime.date(2026, 8, 24), 0.8699700728223513, 2), (datetime.date(2026, 8, 25), 0.8741682107320672, 3), (datetime.date(2026, 8, 26), 0.8641083494303525, 3), (datetime.date(2026, 8, 27), 0.84366246322039, 4), (datetime.date(2026, 8, 28), 0.8361939540203248, 3), (datetime.date(2026, 8, 29), 0.8159167508450181, 4), (datetime.date(2026, 8, 30), 0.8329229334529885, 3), (datetime.date(2026, 8, 31), 0.8176257724498767, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 8, 14), 0.6790808035311233, 3), (datetime.date(2026, 8, 15), 0.7924065073408638, 1), (datetime.date(2026, 8, 16), 0.8687405483073283, 1), (datetime.date(2026, 8, 17), 0.9019965048464774, 1), (datetime.date(2026, 8, 22), 0.6226730284352368, 2), (datetime.date(2026, 8, 23), 0.7312612639007766, 2), (datetime.date(2026, 8, 24), 0.8699700728223513, 2), (datetime.date(2026, 8, 25), 0.8741682107320672, 3), (datetime.date(2026, 8, 26), 0.8641083494303525, 3), (datetime.date(2026, 8, 27), 0.84366246322039, 4), (datetime.date(2026, 8, 28), 0.8361939540203248, 3), (datetime.date(2026, 8, 29), 0.8159167508450181, 4), (datetime.date(2026, 8, 30), 0.8329229334529885, 3), (datetime.date(2026, 8, 31), 0.8176257724498767, 3))}, 'quality_array': [['-8.500600092514725', '14082026'], ['-8.380225041678893', '15082026'], ['-7.798405244041586', '16082026'], ['-7.601750892399866', '22082026'], ['-7.667412787949959', '23082026'], ['-6.389197044115896', '24082026'], ['-6.126966623405255', '25082026'], ['-6.984843408416952', '26082026'], ['-7.107247823363339', '27082026'], ['-7.686179034995705', '28082026'], ['-7.697503245481166', '29082026'], ['-7.588882053239747', '30082026'], ['-7.652108576703856', '31082026']], 'number_of_batch': ((242,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011340222567907798, 'nb_photo': 4484, 'list_port_cont': '31045154,31045202,31045230,31045285,31045328,31045350,31047258,31047415,31047842,31047889,31048289,31048318,31048372,31048538,31048977,31050063,31050322,31050562,31050906,31051006,31051340,31051589,31051787,31052001,31052042,31052358,31052609,31052837,31053050,31053573,31053616,31053819,31053975,31054271,31054540,31054799,31055055,31055299,31055546,31055787,31056018,31056285,31056537,31056769,31056979,31057235,31057446,31057659,31057698,31057959,31058206,31058442,31058699,31059009,31059168,31059410,31059668,31059888,31060136,31060406,31060639,31060911,31061170,31061609,31061859,31062109,31062230,31062468,31062686,31063005,31063205,31063231,31063357,31063674,31063856,31064074,31064366,31064482,31064694,31064730,31065203,31065442,31065684,31065999,31066274,31066480,31066682,31066881,31067076,31067385,31067590,31067755,31068034,31068235,31068436,31068487,31068652,31069000,31069192,31069432,31069720,31069959,31070181,31070299,31070640,31070894,31071161,31071276,31071454,31071697,31071953,31072155,31072365,3107266', 'assoc_port': '31044266:31045154,31044453:31045202,31044466:31045230,31044500:31045350,31044540:31045285,31044541:31045328,31045510:31047258,31047372:31047415,31047765:31047889,31047766:31047842,31048156:31048318,31048157:31048289,31048360:31048372,31048443:31048538,31048901:31048977,31049899:31050063,31050103:31050322,31050355:31050562,31050597:31050906,31050882:31051006,31051165:31051340,31051373:31051589,31051623:31051787,31051836:31052042,31051837:31052001,31052146:31052358,31052393:31052609,31052642:31052837,31052885:31053050,31053101:31053573,31053358:31053616,31053642:31053819,31053850:31053975,31054029:31054271,31054321:31054540,31054576:31054799,31054836:31055055,31055095:31055299,31055341:31055546,31055586:31055787,31055824:31056018,31056067:31056285,31056327:31056537,31056568:31056769,31056811:31056979,31057020:31057235,31057270:31057446,31057487:31057698,31057488:31057659,31057793:31057959,31058035:31058206,31058283:31058442,31058531:31058699,31058775:31059009,31058999:31059168,31059246:31059410,31059492:3105966', 'assoc_mat': '31044266:autre:4230:31045154,31044453:autre:4230:31045202,31044466:autre:4230:31045230,31044500:autre:4230:31045350,31044540:autre:4230:31045285,31044541:autre:4230:31045328,31045510:autre:4230:31047258,31047372:autre:4230:31047415,31047765:autre:4230:31047889,31047766:autre:4230:31047842,31048156:autre:4230:31048318,31048157:autre:4230:31048289,31048360:autre:4230:31048372,31048443:autre:4230:31048538,31048901:autre:4230:31048977,31049899:autre:4230:31050063,31050103:autre:4230:31050322,31050355:autre:4230:31050562,31050597:autre:4230:31050906,31050882:autre:4230:31051006,31051165:autre:4230:31051340,31051373:autre:4230:31051589,31051623:autre:4230:31051787,31051836:autre:4230:31052042,31051837:autre:4230:31052001,31052146:autre:4230:31052358,31052393:autre:4230:31052609,31052642:autre:4230:31052837,31052885:autre:4230:31053050,31053101:autre:4230:31053573,31053358:autre:4230:31053616,31053642:autre:4230:31053819,31053850:autre:4230:31053975,31054029:autre:4230:31054271,31054321:autre:4230:31054540,31054576:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03589963348073788, 'nb_photo': 17764, 'list_port_cont': '31045165,31045203,31045238,31045288,31045339,31045356,31047266,31047427,31047849,31047893,31048294,31048330,31048366,31048531,31048974,31050069,31050318,31050570,31050895,31051023,31051328,31051581,31051789,31052003,31052040,31052353,31052604,31052850,31053057,31053559,31053613,31053809,31053990,31054283,31054532,31054793,31055061,31055298,31055553,31055795,31056022,31056290,31056531,31056780,31056983,31057234,31057443,31057646,31057693,31057953,31058196,31058445,31058695,31059013,31059169,31059406,31059670,31059892,31060144,31060408,31060647,31060922,31061162,31061364,31061613,31061864,31062116,31062240,31062475,31062680,31063006,31063203,31063238,31063368,31063675,31063866,31064077,31064369,31064491,31064701,31064742,31065197,31065450,31065676,31065998,31066282,31066487,31066683,31066887,31067068,31067398,31067599,31067761,31068041,31068236,31068441,31068481,31068657,31069001,31069186,31069438,31069736,31069970,31070172,31070301,31070653,31070889,31071158,31071285,31071458,31071711,31071957,31072159,3107237', 'assoc_port': '31044266:31045165,31044453:31045203,31044466:31045238,31044500:31045356,31044540:31045288,31044541:31045339,31045510:31047266,31047372:31047427,31047765:31047893,31047766:31047849,31048156:31048330,31048157:31048294,31048360:31048366,31048443:31048531,31048901:31048974,31049899:31050069,31050103:31050318,31050355:31050570,31050597:31050895,31050882:31051023,31051165:31051328,31051373:31051581,31051623:31051789,31051836:31052040,31051837:31052003,31052146:31052353,31052393:31052604,31052642:31052850,31052885:31053057,31053101:31053559,31053358:31053613,31053642:31053809,31053850:31053990,31054029:31054283,31054321:31054532,31054576:31054793,31054836:31055061,31055095:31055298,31055341:31055553,31055586:31055795,31055824:31056022,31056067:31056290,31056327:31056531,31056568:31056780,31056811:31056983,31057020:31057234,31057270:31057443,31057487:31057693,31057488:31057646,31057793:31057953,31058035:31058196,31058283:31058445,31058531:31058695,31058775:31059013,31058999:31059169,31059246:31059406,31059492:3105967', 'assoc_mat': '31044266:carton:4230:31045165,31044453:carton:4230:31045203,31044466:carton:4230:31045238,31044500:carton:4230:31045356,31044540:carton:4230:31045288,31044541:carton:4230:31045339,31045510:carton:4230:31047266,31047372:carton:4230:31047427,31047765:carton:4230:31047893,31047766:carton:4230:31047849,31048156:carton:4230:31048330,31048157:carton:4230:31048294,31048360:carton:4230:31048366,31048443:carton:4230:31048531,31048901:carton:4230:31048974,31049899:carton:4230:31050069,31050103:carton:4230:31050318,31050355:carton:4230:31050570,31050597:carton:4230:31050895,31050882:carton:4230:31051023,31051165:carton:4230:31051328,31051373:carton:4230:31051581,31051623:carton:4230:31051789,31051836:carton:4230:31052040,31051837:carton:4230:31052003,31052146:carton:4230:31052353,31052393:carton:4230:31052604,31052642:carton:4230:31052850,31052885:carton:4230:31053057,31053101:carton:4230:31053559,31053358:carton:4230:31053613,31053642:carton:4230:31053809,31053850:carton:4230:31053990,31054029:carton:4230:31054283,3105'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010002787437836049, 'nb_photo': 389, 'list_port_cont': '31045156,31045200,31045233,31045294,31045336,31045358,31047267,31047844,31047891,31048328,31048370,31050311,31050560,31050903,31051327,31051579,31052600,31053056,31053601,31053980,31054534,31055057,31055303,31055544,31055790,31056019,31056529,31056775,31056966,31057441,31058451,31059155,31059889,31060648,31060926,31061158,31061352,31061865,31063004,31063861,31064356,31066691,31067065,31067394,31067745,31068031,31068240,31068474,31070654,31070891,31071160,31071281,31071446,31071706,31071944,31072157,31072361,31072660,31072777,31073068,31073514,31073979,31074244,31074574,31075269,31075449,31075930,31076365,31076524,31076747,31076952,31077972,31078693,31079783,31080099,31080265,31080551,31080726,31081165,31081301,31081585,31082047,31082285,31082561,31082788,31082973,31083194,31083445,31083651,31083894,31084100,31084124,31084370,31084423,31084680,31084861,31084996,31085209,31085380,31085668,31085943,31086147,31086399,31086644,31086938,31087143,31087831,31088044,31088288,31088444,31088697,31088940,31089197,3108922', 'assoc_port': '31044266:31045156,31044453:31045200,31044466:31045233,31044500:31045358,31044540:31045294,31044541:31045336,31045510:31047267,31047765:31047891,31047766:31047844,31048156:31048328,31048360:31048370,31050103:31050311,31050355:31050560,31050597:31050903,31051165:31051327,31051373:31051579,31052393:31052600,31052885:31053056,31053358:31053601,31053850:31053980,31054321:31054534,31054836:31055057,31055095:31055303,31055341:31055544,31055586:31055790,31055824:31056019,31056327:31056529,31056568:31056775,31056811:31056966,31057270:31057441,31058283:31058451,31058999:31059155,31059709:31059889,31060480:31060648,31060718:31060926,31060958:31061158,31061200:31061352,31061650:31061865,31062796:31063004,31063744:31063861,31064153:31064356,31066524:31066691,31066934:31067065,31067152:31067394,31067667:31067745,31067839:31068031,31068078:31068240,31068279:31068474,31070436:31070654,31070688:31070891,31070938:31071160,31071196:31071281,31071328:31071446,31071536:31071706,31071782:31071944,31072025:31072157,31072196:3107236', 'assoc_mat': '31044266:metal:4230:31045156,31044453:metal:4230:31045200,31044466:metal:4230:31045233,31044500:metal:4230:31045358,31044540:metal:4230:31045294,31044541:metal:4230:31045336,31045510:metal:4230:31047267,31047765:metal:4230:31047891,31047766:metal:4230:31047844,31048156:metal:4230:31048328,31048360:metal:4230:31048370,31050103:metal:4230:31050311,31050355:metal:4230:31050560,31050597:metal:4230:31050903,31051165:metal:4230:31051327,31051373:metal:4230:31051579,31052393:metal:4230:31052600,31052885:metal:4230:31053056,31053358:metal:4230:31053601,31053850:metal:4230:31053980,31054321:metal:4230:31054534,31054836:metal:4230:31055057,31055095:metal:4230:31055303,31055341:metal:4230:31055544,31055586:metal:4230:31055790,31055824:metal:4230:31056019,31056327:metal:4230:31056529,31056568:metal:4230:31056775,31056811:metal:4230:31056966,31057270:metal:4230:31057441,31058283:metal:4230:31058451,31058999:metal:4230:31059155,31059709:metal:4230:31059889,31060480:metal:4230:31060648,31060718:metal:4230:31060926,31060958:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.14543452819657324, 'nb_photo': 74348, 'list_port_cont': '31045167,31045199,31045237,31045299,31045324,31045355,31047260,31047423,31047856,31047888,31048285,31048327,31048376,31048537,31048980,31050073,31050326,31050569,31050900,31051013,31051333,31051586,31051799,31052004,31052046,31052359,31052601,31052851,31053052,31053561,31053618,31053817,31053988,31054282,31054527,31054797,31055056,31055308,31055547,31055796,31056034,31056289,31056532,31056773,31056982,31057228,31057442,31057658,31057689,31057958,31058208,31058452,31058702,31059018,31059166,31059409,31059656,31059890,31060137,31060400,31060634,31060914,31061156,31061368,31061603,31061871,31062113,31062232,31062478,31062683,31063003,31063193,31063228,31063367,31063680,31063860,31064065,31064373,31064496,31064700,31064733,31065205,31065458,31065673,31065997,31066281,31066481,31066687,31066886,31067080,31067391,31067587,31067756,31068046,31068242,31068440,31068485,31068651,31069002,31069191,31069428,31069732,31069966,31070177,31070310,31070645,31070898,31071152,31071283,31071450,31071708,31071949,31072161,3107237', 'assoc_port': '31044266:31045167,31044453:31045199,31044466:31045237,31044500:31045355,31044540:31045299,31044541:31045324,31045510:31047260,31047372:31047423,31047765:31047888,31047766:31047856,31048156:31048327,31048157:31048285,31048360:31048376,31048443:31048537,31048901:31048980,31049899:31050073,31050103:31050326,31050355:31050569,31050597:31050900,31050882:31051013,31051165:31051333,31051373:31051586,31051623:31051799,31051836:31052046,31051837:31052004,31052146:31052359,31052393:31052601,31052642:31052851,31052885:31053052,31053101:31053561,31053358:31053618,31053642:31053817,31053850:31053988,31054029:31054282,31054321:31054527,31054576:31054797,31054836:31055056,31055095:31055308,31055341:31055547,31055586:31055796,31055824:31056034,31056067:31056289,31056327:31056532,31056568:31056773,31056811:31056982,31057020:31057228,31057270:31057442,31057487:31057689,31057488:31057658,31057793:31057958,31058035:31058208,31058283:31058452,31058531:31058702,31058775:31059018,31058999:31059166,31059246:31059409,31059492:3105965', 'assoc_mat': '31044266:papier:4230:31045167,31044453:papier:4230:31045199,31044466:papier:4230:31045237,31044500:papier:4230:31045355,31044540:papier:4230:31045299,31044541:papier:4230:31045324,31045510:papier:4230:31047260,31047372:papier:4230:31047423,31047765:papier:4230:31047888,31047766:papier:4230:31047856,31048156:papier:4230:31048327,31048157:papier:4230:31048285,31048360:papier:4230:31048376,31048443:papier:4230:31048537,31048901:papier:4230:31048980,31049899:papier:4230:31050073,31050103:papier:4230:31050326,31050355:papier:4230:31050569,31050597:papier:4230:31050900,31050882:papier:4230:31051013,31051165:papier:4230:31051333,31051373:papier:4230:31051586,31051623:papier:4230:31051799,31051836:papier:4230:31052046,31051837:papier:4230:31052004,31052146:papier:4230:31052359,31052393:papier:4230:31052601,31052642:papier:4230:31052851,31052885:papier:4230:31053052,31053101:papier:4230:31053561,31053358:papier:4230:31053618,31053642:papier:4230:31053817,31053850:papier:4230:31053988,31054029:papier:4230:31054282,3105'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018318709636072513, 'nb_photo': 195, 'list_port_cont': '31045159,31045205,31045241,31045297,31045332,31045345,31047892,31048325,31048539,31050070,31050327,31050567,31050905,31051021,31051334,31051582,31051794,31052010,31052041,31052356,31052606,31052854,31053061,31053566,31053614,31053808,31053985,31054276,31054537,31054796,31055058,31055306,31055549,31055797,31056032,31056292,31056522,31056767,31056974,31057230,31057437,31057697,31058704,31059006,31059171,31059414,31059894,31060140,31060641,31060919,31063235,31068244,31071162,31072368,31073521,31073758,31073807,31076950,31077195,31077965,31078416,31079776,31080107,31080276,31082050,31082294,31083886,31088709,31088953,31089204,31089235,31089434,31089867,31090259,31090541,31090782,31091232,31091772,31092218,31093123,31093315,31093559,31094130,31095139,31096493,31096965,31097001,31097121,31098449,31098575,31098820,31098965,31099401,31099644,31100126', 'assoc_port': '31044266:31045159,31044453:31045205,31044466:31045241,31044500:31045345,31044540:31045297,31044541:31045332,31047765:31047892,31048156:31048325,31048443:31048539,31049899:31050070,31050103:31050327,31050355:31050567,31050597:31050905,31050882:31051021,31051165:31051334,31051373:31051582,31051623:31051794,31051836:31052041,31051837:31052010,31052146:31052356,31052393:31052606,31052642:31052854,31052885:31053061,31053101:31053566,31053358:31053614,31053642:31053808,31053850:31053985,31054029:31054276,31054321:31054537,31054576:31054796,31054836:31055058,31055095:31055306,31055341:31055549,31055586:31055797,31055824:31056032,31056067:31056292,31056327:31056522,31056568:31056767,31056811:31056974,31057020:31057230,31057270:31057437,31057487:31057697,31058531:31058704,31058775:31059006,31058999:31059171,31059246:31059414,31059709:31059894,31059969:31060140,31060480:31060641,31060718:31060919,31063037:31063235,31068078:31068244,31070938:31071162,31072196:31072368,31073357:31073521,31073598:31073758,31073599:3107380', 'assoc_mat': '31044266:pehd:4230:31045159,31044453:pehd:4230:31045205,31044466:pehd:4230:31045241,31044500:pehd:4230:31045345,31044540:pehd:4230:31045297,31044541:pehd:4230:31045332,31047765:pehd:4230:31047892,31048156:pehd:4230:31048325,31048443:pehd:4230:31048539,31049899:pehd:4230:31050070,31050103:pehd:4230:31050327,31050355:pehd:4230:31050567,31050597:pehd:4230:31050905,31050882:pehd:4230:31051021,31051165:pehd:4230:31051334,31051373:pehd:4230:31051582,31051623:pehd:4230:31051794,31051836:pehd:4230:31052041,31051837:pehd:4230:31052010,31052146:pehd:4230:31052356,31052393:pehd:4230:31052606,31052642:pehd:4230:31052854,31052885:pehd:4230:31053061,31053101:pehd:4230:31053566,31053358:pehd:4230:31053614,31053642:pehd:4230:31053808,31053850:pehd:4230:31053985,31054029:pehd:4230:31054276,31054321:pehd:4230:31054537,31054576:pehd:4230:31054796,31054836:pehd:4230:31055058,31055095:pehd:4230:31055306,31055341:pehd:4230:31055549,31055586:pehd:4230:31055797,31055824:pehd:4230:31056032,31056067:pehd:4230:31056292,31056327:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012476847884658153, 'nb_photo': 5208, 'list_port_cont': '31045162,31045204,31045242,31045295,31045334,31045347,31047255,31047429,31047854,31047881,31048297,31048323,31048374,31048535,31048981,31050076,31050319,31050568,31050909,31051018,31051336,31051590,31051784,31052007,31052044,31052355,31052611,31052843,31053064,31053569,31053612,31053814,31053989,31054277,31054528,31054795,31055050,31055305,31055556,31055785,31056033,31056291,31056538,31056777,31056971,31057233,31057447,31057657,31057691,31057957,31058204,31058450,31058703,31059019,31059165,31059417,31059667,31059893,31060149,31060405,31060637,31060915,31061168,31061362,31061602,31061873,31062108,31062241,31062483,31062689,31063002,31063198,31063237,31063364,31063669,31063871,31064071,31064367,31064498,31064703,31064740,31065206,31065452,31065678,31065996,31066277,31066483,31066684,31066891,31067077,31067393,31067602,31067757,31068045,31068245,31068448,31068476,31068653,31068992,31069188,31069439,31069735,31069971,31070178,31070304,31070644,31070897,31071150,31071291,31071461,31071702,31071952,31072151,3107236', 'assoc_port': '31044266:31045162,31044453:31045204,31044466:31045242,31044500:31045347,31044540:31045295,31044541:31045334,31045510:31047255,31047372:31047429,31047765:31047881,31047766:31047854,31048156:31048323,31048157:31048297,31048360:31048374,31048443:31048535,31048901:31048981,31049899:31050076,31050103:31050319,31050355:31050568,31050597:31050909,31050882:31051018,31051165:31051336,31051373:31051590,31051623:31051784,31051836:31052044,31051837:31052007,31052146:31052355,31052393:31052611,31052642:31052843,31052885:31053064,31053101:31053569,31053358:31053612,31053642:31053814,31053850:31053989,31054029:31054277,31054321:31054528,31054576:31054795,31054836:31055050,31055095:31055305,31055341:31055556,31055586:31055785,31055824:31056033,31056067:31056291,31056327:31056538,31056568:31056777,31056811:31056971,31057020:31057233,31057270:31057447,31057487:31057691,31057488:31057657,31057793:31057957,31058035:31058204,31058283:31058450,31058531:31058703,31058775:31059019,31058999:31059165,31059246:31059417,31059492:3105966', 'assoc_mat': '31044266:pet_clair:4230:31045162,31044453:pet_clair:4230:31045204,31044466:pet_clair:4230:31045242,31044500:pet_clair:4230:31045347,31044540:pet_clair:4230:31045295,31044541:pet_clair:4230:31045334,31045510:pet_clair:4230:31047255,31047372:pet_clair:4230:31047429,31047765:pet_clair:4230:31047881,31047766:pet_clair:4230:31047854,31048156:pet_clair:4230:31048323,31048157:pet_clair:4230:31048297,31048360:pet_clair:4230:31048374,31048443:pet_clair:4230:31048535,31048901:pet_clair:4230:31048981,31049899:pet_clair:4230:31050076,31050103:pet_clair:4230:31050319,31050355:pet_clair:4230:31050568,31050597:pet_clair:4230:31050909,31050882:pet_clair:4230:31051018,31051165:pet_clair:4230:31051336,31051373:pet_clair:4230:31051590,31051623:pet_clair:4230:31051784,31051836:pet_clair:4230:31052044,31051837:pet_clair:4230:31052007,31052146:pet_clair:4230:31052355,31052393:pet_clair:4230:31052611,31052642:pet_clair:4230:31052843,31052885:pet_clair:4230:31053064,31053101:pet_clair:4230:31053569,31053358:pet_clair:4230:31053612,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012998685849173579, 'nb_photo': 151, 'list_port_cont': '31045201,31045239,31045337,31045354,31047426,31048536,31050071,31050325,31050563,31050908,31051017,31051798,31052036,31052347,31052605,31052844,31053571,31053608,31053981,31054279,31054539,31055053,31055554,31055793,31056028,31056981,31057692,31060644,31060927,31063356,31063868,31064076,31064362,31064495,31064739,31065455,31066283,31066479,31069183,31070312,31070888,31071710,31071942,31072158,31072376,31072656,31073769,31074481,31074871,31075657,31076742,31076949,31077485,31077971,31079725,31079777,31080565,31080970,31081163,31081308,31081801,31082043,31082293,31082783,31085942,31086156,31086648,31088051,31088291,31089195,31089865,31089998,31090252,31090535,31090786,31091520,31093322,31095960,31096212,31096497,31096964,31097002,31097130,31097476,31098461,31098572,31098819,31098959,31099404,31099649,31100127', 'assoc_port': '31044453:31045201,31044466:31045239,31044500:31045354,31044541:31045337,31047372:31047426,31048443:31048536,31049899:31050071,31050103:31050325,31050355:31050563,31050597:31050908,31050882:31051017,31051623:31051798,31051836:31052036,31052146:31052347,31052393:31052605,31052642:31052844,31053101:31053571,31053358:31053608,31053850:31053981,31054029:31054279,31054321:31054539,31054836:31055053,31055341:31055554,31055586:31055793,31055824:31056028,31056811:31056981,31057487:31057692,31060480:31060644,31060718:31060927,31063312:31063356,31063744:31063868,31063911:31064076,31064153:31064362,31064401:31064495,31064571:31064739,31065247:31065455,31066062:31066283,31066313:31066479,31069030:31069183,31070217:31070312,31070688:31070888,31071536:31071710,31071782:31071942,31072025:31072158,31072196:31072376,31072451:31072656,31073598:31073769,31074319:31074481,31074651:31074871,31075522:31075657,31076575:31076742,31076817:31076949,31077264:31077485,31077766:31077971,31079527:31079725,31079755:31079777,31080316:3108056', 'assoc_mat': '31044453:pet_fonce:4230:31045201,31044466:pet_fonce:4230:31045239,31044500:pet_fonce:4230:31045354,31044541:pet_fonce:4230:31045337,31047372:pet_fonce:4230:31047426,31048443:pet_fonce:4230:31048536,31049899:pet_fonce:4230:31050071,31050103:pet_fonce:4230:31050325,31050355:pet_fonce:4230:31050563,31050597:pet_fonce:4230:31050908,31050882:pet_fonce:4230:31051017,31051623:pet_fonce:4230:31051798,31051836:pet_fonce:4230:31052036,31052146:pet_fonce:4230:31052347,31052393:pet_fonce:4230:31052605,31052642:pet_fonce:4230:31052844,31053101:pet_fonce:4230:31053571,31053358:pet_fonce:4230:31053608,31053850:pet_fonce:4230:31053981,31054029:pet_fonce:4230:31054279,31054321:pet_fonce:4230:31054539,31054836:pet_fonce:4230:31055053,31055341:pet_fonce:4230:31055554,31055586:pet_fonce:4230:31055793,31055824:pet_fonce:4230:31056028,31056811:pet_fonce:4230:31056981,31057487:pet_fonce:4230:31057692,31060480:pet_fonce:4230:31060644,31060718:pet_fonce:4230:31060927,31063312:pet_fonce:4230:31063356,31063744:pet_fonce:4230:31063868,3'}), 'main_stat': {'nb_photos': 608}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31048704,31048705,31048706,31048707,31048708,31048709,31048710?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-08', 0.8198140261622744),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # 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': ((608,),), 'unwanted_material_monthly_percentage': ((0.8198140261622744,),), 'material_repartition': (('incineration', 607),), 'material_dict': {'incineration': 607}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 8, 14), 0.6790808035311233, 3), (datetime.date(2026, 8, 15), 0.7924065073408638, 1), (datetime.date(2026, 8, 16), 0.8687405483073283, 1), (datetime.date(2026, 8, 17), 0.9019965048464774, 1), (datetime.date(2026, 8, 22), 0.6226730284352368, 2), (datetime.date(2026, 8, 23), 0.7312612639007766, 2), (datetime.date(2026, 8, 24), 0.8699700728223513, 2), (datetime.date(2026, 8, 25), 0.8741682107320672, 3), (datetime.date(2026, 8, 26), 0.8641083494303525, 3), (datetime.date(2026, 8, 27), 0.84366246322039, 4), (datetime.date(2026, 8, 28), 0.8361939540203248, 3), (datetime.date(2026, 8, 29), 0.8159167508450181, 4), (datetime.date(2026, 8, 30), 0.8329229334529885, 3), (datetime.date(2026, 8, 31), 0.8176257724498767, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 8, 14), 0.6790808035311233, 3), (datetime.date(2026, 8, 15), 0.7924065073408638, 1), (datetime.date(2026, 8, 16), 0.8687405483073283, 1), (datetime.date(2026, 8, 17), 0.9019965048464774, 1), (datetime.date(2026, 8, 22), 0.6226730284352368, 2), (datetime.date(2026, 8, 23), 0.7312612639007766, 2), (datetime.date(2026, 8, 24), 0.8699700728223513, 2), (datetime.date(2026, 8, 25), 0.8741682107320672, 3), (datetime.date(2026, 8, 26), 0.8641083494303525, 3), (datetime.date(2026, 8, 27), 0.84366246322039, 4), (datetime.date(2026, 8, 28), 0.8361939540203248, 3), (datetime.date(2026, 8, 29), 0.8159167508450181, 4), (datetime.date(2026, 8, 30), 0.8329229334529885, 3), (datetime.date(2026, 8, 31), 0.8176257724498767, 3))}, 'quality_array': [['-8.500600092514725', '14082026'], ['-8.380225041678893', '15082026'], ['-7.798405244041586', '16082026'], ['-7.601750892399866', '22082026'], ['-7.667412787949959', '23082026'], ['-6.389197044115896', '24082026'], ['-6.126966623405255', '25082026'], ['-6.984843408416952', '26082026'], ['-7.107247823363339', '27082026'], ['-7.686179034995705', '28082026'], ['-7.697503245481166', '29082026'], ['-7.588882053239747', '30082026'], ['-7.652108576703856', '31082026']], 'number_of_batch': ((242,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011340222567907798, 'nb_photo': 4484, 'list_port_cont': '31045154,31045202,31045230,31045285,31045328,31045350,31047258,31047415,31047842,31047889,31048289,31048318,31048372,31048538,31048977,31050063,31050322,31050562,31050906,31051006,31051340,31051589,31051787,31052001,31052042,31052358,31052609,31052837,31053050,31053573,31053616,31053819,31053975,31054271,31054540,31054799,31055055,31055299,31055546,31055787,31056018,31056285,31056537,31056769,31056979,31057235,31057446,31057659,31057698,31057959,31058206,31058442,31058699,31059009,31059168,31059410,31059668,31059888,31060136,31060406,31060639,31060911,31061170,31061609,31061859,31062109,31062230,31062468,31062686,31063005,31063205,31063231,31063357,31063674,31063856,31064074,31064366,31064482,31064694,31064730,31065203,31065442,31065684,31065999,31066274,31066480,31066682,31066881,31067076,31067385,31067590,31067755,31068034,31068235,31068436,31068487,31068652,31069000,31069192,31069432,31069720,31069959,31070181,31070299,31070640,31070894,31071161,31071276,31071454,31071697,31071953,31072155,31072365,3107266', 'assoc_port': '31044266:31045154,31044453:31045202,31044466:31045230,31044500:31045350,31044540:31045285,31044541:31045328,31045510:31047258,31047372:31047415,31047765:31047889,31047766:31047842,31048156:31048318,31048157:31048289,31048360:31048372,31048443:31048538,31048901:31048977,31049899:31050063,31050103:31050322,31050355:31050562,31050597:31050906,31050882:31051006,31051165:31051340,31051373:31051589,31051623:31051787,31051836:31052042,31051837:31052001,31052146:31052358,31052393:31052609,31052642:31052837,31052885:31053050,31053101:31053573,31053358:31053616,31053642:31053819,31053850:31053975,31054029:31054271,31054321:31054540,31054576:31054799,31054836:31055055,31055095:31055299,31055341:31055546,31055586:31055787,31055824:31056018,31056067:31056285,31056327:31056537,31056568:31056769,31056811:31056979,31057020:31057235,31057270:31057446,31057487:31057698,31057488:31057659,31057793:31057959,31058035:31058206,31058283:31058442,31058531:31058699,31058775:31059009,31058999:31059168,31059246:31059410,31059492:3105966', 'assoc_mat': '31044266:autre:4230:31045154,31044453:autre:4230:31045202,31044466:autre:4230:31045230,31044500:autre:4230:31045350,31044540:autre:4230:31045285,31044541:autre:4230:31045328,31045510:autre:4230:31047258,31047372:autre:4230:31047415,31047765:autre:4230:31047889,31047766:autre:4230:31047842,31048156:autre:4230:31048318,31048157:autre:4230:31048289,31048360:autre:4230:31048372,31048443:autre:4230:31048538,31048901:autre:4230:31048977,31049899:autre:4230:31050063,31050103:autre:4230:31050322,31050355:autre:4230:31050562,31050597:autre:4230:31050906,31050882:autre:4230:31051006,31051165:autre:4230:31051340,31051373:autre:4230:31051589,31051623:autre:4230:31051787,31051836:autre:4230:31052042,31051837:autre:4230:31052001,31052146:autre:4230:31052358,31052393:autre:4230:31052609,31052642:autre:4230:31052837,31052885:autre:4230:31053050,31053101:autre:4230:31053573,31053358:autre:4230:31053616,31053642:autre:4230:31053819,31053850:autre:4230:31053975,31054029:autre:4230:31054271,31054321:autre:4230:31054540,31054576:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03589963348073788, 'nb_photo': 17764, 'list_port_cont': '31045165,31045203,31045238,31045288,31045339,31045356,31047266,31047427,31047849,31047893,31048294,31048330,31048366,31048531,31048974,31050069,31050318,31050570,31050895,31051023,31051328,31051581,31051789,31052003,31052040,31052353,31052604,31052850,31053057,31053559,31053613,31053809,31053990,31054283,31054532,31054793,31055061,31055298,31055553,31055795,31056022,31056290,31056531,31056780,31056983,31057234,31057443,31057646,31057693,31057953,31058196,31058445,31058695,31059013,31059169,31059406,31059670,31059892,31060144,31060408,31060647,31060922,31061162,31061364,31061613,31061864,31062116,31062240,31062475,31062680,31063006,31063203,31063238,31063368,31063675,31063866,31064077,31064369,31064491,31064701,31064742,31065197,31065450,31065676,31065998,31066282,31066487,31066683,31066887,31067068,31067398,31067599,31067761,31068041,31068236,31068441,31068481,31068657,31069001,31069186,31069438,31069736,31069970,31070172,31070301,31070653,31070889,31071158,31071285,31071458,31071711,31071957,31072159,3107237', 'assoc_port': '31044266:31045165,31044453:31045203,31044466:31045238,31044500:31045356,31044540:31045288,31044541:31045339,31045510:31047266,31047372:31047427,31047765:31047893,31047766:31047849,31048156:31048330,31048157:31048294,31048360:31048366,31048443:31048531,31048901:31048974,31049899:31050069,31050103:31050318,31050355:31050570,31050597:31050895,31050882:31051023,31051165:31051328,31051373:31051581,31051623:31051789,31051836:31052040,31051837:31052003,31052146:31052353,31052393:31052604,31052642:31052850,31052885:31053057,31053101:31053559,31053358:31053613,31053642:31053809,31053850:31053990,31054029:31054283,31054321:31054532,31054576:31054793,31054836:31055061,31055095:31055298,31055341:31055553,31055586:31055795,31055824:31056022,31056067:31056290,31056327:31056531,31056568:31056780,31056811:31056983,31057020:31057234,31057270:31057443,31057487:31057693,31057488:31057646,31057793:31057953,31058035:31058196,31058283:31058445,31058531:31058695,31058775:31059013,31058999:31059169,31059246:31059406,31059492:3105967', 'assoc_mat': '31044266:carton:4230:31045165,31044453:carton:4230:31045203,31044466:carton:4230:31045238,31044500:carton:4230:31045356,31044540:carton:4230:31045288,31044541:carton:4230:31045339,31045510:carton:4230:31047266,31047372:carton:4230:31047427,31047765:carton:4230:31047893,31047766:carton:4230:31047849,31048156:carton:4230:31048330,31048157:carton:4230:31048294,31048360:carton:4230:31048366,31048443:carton:4230:31048531,31048901:carton:4230:31048974,31049899:carton:4230:31050069,31050103:carton:4230:31050318,31050355:carton:4230:31050570,31050597:carton:4230:31050895,31050882:carton:4230:31051023,31051165:carton:4230:31051328,31051373:carton:4230:31051581,31051623:carton:4230:31051789,31051836:carton:4230:31052040,31051837:carton:4230:31052003,31052146:carton:4230:31052353,31052393:carton:4230:31052604,31052642:carton:4230:31052850,31052885:carton:4230:31053057,31053101:carton:4230:31053559,31053358:carton:4230:31053613,31053642:carton:4230:31053809,31053850:carton:4230:31053990,31054029:carton:4230:31054283,3105'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010002787437836049, 'nb_photo': 389, 'list_port_cont': '31045156,31045200,31045233,31045294,31045336,31045358,31047267,31047844,31047891,31048328,31048370,31050311,31050560,31050903,31051327,31051579,31052600,31053056,31053601,31053980,31054534,31055057,31055303,31055544,31055790,31056019,31056529,31056775,31056966,31057441,31058451,31059155,31059889,31060648,31060926,31061158,31061352,31061865,31063004,31063861,31064356,31066691,31067065,31067394,31067745,31068031,31068240,31068474,31070654,31070891,31071160,31071281,31071446,31071706,31071944,31072157,31072361,31072660,31072777,31073068,31073514,31073979,31074244,31074574,31075269,31075449,31075930,31076365,31076524,31076747,31076952,31077972,31078693,31079783,31080099,31080265,31080551,31080726,31081165,31081301,31081585,31082047,31082285,31082561,31082788,31082973,31083194,31083445,31083651,31083894,31084100,31084124,31084370,31084423,31084680,31084861,31084996,31085209,31085380,31085668,31085943,31086147,31086399,31086644,31086938,31087143,31087831,31088044,31088288,31088444,31088697,31088940,31089197,3108922', 'assoc_port': '31044266:31045156,31044453:31045200,31044466:31045233,31044500:31045358,31044540:31045294,31044541:31045336,31045510:31047267,31047765:31047891,31047766:31047844,31048156:31048328,31048360:31048370,31050103:31050311,31050355:31050560,31050597:31050903,31051165:31051327,31051373:31051579,31052393:31052600,31052885:31053056,31053358:31053601,31053850:31053980,31054321:31054534,31054836:31055057,31055095:31055303,31055341:31055544,31055586:31055790,31055824:31056019,31056327:31056529,31056568:31056775,31056811:31056966,31057270:31057441,31058283:31058451,31058999:31059155,31059709:31059889,31060480:31060648,31060718:31060926,31060958:31061158,31061200:31061352,31061650:31061865,31062796:31063004,31063744:31063861,31064153:31064356,31066524:31066691,31066934:31067065,31067152:31067394,31067667:31067745,31067839:31068031,31068078:31068240,31068279:31068474,31070436:31070654,31070688:31070891,31070938:31071160,31071196:31071281,31071328:31071446,31071536:31071706,31071782:31071944,31072025:31072157,31072196:3107236', 'assoc_mat': '31044266:metal:4230:31045156,31044453:metal:4230:31045200,31044466:metal:4230:31045233,31044500:metal:4230:31045358,31044540:metal:4230:31045294,31044541:metal:4230:31045336,31045510:metal:4230:31047267,31047765:metal:4230:31047891,31047766:metal:4230:31047844,31048156:metal:4230:31048328,31048360:metal:4230:31048370,31050103:metal:4230:31050311,31050355:metal:4230:31050560,31050597:metal:4230:31050903,31051165:metal:4230:31051327,31051373:metal:4230:31051579,31052393:metal:4230:31052600,31052885:metal:4230:31053056,31053358:metal:4230:31053601,31053850:metal:4230:31053980,31054321:metal:4230:31054534,31054836:metal:4230:31055057,31055095:metal:4230:31055303,31055341:metal:4230:31055544,31055586:metal:4230:31055790,31055824:metal:4230:31056019,31056327:metal:4230:31056529,31056568:metal:4230:31056775,31056811:metal:4230:31056966,31057270:metal:4230:31057441,31058283:metal:4230:31058451,31058999:metal:4230:31059155,31059709:metal:4230:31059889,31060480:metal:4230:31060648,31060718:metal:4230:31060926,31060958:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.14543452819657324, 'nb_photo': 74348, 'list_port_cont': '31045167,31045199,31045237,31045299,31045324,31045355,31047260,31047423,31047856,31047888,31048285,31048327,31048376,31048537,31048980,31050073,31050326,31050569,31050900,31051013,31051333,31051586,31051799,31052004,31052046,31052359,31052601,31052851,31053052,31053561,31053618,31053817,31053988,31054282,31054527,31054797,31055056,31055308,31055547,31055796,31056034,31056289,31056532,31056773,31056982,31057228,31057442,31057658,31057689,31057958,31058208,31058452,31058702,31059018,31059166,31059409,31059656,31059890,31060137,31060400,31060634,31060914,31061156,31061368,31061603,31061871,31062113,31062232,31062478,31062683,31063003,31063193,31063228,31063367,31063680,31063860,31064065,31064373,31064496,31064700,31064733,31065205,31065458,31065673,31065997,31066281,31066481,31066687,31066886,31067080,31067391,31067587,31067756,31068046,31068242,31068440,31068485,31068651,31069002,31069191,31069428,31069732,31069966,31070177,31070310,31070645,31070898,31071152,31071283,31071450,31071708,31071949,31072161,3107237', 'assoc_port': '31044266:31045167,31044453:31045199,31044466:31045237,31044500:31045355,31044540:31045299,31044541:31045324,31045510:31047260,31047372:31047423,31047765:31047888,31047766:31047856,31048156:31048327,31048157:31048285,31048360:31048376,31048443:31048537,31048901:31048980,31049899:31050073,31050103:31050326,31050355:31050569,31050597:31050900,31050882:31051013,31051165:31051333,31051373:31051586,31051623:31051799,31051836:31052046,31051837:31052004,31052146:31052359,31052393:31052601,31052642:31052851,31052885:31053052,31053101:31053561,31053358:31053618,31053642:31053817,31053850:31053988,31054029:31054282,31054321:31054527,31054576:31054797,31054836:31055056,31055095:31055308,31055341:31055547,31055586:31055796,31055824:31056034,31056067:31056289,31056327:31056532,31056568:31056773,31056811:31056982,31057020:31057228,31057270:31057442,31057487:31057689,31057488:31057658,31057793:31057958,31058035:31058208,31058283:31058452,31058531:31058702,31058775:31059018,31058999:31059166,31059246:31059409,31059492:3105965', 'assoc_mat': '31044266:papier:4230:31045167,31044453:papier:4230:31045199,31044466:papier:4230:31045237,31044500:papier:4230:31045355,31044540:papier:4230:31045299,31044541:papier:4230:31045324,31045510:papier:4230:31047260,31047372:papier:4230:31047423,31047765:papier:4230:31047888,31047766:papier:4230:31047856,31048156:papier:4230:31048327,31048157:papier:4230:31048285,31048360:papier:4230:31048376,31048443:papier:4230:31048537,31048901:papier:4230:31048980,31049899:papier:4230:31050073,31050103:papier:4230:31050326,31050355:papier:4230:31050569,31050597:papier:4230:31050900,31050882:papier:4230:31051013,31051165:papier:4230:31051333,31051373:papier:4230:31051586,31051623:papier:4230:31051799,31051836:papier:4230:31052046,31051837:papier:4230:31052004,31052146:papier:4230:31052359,31052393:papier:4230:31052601,31052642:papier:4230:31052851,31052885:papier:4230:31053052,31053101:papier:4230:31053561,31053358:papier:4230:31053618,31053642:papier:4230:31053817,31053850:papier:4230:31053988,31054029:papier:4230:31054282,3105'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018318709636072513, 'nb_photo': 195, 'list_port_cont': '31045159,31045205,31045241,31045297,31045332,31045345,31047892,31048325,31048539,31050070,31050327,31050567,31050905,31051021,31051334,31051582,31051794,31052010,31052041,31052356,31052606,31052854,31053061,31053566,31053614,31053808,31053985,31054276,31054537,31054796,31055058,31055306,31055549,31055797,31056032,31056292,31056522,31056767,31056974,31057230,31057437,31057697,31058704,31059006,31059171,31059414,31059894,31060140,31060641,31060919,31063235,31068244,31071162,31072368,31073521,31073758,31073807,31076950,31077195,31077965,31078416,31079776,31080107,31080276,31082050,31082294,31083886,31088709,31088953,31089204,31089235,31089434,31089867,31090259,31090541,31090782,31091232,31091772,31092218,31093123,31093315,31093559,31094130,31095139,31096493,31096965,31097001,31097121,31098449,31098575,31098820,31098965,31099401,31099644,31100126', 'assoc_port': '31044266:31045159,31044453:31045205,31044466:31045241,31044500:31045345,31044540:31045297,31044541:31045332,31047765:31047892,31048156:31048325,31048443:31048539,31049899:31050070,31050103:31050327,31050355:31050567,31050597:31050905,31050882:31051021,31051165:31051334,31051373:31051582,31051623:31051794,31051836:31052041,31051837:31052010,31052146:31052356,31052393:31052606,31052642:31052854,31052885:31053061,31053101:31053566,31053358:31053614,31053642:31053808,31053850:31053985,31054029:31054276,31054321:31054537,31054576:31054796,31054836:31055058,31055095:31055306,31055341:31055549,31055586:31055797,31055824:31056032,31056067:31056292,31056327:31056522,31056568:31056767,31056811:31056974,31057020:31057230,31057270:31057437,31057487:31057697,31058531:31058704,31058775:31059006,31058999:31059171,31059246:31059414,31059709:31059894,31059969:31060140,31060480:31060641,31060718:31060919,31063037:31063235,31068078:31068244,31070938:31071162,31072196:31072368,31073357:31073521,31073598:31073758,31073599:3107380', 'assoc_mat': '31044266:pehd:4230:31045159,31044453:pehd:4230:31045205,31044466:pehd:4230:31045241,31044500:pehd:4230:31045345,31044540:pehd:4230:31045297,31044541:pehd:4230:31045332,31047765:pehd:4230:31047892,31048156:pehd:4230:31048325,31048443:pehd:4230:31048539,31049899:pehd:4230:31050070,31050103:pehd:4230:31050327,31050355:pehd:4230:31050567,31050597:pehd:4230:31050905,31050882:pehd:4230:31051021,31051165:pehd:4230:31051334,31051373:pehd:4230:31051582,31051623:pehd:4230:31051794,31051836:pehd:4230:31052041,31051837:pehd:4230:31052010,31052146:pehd:4230:31052356,31052393:pehd:4230:31052606,31052642:pehd:4230:31052854,31052885:pehd:4230:31053061,31053101:pehd:4230:31053566,31053358:pehd:4230:31053614,31053642:pehd:4230:31053808,31053850:pehd:4230:31053985,31054029:pehd:4230:31054276,31054321:pehd:4230:31054537,31054576:pehd:4230:31054796,31054836:pehd:4230:31055058,31055095:pehd:4230:31055306,31055341:pehd:4230:31055549,31055586:pehd:4230:31055797,31055824:pehd:4230:31056032,31056067:pehd:4230:31056292,31056327:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012476847884658153, 'nb_photo': 5208, 'list_port_cont': '31045162,31045204,31045242,31045295,31045334,31045347,31047255,31047429,31047854,31047881,31048297,31048323,31048374,31048535,31048981,31050076,31050319,31050568,31050909,31051018,31051336,31051590,31051784,31052007,31052044,31052355,31052611,31052843,31053064,31053569,31053612,31053814,31053989,31054277,31054528,31054795,31055050,31055305,31055556,31055785,31056033,31056291,31056538,31056777,31056971,31057233,31057447,31057657,31057691,31057957,31058204,31058450,31058703,31059019,31059165,31059417,31059667,31059893,31060149,31060405,31060637,31060915,31061168,31061362,31061602,31061873,31062108,31062241,31062483,31062689,31063002,31063198,31063237,31063364,31063669,31063871,31064071,31064367,31064498,31064703,31064740,31065206,31065452,31065678,31065996,31066277,31066483,31066684,31066891,31067077,31067393,31067602,31067757,31068045,31068245,31068448,31068476,31068653,31068992,31069188,31069439,31069735,31069971,31070178,31070304,31070644,31070897,31071150,31071291,31071461,31071702,31071952,31072151,3107236', 'assoc_port': '31044266:31045162,31044453:31045204,31044466:31045242,31044500:31045347,31044540:31045295,31044541:31045334,31045510:31047255,31047372:31047429,31047765:31047881,31047766:31047854,31048156:31048323,31048157:31048297,31048360:31048374,31048443:31048535,31048901:31048981,31049899:31050076,31050103:31050319,31050355:31050568,31050597:31050909,31050882:31051018,31051165:31051336,31051373:31051590,31051623:31051784,31051836:31052044,31051837:31052007,31052146:31052355,31052393:31052611,31052642:31052843,31052885:31053064,31053101:31053569,31053358:31053612,31053642:31053814,31053850:31053989,31054029:31054277,31054321:31054528,31054576:31054795,31054836:31055050,31055095:31055305,31055341:31055556,31055586:31055785,31055824:31056033,31056067:31056291,31056327:31056538,31056568:31056777,31056811:31056971,31057020:31057233,31057270:31057447,31057487:31057691,31057488:31057657,31057793:31057957,31058035:31058204,31058283:31058450,31058531:31058703,31058775:31059019,31058999:31059165,31059246:31059417,31059492:3105966', 'assoc_mat': '31044266:pet_clair:4230:31045162,31044453:pet_clair:4230:31045204,31044466:pet_clair:4230:31045242,31044500:pet_clair:4230:31045347,31044540:pet_clair:4230:31045295,31044541:pet_clair:4230:31045334,31045510:pet_clair:4230:31047255,31047372:pet_clair:4230:31047429,31047765:pet_clair:4230:31047881,31047766:pet_clair:4230:31047854,31048156:pet_clair:4230:31048323,31048157:pet_clair:4230:31048297,31048360:pet_clair:4230:31048374,31048443:pet_clair:4230:31048535,31048901:pet_clair:4230:31048981,31049899:pet_clair:4230:31050076,31050103:pet_clair:4230:31050319,31050355:pet_clair:4230:31050568,31050597:pet_clair:4230:31050909,31050882:pet_clair:4230:31051018,31051165:pet_clair:4230:31051336,31051373:pet_clair:4230:31051590,31051623:pet_clair:4230:31051784,31051836:pet_clair:4230:31052044,31051837:pet_clair:4230:31052007,31052146:pet_clair:4230:31052355,31052393:pet_clair:4230:31052611,31052642:pet_clair:4230:31052843,31052885:pet_clair:4230:31053064,31053101:pet_clair:4230:31053569,31053358:pet_clair:4230:31053612,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012998685849173579, 'nb_photo': 151, 'list_port_cont': '31045201,31045239,31045337,31045354,31047426,31048536,31050071,31050325,31050563,31050908,31051017,31051798,31052036,31052347,31052605,31052844,31053571,31053608,31053981,31054279,31054539,31055053,31055554,31055793,31056028,31056981,31057692,31060644,31060927,31063356,31063868,31064076,31064362,31064495,31064739,31065455,31066283,31066479,31069183,31070312,31070888,31071710,31071942,31072158,31072376,31072656,31073769,31074481,31074871,31075657,31076742,31076949,31077485,31077971,31079725,31079777,31080565,31080970,31081163,31081308,31081801,31082043,31082293,31082783,31085942,31086156,31086648,31088051,31088291,31089195,31089865,31089998,31090252,31090535,31090786,31091520,31093322,31095960,31096212,31096497,31096964,31097002,31097130,31097476,31098461,31098572,31098819,31098959,31099404,31099649,31100127', 'assoc_port': '31044453:31045201,31044466:31045239,31044500:31045354,31044541:31045337,31047372:31047426,31048443:31048536,31049899:31050071,31050103:31050325,31050355:31050563,31050597:31050908,31050882:31051017,31051623:31051798,31051836:31052036,31052146:31052347,31052393:31052605,31052642:31052844,31053101:31053571,31053358:31053608,31053850:31053981,31054029:31054279,31054321:31054539,31054836:31055053,31055341:31055554,31055586:31055793,31055824:31056028,31056811:31056981,31057487:31057692,31060480:31060644,31060718:31060927,31063312:31063356,31063744:31063868,31063911:31064076,31064153:31064362,31064401:31064495,31064571:31064739,31065247:31065455,31066062:31066283,31066313:31066479,31069030:31069183,31070217:31070312,31070688:31070888,31071536:31071710,31071782:31071942,31072025:31072158,31072196:31072376,31072451:31072656,31073598:31073769,31074319:31074481,31074651:31074871,31075522:31075657,31076575:31076742,31076817:31076949,31077264:31077485,31077766:31077971,31079527:31079725,31079755:31079777,31080316:3108056', 'assoc_mat': '31044453:pet_fonce:4230:31045201,31044466:pet_fonce:4230:31045239,31044500:pet_fonce:4230:31045354,31044541:pet_fonce:4230:31045337,31047372:pet_fonce:4230:31047426,31048443:pet_fonce:4230:31048536,31049899:pet_fonce:4230:31050071,31050103:pet_fonce:4230:31050325,31050355:pet_fonce:4230:31050563,31050597:pet_fonce:4230:31050908,31050882:pet_fonce:4230:31051017,31051623:pet_fonce:4230:31051798,31051836:pet_fonce:4230:31052036,31052146:pet_fonce:4230:31052347,31052393:pet_fonce:4230:31052605,31052642:pet_fonce:4230:31052844,31053101:pet_fonce:4230:31053571,31053358:pet_fonce:4230:31053608,31053850:pet_fonce:4230:31053981,31054029:pet_fonce:4230:31054279,31054321:pet_fonce:4230:31054539,31054836:pet_fonce:4230:31055053,31055341:pet_fonce:4230:31055554,31055586:pet_fonce:4230:31055793,31055824:pet_fonce:4230:31056028,31056811:pet_fonce:4230:31056981,31057487:pet_fonce:4230:31057692,31060480:pet_fonce:4230:31060644,31060718:pet_fonce:4230:31060927,31063312:pet_fonce:4230:31063356,31063744:pet_fonce:4230:31063868,3'}), 'main_stat': {'nb_photos': 608}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31048704,31048705,31048706,31048707,31048708,31048709,31048710?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-08', 0.8198140261622744),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_08_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.13%', 4484], 'carton': ['carton', '3.59%', 17764], 'metal': ['metal', '0.1%', 389], 'papier': ['papier', '14.54%', 74348], 'pehd': ['pehd', '0.18%', 195], 'pet_clair': ['pet_clair', '1.25%', 5208], 'pet_fonce': ['pet_fonce', '0.13%', 151]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_08_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.42user 2.85system 0:09.02elapsed 58%CPU (0avgtext+0avgdata 190292maxresident)k 127280inputs+296outputs (653major+53801minor)pagefaults 0swaps