python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-10 _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 : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 10 mtr_id : dashboard_places : SCCU_cam6 date : 2026-10 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam6' and date like '%2026-10%') and created_at like '%2026-10%'))); nb_day : (3, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 202 and month(ded.date) = 10 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 202 and month(ded.date) = 10 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%102026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-10-01 : dt_date_just_month_year : 2026-10-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-10-01" AND ded.date <= "2026-10-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 (3011130,3011798,3012506,3013146,3013842,3014446,3015040,3015514,3015736,3016542,3017070,3017594,3018312,3018644,3019218,3019812,3020400,3020648) 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.02022763119293866, 'nb_photo': 13003, 'list_port_cont': '31243303,31243338,31243773,31243961,31244033,31244207,31245755,31245831,31245877,31245917,31245945,31245989,31246109,31246336,31246449,31246497,31246651,31246731,31246941,31247071,31247357,31247519,31247564,31248005,31248073,31248300,31248552,31248697,31249145,31249324,31249912,31250026,31250197,31250653,31250814,31251019,31251189,31251397,31251645,31251905,31252301,31252583,31252656,31252800,31253073,31253135,31253181,31253549,31253794,31253931,31254212,31254860,31255089,31255380,31255437,31255697,31256073,31256117,31256407,31256717,31256899,31257144,31257222,31257511,31257728,31257817,31258103,31258415,31258612,31258858,31259149,31259494,31259582,31259853,31260233,31260588,31260855,31261097,31261335,31261499,31261543,31262214,31262497,31262743,31262783,31263092,31263171,31263486,31263686,31264062,31264291,31264563,31264837,31265066,31265385,31265838,31265912,31266492,31266807,31267102,31267507,31267630,31267816,31268029,31268131,31268409,31268528,31268859,31268893,31269332,31269372,31269419,31269461,3127000', 'assoc_port': '31243157:31243961,31243158:31243338,31243159:31243303,31243610:31243773,31243809:31244033,31244059:31244207,31244513:31245755,31244591:31245831,31244677:31245877,31244936:31246336,31245203:31245989,31245204:31245945,31245458:31245917,31245477:31246109,31246187:31246497,31246188:31246449,31246560:31246731,31246561:31246651,31246764:31246941,31247015:31247071,31247263:31247357,31247461:31247519,31247462:31247564,31247974:31248005,31247975:31248073,31248196:31248300,31248412:31248552,31248619:31248697,31248890:31249912,31249108:31249145,31249311:31249324,31249604:31250026,31250143:31250197,31250360:31250814,31250514:31250653,31250834:31251019,31251008:31251189,31251262:31251397,31251432:31251645,31251719:31251905,31251978:31252301,31252412:31252656,31252413:31252583,31252731:31252800,31252860:31253073,31253049:31253135,31253050:31253181,31253459:31253549,31253696:31253794,31253828:31253931,31254115:31254212,31254398:31254860,31254969:31255437,31254970:31255089,31255210:31255380,31255461:31255697,31255845:3125607', 'assoc_mat': '31243157:autre:4230:31243961,31243158:autre:4230:31243338,31243159:autre:4230:31243303,31243610:autre:4230:31243773,31243809:autre:4230:31244033,31244059:autre:4230:31244207,31244513:autre:4230:31245755,31244591:autre:4230:31245831,31244677:autre:4230:31245877,31244936:autre:4230:31246336,31245203:autre:4230:31245989,31245204:autre:4230:31245945,31245458:autre:4230:31245917,31245477:autre:4230:31246109,31246187:autre:4230:31246497,31246188:autre:4230:31246449,31246560:autre:4230:31246731,31246561:autre:4230:31246651,31246764:autre:4230:31246941,31247015:autre:4230:31247071,31247263:autre:4230:31247357,31247461:autre:4230:31247519,31247462:autre:4230:31247564,31247974:autre:4230:31248005,31247975:autre:4230:31248073,31248196:autre:4230:31248300,31248412:autre:4230:31248552,31248619:autre:4230:31248697,31248890:autre:4230:31249912,31249108:autre:4230:31249145,31249311:autre:4230:31249324,31249604:autre:4230:31250026,31250143:autre:4230:31250197,31250360:autre:4230:31250814,31250514:autre:4230:31250653,31250834:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0552374047605066, 'nb_photo': 56518, 'list_port_cont': '31243306,31243333,31243787,31243954,31244027,31244209,31245764,31245839,31245883,31245921,31245954,31245982,31246120,31246348,31246462,31246492,31246668,31246738,31246948,31247080,31247366,31247522,31247573,31248012,31248089,31248307,31248553,31248695,31249151,31249336,31249899,31250030,31250200,31250657,31250806,31251030,31251199,31251413,31251644,31251916,31252318,31252592,31252667,31252792,31253074,31253142,31253187,31253541,31253804,31253924,31254221,31254869,31255100,31255394,31255439,31255704,31256077,31256106,31256408,31256722,31256906,31257154,31257221,31257520,31257726,31257820,31258099,31258420,31258611,31258860,31259160,31259510,31259578,31259867,31260234,31260579,31260858,31261109,31261347,31261508,31261547,31262225,31262507,31262745,31262780,31263094,31263186,31263496,31263698,31264065,31264298,31264565,31264834,31265070,31265389,31265848,31265918,31266486,31266803,31267117,31267503,31267631,31267822,31268037,31268130,31268415,31268529,31268853,31268904,31269345,31269375,31269423,31269453,3127000', 'assoc_port': '31243157:31243954,31243158:31243333,31243159:31243306,31243610:31243787,31243809:31244027,31244059:31244209,31244513:31245764,31244591:31245839,31244677:31245883,31244936:31246348,31245203:31245982,31245204:31245954,31245458:31245921,31245477:31246120,31246187:31246492,31246188:31246462,31246560:31246738,31246561:31246668,31246764:31246948,31247015:31247080,31247263:31247366,31247461:31247522,31247462:31247573,31247974:31248012,31247975:31248089,31248196:31248307,31248412:31248553,31248619:31248695,31248890:31249899,31249108:31249151,31249311:31249336,31249604:31250030,31250143:31250200,31250360:31250806,31250514:31250657,31250834:31251030,31251008:31251199,31251262:31251413,31251432:31251644,31251719:31251916,31251978:31252318,31252412:31252667,31252413:31252592,31252731:31252792,31252860:31253074,31253049:31253142,31253050:31253187,31253459:31253541,31253696:31253804,31253828:31253924,31254115:31254221,31254398:31254869,31254969:31255439,31254970:31255100,31255210:31255394,31255461:31255704,31255845:3125607', 'assoc_mat': '31243157:carton:4230:31243954,31243158:carton:4230:31243333,31243159:carton:4230:31243306,31243610:carton:4230:31243787,31243809:carton:4230:31244027,31244059:carton:4230:31244209,31244513:carton:4230:31245764,31244591:carton:4230:31245839,31244677:carton:4230:31245883,31244936:carton:4230:31246348,31245203:carton:4230:31245982,31245204:carton:4230:31245954,31245458:carton:4230:31245921,31245477:carton:4230:31246120,31246187:carton:4230:31246492,31246188:carton:4230:31246462,31246560:carton:4230:31246738,31246561:carton:4230:31246668,31246764:carton:4230:31246948,31247015:carton:4230:31247080,31247263:carton:4230:31247366,31247461:carton:4230:31247522,31247462:carton:4230:31247573,31247974:carton:4230:31248012,31247975:carton:4230:31248089,31248196:carton:4230:31248307,31248412:carton:4230:31248553,31248619:carton:4230:31248695,31248890:carton:4230:31249899,31249108:carton:4230:31249151,31249311:carton:4230:31249336,31249604:carton:4230:31250030,31250143:carton:4230:31250200,31250360:carton:4230:31250806,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0015990367919615995, 'nb_photo': 1297, 'list_port_cont': '31243302,31244036,31245754,31245834,31245869,31245911,31245956,31245994,31246105,31246345,31246447,31246481,31246659,31246732,31246953,31247372,31247534,31247567,31248006,31248078,31248295,31248556,31248700,31249157,31249323,31249905,31250019,31250201,31250650,31250813,31251032,31251190,31251403,31251652,31251917,31252306,31252671,31253060,31253788,31253923,31254214,31254857,31255097,31255386,31255431,31255702,31256078,31256111,31256395,31256710,31256889,31257138,31257213,31257518,31257723,31258098,31258407,31258620,31259153,31259498,31259580,31259852,31260226,31260581,31260850,31261108,31261498,31262218,31262506,31262747,31263091,31263495,31263690,31264058,31264294,31264557,31264842,31265388,31265846,31265913,31266484,31266793,31267118,31267510,31267623,31267814,31268028,31268127,31268403,31268521,31268864,31268894,31269335,31269381,31269410,31269465,31270001,31270102,31270461,31270799,31270846,31271229,31271390,31271947,31272021,31272059,31272586,31272702,31273160,31273198,31273611,31273668,31274142,3127428', 'assoc_port': '31243159:31243302,31243809:31244036,31244513:31245754,31244591:31245834,31244677:31245869,31244936:31246345,31245203:31245994,31245204:31245956,31245458:31245911,31245477:31246105,31246187:31246481,31246188:31246447,31246560:31246732,31246561:31246659,31246764:31246953,31247263:31247372,31247461:31247534,31247462:31247567,31247974:31248006,31247975:31248078,31248196:31248295,31248412:31248556,31248619:31248700,31248890:31249905,31249108:31249157,31249311:31249323,31249604:31250019,31250143:31250201,31250360:31250813,31250514:31250650,31250834:31251032,31251008:31251190,31251262:31251403,31251432:31251652,31251719:31251917,31251978:31252306,31252412:31252671,31252860:31253060,31253696:31253788,31253828:31253923,31254115:31254214,31254398:31254857,31254969:31255431,31254970:31255097,31255210:31255386,31255461:31255702,31255845:31256078,31255846:31256111,31256178:31256395,31256434:31256710,31256760:31256889,31256932:31257138,31256933:31257213,31257299:31257518,31257588:31257723,31258037:31258098,31258249:3125840', 'assoc_mat': '31243159:metal:4230:31243302,31243809:metal:4230:31244036,31244513:metal:4230:31245754,31244591:metal:4230:31245834,31244677:metal:4230:31245869,31244936:metal:4230:31246345,31245203:metal:4230:31245994,31245204:metal:4230:31245956,31245458:metal:4230:31245911,31245477:metal:4230:31246105,31246187:metal:4230:31246481,31246188:metal:4230:31246447,31246560:metal:4230:31246732,31246561:metal:4230:31246659,31246764:metal:4230:31246953,31247263:metal:4230:31247372,31247461:metal:4230:31247534,31247462:metal:4230:31247567,31247974:metal:4230:31248006,31247975:metal:4230:31248078,31248196:metal:4230:31248295,31248412:metal:4230:31248556,31248619:metal:4230:31248700,31248890:metal:4230:31249905,31249108:metal:4230:31249157,31249311:metal:4230:31249323,31249604:metal:4230:31250019,31250143:metal:4230:31250201,31250360:metal:4230:31250813,31250514:metal:4230:31250650,31250834:metal:4230:31251032,31251008:metal:4230:31251190,31251262:metal:4230:31251403,31251432:metal:4230:31251652,31251719:metal:4230:31251917,31251978:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.21249494551270032, 'nb_photo': 262954, 'list_port_cont': '31243308,31243337,31243781,31243949,31244037,31244210,31245767,31245844,31245874,31245918,31245957,31245992,31246117,31246343,31246459,31246490,31246666,31246734,31246950,31247068,31247373,31247531,31247572,31247999,31248083,31248309,31248550,31248698,31249156,31249328,31249910,31250031,31250212,31250661,31250810,31251028,31251201,31251405,31251650,31251914,31252307,31252591,31252672,31252802,31253063,31253139,31253185,31253546,31253805,31253926,31254226,31254868,31255099,31255385,31255441,31255696,31256072,31256113,31256401,31256720,31256903,31257152,31257224,31257522,31257729,31257825,31258092,31258424,31258616,31258849,31259163,31259506,31259581,31259863,31260225,31260583,31260859,31261105,31261343,31261506,31261553,31262223,31262509,31262748,31262777,31263096,31263184,31263490,31263695,31264066,31264296,31264558,31264844,31265067,31265390,31265845,31265909,31266498,31266800,31267113,31267506,31267639,31267823,31268041,31268132,31268407,31268525,31268860,31268895,31269346,31269377,31269424,31269463,3127000', 'assoc_port': '31243157:31243949,31243158:31243337,31243159:31243308,31243610:31243781,31243809:31244037,31244059:31244210,31244513:31245767,31244591:31245844,31244677:31245874,31244936:31246343,31245203:31245992,31245204:31245957,31245458:31245918,31245477:31246117,31246187:31246490,31246188:31246459,31246560:31246734,31246561:31246666,31246764:31246950,31247015:31247068,31247263:31247373,31247461:31247531,31247462:31247572,31247974:31247999,31247975:31248083,31248196:31248309,31248412:31248550,31248619:31248698,31248890:31249910,31249108:31249156,31249311:31249328,31249604:31250031,31250143:31250212,31250360:31250810,31250514:31250661,31250834:31251028,31251008:31251201,31251262:31251405,31251432:31251650,31251719:31251914,31251978:31252307,31252412:31252672,31252413:31252591,31252731:31252802,31252860:31253063,31253049:31253139,31253050:31253185,31253459:31253546,31253696:31253805,31253828:31253926,31254115:31254226,31254398:31254868,31254969:31255441,31254970:31255099,31255210:31255385,31255461:31255696,31255845:3125607', 'assoc_mat': '31243157:papier:4230:31243949,31243158:papier:4230:31243337,31243159:papier:4230:31243308,31243610:papier:4230:31243781,31243809:papier:4230:31244037,31244059:papier:4230:31244210,31244513:papier:4230:31245767,31244591:papier:4230:31245844,31244677:papier:4230:31245874,31244936:papier:4230:31246343,31245203:papier:4230:31245992,31245204:papier:4230:31245957,31245458:papier:4230:31245918,31245477:papier:4230:31246117,31246187:papier:4230:31246490,31246188:papier:4230:31246459,31246560:papier:4230:31246734,31246561:papier:4230:31246666,31246764:papier:4230:31246950,31247015:papier:4230:31247068,31247263:papier:4230:31247373,31247461:papier:4230:31247531,31247462:papier:4230:31247572,31247974:papier:4230:31247999,31247975:papier:4230:31248083,31248196:papier:4230:31248309,31248412:papier:4230:31248550,31248619:papier:4230:31248698,31248890:papier:4230:31249910,31249108:papier:4230:31249156,31249311:papier:4230:31249328,31249604:papier:4230:31250031,31250143:papier:4230:31250212,31250360:papier:4230:31250810,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005504713218147078, 'nb_photo': 1852, 'list_port_cont': '31243297,31243344,31243784,31243955,31244025,31245769,31245845,31245872,31245912,31245993,31246118,31246340,31246494,31246727,31247368,31247523,31247570,31248004,31248087,31248298,31248554,31249149,31249335,31250028,31250214,31250648,31250811,31251029,31251200,31251406,31251658,31251913,31252317,31252590,31252666,31252797,31253072,31253141,31253177,31253542,31253801,31253934,31254223,31254865,31255085,31255392,31255440,31255705,31256071,31256120,31256404,31256721,31256905,31257148,31257223,31257513,31257826,31258418,31258610,31259150,31259499,31259576,31259866,31260231,31260582,31260856,31261102,31261349,31261502,31261542,31262500,31263095,31265847,31265916,31266495,31266801,31267109,31267511,31267638,31267811,31268043,31268125,31268420,31268531,31268863,31268903,31269384,31269425,31269462,31270011,31270103,31270285,31270466,31270804,31270845,31271243,31271395,31271966,31272031,31272056,31272585,31272712,31273150,31273202,31273626,31273670,31274152,31274187,31274269,31275075,31275483,31275938,31276183,3127654', 'assoc_port': '31243157:31243955,31243158:31243344,31243159:31243297,31243610:31243784,31243809:31244025,31244513:31245769,31244591:31245845,31244677:31245872,31244936:31246340,31245203:31245993,31245458:31245912,31245477:31246118,31246187:31246494,31246560:31246727,31247263:31247368,31247461:31247523,31247462:31247570,31247974:31248004,31247975:31248087,31248196:31248298,31248412:31248554,31249108:31249149,31249311:31249335,31249604:31250028,31250143:31250214,31250360:31250811,31250514:31250648,31250834:31251029,31251008:31251200,31251262:31251406,31251432:31251658,31251719:31251913,31251978:31252317,31252412:31252666,31252413:31252590,31252731:31252797,31252860:31253072,31253049:31253141,31253050:31253177,31253459:31253542,31253696:31253801,31253828:31253934,31254115:31254223,31254398:31254865,31254969:31255440,31254970:31255085,31255210:31255392,31255461:31255705,31255845:31256071,31255846:31256120,31256178:31256404,31256434:31256721,31256760:31256905,31256932:31257148,31256933:31257223,31257299:31257513,31257759:3125782', 'assoc_mat': '31243157:pehd:4230:31243955,31243158:pehd:4230:31243344,31243159:pehd:4230:31243297,31243610:pehd:4230:31243784,31243809:pehd:4230:31244025,31244513:pehd:4230:31245769,31244591:pehd:4230:31245845,31244677:pehd:4230:31245872,31244936:pehd:4230:31246340,31245203:pehd:4230:31245993,31245458:pehd:4230:31245912,31245477:pehd:4230:31246118,31246187:pehd:4230:31246494,31246560:pehd:4230:31246727,31247263:pehd:4230:31247368,31247461:pehd:4230:31247523,31247462:pehd:4230:31247570,31247974:pehd:4230:31248004,31247975:pehd:4230:31248087,31248196:pehd:4230:31248298,31248412:pehd:4230:31248554,31249108:pehd:4230:31249149,31249311:pehd:4230:31249335,31249604:pehd:4230:31250028,31250143:pehd:4230:31250214,31250360:pehd:4230:31250811,31250514:pehd:4230:31250648,31250834:pehd:4230:31251029,31251008:pehd:4230:31251200,31251262:pehd:4230:31251406,31251432:pehd:4230:31251658,31251719:pehd:4230:31251913,31251978:pehd:4230:31252317,31252412:pehd:4230:31252666,31252413:pehd:4230:31252590,31252731:pehd:4230:31252797,31252860:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015142502244208466, 'nb_photo': 15275, 'list_port_cont': '31243301,31243335,31243785,31243960,31244029,31244222,31245762,31245846,31245878,31245919,31245952,31245981,31246112,31246353,31246458,31246498,31246663,31246739,31246956,31247076,31247367,31247528,31247566,31248014,31248085,31248302,31248551,31248692,31249148,31249326,31249904,31250027,31250211,31250659,31250812,31251018,31251193,31251404,31251654,31251918,31252315,31252587,31252670,31252798,31253067,31253151,31253186,31253544,31253800,31253928,31254224,31254870,31255091,31255391,31255430,31255698,31256068,31256116,31256410,31256709,31256893,31257151,31257217,31257512,31257730,31257822,31258096,31258417,31258619,31258864,31259154,31259507,31259583,31259858,31260237,31260587,31260861,31261106,31261339,31261512,31261550,31262221,31262501,31262746,31262781,31263090,31263178,31263499,31263685,31264063,31264297,31264566,31264838,31265061,31265379,31265841,31265921,31266494,31266802,31267107,31267512,31267640,31267817,31268039,31268119,31268414,31268533,31268856,31268902,31269348,31269385,31269415,31269458,3127001', 'assoc_port': '31243157:31243960,31243158:31243335,31243159:31243301,31243610:31243785,31243809:31244029,31244059:31244222,31244513:31245762,31244591:31245846,31244677:31245878,31244936:31246353,31245203:31245981,31245204:31245952,31245458:31245919,31245477:31246112,31246187:31246498,31246188:31246458,31246560:31246739,31246561:31246663,31246764:31246956,31247015:31247076,31247263:31247367,31247461:31247528,31247462:31247566,31247974:31248014,31247975:31248085,31248196:31248302,31248412:31248551,31248619:31248692,31248890:31249904,31249108:31249148,31249311:31249326,31249604:31250027,31250143:31250211,31250360:31250812,31250514:31250659,31250834:31251018,31251008:31251193,31251262:31251404,31251432:31251654,31251719:31251918,31251978:31252315,31252412:31252670,31252413:31252587,31252731:31252798,31252860:31253067,31253049:31253151,31253050:31253186,31253459:31253544,31253696:31253800,31253828:31253928,31254115:31254224,31254398:31254870,31254969:31255430,31254970:31255091,31255210:31255391,31255461:31255698,31255845:3125606', 'assoc_mat': '31243157:pet_clair:4230:31243960,31243158:pet_clair:4230:31243335,31243159:pet_clair:4230:31243301,31243610:pet_clair:4230:31243785,31243809:pet_clair:4230:31244029,31244059:pet_clair:4230:31244222,31244513:pet_clair:4230:31245762,31244591:pet_clair:4230:31245846,31244677:pet_clair:4230:31245878,31244936:pet_clair:4230:31246353,31245203:pet_clair:4230:31245981,31245204:pet_clair:4230:31245952,31245458:pet_clair:4230:31245919,31245477:pet_clair:4230:31246112,31246187:pet_clair:4230:31246498,31246188:pet_clair:4230:31246458,31246560:pet_clair:4230:31246739,31246561:pet_clair:4230:31246663,31246764:pet_clair:4230:31246956,31247015:pet_clair:4230:31247076,31247263:pet_clair:4230:31247367,31247461:pet_clair:4230:31247528,31247462:pet_clair:4230:31247566,31247974:pet_clair:4230:31248014,31247975:pet_clair:4230:31248085,31248196:pet_clair:4230:31248302,31248412:pet_clair:4230:31248551,31248619:pet_clair:4230:31248692,31248890:pet_clair:4230:31249904,31249108:pet_clair:4230:31249148,31249311:pet_clair:4230:31249326,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003107514034321112, 'nb_photo': 766, 'list_port_cont': '31243342,31243789,31243952,31244035,31245840,31245873,31245916,31245995,31246114,31246349,31246491,31246667,31247370,31247569,31248090,31248299,31248542,31249142,31250035,31250660,31250803,31251025,31251198,31251408,31251653,31251911,31252309,31252597,31252662,31253071,31253147,31253179,31253547,31253802,31253929,31254217,31255094,31255393,31255433,31255701,31256067,31256110,31256403,31256715,31256894,31257153,31257227,31257515,31257727,31258421,31258615,31259162,31259509,31260576,31261107,31261348,31261514,31261549,31262510,31263084,31263183,31263492,31264287,31264843,31265387,31265839,31265914,31266497,31267119,31267514,31267634,31267815,31268040,31268134,31268418,31268851,31268899,31269343,31269378,31269426,31269456,31269999,31270107,31270279,31270465,31270798,31270847,31271960,31272026,31272599,31272706,31273163,31273197,31273623,31273674,31274154,31274186,31274261,31274753,31274789,31274927,31275448,31275486,31275626,31275936,31276186,31276544,31276731,31277004,31277107,31277261,31277718,31278302,3127850', 'assoc_port': '31243157:31243952,31243158:31243342,31243610:31243789,31243809:31244035,31244591:31245840,31244677:31245873,31244936:31246349,31245203:31245995,31245458:31245916,31245477:31246114,31246187:31246491,31246561:31246667,31247263:31247370,31247462:31247569,31247975:31248090,31248196:31248299,31248412:31248542,31249108:31249142,31249604:31250035,31250360:31250803,31250514:31250660,31250834:31251025,31251008:31251198,31251262:31251408,31251432:31251653,31251719:31251911,31251978:31252309,31252412:31252662,31252413:31252597,31252860:31253071,31253049:31253147,31253050:31253179,31253459:31253547,31253696:31253802,31253828:31253929,31254115:31254217,31254969:31255433,31254970:31255094,31255210:31255393,31255461:31255701,31255845:31256067,31255846:31256110,31256178:31256403,31256434:31256715,31256760:31256894,31256932:31257153,31256933:31257227,31257299:31257515,31257588:31257727,31258249:31258421,31258484:31258615,31258933:31259162,31259326:31259509,31260334:31260576,31260957:31261107,31261165:31261348,31261370:3126154', 'assoc_mat': '31243157:pet_fonce:4230:31243952,31243158:pet_fonce:4230:31243342,31243610:pet_fonce:4230:31243789,31243809:pet_fonce:4230:31244035,31244591:pet_fonce:4230:31245840,31244677:pet_fonce:4230:31245873,31244936:pet_fonce:4230:31246349,31245203:pet_fonce:4230:31245995,31245458:pet_fonce:4230:31245916,31245477:pet_fonce:4230:31246114,31246187:pet_fonce:4230:31246491,31246561:pet_fonce:4230:31246667,31247263:pet_fonce:4230:31247370,31247462:pet_fonce:4230:31247569,31247975:pet_fonce:4230:31248090,31248196:pet_fonce:4230:31248299,31248412:pet_fonce:4230:31248542,31249108:pet_fonce:4230:31249142,31249604:pet_fonce:4230:31250035,31250360:pet_fonce:4230:31250803,31250514:pet_fonce:4230:31250660,31250834:pet_fonce:4230:31251025,31251008:pet_fonce:4230:31251198,31251262:pet_fonce:4230:31251408,31251432:pet_fonce:4230:31251653,31251719:pet_fonce:4230:31251911,31251978:pet_fonce:4230:31252309,31252412:pet_fonce:4230:31252662,31252413:pet_fonce:4230:31252597,31252860:pet_fonce:4230:31253071,31253049:pet_fonce:4230:31253147,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(3011130,3011798,3012506,3013146,3013842,3014446,3015040,3015514,3015736,3016542,3017070,3017594,3018312,3018644,3019218,3019812,3020400,3020648)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341139, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243303,31243338,31243773,31243961,31244033,31244207,31245755,31245831,31245877,31245917,31245945,31245989,31246109,31246336,31246449,31246497,31246651,31246731,31246941,31247071,31247357,31247519,31247564,31248005,31248073,31248300,31248552,31248697,31249145,31249324,31249912,31250026,31250197,31250653,31250814,31251019,31251189,31251397,31251645,31251905,31252301,31252583,31252656,31252800,31253073,31253135,31253181,31253549,31253794,31253931,31254212,31254860,31255089,31255380,31255437,31255697,31256073,31256117,31256407,31256717,31256899,31257144,31257222,31257511,31257728,31257817,31258103,31258415,31258612,31258858,31259149,31259494,31259582,31259853,31260233,31260588,31260855,31261097,31261335,31261499,31261543,31262214,31262497,31262743,31262783,31263092,31263171,31263486,31263686,31264062,31264291,31264563,31264837,31265066,31265385,31265838,31265912,31266492,31266807,31267102,31267507,31267630,31267816,31268029,31268131,31268409,31268528,31268859,31268893,31269332,31269372,31269419,31269461,3127000 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341140, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243306,31243333,31243787,31243954,31244027,31244209,31245764,31245839,31245883,31245921,31245954,31245982,31246120,31246348,31246462,31246492,31246668,31246738,31246948,31247080,31247366,31247522,31247573,31248012,31248089,31248307,31248553,31248695,31249151,31249336,31249899,31250030,31250200,31250657,31250806,31251030,31251199,31251413,31251644,31251916,31252318,31252592,31252667,31252792,31253074,31253142,31253187,31253541,31253804,31253924,31254221,31254869,31255100,31255394,31255439,31255704,31256077,31256106,31256408,31256722,31256906,31257154,31257221,31257520,31257726,31257820,31258099,31258420,31258611,31258860,31259160,31259510,31259578,31259867,31260234,31260579,31260858,31261109,31261347,31261508,31261547,31262225,31262507,31262745,31262780,31263094,31263186,31263496,31263698,31264065,31264298,31264565,31264834,31265070,31265389,31265848,31265918,31266486,31266803,31267117,31267503,31267631,31267822,31268037,31268130,31268415,31268529,31268853,31268904,31269345,31269375,31269423,31269453,3127000 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341141, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243302,31244036,31245754,31245834,31245869,31245911,31245956,31245994,31246105,31246345,31246447,31246481,31246659,31246732,31246953,31247372,31247534,31247567,31248006,31248078,31248295,31248556,31248700,31249157,31249323,31249905,31250019,31250201,31250650,31250813,31251032,31251190,31251403,31251652,31251917,31252306,31252671,31253060,31253788,31253923,31254214,31254857,31255097,31255386,31255431,31255702,31256078,31256111,31256395,31256710,31256889,31257138,31257213,31257518,31257723,31258098,31258407,31258620,31259153,31259498,31259580,31259852,31260226,31260581,31260850,31261108,31261498,31262218,31262506,31262747,31263091,31263495,31263690,31264058,31264294,31264557,31264842,31265388,31265846,31265913,31266484,31266793,31267118,31267510,31267623,31267814,31268028,31268127,31268403,31268521,31268864,31268894,31269335,31269381,31269410,31269465,31270001,31270102,31270461,31270799,31270846,31271229,31271390,31271947,31272021,31272059,31272586,31272702,31273160,31273198,31273611,31273668,31274142,3127428 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341142, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243308,31243337,31243781,31243949,31244037,31244210,31245767,31245844,31245874,31245918,31245957,31245992,31246117,31246343,31246459,31246490,31246666,31246734,31246950,31247068,31247373,31247531,31247572,31247999,31248083,31248309,31248550,31248698,31249156,31249328,31249910,31250031,31250212,31250661,31250810,31251028,31251201,31251405,31251650,31251914,31252307,31252591,31252672,31252802,31253063,31253139,31253185,31253546,31253805,31253926,31254226,31254868,31255099,31255385,31255441,31255696,31256072,31256113,31256401,31256720,31256903,31257152,31257224,31257522,31257729,31257825,31258092,31258424,31258616,31258849,31259163,31259506,31259581,31259863,31260225,31260583,31260859,31261105,31261343,31261506,31261553,31262223,31262509,31262748,31262777,31263096,31263184,31263490,31263695,31264066,31264296,31264558,31264844,31265067,31265390,31265845,31265909,31266498,31266800,31267113,31267506,31267639,31267823,31268041,31268132,31268407,31268525,31268860,31268895,31269346,31269377,31269424,31269463,3127000 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341143, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243297,31243344,31243784,31243955,31244025,31245769,31245845,31245872,31245912,31245993,31246118,31246340,31246494,31246727,31247368,31247523,31247570,31248004,31248087,31248298,31248554,31249149,31249335,31250028,31250214,31250648,31250811,31251029,31251200,31251406,31251658,31251913,31252317,31252590,31252666,31252797,31253072,31253141,31253177,31253542,31253801,31253934,31254223,31254865,31255085,31255392,31255440,31255705,31256071,31256120,31256404,31256721,31256905,31257148,31257223,31257513,31257826,31258418,31258610,31259150,31259499,31259576,31259866,31260231,31260582,31260856,31261102,31261349,31261502,31261542,31262500,31263095,31265847,31265916,31266495,31266801,31267109,31267511,31267638,31267811,31268043,31268125,31268420,31268531,31268863,31268903,31269384,31269425,31269462,31270011,31270103,31270285,31270466,31270804,31270845,31271243,31271395,31271966,31272031,31272056,31272585,31272712,31273150,31273202,31273626,31273670,31274152,31274187,31274269,31275075,31275483,31275938,31276183,3127654 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341144, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243301,31243335,31243785,31243960,31244029,31244222,31245762,31245846,31245878,31245919,31245952,31245981,31246112,31246353,31246458,31246498,31246663,31246739,31246956,31247076,31247367,31247528,31247566,31248014,31248085,31248302,31248551,31248692,31249148,31249326,31249904,31250027,31250211,31250659,31250812,31251018,31251193,31251404,31251654,31251918,31252315,31252587,31252670,31252798,31253067,31253151,31253186,31253544,31253800,31253928,31254224,31254870,31255091,31255391,31255430,31255698,31256068,31256116,31256410,31256709,31256893,31257151,31257217,31257512,31257730,31257822,31258096,31258417,31258619,31258864,31259154,31259507,31259583,31259858,31260237,31260587,31260861,31261106,31261339,31261512,31261550,31262221,31262501,31262746,31262781,31263090,31263178,31263499,31263685,31264063,31264297,31264566,31264838,31265061,31265379,31265841,31265921,31266494,31266802,31267107,31267512,31267640,31267817,31268039,31268119,31268414,31268533,31268856,31268902,31269348,31269385,31269415,31269458,3127001 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341145, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243342,31243789,31243952,31244035,31245840,31245873,31245916,31245995,31246114,31246349,31246491,31246667,31247370,31247569,31248090,31248299,31248542,31249142,31250035,31250660,31250803,31251025,31251198,31251408,31251653,31251911,31252309,31252597,31252662,31253071,31253147,31253179,31253547,31253802,31253929,31254217,31255094,31255393,31255433,31255701,31256067,31256110,31256403,31256715,31256894,31257153,31257227,31257515,31257727,31258421,31258615,31259162,31259509,31260576,31261107,31261348,31261514,31261549,31262510,31263084,31263183,31263492,31264287,31264843,31265387,31265839,31265914,31266497,31267119,31267514,31267634,31267815,31268040,31268134,31268418,31268851,31268899,31269343,31269378,31269426,31269456,31269999,31270107,31270279,31270465,31270798,31270847,31271960,31272026,31272599,31272706,31273163,31273197,31273623,31273674,31274154,31274186,31274261,31274753,31274789,31274927,31275448,31275486,31275626,31275936,31276186,31276544,31276731,31277004,31277107,31277261,31277718,31278302,3127850 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31341139,31341140,31341141,31341142,31341143,31341144,31341145?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2026-10-01' and date <= '2026-10-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1032,),), 'unwanted_material_monthly_percentage': ((0.7176473337266674,),), 'material_repartition': (('incineration', 1029),), 'material_dict': {'incineration': 1029}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 10, 1), 0.7122028745827107, 2), (datetime.date(2026, 10, 2), 0.6640461583182016, 1), (datetime.date(2026, 10, 3), 0.715571917220856, 1), (datetime.date(2026, 10, 4), 0.7923783958101845, 1), (datetime.date(2026, 10, 5), 0.7432557721524449, 4), (datetime.date(2026, 10, 6), 0.6893164222958932, 3), (datetime.date(2026, 10, 7), 0.658536279600553, 1), (datetime.date(2026, 10, 8), 0.730565811453993, 2), (datetime.date(2026, 10, 9), 0.7407657467761343, 2), (datetime.date(2026, 10, 10), 0.6924191863174799, 4), (datetime.date(2026, 10, 11), 0.7996083673460196, 3), (datetime.date(2026, 10, 12), 0.7689306631415268, 2), (datetime.date(2026, 10, 13), 0.7106422891660283, 3), (datetime.date(2026, 10, 14), 0.6808230003611088, 2), (datetime.date(2026, 10, 15), 0.6968102768688516, 2), (datetime.date(2026, 10, 16), 0.6770758317324755, 3), (datetime.date(2026, 10, 17), 0.6902326895069898, 4), (datetime.date(2026, 10, 18), 0.7883548400188759, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 10, 1), 0.7122028745827107, 2), (datetime.date(2026, 10, 2), 0.6640461583182016, 1), (datetime.date(2026, 10, 3), 0.715571917220856, 1), (datetime.date(2026, 10, 4), 0.7923783958101845, 1), (datetime.date(2026, 10, 5), 0.7432557721524449, 4), (datetime.date(2026, 10, 6), 0.6893164222958932, 3), (datetime.date(2026, 10, 7), 0.658536279600553, 1), (datetime.date(2026, 10, 8), 0.730565811453993, 2), (datetime.date(2026, 10, 9), 0.7407657467761343, 2), (datetime.date(2026, 10, 10), 0.6924191863174799, 4), (datetime.date(2026, 10, 11), 0.7996083673460196, 3), (datetime.date(2026, 10, 12), 0.7689306631415268, 2), (datetime.date(2026, 10, 13), 0.7106422891660283, 3), (datetime.date(2026, 10, 14), 0.6808230003611088, 2), (datetime.date(2026, 10, 15), 0.6968102768688516, 2), (datetime.date(2026, 10, 16), 0.6770758317324755, 3), (datetime.date(2026, 10, 17), 0.6902326895069898, 4), (datetime.date(2026, 10, 18), 0.7883548400188759, 3))}, 'quality_array': [['-8.294893033709013', '09102026'], ['-7.261640542190818', '01102026'], ['-8.425066139654133', '02102026'], ['-8.511240271772737', '03102026'], ['-7.573021104377661', '04102026'], ['-7.475746525181489', '05102026'], ['-8.297832333103443', '06102026'], ['-8.63238787211698', '07102026'], ['-6.542604677693863', '08102026'], ['-7.983351152503088', '10102026'], ['-8.09601625031544', '11102026'], ['-7.712178220806423', '12102026'], ['-8.169099065995105', '13102026'], ['-8.37532117373984', '14102026'], ['-8.171237612934084', '15102026'], ['-8.496126375635683', '16102026'], ['-8.450900551696837', '17102026'], ['-8.06006494107045', '18102026']], 'number_of_batch': ((378,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02022763119293866, 'nb_photo': 13003, 'list_port_cont': '31243303,31243338,31243773,31243961,31244033,31244207,31245755,31245831,31245877,31245917,31245945,31245989,31246109,31246336,31246449,31246497,31246651,31246731,31246941,31247071,31247357,31247519,31247564,31248005,31248073,31248300,31248552,31248697,31249145,31249324,31249912,31250026,31250197,31250653,31250814,31251019,31251189,31251397,31251645,31251905,31252301,31252583,31252656,31252800,31253073,31253135,31253181,31253549,31253794,31253931,31254212,31254860,31255089,31255380,31255437,31255697,31256073,31256117,31256407,31256717,31256899,31257144,31257222,31257511,31257728,31257817,31258103,31258415,31258612,31258858,31259149,31259494,31259582,31259853,31260233,31260588,31260855,31261097,31261335,31261499,31261543,31262214,31262497,31262743,31262783,31263092,31263171,31263486,31263686,31264062,31264291,31264563,31264837,31265066,31265385,31265838,31265912,31266492,31266807,31267102,31267507,31267630,31267816,31268029,31268131,31268409,31268528,31268859,31268893,31269332,31269372,31269419,31269461,3127000', 'assoc_port': '31243157:31243961,31243158:31243338,31243159:31243303,31243610:31243773,31243809:31244033,31244059:31244207,31244513:31245755,31244591:31245831,31244677:31245877,31244936:31246336,31245203:31245989,31245204:31245945,31245458:31245917,31245477:31246109,31246187:31246497,31246188:31246449,31246560:31246731,31246561:31246651,31246764:31246941,31247015:31247071,31247263:31247357,31247461:31247519,31247462:31247564,31247974:31248005,31247975:31248073,31248196:31248300,31248412:31248552,31248619:31248697,31248890:31249912,31249108:31249145,31249311:31249324,31249604:31250026,31250143:31250197,31250360:31250814,31250514:31250653,31250834:31251019,31251008:31251189,31251262:31251397,31251432:31251645,31251719:31251905,31251978:31252301,31252412:31252656,31252413:31252583,31252731:31252800,31252860:31253073,31253049:31253135,31253050:31253181,31253459:31253549,31253696:31253794,31253828:31253931,31254115:31254212,31254398:31254860,31254969:31255437,31254970:31255089,31255210:31255380,31255461:31255697,31255845:3125607', 'assoc_mat': '31243157:autre:4230:31243961,31243158:autre:4230:31243338,31243159:autre:4230:31243303,31243610:autre:4230:31243773,31243809:autre:4230:31244033,31244059:autre:4230:31244207,31244513:autre:4230:31245755,31244591:autre:4230:31245831,31244677:autre:4230:31245877,31244936:autre:4230:31246336,31245203:autre:4230:31245989,31245204:autre:4230:31245945,31245458:autre:4230:31245917,31245477:autre:4230:31246109,31246187:autre:4230:31246497,31246188:autre:4230:31246449,31246560:autre:4230:31246731,31246561:autre:4230:31246651,31246764:autre:4230:31246941,31247015:autre:4230:31247071,31247263:autre:4230:31247357,31247461:autre:4230:31247519,31247462:autre:4230:31247564,31247974:autre:4230:31248005,31247975:autre:4230:31248073,31248196:autre:4230:31248300,31248412:autre:4230:31248552,31248619:autre:4230:31248697,31248890:autre:4230:31249912,31249108:autre:4230:31249145,31249311:autre:4230:31249324,31249604:autre:4230:31250026,31250143:autre:4230:31250197,31250360:autre:4230:31250814,31250514:autre:4230:31250653,31250834:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0552374047605066, 'nb_photo': 56518, 'list_port_cont': '31243306,31243333,31243787,31243954,31244027,31244209,31245764,31245839,31245883,31245921,31245954,31245982,31246120,31246348,31246462,31246492,31246668,31246738,31246948,31247080,31247366,31247522,31247573,31248012,31248089,31248307,31248553,31248695,31249151,31249336,31249899,31250030,31250200,31250657,31250806,31251030,31251199,31251413,31251644,31251916,31252318,31252592,31252667,31252792,31253074,31253142,31253187,31253541,31253804,31253924,31254221,31254869,31255100,31255394,31255439,31255704,31256077,31256106,31256408,31256722,31256906,31257154,31257221,31257520,31257726,31257820,31258099,31258420,31258611,31258860,31259160,31259510,31259578,31259867,31260234,31260579,31260858,31261109,31261347,31261508,31261547,31262225,31262507,31262745,31262780,31263094,31263186,31263496,31263698,31264065,31264298,31264565,31264834,31265070,31265389,31265848,31265918,31266486,31266803,31267117,31267503,31267631,31267822,31268037,31268130,31268415,31268529,31268853,31268904,31269345,31269375,31269423,31269453,3127000', 'assoc_port': '31243157:31243954,31243158:31243333,31243159:31243306,31243610:31243787,31243809:31244027,31244059:31244209,31244513:31245764,31244591:31245839,31244677:31245883,31244936:31246348,31245203:31245982,31245204:31245954,31245458:31245921,31245477:31246120,31246187:31246492,31246188:31246462,31246560:31246738,31246561:31246668,31246764:31246948,31247015:31247080,31247263:31247366,31247461:31247522,31247462:31247573,31247974:31248012,31247975:31248089,31248196:31248307,31248412:31248553,31248619:31248695,31248890:31249899,31249108:31249151,31249311:31249336,31249604:31250030,31250143:31250200,31250360:31250806,31250514:31250657,31250834:31251030,31251008:31251199,31251262:31251413,31251432:31251644,31251719:31251916,31251978:31252318,31252412:31252667,31252413:31252592,31252731:31252792,31252860:31253074,31253049:31253142,31253050:31253187,31253459:31253541,31253696:31253804,31253828:31253924,31254115:31254221,31254398:31254869,31254969:31255439,31254970:31255100,31255210:31255394,31255461:31255704,31255845:3125607', 'assoc_mat': '31243157:carton:4230:31243954,31243158:carton:4230:31243333,31243159:carton:4230:31243306,31243610:carton:4230:31243787,31243809:carton:4230:31244027,31244059:carton:4230:31244209,31244513:carton:4230:31245764,31244591:carton:4230:31245839,31244677:carton:4230:31245883,31244936:carton:4230:31246348,31245203:carton:4230:31245982,31245204:carton:4230:31245954,31245458:carton:4230:31245921,31245477:carton:4230:31246120,31246187:carton:4230:31246492,31246188:carton:4230:31246462,31246560:carton:4230:31246738,31246561:carton:4230:31246668,31246764:carton:4230:31246948,31247015:carton:4230:31247080,31247263:carton:4230:31247366,31247461:carton:4230:31247522,31247462:carton:4230:31247573,31247974:carton:4230:31248012,31247975:carton:4230:31248089,31248196:carton:4230:31248307,31248412:carton:4230:31248553,31248619:carton:4230:31248695,31248890:carton:4230:31249899,31249108:carton:4230:31249151,31249311:carton:4230:31249336,31249604:carton:4230:31250030,31250143:carton:4230:31250200,31250360:carton:4230:31250806,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0015990367919615995, 'nb_photo': 1297, 'list_port_cont': '31243302,31244036,31245754,31245834,31245869,31245911,31245956,31245994,31246105,31246345,31246447,31246481,31246659,31246732,31246953,31247372,31247534,31247567,31248006,31248078,31248295,31248556,31248700,31249157,31249323,31249905,31250019,31250201,31250650,31250813,31251032,31251190,31251403,31251652,31251917,31252306,31252671,31253060,31253788,31253923,31254214,31254857,31255097,31255386,31255431,31255702,31256078,31256111,31256395,31256710,31256889,31257138,31257213,31257518,31257723,31258098,31258407,31258620,31259153,31259498,31259580,31259852,31260226,31260581,31260850,31261108,31261498,31262218,31262506,31262747,31263091,31263495,31263690,31264058,31264294,31264557,31264842,31265388,31265846,31265913,31266484,31266793,31267118,31267510,31267623,31267814,31268028,31268127,31268403,31268521,31268864,31268894,31269335,31269381,31269410,31269465,31270001,31270102,31270461,31270799,31270846,31271229,31271390,31271947,31272021,31272059,31272586,31272702,31273160,31273198,31273611,31273668,31274142,3127428', 'assoc_port': '31243159:31243302,31243809:31244036,31244513:31245754,31244591:31245834,31244677:31245869,31244936:31246345,31245203:31245994,31245204:31245956,31245458:31245911,31245477:31246105,31246187:31246481,31246188:31246447,31246560:31246732,31246561:31246659,31246764:31246953,31247263:31247372,31247461:31247534,31247462:31247567,31247974:31248006,31247975:31248078,31248196:31248295,31248412:31248556,31248619:31248700,31248890:31249905,31249108:31249157,31249311:31249323,31249604:31250019,31250143:31250201,31250360:31250813,31250514:31250650,31250834:31251032,31251008:31251190,31251262:31251403,31251432:31251652,31251719:31251917,31251978:31252306,31252412:31252671,31252860:31253060,31253696:31253788,31253828:31253923,31254115:31254214,31254398:31254857,31254969:31255431,31254970:31255097,31255210:31255386,31255461:31255702,31255845:31256078,31255846:31256111,31256178:31256395,31256434:31256710,31256760:31256889,31256932:31257138,31256933:31257213,31257299:31257518,31257588:31257723,31258037:31258098,31258249:3125840', 'assoc_mat': '31243159:metal:4230:31243302,31243809:metal:4230:31244036,31244513:metal:4230:31245754,31244591:metal:4230:31245834,31244677:metal:4230:31245869,31244936:metal:4230:31246345,31245203:metal:4230:31245994,31245204:metal:4230:31245956,31245458:metal:4230:31245911,31245477:metal:4230:31246105,31246187:metal:4230:31246481,31246188:metal:4230:31246447,31246560:metal:4230:31246732,31246561:metal:4230:31246659,31246764:metal:4230:31246953,31247263:metal:4230:31247372,31247461:metal:4230:31247534,31247462:metal:4230:31247567,31247974:metal:4230:31248006,31247975:metal:4230:31248078,31248196:metal:4230:31248295,31248412:metal:4230:31248556,31248619:metal:4230:31248700,31248890:metal:4230:31249905,31249108:metal:4230:31249157,31249311:metal:4230:31249323,31249604:metal:4230:31250019,31250143:metal:4230:31250201,31250360:metal:4230:31250813,31250514:metal:4230:31250650,31250834:metal:4230:31251032,31251008:metal:4230:31251190,31251262:metal:4230:31251403,31251432:metal:4230:31251652,31251719:metal:4230:31251917,31251978:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.21249494551270032, 'nb_photo': 262954, 'list_port_cont': '31243308,31243337,31243781,31243949,31244037,31244210,31245767,31245844,31245874,31245918,31245957,31245992,31246117,31246343,31246459,31246490,31246666,31246734,31246950,31247068,31247373,31247531,31247572,31247999,31248083,31248309,31248550,31248698,31249156,31249328,31249910,31250031,31250212,31250661,31250810,31251028,31251201,31251405,31251650,31251914,31252307,31252591,31252672,31252802,31253063,31253139,31253185,31253546,31253805,31253926,31254226,31254868,31255099,31255385,31255441,31255696,31256072,31256113,31256401,31256720,31256903,31257152,31257224,31257522,31257729,31257825,31258092,31258424,31258616,31258849,31259163,31259506,31259581,31259863,31260225,31260583,31260859,31261105,31261343,31261506,31261553,31262223,31262509,31262748,31262777,31263096,31263184,31263490,31263695,31264066,31264296,31264558,31264844,31265067,31265390,31265845,31265909,31266498,31266800,31267113,31267506,31267639,31267823,31268041,31268132,31268407,31268525,31268860,31268895,31269346,31269377,31269424,31269463,3127000', 'assoc_port': '31243157:31243949,31243158:31243337,31243159:31243308,31243610:31243781,31243809:31244037,31244059:31244210,31244513:31245767,31244591:31245844,31244677:31245874,31244936:31246343,31245203:31245992,31245204:31245957,31245458:31245918,31245477:31246117,31246187:31246490,31246188:31246459,31246560:31246734,31246561:31246666,31246764:31246950,31247015:31247068,31247263:31247373,31247461:31247531,31247462:31247572,31247974:31247999,31247975:31248083,31248196:31248309,31248412:31248550,31248619:31248698,31248890:31249910,31249108:31249156,31249311:31249328,31249604:31250031,31250143:31250212,31250360:31250810,31250514:31250661,31250834:31251028,31251008:31251201,31251262:31251405,31251432:31251650,31251719:31251914,31251978:31252307,31252412:31252672,31252413:31252591,31252731:31252802,31252860:31253063,31253049:31253139,31253050:31253185,31253459:31253546,31253696:31253805,31253828:31253926,31254115:31254226,31254398:31254868,31254969:31255441,31254970:31255099,31255210:31255385,31255461:31255696,31255845:3125607', 'assoc_mat': '31243157:papier:4230:31243949,31243158:papier:4230:31243337,31243159:papier:4230:31243308,31243610:papier:4230:31243781,31243809:papier:4230:31244037,31244059:papier:4230:31244210,31244513:papier:4230:31245767,31244591:papier:4230:31245844,31244677:papier:4230:31245874,31244936:papier:4230:31246343,31245203:papier:4230:31245992,31245204:papier:4230:31245957,31245458:papier:4230:31245918,31245477:papier:4230:31246117,31246187:papier:4230:31246490,31246188:papier:4230:31246459,31246560:papier:4230:31246734,31246561:papier:4230:31246666,31246764:papier:4230:31246950,31247015:papier:4230:31247068,31247263:papier:4230:31247373,31247461:papier:4230:31247531,31247462:papier:4230:31247572,31247974:papier:4230:31247999,31247975:papier:4230:31248083,31248196:papier:4230:31248309,31248412:papier:4230:31248550,31248619:papier:4230:31248698,31248890:papier:4230:31249910,31249108:papier:4230:31249156,31249311:papier:4230:31249328,31249604:papier:4230:31250031,31250143:papier:4230:31250212,31250360:papier:4230:31250810,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005504713218147078, 'nb_photo': 1852, 'list_port_cont': '31243297,31243344,31243784,31243955,31244025,31245769,31245845,31245872,31245912,31245993,31246118,31246340,31246494,31246727,31247368,31247523,31247570,31248004,31248087,31248298,31248554,31249149,31249335,31250028,31250214,31250648,31250811,31251029,31251200,31251406,31251658,31251913,31252317,31252590,31252666,31252797,31253072,31253141,31253177,31253542,31253801,31253934,31254223,31254865,31255085,31255392,31255440,31255705,31256071,31256120,31256404,31256721,31256905,31257148,31257223,31257513,31257826,31258418,31258610,31259150,31259499,31259576,31259866,31260231,31260582,31260856,31261102,31261349,31261502,31261542,31262500,31263095,31265847,31265916,31266495,31266801,31267109,31267511,31267638,31267811,31268043,31268125,31268420,31268531,31268863,31268903,31269384,31269425,31269462,31270011,31270103,31270285,31270466,31270804,31270845,31271243,31271395,31271966,31272031,31272056,31272585,31272712,31273150,31273202,31273626,31273670,31274152,31274187,31274269,31275075,31275483,31275938,31276183,3127654', 'assoc_port': '31243157:31243955,31243158:31243344,31243159:31243297,31243610:31243784,31243809:31244025,31244513:31245769,31244591:31245845,31244677:31245872,31244936:31246340,31245203:31245993,31245458:31245912,31245477:31246118,31246187:31246494,31246560:31246727,31247263:31247368,31247461:31247523,31247462:31247570,31247974:31248004,31247975:31248087,31248196:31248298,31248412:31248554,31249108:31249149,31249311:31249335,31249604:31250028,31250143:31250214,31250360:31250811,31250514:31250648,31250834:31251029,31251008:31251200,31251262:31251406,31251432:31251658,31251719:31251913,31251978:31252317,31252412:31252666,31252413:31252590,31252731:31252797,31252860:31253072,31253049:31253141,31253050:31253177,31253459:31253542,31253696:31253801,31253828:31253934,31254115:31254223,31254398:31254865,31254969:31255440,31254970:31255085,31255210:31255392,31255461:31255705,31255845:31256071,31255846:31256120,31256178:31256404,31256434:31256721,31256760:31256905,31256932:31257148,31256933:31257223,31257299:31257513,31257759:3125782', 'assoc_mat': '31243157:pehd:4230:31243955,31243158:pehd:4230:31243344,31243159:pehd:4230:31243297,31243610:pehd:4230:31243784,31243809:pehd:4230:31244025,31244513:pehd:4230:31245769,31244591:pehd:4230:31245845,31244677:pehd:4230:31245872,31244936:pehd:4230:31246340,31245203:pehd:4230:31245993,31245458:pehd:4230:31245912,31245477:pehd:4230:31246118,31246187:pehd:4230:31246494,31246560:pehd:4230:31246727,31247263:pehd:4230:31247368,31247461:pehd:4230:31247523,31247462:pehd:4230:31247570,31247974:pehd:4230:31248004,31247975:pehd:4230:31248087,31248196:pehd:4230:31248298,31248412:pehd:4230:31248554,31249108:pehd:4230:31249149,31249311:pehd:4230:31249335,31249604:pehd:4230:31250028,31250143:pehd:4230:31250214,31250360:pehd:4230:31250811,31250514:pehd:4230:31250648,31250834:pehd:4230:31251029,31251008:pehd:4230:31251200,31251262:pehd:4230:31251406,31251432:pehd:4230:31251658,31251719:pehd:4230:31251913,31251978:pehd:4230:31252317,31252412:pehd:4230:31252666,31252413:pehd:4230:31252590,31252731:pehd:4230:31252797,31252860:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015142502244208466, 'nb_photo': 15275, 'list_port_cont': '31243301,31243335,31243785,31243960,31244029,31244222,31245762,31245846,31245878,31245919,31245952,31245981,31246112,31246353,31246458,31246498,31246663,31246739,31246956,31247076,31247367,31247528,31247566,31248014,31248085,31248302,31248551,31248692,31249148,31249326,31249904,31250027,31250211,31250659,31250812,31251018,31251193,31251404,31251654,31251918,31252315,31252587,31252670,31252798,31253067,31253151,31253186,31253544,31253800,31253928,31254224,31254870,31255091,31255391,31255430,31255698,31256068,31256116,31256410,31256709,31256893,31257151,31257217,31257512,31257730,31257822,31258096,31258417,31258619,31258864,31259154,31259507,31259583,31259858,31260237,31260587,31260861,31261106,31261339,31261512,31261550,31262221,31262501,31262746,31262781,31263090,31263178,31263499,31263685,31264063,31264297,31264566,31264838,31265061,31265379,31265841,31265921,31266494,31266802,31267107,31267512,31267640,31267817,31268039,31268119,31268414,31268533,31268856,31268902,31269348,31269385,31269415,31269458,3127001', 'assoc_port': '31243157:31243960,31243158:31243335,31243159:31243301,31243610:31243785,31243809:31244029,31244059:31244222,31244513:31245762,31244591:31245846,31244677:31245878,31244936:31246353,31245203:31245981,31245204:31245952,31245458:31245919,31245477:31246112,31246187:31246498,31246188:31246458,31246560:31246739,31246561:31246663,31246764:31246956,31247015:31247076,31247263:31247367,31247461:31247528,31247462:31247566,31247974:31248014,31247975:31248085,31248196:31248302,31248412:31248551,31248619:31248692,31248890:31249904,31249108:31249148,31249311:31249326,31249604:31250027,31250143:31250211,31250360:31250812,31250514:31250659,31250834:31251018,31251008:31251193,31251262:31251404,31251432:31251654,31251719:31251918,31251978:31252315,31252412:31252670,31252413:31252587,31252731:31252798,31252860:31253067,31253049:31253151,31253050:31253186,31253459:31253544,31253696:31253800,31253828:31253928,31254115:31254224,31254398:31254870,31254969:31255430,31254970:31255091,31255210:31255391,31255461:31255698,31255845:3125606', 'assoc_mat': '31243157:pet_clair:4230:31243960,31243158:pet_clair:4230:31243335,31243159:pet_clair:4230:31243301,31243610:pet_clair:4230:31243785,31243809:pet_clair:4230:31244029,31244059:pet_clair:4230:31244222,31244513:pet_clair:4230:31245762,31244591:pet_clair:4230:31245846,31244677:pet_clair:4230:31245878,31244936:pet_clair:4230:31246353,31245203:pet_clair:4230:31245981,31245204:pet_clair:4230:31245952,31245458:pet_clair:4230:31245919,31245477:pet_clair:4230:31246112,31246187:pet_clair:4230:31246498,31246188:pet_clair:4230:31246458,31246560:pet_clair:4230:31246739,31246561:pet_clair:4230:31246663,31246764:pet_clair:4230:31246956,31247015:pet_clair:4230:31247076,31247263:pet_clair:4230:31247367,31247461:pet_clair:4230:31247528,31247462:pet_clair:4230:31247566,31247974:pet_clair:4230:31248014,31247975:pet_clair:4230:31248085,31248196:pet_clair:4230:31248302,31248412:pet_clair:4230:31248551,31248619:pet_clair:4230:31248692,31248890:pet_clair:4230:31249904,31249108:pet_clair:4230:31249148,31249311:pet_clair:4230:31249326,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003107514034321112, 'nb_photo': 766, 'list_port_cont': '31243342,31243789,31243952,31244035,31245840,31245873,31245916,31245995,31246114,31246349,31246491,31246667,31247370,31247569,31248090,31248299,31248542,31249142,31250035,31250660,31250803,31251025,31251198,31251408,31251653,31251911,31252309,31252597,31252662,31253071,31253147,31253179,31253547,31253802,31253929,31254217,31255094,31255393,31255433,31255701,31256067,31256110,31256403,31256715,31256894,31257153,31257227,31257515,31257727,31258421,31258615,31259162,31259509,31260576,31261107,31261348,31261514,31261549,31262510,31263084,31263183,31263492,31264287,31264843,31265387,31265839,31265914,31266497,31267119,31267514,31267634,31267815,31268040,31268134,31268418,31268851,31268899,31269343,31269378,31269426,31269456,31269999,31270107,31270279,31270465,31270798,31270847,31271960,31272026,31272599,31272706,31273163,31273197,31273623,31273674,31274154,31274186,31274261,31274753,31274789,31274927,31275448,31275486,31275626,31275936,31276186,31276544,31276731,31277004,31277107,31277261,31277718,31278302,3127850', 'assoc_port': '31243157:31243952,31243158:31243342,31243610:31243789,31243809:31244035,31244591:31245840,31244677:31245873,31244936:31246349,31245203:31245995,31245458:31245916,31245477:31246114,31246187:31246491,31246561:31246667,31247263:31247370,31247462:31247569,31247975:31248090,31248196:31248299,31248412:31248542,31249108:31249142,31249604:31250035,31250360:31250803,31250514:31250660,31250834:31251025,31251008:31251198,31251262:31251408,31251432:31251653,31251719:31251911,31251978:31252309,31252412:31252662,31252413:31252597,31252860:31253071,31253049:31253147,31253050:31253179,31253459:31253547,31253696:31253802,31253828:31253929,31254115:31254217,31254969:31255433,31254970:31255094,31255210:31255393,31255461:31255701,31255845:31256067,31255846:31256110,31256178:31256403,31256434:31256715,31256760:31256894,31256932:31257153,31256933:31257227,31257299:31257515,31257588:31257727,31258249:31258421,31258484:31258615,31258933:31259162,31259326:31259509,31260334:31260576,31260957:31261107,31261165:31261348,31261370:3126154', 'assoc_mat': '31243157:pet_fonce:4230:31243952,31243158:pet_fonce:4230:31243342,31243610:pet_fonce:4230:31243789,31243809:pet_fonce:4230:31244035,31244591:pet_fonce:4230:31245840,31244677:pet_fonce:4230:31245873,31244936:pet_fonce:4230:31246349,31245203:pet_fonce:4230:31245995,31245458:pet_fonce:4230:31245916,31245477:pet_fonce:4230:31246114,31246187:pet_fonce:4230:31246491,31246561:pet_fonce:4230:31246667,31247263:pet_fonce:4230:31247370,31247462:pet_fonce:4230:31247569,31247975:pet_fonce:4230:31248090,31248196:pet_fonce:4230:31248299,31248412:pet_fonce:4230:31248542,31249108:pet_fonce:4230:31249142,31249604:pet_fonce:4230:31250035,31250360:pet_fonce:4230:31250803,31250514:pet_fonce:4230:31250660,31250834:pet_fonce:4230:31251025,31251008:pet_fonce:4230:31251198,31251262:pet_fonce:4230:31251408,31251432:pet_fonce:4230:31251653,31251719:pet_fonce:4230:31251911,31251978:pet_fonce:4230:31252309,31252412:pet_fonce:4230:31252662,31252413:pet_fonce:4230:31252597,31252860:pet_fonce:4230:31253071,31253049:pet_fonce:4230:31253147,3'}), 'main_stat': {'nb_photos': 1032}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31341139,31341140,31341141,31341142,31341143,31341144,31341145?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-10', 0.7182737270227025),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1032,),), 'unwanted_material_monthly_percentage': ((0.7176473337266674,),), 'material_repartition': (('incineration', 1029),), 'material_dict': {'incineration': 1029}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 10, 1), 0.7122028745827107, 2), (datetime.date(2026, 10, 2), 0.6640461583182016, 1), (datetime.date(2026, 10, 3), 0.715571917220856, 1), (datetime.date(2026, 10, 4), 0.7923783958101845, 1), (datetime.date(2026, 10, 5), 0.7432557721524449, 4), (datetime.date(2026, 10, 6), 0.6893164222958932, 3), (datetime.date(2026, 10, 7), 0.658536279600553, 1), (datetime.date(2026, 10, 8), 0.730565811453993, 2), (datetime.date(2026, 10, 9), 0.7407657467761343, 2), (datetime.date(2026, 10, 10), 0.6924191863174799, 4), (datetime.date(2026, 10, 11), 0.7996083673460196, 3), (datetime.date(2026, 10, 12), 0.7689306631415268, 2), (datetime.date(2026, 10, 13), 0.7106422891660283, 3), (datetime.date(2026, 10, 14), 0.6808230003611088, 2), (datetime.date(2026, 10, 15), 0.6968102768688516, 2), (datetime.date(2026, 10, 16), 0.6770758317324755, 3), (datetime.date(2026, 10, 17), 0.6902326895069898, 4), (datetime.date(2026, 10, 18), 0.7883548400188759, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 10, 1), 0.7122028745827107, 2), (datetime.date(2026, 10, 2), 0.6640461583182016, 1), (datetime.date(2026, 10, 3), 0.715571917220856, 1), (datetime.date(2026, 10, 4), 0.7923783958101845, 1), (datetime.date(2026, 10, 5), 0.7432557721524449, 4), (datetime.date(2026, 10, 6), 0.6893164222958932, 3), (datetime.date(2026, 10, 7), 0.658536279600553, 1), (datetime.date(2026, 10, 8), 0.730565811453993, 2), (datetime.date(2026, 10, 9), 0.7407657467761343, 2), (datetime.date(2026, 10, 10), 0.6924191863174799, 4), (datetime.date(2026, 10, 11), 0.7996083673460196, 3), (datetime.date(2026, 10, 12), 0.7689306631415268, 2), (datetime.date(2026, 10, 13), 0.7106422891660283, 3), (datetime.date(2026, 10, 14), 0.6808230003611088, 2), (datetime.date(2026, 10, 15), 0.6968102768688516, 2), (datetime.date(2026, 10, 16), 0.6770758317324755, 3), (datetime.date(2026, 10, 17), 0.6902326895069898, 4), (datetime.date(2026, 10, 18), 0.7883548400188759, 3))}, 'quality_array': [['-8.294893033709013', '09102026'], ['-7.261640542190818', '01102026'], ['-8.425066139654133', '02102026'], ['-8.511240271772737', '03102026'], ['-7.573021104377661', '04102026'], ['-7.475746525181489', '05102026'], ['-8.297832333103443', '06102026'], ['-8.63238787211698', '07102026'], ['-6.542604677693863', '08102026'], ['-7.983351152503088', '10102026'], ['-8.09601625031544', '11102026'], ['-7.712178220806423', '12102026'], ['-8.169099065995105', '13102026'], ['-8.37532117373984', '14102026'], ['-8.171237612934084', '15102026'], ['-8.496126375635683', '16102026'], ['-8.450900551696837', '17102026'], ['-8.06006494107045', '18102026']], 'number_of_batch': ((378,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02022763119293866, 'nb_photo': 13003, 'list_port_cont': '31243303,31243338,31243773,31243961,31244033,31244207,31245755,31245831,31245877,31245917,31245945,31245989,31246109,31246336,31246449,31246497,31246651,31246731,31246941,31247071,31247357,31247519,31247564,31248005,31248073,31248300,31248552,31248697,31249145,31249324,31249912,31250026,31250197,31250653,31250814,31251019,31251189,31251397,31251645,31251905,31252301,31252583,31252656,31252800,31253073,31253135,31253181,31253549,31253794,31253931,31254212,31254860,31255089,31255380,31255437,31255697,31256073,31256117,31256407,31256717,31256899,31257144,31257222,31257511,31257728,31257817,31258103,31258415,31258612,31258858,31259149,31259494,31259582,31259853,31260233,31260588,31260855,31261097,31261335,31261499,31261543,31262214,31262497,31262743,31262783,31263092,31263171,31263486,31263686,31264062,31264291,31264563,31264837,31265066,31265385,31265838,31265912,31266492,31266807,31267102,31267507,31267630,31267816,31268029,31268131,31268409,31268528,31268859,31268893,31269332,31269372,31269419,31269461,3127000', 'assoc_port': '31243157:31243961,31243158:31243338,31243159:31243303,31243610:31243773,31243809:31244033,31244059:31244207,31244513:31245755,31244591:31245831,31244677:31245877,31244936:31246336,31245203:31245989,31245204:31245945,31245458:31245917,31245477:31246109,31246187:31246497,31246188:31246449,31246560:31246731,31246561:31246651,31246764:31246941,31247015:31247071,31247263:31247357,31247461:31247519,31247462:31247564,31247974:31248005,31247975:31248073,31248196:31248300,31248412:31248552,31248619:31248697,31248890:31249912,31249108:31249145,31249311:31249324,31249604:31250026,31250143:31250197,31250360:31250814,31250514:31250653,31250834:31251019,31251008:31251189,31251262:31251397,31251432:31251645,31251719:31251905,31251978:31252301,31252412:31252656,31252413:31252583,31252731:31252800,31252860:31253073,31253049:31253135,31253050:31253181,31253459:31253549,31253696:31253794,31253828:31253931,31254115:31254212,31254398:31254860,31254969:31255437,31254970:31255089,31255210:31255380,31255461:31255697,31255845:3125607', 'assoc_mat': '31243157:autre:4230:31243961,31243158:autre:4230:31243338,31243159:autre:4230:31243303,31243610:autre:4230:31243773,31243809:autre:4230:31244033,31244059:autre:4230:31244207,31244513:autre:4230:31245755,31244591:autre:4230:31245831,31244677:autre:4230:31245877,31244936:autre:4230:31246336,31245203:autre:4230:31245989,31245204:autre:4230:31245945,31245458:autre:4230:31245917,31245477:autre:4230:31246109,31246187:autre:4230:31246497,31246188:autre:4230:31246449,31246560:autre:4230:31246731,31246561:autre:4230:31246651,31246764:autre:4230:31246941,31247015:autre:4230:31247071,31247263:autre:4230:31247357,31247461:autre:4230:31247519,31247462:autre:4230:31247564,31247974:autre:4230:31248005,31247975:autre:4230:31248073,31248196:autre:4230:31248300,31248412:autre:4230:31248552,31248619:autre:4230:31248697,31248890:autre:4230:31249912,31249108:autre:4230:31249145,31249311:autre:4230:31249324,31249604:autre:4230:31250026,31250143:autre:4230:31250197,31250360:autre:4230:31250814,31250514:autre:4230:31250653,31250834:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0552374047605066, 'nb_photo': 56518, 'list_port_cont': '31243306,31243333,31243787,31243954,31244027,31244209,31245764,31245839,31245883,31245921,31245954,31245982,31246120,31246348,31246462,31246492,31246668,31246738,31246948,31247080,31247366,31247522,31247573,31248012,31248089,31248307,31248553,31248695,31249151,31249336,31249899,31250030,31250200,31250657,31250806,31251030,31251199,31251413,31251644,31251916,31252318,31252592,31252667,31252792,31253074,31253142,31253187,31253541,31253804,31253924,31254221,31254869,31255100,31255394,31255439,31255704,31256077,31256106,31256408,31256722,31256906,31257154,31257221,31257520,31257726,31257820,31258099,31258420,31258611,31258860,31259160,31259510,31259578,31259867,31260234,31260579,31260858,31261109,31261347,31261508,31261547,31262225,31262507,31262745,31262780,31263094,31263186,31263496,31263698,31264065,31264298,31264565,31264834,31265070,31265389,31265848,31265918,31266486,31266803,31267117,31267503,31267631,31267822,31268037,31268130,31268415,31268529,31268853,31268904,31269345,31269375,31269423,31269453,3127000', 'assoc_port': '31243157:31243954,31243158:31243333,31243159:31243306,31243610:31243787,31243809:31244027,31244059:31244209,31244513:31245764,31244591:31245839,31244677:31245883,31244936:31246348,31245203:31245982,31245204:31245954,31245458:31245921,31245477:31246120,31246187:31246492,31246188:31246462,31246560:31246738,31246561:31246668,31246764:31246948,31247015:31247080,31247263:31247366,31247461:31247522,31247462:31247573,31247974:31248012,31247975:31248089,31248196:31248307,31248412:31248553,31248619:31248695,31248890:31249899,31249108:31249151,31249311:31249336,31249604:31250030,31250143:31250200,31250360:31250806,31250514:31250657,31250834:31251030,31251008:31251199,31251262:31251413,31251432:31251644,31251719:31251916,31251978:31252318,31252412:31252667,31252413:31252592,31252731:31252792,31252860:31253074,31253049:31253142,31253050:31253187,31253459:31253541,31253696:31253804,31253828:31253924,31254115:31254221,31254398:31254869,31254969:31255439,31254970:31255100,31255210:31255394,31255461:31255704,31255845:3125607', 'assoc_mat': '31243157:carton:4230:31243954,31243158:carton:4230:31243333,31243159:carton:4230:31243306,31243610:carton:4230:31243787,31243809:carton:4230:31244027,31244059:carton:4230:31244209,31244513:carton:4230:31245764,31244591:carton:4230:31245839,31244677:carton:4230:31245883,31244936:carton:4230:31246348,31245203:carton:4230:31245982,31245204:carton:4230:31245954,31245458:carton:4230:31245921,31245477:carton:4230:31246120,31246187:carton:4230:31246492,31246188:carton:4230:31246462,31246560:carton:4230:31246738,31246561:carton:4230:31246668,31246764:carton:4230:31246948,31247015:carton:4230:31247080,31247263:carton:4230:31247366,31247461:carton:4230:31247522,31247462:carton:4230:31247573,31247974:carton:4230:31248012,31247975:carton:4230:31248089,31248196:carton:4230:31248307,31248412:carton:4230:31248553,31248619:carton:4230:31248695,31248890:carton:4230:31249899,31249108:carton:4230:31249151,31249311:carton:4230:31249336,31249604:carton:4230:31250030,31250143:carton:4230:31250200,31250360:carton:4230:31250806,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0015990367919615995, 'nb_photo': 1297, 'list_port_cont': '31243302,31244036,31245754,31245834,31245869,31245911,31245956,31245994,31246105,31246345,31246447,31246481,31246659,31246732,31246953,31247372,31247534,31247567,31248006,31248078,31248295,31248556,31248700,31249157,31249323,31249905,31250019,31250201,31250650,31250813,31251032,31251190,31251403,31251652,31251917,31252306,31252671,31253060,31253788,31253923,31254214,31254857,31255097,31255386,31255431,31255702,31256078,31256111,31256395,31256710,31256889,31257138,31257213,31257518,31257723,31258098,31258407,31258620,31259153,31259498,31259580,31259852,31260226,31260581,31260850,31261108,31261498,31262218,31262506,31262747,31263091,31263495,31263690,31264058,31264294,31264557,31264842,31265388,31265846,31265913,31266484,31266793,31267118,31267510,31267623,31267814,31268028,31268127,31268403,31268521,31268864,31268894,31269335,31269381,31269410,31269465,31270001,31270102,31270461,31270799,31270846,31271229,31271390,31271947,31272021,31272059,31272586,31272702,31273160,31273198,31273611,31273668,31274142,3127428', 'assoc_port': '31243159:31243302,31243809:31244036,31244513:31245754,31244591:31245834,31244677:31245869,31244936:31246345,31245203:31245994,31245204:31245956,31245458:31245911,31245477:31246105,31246187:31246481,31246188:31246447,31246560:31246732,31246561:31246659,31246764:31246953,31247263:31247372,31247461:31247534,31247462:31247567,31247974:31248006,31247975:31248078,31248196:31248295,31248412:31248556,31248619:31248700,31248890:31249905,31249108:31249157,31249311:31249323,31249604:31250019,31250143:31250201,31250360:31250813,31250514:31250650,31250834:31251032,31251008:31251190,31251262:31251403,31251432:31251652,31251719:31251917,31251978:31252306,31252412:31252671,31252860:31253060,31253696:31253788,31253828:31253923,31254115:31254214,31254398:31254857,31254969:31255431,31254970:31255097,31255210:31255386,31255461:31255702,31255845:31256078,31255846:31256111,31256178:31256395,31256434:31256710,31256760:31256889,31256932:31257138,31256933:31257213,31257299:31257518,31257588:31257723,31258037:31258098,31258249:3125840', 'assoc_mat': '31243159:metal:4230:31243302,31243809:metal:4230:31244036,31244513:metal:4230:31245754,31244591:metal:4230:31245834,31244677:metal:4230:31245869,31244936:metal:4230:31246345,31245203:metal:4230:31245994,31245204:metal:4230:31245956,31245458:metal:4230:31245911,31245477:metal:4230:31246105,31246187:metal:4230:31246481,31246188:metal:4230:31246447,31246560:metal:4230:31246732,31246561:metal:4230:31246659,31246764:metal:4230:31246953,31247263:metal:4230:31247372,31247461:metal:4230:31247534,31247462:metal:4230:31247567,31247974:metal:4230:31248006,31247975:metal:4230:31248078,31248196:metal:4230:31248295,31248412:metal:4230:31248556,31248619:metal:4230:31248700,31248890:metal:4230:31249905,31249108:metal:4230:31249157,31249311:metal:4230:31249323,31249604:metal:4230:31250019,31250143:metal:4230:31250201,31250360:metal:4230:31250813,31250514:metal:4230:31250650,31250834:metal:4230:31251032,31251008:metal:4230:31251190,31251262:metal:4230:31251403,31251432:metal:4230:31251652,31251719:metal:4230:31251917,31251978:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.21249494551270032, 'nb_photo': 262954, 'list_port_cont': '31243308,31243337,31243781,31243949,31244037,31244210,31245767,31245844,31245874,31245918,31245957,31245992,31246117,31246343,31246459,31246490,31246666,31246734,31246950,31247068,31247373,31247531,31247572,31247999,31248083,31248309,31248550,31248698,31249156,31249328,31249910,31250031,31250212,31250661,31250810,31251028,31251201,31251405,31251650,31251914,31252307,31252591,31252672,31252802,31253063,31253139,31253185,31253546,31253805,31253926,31254226,31254868,31255099,31255385,31255441,31255696,31256072,31256113,31256401,31256720,31256903,31257152,31257224,31257522,31257729,31257825,31258092,31258424,31258616,31258849,31259163,31259506,31259581,31259863,31260225,31260583,31260859,31261105,31261343,31261506,31261553,31262223,31262509,31262748,31262777,31263096,31263184,31263490,31263695,31264066,31264296,31264558,31264844,31265067,31265390,31265845,31265909,31266498,31266800,31267113,31267506,31267639,31267823,31268041,31268132,31268407,31268525,31268860,31268895,31269346,31269377,31269424,31269463,3127000', 'assoc_port': '31243157:31243949,31243158:31243337,31243159:31243308,31243610:31243781,31243809:31244037,31244059:31244210,31244513:31245767,31244591:31245844,31244677:31245874,31244936:31246343,31245203:31245992,31245204:31245957,31245458:31245918,31245477:31246117,31246187:31246490,31246188:31246459,31246560:31246734,31246561:31246666,31246764:31246950,31247015:31247068,31247263:31247373,31247461:31247531,31247462:31247572,31247974:31247999,31247975:31248083,31248196:31248309,31248412:31248550,31248619:31248698,31248890:31249910,31249108:31249156,31249311:31249328,31249604:31250031,31250143:31250212,31250360:31250810,31250514:31250661,31250834:31251028,31251008:31251201,31251262:31251405,31251432:31251650,31251719:31251914,31251978:31252307,31252412:31252672,31252413:31252591,31252731:31252802,31252860:31253063,31253049:31253139,31253050:31253185,31253459:31253546,31253696:31253805,31253828:31253926,31254115:31254226,31254398:31254868,31254969:31255441,31254970:31255099,31255210:31255385,31255461:31255696,31255845:3125607', 'assoc_mat': '31243157:papier:4230:31243949,31243158:papier:4230:31243337,31243159:papier:4230:31243308,31243610:papier:4230:31243781,31243809:papier:4230:31244037,31244059:papier:4230:31244210,31244513:papier:4230:31245767,31244591:papier:4230:31245844,31244677:papier:4230:31245874,31244936:papier:4230:31246343,31245203:papier:4230:31245992,31245204:papier:4230:31245957,31245458:papier:4230:31245918,31245477:papier:4230:31246117,31246187:papier:4230:31246490,31246188:papier:4230:31246459,31246560:papier:4230:31246734,31246561:papier:4230:31246666,31246764:papier:4230:31246950,31247015:papier:4230:31247068,31247263:papier:4230:31247373,31247461:papier:4230:31247531,31247462:papier:4230:31247572,31247974:papier:4230:31247999,31247975:papier:4230:31248083,31248196:papier:4230:31248309,31248412:papier:4230:31248550,31248619:papier:4230:31248698,31248890:papier:4230:31249910,31249108:papier:4230:31249156,31249311:papier:4230:31249328,31249604:papier:4230:31250031,31250143:papier:4230:31250212,31250360:papier:4230:31250810,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005504713218147078, 'nb_photo': 1852, 'list_port_cont': '31243297,31243344,31243784,31243955,31244025,31245769,31245845,31245872,31245912,31245993,31246118,31246340,31246494,31246727,31247368,31247523,31247570,31248004,31248087,31248298,31248554,31249149,31249335,31250028,31250214,31250648,31250811,31251029,31251200,31251406,31251658,31251913,31252317,31252590,31252666,31252797,31253072,31253141,31253177,31253542,31253801,31253934,31254223,31254865,31255085,31255392,31255440,31255705,31256071,31256120,31256404,31256721,31256905,31257148,31257223,31257513,31257826,31258418,31258610,31259150,31259499,31259576,31259866,31260231,31260582,31260856,31261102,31261349,31261502,31261542,31262500,31263095,31265847,31265916,31266495,31266801,31267109,31267511,31267638,31267811,31268043,31268125,31268420,31268531,31268863,31268903,31269384,31269425,31269462,31270011,31270103,31270285,31270466,31270804,31270845,31271243,31271395,31271966,31272031,31272056,31272585,31272712,31273150,31273202,31273626,31273670,31274152,31274187,31274269,31275075,31275483,31275938,31276183,3127654', 'assoc_port': '31243157:31243955,31243158:31243344,31243159:31243297,31243610:31243784,31243809:31244025,31244513:31245769,31244591:31245845,31244677:31245872,31244936:31246340,31245203:31245993,31245458:31245912,31245477:31246118,31246187:31246494,31246560:31246727,31247263:31247368,31247461:31247523,31247462:31247570,31247974:31248004,31247975:31248087,31248196:31248298,31248412:31248554,31249108:31249149,31249311:31249335,31249604:31250028,31250143:31250214,31250360:31250811,31250514:31250648,31250834:31251029,31251008:31251200,31251262:31251406,31251432:31251658,31251719:31251913,31251978:31252317,31252412:31252666,31252413:31252590,31252731:31252797,31252860:31253072,31253049:31253141,31253050:31253177,31253459:31253542,31253696:31253801,31253828:31253934,31254115:31254223,31254398:31254865,31254969:31255440,31254970:31255085,31255210:31255392,31255461:31255705,31255845:31256071,31255846:31256120,31256178:31256404,31256434:31256721,31256760:31256905,31256932:31257148,31256933:31257223,31257299:31257513,31257759:3125782', 'assoc_mat': '31243157:pehd:4230:31243955,31243158:pehd:4230:31243344,31243159:pehd:4230:31243297,31243610:pehd:4230:31243784,31243809:pehd:4230:31244025,31244513:pehd:4230:31245769,31244591:pehd:4230:31245845,31244677:pehd:4230:31245872,31244936:pehd:4230:31246340,31245203:pehd:4230:31245993,31245458:pehd:4230:31245912,31245477:pehd:4230:31246118,31246187:pehd:4230:31246494,31246560:pehd:4230:31246727,31247263:pehd:4230:31247368,31247461:pehd:4230:31247523,31247462:pehd:4230:31247570,31247974:pehd:4230:31248004,31247975:pehd:4230:31248087,31248196:pehd:4230:31248298,31248412:pehd:4230:31248554,31249108:pehd:4230:31249149,31249311:pehd:4230:31249335,31249604:pehd:4230:31250028,31250143:pehd:4230:31250214,31250360:pehd:4230:31250811,31250514:pehd:4230:31250648,31250834:pehd:4230:31251029,31251008:pehd:4230:31251200,31251262:pehd:4230:31251406,31251432:pehd:4230:31251658,31251719:pehd:4230:31251913,31251978:pehd:4230:31252317,31252412:pehd:4230:31252666,31252413:pehd:4230:31252590,31252731:pehd:4230:31252797,31252860:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015142502244208466, 'nb_photo': 15275, 'list_port_cont': '31243301,31243335,31243785,31243960,31244029,31244222,31245762,31245846,31245878,31245919,31245952,31245981,31246112,31246353,31246458,31246498,31246663,31246739,31246956,31247076,31247367,31247528,31247566,31248014,31248085,31248302,31248551,31248692,31249148,31249326,31249904,31250027,31250211,31250659,31250812,31251018,31251193,31251404,31251654,31251918,31252315,31252587,31252670,31252798,31253067,31253151,31253186,31253544,31253800,31253928,31254224,31254870,31255091,31255391,31255430,31255698,31256068,31256116,31256410,31256709,31256893,31257151,31257217,31257512,31257730,31257822,31258096,31258417,31258619,31258864,31259154,31259507,31259583,31259858,31260237,31260587,31260861,31261106,31261339,31261512,31261550,31262221,31262501,31262746,31262781,31263090,31263178,31263499,31263685,31264063,31264297,31264566,31264838,31265061,31265379,31265841,31265921,31266494,31266802,31267107,31267512,31267640,31267817,31268039,31268119,31268414,31268533,31268856,31268902,31269348,31269385,31269415,31269458,3127001', 'assoc_port': '31243157:31243960,31243158:31243335,31243159:31243301,31243610:31243785,31243809:31244029,31244059:31244222,31244513:31245762,31244591:31245846,31244677:31245878,31244936:31246353,31245203:31245981,31245204:31245952,31245458:31245919,31245477:31246112,31246187:31246498,31246188:31246458,31246560:31246739,31246561:31246663,31246764:31246956,31247015:31247076,31247263:31247367,31247461:31247528,31247462:31247566,31247974:31248014,31247975:31248085,31248196:31248302,31248412:31248551,31248619:31248692,31248890:31249904,31249108:31249148,31249311:31249326,31249604:31250027,31250143:31250211,31250360:31250812,31250514:31250659,31250834:31251018,31251008:31251193,31251262:31251404,31251432:31251654,31251719:31251918,31251978:31252315,31252412:31252670,31252413:31252587,31252731:31252798,31252860:31253067,31253049:31253151,31253050:31253186,31253459:31253544,31253696:31253800,31253828:31253928,31254115:31254224,31254398:31254870,31254969:31255430,31254970:31255091,31255210:31255391,31255461:31255698,31255845:3125606', 'assoc_mat': '31243157:pet_clair:4230:31243960,31243158:pet_clair:4230:31243335,31243159:pet_clair:4230:31243301,31243610:pet_clair:4230:31243785,31243809:pet_clair:4230:31244029,31244059:pet_clair:4230:31244222,31244513:pet_clair:4230:31245762,31244591:pet_clair:4230:31245846,31244677:pet_clair:4230:31245878,31244936:pet_clair:4230:31246353,31245203:pet_clair:4230:31245981,31245204:pet_clair:4230:31245952,31245458:pet_clair:4230:31245919,31245477:pet_clair:4230:31246112,31246187:pet_clair:4230:31246498,31246188:pet_clair:4230:31246458,31246560:pet_clair:4230:31246739,31246561:pet_clair:4230:31246663,31246764:pet_clair:4230:31246956,31247015:pet_clair:4230:31247076,31247263:pet_clair:4230:31247367,31247461:pet_clair:4230:31247528,31247462:pet_clair:4230:31247566,31247974:pet_clair:4230:31248014,31247975:pet_clair:4230:31248085,31248196:pet_clair:4230:31248302,31248412:pet_clair:4230:31248551,31248619:pet_clair:4230:31248692,31248890:pet_clair:4230:31249904,31249108:pet_clair:4230:31249148,31249311:pet_clair:4230:31249326,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003107514034321112, 'nb_photo': 766, 'list_port_cont': '31243342,31243789,31243952,31244035,31245840,31245873,31245916,31245995,31246114,31246349,31246491,31246667,31247370,31247569,31248090,31248299,31248542,31249142,31250035,31250660,31250803,31251025,31251198,31251408,31251653,31251911,31252309,31252597,31252662,31253071,31253147,31253179,31253547,31253802,31253929,31254217,31255094,31255393,31255433,31255701,31256067,31256110,31256403,31256715,31256894,31257153,31257227,31257515,31257727,31258421,31258615,31259162,31259509,31260576,31261107,31261348,31261514,31261549,31262510,31263084,31263183,31263492,31264287,31264843,31265387,31265839,31265914,31266497,31267119,31267514,31267634,31267815,31268040,31268134,31268418,31268851,31268899,31269343,31269378,31269426,31269456,31269999,31270107,31270279,31270465,31270798,31270847,31271960,31272026,31272599,31272706,31273163,31273197,31273623,31273674,31274154,31274186,31274261,31274753,31274789,31274927,31275448,31275486,31275626,31275936,31276186,31276544,31276731,31277004,31277107,31277261,31277718,31278302,3127850', 'assoc_port': '31243157:31243952,31243158:31243342,31243610:31243789,31243809:31244035,31244591:31245840,31244677:31245873,31244936:31246349,31245203:31245995,31245458:31245916,31245477:31246114,31246187:31246491,31246561:31246667,31247263:31247370,31247462:31247569,31247975:31248090,31248196:31248299,31248412:31248542,31249108:31249142,31249604:31250035,31250360:31250803,31250514:31250660,31250834:31251025,31251008:31251198,31251262:31251408,31251432:31251653,31251719:31251911,31251978:31252309,31252412:31252662,31252413:31252597,31252860:31253071,31253049:31253147,31253050:31253179,31253459:31253547,31253696:31253802,31253828:31253929,31254115:31254217,31254969:31255433,31254970:31255094,31255210:31255393,31255461:31255701,31255845:31256067,31255846:31256110,31256178:31256403,31256434:31256715,31256760:31256894,31256932:31257153,31256933:31257227,31257299:31257515,31257588:31257727,31258249:31258421,31258484:31258615,31258933:31259162,31259326:31259509,31260334:31260576,31260957:31261107,31261165:31261348,31261370:3126154', 'assoc_mat': '31243157:pet_fonce:4230:31243952,31243158:pet_fonce:4230:31243342,31243610:pet_fonce:4230:31243789,31243809:pet_fonce:4230:31244035,31244591:pet_fonce:4230:31245840,31244677:pet_fonce:4230:31245873,31244936:pet_fonce:4230:31246349,31245203:pet_fonce:4230:31245995,31245458:pet_fonce:4230:31245916,31245477:pet_fonce:4230:31246114,31246187:pet_fonce:4230:31246491,31246561:pet_fonce:4230:31246667,31247263:pet_fonce:4230:31247370,31247462:pet_fonce:4230:31247569,31247975:pet_fonce:4230:31248090,31248196:pet_fonce:4230:31248299,31248412:pet_fonce:4230:31248542,31249108:pet_fonce:4230:31249142,31249604:pet_fonce:4230:31250035,31250360:pet_fonce:4230:31250803,31250514:pet_fonce:4230:31250660,31250834:pet_fonce:4230:31251025,31251008:pet_fonce:4230:31251198,31251262:pet_fonce:4230:31251408,31251432:pet_fonce:4230:31251653,31251719:pet_fonce:4230:31251911,31251978:pet_fonce:4230:31252309,31252412:pet_fonce:4230:31252662,31252413:pet_fonce:4230:31252597,31252860:pet_fonce:4230:31253071,31253049:pet_fonce:4230:31253147,3'}), 'main_stat': {'nb_photos': 1032}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31341139,31341140,31341141,31341142,31341143,31341144,31341145?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-10', 0.7182737270227025),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_10_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', '2.02%', 13003], 'carton': ['carton', '5.52%', 56518], 'metal': ['metal', '0.16%', 1297], 'papier': ['papier', '21.25%', 262954], 'pehd': ['pehd', '0.55%', 1852], 'pet_clair': ['pet_clair', '1.51%', 15275], 'pet_fonce': ['pet_fonce', '0.31%', 766]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_10_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.42user 2.94system 0:07.26elapsed 73%CPU (0avgtext+0avgdata 187196maxresident)k 8inputs+296outputs (1major+49028minor)pagefaults 0swaps