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_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -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_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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 : 204 month : 10 mtr_id : dashboard_places : SCCU_cam7 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_cam7' 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 = 204 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 = 204 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 = 204 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_cam7" 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 (3011134,3011800,3012508,3013148,3013844,3014450,3015046,3015516,3016108,3016548,3017072,3017596,3018304,3018648,3019222,3019814,3020406,3020650) 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.0173526584318021, 'nb_photo': 10829, 'list_port_cont': '31243125,31243382,31243589,31243860,31244064,31244347,31244439,31244852,31244883,31245721,31246074,31246196,31246309,31246526,31246564,31246770,31246807,31247147,31247635,31247685,31247829,31248219,31248256,31248638,31248805,31249031,31249193,31249424,31249466,31250332,31250770,31250876,31251055,31251230,31251449,31251730,31251945,31252427,31252636,31252704,31253221,31253308,31253431,31253606,31253834,31253997,31254188,31254261,31255133,31255232,31255508,31255811,31256143,31256201,31256353,31256775,31256977,31257301,31257394,31257603,31257775,31257861,31258644,31258937,31259186,31259615,31260150,31260302,31260422,31260662,31260888,31260930,31261181,31261629,31261940,31262263,31262585,31262847,31262920,31263211,31263247,31263529,31264328,31264358,31264882,31265169,31265949,31266037,31266252,31266541,31266588,31267148,31267188,31267542,31267727,31268156,31268208,31268452,31268587,31268936,31268979,31269523,31269578,31269612,31269656,31269923,31269967,31270034,31270574,31270697,31270994,31271020,31271066,3127209', 'assoc_port': '31242910:31243125,31243162:31243382,31243439:31243589,31243650:31243860,31243813:31244064,31244062:31244347,31244106:31244439,31244599:31244883,31244681:31244852,31244960:31246309,31245215:31245721,31245500:31246074,31245501:31246196,31246228:31246526,31246229:31246564,31246600:31246770,31246601:31246807,31247019:31247147,31247268:31247829,31247464:31247635,31247465:31247685,31248198:31248219,31248199:31248256,31248417:31248638,31248622:31248805,31248896:31249031,31249111:31249193,31249313:31249466,31249314:31249424,31250149:31250332,31250362:31250770,31250518:31250876,31250839:31251055,31251013:31251230,31251336:31251449,31251512:31251730,31251723:31251945,31252016:31252427,31252414:31252704,31252415:31252636,31253053:31253221,31253054:31253308,31253295:31253431,31253465:31253606,31253701:31253834,31253867:31253997,31254119:31254261,31254120:31254188,31254974:31255133,31254975:31255232,31255216:31255508,31255503:31255811,31255889:31256143,31255890:31256201,31256181:31256353,31256472:31256775,31256763:3125697', 'assoc_mat': '31242910:autre:4230:31243125,31243162:autre:4230:31243382,31243439:autre:4230:31243589,31243650:autre:4230:31243860,31243813:autre:4230:31244064,31244062:autre:4230:31244347,31244106:autre:4230:31244439,31244599:autre:4230:31244883,31244681:autre:4230:31244852,31244960:autre:4230:31246309,31245215:autre:4230:31245721,31245500:autre:4230:31246074,31245501:autre:4230:31246196,31246228:autre:4230:31246526,31246229:autre:4230:31246564,31246600:autre:4230:31246770,31246601:autre:4230:31246807,31247019:autre:4230:31247147,31247268:autre:4230:31247829,31247464:autre:4230:31247635,31247465:autre:4230:31247685,31248198:autre:4230:31248219,31248199:autre:4230:31248256,31248417:autre:4230:31248638,31248622:autre:4230:31248805,31248896:autre:4230:31249031,31249111:autre:4230:31249193,31249313:autre:4230:31249466,31249314:autre:4230:31249424,31250149:autre:4230:31250332,31250362:autre:4230:31250770,31250518:autre:4230:31250876,31250839:autre:4230:31251055,31251013:autre:4230:31251230,31251336:autre:4230:31251449,31251512:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07970912219520444, 'nb_photo': 75197, 'list_port_cont': '31243137,31243381,31243591,31243873,31244068,31244345,31244445,31244851,31244894,31245730,31246068,31246204,31246316,31246534,31246579,31246782,31246815,31247162,31247637,31247675,31247828,31248220,31248264,31248635,31248812,31249036,31249188,31249414,31249464,31250325,31250774,31250873,31251067,31251232,31251450,31251739,31251951,31252433,31252634,31252701,31253217,31253317,31253432,31253618,31253840,31254009,31254187,31254263,31255145,31255239,31255520,31255809,31256153,31256194,31256358,31256777,31256979,31257316,31257402,31257600,31257777,31257866,31258657,31258954,31259200,31259619,31260151,31260306,31260430,31260655,31260889,31260935,31261185,31261625,31261953,31262253,31262579,31262856,31262928,31263215,31263254,31263525,31264326,31264375,31264885,31265177,31265945,31266031,31266266,31266550,31266577,31267151,31267197,31267555,31267731,31268171,31268209,31268456,31268580,31268942,31268972,31269528,31269566,31269616,31269661,31269919,31269961,31270046,31270567,31270696,31270993,31271028,31271064,3127210', 'assoc_port': '31242910:31243137,31243162:31243381,31243439:31243591,31243650:31243873,31243813:31244068,31244062:31244345,31244106:31244445,31244599:31244894,31244681:31244851,31244960:31246316,31245215:31245730,31245500:31246068,31245501:31246204,31246228:31246534,31246229:31246579,31246600:31246782,31246601:31246815,31247019:31247162,31247268:31247828,31247464:31247637,31247465:31247675,31248198:31248220,31248199:31248264,31248417:31248635,31248622:31248812,31248896:31249036,31249111:31249188,31249313:31249464,31249314:31249414,31250149:31250325,31250362:31250774,31250518:31250873,31250839:31251067,31251013:31251232,31251336:31251450,31251512:31251739,31251723:31251951,31252016:31252433,31252414:31252701,31252415:31252634,31253053:31253217,31253054:31253317,31253295:31253432,31253465:31253618,31253701:31253840,31253867:31254009,31254119:31254263,31254120:31254187,31254974:31255145,31254975:31255239,31255216:31255520,31255503:31255809,31255889:31256153,31255890:31256194,31256181:31256358,31256472:31256777,31256763:3125697', 'assoc_mat': '31242910:carton:4230:31243137,31243162:carton:4230:31243381,31243439:carton:4230:31243591,31243650:carton:4230:31243873,31243813:carton:4230:31244068,31244062:carton:4230:31244345,31244106:carton:4230:31244445,31244599:carton:4230:31244894,31244681:carton:4230:31244851,31244960:carton:4230:31246316,31245215:carton:4230:31245730,31245500:carton:4230:31246068,31245501:carton:4230:31246204,31246228:carton:4230:31246534,31246229:carton:4230:31246579,31246600:carton:4230:31246782,31246601:carton:4230:31246815,31247019:carton:4230:31247162,31247268:carton:4230:31247828,31247464:carton:4230:31247637,31247465:carton:4230:31247675,31248198:carton:4230:31248220,31248199:carton:4230:31248264,31248417:carton:4230:31248635,31248622:carton:4230:31248812,31248896:carton:4230:31249036,31249111:carton:4230:31249188,31249313:carton:4230:31249464,31249314:carton:4230:31249414,31250149:carton:4230:31250325,31250362:carton:4230:31250774,31250518:carton:4230:31250873,31250839:carton:4230:31251067,31251013:carton:4230:31251232,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0019990466648498323, 'nb_photo': 1634, 'list_port_cont': '31243126,31243375,31243574,31243858,31244074,31244342,31244444,31244846,31244896,31245724,31246197,31246302,31246535,31246574,31246780,31246816,31247150,31247640,31247826,31248213,31248253,31248640,31248802,31249029,31249192,31249459,31250763,31250875,31251071,31251231,31251444,31251736,31251955,31252429,31252697,31253220,31253305,31253435,31253616,31253831,31254008,31254177,31254256,31255131,31255223,31255513,31255810,31256156,31256185,31256350,31256773,31256973,31257312,31257392,31257601,31257772,31258647,31258950,31259194,31259608,31260145,31260308,31260431,31260653,31260928,31261179,31261628,31261949,31262249,31262569,31262844,31262933,31263248,31263528,31264335,31264363,31264874,31265179,31265948,31266025,31266250,31266549,31266575,31267139,31267199,31267539,31267725,31268159,31268218,31268446,31268581,31268937,31268973,31269532,31269568,31269618,31269651,31269964,31270048,31270578,31270693,31270987,31271018,31271061,31272094,31272132,31272167,31272800,31272848,31273275,31273343,31273713,31273806,3127428', 'assoc_port': '31242910:31243126,31243162:31243375,31243439:31243574,31243650:31243858,31243813:31244074,31244062:31244342,31244106:31244444,31244599:31244896,31244681:31244846,31244960:31246302,31245215:31245724,31245501:31246197,31246228:31246535,31246229:31246574,31246600:31246780,31246601:31246816,31247019:31247150,31247268:31247826,31247464:31247640,31248198:31248213,31248199:31248253,31248417:31248640,31248622:31248802,31248896:31249029,31249111:31249192,31249313:31249459,31250362:31250763,31250518:31250875,31250839:31251071,31251013:31251231,31251336:31251444,31251512:31251736,31251723:31251955,31252016:31252429,31252414:31252697,31253053:31253220,31253054:31253305,31253295:31253435,31253465:31253616,31253701:31253831,31253867:31254008,31254119:31254256,31254120:31254177,31254974:31255131,31254975:31255223,31255216:31255513,31255503:31255810,31255889:31256156,31255890:31256185,31256181:31256350,31256472:31256773,31256763:31256973,31257011:31257312,31257012:31257392,31257337:31257601,31257626:31257772,31258287:3125895', 'assoc_mat': '31242910:metal:4230:31243126,31243162:metal:4230:31243375,31243439:metal:4230:31243574,31243650:metal:4230:31243858,31243813:metal:4230:31244074,31244062:metal:4230:31244342,31244106:metal:4230:31244444,31244599:metal:4230:31244896,31244681:metal:4230:31244846,31244960:metal:4230:31246302,31245215:metal:4230:31245724,31245501:metal:4230:31246197,31246228:metal:4230:31246535,31246229:metal:4230:31246574,31246600:metal:4230:31246780,31246601:metal:4230:31246816,31247019:metal:4230:31247150,31247268:metal:4230:31247826,31247464:metal:4230:31247640,31248198:metal:4230:31248213,31248199:metal:4230:31248253,31248417:metal:4230:31248640,31248622:metal:4230:31248802,31248896:metal:4230:31249029,31249111:metal:4230:31249192,31249313:metal:4230:31249459,31250362:metal:4230:31250763,31250518:metal:4230:31250875,31250839:metal:4230:31251071,31251013:metal:4230:31251231,31251336:metal:4230:31251444,31251512:metal:4230:31251736,31251723:metal:4230:31251955,31252016:metal:4230:31252429,31252414:metal:4230:31252697,31253053:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2484649980590342, 'nb_photo': 232473, 'list_port_cont': '31243135,31243372,31243586,31243864,31244077,31244348,31244450,31244857,31244888,31245716,31246065,31246194,31246313,31246536,31246578,31246775,31246817,31247154,31247648,31247684,31247821,31248227,31248261,31248642,31248798,31249041,31249194,31249420,31249457,31250329,31250771,31250863,31251070,31251236,31251441,31251733,31251941,31252428,31252629,31252709,31253215,31253309,31253439,31253620,31253843,31254006,31254190,31254251,31255138,31255237,31255521,31255807,31256155,31256195,31256364,31256781,31256985,31257315,31257395,31257602,31257780,31257862,31258654,31258947,31259195,31259616,31260152,31260298,31260436,31260657,31260891,31260932,31261194,31261619,31261947,31262257,31262576,31262860,31262936,31263219,31263257,31263532,31264333,31264371,31264870,31265174,31265951,31266030,31266265,31266543,31266589,31267153,31267195,31267553,31267732,31268166,31268217,31268457,31268591,31268929,31268984,31269539,31269579,31269619,31269659,31269922,31269965,31270043,31270575,31270701,31270992,31271024,31271071,3127210', 'assoc_port': '31242910:31243135,31243162:31243372,31243439:31243586,31243650:31243864,31243813:31244077,31244062:31244348,31244106:31244450,31244599:31244888,31244681:31244857,31244960:31246313,31245215:31245716,31245500:31246065,31245501:31246194,31246228:31246536,31246229:31246578,31246600:31246775,31246601:31246817,31247019:31247154,31247268:31247821,31247464:31247648,31247465:31247684,31248198:31248227,31248199:31248261,31248417:31248642,31248622:31248798,31248896:31249041,31249111:31249194,31249313:31249457,31249314:31249420,31250149:31250329,31250362:31250771,31250518:31250863,31250839:31251070,31251013:31251236,31251336:31251441,31251512:31251733,31251723:31251941,31252016:31252428,31252414:31252709,31252415:31252629,31253053:31253215,31253054:31253309,31253295:31253439,31253465:31253620,31253701:31253843,31253867:31254006,31254119:31254251,31254120:31254190,31254974:31255138,31254975:31255237,31255216:31255521,31255503:31255807,31255889:31256155,31255890:31256195,31256181:31256364,31256472:31256781,31256763:3125698', 'assoc_mat': '31242910:papier:4230:31243135,31243162:papier:4230:31243372,31243439:papier:4230:31243586,31243650:papier:4230:31243864,31243813:papier:4230:31244077,31244062:papier:4230:31244348,31244106:papier:4230:31244450,31244599:papier:4230:31244888,31244681:papier:4230:31244857,31244960:papier:4230:31246313,31245215:papier:4230:31245716,31245500:papier:4230:31246065,31245501:papier:4230:31246194,31246228:papier:4230:31246536,31246229:papier:4230:31246578,31246600:papier:4230:31246775,31246601:papier:4230:31246817,31247019:papier:4230:31247154,31247268:papier:4230:31247821,31247464:papier:4230:31247648,31247465:papier:4230:31247684,31248198:papier:4230:31248227,31248199:papier:4230:31248261,31248417:papier:4230:31248642,31248622:papier:4230:31248798,31248896:papier:4230:31249041,31249111:papier:4230:31249194,31249313:papier:4230:31249457,31249314:papier:4230:31249420,31250149:papier:4230:31250329,31250362:papier:4230:31250771,31250518:papier:4230:31250863,31250839:papier:4230:31251070,31251013:papier:4230:31251236,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005452743921995672, 'nb_photo': 2190, 'list_port_cont': '31243134,31243384,31243577,31243871,31244071,31244343,31244451,31244858,31244897,31245727,31246069,31246206,31246308,31246525,31246571,31246778,31246821,31247161,31247643,31247690,31247825,31248230,31248269,31248631,31248814,31249035,31249191,31249416,31249463,31250772,31250869,31251072,31251228,31251451,31251734,31251950,31252432,31252630,31252706,31253224,31253312,31253433,31253623,31253845,31254002,31254184,31254264,31255142,31255229,31255514,31255795,31256154,31256199,31256363,31256778,31256984,31257314,31257398,31257606,31257779,31258650,31258949,31259199,31260154,31260305,31260435,31260650,31260899,31260931,31261188,31261632,31261948,31262259,31262582,31262857,31262924,31263216,31263259,31263520,31264373,31264875,31265956,31266035,31266264,31266580,31267155,31267200,31267552,31267734,31268167,31268212,31268453,31268585,31268941,31268982,31269567,31269614,31269652,31269914,31269966,31270035,31270573,31271030,31271067,31272106,31272131,31272173,31272801,31272834,31273271,31273333,31273722,31273807,3127433', 'assoc_port': '31242910:31243134,31243162:31243384,31243439:31243577,31243650:31243871,31243813:31244071,31244062:31244343,31244106:31244451,31244599:31244897,31244681:31244858,31244960:31246308,31245215:31245727,31245500:31246069,31245501:31246206,31246228:31246525,31246229:31246571,31246600:31246778,31246601:31246821,31247019:31247161,31247268:31247825,31247464:31247643,31247465:31247690,31248198:31248230,31248199:31248269,31248417:31248631,31248622:31248814,31248896:31249035,31249111:31249191,31249313:31249463,31249314:31249416,31250362:31250772,31250518:31250869,31250839:31251072,31251013:31251228,31251336:31251451,31251512:31251734,31251723:31251950,31252016:31252432,31252414:31252706,31252415:31252630,31253053:31253224,31253054:31253312,31253295:31253433,31253465:31253623,31253701:31253845,31253867:31254002,31254119:31254264,31254120:31254184,31254974:31255142,31254975:31255229,31255216:31255514,31255503:31255795,31255889:31256154,31255890:31256199,31256181:31256363,31256472:31256778,31256763:31256984,31257011:3125731', 'assoc_mat': '31242910:pehd:4230:31243134,31243162:pehd:4230:31243384,31243439:pehd:4230:31243577,31243650:pehd:4230:31243871,31243813:pehd:4230:31244071,31244062:pehd:4230:31244343,31244106:pehd:4230:31244451,31244599:pehd:4230:31244897,31244681:pehd:4230:31244858,31244960:pehd:4230:31246308,31245215:pehd:4230:31245727,31245500:pehd:4230:31246069,31245501:pehd:4230:31246206,31246228:pehd:4230:31246525,31246229:pehd:4230:31246571,31246600:pehd:4230:31246778,31246601:pehd:4230:31246821,31247019:pehd:4230:31247161,31247268:pehd:4230:31247825,31247464:pehd:4230:31247643,31247465:pehd:4230:31247690,31248198:pehd:4230:31248230,31248199:pehd:4230:31248269,31248417:pehd:4230:31248631,31248622:pehd:4230:31248814,31248896:pehd:4230:31249035,31249111:pehd:4230:31249191,31249313:pehd:4230:31249463,31249314:pehd:4230:31249416,31250362:pehd:4230:31250772,31250518:pehd:4230:31250869,31250839:pehd:4230:31251072,31251013:pehd:4230:31251228,31251336:pehd:4230:31251451,31251512:pehd:4230:31251734,31251723:pehd:4230:31251950,31252016:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012962910551459653, 'nb_photo': 15312, 'list_port_cont': '31243132,31243368,31243579,31243872,31244081,31244341,31244446,31244849,31244886,31245729,31246075,31246202,31246312,31246538,31246576,31246773,31246812,31247158,31247646,31247682,31247819,31248224,31248260,31248644,31248806,31249038,31249182,31249411,31249462,31250330,31250768,31250870,31251069,31251239,31251447,31251742,31251946,31252424,31252635,31252700,31253228,31253304,31253438,31253621,31253842,31254013,31254186,31254260,31255137,31255240,31255509,31255803,31256157,31256200,31256361,31256771,31256986,31257306,31257397,31257604,31257781,31257865,31258646,31258952,31259192,31259622,31260146,31260307,31260437,31260659,31260901,31260936,31261186,31261631,31261946,31262261,31262584,31262852,31262934,31263217,31263246,31263533,31264332,31264374,31264880,31265176,31265954,31266027,31266267,31266547,31266583,31267150,31267201,31267550,31267723,31268172,31268220,31268443,31268586,31268935,31268983,31269534,31269580,31269611,31269657,31269918,31269959,31270047,31270579,31270690,31270991,31271035,31271059,3127209', 'assoc_port': '31242910:31243132,31243162:31243368,31243439:31243579,31243650:31243872,31243813:31244081,31244062:31244341,31244106:31244446,31244599:31244886,31244681:31244849,31244960:31246312,31245215:31245729,31245500:31246075,31245501:31246202,31246228:31246538,31246229:31246576,31246600:31246773,31246601:31246812,31247019:31247158,31247268:31247819,31247464:31247646,31247465:31247682,31248198:31248224,31248199:31248260,31248417:31248644,31248622:31248806,31248896:31249038,31249111:31249182,31249313:31249462,31249314:31249411,31250149:31250330,31250362:31250768,31250518:31250870,31250839:31251069,31251013:31251239,31251336:31251447,31251512:31251742,31251723:31251946,31252016:31252424,31252414:31252700,31252415:31252635,31253053:31253228,31253054:31253304,31253295:31253438,31253465:31253621,31253701:31253842,31253867:31254013,31254119:31254260,31254120:31254186,31254974:31255137,31254975:31255240,31255216:31255509,31255503:31255803,31255889:31256157,31255890:31256200,31256181:31256361,31256472:31256771,31256763:3125698', 'assoc_mat': '31242910:pet_clair:4230:31243132,31243162:pet_clair:4230:31243368,31243439:pet_clair:4230:31243579,31243650:pet_clair:4230:31243872,31243813:pet_clair:4230:31244081,31244062:pet_clair:4230:31244341,31244106:pet_clair:4230:31244446,31244599:pet_clair:4230:31244886,31244681:pet_clair:4230:31244849,31244960:pet_clair:4230:31246312,31245215:pet_clair:4230:31245729,31245500:pet_clair:4230:31246075,31245501:pet_clair:4230:31246202,31246228:pet_clair:4230:31246538,31246229:pet_clair:4230:31246576,31246600:pet_clair:4230:31246773,31246601:pet_clair:4230:31246812,31247019:pet_clair:4230:31247158,31247268:pet_clair:4230:31247819,31247464:pet_clair:4230:31247646,31247465:pet_clair:4230:31247682,31248198:pet_clair:4230:31248224,31248199:pet_clair:4230:31248260,31248417:pet_clair:4230:31248644,31248622:pet_clair:4230:31248806,31248896:pet_clair:4230:31249038,31249111:pet_clair:4230:31249182,31249313:pet_clair:4230:31249462,31249314:pet_clair:4230:31249411,31250149:pet_clair:4230:31250330,31250362:pet_clair:4230:31250768,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002808715491316932, 'nb_photo': 738, 'list_port_cont': '31243130,31243383,31243590,31243867,31244078,31244338,31244448,31244847,31244895,31246073,31246207,31246314,31246540,31246772,31247818,31248225,31248258,31248636,31249039,31249187,31249467,31250328,31250776,31250868,31251065,31251240,31251435,31251738,31251954,31252712,31253222,31253306,31253428,31254010,31254262,31255236,31255511,31255804,31256152,31256197,31256355,31256783,31257313,31257404,31257767,31257852,31259614,31260155,31260303,31260432,31260663,31260933,31261191,31261621,31261954,31262264,31262581,31262858,31262927,31263220,31264372,31264881,31265952,31266036,31266548,31267147,31267192,31267554,31267730,31268161,31268219,31268582,31268931,31268970,31269577,31269960,31270033,31270699,31271032,31272101,31272138,31272179,31272798,31272845,31273340,31273724,31273809,31274272,31274395,31274435,31275110,31275571,31276290,31276670,31277449,31277532,31277929,31278003,31278142,31278553,31280165,31280259,31280626,31280841,31281156,31281497,31281791,31282005,31282303,31282862,31283190,31284477,31284584,3128484', 'assoc_port': '31242910:31243130,31243162:31243383,31243439:31243590,31243650:31243867,31243813:31244078,31244062:31244338,31244106:31244448,31244599:31244895,31244681:31244847,31244960:31246314,31245500:31246073,31245501:31246207,31246228:31246540,31246600:31246772,31247268:31247818,31248198:31248225,31248199:31248258,31248417:31248636,31248896:31249039,31249111:31249187,31249313:31249467,31250149:31250328,31250362:31250776,31250518:31250868,31250839:31251065,31251013:31251240,31251336:31251435,31251512:31251738,31251723:31251954,31252414:31252712,31253053:31253222,31253054:31253306,31253295:31253428,31253867:31254010,31254119:31254262,31254975:31255236,31255216:31255511,31255503:31255804,31255889:31256152,31255890:31256197,31256181:31256355,31256472:31256783,31257011:31257313,31257012:31257404,31257626:31257767,31257763:31257852,31259329:31259614,31259330:31260155,31259691:31260432,31260046:31260303,31260373:31260663,31260739:31260933,31260964:31261191,31261375:31261621,31261731:31261954,31262043:31262264,31262341:3126258', 'assoc_mat': '31242910:pet_fonce:4230:31243130,31243162:pet_fonce:4230:31243383,31243439:pet_fonce:4230:31243590,31243650:pet_fonce:4230:31243867,31243813:pet_fonce:4230:31244078,31244062:pet_fonce:4230:31244338,31244106:pet_fonce:4230:31244448,31244599:pet_fonce:4230:31244895,31244681:pet_fonce:4230:31244847,31244960:pet_fonce:4230:31246314,31245500:pet_fonce:4230:31246073,31245501:pet_fonce:4230:31246207,31246228:pet_fonce:4230:31246540,31246600:pet_fonce:4230:31246772,31247268:pet_fonce:4230:31247818,31248198:pet_fonce:4230:31248225,31248199:pet_fonce:4230:31248258,31248417:pet_fonce:4230:31248636,31248896:pet_fonce:4230:31249039,31249111:pet_fonce:4230:31249187,31249313:pet_fonce:4230:31249467,31250149:pet_fonce:4230:31250328,31250362:pet_fonce:4230:31250776,31250518:pet_fonce:4230:31250868,31250839:pet_fonce:4230:31251065,31251013:pet_fonce:4230:31251240,31251336:pet_fonce:4230:31251435,31251512:pet_fonce:4230:31251738,31251723:pet_fonce:4230:31251954,31252414:pet_fonce:4230:31252712,31253053:pet_fonce:4230:31253222,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(3011134,3011800,3012508,3013148,3013844,3014450,3015046,3015516,3016108,3016548,3017072,3017596,3018304,3018648,3019222,3019814,3020406,3020650)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341221, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243125,31243382,31243589,31243860,31244064,31244347,31244439,31244852,31244883,31245721,31246074,31246196,31246309,31246526,31246564,31246770,31246807,31247147,31247635,31247685,31247829,31248219,31248256,31248638,31248805,31249031,31249193,31249424,31249466,31250332,31250770,31250876,31251055,31251230,31251449,31251730,31251945,31252427,31252636,31252704,31253221,31253308,31253431,31253606,31253834,31253997,31254188,31254261,31255133,31255232,31255508,31255811,31256143,31256201,31256353,31256775,31256977,31257301,31257394,31257603,31257775,31257861,31258644,31258937,31259186,31259615,31260150,31260302,31260422,31260662,31260888,31260930,31261181,31261629,31261940,31262263,31262585,31262847,31262920,31263211,31263247,31263529,31264328,31264358,31264882,31265169,31265949,31266037,31266252,31266541,31266588,31267148,31267188,31267542,31267727,31268156,31268208,31268452,31268587,31268936,31268979,31269523,31269578,31269612,31269656,31269923,31269967,31270034,31270574,31270697,31270994,31271020,31271066,3127209 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341222, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243137,31243381,31243591,31243873,31244068,31244345,31244445,31244851,31244894,31245730,31246068,31246204,31246316,31246534,31246579,31246782,31246815,31247162,31247637,31247675,31247828,31248220,31248264,31248635,31248812,31249036,31249188,31249414,31249464,31250325,31250774,31250873,31251067,31251232,31251450,31251739,31251951,31252433,31252634,31252701,31253217,31253317,31253432,31253618,31253840,31254009,31254187,31254263,31255145,31255239,31255520,31255809,31256153,31256194,31256358,31256777,31256979,31257316,31257402,31257600,31257777,31257866,31258657,31258954,31259200,31259619,31260151,31260306,31260430,31260655,31260889,31260935,31261185,31261625,31261953,31262253,31262579,31262856,31262928,31263215,31263254,31263525,31264326,31264375,31264885,31265177,31265945,31266031,31266266,31266550,31266577,31267151,31267197,31267555,31267731,31268171,31268209,31268456,31268580,31268942,31268972,31269528,31269566,31269616,31269661,31269919,31269961,31270046,31270567,31270696,31270993,31271028,31271064,3127210 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341223, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243126,31243375,31243574,31243858,31244074,31244342,31244444,31244846,31244896,31245724,31246197,31246302,31246535,31246574,31246780,31246816,31247150,31247640,31247826,31248213,31248253,31248640,31248802,31249029,31249192,31249459,31250763,31250875,31251071,31251231,31251444,31251736,31251955,31252429,31252697,31253220,31253305,31253435,31253616,31253831,31254008,31254177,31254256,31255131,31255223,31255513,31255810,31256156,31256185,31256350,31256773,31256973,31257312,31257392,31257601,31257772,31258647,31258950,31259194,31259608,31260145,31260308,31260431,31260653,31260928,31261179,31261628,31261949,31262249,31262569,31262844,31262933,31263248,31263528,31264335,31264363,31264874,31265179,31265948,31266025,31266250,31266549,31266575,31267139,31267199,31267539,31267725,31268159,31268218,31268446,31268581,31268937,31268973,31269532,31269568,31269618,31269651,31269964,31270048,31270578,31270693,31270987,31271018,31271061,31272094,31272132,31272167,31272800,31272848,31273275,31273343,31273713,31273806,3127428 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341224, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243135,31243372,31243586,31243864,31244077,31244348,31244450,31244857,31244888,31245716,31246065,31246194,31246313,31246536,31246578,31246775,31246817,31247154,31247648,31247684,31247821,31248227,31248261,31248642,31248798,31249041,31249194,31249420,31249457,31250329,31250771,31250863,31251070,31251236,31251441,31251733,31251941,31252428,31252629,31252709,31253215,31253309,31253439,31253620,31253843,31254006,31254190,31254251,31255138,31255237,31255521,31255807,31256155,31256195,31256364,31256781,31256985,31257315,31257395,31257602,31257780,31257862,31258654,31258947,31259195,31259616,31260152,31260298,31260436,31260657,31260891,31260932,31261194,31261619,31261947,31262257,31262576,31262860,31262936,31263219,31263257,31263532,31264333,31264371,31264870,31265174,31265951,31266030,31266265,31266543,31266589,31267153,31267195,31267553,31267732,31268166,31268217,31268457,31268591,31268929,31268984,31269539,31269579,31269619,31269659,31269922,31269965,31270043,31270575,31270701,31270992,31271024,31271071,3127210 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341225, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243134,31243384,31243577,31243871,31244071,31244343,31244451,31244858,31244897,31245727,31246069,31246206,31246308,31246525,31246571,31246778,31246821,31247161,31247643,31247690,31247825,31248230,31248269,31248631,31248814,31249035,31249191,31249416,31249463,31250772,31250869,31251072,31251228,31251451,31251734,31251950,31252432,31252630,31252706,31253224,31253312,31253433,31253623,31253845,31254002,31254184,31254264,31255142,31255229,31255514,31255795,31256154,31256199,31256363,31256778,31256984,31257314,31257398,31257606,31257779,31258650,31258949,31259199,31260154,31260305,31260435,31260650,31260899,31260931,31261188,31261632,31261948,31262259,31262582,31262857,31262924,31263216,31263259,31263520,31264373,31264875,31265956,31266035,31266264,31266580,31267155,31267200,31267552,31267734,31268167,31268212,31268453,31268585,31268941,31268982,31269567,31269614,31269652,31269914,31269966,31270035,31270573,31271030,31271067,31272106,31272131,31272173,31272801,31272834,31273271,31273333,31273722,31273807,3127433 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341226, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243132,31243368,31243579,31243872,31244081,31244341,31244446,31244849,31244886,31245729,31246075,31246202,31246312,31246538,31246576,31246773,31246812,31247158,31247646,31247682,31247819,31248224,31248260,31248644,31248806,31249038,31249182,31249411,31249462,31250330,31250768,31250870,31251069,31251239,31251447,31251742,31251946,31252424,31252635,31252700,31253228,31253304,31253438,31253621,31253842,31254013,31254186,31254260,31255137,31255240,31255509,31255803,31256157,31256200,31256361,31256771,31256986,31257306,31257397,31257604,31257781,31257865,31258646,31258952,31259192,31259622,31260146,31260307,31260437,31260659,31260901,31260936,31261186,31261631,31261946,31262261,31262584,31262852,31262934,31263217,31263246,31263533,31264332,31264374,31264880,31265176,31265954,31266027,31266267,31266547,31266583,31267150,31267201,31267550,31267723,31268172,31268220,31268443,31268586,31268935,31268983,31269534,31269580,31269611,31269657,31269918,31269959,31270047,31270579,31270690,31270991,31271035,31271059,3127209 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341227, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243130,31243383,31243590,31243867,31244078,31244338,31244448,31244847,31244895,31246073,31246207,31246314,31246540,31246772,31247818,31248225,31248258,31248636,31249039,31249187,31249467,31250328,31250776,31250868,31251065,31251240,31251435,31251738,31251954,31252712,31253222,31253306,31253428,31254010,31254262,31255236,31255511,31255804,31256152,31256197,31256355,31256783,31257313,31257404,31257767,31257852,31259614,31260155,31260303,31260432,31260663,31260933,31261191,31261621,31261954,31262264,31262581,31262858,31262927,31263220,31264372,31264881,31265952,31266036,31266548,31267147,31267192,31267554,31267730,31268161,31268219,31268582,31268931,31268970,31269577,31269960,31270033,31270699,31271032,31272101,31272138,31272179,31272798,31272845,31273340,31273724,31273809,31274272,31274395,31274435,31275110,31275571,31276290,31276670,31277449,31277532,31277929,31278003,31278142,31278553,31280165,31280259,31280626,31280841,31281156,31281497,31281791,31282005,31282303,31282862,31283190,31284477,31284584,3128484 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31341221,31341222,31341223,31341224,31341225,31341226,31341227?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=204 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': ((936,),), 'unwanted_material_monthly_percentage': ((0.6589124892085263,),), 'material_repartition': (('incineration', 935),), 'material_dict': {'incineration': 935}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 10, 1), 0.6611281632073951, 3), (datetime.date(2026, 10, 2), 0.6216015924708596, 3), (datetime.date(2026, 10, 3), 0.6381739355540377, 2), (datetime.date(2026, 10, 4), 0.7091015473374699, 2), (datetime.date(2026, 10, 5), 0.7225354153202342, 4), (datetime.date(2026, 10, 6), 0.6725320892761918, 2), (datetime.date(2026, 10, 7), 0.5934438798447818, 2), (datetime.date(2026, 10, 8), 0.6928960121305671, 3), (datetime.date(2026, 10, 9), 0.6788450581511413, 2), (datetime.date(2026, 10, 10), 0.6470368328785875, 2), (datetime.date(2026, 10, 11), 0.744652495141112, 2), (datetime.date(2026, 10, 12), 0.7248326821189933, 1), (datetime.date(2026, 10, 13), 0.6769813881216094, 2), (datetime.date(2026, 10, 14), 0.67516701805559, 1), (datetime.date(2026, 10, 15), 0.6139454478777748, 3), (datetime.date(2026, 10, 16), 0.5412363077960705, 2), (datetime.date(2026, 10, 17), 0.5807807609365668, 2), (datetime.date(2026, 10, 18), 0.64820911550743, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 10, 1), 0.6611281632073951, 3), (datetime.date(2026, 10, 2), 0.6216015924708596, 3), (datetime.date(2026, 10, 3), 0.6381739355540377, 2), (datetime.date(2026, 10, 4), 0.7091015473374699, 2), (datetime.date(2026, 10, 5), 0.7225354153202342, 4), (datetime.date(2026, 10, 6), 0.6725320892761918, 2), (datetime.date(2026, 10, 7), 0.5934438798447818, 2), (datetime.date(2026, 10, 8), 0.6928960121305671, 3), (datetime.date(2026, 10, 9), 0.6788450581511413, 2), (datetime.date(2026, 10, 10), 0.6470368328785875, 2), (datetime.date(2026, 10, 11), 0.744652495141112, 2), (datetime.date(2026, 10, 12), 0.7248326821189933, 1), (datetime.date(2026, 10, 13), 0.6769813881216094, 2), (datetime.date(2026, 10, 14), 0.67516701805559, 1), (datetime.date(2026, 10, 15), 0.6139454478777748, 3), (datetime.date(2026, 10, 16), 0.5412363077960705, 2), (datetime.date(2026, 10, 17), 0.5807807609365668, 2), (datetime.date(2026, 10, 18), 0.64820911550743, 1))}, 'quality_array': [['-8.10700638878741', '01102026'], ['-8.882288114688118', '02102026'], ['-8.912355317533049', '03102026'], ['-8.420920804235687', '04102026'], ['-8.492327713161314', '05102026'], ['-8.898542640641507', '06102026'], ['-9.091839910856283', '07102026'], ['-7.60591847657195', '08102026'], ['-8.614733327580714', '09102026'], ['-8.447225863979599', '10102026'], ['-8.562153322726031', '11102026'], ['-8.174491068449262', '12102026'], ['-8.748801196748932', '13102026'], ['-8.705040589737594', '14102026'], ['-8.530771407177268', '15102026'], ['-8.777525525911845', '16102026'], ['-8.85273540771212', '17102026'], ['-8.596386679363693', '18102026']], 'number_of_batch': ((380,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0173526584318021, 'nb_photo': 10829, 'list_port_cont': '31243125,31243382,31243589,31243860,31244064,31244347,31244439,31244852,31244883,31245721,31246074,31246196,31246309,31246526,31246564,31246770,31246807,31247147,31247635,31247685,31247829,31248219,31248256,31248638,31248805,31249031,31249193,31249424,31249466,31250332,31250770,31250876,31251055,31251230,31251449,31251730,31251945,31252427,31252636,31252704,31253221,31253308,31253431,31253606,31253834,31253997,31254188,31254261,31255133,31255232,31255508,31255811,31256143,31256201,31256353,31256775,31256977,31257301,31257394,31257603,31257775,31257861,31258644,31258937,31259186,31259615,31260150,31260302,31260422,31260662,31260888,31260930,31261181,31261629,31261940,31262263,31262585,31262847,31262920,31263211,31263247,31263529,31264328,31264358,31264882,31265169,31265949,31266037,31266252,31266541,31266588,31267148,31267188,31267542,31267727,31268156,31268208,31268452,31268587,31268936,31268979,31269523,31269578,31269612,31269656,31269923,31269967,31270034,31270574,31270697,31270994,31271020,31271066,3127209', 'assoc_port': '31242910:31243125,31243162:31243382,31243439:31243589,31243650:31243860,31243813:31244064,31244062:31244347,31244106:31244439,31244599:31244883,31244681:31244852,31244960:31246309,31245215:31245721,31245500:31246074,31245501:31246196,31246228:31246526,31246229:31246564,31246600:31246770,31246601:31246807,31247019:31247147,31247268:31247829,31247464:31247635,31247465:31247685,31248198:31248219,31248199:31248256,31248417:31248638,31248622:31248805,31248896:31249031,31249111:31249193,31249313:31249466,31249314:31249424,31250149:31250332,31250362:31250770,31250518:31250876,31250839:31251055,31251013:31251230,31251336:31251449,31251512:31251730,31251723:31251945,31252016:31252427,31252414:31252704,31252415:31252636,31253053:31253221,31253054:31253308,31253295:31253431,31253465:31253606,31253701:31253834,31253867:31253997,31254119:31254261,31254120:31254188,31254974:31255133,31254975:31255232,31255216:31255508,31255503:31255811,31255889:31256143,31255890:31256201,31256181:31256353,31256472:31256775,31256763:3125697', 'assoc_mat': '31242910:autre:4230:31243125,31243162:autre:4230:31243382,31243439:autre:4230:31243589,31243650:autre:4230:31243860,31243813:autre:4230:31244064,31244062:autre:4230:31244347,31244106:autre:4230:31244439,31244599:autre:4230:31244883,31244681:autre:4230:31244852,31244960:autre:4230:31246309,31245215:autre:4230:31245721,31245500:autre:4230:31246074,31245501:autre:4230:31246196,31246228:autre:4230:31246526,31246229:autre:4230:31246564,31246600:autre:4230:31246770,31246601:autre:4230:31246807,31247019:autre:4230:31247147,31247268:autre:4230:31247829,31247464:autre:4230:31247635,31247465:autre:4230:31247685,31248198:autre:4230:31248219,31248199:autre:4230:31248256,31248417:autre:4230:31248638,31248622:autre:4230:31248805,31248896:autre:4230:31249031,31249111:autre:4230:31249193,31249313:autre:4230:31249466,31249314:autre:4230:31249424,31250149:autre:4230:31250332,31250362:autre:4230:31250770,31250518:autre:4230:31250876,31250839:autre:4230:31251055,31251013:autre:4230:31251230,31251336:autre:4230:31251449,31251512:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07970912219520444, 'nb_photo': 75197, 'list_port_cont': '31243137,31243381,31243591,31243873,31244068,31244345,31244445,31244851,31244894,31245730,31246068,31246204,31246316,31246534,31246579,31246782,31246815,31247162,31247637,31247675,31247828,31248220,31248264,31248635,31248812,31249036,31249188,31249414,31249464,31250325,31250774,31250873,31251067,31251232,31251450,31251739,31251951,31252433,31252634,31252701,31253217,31253317,31253432,31253618,31253840,31254009,31254187,31254263,31255145,31255239,31255520,31255809,31256153,31256194,31256358,31256777,31256979,31257316,31257402,31257600,31257777,31257866,31258657,31258954,31259200,31259619,31260151,31260306,31260430,31260655,31260889,31260935,31261185,31261625,31261953,31262253,31262579,31262856,31262928,31263215,31263254,31263525,31264326,31264375,31264885,31265177,31265945,31266031,31266266,31266550,31266577,31267151,31267197,31267555,31267731,31268171,31268209,31268456,31268580,31268942,31268972,31269528,31269566,31269616,31269661,31269919,31269961,31270046,31270567,31270696,31270993,31271028,31271064,3127210', 'assoc_port': '31242910:31243137,31243162:31243381,31243439:31243591,31243650:31243873,31243813:31244068,31244062:31244345,31244106:31244445,31244599:31244894,31244681:31244851,31244960:31246316,31245215:31245730,31245500:31246068,31245501:31246204,31246228:31246534,31246229:31246579,31246600:31246782,31246601:31246815,31247019:31247162,31247268:31247828,31247464:31247637,31247465:31247675,31248198:31248220,31248199:31248264,31248417:31248635,31248622:31248812,31248896:31249036,31249111:31249188,31249313:31249464,31249314:31249414,31250149:31250325,31250362:31250774,31250518:31250873,31250839:31251067,31251013:31251232,31251336:31251450,31251512:31251739,31251723:31251951,31252016:31252433,31252414:31252701,31252415:31252634,31253053:31253217,31253054:31253317,31253295:31253432,31253465:31253618,31253701:31253840,31253867:31254009,31254119:31254263,31254120:31254187,31254974:31255145,31254975:31255239,31255216:31255520,31255503:31255809,31255889:31256153,31255890:31256194,31256181:31256358,31256472:31256777,31256763:3125697', 'assoc_mat': '31242910:carton:4230:31243137,31243162:carton:4230:31243381,31243439:carton:4230:31243591,31243650:carton:4230:31243873,31243813:carton:4230:31244068,31244062:carton:4230:31244345,31244106:carton:4230:31244445,31244599:carton:4230:31244894,31244681:carton:4230:31244851,31244960:carton:4230:31246316,31245215:carton:4230:31245730,31245500:carton:4230:31246068,31245501:carton:4230:31246204,31246228:carton:4230:31246534,31246229:carton:4230:31246579,31246600:carton:4230:31246782,31246601:carton:4230:31246815,31247019:carton:4230:31247162,31247268:carton:4230:31247828,31247464:carton:4230:31247637,31247465:carton:4230:31247675,31248198:carton:4230:31248220,31248199:carton:4230:31248264,31248417:carton:4230:31248635,31248622:carton:4230:31248812,31248896:carton:4230:31249036,31249111:carton:4230:31249188,31249313:carton:4230:31249464,31249314:carton:4230:31249414,31250149:carton:4230:31250325,31250362:carton:4230:31250774,31250518:carton:4230:31250873,31250839:carton:4230:31251067,31251013:carton:4230:31251232,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0019990466648498323, 'nb_photo': 1634, 'list_port_cont': '31243126,31243375,31243574,31243858,31244074,31244342,31244444,31244846,31244896,31245724,31246197,31246302,31246535,31246574,31246780,31246816,31247150,31247640,31247826,31248213,31248253,31248640,31248802,31249029,31249192,31249459,31250763,31250875,31251071,31251231,31251444,31251736,31251955,31252429,31252697,31253220,31253305,31253435,31253616,31253831,31254008,31254177,31254256,31255131,31255223,31255513,31255810,31256156,31256185,31256350,31256773,31256973,31257312,31257392,31257601,31257772,31258647,31258950,31259194,31259608,31260145,31260308,31260431,31260653,31260928,31261179,31261628,31261949,31262249,31262569,31262844,31262933,31263248,31263528,31264335,31264363,31264874,31265179,31265948,31266025,31266250,31266549,31266575,31267139,31267199,31267539,31267725,31268159,31268218,31268446,31268581,31268937,31268973,31269532,31269568,31269618,31269651,31269964,31270048,31270578,31270693,31270987,31271018,31271061,31272094,31272132,31272167,31272800,31272848,31273275,31273343,31273713,31273806,3127428', 'assoc_port': '31242910:31243126,31243162:31243375,31243439:31243574,31243650:31243858,31243813:31244074,31244062:31244342,31244106:31244444,31244599:31244896,31244681:31244846,31244960:31246302,31245215:31245724,31245501:31246197,31246228:31246535,31246229:31246574,31246600:31246780,31246601:31246816,31247019:31247150,31247268:31247826,31247464:31247640,31248198:31248213,31248199:31248253,31248417:31248640,31248622:31248802,31248896:31249029,31249111:31249192,31249313:31249459,31250362:31250763,31250518:31250875,31250839:31251071,31251013:31251231,31251336:31251444,31251512:31251736,31251723:31251955,31252016:31252429,31252414:31252697,31253053:31253220,31253054:31253305,31253295:31253435,31253465:31253616,31253701:31253831,31253867:31254008,31254119:31254256,31254120:31254177,31254974:31255131,31254975:31255223,31255216:31255513,31255503:31255810,31255889:31256156,31255890:31256185,31256181:31256350,31256472:31256773,31256763:31256973,31257011:31257312,31257012:31257392,31257337:31257601,31257626:31257772,31258287:3125895', 'assoc_mat': '31242910:metal:4230:31243126,31243162:metal:4230:31243375,31243439:metal:4230:31243574,31243650:metal:4230:31243858,31243813:metal:4230:31244074,31244062:metal:4230:31244342,31244106:metal:4230:31244444,31244599:metal:4230:31244896,31244681:metal:4230:31244846,31244960:metal:4230:31246302,31245215:metal:4230:31245724,31245501:metal:4230:31246197,31246228:metal:4230:31246535,31246229:metal:4230:31246574,31246600:metal:4230:31246780,31246601:metal:4230:31246816,31247019:metal:4230:31247150,31247268:metal:4230:31247826,31247464:metal:4230:31247640,31248198:metal:4230:31248213,31248199:metal:4230:31248253,31248417:metal:4230:31248640,31248622:metal:4230:31248802,31248896:metal:4230:31249029,31249111:metal:4230:31249192,31249313:metal:4230:31249459,31250362:metal:4230:31250763,31250518:metal:4230:31250875,31250839:metal:4230:31251071,31251013:metal:4230:31251231,31251336:metal:4230:31251444,31251512:metal:4230:31251736,31251723:metal:4230:31251955,31252016:metal:4230:31252429,31252414:metal:4230:31252697,31253053:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2484649980590342, 'nb_photo': 232473, 'list_port_cont': '31243135,31243372,31243586,31243864,31244077,31244348,31244450,31244857,31244888,31245716,31246065,31246194,31246313,31246536,31246578,31246775,31246817,31247154,31247648,31247684,31247821,31248227,31248261,31248642,31248798,31249041,31249194,31249420,31249457,31250329,31250771,31250863,31251070,31251236,31251441,31251733,31251941,31252428,31252629,31252709,31253215,31253309,31253439,31253620,31253843,31254006,31254190,31254251,31255138,31255237,31255521,31255807,31256155,31256195,31256364,31256781,31256985,31257315,31257395,31257602,31257780,31257862,31258654,31258947,31259195,31259616,31260152,31260298,31260436,31260657,31260891,31260932,31261194,31261619,31261947,31262257,31262576,31262860,31262936,31263219,31263257,31263532,31264333,31264371,31264870,31265174,31265951,31266030,31266265,31266543,31266589,31267153,31267195,31267553,31267732,31268166,31268217,31268457,31268591,31268929,31268984,31269539,31269579,31269619,31269659,31269922,31269965,31270043,31270575,31270701,31270992,31271024,31271071,3127210', 'assoc_port': '31242910:31243135,31243162:31243372,31243439:31243586,31243650:31243864,31243813:31244077,31244062:31244348,31244106:31244450,31244599:31244888,31244681:31244857,31244960:31246313,31245215:31245716,31245500:31246065,31245501:31246194,31246228:31246536,31246229:31246578,31246600:31246775,31246601:31246817,31247019:31247154,31247268:31247821,31247464:31247648,31247465:31247684,31248198:31248227,31248199:31248261,31248417:31248642,31248622:31248798,31248896:31249041,31249111:31249194,31249313:31249457,31249314:31249420,31250149:31250329,31250362:31250771,31250518:31250863,31250839:31251070,31251013:31251236,31251336:31251441,31251512:31251733,31251723:31251941,31252016:31252428,31252414:31252709,31252415:31252629,31253053:31253215,31253054:31253309,31253295:31253439,31253465:31253620,31253701:31253843,31253867:31254006,31254119:31254251,31254120:31254190,31254974:31255138,31254975:31255237,31255216:31255521,31255503:31255807,31255889:31256155,31255890:31256195,31256181:31256364,31256472:31256781,31256763:3125698', 'assoc_mat': '31242910:papier:4230:31243135,31243162:papier:4230:31243372,31243439:papier:4230:31243586,31243650:papier:4230:31243864,31243813:papier:4230:31244077,31244062:papier:4230:31244348,31244106:papier:4230:31244450,31244599:papier:4230:31244888,31244681:papier:4230:31244857,31244960:papier:4230:31246313,31245215:papier:4230:31245716,31245500:papier:4230:31246065,31245501:papier:4230:31246194,31246228:papier:4230:31246536,31246229:papier:4230:31246578,31246600:papier:4230:31246775,31246601:papier:4230:31246817,31247019:papier:4230:31247154,31247268:papier:4230:31247821,31247464:papier:4230:31247648,31247465:papier:4230:31247684,31248198:papier:4230:31248227,31248199:papier:4230:31248261,31248417:papier:4230:31248642,31248622:papier:4230:31248798,31248896:papier:4230:31249041,31249111:papier:4230:31249194,31249313:papier:4230:31249457,31249314:papier:4230:31249420,31250149:papier:4230:31250329,31250362:papier:4230:31250771,31250518:papier:4230:31250863,31250839:papier:4230:31251070,31251013:papier:4230:31251236,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005452743921995672, 'nb_photo': 2190, 'list_port_cont': '31243134,31243384,31243577,31243871,31244071,31244343,31244451,31244858,31244897,31245727,31246069,31246206,31246308,31246525,31246571,31246778,31246821,31247161,31247643,31247690,31247825,31248230,31248269,31248631,31248814,31249035,31249191,31249416,31249463,31250772,31250869,31251072,31251228,31251451,31251734,31251950,31252432,31252630,31252706,31253224,31253312,31253433,31253623,31253845,31254002,31254184,31254264,31255142,31255229,31255514,31255795,31256154,31256199,31256363,31256778,31256984,31257314,31257398,31257606,31257779,31258650,31258949,31259199,31260154,31260305,31260435,31260650,31260899,31260931,31261188,31261632,31261948,31262259,31262582,31262857,31262924,31263216,31263259,31263520,31264373,31264875,31265956,31266035,31266264,31266580,31267155,31267200,31267552,31267734,31268167,31268212,31268453,31268585,31268941,31268982,31269567,31269614,31269652,31269914,31269966,31270035,31270573,31271030,31271067,31272106,31272131,31272173,31272801,31272834,31273271,31273333,31273722,31273807,3127433', 'assoc_port': '31242910:31243134,31243162:31243384,31243439:31243577,31243650:31243871,31243813:31244071,31244062:31244343,31244106:31244451,31244599:31244897,31244681:31244858,31244960:31246308,31245215:31245727,31245500:31246069,31245501:31246206,31246228:31246525,31246229:31246571,31246600:31246778,31246601:31246821,31247019:31247161,31247268:31247825,31247464:31247643,31247465:31247690,31248198:31248230,31248199:31248269,31248417:31248631,31248622:31248814,31248896:31249035,31249111:31249191,31249313:31249463,31249314:31249416,31250362:31250772,31250518:31250869,31250839:31251072,31251013:31251228,31251336:31251451,31251512:31251734,31251723:31251950,31252016:31252432,31252414:31252706,31252415:31252630,31253053:31253224,31253054:31253312,31253295:31253433,31253465:31253623,31253701:31253845,31253867:31254002,31254119:31254264,31254120:31254184,31254974:31255142,31254975:31255229,31255216:31255514,31255503:31255795,31255889:31256154,31255890:31256199,31256181:31256363,31256472:31256778,31256763:31256984,31257011:3125731', 'assoc_mat': '31242910:pehd:4230:31243134,31243162:pehd:4230:31243384,31243439:pehd:4230:31243577,31243650:pehd:4230:31243871,31243813:pehd:4230:31244071,31244062:pehd:4230:31244343,31244106:pehd:4230:31244451,31244599:pehd:4230:31244897,31244681:pehd:4230:31244858,31244960:pehd:4230:31246308,31245215:pehd:4230:31245727,31245500:pehd:4230:31246069,31245501:pehd:4230:31246206,31246228:pehd:4230:31246525,31246229:pehd:4230:31246571,31246600:pehd:4230:31246778,31246601:pehd:4230:31246821,31247019:pehd:4230:31247161,31247268:pehd:4230:31247825,31247464:pehd:4230:31247643,31247465:pehd:4230:31247690,31248198:pehd:4230:31248230,31248199:pehd:4230:31248269,31248417:pehd:4230:31248631,31248622:pehd:4230:31248814,31248896:pehd:4230:31249035,31249111:pehd:4230:31249191,31249313:pehd:4230:31249463,31249314:pehd:4230:31249416,31250362:pehd:4230:31250772,31250518:pehd:4230:31250869,31250839:pehd:4230:31251072,31251013:pehd:4230:31251228,31251336:pehd:4230:31251451,31251512:pehd:4230:31251734,31251723:pehd:4230:31251950,31252016:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012962910551459653, 'nb_photo': 15312, 'list_port_cont': '31243132,31243368,31243579,31243872,31244081,31244341,31244446,31244849,31244886,31245729,31246075,31246202,31246312,31246538,31246576,31246773,31246812,31247158,31247646,31247682,31247819,31248224,31248260,31248644,31248806,31249038,31249182,31249411,31249462,31250330,31250768,31250870,31251069,31251239,31251447,31251742,31251946,31252424,31252635,31252700,31253228,31253304,31253438,31253621,31253842,31254013,31254186,31254260,31255137,31255240,31255509,31255803,31256157,31256200,31256361,31256771,31256986,31257306,31257397,31257604,31257781,31257865,31258646,31258952,31259192,31259622,31260146,31260307,31260437,31260659,31260901,31260936,31261186,31261631,31261946,31262261,31262584,31262852,31262934,31263217,31263246,31263533,31264332,31264374,31264880,31265176,31265954,31266027,31266267,31266547,31266583,31267150,31267201,31267550,31267723,31268172,31268220,31268443,31268586,31268935,31268983,31269534,31269580,31269611,31269657,31269918,31269959,31270047,31270579,31270690,31270991,31271035,31271059,3127209', 'assoc_port': '31242910:31243132,31243162:31243368,31243439:31243579,31243650:31243872,31243813:31244081,31244062:31244341,31244106:31244446,31244599:31244886,31244681:31244849,31244960:31246312,31245215:31245729,31245500:31246075,31245501:31246202,31246228:31246538,31246229:31246576,31246600:31246773,31246601:31246812,31247019:31247158,31247268:31247819,31247464:31247646,31247465:31247682,31248198:31248224,31248199:31248260,31248417:31248644,31248622:31248806,31248896:31249038,31249111:31249182,31249313:31249462,31249314:31249411,31250149:31250330,31250362:31250768,31250518:31250870,31250839:31251069,31251013:31251239,31251336:31251447,31251512:31251742,31251723:31251946,31252016:31252424,31252414:31252700,31252415:31252635,31253053:31253228,31253054:31253304,31253295:31253438,31253465:31253621,31253701:31253842,31253867:31254013,31254119:31254260,31254120:31254186,31254974:31255137,31254975:31255240,31255216:31255509,31255503:31255803,31255889:31256157,31255890:31256200,31256181:31256361,31256472:31256771,31256763:3125698', 'assoc_mat': '31242910:pet_clair:4230:31243132,31243162:pet_clair:4230:31243368,31243439:pet_clair:4230:31243579,31243650:pet_clair:4230:31243872,31243813:pet_clair:4230:31244081,31244062:pet_clair:4230:31244341,31244106:pet_clair:4230:31244446,31244599:pet_clair:4230:31244886,31244681:pet_clair:4230:31244849,31244960:pet_clair:4230:31246312,31245215:pet_clair:4230:31245729,31245500:pet_clair:4230:31246075,31245501:pet_clair:4230:31246202,31246228:pet_clair:4230:31246538,31246229:pet_clair:4230:31246576,31246600:pet_clair:4230:31246773,31246601:pet_clair:4230:31246812,31247019:pet_clair:4230:31247158,31247268:pet_clair:4230:31247819,31247464:pet_clair:4230:31247646,31247465:pet_clair:4230:31247682,31248198:pet_clair:4230:31248224,31248199:pet_clair:4230:31248260,31248417:pet_clair:4230:31248644,31248622:pet_clair:4230:31248806,31248896:pet_clair:4230:31249038,31249111:pet_clair:4230:31249182,31249313:pet_clair:4230:31249462,31249314:pet_clair:4230:31249411,31250149:pet_clair:4230:31250330,31250362:pet_clair:4230:31250768,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002808715491316932, 'nb_photo': 738, 'list_port_cont': '31243130,31243383,31243590,31243867,31244078,31244338,31244448,31244847,31244895,31246073,31246207,31246314,31246540,31246772,31247818,31248225,31248258,31248636,31249039,31249187,31249467,31250328,31250776,31250868,31251065,31251240,31251435,31251738,31251954,31252712,31253222,31253306,31253428,31254010,31254262,31255236,31255511,31255804,31256152,31256197,31256355,31256783,31257313,31257404,31257767,31257852,31259614,31260155,31260303,31260432,31260663,31260933,31261191,31261621,31261954,31262264,31262581,31262858,31262927,31263220,31264372,31264881,31265952,31266036,31266548,31267147,31267192,31267554,31267730,31268161,31268219,31268582,31268931,31268970,31269577,31269960,31270033,31270699,31271032,31272101,31272138,31272179,31272798,31272845,31273340,31273724,31273809,31274272,31274395,31274435,31275110,31275571,31276290,31276670,31277449,31277532,31277929,31278003,31278142,31278553,31280165,31280259,31280626,31280841,31281156,31281497,31281791,31282005,31282303,31282862,31283190,31284477,31284584,3128484', 'assoc_port': '31242910:31243130,31243162:31243383,31243439:31243590,31243650:31243867,31243813:31244078,31244062:31244338,31244106:31244448,31244599:31244895,31244681:31244847,31244960:31246314,31245500:31246073,31245501:31246207,31246228:31246540,31246600:31246772,31247268:31247818,31248198:31248225,31248199:31248258,31248417:31248636,31248896:31249039,31249111:31249187,31249313:31249467,31250149:31250328,31250362:31250776,31250518:31250868,31250839:31251065,31251013:31251240,31251336:31251435,31251512:31251738,31251723:31251954,31252414:31252712,31253053:31253222,31253054:31253306,31253295:31253428,31253867:31254010,31254119:31254262,31254975:31255236,31255216:31255511,31255503:31255804,31255889:31256152,31255890:31256197,31256181:31256355,31256472:31256783,31257011:31257313,31257012:31257404,31257626:31257767,31257763:31257852,31259329:31259614,31259330:31260155,31259691:31260432,31260046:31260303,31260373:31260663,31260739:31260933,31260964:31261191,31261375:31261621,31261731:31261954,31262043:31262264,31262341:3126258', 'assoc_mat': '31242910:pet_fonce:4230:31243130,31243162:pet_fonce:4230:31243383,31243439:pet_fonce:4230:31243590,31243650:pet_fonce:4230:31243867,31243813:pet_fonce:4230:31244078,31244062:pet_fonce:4230:31244338,31244106:pet_fonce:4230:31244448,31244599:pet_fonce:4230:31244895,31244681:pet_fonce:4230:31244847,31244960:pet_fonce:4230:31246314,31245500:pet_fonce:4230:31246073,31245501:pet_fonce:4230:31246207,31246228:pet_fonce:4230:31246540,31246600:pet_fonce:4230:31246772,31247268:pet_fonce:4230:31247818,31248198:pet_fonce:4230:31248225,31248199:pet_fonce:4230:31248258,31248417:pet_fonce:4230:31248636,31248896:pet_fonce:4230:31249039,31249111:pet_fonce:4230:31249187,31249313:pet_fonce:4230:31249467,31250149:pet_fonce:4230:31250328,31250362:pet_fonce:4230:31250776,31250518:pet_fonce:4230:31250868,31250839:pet_fonce:4230:31251065,31251013:pet_fonce:4230:31251240,31251336:pet_fonce:4230:31251435,31251512:pet_fonce:4230:31251738,31251723:pet_fonce:4230:31251954,31252414:pet_fonce:4230:31252712,31253053:pet_fonce:4230:31253222,3'}), 'main_stat': {'nb_photos': 936}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31341221,31341222,31341223,31341224,31341225,31341226,31341227?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-10', 0.6589124892085263),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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': ((936,),), 'unwanted_material_monthly_percentage': ((0.6589124892085263,),), 'material_repartition': (('incineration', 935),), 'material_dict': {'incineration': 935}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 10, 1), 0.6611281632073951, 3), (datetime.date(2026, 10, 2), 0.6216015924708596, 3), (datetime.date(2026, 10, 3), 0.6381739355540377, 2), (datetime.date(2026, 10, 4), 0.7091015473374699, 2), (datetime.date(2026, 10, 5), 0.7225354153202342, 4), (datetime.date(2026, 10, 6), 0.6725320892761918, 2), (datetime.date(2026, 10, 7), 0.5934438798447818, 2), (datetime.date(2026, 10, 8), 0.6928960121305671, 3), (datetime.date(2026, 10, 9), 0.6788450581511413, 2), (datetime.date(2026, 10, 10), 0.6470368328785875, 2), (datetime.date(2026, 10, 11), 0.744652495141112, 2), (datetime.date(2026, 10, 12), 0.7248326821189933, 1), (datetime.date(2026, 10, 13), 0.6769813881216094, 2), (datetime.date(2026, 10, 14), 0.67516701805559, 1), (datetime.date(2026, 10, 15), 0.6139454478777748, 3), (datetime.date(2026, 10, 16), 0.5412363077960705, 2), (datetime.date(2026, 10, 17), 0.5807807609365668, 2), (datetime.date(2026, 10, 18), 0.64820911550743, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 10, 1), 0.6611281632073951, 3), (datetime.date(2026, 10, 2), 0.6216015924708596, 3), (datetime.date(2026, 10, 3), 0.6381739355540377, 2), (datetime.date(2026, 10, 4), 0.7091015473374699, 2), (datetime.date(2026, 10, 5), 0.7225354153202342, 4), (datetime.date(2026, 10, 6), 0.6725320892761918, 2), (datetime.date(2026, 10, 7), 0.5934438798447818, 2), (datetime.date(2026, 10, 8), 0.6928960121305671, 3), (datetime.date(2026, 10, 9), 0.6788450581511413, 2), (datetime.date(2026, 10, 10), 0.6470368328785875, 2), (datetime.date(2026, 10, 11), 0.744652495141112, 2), (datetime.date(2026, 10, 12), 0.7248326821189933, 1), (datetime.date(2026, 10, 13), 0.6769813881216094, 2), (datetime.date(2026, 10, 14), 0.67516701805559, 1), (datetime.date(2026, 10, 15), 0.6139454478777748, 3), (datetime.date(2026, 10, 16), 0.5412363077960705, 2), (datetime.date(2026, 10, 17), 0.5807807609365668, 2), (datetime.date(2026, 10, 18), 0.64820911550743, 1))}, 'quality_array': [['-8.10700638878741', '01102026'], ['-8.882288114688118', '02102026'], ['-8.912355317533049', '03102026'], ['-8.420920804235687', '04102026'], ['-8.492327713161314', '05102026'], ['-8.898542640641507', '06102026'], ['-9.091839910856283', '07102026'], ['-7.60591847657195', '08102026'], ['-8.614733327580714', '09102026'], ['-8.447225863979599', '10102026'], ['-8.562153322726031', '11102026'], ['-8.174491068449262', '12102026'], ['-8.748801196748932', '13102026'], ['-8.705040589737594', '14102026'], ['-8.530771407177268', '15102026'], ['-8.777525525911845', '16102026'], ['-8.85273540771212', '17102026'], ['-8.596386679363693', '18102026']], 'number_of_batch': ((380,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0173526584318021, 'nb_photo': 10829, 'list_port_cont': '31243125,31243382,31243589,31243860,31244064,31244347,31244439,31244852,31244883,31245721,31246074,31246196,31246309,31246526,31246564,31246770,31246807,31247147,31247635,31247685,31247829,31248219,31248256,31248638,31248805,31249031,31249193,31249424,31249466,31250332,31250770,31250876,31251055,31251230,31251449,31251730,31251945,31252427,31252636,31252704,31253221,31253308,31253431,31253606,31253834,31253997,31254188,31254261,31255133,31255232,31255508,31255811,31256143,31256201,31256353,31256775,31256977,31257301,31257394,31257603,31257775,31257861,31258644,31258937,31259186,31259615,31260150,31260302,31260422,31260662,31260888,31260930,31261181,31261629,31261940,31262263,31262585,31262847,31262920,31263211,31263247,31263529,31264328,31264358,31264882,31265169,31265949,31266037,31266252,31266541,31266588,31267148,31267188,31267542,31267727,31268156,31268208,31268452,31268587,31268936,31268979,31269523,31269578,31269612,31269656,31269923,31269967,31270034,31270574,31270697,31270994,31271020,31271066,3127209', 'assoc_port': '31242910:31243125,31243162:31243382,31243439:31243589,31243650:31243860,31243813:31244064,31244062:31244347,31244106:31244439,31244599:31244883,31244681:31244852,31244960:31246309,31245215:31245721,31245500:31246074,31245501:31246196,31246228:31246526,31246229:31246564,31246600:31246770,31246601:31246807,31247019:31247147,31247268:31247829,31247464:31247635,31247465:31247685,31248198:31248219,31248199:31248256,31248417:31248638,31248622:31248805,31248896:31249031,31249111:31249193,31249313:31249466,31249314:31249424,31250149:31250332,31250362:31250770,31250518:31250876,31250839:31251055,31251013:31251230,31251336:31251449,31251512:31251730,31251723:31251945,31252016:31252427,31252414:31252704,31252415:31252636,31253053:31253221,31253054:31253308,31253295:31253431,31253465:31253606,31253701:31253834,31253867:31253997,31254119:31254261,31254120:31254188,31254974:31255133,31254975:31255232,31255216:31255508,31255503:31255811,31255889:31256143,31255890:31256201,31256181:31256353,31256472:31256775,31256763:3125697', 'assoc_mat': '31242910:autre:4230:31243125,31243162:autre:4230:31243382,31243439:autre:4230:31243589,31243650:autre:4230:31243860,31243813:autre:4230:31244064,31244062:autre:4230:31244347,31244106:autre:4230:31244439,31244599:autre:4230:31244883,31244681:autre:4230:31244852,31244960:autre:4230:31246309,31245215:autre:4230:31245721,31245500:autre:4230:31246074,31245501:autre:4230:31246196,31246228:autre:4230:31246526,31246229:autre:4230:31246564,31246600:autre:4230:31246770,31246601:autre:4230:31246807,31247019:autre:4230:31247147,31247268:autre:4230:31247829,31247464:autre:4230:31247635,31247465:autre:4230:31247685,31248198:autre:4230:31248219,31248199:autre:4230:31248256,31248417:autre:4230:31248638,31248622:autre:4230:31248805,31248896:autre:4230:31249031,31249111:autre:4230:31249193,31249313:autre:4230:31249466,31249314:autre:4230:31249424,31250149:autre:4230:31250332,31250362:autre:4230:31250770,31250518:autre:4230:31250876,31250839:autre:4230:31251055,31251013:autre:4230:31251230,31251336:autre:4230:31251449,31251512:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07970912219520444, 'nb_photo': 75197, 'list_port_cont': '31243137,31243381,31243591,31243873,31244068,31244345,31244445,31244851,31244894,31245730,31246068,31246204,31246316,31246534,31246579,31246782,31246815,31247162,31247637,31247675,31247828,31248220,31248264,31248635,31248812,31249036,31249188,31249414,31249464,31250325,31250774,31250873,31251067,31251232,31251450,31251739,31251951,31252433,31252634,31252701,31253217,31253317,31253432,31253618,31253840,31254009,31254187,31254263,31255145,31255239,31255520,31255809,31256153,31256194,31256358,31256777,31256979,31257316,31257402,31257600,31257777,31257866,31258657,31258954,31259200,31259619,31260151,31260306,31260430,31260655,31260889,31260935,31261185,31261625,31261953,31262253,31262579,31262856,31262928,31263215,31263254,31263525,31264326,31264375,31264885,31265177,31265945,31266031,31266266,31266550,31266577,31267151,31267197,31267555,31267731,31268171,31268209,31268456,31268580,31268942,31268972,31269528,31269566,31269616,31269661,31269919,31269961,31270046,31270567,31270696,31270993,31271028,31271064,3127210', 'assoc_port': '31242910:31243137,31243162:31243381,31243439:31243591,31243650:31243873,31243813:31244068,31244062:31244345,31244106:31244445,31244599:31244894,31244681:31244851,31244960:31246316,31245215:31245730,31245500:31246068,31245501:31246204,31246228:31246534,31246229:31246579,31246600:31246782,31246601:31246815,31247019:31247162,31247268:31247828,31247464:31247637,31247465:31247675,31248198:31248220,31248199:31248264,31248417:31248635,31248622:31248812,31248896:31249036,31249111:31249188,31249313:31249464,31249314:31249414,31250149:31250325,31250362:31250774,31250518:31250873,31250839:31251067,31251013:31251232,31251336:31251450,31251512:31251739,31251723:31251951,31252016:31252433,31252414:31252701,31252415:31252634,31253053:31253217,31253054:31253317,31253295:31253432,31253465:31253618,31253701:31253840,31253867:31254009,31254119:31254263,31254120:31254187,31254974:31255145,31254975:31255239,31255216:31255520,31255503:31255809,31255889:31256153,31255890:31256194,31256181:31256358,31256472:31256777,31256763:3125697', 'assoc_mat': '31242910:carton:4230:31243137,31243162:carton:4230:31243381,31243439:carton:4230:31243591,31243650:carton:4230:31243873,31243813:carton:4230:31244068,31244062:carton:4230:31244345,31244106:carton:4230:31244445,31244599:carton:4230:31244894,31244681:carton:4230:31244851,31244960:carton:4230:31246316,31245215:carton:4230:31245730,31245500:carton:4230:31246068,31245501:carton:4230:31246204,31246228:carton:4230:31246534,31246229:carton:4230:31246579,31246600:carton:4230:31246782,31246601:carton:4230:31246815,31247019:carton:4230:31247162,31247268:carton:4230:31247828,31247464:carton:4230:31247637,31247465:carton:4230:31247675,31248198:carton:4230:31248220,31248199:carton:4230:31248264,31248417:carton:4230:31248635,31248622:carton:4230:31248812,31248896:carton:4230:31249036,31249111:carton:4230:31249188,31249313:carton:4230:31249464,31249314:carton:4230:31249414,31250149:carton:4230:31250325,31250362:carton:4230:31250774,31250518:carton:4230:31250873,31250839:carton:4230:31251067,31251013:carton:4230:31251232,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0019990466648498323, 'nb_photo': 1634, 'list_port_cont': '31243126,31243375,31243574,31243858,31244074,31244342,31244444,31244846,31244896,31245724,31246197,31246302,31246535,31246574,31246780,31246816,31247150,31247640,31247826,31248213,31248253,31248640,31248802,31249029,31249192,31249459,31250763,31250875,31251071,31251231,31251444,31251736,31251955,31252429,31252697,31253220,31253305,31253435,31253616,31253831,31254008,31254177,31254256,31255131,31255223,31255513,31255810,31256156,31256185,31256350,31256773,31256973,31257312,31257392,31257601,31257772,31258647,31258950,31259194,31259608,31260145,31260308,31260431,31260653,31260928,31261179,31261628,31261949,31262249,31262569,31262844,31262933,31263248,31263528,31264335,31264363,31264874,31265179,31265948,31266025,31266250,31266549,31266575,31267139,31267199,31267539,31267725,31268159,31268218,31268446,31268581,31268937,31268973,31269532,31269568,31269618,31269651,31269964,31270048,31270578,31270693,31270987,31271018,31271061,31272094,31272132,31272167,31272800,31272848,31273275,31273343,31273713,31273806,3127428', 'assoc_port': '31242910:31243126,31243162:31243375,31243439:31243574,31243650:31243858,31243813:31244074,31244062:31244342,31244106:31244444,31244599:31244896,31244681:31244846,31244960:31246302,31245215:31245724,31245501:31246197,31246228:31246535,31246229:31246574,31246600:31246780,31246601:31246816,31247019:31247150,31247268:31247826,31247464:31247640,31248198:31248213,31248199:31248253,31248417:31248640,31248622:31248802,31248896:31249029,31249111:31249192,31249313:31249459,31250362:31250763,31250518:31250875,31250839:31251071,31251013:31251231,31251336:31251444,31251512:31251736,31251723:31251955,31252016:31252429,31252414:31252697,31253053:31253220,31253054:31253305,31253295:31253435,31253465:31253616,31253701:31253831,31253867:31254008,31254119:31254256,31254120:31254177,31254974:31255131,31254975:31255223,31255216:31255513,31255503:31255810,31255889:31256156,31255890:31256185,31256181:31256350,31256472:31256773,31256763:31256973,31257011:31257312,31257012:31257392,31257337:31257601,31257626:31257772,31258287:3125895', 'assoc_mat': '31242910:metal:4230:31243126,31243162:metal:4230:31243375,31243439:metal:4230:31243574,31243650:metal:4230:31243858,31243813:metal:4230:31244074,31244062:metal:4230:31244342,31244106:metal:4230:31244444,31244599:metal:4230:31244896,31244681:metal:4230:31244846,31244960:metal:4230:31246302,31245215:metal:4230:31245724,31245501:metal:4230:31246197,31246228:metal:4230:31246535,31246229:metal:4230:31246574,31246600:metal:4230:31246780,31246601:metal:4230:31246816,31247019:metal:4230:31247150,31247268:metal:4230:31247826,31247464:metal:4230:31247640,31248198:metal:4230:31248213,31248199:metal:4230:31248253,31248417:metal:4230:31248640,31248622:metal:4230:31248802,31248896:metal:4230:31249029,31249111:metal:4230:31249192,31249313:metal:4230:31249459,31250362:metal:4230:31250763,31250518:metal:4230:31250875,31250839:metal:4230:31251071,31251013:metal:4230:31251231,31251336:metal:4230:31251444,31251512:metal:4230:31251736,31251723:metal:4230:31251955,31252016:metal:4230:31252429,31252414:metal:4230:31252697,31253053:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2484649980590342, 'nb_photo': 232473, 'list_port_cont': '31243135,31243372,31243586,31243864,31244077,31244348,31244450,31244857,31244888,31245716,31246065,31246194,31246313,31246536,31246578,31246775,31246817,31247154,31247648,31247684,31247821,31248227,31248261,31248642,31248798,31249041,31249194,31249420,31249457,31250329,31250771,31250863,31251070,31251236,31251441,31251733,31251941,31252428,31252629,31252709,31253215,31253309,31253439,31253620,31253843,31254006,31254190,31254251,31255138,31255237,31255521,31255807,31256155,31256195,31256364,31256781,31256985,31257315,31257395,31257602,31257780,31257862,31258654,31258947,31259195,31259616,31260152,31260298,31260436,31260657,31260891,31260932,31261194,31261619,31261947,31262257,31262576,31262860,31262936,31263219,31263257,31263532,31264333,31264371,31264870,31265174,31265951,31266030,31266265,31266543,31266589,31267153,31267195,31267553,31267732,31268166,31268217,31268457,31268591,31268929,31268984,31269539,31269579,31269619,31269659,31269922,31269965,31270043,31270575,31270701,31270992,31271024,31271071,3127210', 'assoc_port': '31242910:31243135,31243162:31243372,31243439:31243586,31243650:31243864,31243813:31244077,31244062:31244348,31244106:31244450,31244599:31244888,31244681:31244857,31244960:31246313,31245215:31245716,31245500:31246065,31245501:31246194,31246228:31246536,31246229:31246578,31246600:31246775,31246601:31246817,31247019:31247154,31247268:31247821,31247464:31247648,31247465:31247684,31248198:31248227,31248199:31248261,31248417:31248642,31248622:31248798,31248896:31249041,31249111:31249194,31249313:31249457,31249314:31249420,31250149:31250329,31250362:31250771,31250518:31250863,31250839:31251070,31251013:31251236,31251336:31251441,31251512:31251733,31251723:31251941,31252016:31252428,31252414:31252709,31252415:31252629,31253053:31253215,31253054:31253309,31253295:31253439,31253465:31253620,31253701:31253843,31253867:31254006,31254119:31254251,31254120:31254190,31254974:31255138,31254975:31255237,31255216:31255521,31255503:31255807,31255889:31256155,31255890:31256195,31256181:31256364,31256472:31256781,31256763:3125698', 'assoc_mat': '31242910:papier:4230:31243135,31243162:papier:4230:31243372,31243439:papier:4230:31243586,31243650:papier:4230:31243864,31243813:papier:4230:31244077,31244062:papier:4230:31244348,31244106:papier:4230:31244450,31244599:papier:4230:31244888,31244681:papier:4230:31244857,31244960:papier:4230:31246313,31245215:papier:4230:31245716,31245500:papier:4230:31246065,31245501:papier:4230:31246194,31246228:papier:4230:31246536,31246229:papier:4230:31246578,31246600:papier:4230:31246775,31246601:papier:4230:31246817,31247019:papier:4230:31247154,31247268:papier:4230:31247821,31247464:papier:4230:31247648,31247465:papier:4230:31247684,31248198:papier:4230:31248227,31248199:papier:4230:31248261,31248417:papier:4230:31248642,31248622:papier:4230:31248798,31248896:papier:4230:31249041,31249111:papier:4230:31249194,31249313:papier:4230:31249457,31249314:papier:4230:31249420,31250149:papier:4230:31250329,31250362:papier:4230:31250771,31250518:papier:4230:31250863,31250839:papier:4230:31251070,31251013:papier:4230:31251236,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005452743921995672, 'nb_photo': 2190, 'list_port_cont': '31243134,31243384,31243577,31243871,31244071,31244343,31244451,31244858,31244897,31245727,31246069,31246206,31246308,31246525,31246571,31246778,31246821,31247161,31247643,31247690,31247825,31248230,31248269,31248631,31248814,31249035,31249191,31249416,31249463,31250772,31250869,31251072,31251228,31251451,31251734,31251950,31252432,31252630,31252706,31253224,31253312,31253433,31253623,31253845,31254002,31254184,31254264,31255142,31255229,31255514,31255795,31256154,31256199,31256363,31256778,31256984,31257314,31257398,31257606,31257779,31258650,31258949,31259199,31260154,31260305,31260435,31260650,31260899,31260931,31261188,31261632,31261948,31262259,31262582,31262857,31262924,31263216,31263259,31263520,31264373,31264875,31265956,31266035,31266264,31266580,31267155,31267200,31267552,31267734,31268167,31268212,31268453,31268585,31268941,31268982,31269567,31269614,31269652,31269914,31269966,31270035,31270573,31271030,31271067,31272106,31272131,31272173,31272801,31272834,31273271,31273333,31273722,31273807,3127433', 'assoc_port': '31242910:31243134,31243162:31243384,31243439:31243577,31243650:31243871,31243813:31244071,31244062:31244343,31244106:31244451,31244599:31244897,31244681:31244858,31244960:31246308,31245215:31245727,31245500:31246069,31245501:31246206,31246228:31246525,31246229:31246571,31246600:31246778,31246601:31246821,31247019:31247161,31247268:31247825,31247464:31247643,31247465:31247690,31248198:31248230,31248199:31248269,31248417:31248631,31248622:31248814,31248896:31249035,31249111:31249191,31249313:31249463,31249314:31249416,31250362:31250772,31250518:31250869,31250839:31251072,31251013:31251228,31251336:31251451,31251512:31251734,31251723:31251950,31252016:31252432,31252414:31252706,31252415:31252630,31253053:31253224,31253054:31253312,31253295:31253433,31253465:31253623,31253701:31253845,31253867:31254002,31254119:31254264,31254120:31254184,31254974:31255142,31254975:31255229,31255216:31255514,31255503:31255795,31255889:31256154,31255890:31256199,31256181:31256363,31256472:31256778,31256763:31256984,31257011:3125731', 'assoc_mat': '31242910:pehd:4230:31243134,31243162:pehd:4230:31243384,31243439:pehd:4230:31243577,31243650:pehd:4230:31243871,31243813:pehd:4230:31244071,31244062:pehd:4230:31244343,31244106:pehd:4230:31244451,31244599:pehd:4230:31244897,31244681:pehd:4230:31244858,31244960:pehd:4230:31246308,31245215:pehd:4230:31245727,31245500:pehd:4230:31246069,31245501:pehd:4230:31246206,31246228:pehd:4230:31246525,31246229:pehd:4230:31246571,31246600:pehd:4230:31246778,31246601:pehd:4230:31246821,31247019:pehd:4230:31247161,31247268:pehd:4230:31247825,31247464:pehd:4230:31247643,31247465:pehd:4230:31247690,31248198:pehd:4230:31248230,31248199:pehd:4230:31248269,31248417:pehd:4230:31248631,31248622:pehd:4230:31248814,31248896:pehd:4230:31249035,31249111:pehd:4230:31249191,31249313:pehd:4230:31249463,31249314:pehd:4230:31249416,31250362:pehd:4230:31250772,31250518:pehd:4230:31250869,31250839:pehd:4230:31251072,31251013:pehd:4230:31251228,31251336:pehd:4230:31251451,31251512:pehd:4230:31251734,31251723:pehd:4230:31251950,31252016:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012962910551459653, 'nb_photo': 15312, 'list_port_cont': '31243132,31243368,31243579,31243872,31244081,31244341,31244446,31244849,31244886,31245729,31246075,31246202,31246312,31246538,31246576,31246773,31246812,31247158,31247646,31247682,31247819,31248224,31248260,31248644,31248806,31249038,31249182,31249411,31249462,31250330,31250768,31250870,31251069,31251239,31251447,31251742,31251946,31252424,31252635,31252700,31253228,31253304,31253438,31253621,31253842,31254013,31254186,31254260,31255137,31255240,31255509,31255803,31256157,31256200,31256361,31256771,31256986,31257306,31257397,31257604,31257781,31257865,31258646,31258952,31259192,31259622,31260146,31260307,31260437,31260659,31260901,31260936,31261186,31261631,31261946,31262261,31262584,31262852,31262934,31263217,31263246,31263533,31264332,31264374,31264880,31265176,31265954,31266027,31266267,31266547,31266583,31267150,31267201,31267550,31267723,31268172,31268220,31268443,31268586,31268935,31268983,31269534,31269580,31269611,31269657,31269918,31269959,31270047,31270579,31270690,31270991,31271035,31271059,3127209', 'assoc_port': '31242910:31243132,31243162:31243368,31243439:31243579,31243650:31243872,31243813:31244081,31244062:31244341,31244106:31244446,31244599:31244886,31244681:31244849,31244960:31246312,31245215:31245729,31245500:31246075,31245501:31246202,31246228:31246538,31246229:31246576,31246600:31246773,31246601:31246812,31247019:31247158,31247268:31247819,31247464:31247646,31247465:31247682,31248198:31248224,31248199:31248260,31248417:31248644,31248622:31248806,31248896:31249038,31249111:31249182,31249313:31249462,31249314:31249411,31250149:31250330,31250362:31250768,31250518:31250870,31250839:31251069,31251013:31251239,31251336:31251447,31251512:31251742,31251723:31251946,31252016:31252424,31252414:31252700,31252415:31252635,31253053:31253228,31253054:31253304,31253295:31253438,31253465:31253621,31253701:31253842,31253867:31254013,31254119:31254260,31254120:31254186,31254974:31255137,31254975:31255240,31255216:31255509,31255503:31255803,31255889:31256157,31255890:31256200,31256181:31256361,31256472:31256771,31256763:3125698', 'assoc_mat': '31242910:pet_clair:4230:31243132,31243162:pet_clair:4230:31243368,31243439:pet_clair:4230:31243579,31243650:pet_clair:4230:31243872,31243813:pet_clair:4230:31244081,31244062:pet_clair:4230:31244341,31244106:pet_clair:4230:31244446,31244599:pet_clair:4230:31244886,31244681:pet_clair:4230:31244849,31244960:pet_clair:4230:31246312,31245215:pet_clair:4230:31245729,31245500:pet_clair:4230:31246075,31245501:pet_clair:4230:31246202,31246228:pet_clair:4230:31246538,31246229:pet_clair:4230:31246576,31246600:pet_clair:4230:31246773,31246601:pet_clair:4230:31246812,31247019:pet_clair:4230:31247158,31247268:pet_clair:4230:31247819,31247464:pet_clair:4230:31247646,31247465:pet_clair:4230:31247682,31248198:pet_clair:4230:31248224,31248199:pet_clair:4230:31248260,31248417:pet_clair:4230:31248644,31248622:pet_clair:4230:31248806,31248896:pet_clair:4230:31249038,31249111:pet_clair:4230:31249182,31249313:pet_clair:4230:31249462,31249314:pet_clair:4230:31249411,31250149:pet_clair:4230:31250330,31250362:pet_clair:4230:31250768,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002808715491316932, 'nb_photo': 738, 'list_port_cont': '31243130,31243383,31243590,31243867,31244078,31244338,31244448,31244847,31244895,31246073,31246207,31246314,31246540,31246772,31247818,31248225,31248258,31248636,31249039,31249187,31249467,31250328,31250776,31250868,31251065,31251240,31251435,31251738,31251954,31252712,31253222,31253306,31253428,31254010,31254262,31255236,31255511,31255804,31256152,31256197,31256355,31256783,31257313,31257404,31257767,31257852,31259614,31260155,31260303,31260432,31260663,31260933,31261191,31261621,31261954,31262264,31262581,31262858,31262927,31263220,31264372,31264881,31265952,31266036,31266548,31267147,31267192,31267554,31267730,31268161,31268219,31268582,31268931,31268970,31269577,31269960,31270033,31270699,31271032,31272101,31272138,31272179,31272798,31272845,31273340,31273724,31273809,31274272,31274395,31274435,31275110,31275571,31276290,31276670,31277449,31277532,31277929,31278003,31278142,31278553,31280165,31280259,31280626,31280841,31281156,31281497,31281791,31282005,31282303,31282862,31283190,31284477,31284584,3128484', 'assoc_port': '31242910:31243130,31243162:31243383,31243439:31243590,31243650:31243867,31243813:31244078,31244062:31244338,31244106:31244448,31244599:31244895,31244681:31244847,31244960:31246314,31245500:31246073,31245501:31246207,31246228:31246540,31246600:31246772,31247268:31247818,31248198:31248225,31248199:31248258,31248417:31248636,31248896:31249039,31249111:31249187,31249313:31249467,31250149:31250328,31250362:31250776,31250518:31250868,31250839:31251065,31251013:31251240,31251336:31251435,31251512:31251738,31251723:31251954,31252414:31252712,31253053:31253222,31253054:31253306,31253295:31253428,31253867:31254010,31254119:31254262,31254975:31255236,31255216:31255511,31255503:31255804,31255889:31256152,31255890:31256197,31256181:31256355,31256472:31256783,31257011:31257313,31257012:31257404,31257626:31257767,31257763:31257852,31259329:31259614,31259330:31260155,31259691:31260432,31260046:31260303,31260373:31260663,31260739:31260933,31260964:31261191,31261375:31261621,31261731:31261954,31262043:31262264,31262341:3126258', 'assoc_mat': '31242910:pet_fonce:4230:31243130,31243162:pet_fonce:4230:31243383,31243439:pet_fonce:4230:31243590,31243650:pet_fonce:4230:31243867,31243813:pet_fonce:4230:31244078,31244062:pet_fonce:4230:31244338,31244106:pet_fonce:4230:31244448,31244599:pet_fonce:4230:31244895,31244681:pet_fonce:4230:31244847,31244960:pet_fonce:4230:31246314,31245500:pet_fonce:4230:31246073,31245501:pet_fonce:4230:31246207,31246228:pet_fonce:4230:31246540,31246600:pet_fonce:4230:31246772,31247268:pet_fonce:4230:31247818,31248198:pet_fonce:4230:31248225,31248199:pet_fonce:4230:31248258,31248417:pet_fonce:4230:31248636,31248896:pet_fonce:4230:31249039,31249111:pet_fonce:4230:31249187,31249313:pet_fonce:4230:31249467,31250149:pet_fonce:4230:31250328,31250362:pet_fonce:4230:31250776,31250518:pet_fonce:4230:31250868,31250839:pet_fonce:4230:31251065,31251013:pet_fonce:4230:31251240,31251336:pet_fonce:4230:31251435,31251512:pet_fonce:4230:31251738,31251723:pet_fonce:4230:31251954,31252414:pet_fonce:4230:31252712,31253053:pet_fonce:4230:31253222,3'}), 'main_stat': {'nb_photos': 936}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31341221,31341222,31341223,31341224,31341225,31341226,31341227?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-10', 0.6589124892085263),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_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', '1.74%', 10829], 'carton': ['carton', '7.97%', 75197], 'metal': ['metal', '0.2%', 1634], 'papier': ['papier', '24.85%', 232473], 'pehd': ['pehd', '0.55%', 2190], 'pet_clair': ['pet_clair', '1.3%', 15312], 'pet_fonce': ['pet_fonce', '0.28%', 738]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_10_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.33user 2.80system 0:06.84elapsed 75%CPU (0avgtext+0avgdata 186908maxresident)k 8inputs+296outputs (2major+49481minor)pagefaults 0swaps