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-06 _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 : (0, 30) 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 : (0, 30) 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 : 06 mtr_id : dashboard_places : SCCU_cam6 date : 2026-06 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-06%') and created_at like '%2026-06%'))); nb_day : (0, 30) 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) = 06 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) = 06 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 '%062026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-06-01 : dt_date_just_month_year : 2026-06-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-06-01" AND ded.date <= "2026-06-30" 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 (3000946,2996358,2996310,3001668,3001178,2997660,2998110,2998634,2999160,2999788,3000332,3000774,3001286,3001822,3002428,3002770,3003138,3003564,3004096,3004254) 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.013785055530350221, 'nb_photo': 20435, 'list_port_cont': '31141485,31141695,31142125,31142319,31142574,31142624,31142949,31143371,31143413,31143911,31143939,31144353,31144390,31144435,31144512,31145543,31145866,31145894,31146964,31147013,31147046,31147090,31147118,31147169,31147198,31147245,31147272,31147324,31147347,31147384,31147432,31147468,31147497,31147576,31150916,31150944,31150981,31151015,31151069,31151101,31151128,31151177,31151222,31151252,31151280,31151318,31151369,31151405,31151441,31151477,31151535,31151569,31151604,31151679,31151720,31151786,31151824,31151872,31151909,31151949,31152049,31152084,31152113,31152156,31152200,31152258,31153636,31153699,31154524,31154557,31154593,31154641,31154675,31154708,31154762,31154798,31154830,31154879,31154910,31154944,31154998,31155023,31155070,31156399,31156449,31157600,31157626,31157671,31157708,31157741,31157790,31157819,31157858,31157895,31157938,31157960,31158002,31158041,31158083,31158126,31158160,31160355,31160394,31160433,31160465,31160514,31160546,31160580,31160626,31160651,31160691,31160737,31160773,3116080', 'assoc_port': '31141458:31141485,31141670:31141695,31141920:31142319,31142099:31142125,31142550:31142574,31142551:31142624,31142881:31142949,31143278:31143371,31143279:31143413,31143714:31143939,31143715:31143911,31144159:31144353,31144160:31144390,31144161:31144435,31144162:31144512,31144869:31145543,31144871:31145894,31144872:31145866,31146752:31146964,31146753:31147013,31146755:31156449,31146756:31147046,31146757:31151786,31146758:31156399,31146759:31151824,31146760:31147090,31146761:31147118,31146762:31151872,31146763:31151909,31146764:31151949,31146765:31147169,31146766:31147198,31146767:31147245,31146768:31147272,31146769:31147324,31146770:31147347,31146771:31147384,31146772:31147432,31146773:31147468,31146774:31147497,31146775:31147576,31146927:31175752,31146928:31175797,31146935:31150916,31146936:31150944,31146937:31150981,31146938:31151015,31146939:31151069,31146940:31151101,31146941:31151128,31146942:31151177,31146943:31153636,31146944:31151222,31146945:31151252,31146946:31151280,31146947:31151318,31146948:3115136', 'assoc_mat': '31141458:autre:4230:31141485,31141670:autre:4230:31141695,31141920:autre:4230:31142319,31142099:autre:4230:31142125,31142550:autre:4230:31142574,31142551:autre:4230:31142624,31142881:autre:4230:31142949,31143278:autre:4230:31143371,31143279:autre:4230:31143413,31143714:autre:4230:31143939,31143715:autre:4230:31143911,31144159:autre:4230:31144353,31144160:autre:4230:31144390,31144161:autre:4230:31144435,31144162:autre:4230:31144512,31144869:autre:4230:31145543,31144871:autre:4230:31145894,31144872:autre:4230:31145866,31146752:autre:4230:31146964,31146753:autre:4230:31147013,31146755:autre:4230:31156449,31146756:autre:4230:31147046,31146757:autre:4230:31151786,31146758:autre:4230:31156399,31146759:autre:4230:31151824,31146760:autre:4230:31147090,31146761:autre:4230:31147118,31146762:autre:4230:31151872,31146763:autre:4230:31151909,31146764:autre:4230:31151949,31146765:autre:4230:31147169,31146766:autre:4230:31147198,31146767:autre:4230:31147245,31146768:autre:4230:31147272,31146769:autre:4230:31147324,31146770:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03691127350529296, 'nb_photo': 88612, 'list_port_cont': '31141486,31141701,31142129,31142316,31142581,31142618,31142952,31143384,31143421,31143906,31143946,31144366,31144400,31144434,31144514,31145539,31145863,31145900,31146973,31147003,31147044,31147088,31147123,31147174,31147202,31147247,31147285,31147315,31147356,31147390,31147431,31147472,31147514,31147579,31150909,31150947,31150976,31151028,31151064,31151090,31151145,31151179,31151220,31151250,31151282,31151328,31151364,31151397,31151439,31151476,31151532,31151573,31151608,31151686,31151729,31151792,31151823,31151875,31151904,31151941,31152046,31152073,31152123,31152154,31152196,31152273,31153635,31153701,31154525,31154566,31154606,31154646,31154679,31154716,31154748,31154810,31154843,31154876,31154925,31154955,31154996,31155030,31155086,31156410,31156455,31157599,31157638,31157666,31157717,31157751,31157784,31157818,31157859,31157896,31157930,31157975,31158010,31158052,31158085,31158128,31158156,31160367,31160405,31160443,31160476,31160515,31160554,31160590,31160629,31160665,31160686,31160735,31160775,3116080', 'assoc_port': '31141458:31141486,31141670:31141701,31141920:31142316,31142099:31142129,31142550:31142581,31142551:31142618,31142881:31142952,31143278:31143384,31143279:31143421,31143714:31143946,31143715:31143906,31144159:31144366,31144160:31144400,31144161:31144434,31144162:31144514,31144869:31145539,31144871:31145900,31144872:31145863,31146752:31146973,31146753:31147003,31146755:31156455,31146756:31147044,31146757:31151792,31146758:31156410,31146759:31151823,31146760:31147088,31146761:31147123,31146762:31151875,31146763:31151904,31146764:31151941,31146765:31147174,31146766:31147202,31146767:31147247,31146768:31147285,31146769:31147315,31146770:31147356,31146771:31147390,31146772:31147431,31146773:31147472,31146774:31147514,31146775:31147579,31146927:31175758,31146928:31175794,31146935:31150909,31146936:31150947,31146937:31150976,31146938:31151028,31146939:31151064,31146940:31151090,31146941:31151145,31146942:31151179,31146943:31153635,31146944:31151220,31146945:31151250,31146946:31151282,31146947:31151328,31146948:3115136', 'assoc_mat': '31141458:carton:4230:31141486,31141670:carton:4230:31141701,31141920:carton:4230:31142316,31142099:carton:4230:31142129,31142550:carton:4230:31142581,31142551:carton:4230:31142618,31142881:carton:4230:31142952,31143278:carton:4230:31143384,31143279:carton:4230:31143421,31143714:carton:4230:31143946,31143715:carton:4230:31143906,31144159:carton:4230:31144366,31144160:carton:4230:31144400,31144161:carton:4230:31144434,31144162:carton:4230:31144514,31144869:carton:4230:31145539,31144871:carton:4230:31145900,31144872:carton:4230:31145863,31146752:carton:4230:31146973,31146753:carton:4230:31147003,31146755:carton:4230:31156455,31146756:carton:4230:31147044,31146757:carton:4230:31151792,31146758:carton:4230:31156410,31146759:carton:4230:31151823,31146760:carton:4230:31147088,31146761:carton:4230:31147123,31146762:carton:4230:31151875,31146763:carton:4230:31151904,31146764:carton:4230:31151941,31146765:carton:4230:31147174,31146766:carton:4230:31147202,31146767:carton:4230:31147247,31146768:carton:4230:31147285,3114'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012734899793404027, 'nb_photo': 1971, 'list_port_cont': '31142118,31143908,31143943,31144357,31144399,31144497,31145532,31145905,31146979,31147124,31147173,31147200,31147233,31147270,31147319,31147355,31147383,31147436,31147473,31147501,31147587,31150917,31150940,31150984,31151027,31151057,31151098,31151144,31151216,31151291,31151319,31151367,31151436,31151473,31151537,31151559,31151602,31151673,31151714,31151789,31151836,31151907,31151936,31152044,31152082,31152111,31152149,31152194,31152261,31153640,31153691,31154531,31154561,31154678,31154712,31154759,31154794,31154842,31154871,31154923,31154945,31154990,31155040,31155085,31156398,31156444,31157598,31157637,31157677,31157707,31157783,31157863,31157891,31158081,31158155,31160364,31160400,31160428,31160477,31160553,31160575,31160699,31160739,31160766,31160807,31160843,31160888,31160928,31162707,31162734,31162783,31162865,31163316,31163384,31163525,31163677,31163708,31163748,31163792,31163865,31163934,31163961,31163993,31164040,31165826,31165855,31166565,31166669,31166713,31166741,31166786,31166891,31166937,3116699', 'assoc_port': '31142099:31142118,31143714:31143943,31143715:31143908,31144159:31144357,31144160:31144399,31144162:31144497,31144869:31145532,31144871:31145905,31146752:31146979,31146755:31156444,31146757:31151789,31146758:31156398,31146759:31151836,31146761:31147124,31146763:31151907,31146764:31151936,31146765:31147173,31146766:31147200,31146767:31147233,31146768:31147270,31146769:31147319,31146770:31147355,31146771:31147383,31146772:31147436,31146773:31147473,31146774:31147501,31146775:31147587,31146935:31150917,31146936:31150940,31146937:31150984,31146938:31151027,31146939:31151057,31146940:31151098,31146941:31151144,31146943:31153640,31146944:31151216,31146946:31151291,31146947:31151319,31146948:31151367,31146950:31151436,31146951:31151473,31146952:31151537,31146953:31151559,31146954:31151602,31146956:31151673,31146957:31151714,31146958:31153691,31148212:31152044,31148213:31152082,31148214:31152111,31148215:31152149,31148216:31152261,31148217:31152194,31152842:31179120,31152880:31179153,31152881:31179218,31152882:3117925', 'assoc_mat': '31142099:metal:4230:31142118,31143714:metal:4230:31143943,31143715:metal:4230:31143908,31144159:metal:4230:31144357,31144160:metal:4230:31144399,31144162:metal:4230:31144497,31144869:metal:4230:31145532,31144871:metal:4230:31145905,31146752:metal:4230:31146979,31146755:metal:4230:31156444,31146757:metal:4230:31151789,31146758:metal:4230:31156398,31146759:metal:4230:31151836,31146761:metal:4230:31147124,31146763:metal:4230:31151907,31146764:metal:4230:31151936,31146765:metal:4230:31147173,31146766:metal:4230:31147200,31146767:metal:4230:31147233,31146768:metal:4230:31147270,31146769:metal:4230:31147319,31146770:metal:4230:31147355,31146771:metal:4230:31147383,31146772:metal:4230:31147436,31146773:metal:4230:31147473,31146774:metal:4230:31147501,31146775:metal:4230:31147587,31146935:metal:4230:31150917,31146936:metal:4230:31150940,31146937:metal:4230:31150984,31146938:metal:4230:31151027,31146939:metal:4230:31151057,31146940:metal:4230:31151098,31146941:metal:4230:31151144,31146943:metal:4230:31153640,31146944:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.172187789881647, 'nb_photo': 548040, 'list_port_cont': '31141472,31141692,31142124,31142320,31142585,31142623,31142951,31143386,31143417,31143903,31143945,31144365,31144398,31144430,31144511,31145544,31145867,31145902,31146974,31147010,31147057,31147093,31147127,31147168,31147211,31147240,31147281,31147322,31147359,31147393,31147433,31147474,31147512,31147586,31150908,31150954,31150980,31151017,31151060,31151096,31151139,31151172,31151218,31151253,31151289,31151330,31151354,31151404,31151445,31151484,31151530,31151567,31151615,31151690,31151730,31151793,31151833,31151864,31151913,31151948,31152040,31152076,31152124,31152164,31152202,31152271,31153647,31153702,31154536,31154571,31154608,31154637,31154685,31154719,31154756,31154802,31154839,31154880,31154918,31154951,31154989,31155032,31155087,31156414,31156453,31157595,31157640,31157678,31157703,31157749,31157788,31157828,31157865,31157902,31157936,31157974,31158011,31158050,31158077,31158124,31158169,31160366,31160407,31160436,31160472,31160505,31160556,31160588,31160623,31160663,31160698,31160734,31160771,3116080', 'assoc_port': '31141458:31141472,31141670:31141692,31141920:31142320,31142099:31142124,31142550:31142585,31142551:31142623,31142881:31142951,31143278:31143386,31143279:31143417,31143714:31143945,31143715:31143903,31144159:31144365,31144160:31144398,31144161:31144430,31144162:31144511,31144869:31145544,31144871:31145902,31144872:31145867,31146752:31146974,31146753:31147010,31146755:31156453,31146756:31147057,31146757:31151793,31146758:31156414,31146759:31151833,31146760:31147093,31146761:31147127,31146762:31151864,31146763:31151913,31146764:31151948,31146765:31147168,31146766:31147211,31146767:31147240,31146768:31147281,31146769:31147322,31146770:31147359,31146771:31147393,31146772:31147433,31146773:31147474,31146774:31147512,31146775:31147586,31146927:31175759,31146928:31175789,31146935:31150908,31146936:31150954,31146937:31150980,31146938:31151017,31146939:31151060,31146940:31151096,31146941:31151139,31146942:31151172,31146943:31153647,31146944:31151218,31146945:31151253,31146946:31151289,31146947:31151330,31146948:3115135', 'assoc_mat': '31141458:papier:4230:31141472,31141670:papier:4230:31141692,31141920:papier:4230:31142320,31142099:papier:4230:31142124,31142550:papier:4230:31142585,31142551:papier:4230:31142623,31142881:papier:4230:31142951,31143278:papier:4230:31143386,31143279:papier:4230:31143417,31143714:papier:4230:31143945,31143715:papier:4230:31143903,31144159:papier:4230:31144365,31144160:papier:4230:31144398,31144161:papier:4230:31144430,31144162:papier:4230:31144511,31144869:papier:4230:31145544,31144871:papier:4230:31145902,31144872:papier:4230:31145867,31146752:papier:4230:31146974,31146753:papier:4230:31147010,31146755:papier:4230:31156453,31146756:papier:4230:31147057,31146757:papier:4230:31151793,31146758:papier:4230:31156414,31146759:papier:4230:31151833,31146760:papier:4230:31147093,31146761:papier:4230:31147127,31146762:papier:4230:31151864,31146763:papier:4230:31151913,31146764:papier:4230:31151948,31146765:papier:4230:31147168,31146766:papier:4230:31147211,31146767:papier:4230:31147240,31146768:papier:4230:31147281,3114'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0035226340105312644, 'nb_photo': 1946, 'list_port_cont': '31142117,31142616,31143410,31143912,31143944,31144363,31144507,31145538,31145908,31146976,31147122,31147171,31147210,31147242,31147280,31147392,31147435,31147467,31147573,31150988,31151029,31151066,31151135,31151180,31151219,31151257,31151285,31151329,31151366,31151408,31151440,31151481,31151538,31151609,31151681,31151831,31151865,31151912,31151947,31152045,31152083,31152161,31152192,31152269,31153645,31154684,31154717,31154753,31154805,31154846,31154878,31154921,31154949,31154999,31155025,31155073,31156413,31160480,31160509,31160545,31160625,31160657,31160696,31160732,31160887,31161032,31162700,31162740,31162817,31163285,31163322,31163500,31163604,31163650,31163683,31163794,31163861,31163896,31163928,31163966,31164005,31164039,31165861,31165889,31166608,31166641,31166676,31166787,31166828,31167003,31169416,31169487,31169527,31169566,31169603,31171083,31171401,31171546,31171592,31171633,31171664,31171708,31171779,31173228,31173274,31173310,31173350,31173385,31173411,31173452,31173500,31173535,31173564,3117360', 'assoc_port': '31142099:31142117,31142551:31142616,31143279:31143410,31143714:31143944,31143715:31143912,31144159:31144363,31144162:31144507,31144869:31145538,31144871:31145908,31146752:31146976,31146758:31156413,31146759:31151831,31146761:31147122,31146762:31151865,31146763:31151912,31146764:31151947,31146765:31147171,31146766:31147210,31146767:31147242,31146768:31147280,31146771:31147392,31146772:31147435,31146773:31147467,31146775:31147573,31146927:31175753,31146928:31175796,31146937:31150988,31146938:31151029,31146939:31151066,31146941:31151135,31146942:31151180,31146943:31153645,31146944:31151219,31146945:31151257,31146946:31151285,31146947:31151329,31146948:31151366,31146949:31151408,31146950:31151440,31146951:31151481,31146952:31151538,31146954:31151609,31146956:31151681,31148212:31152045,31148213:31152083,31148215:31152161,31148216:31152269,31148217:31152192,31152842:31179110,31152879:31179182,31152880:31179151,31152881:31179231,31152883:31179303,31152884:31179338,31152885:31179370,31152886:31179410,31152887:3117945', 'assoc_mat': '31142099:pehd:4230:31142117,31142551:pehd:4230:31142616,31143279:pehd:4230:31143410,31143714:pehd:4230:31143944,31143715:pehd:4230:31143912,31144159:pehd:4230:31144363,31144162:pehd:4230:31144507,31144869:pehd:4230:31145538,31144871:pehd:4230:31145908,31146752:pehd:4230:31146976,31146758:pehd:4230:31156413,31146759:pehd:4230:31151831,31146761:pehd:4230:31147122,31146762:pehd:4230:31151865,31146763:pehd:4230:31151912,31146764:pehd:4230:31151947,31146765:pehd:4230:31147171,31146766:pehd:4230:31147210,31146767:pehd:4230:31147242,31146768:pehd:4230:31147280,31146771:pehd:4230:31147392,31146772:pehd:4230:31147435,31146773:pehd:4230:31147467,31146775:pehd:4230:31147573,31146927:pehd:4230:31175753,31146928:pehd:4230:31175796,31146937:pehd:4230:31150988,31146938:pehd:4230:31151029,31146939:pehd:4230:31151066,31146941:pehd:4230:31151135,31146942:pehd:4230:31151180,31146943:pehd:4230:31153645,31146944:pehd:4230:31151219,31146945:pehd:4230:31151257,31146946:pehd:4230:31151285,31146947:pehd:4230:31151329,31146948:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017948749129603772, 'nb_photo': 32350, 'list_port_cont': '31141487,31141698,31142127,31142317,31142586,31142621,31142948,31143381,31143422,31143904,31143937,31144355,31144391,31144440,31144513,31145542,31145864,31145901,31146977,31147004,31147051,31147092,31147130,31147172,31147206,31147243,31147279,31147320,31147349,31147397,31147428,31147476,31147503,31147585,31150914,31150952,31150989,31151026,31151053,31151099,31151142,31151176,31151214,31151258,31151294,31151331,31151362,31151395,31151444,31151487,31151536,31151566,31151601,31151688,31151721,31151796,31151835,31151873,31151910,31151944,31152047,31152078,31152120,31152151,31152198,31152270,31153646,31153694,31154530,31154572,31154607,31154645,31154681,31154713,31154758,31154801,31154847,31154884,31154924,31154953,31155001,31155039,31155084,31156411,31156445,31157593,31157635,31157672,31157715,31157746,31157786,31157822,31157857,31157901,31157935,31157965,31158009,31158053,31158087,31158130,31158168,31160362,31160398,31160444,31160473,31160513,31160551,31160592,31160627,31160658,31160692,31160741,31160772,3116079', 'assoc_port': '31141458:31141487,31141670:31141698,31141920:31142317,31142099:31142127,31142550:31142586,31142551:31142621,31142881:31142948,31143278:31143381,31143279:31143422,31143714:31143937,31143715:31143904,31144159:31144355,31144160:31144391,31144161:31144440,31144162:31144513,31144869:31145542,31144871:31145901,31144872:31145864,31146752:31146977,31146753:31147004,31146755:31156445,31146756:31147051,31146757:31151796,31146758:31156411,31146759:31151835,31146760:31147092,31146761:31147130,31146762:31151873,31146763:31151910,31146764:31151944,31146765:31147172,31146766:31147206,31146767:31147243,31146768:31147279,31146769:31147320,31146770:31147349,31146771:31147397,31146772:31147428,31146773:31147476,31146774:31147503,31146775:31147585,31146927:31175756,31146928:31175793,31146935:31150914,31146936:31150952,31146937:31150989,31146938:31151026,31146939:31151053,31146940:31151099,31146941:31151142,31146942:31151176,31146943:31153646,31146944:31151214,31146945:31151258,31146946:31151294,31146947:31151331,31146948:3115136', 'assoc_mat': '31141458:pet_clair:4230:31141487,31141670:pet_clair:4230:31141698,31141920:pet_clair:4230:31142317,31142099:pet_clair:4230:31142127,31142550:pet_clair:4230:31142586,31142551:pet_clair:4230:31142621,31142881:pet_clair:4230:31142948,31143278:pet_clair:4230:31143381,31143279:pet_clair:4230:31143422,31143714:pet_clair:4230:31143937,31143715:pet_clair:4230:31143904,31144159:pet_clair:4230:31144355,31144160:pet_clair:4230:31144391,31144161:pet_clair:4230:31144440,31144162:pet_clair:4230:31144513,31144869:pet_clair:4230:31145542,31144871:pet_clair:4230:31145901,31144872:pet_clair:4230:31145864,31146752:pet_clair:4230:31146977,31146753:pet_clair:4230:31147004,31146755:pet_clair:4230:31156445,31146756:pet_clair:4230:31147051,31146757:pet_clair:4230:31151796,31146758:pet_clair:4230:31156411,31146759:pet_clair:4230:31151835,31146760:pet_clair:4230:31147092,31146761:pet_clair:4230:31147130,31146762:pet_clair:4230:31151873,31146763:pet_clair:4230:31151910,31146764:pet_clair:4230:31151944,31146765:pet_clair:4230:31147172,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018495989388387045, 'nb_photo': 923, 'list_port_cont': '31141484,31141696,31142121,31142312,31142939,31143414,31143948,31144368,31144505,31145541,31145899,31147159,31147207,31147237,31147275,31147353,31147400,31147513,31147577,31151023,31151166,31151256,31151293,31151327,31151443,31151486,31151533,31151570,31151614,31151685,31151797,31151899,31151950,31152039,31152266,31154564,31154640,31154682,31154755,31154809,31154844,31154882,31154917,31154961,31154994,31155082,31156403,31157601,31157662,31157709,31157829,31158120,31158163,31160353,31160438,31160544,31160621,31160701,31160808,31160849,31160892,31160927,31162776,31163288,31163576,31163609,31163647,31163679,31163720,31163752,31163858,31163933,31163967,31164044,31164115,31165786,31165818,31165893,31166375,31166414,31166496,31166753,31166784,31167002,31167076,31167118,31169299,31169568,31169638,31171402,31171433,31171600,31171672,31171707,31173387,31173605,31173639,31173671,31173755,31173874,31173913,31173945,31173983,31174057,31176003,31176059,31176124,31176166,31176197,31176238,31176804,31176915,31176952,3117698', 'assoc_port': '31141458:31141484,31141670:31141696,31141920:31142312,31142099:31142121,31142881:31142939,31143279:31143414,31143714:31143948,31144159:31144368,31144162:31144505,31144869:31145541,31144871:31145899,31146757:31151797,31146758:31156403,31146763:31151899,31146764:31151950,31146765:31147159,31146766:31147207,31146767:31147237,31146768:31147275,31146770:31147353,31146771:31147400,31146774:31147513,31146775:31147577,31146938:31151023,31146942:31151166,31146945:31151256,31146946:31151293,31146947:31151327,31146950:31151443,31146951:31151486,31146952:31151533,31146953:31151570,31146954:31151614,31146956:31151685,31148212:31152039,31148216:31152266,31152842:31179107,31152880:31179152,31152881:31179229,31152883:31179296,31152884:31179334,31152885:31179371,31152886:31179409,31152887:31179449,31152888:31179490,31152889:31179518,31152890:31179562,31152892:31179635,31152893:31179667,31152894:31179739,31152895:31179705,31153808:31176003,31153812:31154564,31153813:31154640,31153815:31154682,31153817:31154755,31153818:3115480', 'assoc_mat': '31141458:pet_fonce:4230:31141484,31141670:pet_fonce:4230:31141696,31141920:pet_fonce:4230:31142312,31142099:pet_fonce:4230:31142121,31142881:pet_fonce:4230:31142939,31143279:pet_fonce:4230:31143414,31143714:pet_fonce:4230:31143948,31144159:pet_fonce:4230:31144368,31144162:pet_fonce:4230:31144505,31144869:pet_fonce:4230:31145541,31144871:pet_fonce:4230:31145899,31146757:pet_fonce:4230:31151797,31146758:pet_fonce:4230:31156403,31146763:pet_fonce:4230:31151899,31146764:pet_fonce:4230:31151950,31146765:pet_fonce:4230:31147159,31146766:pet_fonce:4230:31147207,31146767:pet_fonce:4230:31147237,31146768:pet_fonce:4230:31147275,31146770:pet_fonce:4230:31147353,31146771:pet_fonce:4230:31147400,31146774:pet_fonce:4230:31147513,31146775:pet_fonce:4230:31147577,31146938:pet_fonce:4230:31151023,31146942:pet_fonce:4230:31151166,31146945:pet_fonce:4230:31151256,31146946:pet_fonce:4230:31151293,31146947:pet_fonce:4230:31151327,31146950:pet_fonce:4230:31151443,31146951:pet_fonce:4230:31151486,31146952:pet_fonce:4230:31151533,3'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(3000946,2996358,2996310,3001668,3001178,2997660,2998110,2998634,2999160,2999788,3000332,3000774,3001286,3001822,3002428,3002770,3003138,3003564,3004096,3004254)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31196998, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141485,31141695,31142125,31142319,31142574,31142624,31142949,31143371,31143413,31143911,31143939,31144353,31144390,31144435,31144512,31145543,31145866,31145894,31146964,31147013,31147046,31147090,31147118,31147169,31147198,31147245,31147272,31147324,31147347,31147384,31147432,31147468,31147497,31147576,31150916,31150944,31150981,31151015,31151069,31151101,31151128,31151177,31151222,31151252,31151280,31151318,31151369,31151405,31151441,31151477,31151535,31151569,31151604,31151679,31151720,31151786,31151824,31151872,31151909,31151949,31152049,31152084,31152113,31152156,31152200,31152258,31153636,31153699,31154524,31154557,31154593,31154641,31154675,31154708,31154762,31154798,31154830,31154879,31154910,31154944,31154998,31155023,31155070,31156399,31156449,31157600,31157626,31157671,31157708,31157741,31157790,31157819,31157858,31157895,31157938,31157960,31158002,31158041,31158083,31158126,31158160,31160355,31160394,31160433,31160465,31160514,31160546,31160580,31160626,31160651,31160691,31160737,31160773,3116080 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31196999, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141486,31141701,31142129,31142316,31142581,31142618,31142952,31143384,31143421,31143906,31143946,31144366,31144400,31144434,31144514,31145539,31145863,31145900,31146973,31147003,31147044,31147088,31147123,31147174,31147202,31147247,31147285,31147315,31147356,31147390,31147431,31147472,31147514,31147579,31150909,31150947,31150976,31151028,31151064,31151090,31151145,31151179,31151220,31151250,31151282,31151328,31151364,31151397,31151439,31151476,31151532,31151573,31151608,31151686,31151729,31151792,31151823,31151875,31151904,31151941,31152046,31152073,31152123,31152154,31152196,31152273,31153635,31153701,31154525,31154566,31154606,31154646,31154679,31154716,31154748,31154810,31154843,31154876,31154925,31154955,31154996,31155030,31155086,31156410,31156455,31157599,31157638,31157666,31157717,31157751,31157784,31157818,31157859,31157896,31157930,31157975,31158010,31158052,31158085,31158128,31158156,31160367,31160405,31160443,31160476,31160515,31160554,31160590,31160629,31160665,31160686,31160735,31160775,3116080 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197000, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31142118,31143908,31143943,31144357,31144399,31144497,31145532,31145905,31146979,31147124,31147173,31147200,31147233,31147270,31147319,31147355,31147383,31147436,31147473,31147501,31147587,31150917,31150940,31150984,31151027,31151057,31151098,31151144,31151216,31151291,31151319,31151367,31151436,31151473,31151537,31151559,31151602,31151673,31151714,31151789,31151836,31151907,31151936,31152044,31152082,31152111,31152149,31152194,31152261,31153640,31153691,31154531,31154561,31154678,31154712,31154759,31154794,31154842,31154871,31154923,31154945,31154990,31155040,31155085,31156398,31156444,31157598,31157637,31157677,31157707,31157783,31157863,31157891,31158081,31158155,31160364,31160400,31160428,31160477,31160553,31160575,31160699,31160739,31160766,31160807,31160843,31160888,31160928,31162707,31162734,31162783,31162865,31163316,31163384,31163525,31163677,31163708,31163748,31163792,31163865,31163934,31163961,31163993,31164040,31165826,31165855,31166565,31166669,31166713,31166741,31166786,31166891,31166937,3116699 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197001, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141472,31141692,31142124,31142320,31142585,31142623,31142951,31143386,31143417,31143903,31143945,31144365,31144398,31144430,31144511,31145544,31145867,31145902,31146974,31147010,31147057,31147093,31147127,31147168,31147211,31147240,31147281,31147322,31147359,31147393,31147433,31147474,31147512,31147586,31150908,31150954,31150980,31151017,31151060,31151096,31151139,31151172,31151218,31151253,31151289,31151330,31151354,31151404,31151445,31151484,31151530,31151567,31151615,31151690,31151730,31151793,31151833,31151864,31151913,31151948,31152040,31152076,31152124,31152164,31152202,31152271,31153647,31153702,31154536,31154571,31154608,31154637,31154685,31154719,31154756,31154802,31154839,31154880,31154918,31154951,31154989,31155032,31155087,31156414,31156453,31157595,31157640,31157678,31157703,31157749,31157788,31157828,31157865,31157902,31157936,31157974,31158011,31158050,31158077,31158124,31158169,31160366,31160407,31160436,31160472,31160505,31160556,31160588,31160623,31160663,31160698,31160734,31160771,3116080 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197002, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31142117,31142616,31143410,31143912,31143944,31144363,31144507,31145538,31145908,31146976,31147122,31147171,31147210,31147242,31147280,31147392,31147435,31147467,31147573,31150988,31151029,31151066,31151135,31151180,31151219,31151257,31151285,31151329,31151366,31151408,31151440,31151481,31151538,31151609,31151681,31151831,31151865,31151912,31151947,31152045,31152083,31152161,31152192,31152269,31153645,31154684,31154717,31154753,31154805,31154846,31154878,31154921,31154949,31154999,31155025,31155073,31156413,31160480,31160509,31160545,31160625,31160657,31160696,31160732,31160887,31161032,31162700,31162740,31162817,31163285,31163322,31163500,31163604,31163650,31163683,31163794,31163861,31163896,31163928,31163966,31164005,31164039,31165861,31165889,31166608,31166641,31166676,31166787,31166828,31167003,31169416,31169487,31169527,31169566,31169603,31171083,31171401,31171546,31171592,31171633,31171664,31171708,31171779,31173228,31173274,31173310,31173350,31173385,31173411,31173452,31173500,31173535,31173564,3117360 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197003, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141487,31141698,31142127,31142317,31142586,31142621,31142948,31143381,31143422,31143904,31143937,31144355,31144391,31144440,31144513,31145542,31145864,31145901,31146977,31147004,31147051,31147092,31147130,31147172,31147206,31147243,31147279,31147320,31147349,31147397,31147428,31147476,31147503,31147585,31150914,31150952,31150989,31151026,31151053,31151099,31151142,31151176,31151214,31151258,31151294,31151331,31151362,31151395,31151444,31151487,31151536,31151566,31151601,31151688,31151721,31151796,31151835,31151873,31151910,31151944,31152047,31152078,31152120,31152151,31152198,31152270,31153646,31153694,31154530,31154572,31154607,31154645,31154681,31154713,31154758,31154801,31154847,31154884,31154924,31154953,31155001,31155039,31155084,31156411,31156445,31157593,31157635,31157672,31157715,31157746,31157786,31157822,31157857,31157901,31157935,31157965,31158009,31158053,31158087,31158130,31158168,31160362,31160398,31160444,31160473,31160513,31160551,31160592,31160627,31160658,31160692,31160741,31160772,3116079 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197004, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141484,31141696,31142121,31142312,31142939,31143414,31143948,31144368,31144505,31145541,31145899,31147159,31147207,31147237,31147275,31147353,31147400,31147513,31147577,31151023,31151166,31151256,31151293,31151327,31151443,31151486,31151533,31151570,31151614,31151685,31151797,31151899,31151950,31152039,31152266,31154564,31154640,31154682,31154755,31154809,31154844,31154882,31154917,31154961,31154994,31155082,31156403,31157601,31157662,31157709,31157829,31158120,31158163,31160353,31160438,31160544,31160621,31160701,31160808,31160849,31160892,31160927,31162776,31163288,31163576,31163609,31163647,31163679,31163720,31163752,31163858,31163933,31163967,31164044,31164115,31165786,31165818,31165893,31166375,31166414,31166496,31166753,31166784,31167002,31167076,31167118,31169299,31169568,31169638,31171402,31171433,31171600,31171672,31171707,31173387,31173605,31173639,31173671,31173755,31173874,31173913,31173945,31173983,31174057,31176003,31176059,31176124,31176166,31176197,31176238,31176804,31176915,31176952,3117698 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31196998,31196999,31197000,31197001,31197002,31197003,31197004?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-06-01' and date <= '2026-06-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1098,),), 'unwanted_material_monthly_percentage': ((0.7878335676753392,),), 'material_repartition': (('incineration', 1095),), 'material_dict': {'incineration': 1095}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 6, 1), 0.7805386554144761, 2), (datetime.date(2026, 6, 10), 0.7623513548540927, 2), (datetime.date(2026, 6, 11), 0.7776082786828711, 1), (datetime.date(2026, 6, 12), 0.7615411283210718, 3), (datetime.date(2026, 6, 13), 0.7262019540337863, 2), (datetime.date(2026, 6, 14), 0.8275846991390845, 2), (datetime.date(2026, 6, 15), 0.8047624299670847, 3), (datetime.date(2026, 6, 16), 0.7942823093237922, 3), (datetime.date(2026, 6, 17), 0.8289409493297756, 3), (datetime.date(2026, 6, 18), 0.8141803235838798, 2), (datetime.date(2026, 6, 19), 0.8112940428499074, 4), (datetime.date(2026, 6, 20), 0.7546239456803474, 2), (datetime.date(2026, 6, 21), 0.8430071078079783, 1), (datetime.date(2026, 6, 22), 0.8439434900476124, 2), (datetime.date(2026, 6, 23), 0.8461396555581235, 3), (datetime.date(2026, 6, 24), 0.7646940103794583, 3), (datetime.date(2026, 6, 25), 0.7628949765142797, 4), (datetime.date(2026, 6, 26), 0.755289057766601, 2), (datetime.date(2026, 6, 27), 0.7281418594356759, 3), (datetime.date(2026, 6, 28), 0.7631655969501516, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 6, 1), 0.7805386554144761, 2), (datetime.date(2026, 6, 10), 0.7623513548540927, 2), (datetime.date(2026, 6, 11), 0.7776082786828711, 1), (datetime.date(2026, 6, 12), 0.7615411283210718, 3), (datetime.date(2026, 6, 13), 0.7262019540337863, 2), (datetime.date(2026, 6, 14), 0.8275846991390845, 2), (datetime.date(2026, 6, 15), 0.8047624299670847, 3), (datetime.date(2026, 6, 16), 0.7942823093237922, 3), (datetime.date(2026, 6, 17), 0.8289409493297756, 3), (datetime.date(2026, 6, 18), 0.8141803235838798, 2), (datetime.date(2026, 6, 19), 0.8112940428499074, 4), (datetime.date(2026, 6, 20), 0.7546239456803474, 2), (datetime.date(2026, 6, 21), 0.8430071078079783, 1), (datetime.date(2026, 6, 22), 0.8439434900476124, 2), (datetime.date(2026, 6, 23), 0.8461396555581235, 3), (datetime.date(2026, 6, 24), 0.7646940103794583, 3), (datetime.date(2026, 6, 25), 0.7628949765142797, 4), (datetime.date(2026, 6, 26), 0.755289057766601, 2), (datetime.date(2026, 6, 27), 0.7281418594356759, 3), (datetime.date(2026, 6, 28), 0.7631655969501516, 3))}, 'quality_array': [['-7.940956779812399', '01062026'], ['-8.10815127385505', '10062026'], ['-8.306654281644446', '11062026'], ['-8.335800106824927', '12062026'], ['-8.046560122643143', '13062026'], ['-7.521127209710982', '14062026'], ['-7.088214464901664', '15062026'], ['-7.505461972564141', '16062026'], ['-7.46007215837358', '17062026'], ['-7.092825866049265', '18062026'], ['-7.668499093542793', '19062026'], ['-7.619706442709475', '20062026'], ['-7.6990424142689875', '21062026'], ['-7.378229538920456', '22062026'], ['-7.049570997903963', '23062026'], ['-7.374473568846001', '24062026'], ['-7.369227454189589', '25062026'], ['-7.311812212865766', '26062026'], ['-7.610516092851808', '27062026'], ['-7.8256622165785625', '28062026']], 'number_of_batch': ((426,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013785055530350221, 'nb_photo': 20435, 'list_port_cont': '31141485,31141695,31142125,31142319,31142574,31142624,31142949,31143371,31143413,31143911,31143939,31144353,31144390,31144435,31144512,31145543,31145866,31145894,31146964,31147013,31147046,31147090,31147118,31147169,31147198,31147245,31147272,31147324,31147347,31147384,31147432,31147468,31147497,31147576,31150916,31150944,31150981,31151015,31151069,31151101,31151128,31151177,31151222,31151252,31151280,31151318,31151369,31151405,31151441,31151477,31151535,31151569,31151604,31151679,31151720,31151786,31151824,31151872,31151909,31151949,31152049,31152084,31152113,31152156,31152200,31152258,31153636,31153699,31154524,31154557,31154593,31154641,31154675,31154708,31154762,31154798,31154830,31154879,31154910,31154944,31154998,31155023,31155070,31156399,31156449,31157600,31157626,31157671,31157708,31157741,31157790,31157819,31157858,31157895,31157938,31157960,31158002,31158041,31158083,31158126,31158160,31160355,31160394,31160433,31160465,31160514,31160546,31160580,31160626,31160651,31160691,31160737,31160773,3116080', 'assoc_port': '31141458:31141485,31141670:31141695,31141920:31142319,31142099:31142125,31142550:31142574,31142551:31142624,31142881:31142949,31143278:31143371,31143279:31143413,31143714:31143939,31143715:31143911,31144159:31144353,31144160:31144390,31144161:31144435,31144162:31144512,31144869:31145543,31144871:31145894,31144872:31145866,31146752:31146964,31146753:31147013,31146755:31156449,31146756:31147046,31146757:31151786,31146758:31156399,31146759:31151824,31146760:31147090,31146761:31147118,31146762:31151872,31146763:31151909,31146764:31151949,31146765:31147169,31146766:31147198,31146767:31147245,31146768:31147272,31146769:31147324,31146770:31147347,31146771:31147384,31146772:31147432,31146773:31147468,31146774:31147497,31146775:31147576,31146927:31175752,31146928:31175797,31146935:31150916,31146936:31150944,31146937:31150981,31146938:31151015,31146939:31151069,31146940:31151101,31146941:31151128,31146942:31151177,31146943:31153636,31146944:31151222,31146945:31151252,31146946:31151280,31146947:31151318,31146948:3115136', 'assoc_mat': '31141458:autre:4230:31141485,31141670:autre:4230:31141695,31141920:autre:4230:31142319,31142099:autre:4230:31142125,31142550:autre:4230:31142574,31142551:autre:4230:31142624,31142881:autre:4230:31142949,31143278:autre:4230:31143371,31143279:autre:4230:31143413,31143714:autre:4230:31143939,31143715:autre:4230:31143911,31144159:autre:4230:31144353,31144160:autre:4230:31144390,31144161:autre:4230:31144435,31144162:autre:4230:31144512,31144869:autre:4230:31145543,31144871:autre:4230:31145894,31144872:autre:4230:31145866,31146752:autre:4230:31146964,31146753:autre:4230:31147013,31146755:autre:4230:31156449,31146756:autre:4230:31147046,31146757:autre:4230:31151786,31146758:autre:4230:31156399,31146759:autre:4230:31151824,31146760:autre:4230:31147090,31146761:autre:4230:31147118,31146762:autre:4230:31151872,31146763:autre:4230:31151909,31146764:autre:4230:31151949,31146765:autre:4230:31147169,31146766:autre:4230:31147198,31146767:autre:4230:31147245,31146768:autre:4230:31147272,31146769:autre:4230:31147324,31146770:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03691127350529296, 'nb_photo': 88612, 'list_port_cont': '31141486,31141701,31142129,31142316,31142581,31142618,31142952,31143384,31143421,31143906,31143946,31144366,31144400,31144434,31144514,31145539,31145863,31145900,31146973,31147003,31147044,31147088,31147123,31147174,31147202,31147247,31147285,31147315,31147356,31147390,31147431,31147472,31147514,31147579,31150909,31150947,31150976,31151028,31151064,31151090,31151145,31151179,31151220,31151250,31151282,31151328,31151364,31151397,31151439,31151476,31151532,31151573,31151608,31151686,31151729,31151792,31151823,31151875,31151904,31151941,31152046,31152073,31152123,31152154,31152196,31152273,31153635,31153701,31154525,31154566,31154606,31154646,31154679,31154716,31154748,31154810,31154843,31154876,31154925,31154955,31154996,31155030,31155086,31156410,31156455,31157599,31157638,31157666,31157717,31157751,31157784,31157818,31157859,31157896,31157930,31157975,31158010,31158052,31158085,31158128,31158156,31160367,31160405,31160443,31160476,31160515,31160554,31160590,31160629,31160665,31160686,31160735,31160775,3116080', 'assoc_port': '31141458:31141486,31141670:31141701,31141920:31142316,31142099:31142129,31142550:31142581,31142551:31142618,31142881:31142952,31143278:31143384,31143279:31143421,31143714:31143946,31143715:31143906,31144159:31144366,31144160:31144400,31144161:31144434,31144162:31144514,31144869:31145539,31144871:31145900,31144872:31145863,31146752:31146973,31146753:31147003,31146755:31156455,31146756:31147044,31146757:31151792,31146758:31156410,31146759:31151823,31146760:31147088,31146761:31147123,31146762:31151875,31146763:31151904,31146764:31151941,31146765:31147174,31146766:31147202,31146767:31147247,31146768:31147285,31146769:31147315,31146770:31147356,31146771:31147390,31146772:31147431,31146773:31147472,31146774:31147514,31146775:31147579,31146927:31175758,31146928:31175794,31146935:31150909,31146936:31150947,31146937:31150976,31146938:31151028,31146939:31151064,31146940:31151090,31146941:31151145,31146942:31151179,31146943:31153635,31146944:31151220,31146945:31151250,31146946:31151282,31146947:31151328,31146948:3115136', 'assoc_mat': '31141458:carton:4230:31141486,31141670:carton:4230:31141701,31141920:carton:4230:31142316,31142099:carton:4230:31142129,31142550:carton:4230:31142581,31142551:carton:4230:31142618,31142881:carton:4230:31142952,31143278:carton:4230:31143384,31143279:carton:4230:31143421,31143714:carton:4230:31143946,31143715:carton:4230:31143906,31144159:carton:4230:31144366,31144160:carton:4230:31144400,31144161:carton:4230:31144434,31144162:carton:4230:31144514,31144869:carton:4230:31145539,31144871:carton:4230:31145900,31144872:carton:4230:31145863,31146752:carton:4230:31146973,31146753:carton:4230:31147003,31146755:carton:4230:31156455,31146756:carton:4230:31147044,31146757:carton:4230:31151792,31146758:carton:4230:31156410,31146759:carton:4230:31151823,31146760:carton:4230:31147088,31146761:carton:4230:31147123,31146762:carton:4230:31151875,31146763:carton:4230:31151904,31146764:carton:4230:31151941,31146765:carton:4230:31147174,31146766:carton:4230:31147202,31146767:carton:4230:31147247,31146768:carton:4230:31147285,3114'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012734899793404027, 'nb_photo': 1971, 'list_port_cont': '31142118,31143908,31143943,31144357,31144399,31144497,31145532,31145905,31146979,31147124,31147173,31147200,31147233,31147270,31147319,31147355,31147383,31147436,31147473,31147501,31147587,31150917,31150940,31150984,31151027,31151057,31151098,31151144,31151216,31151291,31151319,31151367,31151436,31151473,31151537,31151559,31151602,31151673,31151714,31151789,31151836,31151907,31151936,31152044,31152082,31152111,31152149,31152194,31152261,31153640,31153691,31154531,31154561,31154678,31154712,31154759,31154794,31154842,31154871,31154923,31154945,31154990,31155040,31155085,31156398,31156444,31157598,31157637,31157677,31157707,31157783,31157863,31157891,31158081,31158155,31160364,31160400,31160428,31160477,31160553,31160575,31160699,31160739,31160766,31160807,31160843,31160888,31160928,31162707,31162734,31162783,31162865,31163316,31163384,31163525,31163677,31163708,31163748,31163792,31163865,31163934,31163961,31163993,31164040,31165826,31165855,31166565,31166669,31166713,31166741,31166786,31166891,31166937,3116699', 'assoc_port': '31142099:31142118,31143714:31143943,31143715:31143908,31144159:31144357,31144160:31144399,31144162:31144497,31144869:31145532,31144871:31145905,31146752:31146979,31146755:31156444,31146757:31151789,31146758:31156398,31146759:31151836,31146761:31147124,31146763:31151907,31146764:31151936,31146765:31147173,31146766:31147200,31146767:31147233,31146768:31147270,31146769:31147319,31146770:31147355,31146771:31147383,31146772:31147436,31146773:31147473,31146774:31147501,31146775:31147587,31146935:31150917,31146936:31150940,31146937:31150984,31146938:31151027,31146939:31151057,31146940:31151098,31146941:31151144,31146943:31153640,31146944:31151216,31146946:31151291,31146947:31151319,31146948:31151367,31146950:31151436,31146951:31151473,31146952:31151537,31146953:31151559,31146954:31151602,31146956:31151673,31146957:31151714,31146958:31153691,31148212:31152044,31148213:31152082,31148214:31152111,31148215:31152149,31148216:31152261,31148217:31152194,31152842:31179120,31152880:31179153,31152881:31179218,31152882:3117925', 'assoc_mat': '31142099:metal:4230:31142118,31143714:metal:4230:31143943,31143715:metal:4230:31143908,31144159:metal:4230:31144357,31144160:metal:4230:31144399,31144162:metal:4230:31144497,31144869:metal:4230:31145532,31144871:metal:4230:31145905,31146752:metal:4230:31146979,31146755:metal:4230:31156444,31146757:metal:4230:31151789,31146758:metal:4230:31156398,31146759:metal:4230:31151836,31146761:metal:4230:31147124,31146763:metal:4230:31151907,31146764:metal:4230:31151936,31146765:metal:4230:31147173,31146766:metal:4230:31147200,31146767:metal:4230:31147233,31146768:metal:4230:31147270,31146769:metal:4230:31147319,31146770:metal:4230:31147355,31146771:metal:4230:31147383,31146772:metal:4230:31147436,31146773:metal:4230:31147473,31146774:metal:4230:31147501,31146775:metal:4230:31147587,31146935:metal:4230:31150917,31146936:metal:4230:31150940,31146937:metal:4230:31150984,31146938:metal:4230:31151027,31146939:metal:4230:31151057,31146940:metal:4230:31151098,31146941:metal:4230:31151144,31146943:metal:4230:31153640,31146944:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.172187789881647, 'nb_photo': 548040, 'list_port_cont': '31141472,31141692,31142124,31142320,31142585,31142623,31142951,31143386,31143417,31143903,31143945,31144365,31144398,31144430,31144511,31145544,31145867,31145902,31146974,31147010,31147057,31147093,31147127,31147168,31147211,31147240,31147281,31147322,31147359,31147393,31147433,31147474,31147512,31147586,31150908,31150954,31150980,31151017,31151060,31151096,31151139,31151172,31151218,31151253,31151289,31151330,31151354,31151404,31151445,31151484,31151530,31151567,31151615,31151690,31151730,31151793,31151833,31151864,31151913,31151948,31152040,31152076,31152124,31152164,31152202,31152271,31153647,31153702,31154536,31154571,31154608,31154637,31154685,31154719,31154756,31154802,31154839,31154880,31154918,31154951,31154989,31155032,31155087,31156414,31156453,31157595,31157640,31157678,31157703,31157749,31157788,31157828,31157865,31157902,31157936,31157974,31158011,31158050,31158077,31158124,31158169,31160366,31160407,31160436,31160472,31160505,31160556,31160588,31160623,31160663,31160698,31160734,31160771,3116080', 'assoc_port': '31141458:31141472,31141670:31141692,31141920:31142320,31142099:31142124,31142550:31142585,31142551:31142623,31142881:31142951,31143278:31143386,31143279:31143417,31143714:31143945,31143715:31143903,31144159:31144365,31144160:31144398,31144161:31144430,31144162:31144511,31144869:31145544,31144871:31145902,31144872:31145867,31146752:31146974,31146753:31147010,31146755:31156453,31146756:31147057,31146757:31151793,31146758:31156414,31146759:31151833,31146760:31147093,31146761:31147127,31146762:31151864,31146763:31151913,31146764:31151948,31146765:31147168,31146766:31147211,31146767:31147240,31146768:31147281,31146769:31147322,31146770:31147359,31146771:31147393,31146772:31147433,31146773:31147474,31146774:31147512,31146775:31147586,31146927:31175759,31146928:31175789,31146935:31150908,31146936:31150954,31146937:31150980,31146938:31151017,31146939:31151060,31146940:31151096,31146941:31151139,31146942:31151172,31146943:31153647,31146944:31151218,31146945:31151253,31146946:31151289,31146947:31151330,31146948:3115135', 'assoc_mat': '31141458:papier:4230:31141472,31141670:papier:4230:31141692,31141920:papier:4230:31142320,31142099:papier:4230:31142124,31142550:papier:4230:31142585,31142551:papier:4230:31142623,31142881:papier:4230:31142951,31143278:papier:4230:31143386,31143279:papier:4230:31143417,31143714:papier:4230:31143945,31143715:papier:4230:31143903,31144159:papier:4230:31144365,31144160:papier:4230:31144398,31144161:papier:4230:31144430,31144162:papier:4230:31144511,31144869:papier:4230:31145544,31144871:papier:4230:31145902,31144872:papier:4230:31145867,31146752:papier:4230:31146974,31146753:papier:4230:31147010,31146755:papier:4230:31156453,31146756:papier:4230:31147057,31146757:papier:4230:31151793,31146758:papier:4230:31156414,31146759:papier:4230:31151833,31146760:papier:4230:31147093,31146761:papier:4230:31147127,31146762:papier:4230:31151864,31146763:papier:4230:31151913,31146764:papier:4230:31151948,31146765:papier:4230:31147168,31146766:papier:4230:31147211,31146767:papier:4230:31147240,31146768:papier:4230:31147281,3114'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0035226340105312644, 'nb_photo': 1946, 'list_port_cont': '31142117,31142616,31143410,31143912,31143944,31144363,31144507,31145538,31145908,31146976,31147122,31147171,31147210,31147242,31147280,31147392,31147435,31147467,31147573,31150988,31151029,31151066,31151135,31151180,31151219,31151257,31151285,31151329,31151366,31151408,31151440,31151481,31151538,31151609,31151681,31151831,31151865,31151912,31151947,31152045,31152083,31152161,31152192,31152269,31153645,31154684,31154717,31154753,31154805,31154846,31154878,31154921,31154949,31154999,31155025,31155073,31156413,31160480,31160509,31160545,31160625,31160657,31160696,31160732,31160887,31161032,31162700,31162740,31162817,31163285,31163322,31163500,31163604,31163650,31163683,31163794,31163861,31163896,31163928,31163966,31164005,31164039,31165861,31165889,31166608,31166641,31166676,31166787,31166828,31167003,31169416,31169487,31169527,31169566,31169603,31171083,31171401,31171546,31171592,31171633,31171664,31171708,31171779,31173228,31173274,31173310,31173350,31173385,31173411,31173452,31173500,31173535,31173564,3117360', 'assoc_port': '31142099:31142117,31142551:31142616,31143279:31143410,31143714:31143944,31143715:31143912,31144159:31144363,31144162:31144507,31144869:31145538,31144871:31145908,31146752:31146976,31146758:31156413,31146759:31151831,31146761:31147122,31146762:31151865,31146763:31151912,31146764:31151947,31146765:31147171,31146766:31147210,31146767:31147242,31146768:31147280,31146771:31147392,31146772:31147435,31146773:31147467,31146775:31147573,31146927:31175753,31146928:31175796,31146937:31150988,31146938:31151029,31146939:31151066,31146941:31151135,31146942:31151180,31146943:31153645,31146944:31151219,31146945:31151257,31146946:31151285,31146947:31151329,31146948:31151366,31146949:31151408,31146950:31151440,31146951:31151481,31146952:31151538,31146954:31151609,31146956:31151681,31148212:31152045,31148213:31152083,31148215:31152161,31148216:31152269,31148217:31152192,31152842:31179110,31152879:31179182,31152880:31179151,31152881:31179231,31152883:31179303,31152884:31179338,31152885:31179370,31152886:31179410,31152887:3117945', 'assoc_mat': '31142099:pehd:4230:31142117,31142551:pehd:4230:31142616,31143279:pehd:4230:31143410,31143714:pehd:4230:31143944,31143715:pehd:4230:31143912,31144159:pehd:4230:31144363,31144162:pehd:4230:31144507,31144869:pehd:4230:31145538,31144871:pehd:4230:31145908,31146752:pehd:4230:31146976,31146758:pehd:4230:31156413,31146759:pehd:4230:31151831,31146761:pehd:4230:31147122,31146762:pehd:4230:31151865,31146763:pehd:4230:31151912,31146764:pehd:4230:31151947,31146765:pehd:4230:31147171,31146766:pehd:4230:31147210,31146767:pehd:4230:31147242,31146768:pehd:4230:31147280,31146771:pehd:4230:31147392,31146772:pehd:4230:31147435,31146773:pehd:4230:31147467,31146775:pehd:4230:31147573,31146927:pehd:4230:31175753,31146928:pehd:4230:31175796,31146937:pehd:4230:31150988,31146938:pehd:4230:31151029,31146939:pehd:4230:31151066,31146941:pehd:4230:31151135,31146942:pehd:4230:31151180,31146943:pehd:4230:31153645,31146944:pehd:4230:31151219,31146945:pehd:4230:31151257,31146946:pehd:4230:31151285,31146947:pehd:4230:31151329,31146948:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017948749129603772, 'nb_photo': 32350, 'list_port_cont': '31141487,31141698,31142127,31142317,31142586,31142621,31142948,31143381,31143422,31143904,31143937,31144355,31144391,31144440,31144513,31145542,31145864,31145901,31146977,31147004,31147051,31147092,31147130,31147172,31147206,31147243,31147279,31147320,31147349,31147397,31147428,31147476,31147503,31147585,31150914,31150952,31150989,31151026,31151053,31151099,31151142,31151176,31151214,31151258,31151294,31151331,31151362,31151395,31151444,31151487,31151536,31151566,31151601,31151688,31151721,31151796,31151835,31151873,31151910,31151944,31152047,31152078,31152120,31152151,31152198,31152270,31153646,31153694,31154530,31154572,31154607,31154645,31154681,31154713,31154758,31154801,31154847,31154884,31154924,31154953,31155001,31155039,31155084,31156411,31156445,31157593,31157635,31157672,31157715,31157746,31157786,31157822,31157857,31157901,31157935,31157965,31158009,31158053,31158087,31158130,31158168,31160362,31160398,31160444,31160473,31160513,31160551,31160592,31160627,31160658,31160692,31160741,31160772,3116079', 'assoc_port': '31141458:31141487,31141670:31141698,31141920:31142317,31142099:31142127,31142550:31142586,31142551:31142621,31142881:31142948,31143278:31143381,31143279:31143422,31143714:31143937,31143715:31143904,31144159:31144355,31144160:31144391,31144161:31144440,31144162:31144513,31144869:31145542,31144871:31145901,31144872:31145864,31146752:31146977,31146753:31147004,31146755:31156445,31146756:31147051,31146757:31151796,31146758:31156411,31146759:31151835,31146760:31147092,31146761:31147130,31146762:31151873,31146763:31151910,31146764:31151944,31146765:31147172,31146766:31147206,31146767:31147243,31146768:31147279,31146769:31147320,31146770:31147349,31146771:31147397,31146772:31147428,31146773:31147476,31146774:31147503,31146775:31147585,31146927:31175756,31146928:31175793,31146935:31150914,31146936:31150952,31146937:31150989,31146938:31151026,31146939:31151053,31146940:31151099,31146941:31151142,31146942:31151176,31146943:31153646,31146944:31151214,31146945:31151258,31146946:31151294,31146947:31151331,31146948:3115136', 'assoc_mat': '31141458:pet_clair:4230:31141487,31141670:pet_clair:4230:31141698,31141920:pet_clair:4230:31142317,31142099:pet_clair:4230:31142127,31142550:pet_clair:4230:31142586,31142551:pet_clair:4230:31142621,31142881:pet_clair:4230:31142948,31143278:pet_clair:4230:31143381,31143279:pet_clair:4230:31143422,31143714:pet_clair:4230:31143937,31143715:pet_clair:4230:31143904,31144159:pet_clair:4230:31144355,31144160:pet_clair:4230:31144391,31144161:pet_clair:4230:31144440,31144162:pet_clair:4230:31144513,31144869:pet_clair:4230:31145542,31144871:pet_clair:4230:31145901,31144872:pet_clair:4230:31145864,31146752:pet_clair:4230:31146977,31146753:pet_clair:4230:31147004,31146755:pet_clair:4230:31156445,31146756:pet_clair:4230:31147051,31146757:pet_clair:4230:31151796,31146758:pet_clair:4230:31156411,31146759:pet_clair:4230:31151835,31146760:pet_clair:4230:31147092,31146761:pet_clair:4230:31147130,31146762:pet_clair:4230:31151873,31146763:pet_clair:4230:31151910,31146764:pet_clair:4230:31151944,31146765:pet_clair:4230:31147172,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018495989388387045, 'nb_photo': 923, 'list_port_cont': '31141484,31141696,31142121,31142312,31142939,31143414,31143948,31144368,31144505,31145541,31145899,31147159,31147207,31147237,31147275,31147353,31147400,31147513,31147577,31151023,31151166,31151256,31151293,31151327,31151443,31151486,31151533,31151570,31151614,31151685,31151797,31151899,31151950,31152039,31152266,31154564,31154640,31154682,31154755,31154809,31154844,31154882,31154917,31154961,31154994,31155082,31156403,31157601,31157662,31157709,31157829,31158120,31158163,31160353,31160438,31160544,31160621,31160701,31160808,31160849,31160892,31160927,31162776,31163288,31163576,31163609,31163647,31163679,31163720,31163752,31163858,31163933,31163967,31164044,31164115,31165786,31165818,31165893,31166375,31166414,31166496,31166753,31166784,31167002,31167076,31167118,31169299,31169568,31169638,31171402,31171433,31171600,31171672,31171707,31173387,31173605,31173639,31173671,31173755,31173874,31173913,31173945,31173983,31174057,31176003,31176059,31176124,31176166,31176197,31176238,31176804,31176915,31176952,3117698', 'assoc_port': '31141458:31141484,31141670:31141696,31141920:31142312,31142099:31142121,31142881:31142939,31143279:31143414,31143714:31143948,31144159:31144368,31144162:31144505,31144869:31145541,31144871:31145899,31146757:31151797,31146758:31156403,31146763:31151899,31146764:31151950,31146765:31147159,31146766:31147207,31146767:31147237,31146768:31147275,31146770:31147353,31146771:31147400,31146774:31147513,31146775:31147577,31146938:31151023,31146942:31151166,31146945:31151256,31146946:31151293,31146947:31151327,31146950:31151443,31146951:31151486,31146952:31151533,31146953:31151570,31146954:31151614,31146956:31151685,31148212:31152039,31148216:31152266,31152842:31179107,31152880:31179152,31152881:31179229,31152883:31179296,31152884:31179334,31152885:31179371,31152886:31179409,31152887:31179449,31152888:31179490,31152889:31179518,31152890:31179562,31152892:31179635,31152893:31179667,31152894:31179739,31152895:31179705,31153808:31176003,31153812:31154564,31153813:31154640,31153815:31154682,31153817:31154755,31153818:3115480', 'assoc_mat': '31141458:pet_fonce:4230:31141484,31141670:pet_fonce:4230:31141696,31141920:pet_fonce:4230:31142312,31142099:pet_fonce:4230:31142121,31142881:pet_fonce:4230:31142939,31143279:pet_fonce:4230:31143414,31143714:pet_fonce:4230:31143948,31144159:pet_fonce:4230:31144368,31144162:pet_fonce:4230:31144505,31144869:pet_fonce:4230:31145541,31144871:pet_fonce:4230:31145899,31146757:pet_fonce:4230:31151797,31146758:pet_fonce:4230:31156403,31146763:pet_fonce:4230:31151899,31146764:pet_fonce:4230:31151950,31146765:pet_fonce:4230:31147159,31146766:pet_fonce:4230:31147207,31146767:pet_fonce:4230:31147237,31146768:pet_fonce:4230:31147275,31146770:pet_fonce:4230:31147353,31146771:pet_fonce:4230:31147400,31146774:pet_fonce:4230:31147513,31146775:pet_fonce:4230:31147577,31146938:pet_fonce:4230:31151023,31146942:pet_fonce:4230:31151166,31146945:pet_fonce:4230:31151256,31146946:pet_fonce:4230:31151293,31146947:pet_fonce:4230:31151327,31146950:pet_fonce:4230:31151443,31146951:pet_fonce:4230:31151486,31146952:pet_fonce:4230:31151533,3'}), 'main_stat': {'nb_photos': 1098}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31196998,31196999,31197000,31197001,31197002,31197003,31197004?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-06', 0.7878335676753392),)]} 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': ((1098,),), 'unwanted_material_monthly_percentage': ((0.7878335676753392,),), 'material_repartition': (('incineration', 1095),), 'material_dict': {'incineration': 1095}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 6, 1), 0.7805386554144761, 2), (datetime.date(2026, 6, 10), 0.7623513548540927, 2), (datetime.date(2026, 6, 11), 0.7776082786828711, 1), (datetime.date(2026, 6, 12), 0.7615411283210718, 3), (datetime.date(2026, 6, 13), 0.7262019540337863, 2), (datetime.date(2026, 6, 14), 0.8275846991390845, 2), (datetime.date(2026, 6, 15), 0.8047624299670847, 3), (datetime.date(2026, 6, 16), 0.7942823093237922, 3), (datetime.date(2026, 6, 17), 0.8289409493297756, 3), (datetime.date(2026, 6, 18), 0.8141803235838798, 2), (datetime.date(2026, 6, 19), 0.8112940428499074, 4), (datetime.date(2026, 6, 20), 0.7546239456803474, 2), (datetime.date(2026, 6, 21), 0.8430071078079783, 1), (datetime.date(2026, 6, 22), 0.8439434900476124, 2), (datetime.date(2026, 6, 23), 0.8461396555581235, 3), (datetime.date(2026, 6, 24), 0.7646940103794583, 3), (datetime.date(2026, 6, 25), 0.7628949765142797, 4), (datetime.date(2026, 6, 26), 0.755289057766601, 2), (datetime.date(2026, 6, 27), 0.7281418594356759, 3), (datetime.date(2026, 6, 28), 0.7631655969501516, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 6, 1), 0.7805386554144761, 2), (datetime.date(2026, 6, 10), 0.7623513548540927, 2), (datetime.date(2026, 6, 11), 0.7776082786828711, 1), (datetime.date(2026, 6, 12), 0.7615411283210718, 3), (datetime.date(2026, 6, 13), 0.7262019540337863, 2), (datetime.date(2026, 6, 14), 0.8275846991390845, 2), (datetime.date(2026, 6, 15), 0.8047624299670847, 3), (datetime.date(2026, 6, 16), 0.7942823093237922, 3), (datetime.date(2026, 6, 17), 0.8289409493297756, 3), (datetime.date(2026, 6, 18), 0.8141803235838798, 2), (datetime.date(2026, 6, 19), 0.8112940428499074, 4), (datetime.date(2026, 6, 20), 0.7546239456803474, 2), (datetime.date(2026, 6, 21), 0.8430071078079783, 1), (datetime.date(2026, 6, 22), 0.8439434900476124, 2), (datetime.date(2026, 6, 23), 0.8461396555581235, 3), (datetime.date(2026, 6, 24), 0.7646940103794583, 3), (datetime.date(2026, 6, 25), 0.7628949765142797, 4), (datetime.date(2026, 6, 26), 0.755289057766601, 2), (datetime.date(2026, 6, 27), 0.7281418594356759, 3), (datetime.date(2026, 6, 28), 0.7631655969501516, 3))}, 'quality_array': [['-7.940956779812399', '01062026'], ['-8.10815127385505', '10062026'], ['-8.306654281644446', '11062026'], ['-8.335800106824927', '12062026'], ['-8.046560122643143', '13062026'], ['-7.521127209710982', '14062026'], ['-7.088214464901664', '15062026'], ['-7.505461972564141', '16062026'], ['-7.46007215837358', '17062026'], ['-7.092825866049265', '18062026'], ['-7.668499093542793', '19062026'], ['-7.619706442709475', '20062026'], ['-7.6990424142689875', '21062026'], ['-7.378229538920456', '22062026'], ['-7.049570997903963', '23062026'], ['-7.374473568846001', '24062026'], ['-7.369227454189589', '25062026'], ['-7.311812212865766', '26062026'], ['-7.610516092851808', '27062026'], ['-7.8256622165785625', '28062026']], 'number_of_batch': ((426,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013785055530350221, 'nb_photo': 20435, 'list_port_cont': '31141485,31141695,31142125,31142319,31142574,31142624,31142949,31143371,31143413,31143911,31143939,31144353,31144390,31144435,31144512,31145543,31145866,31145894,31146964,31147013,31147046,31147090,31147118,31147169,31147198,31147245,31147272,31147324,31147347,31147384,31147432,31147468,31147497,31147576,31150916,31150944,31150981,31151015,31151069,31151101,31151128,31151177,31151222,31151252,31151280,31151318,31151369,31151405,31151441,31151477,31151535,31151569,31151604,31151679,31151720,31151786,31151824,31151872,31151909,31151949,31152049,31152084,31152113,31152156,31152200,31152258,31153636,31153699,31154524,31154557,31154593,31154641,31154675,31154708,31154762,31154798,31154830,31154879,31154910,31154944,31154998,31155023,31155070,31156399,31156449,31157600,31157626,31157671,31157708,31157741,31157790,31157819,31157858,31157895,31157938,31157960,31158002,31158041,31158083,31158126,31158160,31160355,31160394,31160433,31160465,31160514,31160546,31160580,31160626,31160651,31160691,31160737,31160773,3116080', 'assoc_port': '31141458:31141485,31141670:31141695,31141920:31142319,31142099:31142125,31142550:31142574,31142551:31142624,31142881:31142949,31143278:31143371,31143279:31143413,31143714:31143939,31143715:31143911,31144159:31144353,31144160:31144390,31144161:31144435,31144162:31144512,31144869:31145543,31144871:31145894,31144872:31145866,31146752:31146964,31146753:31147013,31146755:31156449,31146756:31147046,31146757:31151786,31146758:31156399,31146759:31151824,31146760:31147090,31146761:31147118,31146762:31151872,31146763:31151909,31146764:31151949,31146765:31147169,31146766:31147198,31146767:31147245,31146768:31147272,31146769:31147324,31146770:31147347,31146771:31147384,31146772:31147432,31146773:31147468,31146774:31147497,31146775:31147576,31146927:31175752,31146928:31175797,31146935:31150916,31146936:31150944,31146937:31150981,31146938:31151015,31146939:31151069,31146940:31151101,31146941:31151128,31146942:31151177,31146943:31153636,31146944:31151222,31146945:31151252,31146946:31151280,31146947:31151318,31146948:3115136', 'assoc_mat': '31141458:autre:4230:31141485,31141670:autre:4230:31141695,31141920:autre:4230:31142319,31142099:autre:4230:31142125,31142550:autre:4230:31142574,31142551:autre:4230:31142624,31142881:autre:4230:31142949,31143278:autre:4230:31143371,31143279:autre:4230:31143413,31143714:autre:4230:31143939,31143715:autre:4230:31143911,31144159:autre:4230:31144353,31144160:autre:4230:31144390,31144161:autre:4230:31144435,31144162:autre:4230:31144512,31144869:autre:4230:31145543,31144871:autre:4230:31145894,31144872:autre:4230:31145866,31146752:autre:4230:31146964,31146753:autre:4230:31147013,31146755:autre:4230:31156449,31146756:autre:4230:31147046,31146757:autre:4230:31151786,31146758:autre:4230:31156399,31146759:autre:4230:31151824,31146760:autre:4230:31147090,31146761:autre:4230:31147118,31146762:autre:4230:31151872,31146763:autre:4230:31151909,31146764:autre:4230:31151949,31146765:autre:4230:31147169,31146766:autre:4230:31147198,31146767:autre:4230:31147245,31146768:autre:4230:31147272,31146769:autre:4230:31147324,31146770:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03691127350529296, 'nb_photo': 88612, 'list_port_cont': '31141486,31141701,31142129,31142316,31142581,31142618,31142952,31143384,31143421,31143906,31143946,31144366,31144400,31144434,31144514,31145539,31145863,31145900,31146973,31147003,31147044,31147088,31147123,31147174,31147202,31147247,31147285,31147315,31147356,31147390,31147431,31147472,31147514,31147579,31150909,31150947,31150976,31151028,31151064,31151090,31151145,31151179,31151220,31151250,31151282,31151328,31151364,31151397,31151439,31151476,31151532,31151573,31151608,31151686,31151729,31151792,31151823,31151875,31151904,31151941,31152046,31152073,31152123,31152154,31152196,31152273,31153635,31153701,31154525,31154566,31154606,31154646,31154679,31154716,31154748,31154810,31154843,31154876,31154925,31154955,31154996,31155030,31155086,31156410,31156455,31157599,31157638,31157666,31157717,31157751,31157784,31157818,31157859,31157896,31157930,31157975,31158010,31158052,31158085,31158128,31158156,31160367,31160405,31160443,31160476,31160515,31160554,31160590,31160629,31160665,31160686,31160735,31160775,3116080', 'assoc_port': '31141458:31141486,31141670:31141701,31141920:31142316,31142099:31142129,31142550:31142581,31142551:31142618,31142881:31142952,31143278:31143384,31143279:31143421,31143714:31143946,31143715:31143906,31144159:31144366,31144160:31144400,31144161:31144434,31144162:31144514,31144869:31145539,31144871:31145900,31144872:31145863,31146752:31146973,31146753:31147003,31146755:31156455,31146756:31147044,31146757:31151792,31146758:31156410,31146759:31151823,31146760:31147088,31146761:31147123,31146762:31151875,31146763:31151904,31146764:31151941,31146765:31147174,31146766:31147202,31146767:31147247,31146768:31147285,31146769:31147315,31146770:31147356,31146771:31147390,31146772:31147431,31146773:31147472,31146774:31147514,31146775:31147579,31146927:31175758,31146928:31175794,31146935:31150909,31146936:31150947,31146937:31150976,31146938:31151028,31146939:31151064,31146940:31151090,31146941:31151145,31146942:31151179,31146943:31153635,31146944:31151220,31146945:31151250,31146946:31151282,31146947:31151328,31146948:3115136', 'assoc_mat': '31141458:carton:4230:31141486,31141670:carton:4230:31141701,31141920:carton:4230:31142316,31142099:carton:4230:31142129,31142550:carton:4230:31142581,31142551:carton:4230:31142618,31142881:carton:4230:31142952,31143278:carton:4230:31143384,31143279:carton:4230:31143421,31143714:carton:4230:31143946,31143715:carton:4230:31143906,31144159:carton:4230:31144366,31144160:carton:4230:31144400,31144161:carton:4230:31144434,31144162:carton:4230:31144514,31144869:carton:4230:31145539,31144871:carton:4230:31145900,31144872:carton:4230:31145863,31146752:carton:4230:31146973,31146753:carton:4230:31147003,31146755:carton:4230:31156455,31146756:carton:4230:31147044,31146757:carton:4230:31151792,31146758:carton:4230:31156410,31146759:carton:4230:31151823,31146760:carton:4230:31147088,31146761:carton:4230:31147123,31146762:carton:4230:31151875,31146763:carton:4230:31151904,31146764:carton:4230:31151941,31146765:carton:4230:31147174,31146766:carton:4230:31147202,31146767:carton:4230:31147247,31146768:carton:4230:31147285,3114'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012734899793404027, 'nb_photo': 1971, 'list_port_cont': '31142118,31143908,31143943,31144357,31144399,31144497,31145532,31145905,31146979,31147124,31147173,31147200,31147233,31147270,31147319,31147355,31147383,31147436,31147473,31147501,31147587,31150917,31150940,31150984,31151027,31151057,31151098,31151144,31151216,31151291,31151319,31151367,31151436,31151473,31151537,31151559,31151602,31151673,31151714,31151789,31151836,31151907,31151936,31152044,31152082,31152111,31152149,31152194,31152261,31153640,31153691,31154531,31154561,31154678,31154712,31154759,31154794,31154842,31154871,31154923,31154945,31154990,31155040,31155085,31156398,31156444,31157598,31157637,31157677,31157707,31157783,31157863,31157891,31158081,31158155,31160364,31160400,31160428,31160477,31160553,31160575,31160699,31160739,31160766,31160807,31160843,31160888,31160928,31162707,31162734,31162783,31162865,31163316,31163384,31163525,31163677,31163708,31163748,31163792,31163865,31163934,31163961,31163993,31164040,31165826,31165855,31166565,31166669,31166713,31166741,31166786,31166891,31166937,3116699', 'assoc_port': '31142099:31142118,31143714:31143943,31143715:31143908,31144159:31144357,31144160:31144399,31144162:31144497,31144869:31145532,31144871:31145905,31146752:31146979,31146755:31156444,31146757:31151789,31146758:31156398,31146759:31151836,31146761:31147124,31146763:31151907,31146764:31151936,31146765:31147173,31146766:31147200,31146767:31147233,31146768:31147270,31146769:31147319,31146770:31147355,31146771:31147383,31146772:31147436,31146773:31147473,31146774:31147501,31146775:31147587,31146935:31150917,31146936:31150940,31146937:31150984,31146938:31151027,31146939:31151057,31146940:31151098,31146941:31151144,31146943:31153640,31146944:31151216,31146946:31151291,31146947:31151319,31146948:31151367,31146950:31151436,31146951:31151473,31146952:31151537,31146953:31151559,31146954:31151602,31146956:31151673,31146957:31151714,31146958:31153691,31148212:31152044,31148213:31152082,31148214:31152111,31148215:31152149,31148216:31152261,31148217:31152194,31152842:31179120,31152880:31179153,31152881:31179218,31152882:3117925', 'assoc_mat': '31142099:metal:4230:31142118,31143714:metal:4230:31143943,31143715:metal:4230:31143908,31144159:metal:4230:31144357,31144160:metal:4230:31144399,31144162:metal:4230:31144497,31144869:metal:4230:31145532,31144871:metal:4230:31145905,31146752:metal:4230:31146979,31146755:metal:4230:31156444,31146757:metal:4230:31151789,31146758:metal:4230:31156398,31146759:metal:4230:31151836,31146761:metal:4230:31147124,31146763:metal:4230:31151907,31146764:metal:4230:31151936,31146765:metal:4230:31147173,31146766:metal:4230:31147200,31146767:metal:4230:31147233,31146768:metal:4230:31147270,31146769:metal:4230:31147319,31146770:metal:4230:31147355,31146771:metal:4230:31147383,31146772:metal:4230:31147436,31146773:metal:4230:31147473,31146774:metal:4230:31147501,31146775:metal:4230:31147587,31146935:metal:4230:31150917,31146936:metal:4230:31150940,31146937:metal:4230:31150984,31146938:metal:4230:31151027,31146939:metal:4230:31151057,31146940:metal:4230:31151098,31146941:metal:4230:31151144,31146943:metal:4230:31153640,31146944:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.172187789881647, 'nb_photo': 548040, 'list_port_cont': '31141472,31141692,31142124,31142320,31142585,31142623,31142951,31143386,31143417,31143903,31143945,31144365,31144398,31144430,31144511,31145544,31145867,31145902,31146974,31147010,31147057,31147093,31147127,31147168,31147211,31147240,31147281,31147322,31147359,31147393,31147433,31147474,31147512,31147586,31150908,31150954,31150980,31151017,31151060,31151096,31151139,31151172,31151218,31151253,31151289,31151330,31151354,31151404,31151445,31151484,31151530,31151567,31151615,31151690,31151730,31151793,31151833,31151864,31151913,31151948,31152040,31152076,31152124,31152164,31152202,31152271,31153647,31153702,31154536,31154571,31154608,31154637,31154685,31154719,31154756,31154802,31154839,31154880,31154918,31154951,31154989,31155032,31155087,31156414,31156453,31157595,31157640,31157678,31157703,31157749,31157788,31157828,31157865,31157902,31157936,31157974,31158011,31158050,31158077,31158124,31158169,31160366,31160407,31160436,31160472,31160505,31160556,31160588,31160623,31160663,31160698,31160734,31160771,3116080', 'assoc_port': '31141458:31141472,31141670:31141692,31141920:31142320,31142099:31142124,31142550:31142585,31142551:31142623,31142881:31142951,31143278:31143386,31143279:31143417,31143714:31143945,31143715:31143903,31144159:31144365,31144160:31144398,31144161:31144430,31144162:31144511,31144869:31145544,31144871:31145902,31144872:31145867,31146752:31146974,31146753:31147010,31146755:31156453,31146756:31147057,31146757:31151793,31146758:31156414,31146759:31151833,31146760:31147093,31146761:31147127,31146762:31151864,31146763:31151913,31146764:31151948,31146765:31147168,31146766:31147211,31146767:31147240,31146768:31147281,31146769:31147322,31146770:31147359,31146771:31147393,31146772:31147433,31146773:31147474,31146774:31147512,31146775:31147586,31146927:31175759,31146928:31175789,31146935:31150908,31146936:31150954,31146937:31150980,31146938:31151017,31146939:31151060,31146940:31151096,31146941:31151139,31146942:31151172,31146943:31153647,31146944:31151218,31146945:31151253,31146946:31151289,31146947:31151330,31146948:3115135', 'assoc_mat': '31141458:papier:4230:31141472,31141670:papier:4230:31141692,31141920:papier:4230:31142320,31142099:papier:4230:31142124,31142550:papier:4230:31142585,31142551:papier:4230:31142623,31142881:papier:4230:31142951,31143278:papier:4230:31143386,31143279:papier:4230:31143417,31143714:papier:4230:31143945,31143715:papier:4230:31143903,31144159:papier:4230:31144365,31144160:papier:4230:31144398,31144161:papier:4230:31144430,31144162:papier:4230:31144511,31144869:papier:4230:31145544,31144871:papier:4230:31145902,31144872:papier:4230:31145867,31146752:papier:4230:31146974,31146753:papier:4230:31147010,31146755:papier:4230:31156453,31146756:papier:4230:31147057,31146757:papier:4230:31151793,31146758:papier:4230:31156414,31146759:papier:4230:31151833,31146760:papier:4230:31147093,31146761:papier:4230:31147127,31146762:papier:4230:31151864,31146763:papier:4230:31151913,31146764:papier:4230:31151948,31146765:papier:4230:31147168,31146766:papier:4230:31147211,31146767:papier:4230:31147240,31146768:papier:4230:31147281,3114'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0035226340105312644, 'nb_photo': 1946, 'list_port_cont': '31142117,31142616,31143410,31143912,31143944,31144363,31144507,31145538,31145908,31146976,31147122,31147171,31147210,31147242,31147280,31147392,31147435,31147467,31147573,31150988,31151029,31151066,31151135,31151180,31151219,31151257,31151285,31151329,31151366,31151408,31151440,31151481,31151538,31151609,31151681,31151831,31151865,31151912,31151947,31152045,31152083,31152161,31152192,31152269,31153645,31154684,31154717,31154753,31154805,31154846,31154878,31154921,31154949,31154999,31155025,31155073,31156413,31160480,31160509,31160545,31160625,31160657,31160696,31160732,31160887,31161032,31162700,31162740,31162817,31163285,31163322,31163500,31163604,31163650,31163683,31163794,31163861,31163896,31163928,31163966,31164005,31164039,31165861,31165889,31166608,31166641,31166676,31166787,31166828,31167003,31169416,31169487,31169527,31169566,31169603,31171083,31171401,31171546,31171592,31171633,31171664,31171708,31171779,31173228,31173274,31173310,31173350,31173385,31173411,31173452,31173500,31173535,31173564,3117360', 'assoc_port': '31142099:31142117,31142551:31142616,31143279:31143410,31143714:31143944,31143715:31143912,31144159:31144363,31144162:31144507,31144869:31145538,31144871:31145908,31146752:31146976,31146758:31156413,31146759:31151831,31146761:31147122,31146762:31151865,31146763:31151912,31146764:31151947,31146765:31147171,31146766:31147210,31146767:31147242,31146768:31147280,31146771:31147392,31146772:31147435,31146773:31147467,31146775:31147573,31146927:31175753,31146928:31175796,31146937:31150988,31146938:31151029,31146939:31151066,31146941:31151135,31146942:31151180,31146943:31153645,31146944:31151219,31146945:31151257,31146946:31151285,31146947:31151329,31146948:31151366,31146949:31151408,31146950:31151440,31146951:31151481,31146952:31151538,31146954:31151609,31146956:31151681,31148212:31152045,31148213:31152083,31148215:31152161,31148216:31152269,31148217:31152192,31152842:31179110,31152879:31179182,31152880:31179151,31152881:31179231,31152883:31179303,31152884:31179338,31152885:31179370,31152886:31179410,31152887:3117945', 'assoc_mat': '31142099:pehd:4230:31142117,31142551:pehd:4230:31142616,31143279:pehd:4230:31143410,31143714:pehd:4230:31143944,31143715:pehd:4230:31143912,31144159:pehd:4230:31144363,31144162:pehd:4230:31144507,31144869:pehd:4230:31145538,31144871:pehd:4230:31145908,31146752:pehd:4230:31146976,31146758:pehd:4230:31156413,31146759:pehd:4230:31151831,31146761:pehd:4230:31147122,31146762:pehd:4230:31151865,31146763:pehd:4230:31151912,31146764:pehd:4230:31151947,31146765:pehd:4230:31147171,31146766:pehd:4230:31147210,31146767:pehd:4230:31147242,31146768:pehd:4230:31147280,31146771:pehd:4230:31147392,31146772:pehd:4230:31147435,31146773:pehd:4230:31147467,31146775:pehd:4230:31147573,31146927:pehd:4230:31175753,31146928:pehd:4230:31175796,31146937:pehd:4230:31150988,31146938:pehd:4230:31151029,31146939:pehd:4230:31151066,31146941:pehd:4230:31151135,31146942:pehd:4230:31151180,31146943:pehd:4230:31153645,31146944:pehd:4230:31151219,31146945:pehd:4230:31151257,31146946:pehd:4230:31151285,31146947:pehd:4230:31151329,31146948:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017948749129603772, 'nb_photo': 32350, 'list_port_cont': '31141487,31141698,31142127,31142317,31142586,31142621,31142948,31143381,31143422,31143904,31143937,31144355,31144391,31144440,31144513,31145542,31145864,31145901,31146977,31147004,31147051,31147092,31147130,31147172,31147206,31147243,31147279,31147320,31147349,31147397,31147428,31147476,31147503,31147585,31150914,31150952,31150989,31151026,31151053,31151099,31151142,31151176,31151214,31151258,31151294,31151331,31151362,31151395,31151444,31151487,31151536,31151566,31151601,31151688,31151721,31151796,31151835,31151873,31151910,31151944,31152047,31152078,31152120,31152151,31152198,31152270,31153646,31153694,31154530,31154572,31154607,31154645,31154681,31154713,31154758,31154801,31154847,31154884,31154924,31154953,31155001,31155039,31155084,31156411,31156445,31157593,31157635,31157672,31157715,31157746,31157786,31157822,31157857,31157901,31157935,31157965,31158009,31158053,31158087,31158130,31158168,31160362,31160398,31160444,31160473,31160513,31160551,31160592,31160627,31160658,31160692,31160741,31160772,3116079', 'assoc_port': '31141458:31141487,31141670:31141698,31141920:31142317,31142099:31142127,31142550:31142586,31142551:31142621,31142881:31142948,31143278:31143381,31143279:31143422,31143714:31143937,31143715:31143904,31144159:31144355,31144160:31144391,31144161:31144440,31144162:31144513,31144869:31145542,31144871:31145901,31144872:31145864,31146752:31146977,31146753:31147004,31146755:31156445,31146756:31147051,31146757:31151796,31146758:31156411,31146759:31151835,31146760:31147092,31146761:31147130,31146762:31151873,31146763:31151910,31146764:31151944,31146765:31147172,31146766:31147206,31146767:31147243,31146768:31147279,31146769:31147320,31146770:31147349,31146771:31147397,31146772:31147428,31146773:31147476,31146774:31147503,31146775:31147585,31146927:31175756,31146928:31175793,31146935:31150914,31146936:31150952,31146937:31150989,31146938:31151026,31146939:31151053,31146940:31151099,31146941:31151142,31146942:31151176,31146943:31153646,31146944:31151214,31146945:31151258,31146946:31151294,31146947:31151331,31146948:3115136', 'assoc_mat': '31141458:pet_clair:4230:31141487,31141670:pet_clair:4230:31141698,31141920:pet_clair:4230:31142317,31142099:pet_clair:4230:31142127,31142550:pet_clair:4230:31142586,31142551:pet_clair:4230:31142621,31142881:pet_clair:4230:31142948,31143278:pet_clair:4230:31143381,31143279:pet_clair:4230:31143422,31143714:pet_clair:4230:31143937,31143715:pet_clair:4230:31143904,31144159:pet_clair:4230:31144355,31144160:pet_clair:4230:31144391,31144161:pet_clair:4230:31144440,31144162:pet_clair:4230:31144513,31144869:pet_clair:4230:31145542,31144871:pet_clair:4230:31145901,31144872:pet_clair:4230:31145864,31146752:pet_clair:4230:31146977,31146753:pet_clair:4230:31147004,31146755:pet_clair:4230:31156445,31146756:pet_clair:4230:31147051,31146757:pet_clair:4230:31151796,31146758:pet_clair:4230:31156411,31146759:pet_clair:4230:31151835,31146760:pet_clair:4230:31147092,31146761:pet_clair:4230:31147130,31146762:pet_clair:4230:31151873,31146763:pet_clair:4230:31151910,31146764:pet_clair:4230:31151944,31146765:pet_clair:4230:31147172,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018495989388387045, 'nb_photo': 923, 'list_port_cont': '31141484,31141696,31142121,31142312,31142939,31143414,31143948,31144368,31144505,31145541,31145899,31147159,31147207,31147237,31147275,31147353,31147400,31147513,31147577,31151023,31151166,31151256,31151293,31151327,31151443,31151486,31151533,31151570,31151614,31151685,31151797,31151899,31151950,31152039,31152266,31154564,31154640,31154682,31154755,31154809,31154844,31154882,31154917,31154961,31154994,31155082,31156403,31157601,31157662,31157709,31157829,31158120,31158163,31160353,31160438,31160544,31160621,31160701,31160808,31160849,31160892,31160927,31162776,31163288,31163576,31163609,31163647,31163679,31163720,31163752,31163858,31163933,31163967,31164044,31164115,31165786,31165818,31165893,31166375,31166414,31166496,31166753,31166784,31167002,31167076,31167118,31169299,31169568,31169638,31171402,31171433,31171600,31171672,31171707,31173387,31173605,31173639,31173671,31173755,31173874,31173913,31173945,31173983,31174057,31176003,31176059,31176124,31176166,31176197,31176238,31176804,31176915,31176952,3117698', 'assoc_port': '31141458:31141484,31141670:31141696,31141920:31142312,31142099:31142121,31142881:31142939,31143279:31143414,31143714:31143948,31144159:31144368,31144162:31144505,31144869:31145541,31144871:31145899,31146757:31151797,31146758:31156403,31146763:31151899,31146764:31151950,31146765:31147159,31146766:31147207,31146767:31147237,31146768:31147275,31146770:31147353,31146771:31147400,31146774:31147513,31146775:31147577,31146938:31151023,31146942:31151166,31146945:31151256,31146946:31151293,31146947:31151327,31146950:31151443,31146951:31151486,31146952:31151533,31146953:31151570,31146954:31151614,31146956:31151685,31148212:31152039,31148216:31152266,31152842:31179107,31152880:31179152,31152881:31179229,31152883:31179296,31152884:31179334,31152885:31179371,31152886:31179409,31152887:31179449,31152888:31179490,31152889:31179518,31152890:31179562,31152892:31179635,31152893:31179667,31152894:31179739,31152895:31179705,31153808:31176003,31153812:31154564,31153813:31154640,31153815:31154682,31153817:31154755,31153818:3115480', 'assoc_mat': '31141458:pet_fonce:4230:31141484,31141670:pet_fonce:4230:31141696,31141920:pet_fonce:4230:31142312,31142099:pet_fonce:4230:31142121,31142881:pet_fonce:4230:31142939,31143279:pet_fonce:4230:31143414,31143714:pet_fonce:4230:31143948,31144159:pet_fonce:4230:31144368,31144162:pet_fonce:4230:31144505,31144869:pet_fonce:4230:31145541,31144871:pet_fonce:4230:31145899,31146757:pet_fonce:4230:31151797,31146758:pet_fonce:4230:31156403,31146763:pet_fonce:4230:31151899,31146764:pet_fonce:4230:31151950,31146765:pet_fonce:4230:31147159,31146766:pet_fonce:4230:31147207,31146767:pet_fonce:4230:31147237,31146768:pet_fonce:4230:31147275,31146770:pet_fonce:4230:31147353,31146771:pet_fonce:4230:31147400,31146774:pet_fonce:4230:31147513,31146775:pet_fonce:4230:31147577,31146938:pet_fonce:4230:31151023,31146942:pet_fonce:4230:31151166,31146945:pet_fonce:4230:31151256,31146946:pet_fonce:4230:31151293,31146947:pet_fonce:4230:31151327,31146950:pet_fonce:4230:31151443,31146951:pet_fonce:4230:31151486,31146952:pet_fonce:4230:31151533,3'}), 'main_stat': {'nb_photos': 1098}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31196998,31196999,31197000,31197001,31197002,31197003,31197004?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-06', 0.7878335676753392),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_06_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.38%', 20435], 'carton': ['carton', '3.69%', 88612], 'metal': ['metal', '0.13%', 1971], 'papier': ['papier', '17.22%', 548040], 'pehd': ['pehd', '0.35%', 1946], 'pet_clair': ['pet_clair', '1.79%', 32350], 'pet_fonce': ['pet_fonce', '0.18%', 923]}} 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_06_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.43user 2.93system 0:30.50elapsed 17%CPU (0avgtext+0avgdata 191184maxresident)k 28328inputs+304outputs (82major+51776minor)pagefaults 0swaps