python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-01 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 01 mtr_id : dashboard_places : SCCU_cam6 date : 2026-01 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam6' and date like '%2026-01%') and created_at like '%2026-01%'))); nb_day : (3, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 202 and month(ded.date) = 01 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 202 and month(ded.date) = 01 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%012026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-01-01 : dt_date_just_month_year : 2026-01-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-01-01" AND ded.date <= "2026-01-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 (2835825,2842686,2847227,2847809,2853845,2860814,2867739,2872230,2873655,2874680,2875157,2876337,2877685,2879031,2880248,2881435,2882498,2883063,2884151,2885204,2885913,2886688,2887652,2888784,2888983) 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.0155145325877894, 'nb_photo': 13979, 'list_port_cont': '29872221,29872333,29872438,29872725,29872784,29872943,29873032,29873251,29873356,29873396,29873587,29873662,29873701,29873967,29874033,29874126,29874290,29874475,29874545,29874603,29874676,29910433,29910479,29910799,29911196,29911300,29911528,29911564,29911897,29911987,29912372,29912633,29912926,29913097,29913519,29913620,29914169,29914375,29914439,29914691,29914857,29915032,29915293,29915507,29935119,29935338,29935512,29935736,29935915,29936067,29936400,29936548,29936584,29936609,29936652,29936717,29936764,29936871,29936940,29937008,29937168,29937208,29937314,29937424,29937533,29937559,29937611,29937644,29941222,29941988,29942027,29942132,29942176,29942193,29942221,29942311,29942357,29942381,29942452,29942498,29942530,29942563,29942606,29942639,29942669,29942712,29942744,29942794,29942910,29943004,29943191,29976429,29976592,29976673,29976832,29977054,29977251,29977497,29977680,29977828,29978164,29978239,29978410,29978621,29978671,29978920,29978966,29978991,29979116,29979144,29979191,29979215,29979362,2997988', 'assoc_port': '29872022:29872333,29872023:29872221,29872025:29872438,29872027:29872725,29872029:29872784,29872031:29872943,29872033:29873032,29872035:29873251,29872038:29873396,29872040:29873356,29872044:29873587,29872047:29873701,29872050:29874676,29872053:29873967,29872054:29874033,29872058:29874126,29872062:29874290,29872065:29874545,29872067:29874475,29873348:29873662,29874582:29874603,29909976:29910433,29909979:29910799,29909992:29911196,29909994:29911300,29910007:29911564,29910009:29911528,29910010:29911897,29910012:29911987,29910013:29912372,29910015:29912633,29910016:29912926,29910019:29913097,29910022:29913620,29910024:29913519,29910027:29914169,29910031:29914375,29910035:29914439,29910039:29914691,29910043:29910479,29910046:29914857,29910051:29915032,29910055:29915293,29910072:29915507,29934937:29935119,29934939:29935338,29934941:29935512,29934943:29935736,29934947:29937644,29934950:29935915,29934953:29936067,29934956:29936609,29934958:29936764,29934961:29936871,29934964:29936940,29934966:29937208,29934968:2993761', 'assoc_mat': '29872022:autre:4230:29872333,29872023:autre:4230:29872221,29872025:autre:4230:29872438,29872027:autre:4230:29872725,29872029:autre:4230:29872784,29872031:autre:4230:29872943,29872033:autre:4230:29873032,29872035:autre:4230:29873251,29872038:autre:4230:29873396,29872040:autre:4230:29873356,29872044:autre:4230:29873587,29872047:autre:4230:29873701,29872050:autre:4230:29874676,29872053:autre:4230:29873967,29872054:autre:4230:29874033,29872058:autre:4230:29874126,29872062:autre:4230:29874290,29872065:autre:4230:29874545,29872067:autre:4230:29874475,29873348:autre:4230:29873662,29874582:autre:4230:29874603,29909976:autre:4230:29910433,29909979:autre:4230:29910799,29909992:autre:4230:29911196,29909994:autre:4230:29911300,29910007:autre:4230:29911564,29910009:autre:4230:29911528,29910010:autre:4230:29911897,29910012:autre:4230:29911987,29910013:autre:4230:29912372,29910015:autre:4230:29912633,29910016:autre:4230:29912926,29910019:autre:4230:29913097,29910022:autre:4230:29913620,29910024:autre:4230:29913519,29910027:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.045471572710061824, 'nb_photo': 59657, 'list_port_cont': '29872225,29872330,29872442,29872720,29872792,29872954,29873020,29873243,29873368,29873402,29873591,29873656,29873695,29873982,29874030,29874123,29874307,29874489,29874549,29874602,29874689,29910427,29910508,29910809,29911202,29911305,29911534,29911568,29911898,29911988,29912362,29912628,29912943,29913095,29913523,29913625,29914173,29914382,29914433,29914688,29914856,29915045,29915298,29915498,29935125,29935329,29935527,29935742,29935924,29936070,29936396,29936539,29936580,29936619,29936654,29936707,29936756,29936875,29936939,29937023,29937169,29937204,29937316,29937423,29937538,29937574,29937609,29937642,29941229,29941992,29942020,29942133,29942168,29942192,29942220,29942315,29942349,29942386,29942453,29942497,29942538,29942573,29942608,29942646,29942681,29942709,29942754,29942802,29942908,29943007,29943190,29976432,29976584,29976666,29976833,29977063,29977257,29977503,29977679,29977834,29978163,29978247,29978418,29978620,29978682,29978928,29978965,29979001,29979115,29979142,29979189,29979226,29979374,2997988', 'assoc_port': '29872022:29872330,29872023:29872225,29872025:29872442,29872027:29872720,29872029:29872792,29872031:29872954,29872033:29873020,29872035:29873243,29872038:29873402,29872040:29873368,29872044:29873591,29872047:29873695,29872050:29874689,29872053:29873982,29872054:29874030,29872058:29874123,29872062:29874307,29872065:29874549,29872067:29874489,29873348:29873656,29874582:29874602,29909976:29910427,29909979:29910809,29909992:29911202,29909994:29911305,29910007:29911568,29910009:29911534,29910010:29911898,29910012:29911988,29910013:29912362,29910015:29912628,29910016:29912943,29910019:29913095,29910022:29913625,29910024:29913523,29910027:29914173,29910031:29914382,29910035:29914433,29910039:29914688,29910043:29910508,29910046:29914856,29910051:29915045,29910055:29915298,29910072:29915498,29934937:29935125,29934939:29935329,29934941:29935527,29934943:29935742,29934947:29937642,29934950:29935924,29934953:29936070,29934956:29936619,29934958:29936756,29934961:29936875,29934964:29936939,29934966:29937204,29934968:2993760', 'assoc_mat': '29872022:carton:4230:29872330,29872023:carton:4230:29872225,29872025:carton:4230:29872442,29872027:carton:4230:29872720,29872029:carton:4230:29872792,29872031:carton:4230:29872954,29872033:carton:4230:29873020,29872035:carton:4230:29873243,29872038:carton:4230:29873402,29872040:carton:4230:29873368,29872044:carton:4230:29873591,29872047:carton:4230:29873695,29872050:carton:4230:29874689,29872053:carton:4230:29873982,29872054:carton:4230:29874030,29872058:carton:4230:29874123,29872062:carton:4230:29874307,29872065:carton:4230:29874549,29872067:carton:4230:29874489,29873348:carton:4230:29873656,29874582:carton:4230:29874602,29909976:carton:4230:29910427,29909979:carton:4230:29910809,29909992:carton:4230:29911202,29909994:carton:4230:29911305,29910007:carton:4230:29911568,29910009:carton:4230:29911534,29910010:carton:4230:29911898,29910012:carton:4230:29911988,29910013:carton:4230:29912362,29910015:carton:4230:29912628,29910016:carton:4230:29912943,29910019:carton:4230:29913095,29910022:carton:4230:29913625,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014653717255396924, 'nb_photo': 1212, 'list_port_cont': '29872319,29872443,29872723,29872797,29872952,29873025,29873250,29873353,29873397,29873579,29873650,29873980,29874031,29874124,29874478,29874609,29874680,29910504,29910816,29911199,29911311,29911555,29911888,29911981,29912373,29912634,29912942,29913090,29913517,29913611,29914179,29914373,29914423,29914858,29915034,29915305,29935115,29935336,29935519,29935743,29935916,29936397,29936550,29936613,29936757,29936866,29936950,29937015,29937158,29937191,29937304,29937408,29937534,29937558,29937599,29937647,29942022,29942136,29942351,29942392,29942500,29942567,29942595,29942714,29942753,29942899,29943200,29976420,29976589,29976672,29976844,29977056,29977490,29977682,29977823,29978148,29978254,29978412,29978672,29978927,29978964,29979153,29979182,29979223,29979963,29980658,29981121,29981321,29982081,29982954,29984093,29984240,29985929,29989767,29991741,29993581,29999252,30031435,30031830,30031845,30032070,30032201,30032308,30032421,30032921,30032961,30033024,30033146,30033345,30033609,30033829,30034051,30034127,3003436', 'assoc_port': '29872022:29872319,29872025:29872443,29872027:29872723,29872029:29872797,29872031:29872952,29872033:29873025,29872035:29873250,29872038:29873397,29872040:29873353,29872044:29873579,29872050:29874680,29872053:29873980,29872054:29874031,29872058:29874124,29872067:29874478,29873348:29873650,29874582:29874609,29909979:29910816,29909992:29911199,29909994:29911311,29910007:29911555,29910010:29911888,29910012:29911981,29910013:29912373,29910015:29912634,29910016:29912942,29910019:29913090,29910022:29913611,29910024:29913517,29910027:29914179,29910031:29914373,29910035:29914423,29910043:29910504,29910046:29914858,29910051:29915034,29910055:29915305,29934937:29935115,29934939:29935336,29934941:29935519,29934943:29935743,29934947:29937647,29934950:29935916,29934956:29936613,29934958:29936757,29934961:29936866,29934964:29936950,29934966:29937191,29934968:29937599,29934970:29937558,29934972:29937408,29934974:29937534,29934976:29937304,29934978:29937015,29934983:29936550,29934990:29936397,29936858:29937158,29941169:2994289', 'assoc_mat': '29872022:metal:4230:29872319,29872025:metal:4230:29872443,29872027:metal:4230:29872723,29872029:metal:4230:29872797,29872031:metal:4230:29872952,29872033:metal:4230:29873025,29872035:metal:4230:29873250,29872038:metal:4230:29873397,29872040:metal:4230:29873353,29872044:metal:4230:29873579,29872050:metal:4230:29874680,29872053:metal:4230:29873980,29872054:metal:4230:29874031,29872058:metal:4230:29874124,29872067:metal:4230:29874478,29873348:metal:4230:29873650,29874582:metal:4230:29874609,29909979:metal:4230:29910816,29909992:metal:4230:29911199,29909994:metal:4230:29911311,29910007:metal:4230:29911555,29910010:metal:4230:29911888,29910012:metal:4230:29911981,29910013:metal:4230:29912373,29910015:metal:4230:29912634,29910016:metal:4230:29912942,29910019:metal:4230:29913090,29910022:metal:4230:29913611,29910024:metal:4230:29913517,29910027:metal:4230:29914179,29910031:metal:4230:29914373,29910035:metal:4230:29914423,29910043:metal:4230:29910504,29910046:metal:4230:29914858,29910051:metal:4230:29915034,29910055:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1979962975392382, 'nb_photo': 313537, 'list_port_cont': '29872222,29872328,29872451,29872717,29872798,29872942,29873027,29873247,29873369,29873399,29873594,29873663,29873700,29873974,29874032,29874119,29874306,29874482,29874543,29874596,29874690,29910424,29910500,29910814,29911204,29911310,29911529,29911570,29911889,29911989,29912374,29912625,29912934,29913092,29913514,29913619,29914176,29914385,29914436,29914683,29914861,29915047,29915302,29915504,29935112,29935344,29935521,29935738,29935914,29936071,29936390,29936547,29936582,29936622,29936645,29936702,29936767,29936877,29936944,29937020,29937170,29937206,29937313,29937421,29937524,29937573,29937604,29937641,29941232,29941997,29942024,29942139,29942172,29942195,29942229,29942313,29942353,29942390,29942464,29942502,29942535,29942568,29942600,29942637,29942679,29942719,29942755,29942803,29942907,29943015,29943192,29976436,29976591,29976676,29976834,29977058,29977258,29977491,29977690,29977832,29978160,29978251,29978413,29978609,29978683,29978922,29978962,29978999,29979111,29979150,29979180,29979224,29979373,2997988', 'assoc_port': '29872022:29872328,29872023:29872222,29872025:29872451,29872027:29872717,29872029:29872798,29872031:29872942,29872033:29873027,29872035:29873247,29872038:29873399,29872040:29873369,29872044:29873594,29872047:29873700,29872050:29874690,29872053:29873974,29872054:29874032,29872058:29874119,29872062:29874306,29872065:29874543,29872067:29874482,29873348:29873663,29874582:29874596,29909976:29910424,29909979:29910814,29909992:29911204,29909994:29911310,29910007:29911570,29910009:29911529,29910010:29911889,29910012:29911989,29910013:29912374,29910015:29912625,29910016:29912934,29910019:29913092,29910022:29913619,29910024:29913514,29910027:29914176,29910031:29914385,29910035:29914436,29910039:29914683,29910043:29910500,29910046:29914861,29910051:29915047,29910055:29915302,29910072:29915504,29934937:29935112,29934939:29935344,29934941:29935521,29934943:29935738,29934947:29937641,29934950:29935914,29934953:29936071,29934956:29936622,29934958:29936767,29934961:29936877,29934964:29936944,29934966:29937206,29934968:2993760', 'assoc_mat': '29872022:papier:4230:29872328,29872023:papier:4230:29872222,29872025:papier:4230:29872451,29872027:papier:4230:29872717,29872029:papier:4230:29872798,29872031:papier:4230:29872942,29872033:papier:4230:29873027,29872035:papier:4230:29873247,29872038:papier:4230:29873399,29872040:papier:4230:29873369,29872044:papier:4230:29873594,29872047:papier:4230:29873700,29872050:papier:4230:29874690,29872053:papier:4230:29873974,29872054:papier:4230:29874032,29872058:papier:4230:29874119,29872062:papier:4230:29874306,29872065:papier:4230:29874543,29872067:papier:4230:29874482,29873348:papier:4230:29873663,29874582:papier:4230:29874596,29909976:papier:4230:29910424,29909979:papier:4230:29910814,29909992:papier:4230:29911204,29909994:papier:4230:29911310,29910007:papier:4230:29911570,29910009:papier:4230:29911529,29910010:papier:4230:29911889,29910012:papier:4230:29911989,29910013:papier:4230:29912374,29910015:papier:4230:29912625,29910016:papier:4230:29912934,29910019:papier:4230:29913092,29910022:papier:4230:29913619,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0034348385785937185, 'nb_photo': 1571, 'list_port_cont': '29872224,29872336,29872455,29872714,29872793,29872946,29873023,29873252,29873390,29873592,29873660,29873979,29874488,29874604,29874684,29910430,29910490,29910815,29911195,29911308,29911533,29911563,29911895,29911980,29912370,29912630,29912937,29913099,29913518,29913628,29914166,29914379,29914685,29915049,29915306,29915510,29935121,29935520,29935740,29935923,29936075,29936544,29936608,29936758,29936872,29936938,29937022,29937202,29937306,29937413,29937530,29937572,29937608,29937646,29941231,29942501,29942561,29942633,29942675,29942715,29942751,29943008,29943199,29976434,29976581,29976845,29977496,29977685,29977839,29978152,29978242,29978406,29978614,29978932,29978968,29979107,29979154,29979186,29979214,29979884,29979977,29980076,29980945,29981318,29981662,29982969,29984256,29985927,29997260,29999249,30031449,30031838,30032075,30032216,30032305,30032420,30032812,30032930,30032957,30033032,30033143,30033616,30033830,30034067,30034368,30038111,30061048,30061156,30061291,30061485,30061727,30061775,30061953,3006201', 'assoc_port': '29872022:29872336,29872023:29872224,29872025:29872455,29872027:29872714,29872029:29872793,29872031:29872946,29872033:29873023,29872035:29873252,29872038:29873390,29872044:29873592,29872050:29874684,29872053:29873979,29872067:29874488,29873348:29873660,29874582:29874604,29909976:29910430,29909979:29910815,29909992:29911195,29909994:29911308,29910007:29911563,29910009:29911533,29910010:29911895,29910012:29911980,29910013:29912370,29910015:29912630,29910016:29912937,29910019:29913099,29910022:29913628,29910024:29913518,29910027:29914166,29910031:29914379,29910039:29914685,29910043:29910490,29910051:29915049,29910055:29915306,29910072:29915510,29934937:29935121,29934941:29935520,29934943:29935740,29934947:29937646,29934950:29935923,29934953:29936075,29934956:29936608,29934958:29936758,29934961:29936872,29934964:29936938,29934966:29937202,29934968:29937608,29934970:29937572,29934972:29937413,29934974:29937530,29934976:29937306,29934978:29937022,29934983:29936544,29941170:29943199,29941173:29942561,29941174:2994275', 'assoc_mat': '29872022:pehd:4230:29872336,29872023:pehd:4230:29872224,29872025:pehd:4230:29872455,29872027:pehd:4230:29872714,29872029:pehd:4230:29872793,29872031:pehd:4230:29872946,29872033:pehd:4230:29873023,29872035:pehd:4230:29873252,29872038:pehd:4230:29873390,29872044:pehd:4230:29873592,29872050:pehd:4230:29874684,29872053:pehd:4230:29873979,29872067:pehd:4230:29874488,29873348:pehd:4230:29873660,29874582:pehd:4230:29874604,29909976:pehd:4230:29910430,29909979:pehd:4230:29910815,29909992:pehd:4230:29911195,29909994:pehd:4230:29911308,29910007:pehd:4230:29911563,29910009:pehd:4230:29911533,29910010:pehd:4230:29911895,29910012:pehd:4230:29911980,29910013:pehd:4230:29912370,29910015:pehd:4230:29912630,29910016:pehd:4230:29912937,29910019:pehd:4230:29913099,29910022:pehd:4230:29913628,29910024:pehd:4230:29913518,29910027:pehd:4230:29914166,29910031:pehd:4230:29914379,29910039:pehd:4230:29914685,29910043:pehd:4230:29910490,29910051:pehd:4230:29915049,29910055:pehd:4230:29915306,29910072:pehd:4230:29915510,29934937:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012799970637706012, 'nb_photo': 18134, 'list_port_cont': '29872216,29872334,29872450,29872713,29872796,29872953,29873019,29873253,29873361,29873395,29873596,29873658,29873687,29873973,29874028,29874120,29874302,29874480,29874553,29874608,29874693,29910431,29910486,29910808,29911201,29911307,29911525,29911569,29911899,29911990,29912369,29912632,29912940,29913087,29913524,29913627,29914178,29914383,29914431,29914694,29914864,29915048,29915308,29915502,29935122,29935334,29935526,29935741,29935913,29936059,29936392,29936538,29936578,29936620,29936656,29936719,29936766,29936876,29936943,29937024,29937161,29937203,29937317,29937425,29937537,29937568,29937605,29937635,29941227,29941993,29942031,29942131,29942178,29942190,29942237,29942319,29942356,29942388,29942458,29942488,29942528,29942572,29942605,29942642,29942682,29942711,29942749,29942804,29942912,29943012,29943195,29976437,29976590,29976678,29976837,29977061,29977263,29977504,29977688,29977838,29978157,29978253,29978404,29978612,29978680,29978929,29978958,29979003,29979114,29979147,29979181,29979221,29979372,2997989', 'assoc_port': '29872022:29872334,29872023:29872216,29872025:29872450,29872027:29872713,29872029:29872796,29872031:29872953,29872033:29873019,29872035:29873253,29872038:29873395,29872040:29873361,29872044:29873596,29872047:29873687,29872050:29874693,29872053:29873973,29872054:29874028,29872058:29874120,29872062:29874302,29872065:29874553,29872067:29874480,29873348:29873658,29874582:29874608,29909976:29910431,29909979:29910808,29909992:29911201,29909994:29911307,29910007:29911569,29910009:29911525,29910010:29911899,29910012:29911990,29910013:29912369,29910015:29912632,29910016:29912940,29910019:29913087,29910022:29913627,29910024:29913524,29910027:29914178,29910031:29914383,29910035:29914431,29910039:29914694,29910043:29910486,29910046:29914864,29910051:29915048,29910055:29915308,29910072:29915502,29934937:29935122,29934939:29935334,29934941:29935526,29934943:29935741,29934947:29937635,29934950:29935913,29934953:29936059,29934956:29936620,29934958:29936766,29934961:29936876,29934964:29936943,29934966:29937203,29934968:2993760', 'assoc_mat': '29872022:pet_clair:4230:29872334,29872023:pet_clair:4230:29872216,29872025:pet_clair:4230:29872450,29872027:pet_clair:4230:29872713,29872029:pet_clair:4230:29872796,29872031:pet_clair:4230:29872953,29872033:pet_clair:4230:29873019,29872035:pet_clair:4230:29873253,29872038:pet_clair:4230:29873395,29872040:pet_clair:4230:29873361,29872044:pet_clair:4230:29873596,29872047:pet_clair:4230:29873687,29872050:pet_clair:4230:29874693,29872053:pet_clair:4230:29873973,29872054:pet_clair:4230:29874028,29872058:pet_clair:4230:29874120,29872062:pet_clair:4230:29874302,29872065:pet_clair:4230:29874553,29872067:pet_clair:4230:29874480,29873348:pet_clair:4230:29873658,29874582:pet_clair:4230:29874608,29909976:pet_clair:4230:29910431,29909979:pet_clair:4230:29910808,29909992:pet_clair:4230:29911201,29909994:pet_clair:4230:29911307,29910007:pet_clair:4230:29911569,29910009:pet_clair:4230:29911525,29910010:pet_clair:4230:29911899,29910012:pet_clair:4230:29911990,29910013:pet_clair:4230:29912369,29910015:pet_clair:4230:29912632,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002538538585640803, 'nb_photo': 798, 'list_port_cont': '29872214,29872332,29872452,29872718,29873022,29873248,29873393,29873599,29873972,29874034,29874125,29874552,29910432,29910812,29911192,29911302,29911571,29911894,29912371,29912936,29913086,29913522,29913616,29914381,29914420,29914686,29915039,29935343,29935522,29935733,29935926,29936657,29936760,29936869,29937164,29937200,29937309,29937419,29937526,29937570,29937613,29942135,29942186,29942317,29942385,29942489,29942745,29942904,29943197,29976435,29977831,29978256,29978416,29978919,29978963,29979108,29979149,29979184,29979227,29979893,29980077,29980953,29981657,29982085,29982417,29982959,29984096,29984257,29987850,29989659,30031840,30031851,30032080,30032418,30032813,30032928,30032969,30033035,30033152,30033612,30034372,30038099,30061050,30061149,30061302,30061482,30062046,30062092,30062189,30062259,30062732,30062802,30062893,30063227,30065346,30065969,30067338,30067728,30068548,30069660,30070484,30070706,30071322,30071835,30072117,30072628,30072960,30073163,30073609,30074408,30074595,30080964,30080994,3008112', 'assoc_port': '29872022:29872332,29872023:29872214,29872025:29872452,29872027:29872718,29872033:29873022,29872035:29873248,29872038:29873393,29872044:29873599,29872053:29873972,29872054:29874034,29872058:29874125,29872065:29874552,29909976:29910432,29909979:29910812,29909992:29911192,29909994:29911302,29910007:29911571,29910010:29911894,29910013:29912371,29910016:29912936,29910019:29913086,29910022:29913616,29910024:29913522,29910031:29914381,29910035:29914420,29910039:29914686,29910051:29915039,29934939:29935343,29934941:29935522,29934943:29935733,29934950:29935926,29934958:29936760,29934961:29936869,29934966:29937200,29934968:29937613,29934970:29937570,29934972:29937419,29934974:29937526,29934976:29937309,29934987:29936657,29936858:29937164,29941169:29942904,29941170:29943197,29941171:29942135,29941174:29942745,29941190:29942489,29941195:29942385,29941197:29942317,29941209:29942186,29976349:29977831,29976352:29978256,29976357:29978416,29976364:29978963,29976366:29978919,29976368:29979184,29976372:29979227,29976375:2997643', 'assoc_mat': '29872022:pet_fonce:4230:29872332,29872023:pet_fonce:4230:29872214,29872025:pet_fonce:4230:29872452,29872027:pet_fonce:4230:29872718,29872033:pet_fonce:4230:29873022,29872035:pet_fonce:4230:29873248,29872038:pet_fonce:4230:29873393,29872044:pet_fonce:4230:29873599,29872053:pet_fonce:4230:29873972,29872054:pet_fonce:4230:29874034,29872058:pet_fonce:4230:29874125,29872065:pet_fonce:4230:29874552,29909976:pet_fonce:4230:29910432,29909979:pet_fonce:4230:29910812,29909992:pet_fonce:4230:29911192,29909994:pet_fonce:4230:29911302,29910007:pet_fonce:4230:29911571,29910010:pet_fonce:4230:29911894,29910013:pet_fonce:4230:29912371,29910016:pet_fonce:4230:29912936,29910019:pet_fonce:4230:29913086,29910022:pet_fonce:4230:29913616,29910024:pet_fonce:4230:29913522,29910031:pet_fonce:4230:29914381,29910035:pet_fonce:4230:29914420,29910039:pet_fonce:4230:29914686,29910051:pet_fonce:4230:29915039,29934939:pet_fonce:4230:29935343,29934941:pet_fonce:4230:29935522,29934943:pet_fonce:4230:29935733,29934950:pet_fonce:4230:29935926,2'}) 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(2835825,2842686,2847227,2847809,2853845,2860814,2867739,2872230,2873655,2874680,2875157,2876337,2877685,2879031,2880248,2881435,2882498,2883063,2884151,2885204,2885913,2886688,2887652,2888784,2888983)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148011, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872221,29872333,29872438,29872725,29872784,29872943,29873032,29873251,29873356,29873396,29873587,29873662,29873701,29873967,29874033,29874126,29874290,29874475,29874545,29874603,29874676,29910433,29910479,29910799,29911196,29911300,29911528,29911564,29911897,29911987,29912372,29912633,29912926,29913097,29913519,29913620,29914169,29914375,29914439,29914691,29914857,29915032,29915293,29915507,29935119,29935338,29935512,29935736,29935915,29936067,29936400,29936548,29936584,29936609,29936652,29936717,29936764,29936871,29936940,29937008,29937168,29937208,29937314,29937424,29937533,29937559,29937611,29937644,29941222,29941988,29942027,29942132,29942176,29942193,29942221,29942311,29942357,29942381,29942452,29942498,29942530,29942563,29942606,29942639,29942669,29942712,29942744,29942794,29942910,29943004,29943191,29976429,29976592,29976673,29976832,29977054,29977251,29977497,29977680,29977828,29978164,29978239,29978410,29978621,29978671,29978920,29978966,29978991,29979116,29979144,29979191,29979215,29979362,2997988 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148012, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872225,29872330,29872442,29872720,29872792,29872954,29873020,29873243,29873368,29873402,29873591,29873656,29873695,29873982,29874030,29874123,29874307,29874489,29874549,29874602,29874689,29910427,29910508,29910809,29911202,29911305,29911534,29911568,29911898,29911988,29912362,29912628,29912943,29913095,29913523,29913625,29914173,29914382,29914433,29914688,29914856,29915045,29915298,29915498,29935125,29935329,29935527,29935742,29935924,29936070,29936396,29936539,29936580,29936619,29936654,29936707,29936756,29936875,29936939,29937023,29937169,29937204,29937316,29937423,29937538,29937574,29937609,29937642,29941229,29941992,29942020,29942133,29942168,29942192,29942220,29942315,29942349,29942386,29942453,29942497,29942538,29942573,29942608,29942646,29942681,29942709,29942754,29942802,29942908,29943007,29943190,29976432,29976584,29976666,29976833,29977063,29977257,29977503,29977679,29977834,29978163,29978247,29978418,29978620,29978682,29978928,29978965,29979001,29979115,29979142,29979189,29979226,29979374,2997988 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148013, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872319,29872443,29872723,29872797,29872952,29873025,29873250,29873353,29873397,29873579,29873650,29873980,29874031,29874124,29874478,29874609,29874680,29910504,29910816,29911199,29911311,29911555,29911888,29911981,29912373,29912634,29912942,29913090,29913517,29913611,29914179,29914373,29914423,29914858,29915034,29915305,29935115,29935336,29935519,29935743,29935916,29936397,29936550,29936613,29936757,29936866,29936950,29937015,29937158,29937191,29937304,29937408,29937534,29937558,29937599,29937647,29942022,29942136,29942351,29942392,29942500,29942567,29942595,29942714,29942753,29942899,29943200,29976420,29976589,29976672,29976844,29977056,29977490,29977682,29977823,29978148,29978254,29978412,29978672,29978927,29978964,29979153,29979182,29979223,29979963,29980658,29981121,29981321,29982081,29982954,29984093,29984240,29985929,29989767,29991741,29993581,29999252,30031435,30031830,30031845,30032070,30032201,30032308,30032421,30032921,30032961,30033024,30033146,30033345,30033609,30033829,30034051,30034127,3003436 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148014, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872222,29872328,29872451,29872717,29872798,29872942,29873027,29873247,29873369,29873399,29873594,29873663,29873700,29873974,29874032,29874119,29874306,29874482,29874543,29874596,29874690,29910424,29910500,29910814,29911204,29911310,29911529,29911570,29911889,29911989,29912374,29912625,29912934,29913092,29913514,29913619,29914176,29914385,29914436,29914683,29914861,29915047,29915302,29915504,29935112,29935344,29935521,29935738,29935914,29936071,29936390,29936547,29936582,29936622,29936645,29936702,29936767,29936877,29936944,29937020,29937170,29937206,29937313,29937421,29937524,29937573,29937604,29937641,29941232,29941997,29942024,29942139,29942172,29942195,29942229,29942313,29942353,29942390,29942464,29942502,29942535,29942568,29942600,29942637,29942679,29942719,29942755,29942803,29942907,29943015,29943192,29976436,29976591,29976676,29976834,29977058,29977258,29977491,29977690,29977832,29978160,29978251,29978413,29978609,29978683,29978922,29978962,29978999,29979111,29979150,29979180,29979224,29979373,2997988 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148015, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872224,29872336,29872455,29872714,29872793,29872946,29873023,29873252,29873390,29873592,29873660,29873979,29874488,29874604,29874684,29910430,29910490,29910815,29911195,29911308,29911533,29911563,29911895,29911980,29912370,29912630,29912937,29913099,29913518,29913628,29914166,29914379,29914685,29915049,29915306,29915510,29935121,29935520,29935740,29935923,29936075,29936544,29936608,29936758,29936872,29936938,29937022,29937202,29937306,29937413,29937530,29937572,29937608,29937646,29941231,29942501,29942561,29942633,29942675,29942715,29942751,29943008,29943199,29976434,29976581,29976845,29977496,29977685,29977839,29978152,29978242,29978406,29978614,29978932,29978968,29979107,29979154,29979186,29979214,29979884,29979977,29980076,29980945,29981318,29981662,29982969,29984256,29985927,29997260,29999249,30031449,30031838,30032075,30032216,30032305,30032420,30032812,30032930,30032957,30033032,30033143,30033616,30033830,30034067,30034368,30038111,30061048,30061156,30061291,30061485,30061727,30061775,30061953,3006201 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148016, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872216,29872334,29872450,29872713,29872796,29872953,29873019,29873253,29873361,29873395,29873596,29873658,29873687,29873973,29874028,29874120,29874302,29874480,29874553,29874608,29874693,29910431,29910486,29910808,29911201,29911307,29911525,29911569,29911899,29911990,29912369,29912632,29912940,29913087,29913524,29913627,29914178,29914383,29914431,29914694,29914864,29915048,29915308,29915502,29935122,29935334,29935526,29935741,29935913,29936059,29936392,29936538,29936578,29936620,29936656,29936719,29936766,29936876,29936943,29937024,29937161,29937203,29937317,29937425,29937537,29937568,29937605,29937635,29941227,29941993,29942031,29942131,29942178,29942190,29942237,29942319,29942356,29942388,29942458,29942488,29942528,29942572,29942605,29942642,29942682,29942711,29942749,29942804,29942912,29943012,29943195,29976437,29976590,29976678,29976837,29977061,29977263,29977504,29977688,29977838,29978157,29978253,29978404,29978612,29978680,29978929,29978958,29979003,29979114,29979147,29979181,29979221,29979372,2997989 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148017, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872214,29872332,29872452,29872718,29873022,29873248,29873393,29873599,29873972,29874034,29874125,29874552,29910432,29910812,29911192,29911302,29911571,29911894,29912371,29912936,29913086,29913522,29913616,29914381,29914420,29914686,29915039,29935343,29935522,29935733,29935926,29936657,29936760,29936869,29937164,29937200,29937309,29937419,29937526,29937570,29937613,29942135,29942186,29942317,29942385,29942489,29942745,29942904,29943197,29976435,29977831,29978256,29978416,29978919,29978963,29979108,29979149,29979184,29979227,29979893,29980077,29980953,29981657,29982085,29982417,29982959,29984096,29984257,29987850,29989659,30031840,30031851,30032080,30032418,30032813,30032928,30032969,30033035,30033152,30033612,30034372,30038099,30061050,30061149,30061302,30061482,30062046,30062092,30062189,30062259,30062732,30062802,30062893,30063227,30065346,30065969,30067338,30067728,30068548,30069660,30070484,30070706,30071322,30071835,30072117,30072628,30072960,30073163,30073609,30074408,30074595,30080964,30080994,3008112 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30148011,30148012,30148013,30148014,30148015,30148016,30148017?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2026-01-01' and date <= '2026-01-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1323,),), 'unwanted_material_monthly_percentage': ((0.7452656576286569,),), 'material_repartition': (('incineration', 1321),), 'material_dict': {'incineration': 1321}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 1, 1), 0.7628683186257823, 3), (datetime.date(2026, 1, 2), 0.7783623583119667, 2), (datetime.date(2026, 1, 3), 0.729091206883599, 2), (datetime.date(2026, 1, 4), 0.8189399831895395, 3), (datetime.date(2026, 1, 5), 0.7904882107291961, 3), (datetime.date(2026, 1, 6), 0.8395475082123964, 2), (datetime.date(2026, 1, 7), 0.7386267470825515, 2), (datetime.date(2026, 1, 8), 0.7097128952319308, 2), (datetime.date(2026, 1, 9), 0.7231809849681471, 3), (datetime.date(2026, 1, 10), 0.7357777679596902, 1), (datetime.date(2026, 1, 11), 0.7882982756111476, 2), (datetime.date(2026, 1, 12), 0.8173380786933885, 3), (datetime.date(2026, 1, 13), 0.7571365992249394, 3), (datetime.date(2026, 1, 14), 0.749564362460003, 3), (datetime.date(2026, 1, 15), 0.7155117017716508, 2), (datetime.date(2026, 1, 16), 0.6888977430291897, 1), (datetime.date(2026, 1, 17), 0.6709783522592179, 1), (datetime.date(2026, 1, 18), 0.7595605128251637, 3), (datetime.date(2026, 1, 19), 0.7459409547898507, 1), (datetime.date(2026, 1, 20), 0.7260240184716925, 3), (datetime.date(2026, 1, 21), 0.7089098060442872, 4), (datetime.date(2026, 1, 22), 0.6795040111746038, 4), (datetime.date(2026, 1, 23), 0.7063906634859868, 2), (datetime.date(2026, 1, 24), 0.73549908202317, 1), (datetime.date(2026, 1, 25), 0.7998666989210884, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 1, 1), 0.7628683186257823, 3), (datetime.date(2026, 1, 2), 0.7783623583119667, 2), (datetime.date(2026, 1, 3), 0.729091206883599, 2), (datetime.date(2026, 1, 4), 0.8189399831895395, 3), (datetime.date(2026, 1, 5), 0.7904882107291961, 3), (datetime.date(2026, 1, 6), 0.8395475082123964, 2), (datetime.date(2026, 1, 7), 0.7386267470825515, 2), (datetime.date(2026, 1, 8), 0.7097128952319308, 2), (datetime.date(2026, 1, 9), 0.7231809849681471, 3), (datetime.date(2026, 1, 10), 0.7357777679596902, 1), (datetime.date(2026, 1, 11), 0.7882982756111476, 2), (datetime.date(2026, 1, 12), 0.8173380786933885, 3), (datetime.date(2026, 1, 13), 0.7571365992249394, 3), (datetime.date(2026, 1, 14), 0.749564362460003, 3), (datetime.date(2026, 1, 15), 0.7155117017716508, 2), (datetime.date(2026, 1, 16), 0.6888977430291897, 1), (datetime.date(2026, 1, 17), 0.6709783522592179, 1), (datetime.date(2026, 1, 18), 0.7595605128251637, 3), (datetime.date(2026, 1, 19), 0.7459409547898507, 1), (datetime.date(2026, 1, 20), 0.7260240184716925, 3), (datetime.date(2026, 1, 21), 0.7089098060442872, 4), (datetime.date(2026, 1, 22), 0.6795040111746038, 4), (datetime.date(2026, 1, 23), 0.7063906634859868, 2), (datetime.date(2026, 1, 24), 0.73549908202317, 1), (datetime.date(2026, 1, 25), 0.7998666989210884, 2))}, 'quality_array': [['-8.471475645173246', '01012026'], ['-7.485638106392712', '02012026'], ['-7.959657411537505', '03012026'], ['-7.813394815412816', '04012026'], ['-7.087615627924376', '05012026'], ['-7.063114630058014', '06012026'], ['-7.933873538653429', '07012026'], ['-8.109901422763794', '08012026'], ['-8.34846447635943', '09012026'], ['-8.208383548442965', '10012026'], ['-7.721711060614156', '11012026'], ['-7.555931334274779', '12012026'], ['-7.798723442954645', '13012026'], ['-8.162256005236166', '14012026'], ['-8.096379951371537', '15012026'], ['-8.12060234291741', '16012026'], ['-8.330049611579897', '17012026'], ['-7.986028228597271', '18012026'], ['-7.635710357991782', '19012026'], ['-7.9219879166899165', '20012026'], ['-8.141102939990596', '21012026'], ['-8.201219858557213', '22012026'], ['-8.49136959495617', '23012026'], ['-8.284741297184938', '24012026'], ['-8.065922524492784', '25012026']], 'number_of_batch': ((558,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0155145325877894, 'nb_photo': 13979, 'list_port_cont': '29872221,29872333,29872438,29872725,29872784,29872943,29873032,29873251,29873356,29873396,29873587,29873662,29873701,29873967,29874033,29874126,29874290,29874475,29874545,29874603,29874676,29910433,29910479,29910799,29911196,29911300,29911528,29911564,29911897,29911987,29912372,29912633,29912926,29913097,29913519,29913620,29914169,29914375,29914439,29914691,29914857,29915032,29915293,29915507,29935119,29935338,29935512,29935736,29935915,29936067,29936400,29936548,29936584,29936609,29936652,29936717,29936764,29936871,29936940,29937008,29937168,29937208,29937314,29937424,29937533,29937559,29937611,29937644,29941222,29941988,29942027,29942132,29942176,29942193,29942221,29942311,29942357,29942381,29942452,29942498,29942530,29942563,29942606,29942639,29942669,29942712,29942744,29942794,29942910,29943004,29943191,29976429,29976592,29976673,29976832,29977054,29977251,29977497,29977680,29977828,29978164,29978239,29978410,29978621,29978671,29978920,29978966,29978991,29979116,29979144,29979191,29979215,29979362,2997988', 'assoc_port': '29872022:29872333,29872023:29872221,29872025:29872438,29872027:29872725,29872029:29872784,29872031:29872943,29872033:29873032,29872035:29873251,29872038:29873396,29872040:29873356,29872044:29873587,29872047:29873701,29872050:29874676,29872053:29873967,29872054:29874033,29872058:29874126,29872062:29874290,29872065:29874545,29872067:29874475,29873348:29873662,29874582:29874603,29909976:29910433,29909979:29910799,29909992:29911196,29909994:29911300,29910007:29911564,29910009:29911528,29910010:29911897,29910012:29911987,29910013:29912372,29910015:29912633,29910016:29912926,29910019:29913097,29910022:29913620,29910024:29913519,29910027:29914169,29910031:29914375,29910035:29914439,29910039:29914691,29910043:29910479,29910046:29914857,29910051:29915032,29910055:29915293,29910072:29915507,29934937:29935119,29934939:29935338,29934941:29935512,29934943:29935736,29934947:29937644,29934950:29935915,29934953:29936067,29934956:29936609,29934958:29936764,29934961:29936871,29934964:29936940,29934966:29937208,29934968:2993761', 'assoc_mat': '29872022:autre:4230:29872333,29872023:autre:4230:29872221,29872025:autre:4230:29872438,29872027:autre:4230:29872725,29872029:autre:4230:29872784,29872031:autre:4230:29872943,29872033:autre:4230:29873032,29872035:autre:4230:29873251,29872038:autre:4230:29873396,29872040:autre:4230:29873356,29872044:autre:4230:29873587,29872047:autre:4230:29873701,29872050:autre:4230:29874676,29872053:autre:4230:29873967,29872054:autre:4230:29874033,29872058:autre:4230:29874126,29872062:autre:4230:29874290,29872065:autre:4230:29874545,29872067:autre:4230:29874475,29873348:autre:4230:29873662,29874582:autre:4230:29874603,29909976:autre:4230:29910433,29909979:autre:4230:29910799,29909992:autre:4230:29911196,29909994:autre:4230:29911300,29910007:autre:4230:29911564,29910009:autre:4230:29911528,29910010:autre:4230:29911897,29910012:autre:4230:29911987,29910013:autre:4230:29912372,29910015:autre:4230:29912633,29910016:autre:4230:29912926,29910019:autre:4230:29913097,29910022:autre:4230:29913620,29910024:autre:4230:29913519,29910027:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.045471572710061824, 'nb_photo': 59657, 'list_port_cont': '29872225,29872330,29872442,29872720,29872792,29872954,29873020,29873243,29873368,29873402,29873591,29873656,29873695,29873982,29874030,29874123,29874307,29874489,29874549,29874602,29874689,29910427,29910508,29910809,29911202,29911305,29911534,29911568,29911898,29911988,29912362,29912628,29912943,29913095,29913523,29913625,29914173,29914382,29914433,29914688,29914856,29915045,29915298,29915498,29935125,29935329,29935527,29935742,29935924,29936070,29936396,29936539,29936580,29936619,29936654,29936707,29936756,29936875,29936939,29937023,29937169,29937204,29937316,29937423,29937538,29937574,29937609,29937642,29941229,29941992,29942020,29942133,29942168,29942192,29942220,29942315,29942349,29942386,29942453,29942497,29942538,29942573,29942608,29942646,29942681,29942709,29942754,29942802,29942908,29943007,29943190,29976432,29976584,29976666,29976833,29977063,29977257,29977503,29977679,29977834,29978163,29978247,29978418,29978620,29978682,29978928,29978965,29979001,29979115,29979142,29979189,29979226,29979374,2997988', 'assoc_port': '29872022:29872330,29872023:29872225,29872025:29872442,29872027:29872720,29872029:29872792,29872031:29872954,29872033:29873020,29872035:29873243,29872038:29873402,29872040:29873368,29872044:29873591,29872047:29873695,29872050:29874689,29872053:29873982,29872054:29874030,29872058:29874123,29872062:29874307,29872065:29874549,29872067:29874489,29873348:29873656,29874582:29874602,29909976:29910427,29909979:29910809,29909992:29911202,29909994:29911305,29910007:29911568,29910009:29911534,29910010:29911898,29910012:29911988,29910013:29912362,29910015:29912628,29910016:29912943,29910019:29913095,29910022:29913625,29910024:29913523,29910027:29914173,29910031:29914382,29910035:29914433,29910039:29914688,29910043:29910508,29910046:29914856,29910051:29915045,29910055:29915298,29910072:29915498,29934937:29935125,29934939:29935329,29934941:29935527,29934943:29935742,29934947:29937642,29934950:29935924,29934953:29936070,29934956:29936619,29934958:29936756,29934961:29936875,29934964:29936939,29934966:29937204,29934968:2993760', 'assoc_mat': '29872022:carton:4230:29872330,29872023:carton:4230:29872225,29872025:carton:4230:29872442,29872027:carton:4230:29872720,29872029:carton:4230:29872792,29872031:carton:4230:29872954,29872033:carton:4230:29873020,29872035:carton:4230:29873243,29872038:carton:4230:29873402,29872040:carton:4230:29873368,29872044:carton:4230:29873591,29872047:carton:4230:29873695,29872050:carton:4230:29874689,29872053:carton:4230:29873982,29872054:carton:4230:29874030,29872058:carton:4230:29874123,29872062:carton:4230:29874307,29872065:carton:4230:29874549,29872067:carton:4230:29874489,29873348:carton:4230:29873656,29874582:carton:4230:29874602,29909976:carton:4230:29910427,29909979:carton:4230:29910809,29909992:carton:4230:29911202,29909994:carton:4230:29911305,29910007:carton:4230:29911568,29910009:carton:4230:29911534,29910010:carton:4230:29911898,29910012:carton:4230:29911988,29910013:carton:4230:29912362,29910015:carton:4230:29912628,29910016:carton:4230:29912943,29910019:carton:4230:29913095,29910022:carton:4230:29913625,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014653717255396924, 'nb_photo': 1212, 'list_port_cont': '29872319,29872443,29872723,29872797,29872952,29873025,29873250,29873353,29873397,29873579,29873650,29873980,29874031,29874124,29874478,29874609,29874680,29910504,29910816,29911199,29911311,29911555,29911888,29911981,29912373,29912634,29912942,29913090,29913517,29913611,29914179,29914373,29914423,29914858,29915034,29915305,29935115,29935336,29935519,29935743,29935916,29936397,29936550,29936613,29936757,29936866,29936950,29937015,29937158,29937191,29937304,29937408,29937534,29937558,29937599,29937647,29942022,29942136,29942351,29942392,29942500,29942567,29942595,29942714,29942753,29942899,29943200,29976420,29976589,29976672,29976844,29977056,29977490,29977682,29977823,29978148,29978254,29978412,29978672,29978927,29978964,29979153,29979182,29979223,29979963,29980658,29981121,29981321,29982081,29982954,29984093,29984240,29985929,29989767,29991741,29993581,29999252,30031435,30031830,30031845,30032070,30032201,30032308,30032421,30032921,30032961,30033024,30033146,30033345,30033609,30033829,30034051,30034127,3003436', 'assoc_port': '29872022:29872319,29872025:29872443,29872027:29872723,29872029:29872797,29872031:29872952,29872033:29873025,29872035:29873250,29872038:29873397,29872040:29873353,29872044:29873579,29872050:29874680,29872053:29873980,29872054:29874031,29872058:29874124,29872067:29874478,29873348:29873650,29874582:29874609,29909979:29910816,29909992:29911199,29909994:29911311,29910007:29911555,29910010:29911888,29910012:29911981,29910013:29912373,29910015:29912634,29910016:29912942,29910019:29913090,29910022:29913611,29910024:29913517,29910027:29914179,29910031:29914373,29910035:29914423,29910043:29910504,29910046:29914858,29910051:29915034,29910055:29915305,29934937:29935115,29934939:29935336,29934941:29935519,29934943:29935743,29934947:29937647,29934950:29935916,29934956:29936613,29934958:29936757,29934961:29936866,29934964:29936950,29934966:29937191,29934968:29937599,29934970:29937558,29934972:29937408,29934974:29937534,29934976:29937304,29934978:29937015,29934983:29936550,29934990:29936397,29936858:29937158,29941169:2994289', 'assoc_mat': '29872022:metal:4230:29872319,29872025:metal:4230:29872443,29872027:metal:4230:29872723,29872029:metal:4230:29872797,29872031:metal:4230:29872952,29872033:metal:4230:29873025,29872035:metal:4230:29873250,29872038:metal:4230:29873397,29872040:metal:4230:29873353,29872044:metal:4230:29873579,29872050:metal:4230:29874680,29872053:metal:4230:29873980,29872054:metal:4230:29874031,29872058:metal:4230:29874124,29872067:metal:4230:29874478,29873348:metal:4230:29873650,29874582:metal:4230:29874609,29909979:metal:4230:29910816,29909992:metal:4230:29911199,29909994:metal:4230:29911311,29910007:metal:4230:29911555,29910010:metal:4230:29911888,29910012:metal:4230:29911981,29910013:metal:4230:29912373,29910015:metal:4230:29912634,29910016:metal:4230:29912942,29910019:metal:4230:29913090,29910022:metal:4230:29913611,29910024:metal:4230:29913517,29910027:metal:4230:29914179,29910031:metal:4230:29914373,29910035:metal:4230:29914423,29910043:metal:4230:29910504,29910046:metal:4230:29914858,29910051:metal:4230:29915034,29910055:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1979962975392382, 'nb_photo': 313537, 'list_port_cont': '29872222,29872328,29872451,29872717,29872798,29872942,29873027,29873247,29873369,29873399,29873594,29873663,29873700,29873974,29874032,29874119,29874306,29874482,29874543,29874596,29874690,29910424,29910500,29910814,29911204,29911310,29911529,29911570,29911889,29911989,29912374,29912625,29912934,29913092,29913514,29913619,29914176,29914385,29914436,29914683,29914861,29915047,29915302,29915504,29935112,29935344,29935521,29935738,29935914,29936071,29936390,29936547,29936582,29936622,29936645,29936702,29936767,29936877,29936944,29937020,29937170,29937206,29937313,29937421,29937524,29937573,29937604,29937641,29941232,29941997,29942024,29942139,29942172,29942195,29942229,29942313,29942353,29942390,29942464,29942502,29942535,29942568,29942600,29942637,29942679,29942719,29942755,29942803,29942907,29943015,29943192,29976436,29976591,29976676,29976834,29977058,29977258,29977491,29977690,29977832,29978160,29978251,29978413,29978609,29978683,29978922,29978962,29978999,29979111,29979150,29979180,29979224,29979373,2997988', 'assoc_port': '29872022:29872328,29872023:29872222,29872025:29872451,29872027:29872717,29872029:29872798,29872031:29872942,29872033:29873027,29872035:29873247,29872038:29873399,29872040:29873369,29872044:29873594,29872047:29873700,29872050:29874690,29872053:29873974,29872054:29874032,29872058:29874119,29872062:29874306,29872065:29874543,29872067:29874482,29873348:29873663,29874582:29874596,29909976:29910424,29909979:29910814,29909992:29911204,29909994:29911310,29910007:29911570,29910009:29911529,29910010:29911889,29910012:29911989,29910013:29912374,29910015:29912625,29910016:29912934,29910019:29913092,29910022:29913619,29910024:29913514,29910027:29914176,29910031:29914385,29910035:29914436,29910039:29914683,29910043:29910500,29910046:29914861,29910051:29915047,29910055:29915302,29910072:29915504,29934937:29935112,29934939:29935344,29934941:29935521,29934943:29935738,29934947:29937641,29934950:29935914,29934953:29936071,29934956:29936622,29934958:29936767,29934961:29936877,29934964:29936944,29934966:29937206,29934968:2993760', 'assoc_mat': '29872022:papier:4230:29872328,29872023:papier:4230:29872222,29872025:papier:4230:29872451,29872027:papier:4230:29872717,29872029:papier:4230:29872798,29872031:papier:4230:29872942,29872033:papier:4230:29873027,29872035:papier:4230:29873247,29872038:papier:4230:29873399,29872040:papier:4230:29873369,29872044:papier:4230:29873594,29872047:papier:4230:29873700,29872050:papier:4230:29874690,29872053:papier:4230:29873974,29872054:papier:4230:29874032,29872058:papier:4230:29874119,29872062:papier:4230:29874306,29872065:papier:4230:29874543,29872067:papier:4230:29874482,29873348:papier:4230:29873663,29874582:papier:4230:29874596,29909976:papier:4230:29910424,29909979:papier:4230:29910814,29909992:papier:4230:29911204,29909994:papier:4230:29911310,29910007:papier:4230:29911570,29910009:papier:4230:29911529,29910010:papier:4230:29911889,29910012:papier:4230:29911989,29910013:papier:4230:29912374,29910015:papier:4230:29912625,29910016:papier:4230:29912934,29910019:papier:4230:29913092,29910022:papier:4230:29913619,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0034348385785937185, 'nb_photo': 1571, 'list_port_cont': '29872224,29872336,29872455,29872714,29872793,29872946,29873023,29873252,29873390,29873592,29873660,29873979,29874488,29874604,29874684,29910430,29910490,29910815,29911195,29911308,29911533,29911563,29911895,29911980,29912370,29912630,29912937,29913099,29913518,29913628,29914166,29914379,29914685,29915049,29915306,29915510,29935121,29935520,29935740,29935923,29936075,29936544,29936608,29936758,29936872,29936938,29937022,29937202,29937306,29937413,29937530,29937572,29937608,29937646,29941231,29942501,29942561,29942633,29942675,29942715,29942751,29943008,29943199,29976434,29976581,29976845,29977496,29977685,29977839,29978152,29978242,29978406,29978614,29978932,29978968,29979107,29979154,29979186,29979214,29979884,29979977,29980076,29980945,29981318,29981662,29982969,29984256,29985927,29997260,29999249,30031449,30031838,30032075,30032216,30032305,30032420,30032812,30032930,30032957,30033032,30033143,30033616,30033830,30034067,30034368,30038111,30061048,30061156,30061291,30061485,30061727,30061775,30061953,3006201', 'assoc_port': '29872022:29872336,29872023:29872224,29872025:29872455,29872027:29872714,29872029:29872793,29872031:29872946,29872033:29873023,29872035:29873252,29872038:29873390,29872044:29873592,29872050:29874684,29872053:29873979,29872067:29874488,29873348:29873660,29874582:29874604,29909976:29910430,29909979:29910815,29909992:29911195,29909994:29911308,29910007:29911563,29910009:29911533,29910010:29911895,29910012:29911980,29910013:29912370,29910015:29912630,29910016:29912937,29910019:29913099,29910022:29913628,29910024:29913518,29910027:29914166,29910031:29914379,29910039:29914685,29910043:29910490,29910051:29915049,29910055:29915306,29910072:29915510,29934937:29935121,29934941:29935520,29934943:29935740,29934947:29937646,29934950:29935923,29934953:29936075,29934956:29936608,29934958:29936758,29934961:29936872,29934964:29936938,29934966:29937202,29934968:29937608,29934970:29937572,29934972:29937413,29934974:29937530,29934976:29937306,29934978:29937022,29934983:29936544,29941170:29943199,29941173:29942561,29941174:2994275', 'assoc_mat': '29872022:pehd:4230:29872336,29872023:pehd:4230:29872224,29872025:pehd:4230:29872455,29872027:pehd:4230:29872714,29872029:pehd:4230:29872793,29872031:pehd:4230:29872946,29872033:pehd:4230:29873023,29872035:pehd:4230:29873252,29872038:pehd:4230:29873390,29872044:pehd:4230:29873592,29872050:pehd:4230:29874684,29872053:pehd:4230:29873979,29872067:pehd:4230:29874488,29873348:pehd:4230:29873660,29874582:pehd:4230:29874604,29909976:pehd:4230:29910430,29909979:pehd:4230:29910815,29909992:pehd:4230:29911195,29909994:pehd:4230:29911308,29910007:pehd:4230:29911563,29910009:pehd:4230:29911533,29910010:pehd:4230:29911895,29910012:pehd:4230:29911980,29910013:pehd:4230:29912370,29910015:pehd:4230:29912630,29910016:pehd:4230:29912937,29910019:pehd:4230:29913099,29910022:pehd:4230:29913628,29910024:pehd:4230:29913518,29910027:pehd:4230:29914166,29910031:pehd:4230:29914379,29910039:pehd:4230:29914685,29910043:pehd:4230:29910490,29910051:pehd:4230:29915049,29910055:pehd:4230:29915306,29910072:pehd:4230:29915510,29934937:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012799970637706012, 'nb_photo': 18134, 'list_port_cont': '29872216,29872334,29872450,29872713,29872796,29872953,29873019,29873253,29873361,29873395,29873596,29873658,29873687,29873973,29874028,29874120,29874302,29874480,29874553,29874608,29874693,29910431,29910486,29910808,29911201,29911307,29911525,29911569,29911899,29911990,29912369,29912632,29912940,29913087,29913524,29913627,29914178,29914383,29914431,29914694,29914864,29915048,29915308,29915502,29935122,29935334,29935526,29935741,29935913,29936059,29936392,29936538,29936578,29936620,29936656,29936719,29936766,29936876,29936943,29937024,29937161,29937203,29937317,29937425,29937537,29937568,29937605,29937635,29941227,29941993,29942031,29942131,29942178,29942190,29942237,29942319,29942356,29942388,29942458,29942488,29942528,29942572,29942605,29942642,29942682,29942711,29942749,29942804,29942912,29943012,29943195,29976437,29976590,29976678,29976837,29977061,29977263,29977504,29977688,29977838,29978157,29978253,29978404,29978612,29978680,29978929,29978958,29979003,29979114,29979147,29979181,29979221,29979372,2997989', 'assoc_port': '29872022:29872334,29872023:29872216,29872025:29872450,29872027:29872713,29872029:29872796,29872031:29872953,29872033:29873019,29872035:29873253,29872038:29873395,29872040:29873361,29872044:29873596,29872047:29873687,29872050:29874693,29872053:29873973,29872054:29874028,29872058:29874120,29872062:29874302,29872065:29874553,29872067:29874480,29873348:29873658,29874582:29874608,29909976:29910431,29909979:29910808,29909992:29911201,29909994:29911307,29910007:29911569,29910009:29911525,29910010:29911899,29910012:29911990,29910013:29912369,29910015:29912632,29910016:29912940,29910019:29913087,29910022:29913627,29910024:29913524,29910027:29914178,29910031:29914383,29910035:29914431,29910039:29914694,29910043:29910486,29910046:29914864,29910051:29915048,29910055:29915308,29910072:29915502,29934937:29935122,29934939:29935334,29934941:29935526,29934943:29935741,29934947:29937635,29934950:29935913,29934953:29936059,29934956:29936620,29934958:29936766,29934961:29936876,29934964:29936943,29934966:29937203,29934968:2993760', 'assoc_mat': '29872022:pet_clair:4230:29872334,29872023:pet_clair:4230:29872216,29872025:pet_clair:4230:29872450,29872027:pet_clair:4230:29872713,29872029:pet_clair:4230:29872796,29872031:pet_clair:4230:29872953,29872033:pet_clair:4230:29873019,29872035:pet_clair:4230:29873253,29872038:pet_clair:4230:29873395,29872040:pet_clair:4230:29873361,29872044:pet_clair:4230:29873596,29872047:pet_clair:4230:29873687,29872050:pet_clair:4230:29874693,29872053:pet_clair:4230:29873973,29872054:pet_clair:4230:29874028,29872058:pet_clair:4230:29874120,29872062:pet_clair:4230:29874302,29872065:pet_clair:4230:29874553,29872067:pet_clair:4230:29874480,29873348:pet_clair:4230:29873658,29874582:pet_clair:4230:29874608,29909976:pet_clair:4230:29910431,29909979:pet_clair:4230:29910808,29909992:pet_clair:4230:29911201,29909994:pet_clair:4230:29911307,29910007:pet_clair:4230:29911569,29910009:pet_clair:4230:29911525,29910010:pet_clair:4230:29911899,29910012:pet_clair:4230:29911990,29910013:pet_clair:4230:29912369,29910015:pet_clair:4230:29912632,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002538538585640803, 'nb_photo': 798, 'list_port_cont': '29872214,29872332,29872452,29872718,29873022,29873248,29873393,29873599,29873972,29874034,29874125,29874552,29910432,29910812,29911192,29911302,29911571,29911894,29912371,29912936,29913086,29913522,29913616,29914381,29914420,29914686,29915039,29935343,29935522,29935733,29935926,29936657,29936760,29936869,29937164,29937200,29937309,29937419,29937526,29937570,29937613,29942135,29942186,29942317,29942385,29942489,29942745,29942904,29943197,29976435,29977831,29978256,29978416,29978919,29978963,29979108,29979149,29979184,29979227,29979893,29980077,29980953,29981657,29982085,29982417,29982959,29984096,29984257,29987850,29989659,30031840,30031851,30032080,30032418,30032813,30032928,30032969,30033035,30033152,30033612,30034372,30038099,30061050,30061149,30061302,30061482,30062046,30062092,30062189,30062259,30062732,30062802,30062893,30063227,30065346,30065969,30067338,30067728,30068548,30069660,30070484,30070706,30071322,30071835,30072117,30072628,30072960,30073163,30073609,30074408,30074595,30080964,30080994,3008112', 'assoc_port': '29872022:29872332,29872023:29872214,29872025:29872452,29872027:29872718,29872033:29873022,29872035:29873248,29872038:29873393,29872044:29873599,29872053:29873972,29872054:29874034,29872058:29874125,29872065:29874552,29909976:29910432,29909979:29910812,29909992:29911192,29909994:29911302,29910007:29911571,29910010:29911894,29910013:29912371,29910016:29912936,29910019:29913086,29910022:29913616,29910024:29913522,29910031:29914381,29910035:29914420,29910039:29914686,29910051:29915039,29934939:29935343,29934941:29935522,29934943:29935733,29934950:29935926,29934958:29936760,29934961:29936869,29934966:29937200,29934968:29937613,29934970:29937570,29934972:29937419,29934974:29937526,29934976:29937309,29934987:29936657,29936858:29937164,29941169:29942904,29941170:29943197,29941171:29942135,29941174:29942745,29941190:29942489,29941195:29942385,29941197:29942317,29941209:29942186,29976349:29977831,29976352:29978256,29976357:29978416,29976364:29978963,29976366:29978919,29976368:29979184,29976372:29979227,29976375:2997643', 'assoc_mat': '29872022:pet_fonce:4230:29872332,29872023:pet_fonce:4230:29872214,29872025:pet_fonce:4230:29872452,29872027:pet_fonce:4230:29872718,29872033:pet_fonce:4230:29873022,29872035:pet_fonce:4230:29873248,29872038:pet_fonce:4230:29873393,29872044:pet_fonce:4230:29873599,29872053:pet_fonce:4230:29873972,29872054:pet_fonce:4230:29874034,29872058:pet_fonce:4230:29874125,29872065:pet_fonce:4230:29874552,29909976:pet_fonce:4230:29910432,29909979:pet_fonce:4230:29910812,29909992:pet_fonce:4230:29911192,29909994:pet_fonce:4230:29911302,29910007:pet_fonce:4230:29911571,29910010:pet_fonce:4230:29911894,29910013:pet_fonce:4230:29912371,29910016:pet_fonce:4230:29912936,29910019:pet_fonce:4230:29913086,29910022:pet_fonce:4230:29913616,29910024:pet_fonce:4230:29913522,29910031:pet_fonce:4230:29914381,29910035:pet_fonce:4230:29914420,29910039:pet_fonce:4230:29914686,29910051:pet_fonce:4230:29915039,29934939:pet_fonce:4230:29935343,29934941:pet_fonce:4230:29935522,29934943:pet_fonce:4230:29935733,29934950:pet_fonce:4230:29935926,2'}), 'main_stat': {'nb_photos': 1323}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30148011,30148012,30148013,30148014,30148015,30148016,30148017?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-01', 0.7452656576286569),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1323,),), 'unwanted_material_monthly_percentage': ((0.7452656576286569,),), 'material_repartition': (('incineration', 1321),), 'material_dict': {'incineration': 1321}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 1, 1), 0.7628683186257823, 3), (datetime.date(2026, 1, 2), 0.7783623583119667, 2), (datetime.date(2026, 1, 3), 0.729091206883599, 2), (datetime.date(2026, 1, 4), 0.8189399831895395, 3), (datetime.date(2026, 1, 5), 0.7904882107291961, 3), (datetime.date(2026, 1, 6), 0.8395475082123964, 2), (datetime.date(2026, 1, 7), 0.7386267470825515, 2), (datetime.date(2026, 1, 8), 0.7097128952319308, 2), (datetime.date(2026, 1, 9), 0.7231809849681471, 3), (datetime.date(2026, 1, 10), 0.7357777679596902, 1), (datetime.date(2026, 1, 11), 0.7882982756111476, 2), (datetime.date(2026, 1, 12), 0.8173380786933885, 3), (datetime.date(2026, 1, 13), 0.7571365992249394, 3), (datetime.date(2026, 1, 14), 0.749564362460003, 3), (datetime.date(2026, 1, 15), 0.7155117017716508, 2), (datetime.date(2026, 1, 16), 0.6888977430291897, 1), (datetime.date(2026, 1, 17), 0.6709783522592179, 1), (datetime.date(2026, 1, 18), 0.7595605128251637, 3), (datetime.date(2026, 1, 19), 0.7459409547898507, 1), (datetime.date(2026, 1, 20), 0.7260240184716925, 3), (datetime.date(2026, 1, 21), 0.7089098060442872, 4), (datetime.date(2026, 1, 22), 0.6795040111746038, 4), (datetime.date(2026, 1, 23), 0.7063906634859868, 2), (datetime.date(2026, 1, 24), 0.73549908202317, 1), (datetime.date(2026, 1, 25), 0.7998666989210884, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 1, 1), 0.7628683186257823, 3), (datetime.date(2026, 1, 2), 0.7783623583119667, 2), (datetime.date(2026, 1, 3), 0.729091206883599, 2), (datetime.date(2026, 1, 4), 0.8189399831895395, 3), (datetime.date(2026, 1, 5), 0.7904882107291961, 3), (datetime.date(2026, 1, 6), 0.8395475082123964, 2), (datetime.date(2026, 1, 7), 0.7386267470825515, 2), (datetime.date(2026, 1, 8), 0.7097128952319308, 2), (datetime.date(2026, 1, 9), 0.7231809849681471, 3), (datetime.date(2026, 1, 10), 0.7357777679596902, 1), (datetime.date(2026, 1, 11), 0.7882982756111476, 2), (datetime.date(2026, 1, 12), 0.8173380786933885, 3), (datetime.date(2026, 1, 13), 0.7571365992249394, 3), (datetime.date(2026, 1, 14), 0.749564362460003, 3), (datetime.date(2026, 1, 15), 0.7155117017716508, 2), (datetime.date(2026, 1, 16), 0.6888977430291897, 1), (datetime.date(2026, 1, 17), 0.6709783522592179, 1), (datetime.date(2026, 1, 18), 0.7595605128251637, 3), (datetime.date(2026, 1, 19), 0.7459409547898507, 1), (datetime.date(2026, 1, 20), 0.7260240184716925, 3), (datetime.date(2026, 1, 21), 0.7089098060442872, 4), (datetime.date(2026, 1, 22), 0.6795040111746038, 4), (datetime.date(2026, 1, 23), 0.7063906634859868, 2), (datetime.date(2026, 1, 24), 0.73549908202317, 1), (datetime.date(2026, 1, 25), 0.7998666989210884, 2))}, 'quality_array': [['-8.471475645173246', '01012026'], ['-7.485638106392712', '02012026'], ['-7.959657411537505', '03012026'], ['-7.813394815412816', '04012026'], ['-7.087615627924376', '05012026'], ['-7.063114630058014', '06012026'], ['-7.933873538653429', '07012026'], ['-8.109901422763794', '08012026'], ['-8.34846447635943', '09012026'], ['-8.208383548442965', '10012026'], ['-7.721711060614156', '11012026'], ['-7.555931334274779', '12012026'], ['-7.798723442954645', '13012026'], ['-8.162256005236166', '14012026'], ['-8.096379951371537', '15012026'], ['-8.12060234291741', '16012026'], ['-8.330049611579897', '17012026'], ['-7.986028228597271', '18012026'], ['-7.635710357991782', '19012026'], ['-7.9219879166899165', '20012026'], ['-8.141102939990596', '21012026'], ['-8.201219858557213', '22012026'], ['-8.49136959495617', '23012026'], ['-8.284741297184938', '24012026'], ['-8.065922524492784', '25012026']], 'number_of_batch': ((558,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0155145325877894, 'nb_photo': 13979, 'list_port_cont': '29872221,29872333,29872438,29872725,29872784,29872943,29873032,29873251,29873356,29873396,29873587,29873662,29873701,29873967,29874033,29874126,29874290,29874475,29874545,29874603,29874676,29910433,29910479,29910799,29911196,29911300,29911528,29911564,29911897,29911987,29912372,29912633,29912926,29913097,29913519,29913620,29914169,29914375,29914439,29914691,29914857,29915032,29915293,29915507,29935119,29935338,29935512,29935736,29935915,29936067,29936400,29936548,29936584,29936609,29936652,29936717,29936764,29936871,29936940,29937008,29937168,29937208,29937314,29937424,29937533,29937559,29937611,29937644,29941222,29941988,29942027,29942132,29942176,29942193,29942221,29942311,29942357,29942381,29942452,29942498,29942530,29942563,29942606,29942639,29942669,29942712,29942744,29942794,29942910,29943004,29943191,29976429,29976592,29976673,29976832,29977054,29977251,29977497,29977680,29977828,29978164,29978239,29978410,29978621,29978671,29978920,29978966,29978991,29979116,29979144,29979191,29979215,29979362,2997988', 'assoc_port': '29872022:29872333,29872023:29872221,29872025:29872438,29872027:29872725,29872029:29872784,29872031:29872943,29872033:29873032,29872035:29873251,29872038:29873396,29872040:29873356,29872044:29873587,29872047:29873701,29872050:29874676,29872053:29873967,29872054:29874033,29872058:29874126,29872062:29874290,29872065:29874545,29872067:29874475,29873348:29873662,29874582:29874603,29909976:29910433,29909979:29910799,29909992:29911196,29909994:29911300,29910007:29911564,29910009:29911528,29910010:29911897,29910012:29911987,29910013:29912372,29910015:29912633,29910016:29912926,29910019:29913097,29910022:29913620,29910024:29913519,29910027:29914169,29910031:29914375,29910035:29914439,29910039:29914691,29910043:29910479,29910046:29914857,29910051:29915032,29910055:29915293,29910072:29915507,29934937:29935119,29934939:29935338,29934941:29935512,29934943:29935736,29934947:29937644,29934950:29935915,29934953:29936067,29934956:29936609,29934958:29936764,29934961:29936871,29934964:29936940,29934966:29937208,29934968:2993761', 'assoc_mat': '29872022:autre:4230:29872333,29872023:autre:4230:29872221,29872025:autre:4230:29872438,29872027:autre:4230:29872725,29872029:autre:4230:29872784,29872031:autre:4230:29872943,29872033:autre:4230:29873032,29872035:autre:4230:29873251,29872038:autre:4230:29873396,29872040:autre:4230:29873356,29872044:autre:4230:29873587,29872047:autre:4230:29873701,29872050:autre:4230:29874676,29872053:autre:4230:29873967,29872054:autre:4230:29874033,29872058:autre:4230:29874126,29872062:autre:4230:29874290,29872065:autre:4230:29874545,29872067:autre:4230:29874475,29873348:autre:4230:29873662,29874582:autre:4230:29874603,29909976:autre:4230:29910433,29909979:autre:4230:29910799,29909992:autre:4230:29911196,29909994:autre:4230:29911300,29910007:autre:4230:29911564,29910009:autre:4230:29911528,29910010:autre:4230:29911897,29910012:autre:4230:29911987,29910013:autre:4230:29912372,29910015:autre:4230:29912633,29910016:autre:4230:29912926,29910019:autre:4230:29913097,29910022:autre:4230:29913620,29910024:autre:4230:29913519,29910027:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.045471572710061824, 'nb_photo': 59657, 'list_port_cont': '29872225,29872330,29872442,29872720,29872792,29872954,29873020,29873243,29873368,29873402,29873591,29873656,29873695,29873982,29874030,29874123,29874307,29874489,29874549,29874602,29874689,29910427,29910508,29910809,29911202,29911305,29911534,29911568,29911898,29911988,29912362,29912628,29912943,29913095,29913523,29913625,29914173,29914382,29914433,29914688,29914856,29915045,29915298,29915498,29935125,29935329,29935527,29935742,29935924,29936070,29936396,29936539,29936580,29936619,29936654,29936707,29936756,29936875,29936939,29937023,29937169,29937204,29937316,29937423,29937538,29937574,29937609,29937642,29941229,29941992,29942020,29942133,29942168,29942192,29942220,29942315,29942349,29942386,29942453,29942497,29942538,29942573,29942608,29942646,29942681,29942709,29942754,29942802,29942908,29943007,29943190,29976432,29976584,29976666,29976833,29977063,29977257,29977503,29977679,29977834,29978163,29978247,29978418,29978620,29978682,29978928,29978965,29979001,29979115,29979142,29979189,29979226,29979374,2997988', 'assoc_port': '29872022:29872330,29872023:29872225,29872025:29872442,29872027:29872720,29872029:29872792,29872031:29872954,29872033:29873020,29872035:29873243,29872038:29873402,29872040:29873368,29872044:29873591,29872047:29873695,29872050:29874689,29872053:29873982,29872054:29874030,29872058:29874123,29872062:29874307,29872065:29874549,29872067:29874489,29873348:29873656,29874582:29874602,29909976:29910427,29909979:29910809,29909992:29911202,29909994:29911305,29910007:29911568,29910009:29911534,29910010:29911898,29910012:29911988,29910013:29912362,29910015:29912628,29910016:29912943,29910019:29913095,29910022:29913625,29910024:29913523,29910027:29914173,29910031:29914382,29910035:29914433,29910039:29914688,29910043:29910508,29910046:29914856,29910051:29915045,29910055:29915298,29910072:29915498,29934937:29935125,29934939:29935329,29934941:29935527,29934943:29935742,29934947:29937642,29934950:29935924,29934953:29936070,29934956:29936619,29934958:29936756,29934961:29936875,29934964:29936939,29934966:29937204,29934968:2993760', 'assoc_mat': '29872022:carton:4230:29872330,29872023:carton:4230:29872225,29872025:carton:4230:29872442,29872027:carton:4230:29872720,29872029:carton:4230:29872792,29872031:carton:4230:29872954,29872033:carton:4230:29873020,29872035:carton:4230:29873243,29872038:carton:4230:29873402,29872040:carton:4230:29873368,29872044:carton:4230:29873591,29872047:carton:4230:29873695,29872050:carton:4230:29874689,29872053:carton:4230:29873982,29872054:carton:4230:29874030,29872058:carton:4230:29874123,29872062:carton:4230:29874307,29872065:carton:4230:29874549,29872067:carton:4230:29874489,29873348:carton:4230:29873656,29874582:carton:4230:29874602,29909976:carton:4230:29910427,29909979:carton:4230:29910809,29909992:carton:4230:29911202,29909994:carton:4230:29911305,29910007:carton:4230:29911568,29910009:carton:4230:29911534,29910010:carton:4230:29911898,29910012:carton:4230:29911988,29910013:carton:4230:29912362,29910015:carton:4230:29912628,29910016:carton:4230:29912943,29910019:carton:4230:29913095,29910022:carton:4230:29913625,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014653717255396924, 'nb_photo': 1212, 'list_port_cont': '29872319,29872443,29872723,29872797,29872952,29873025,29873250,29873353,29873397,29873579,29873650,29873980,29874031,29874124,29874478,29874609,29874680,29910504,29910816,29911199,29911311,29911555,29911888,29911981,29912373,29912634,29912942,29913090,29913517,29913611,29914179,29914373,29914423,29914858,29915034,29915305,29935115,29935336,29935519,29935743,29935916,29936397,29936550,29936613,29936757,29936866,29936950,29937015,29937158,29937191,29937304,29937408,29937534,29937558,29937599,29937647,29942022,29942136,29942351,29942392,29942500,29942567,29942595,29942714,29942753,29942899,29943200,29976420,29976589,29976672,29976844,29977056,29977490,29977682,29977823,29978148,29978254,29978412,29978672,29978927,29978964,29979153,29979182,29979223,29979963,29980658,29981121,29981321,29982081,29982954,29984093,29984240,29985929,29989767,29991741,29993581,29999252,30031435,30031830,30031845,30032070,30032201,30032308,30032421,30032921,30032961,30033024,30033146,30033345,30033609,30033829,30034051,30034127,3003436', 'assoc_port': '29872022:29872319,29872025:29872443,29872027:29872723,29872029:29872797,29872031:29872952,29872033:29873025,29872035:29873250,29872038:29873397,29872040:29873353,29872044:29873579,29872050:29874680,29872053:29873980,29872054:29874031,29872058:29874124,29872067:29874478,29873348:29873650,29874582:29874609,29909979:29910816,29909992:29911199,29909994:29911311,29910007:29911555,29910010:29911888,29910012:29911981,29910013:29912373,29910015:29912634,29910016:29912942,29910019:29913090,29910022:29913611,29910024:29913517,29910027:29914179,29910031:29914373,29910035:29914423,29910043:29910504,29910046:29914858,29910051:29915034,29910055:29915305,29934937:29935115,29934939:29935336,29934941:29935519,29934943:29935743,29934947:29937647,29934950:29935916,29934956:29936613,29934958:29936757,29934961:29936866,29934964:29936950,29934966:29937191,29934968:29937599,29934970:29937558,29934972:29937408,29934974:29937534,29934976:29937304,29934978:29937015,29934983:29936550,29934990:29936397,29936858:29937158,29941169:2994289', 'assoc_mat': '29872022:metal:4230:29872319,29872025:metal:4230:29872443,29872027:metal:4230:29872723,29872029:metal:4230:29872797,29872031:metal:4230:29872952,29872033:metal:4230:29873025,29872035:metal:4230:29873250,29872038:metal:4230:29873397,29872040:metal:4230:29873353,29872044:metal:4230:29873579,29872050:metal:4230:29874680,29872053:metal:4230:29873980,29872054:metal:4230:29874031,29872058:metal:4230:29874124,29872067:metal:4230:29874478,29873348:metal:4230:29873650,29874582:metal:4230:29874609,29909979:metal:4230:29910816,29909992:metal:4230:29911199,29909994:metal:4230:29911311,29910007:metal:4230:29911555,29910010:metal:4230:29911888,29910012:metal:4230:29911981,29910013:metal:4230:29912373,29910015:metal:4230:29912634,29910016:metal:4230:29912942,29910019:metal:4230:29913090,29910022:metal:4230:29913611,29910024:metal:4230:29913517,29910027:metal:4230:29914179,29910031:metal:4230:29914373,29910035:metal:4230:29914423,29910043:metal:4230:29910504,29910046:metal:4230:29914858,29910051:metal:4230:29915034,29910055:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1979962975392382, 'nb_photo': 313537, 'list_port_cont': '29872222,29872328,29872451,29872717,29872798,29872942,29873027,29873247,29873369,29873399,29873594,29873663,29873700,29873974,29874032,29874119,29874306,29874482,29874543,29874596,29874690,29910424,29910500,29910814,29911204,29911310,29911529,29911570,29911889,29911989,29912374,29912625,29912934,29913092,29913514,29913619,29914176,29914385,29914436,29914683,29914861,29915047,29915302,29915504,29935112,29935344,29935521,29935738,29935914,29936071,29936390,29936547,29936582,29936622,29936645,29936702,29936767,29936877,29936944,29937020,29937170,29937206,29937313,29937421,29937524,29937573,29937604,29937641,29941232,29941997,29942024,29942139,29942172,29942195,29942229,29942313,29942353,29942390,29942464,29942502,29942535,29942568,29942600,29942637,29942679,29942719,29942755,29942803,29942907,29943015,29943192,29976436,29976591,29976676,29976834,29977058,29977258,29977491,29977690,29977832,29978160,29978251,29978413,29978609,29978683,29978922,29978962,29978999,29979111,29979150,29979180,29979224,29979373,2997988', 'assoc_port': '29872022:29872328,29872023:29872222,29872025:29872451,29872027:29872717,29872029:29872798,29872031:29872942,29872033:29873027,29872035:29873247,29872038:29873399,29872040:29873369,29872044:29873594,29872047:29873700,29872050:29874690,29872053:29873974,29872054:29874032,29872058:29874119,29872062:29874306,29872065:29874543,29872067:29874482,29873348:29873663,29874582:29874596,29909976:29910424,29909979:29910814,29909992:29911204,29909994:29911310,29910007:29911570,29910009:29911529,29910010:29911889,29910012:29911989,29910013:29912374,29910015:29912625,29910016:29912934,29910019:29913092,29910022:29913619,29910024:29913514,29910027:29914176,29910031:29914385,29910035:29914436,29910039:29914683,29910043:29910500,29910046:29914861,29910051:29915047,29910055:29915302,29910072:29915504,29934937:29935112,29934939:29935344,29934941:29935521,29934943:29935738,29934947:29937641,29934950:29935914,29934953:29936071,29934956:29936622,29934958:29936767,29934961:29936877,29934964:29936944,29934966:29937206,29934968:2993760', 'assoc_mat': '29872022:papier:4230:29872328,29872023:papier:4230:29872222,29872025:papier:4230:29872451,29872027:papier:4230:29872717,29872029:papier:4230:29872798,29872031:papier:4230:29872942,29872033:papier:4230:29873027,29872035:papier:4230:29873247,29872038:papier:4230:29873399,29872040:papier:4230:29873369,29872044:papier:4230:29873594,29872047:papier:4230:29873700,29872050:papier:4230:29874690,29872053:papier:4230:29873974,29872054:papier:4230:29874032,29872058:papier:4230:29874119,29872062:papier:4230:29874306,29872065:papier:4230:29874543,29872067:papier:4230:29874482,29873348:papier:4230:29873663,29874582:papier:4230:29874596,29909976:papier:4230:29910424,29909979:papier:4230:29910814,29909992:papier:4230:29911204,29909994:papier:4230:29911310,29910007:papier:4230:29911570,29910009:papier:4230:29911529,29910010:papier:4230:29911889,29910012:papier:4230:29911989,29910013:papier:4230:29912374,29910015:papier:4230:29912625,29910016:papier:4230:29912934,29910019:papier:4230:29913092,29910022:papier:4230:29913619,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0034348385785937185, 'nb_photo': 1571, 'list_port_cont': '29872224,29872336,29872455,29872714,29872793,29872946,29873023,29873252,29873390,29873592,29873660,29873979,29874488,29874604,29874684,29910430,29910490,29910815,29911195,29911308,29911533,29911563,29911895,29911980,29912370,29912630,29912937,29913099,29913518,29913628,29914166,29914379,29914685,29915049,29915306,29915510,29935121,29935520,29935740,29935923,29936075,29936544,29936608,29936758,29936872,29936938,29937022,29937202,29937306,29937413,29937530,29937572,29937608,29937646,29941231,29942501,29942561,29942633,29942675,29942715,29942751,29943008,29943199,29976434,29976581,29976845,29977496,29977685,29977839,29978152,29978242,29978406,29978614,29978932,29978968,29979107,29979154,29979186,29979214,29979884,29979977,29980076,29980945,29981318,29981662,29982969,29984256,29985927,29997260,29999249,30031449,30031838,30032075,30032216,30032305,30032420,30032812,30032930,30032957,30033032,30033143,30033616,30033830,30034067,30034368,30038111,30061048,30061156,30061291,30061485,30061727,30061775,30061953,3006201', 'assoc_port': '29872022:29872336,29872023:29872224,29872025:29872455,29872027:29872714,29872029:29872793,29872031:29872946,29872033:29873023,29872035:29873252,29872038:29873390,29872044:29873592,29872050:29874684,29872053:29873979,29872067:29874488,29873348:29873660,29874582:29874604,29909976:29910430,29909979:29910815,29909992:29911195,29909994:29911308,29910007:29911563,29910009:29911533,29910010:29911895,29910012:29911980,29910013:29912370,29910015:29912630,29910016:29912937,29910019:29913099,29910022:29913628,29910024:29913518,29910027:29914166,29910031:29914379,29910039:29914685,29910043:29910490,29910051:29915049,29910055:29915306,29910072:29915510,29934937:29935121,29934941:29935520,29934943:29935740,29934947:29937646,29934950:29935923,29934953:29936075,29934956:29936608,29934958:29936758,29934961:29936872,29934964:29936938,29934966:29937202,29934968:29937608,29934970:29937572,29934972:29937413,29934974:29937530,29934976:29937306,29934978:29937022,29934983:29936544,29941170:29943199,29941173:29942561,29941174:2994275', 'assoc_mat': '29872022:pehd:4230:29872336,29872023:pehd:4230:29872224,29872025:pehd:4230:29872455,29872027:pehd:4230:29872714,29872029:pehd:4230:29872793,29872031:pehd:4230:29872946,29872033:pehd:4230:29873023,29872035:pehd:4230:29873252,29872038:pehd:4230:29873390,29872044:pehd:4230:29873592,29872050:pehd:4230:29874684,29872053:pehd:4230:29873979,29872067:pehd:4230:29874488,29873348:pehd:4230:29873660,29874582:pehd:4230:29874604,29909976:pehd:4230:29910430,29909979:pehd:4230:29910815,29909992:pehd:4230:29911195,29909994:pehd:4230:29911308,29910007:pehd:4230:29911563,29910009:pehd:4230:29911533,29910010:pehd:4230:29911895,29910012:pehd:4230:29911980,29910013:pehd:4230:29912370,29910015:pehd:4230:29912630,29910016:pehd:4230:29912937,29910019:pehd:4230:29913099,29910022:pehd:4230:29913628,29910024:pehd:4230:29913518,29910027:pehd:4230:29914166,29910031:pehd:4230:29914379,29910039:pehd:4230:29914685,29910043:pehd:4230:29910490,29910051:pehd:4230:29915049,29910055:pehd:4230:29915306,29910072:pehd:4230:29915510,29934937:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012799970637706012, 'nb_photo': 18134, 'list_port_cont': '29872216,29872334,29872450,29872713,29872796,29872953,29873019,29873253,29873361,29873395,29873596,29873658,29873687,29873973,29874028,29874120,29874302,29874480,29874553,29874608,29874693,29910431,29910486,29910808,29911201,29911307,29911525,29911569,29911899,29911990,29912369,29912632,29912940,29913087,29913524,29913627,29914178,29914383,29914431,29914694,29914864,29915048,29915308,29915502,29935122,29935334,29935526,29935741,29935913,29936059,29936392,29936538,29936578,29936620,29936656,29936719,29936766,29936876,29936943,29937024,29937161,29937203,29937317,29937425,29937537,29937568,29937605,29937635,29941227,29941993,29942031,29942131,29942178,29942190,29942237,29942319,29942356,29942388,29942458,29942488,29942528,29942572,29942605,29942642,29942682,29942711,29942749,29942804,29942912,29943012,29943195,29976437,29976590,29976678,29976837,29977061,29977263,29977504,29977688,29977838,29978157,29978253,29978404,29978612,29978680,29978929,29978958,29979003,29979114,29979147,29979181,29979221,29979372,2997989', 'assoc_port': '29872022:29872334,29872023:29872216,29872025:29872450,29872027:29872713,29872029:29872796,29872031:29872953,29872033:29873019,29872035:29873253,29872038:29873395,29872040:29873361,29872044:29873596,29872047:29873687,29872050:29874693,29872053:29873973,29872054:29874028,29872058:29874120,29872062:29874302,29872065:29874553,29872067:29874480,29873348:29873658,29874582:29874608,29909976:29910431,29909979:29910808,29909992:29911201,29909994:29911307,29910007:29911569,29910009:29911525,29910010:29911899,29910012:29911990,29910013:29912369,29910015:29912632,29910016:29912940,29910019:29913087,29910022:29913627,29910024:29913524,29910027:29914178,29910031:29914383,29910035:29914431,29910039:29914694,29910043:29910486,29910046:29914864,29910051:29915048,29910055:29915308,29910072:29915502,29934937:29935122,29934939:29935334,29934941:29935526,29934943:29935741,29934947:29937635,29934950:29935913,29934953:29936059,29934956:29936620,29934958:29936766,29934961:29936876,29934964:29936943,29934966:29937203,29934968:2993760', 'assoc_mat': '29872022:pet_clair:4230:29872334,29872023:pet_clair:4230:29872216,29872025:pet_clair:4230:29872450,29872027:pet_clair:4230:29872713,29872029:pet_clair:4230:29872796,29872031:pet_clair:4230:29872953,29872033:pet_clair:4230:29873019,29872035:pet_clair:4230:29873253,29872038:pet_clair:4230:29873395,29872040:pet_clair:4230:29873361,29872044:pet_clair:4230:29873596,29872047:pet_clair:4230:29873687,29872050:pet_clair:4230:29874693,29872053:pet_clair:4230:29873973,29872054:pet_clair:4230:29874028,29872058:pet_clair:4230:29874120,29872062:pet_clair:4230:29874302,29872065:pet_clair:4230:29874553,29872067:pet_clair:4230:29874480,29873348:pet_clair:4230:29873658,29874582:pet_clair:4230:29874608,29909976:pet_clair:4230:29910431,29909979:pet_clair:4230:29910808,29909992:pet_clair:4230:29911201,29909994:pet_clair:4230:29911307,29910007:pet_clair:4230:29911569,29910009:pet_clair:4230:29911525,29910010:pet_clair:4230:29911899,29910012:pet_clair:4230:29911990,29910013:pet_clair:4230:29912369,29910015:pet_clair:4230:29912632,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002538538585640803, 'nb_photo': 798, 'list_port_cont': '29872214,29872332,29872452,29872718,29873022,29873248,29873393,29873599,29873972,29874034,29874125,29874552,29910432,29910812,29911192,29911302,29911571,29911894,29912371,29912936,29913086,29913522,29913616,29914381,29914420,29914686,29915039,29935343,29935522,29935733,29935926,29936657,29936760,29936869,29937164,29937200,29937309,29937419,29937526,29937570,29937613,29942135,29942186,29942317,29942385,29942489,29942745,29942904,29943197,29976435,29977831,29978256,29978416,29978919,29978963,29979108,29979149,29979184,29979227,29979893,29980077,29980953,29981657,29982085,29982417,29982959,29984096,29984257,29987850,29989659,30031840,30031851,30032080,30032418,30032813,30032928,30032969,30033035,30033152,30033612,30034372,30038099,30061050,30061149,30061302,30061482,30062046,30062092,30062189,30062259,30062732,30062802,30062893,30063227,30065346,30065969,30067338,30067728,30068548,30069660,30070484,30070706,30071322,30071835,30072117,30072628,30072960,30073163,30073609,30074408,30074595,30080964,30080994,3008112', 'assoc_port': '29872022:29872332,29872023:29872214,29872025:29872452,29872027:29872718,29872033:29873022,29872035:29873248,29872038:29873393,29872044:29873599,29872053:29873972,29872054:29874034,29872058:29874125,29872065:29874552,29909976:29910432,29909979:29910812,29909992:29911192,29909994:29911302,29910007:29911571,29910010:29911894,29910013:29912371,29910016:29912936,29910019:29913086,29910022:29913616,29910024:29913522,29910031:29914381,29910035:29914420,29910039:29914686,29910051:29915039,29934939:29935343,29934941:29935522,29934943:29935733,29934950:29935926,29934958:29936760,29934961:29936869,29934966:29937200,29934968:29937613,29934970:29937570,29934972:29937419,29934974:29937526,29934976:29937309,29934987:29936657,29936858:29937164,29941169:29942904,29941170:29943197,29941171:29942135,29941174:29942745,29941190:29942489,29941195:29942385,29941197:29942317,29941209:29942186,29976349:29977831,29976352:29978256,29976357:29978416,29976364:29978963,29976366:29978919,29976368:29979184,29976372:29979227,29976375:2997643', 'assoc_mat': '29872022:pet_fonce:4230:29872332,29872023:pet_fonce:4230:29872214,29872025:pet_fonce:4230:29872452,29872027:pet_fonce:4230:29872718,29872033:pet_fonce:4230:29873022,29872035:pet_fonce:4230:29873248,29872038:pet_fonce:4230:29873393,29872044:pet_fonce:4230:29873599,29872053:pet_fonce:4230:29873972,29872054:pet_fonce:4230:29874034,29872058:pet_fonce:4230:29874125,29872065:pet_fonce:4230:29874552,29909976:pet_fonce:4230:29910432,29909979:pet_fonce:4230:29910812,29909992:pet_fonce:4230:29911192,29909994:pet_fonce:4230:29911302,29910007:pet_fonce:4230:29911571,29910010:pet_fonce:4230:29911894,29910013:pet_fonce:4230:29912371,29910016:pet_fonce:4230:29912936,29910019:pet_fonce:4230:29913086,29910022:pet_fonce:4230:29913616,29910024:pet_fonce:4230:29913522,29910031:pet_fonce:4230:29914381,29910035:pet_fonce:4230:29914420,29910039:pet_fonce:4230:29914686,29910051:pet_fonce:4230:29915039,29934939:pet_fonce:4230:29935343,29934941:pet_fonce:4230:29935522,29934943:pet_fonce:4230:29935733,29934950:pet_fonce:4230:29935926,2'}), 'main_stat': {'nb_photos': 1323}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30148011,30148012,30148013,30148014,30148015,30148016,30148017?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-01', 0.7452656576286569),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_01_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.55%', 13979], 'carton': ['carton', '4.55%', 59657], 'metal': ['metal', '0.15%', 1212], 'papier': ['papier', '19.8%', 313537], 'pehd': ['pehd', '0.34%', 1571], 'pet_clair': ['pet_clair', '1.28%', 18134], 'pet_fonce': ['pet_fonce', '0.25%', 798]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_01_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.22user 2.52system 0:11.37elapsed 41%CPU (0avgtext+0avgdata 184372maxresident)k 0inputs+296outputs (0major+44866minor)pagefaults 0swaps