python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-09 _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 : (1, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (1, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 09 mtr_id : dashboard_places : SCCU_cam7 date : 2026-09 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam7' and date like '%2026-09%') and created_at like '%2026-09%'))); nb_day : (1, 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 = 204 and month(ded.date) = 09 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 09 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 204 and mp.name like '%092026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-09-01 : dt_date_just_month_year : 2026-09-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-09-01" AND ded.date <= "2026-09-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 (2993846,2994616,2995342,2995936,2996662,2997268,2997730,2998400,2999056,2999692,3000346,3000754,3001108,3001532,3001984,3002524,3003124,3003752,3004302,3004752,3005324,3005964,3006582,3007258,3007848,3008428,3008606) 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.00833621680785237, 'nb_photo': 5425, 'list_port_cont': '31101304,31101595,31102371,31102738,31102859,31103321,31103547,31103830,31104207,31104393,31104532,31104892,31104933,31105111,31105319,31105554,31105832,31105873,31106561,31106771,31107494,31107726,31107999,31108316,31108724,31108844,31109608,31109653,31110012,31110157,31110468,31110604,31110782,31111101,31111225,31111750,31113535,31113830,31113917,31114223,31114468,31114698,31114977,31115266,31115560,31115852,31115964,31116238,31116517,31116672,31116904,31117942,31118559,31118637,31118758,31118950,31119187,31119388,31119696,31119814,31120031,31120313,31120444,31120683,31121013,31121190,31121532,31121844,31121972,31122173,31122562,31122891,31123366,31123639,31123876,31124115,31124319,31124574,31124829,31125085,31125326,31125603,31127152,31127699,31127751,31127784,31127824,31127854,31127889,31128327,31128377,31128411,31128988,31129065,31129356,31129423,31129637,31130220,31130578,31130938,31130970,31131022,31131102,31131274,31131362,31131688,31131948,31132000,31133243,31133301,31133713,31133763,31133802,3113383', 'assoc_port': '31101205:31101304,31101500:31101595,31102242:31102371,31102548:31102738,31102781:31102859,31103149:31103321,31103400:31103547,31103602:31103830,31103861:31104207,31104237:31104393,31104455:31104532,31104675:31104892,31104676:31104933,31105012:31105111,31105216:31105319,31105386:31105554,31105670:31105832,31105671:31105873,31106478:31106561,31106715:31106771,31107400:31107494,31107664:31107726,31107931:31107999,31108204:31108316,31108484:31108724,31108779:31108844,31109135:31109653,31109395:31109608,31109732:31110012,31110043:31110157,31110291:31110468,31110505:31110604,31110680:31110782,31110890:31111101,31111134:31111225,31111550:31111750,31113484:31113535,31113693:31113830,31113864:31113917,31114142:31114223,31114404:31114468,31114673:31114698,31114849:31114977,31115094:31115266,31115348:31115560,31115622:31115852,31115896:31115964,31116137:31116238,31116382:31116517,31116620:31116672,31116823:31116904,31117863:31117942,31118390:31118559,31118391:31118637,31118697:31118758,31118856:31118950,31119058:3111918', 'assoc_mat': '31101205:autre:4230:31101304,31101500:autre:4230:31101595,31102242:autre:4230:31102371,31102548:autre:4230:31102738,31102781:autre:4230:31102859,31103149:autre:4230:31103321,31103400:autre:4230:31103547,31103602:autre:4230:31103830,31103861:autre:4230:31104207,31104237:autre:4230:31104393,31104455:autre:4230:31104532,31104675:autre:4230:31104892,31104676:autre:4230:31104933,31105012:autre:4230:31105111,31105216:autre:4230:31105319,31105386:autre:4230:31105554,31105670:autre:4230:31105832,31105671:autre:4230:31105873,31106478:autre:4230:31106561,31106715:autre:4230:31106771,31107400:autre:4230:31107494,31107664:autre:4230:31107726,31107931:autre:4230:31107999,31108204:autre:4230:31108316,31108484:autre:4230:31108724,31108779:autre:4230:31108844,31109135:autre:4230:31109653,31109395:autre:4230:31109608,31109732:autre:4230:31110012,31110043:autre:4230:31110157,31110291:autre:4230:31110468,31110505:autre:4230:31110604,31110680:autre:4230:31110782,31110890:autre:4230:31111101,31111134:autre:4230:31111225,31111550:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04139735648743596, 'nb_photo': 27142, 'list_port_cont': '31100345,31100597,31100814,31101317,31101600,31101817,31102042,31102380,31102740,31102862,31103322,31103552,31103829,31104210,31104390,31104541,31104900,31104947,31105114,31105324,31105557,31105846,31105884,31106111,31106296,31106568,31106779,31107077,31107236,31107504,31107736,31108010,31108317,31108719,31108857,31109611,31109656,31110006,31110164,31110480,31110613,31110784,31111110,31111235,31111722,31111760,31111802,31112013,31112166,31112448,31112577,31112876,31113076,31113302,31113544,31113820,31113929,31114215,31114465,31114692,31114983,31115263,31115562,31115862,31115976,31116237,31116519,31116683,31116914,31117245,31117284,31117688,31117719,31117952,31117988,31118563,31118631,31118763,31118948,31119193,31119401,31119692,31119818,31120021,31120316,31120440,31120693,31121021,31121194,31121533,31121839,31121971,31122170,31122449,31122574,31122894,31123079,31123373,31123627,31123879,31124112,31124323,31124580,31124827,31125082,31125339,31125599,31127161,31127707,31127747,31127788,31127820,31127858,3112789', 'assoc_port': '31100287:31100345,31100520:31100597,31100752:31100814,31101205:31101317,31101500:31101600,31101746:31101817,31101975:31102042,31102242:31102380,31102548:31102740,31102781:31102862,31103149:31103322,31103400:31103552,31103602:31103829,31103861:31104210,31104237:31104390,31104455:31104541,31104675:31104900,31104676:31104947,31105012:31105114,31105216:31105324,31105386:31105557,31105670:31105846,31105671:31105884,31106048:31106111,31106282:31106296,31106478:31106568,31106715:31106779,31106963:31107077,31107221:31107236,31107400:31107504,31107664:31107736,31107931:31108010,31108204:31108317,31108484:31108719,31108779:31108857,31109135:31109656,31109395:31109611,31109732:31110006,31110043:31110164,31110291:31110480,31110505:31110613,31110680:31110784,31110890:31111110,31111134:31111235,31111304:31111802,31111549:31111722,31111550:31111760,31111917:31112013,31112150:31112166,31112352:31112448,31112553:31112577,31112726:31112876,31113019:31113076,31113233:31113302,31113484:31113544,31113693:31113820,31113864:3111392', 'assoc_mat': '31100287:carton:4230:31100345,31100520:carton:4230:31100597,31100752:carton:4230:31100814,31101205:carton:4230:31101317,31101500:carton:4230:31101600,31101746:carton:4230:31101817,31101975:carton:4230:31102042,31102242:carton:4230:31102380,31102548:carton:4230:31102740,31102781:carton:4230:31102862,31103149:carton:4230:31103322,31103400:carton:4230:31103552,31103602:carton:4230:31103829,31103861:carton:4230:31104210,31104237:carton:4230:31104390,31104455:carton:4230:31104541,31104675:carton:4230:31104900,31104676:carton:4230:31104947,31105012:carton:4230:31105114,31105216:carton:4230:31105324,31105386:carton:4230:31105557,31105670:carton:4230:31105846,31105671:carton:4230:31105884,31106048:carton:4230:31106111,31106282:carton:4230:31106296,31106478:carton:4230:31106568,31106715:carton:4230:31106779,31106963:carton:4230:31107077,31107221:carton:4230:31107236,31107400:carton:4230:31107504,31107664:carton:4230:31107736,31107931:carton:4230:31108010,31108204:carton:4230:31108317,31108484:carton:4230:31108719,3110'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013377244429123084, 'nb_photo': 593, 'list_port_cont': '31104203,31104387,31104525,31107506,31108852,31109606,31110008,31114458,31114688,31114991,31115257,31115551,31115853,31117683,31117956,31118632,31119697,31120304,31124333,31125083,31125322,31125607,31127153,31131021,31133293,31134073,31134535,31134568,31137756,31138117,31138886,31139193,31139283,31139631,31140863,31141224,31145699,31146744,31147987,31150326,31150821,31151334,31151584,31151618,31151959,31152169,31152421,31152632,31152872,31153218,31153433,31153686,31154934,31155307,31155345,31155385,31155854,31155898,31155929,31156225,31156271,31156353,31156719,31157156,31158743,31159208,31160907,31160943,31160978,31161006,31161042,31161127,31161786,31161817,31161863,31162060,31162274,31162340,31162626,31162699,31162918,31162982,31164073,31164325,31164667,31165747,31165781,31165814,31165939,31166357,31166977,31167520,31167831,31168125,31168614,31168654,31168731,31169186,31169218,31170010,31170057,31170098,31170133,31170235,31170261,31170375,31170410,31170653,31170740,31170862,31171120,31171461,31171722,3117177', 'assoc_port': '31103861:31104203,31104237:31104387,31104455:31104525,31107400:31107506,31108779:31108852,31109395:31109606,31109732:31110008,31114404:31114458,31114673:31114688,31114849:31114991,31115094:31115257,31115348:31115551,31115622:31115853,31117558:31117683,31117863:31117956,31118391:31118632,31119547:31119697,31120175:31120304,31124231:31124333,31124977:31125083,31125233:31125322,31125504:31125607,31125823:31127153,31130606:31131021,31132616:31133293,31132808:31134073,31134221:31134535,31134222:31134568,31137686:31137756,31138033:31138117,31138773:31138886,31139004:31139193,31139227:31139283,31139494:31139631,31140612:31140863,31140894:31141224,31145472:31145699,31146589:31146744,31147905:31147987,31150102:31150326,31150647:31150821,31151149:31151334,31151411:31151584,31151463:31151618,31151780:31151959,31151990:31152169,31152249:31152421,31152463:31152632,31152737:31152872,31153168:31153218,31153367:31153433,31153582:31153686,31154679:31154934,31155000:31155854,31155034:31155307,31155151:31155345,31155224:3115538', 'assoc_mat': '31103861:metal:4230:31104203,31104237:metal:4230:31104387,31104455:metal:4230:31104525,31107400:metal:4230:31107506,31108779:metal:4230:31108852,31109395:metal:4230:31109606,31109732:metal:4230:31110008,31114404:metal:4230:31114458,31114673:metal:4230:31114688,31114849:metal:4230:31114991,31115094:metal:4230:31115257,31115348:metal:4230:31115551,31115622:metal:4230:31115853,31117558:metal:4230:31117683,31117863:metal:4230:31117956,31118391:metal:4230:31118632,31119547:metal:4230:31119697,31120175:metal:4230:31120304,31124231:metal:4230:31124333,31124977:metal:4230:31125083,31125233:metal:4230:31125322,31125504:metal:4230:31125607,31125823:metal:4230:31127153,31130606:metal:4230:31131021,31132616:metal:4230:31133293,31132808:metal:4230:31134073,31134221:metal:4230:31134535,31134222:metal:4230:31134568,31137686:metal:4230:31137756,31138033:metal:4230:31138117,31138773:metal:4230:31138886,31139004:metal:4230:31139193,31139227:metal:4230:31139283,31139494:metal:4230:31139631,31140612:metal:4230:31140863,31140894:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.14999512369154486, 'nb_photo': 112729, 'list_port_cont': '31100343,31100598,31100812,31101309,31101392,31101601,31101810,31102050,31102376,31102741,31102867,31103334,31103554,31103832,31104214,31104395,31104537,31104902,31104946,31105107,31105326,31105567,31105842,31105881,31106108,31106305,31106574,31106781,31107075,31107249,31107505,31107732,31108002,31108307,31108718,31108854,31109607,31109657,31110016,31110160,31110471,31110607,31110789,31111104,31111242,31111721,31111759,31111800,31112011,31112170,31112449,31112564,31112869,31113086,31113299,31113545,31113825,31113933,31114224,31114461,31114697,31114990,31115268,31115564,31115861,31115978,31116234,31116515,31116679,31116918,31117242,31117283,31117693,31117724,31117955,31117991,31118560,31118630,31118762,31118942,31119185,31119403,31119691,31119828,31120030,31120317,31120437,31120700,31121024,31121186,31121528,31121845,31121968,31122175,31122452,31122564,31122886,31123087,31123375,31123641,31123875,31124118,31124328,31124585,31124833,31125081,31125333,31125600,31127164,31127706,31127742,31127787,31127823,3112785', 'assoc_port': '31100287:31100343,31100520:31100598,31100752:31100812,31100990:31101392,31101205:31101309,31101500:31101601,31101746:31101810,31101975:31102050,31102242:31102376,31102548:31102741,31102781:31102867,31103149:31103334,31103400:31103554,31103602:31103832,31103861:31104214,31104237:31104395,31104455:31104537,31104675:31104902,31104676:31104946,31105012:31105107,31105216:31105326,31105386:31105567,31105670:31105842,31105671:31105881,31106048:31106108,31106282:31106305,31106478:31106574,31106715:31106781,31106963:31107075,31107221:31107249,31107400:31107505,31107664:31107732,31107931:31108002,31108204:31108307,31108484:31108718,31108779:31108854,31109135:31109657,31109395:31109607,31109732:31110016,31110043:31110160,31110291:31110471,31110505:31110607,31110680:31110789,31110890:31111104,31111134:31111242,31111304:31111800,31111549:31111721,31111550:31111759,31111917:31112011,31112150:31112170,31112352:31112449,31112553:31112564,31112726:31112869,31113019:31113086,31113233:31113299,31113484:31113545,31113693:3111382', 'assoc_mat': '31100287:papier:4230:31100343,31100520:papier:4230:31100598,31100752:papier:4230:31100812,31100990:papier:4230:31101392,31101205:papier:4230:31101309,31101500:papier:4230:31101601,31101746:papier:4230:31101810,31101975:papier:4230:31102050,31102242:papier:4230:31102376,31102548:papier:4230:31102741,31102781:papier:4230:31102867,31103149:papier:4230:31103334,31103400:papier:4230:31103554,31103602:papier:4230:31103832,31103861:papier:4230:31104214,31104237:papier:4230:31104395,31104455:papier:4230:31104537,31104675:papier:4230:31104902,31104676:papier:4230:31104946,31105012:papier:4230:31105107,31105216:papier:4230:31105326,31105386:papier:4230:31105567,31105670:papier:4230:31105842,31105671:papier:4230:31105881,31106048:papier:4230:31106108,31106282:papier:4230:31106305,31106478:papier:4230:31106574,31106715:papier:4230:31106781,31106963:papier:4230:31107075,31107221:papier:4230:31107249,31107400:papier:4230:31107505,31107664:papier:4230:31107732,31107931:papier:4230:31108002,31108204:papier:4230:31108307,3110'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0031306166711609364, 'nb_photo': 968, 'list_port_cont': '31102734,31104897,31104944,31108001,31108312,31108722,31108856,31109650,31110155,31110479,31111109,31113828,31113931,31114220,31114467,31115555,31115866,31115974,31116235,31119198,31119402,31119686,31119825,31120032,31120311,31120445,31121025,31121193,31121526,31121846,31124828,31125089,31125606,31127167,31127708,31127745,31127780,31127813,31127852,31127896,31129429,31129953,31130222,31130572,31130940,31130984,31131361,31131683,31131949,31133832,31133908,31133993,31134068,31134110,31134546,31134577,31134895,31135137,31135421,31135636,31135890,31135931,31136239,31138879,31139201,31139290,31139629,31140004,31140319,31140581,31140869,31141135,31141214,31141436,31141540,31141749,31143150,31143712,31143769,31144397,31144568,31144836,31145177,31145450,31145715,31145967,31146205,31146486,31146567,31146752,31147194,31149380,31149674,31150052,31150340,31150619,31150822,31151332,31151593,31151631,31151963,31152176,31154076,31155298,31155349,31155384,31155859,31155897,31155936,31156232,31156275,31156350,31157274,3115735', 'assoc_port': '31102548:31102734,31104675:31104897,31104676:31104944,31107931:31108001,31108204:31108312,31108484:31108722,31108779:31108856,31109135:31109650,31110043:31110155,31110291:31110479,31110890:31111109,31113693:31113828,31113864:31113931,31114142:31114220,31114404:31114467,31115348:31115555,31115622:31115866,31115896:31115974,31116137:31116235,31119058:31119198,31119304:31119402,31119547:31119686,31119767:31119825,31120007:31120032,31120175:31120311,31120422:31120445,31120880:31121025,31121094:31121193,31121374:31121526,31121641:31121846,31124691:31124828,31124977:31125089,31125504:31125606,31125823:31127167,31127186:31127708,31127187:31127745,31127188:31127780,31127189:31127813,31127190:31127852,31127191:31127896,31129105:31129429,31129709:31129953,31129937:31130222,31130280:31130572,31130604:31130940,31130605:31130984,31131167:31131361,31131631:31131683,31131789:31131949,31132677:31133832,31132679:31133908,31132681:31133993,31132808:31134068,31133195:31134110,31134221:31134546,31134222:31134577,31134643:3113489', 'assoc_mat': '31102548:pehd:4230:31102734,31104675:pehd:4230:31104897,31104676:pehd:4230:31104944,31107931:pehd:4230:31108001,31108204:pehd:4230:31108312,31108484:pehd:4230:31108722,31108779:pehd:4230:31108856,31109135:pehd:4230:31109650,31110043:pehd:4230:31110155,31110291:pehd:4230:31110479,31110890:pehd:4230:31111109,31113693:pehd:4230:31113828,31113864:pehd:4230:31113931,31114142:pehd:4230:31114220,31114404:pehd:4230:31114467,31115348:pehd:4230:31115555,31115622:pehd:4230:31115866,31115896:pehd:4230:31115974,31116137:pehd:4230:31116235,31119058:pehd:4230:31119198,31119304:pehd:4230:31119402,31119547:pehd:4230:31119686,31119767:pehd:4230:31119825,31120007:pehd:4230:31120032,31120175:pehd:4230:31120311,31120422:pehd:4230:31120445,31120880:pehd:4230:31121025,31121094:pehd:4230:31121193,31121374:pehd:4230:31121526,31121641:pehd:4230:31121846,31124691:pehd:4230:31124828,31124977:pehd:4230:31125089,31125504:pehd:4230:31125606,31125823:pehd:4230:31127167,31127186:pehd:4230:31127708,31127187:pehd:4230:31127745,31127188:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007179663552443536, 'nb_photo': 6084, 'list_port_cont': '31100806,31101814,31102046,31102375,31102737,31102866,31103328,31103557,31103819,31104212,31104394,31104542,31104898,31104942,31105321,31108008,31108311,31108710,31108849,31109597,31109658,31110015,31110162,31110481,31110606,31110780,31111111,31112015,31112439,31112578,31112868,31113303,31113831,31113920,31114210,31114471,31114683,31114988,31115255,31115563,31115867,31115968,31116236,31116516,31116681,31116920,31117238,31117691,31117729,31117954,31118624,31118756,31118949,31119199,31119404,31119695,31119824,31120029,31120309,31120436,31120695,31121027,31121189,31121531,31121841,31121966,31122172,31122575,31122895,31123086,31123371,31123637,31124109,31124335,31124584,31124832,31125075,31125338,31125594,31127163,31127714,31127752,31127782,31127817,31127850,31127882,31128329,31128375,31128416,31128997,31129069,31129360,31129434,31129664,31129955,31130212,31130575,31130943,31130983,31131023,31131100,31131273,31131356,31131689,31131952,31132008,31132223,31133255,31133289,31133718,31133799,31133841,31133869,3113395', 'assoc_port': '31100752:31100806,31101746:31101814,31101975:31102046,31102242:31102375,31102548:31102737,31102781:31102866,31103149:31103328,31103400:31103557,31103602:31103819,31103861:31104212,31104237:31104394,31104455:31104542,31104675:31104898,31104676:31104942,31105216:31105321,31107931:31108008,31108204:31108311,31108484:31108710,31108779:31108849,31109135:31109658,31109395:31109597,31109732:31110015,31110043:31110162,31110291:31110481,31110505:31110606,31110680:31110780,31110890:31111111,31111917:31112015,31112352:31112439,31112553:31112578,31112726:31112868,31113233:31113303,31113693:31113831,31113864:31113920,31114142:31114210,31114404:31114471,31114673:31114683,31114849:31114988,31115094:31115255,31115348:31115563,31115622:31115867,31115896:31115968,31116137:31116236,31116382:31116516,31116620:31116681,31116823:31116920,31117099:31117238,31117558:31117691,31117559:31117729,31117863:31117954,31118391:31118624,31118697:31118756,31118856:31118949,31119058:31119199,31119304:31119404,31119547:31119695,31119767:3111982', 'assoc_mat': '31100752:pet_clair:4230:31100806,31101746:pet_clair:4230:31101814,31101975:pet_clair:4230:31102046,31102242:pet_clair:4230:31102375,31102548:pet_clair:4230:31102737,31102781:pet_clair:4230:31102866,31103149:pet_clair:4230:31103328,31103400:pet_clair:4230:31103557,31103602:pet_clair:4230:31103819,31103861:pet_clair:4230:31104212,31104237:pet_clair:4230:31104394,31104455:pet_clair:4230:31104542,31104675:pet_clair:4230:31104898,31104676:pet_clair:4230:31104942,31105216:pet_clair:4230:31105321,31107931:pet_clair:4230:31108008,31108204:pet_clair:4230:31108311,31108484:pet_clair:4230:31108710,31108779:pet_clair:4230:31108849,31109135:pet_clair:4230:31109658,31109395:pet_clair:4230:31109597,31109732:pet_clair:4230:31110015,31110043:pet_clair:4230:31110162,31110291:pet_clair:4230:31110481,31110505:pet_clair:4230:31110606,31110680:pet_clair:4230:31110780,31110890:pet_clair:4230:31111111,31111917:pet_clair:4230:31112015,31112352:pet_clair:4230:31112439,31112553:pet_clair:4230:31112578,31112726:pet_clair:4230:31112868,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002254607773608, 'nb_photo': 250, 'list_port_cont': '31102742,31103333,31104206,31108858,31110018,31110168,31110603,31113829,31114218,31114469,31114690,31115556,31116228,31119693,31119827,31120443,31120696,31124577,31125328,31127159,31127819,31129661,31129957,31130217,31130573,31130945,31131354,31131955,31134074,31134112,31134549,31134582,31134906,31135139,31135916,31137442,31138133,31139202,31139292,31139635,31140007,31140321,31149382,31149678,31150338,31151098,31154369,31155336,31155931,31156233,31158997,31160868,31160977,31161083,31162921,31162997,31163463,31164121,31166909,31166948,31166982,31167533,31168700,31170022,31170053,31170099,31170140,31170268,31170310,31170369,31170418,31170646,31170750,31171393,31173033,31173072,31173233,31173276,31173316,31173348,31173385,31175096,31175136,31175246,31175288,31175330,31175373,31176213,31176245,31179003,31179383,31179663,31179920,31180420,31180646,31180868,31181040,31181156,31184109,31184434,31185017,31186544,31186839,31189771,31190052,31190290,31190551,31194744,31194997,31195232,31200217,31205467,31206701,3120757', 'assoc_port': '31102548:31102742,31103149:31103333,31103861:31104206,31108779:31108858,31109732:31110018,31110043:31110168,31110505:31110603,31113693:31113829,31114142:31114218,31114404:31114469,31114673:31114690,31115348:31115556,31116137:31116228,31119547:31119693,31119767:31119827,31120422:31120443,31120629:31120696,31124478:31124577,31125233:31125328,31125823:31127159,31127189:31127819,31129465:31129661,31129709:31129957,31129937:31130217,31130280:31130573,31130604:31130945,31131167:31131354,31131789:31131955,31132808:31134074,31133195:31134112,31134221:31134549,31134222:31134582,31134643:31134906,31134928:31135139,31135666:31135916,31137321:31137442,31138033:31138133,31139004:31139202,31139227:31139292,31139494:31139635,31139776:31140007,31140031:31140321,31149242:31149382,31149534:31149678,31150102:31150338,31150858:31151098,31154199:31154369,31155151:31155336,31155488:31155931,31156002:31156233,31158932:31158997,31159671:31173033,31159847:31173072,31159888:31160868,31160016:31160977,31160079:31161083,31162509:3116292', 'assoc_mat': '31102548:pet_fonce:4230:31102742,31103149:pet_fonce:4230:31103333,31103861:pet_fonce:4230:31104206,31108779:pet_fonce:4230:31108858,31109732:pet_fonce:4230:31110018,31110043:pet_fonce:4230:31110168,31110505:pet_fonce:4230:31110603,31113693:pet_fonce:4230:31113829,31114142:pet_fonce:4230:31114218,31114404:pet_fonce:4230:31114469,31114673:pet_fonce:4230:31114690,31115348:pet_fonce:4230:31115556,31116137:pet_fonce:4230:31116228,31119547:pet_fonce:4230:31119693,31119767:pet_fonce:4230:31119827,31120422:pet_fonce:4230:31120443,31120629:pet_fonce:4230:31120696,31124478:pet_fonce:4230:31124577,31125233:pet_fonce:4230:31125328,31125823:pet_fonce:4230:31127159,31127189:pet_fonce:4230:31127819,31129465:pet_fonce:4230:31129661,31129709:pet_fonce:4230:31129957,31129937:pet_fonce:4230:31130217,31130280:pet_fonce:4230:31130573,31130604:pet_fonce:4230:31130945,31131167:pet_fonce:4230:31131354,31131789:pet_fonce:4230:31131955,31132808:pet_fonce:4230:31134074,31133195:pet_fonce:4230:31134112,31134221:pet_fonce:4230:31134549,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(2993846,2994616,2995342,2995936,2996662,2997268,2997730,2998400,2999056,2999692,3000346,3000754,3001108,3001532,3001984,3002524,3003124,3003752,3004302,3004752,3005324,3005964,3006582,3007258,3007848,3008428,3008606)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195428, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31101304,31101595,31102371,31102738,31102859,31103321,31103547,31103830,31104207,31104393,31104532,31104892,31104933,31105111,31105319,31105554,31105832,31105873,31106561,31106771,31107494,31107726,31107999,31108316,31108724,31108844,31109608,31109653,31110012,31110157,31110468,31110604,31110782,31111101,31111225,31111750,31113535,31113830,31113917,31114223,31114468,31114698,31114977,31115266,31115560,31115852,31115964,31116238,31116517,31116672,31116904,31117942,31118559,31118637,31118758,31118950,31119187,31119388,31119696,31119814,31120031,31120313,31120444,31120683,31121013,31121190,31121532,31121844,31121972,31122173,31122562,31122891,31123366,31123639,31123876,31124115,31124319,31124574,31124829,31125085,31125326,31125603,31127152,31127699,31127751,31127784,31127824,31127854,31127889,31128327,31128377,31128411,31128988,31129065,31129356,31129423,31129637,31130220,31130578,31130938,31130970,31131022,31131102,31131274,31131362,31131688,31131948,31132000,31133243,31133301,31133713,31133763,31133802,3113383 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195429, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100345,31100597,31100814,31101317,31101600,31101817,31102042,31102380,31102740,31102862,31103322,31103552,31103829,31104210,31104390,31104541,31104900,31104947,31105114,31105324,31105557,31105846,31105884,31106111,31106296,31106568,31106779,31107077,31107236,31107504,31107736,31108010,31108317,31108719,31108857,31109611,31109656,31110006,31110164,31110480,31110613,31110784,31111110,31111235,31111722,31111760,31111802,31112013,31112166,31112448,31112577,31112876,31113076,31113302,31113544,31113820,31113929,31114215,31114465,31114692,31114983,31115263,31115562,31115862,31115976,31116237,31116519,31116683,31116914,31117245,31117284,31117688,31117719,31117952,31117988,31118563,31118631,31118763,31118948,31119193,31119401,31119692,31119818,31120021,31120316,31120440,31120693,31121021,31121194,31121533,31121839,31121971,31122170,31122449,31122574,31122894,31123079,31123373,31123627,31123879,31124112,31124323,31124580,31124827,31125082,31125339,31125599,31127161,31127707,31127747,31127788,31127820,31127858,3112789 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195430, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31104203,31104387,31104525,31107506,31108852,31109606,31110008,31114458,31114688,31114991,31115257,31115551,31115853,31117683,31117956,31118632,31119697,31120304,31124333,31125083,31125322,31125607,31127153,31131021,31133293,31134073,31134535,31134568,31137756,31138117,31138886,31139193,31139283,31139631,31140863,31141224,31145699,31146744,31147987,31150326,31150821,31151334,31151584,31151618,31151959,31152169,31152421,31152632,31152872,31153218,31153433,31153686,31154934,31155307,31155345,31155385,31155854,31155898,31155929,31156225,31156271,31156353,31156719,31157156,31158743,31159208,31160907,31160943,31160978,31161006,31161042,31161127,31161786,31161817,31161863,31162060,31162274,31162340,31162626,31162699,31162918,31162982,31164073,31164325,31164667,31165747,31165781,31165814,31165939,31166357,31166977,31167520,31167831,31168125,31168614,31168654,31168731,31169186,31169218,31170010,31170057,31170098,31170133,31170235,31170261,31170375,31170410,31170653,31170740,31170862,31171120,31171461,31171722,3117177 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195431, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100343,31100598,31100812,31101309,31101392,31101601,31101810,31102050,31102376,31102741,31102867,31103334,31103554,31103832,31104214,31104395,31104537,31104902,31104946,31105107,31105326,31105567,31105842,31105881,31106108,31106305,31106574,31106781,31107075,31107249,31107505,31107732,31108002,31108307,31108718,31108854,31109607,31109657,31110016,31110160,31110471,31110607,31110789,31111104,31111242,31111721,31111759,31111800,31112011,31112170,31112449,31112564,31112869,31113086,31113299,31113545,31113825,31113933,31114224,31114461,31114697,31114990,31115268,31115564,31115861,31115978,31116234,31116515,31116679,31116918,31117242,31117283,31117693,31117724,31117955,31117991,31118560,31118630,31118762,31118942,31119185,31119403,31119691,31119828,31120030,31120317,31120437,31120700,31121024,31121186,31121528,31121845,31121968,31122175,31122452,31122564,31122886,31123087,31123375,31123641,31123875,31124118,31124328,31124585,31124833,31125081,31125333,31125600,31127164,31127706,31127742,31127787,31127823,3112785 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195432, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31102734,31104897,31104944,31108001,31108312,31108722,31108856,31109650,31110155,31110479,31111109,31113828,31113931,31114220,31114467,31115555,31115866,31115974,31116235,31119198,31119402,31119686,31119825,31120032,31120311,31120445,31121025,31121193,31121526,31121846,31124828,31125089,31125606,31127167,31127708,31127745,31127780,31127813,31127852,31127896,31129429,31129953,31130222,31130572,31130940,31130984,31131361,31131683,31131949,31133832,31133908,31133993,31134068,31134110,31134546,31134577,31134895,31135137,31135421,31135636,31135890,31135931,31136239,31138879,31139201,31139290,31139629,31140004,31140319,31140581,31140869,31141135,31141214,31141436,31141540,31141749,31143150,31143712,31143769,31144397,31144568,31144836,31145177,31145450,31145715,31145967,31146205,31146486,31146567,31146752,31147194,31149380,31149674,31150052,31150340,31150619,31150822,31151332,31151593,31151631,31151963,31152176,31154076,31155298,31155349,31155384,31155859,31155897,31155936,31156232,31156275,31156350,31157274,3115735 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195433, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100806,31101814,31102046,31102375,31102737,31102866,31103328,31103557,31103819,31104212,31104394,31104542,31104898,31104942,31105321,31108008,31108311,31108710,31108849,31109597,31109658,31110015,31110162,31110481,31110606,31110780,31111111,31112015,31112439,31112578,31112868,31113303,31113831,31113920,31114210,31114471,31114683,31114988,31115255,31115563,31115867,31115968,31116236,31116516,31116681,31116920,31117238,31117691,31117729,31117954,31118624,31118756,31118949,31119199,31119404,31119695,31119824,31120029,31120309,31120436,31120695,31121027,31121189,31121531,31121841,31121966,31122172,31122575,31122895,31123086,31123371,31123637,31124109,31124335,31124584,31124832,31125075,31125338,31125594,31127163,31127714,31127752,31127782,31127817,31127850,31127882,31128329,31128375,31128416,31128997,31129069,31129360,31129434,31129664,31129955,31130212,31130575,31130943,31130983,31131023,31131100,31131273,31131356,31131689,31131952,31132008,31132223,31133255,31133289,31133718,31133799,31133841,31133869,3113395 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195434, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31102742,31103333,31104206,31108858,31110018,31110168,31110603,31113829,31114218,31114469,31114690,31115556,31116228,31119693,31119827,31120443,31120696,31124577,31125328,31127159,31127819,31129661,31129957,31130217,31130573,31130945,31131354,31131955,31134074,31134112,31134549,31134582,31134906,31135139,31135916,31137442,31138133,31139202,31139292,31139635,31140007,31140321,31149382,31149678,31150338,31151098,31154369,31155336,31155931,31156233,31158997,31160868,31160977,31161083,31162921,31162997,31163463,31164121,31166909,31166948,31166982,31167533,31168700,31170022,31170053,31170099,31170140,31170268,31170310,31170369,31170418,31170646,31170750,31171393,31173033,31173072,31173233,31173276,31173316,31173348,31173385,31175096,31175136,31175246,31175288,31175330,31175373,31176213,31176245,31179003,31179383,31179663,31179920,31180420,31180646,31180868,31181040,31181156,31184109,31184434,31185017,31186544,31186839,31189771,31190052,31190290,31190551,31194744,31194997,31195232,31200217,31205467,31206701,3120757 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31195428,31195429,31195430,31195431,31195432,31195433,31195434?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2026-09-01' and date <= '2026-09-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1573,),), 'unwanted_material_monthly_percentage': ((0.8890112501069118,),), 'material_repartition': (('incineration', 1572),), 'material_dict': {'incineration': 1572}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 9, 1), 0.9538512579782608, 4), (datetime.date(2026, 9, 2), 0.9526576194682628, 2), (datetime.date(2026, 9, 3), 0.940637816239077, 2), (datetime.date(2026, 9, 4), 0.9316191456831745, 3), (datetime.date(2026, 9, 5), 0.9176997353149637, 3), (datetime.date(2026, 9, 6), 0.8888661868770995, 2), (datetime.date(2026, 9, 7), 0.9159439366253582, 2), (datetime.date(2026, 9, 8), 0.9125179778426291, 2), (datetime.date(2026, 9, 9), 0.9009041897660901, 1), (datetime.date(2026, 9, 10), 0.9105000901866234, 3), (datetime.date(2026, 9, 11), 0.9000718439776128, 1), (datetime.date(2026, 9, 12), 0.9059875731965183, 2), (datetime.date(2026, 9, 13), 0.900200374992515, 2), (datetime.date(2026, 9, 14), 0.8990390594670202, 2), (datetime.date(2026, 9, 15), 0.9040092436508275, 3), (datetime.date(2026, 9, 16), 0.9304939782309143, 2), (datetime.date(2026, 9, 17), 0.9163933750223434, 2), (datetime.date(2026, 9, 18), 0.931551074416864, 3), (datetime.date(2026, 9, 19), 0.9194386350738438, 3), (datetime.date(2026, 9, 20), 0.915793554104075, 2), (datetime.date(2026, 9, 21), 0.9097361559874708, 1), (datetime.date(2026, 9, 22), 0.9237405861194358, 1), (datetime.date(2026, 9, 23), 0.7833457657441472, 2), (datetime.date(2026, 9, 24), 0.6957922594364896, 2), (datetime.date(2026, 9, 25), 0.7191343931646158, 2), (datetime.date(2026, 9, 26), 0.7581889844619039, 2), (datetime.date(2026, 9, 27), 0.7644351258268582, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 9, 1), 0.9538512579782608, 4), (datetime.date(2026, 9, 2), 0.9526576194682628, 2), (datetime.date(2026, 9, 3), 0.940637816239077, 2), (datetime.date(2026, 9, 4), 0.9316191456831745, 3), (datetime.date(2026, 9, 5), 0.9176997353149637, 3), (datetime.date(2026, 9, 6), 0.8888661868770995, 2), (datetime.date(2026, 9, 7), 0.9159439366253582, 2), (datetime.date(2026, 9, 8), 0.9125179778426291, 2), (datetime.date(2026, 9, 9), 0.9009041897660901, 1), (datetime.date(2026, 9, 10), 0.9105000901866234, 3), (datetime.date(2026, 9, 11), 0.9000718439776128, 1), (datetime.date(2026, 9, 12), 0.9059875731965183, 2), (datetime.date(2026, 9, 13), 0.900200374992515, 2), (datetime.date(2026, 9, 14), 0.8990390594670202, 2), (datetime.date(2026, 9, 15), 0.9040092436508275, 3), (datetime.date(2026, 9, 16), 0.9304939782309143, 2), (datetime.date(2026, 9, 17), 0.9163933750223434, 2), (datetime.date(2026, 9, 18), 0.931551074416864, 3), (datetime.date(2026, 9, 19), 0.9194386350738438, 3), (datetime.date(2026, 9, 20), 0.915793554104075, 2), (datetime.date(2026, 9, 21), 0.9097361559874708, 1), (datetime.date(2026, 9, 22), 0.9237405861194358, 1), (datetime.date(2026, 9, 23), 0.7833457657441472, 2), (datetime.date(2026, 9, 24), 0.6957922594364896, 2), (datetime.date(2026, 9, 25), 0.7191343931646158, 2), (datetime.date(2026, 9, 26), 0.7581889844619039, 2), (datetime.date(2026, 9, 27), 0.7644351258268582, 2))}, 'quality_array': [['-0.9761994374481754', '01092026'], ['-0.7454300262790777', '02092026'], ['-1.3948722243850296', '03092026'], ['-2.4417051724603196', '04092026'], ['-2.7246961987396', '05092026'], ['-3.1943900471242492', '06092026'], ['-2.7036703803885493', '07092026'], ['-2.339399656880901', '08092026'], ['-2.371909224583474', '09092026'], ['-2.2511034135486288', '10092026'], ['-2.7262184872300965', '11092026'], ['-2.5282113137910556', '12092026'], ['-2.7353229402628445', '13092026'], ['-2.6416337356898345', '14092026'], ['-2.6186972221522886', '15092026'], ['-2.0476448964897664', '16092026'], ['-2.1387896349953603', '17092026'], ['-1.8338383193212118', '18092026'], ['-2.1631783944884746', '19092026'], ['-2.228884101078126', '20092026'], ['-2.3196553962524025', '21092026'], ['-1.99805426017423', '22092026'], ['-6.344876017071158', '23092026'], ['-9.011202246633045', '24092026'], ['-9.052811972707737', '25092026'], ['-8.922264271093917', '26092026'], ['-9.078886006431551', '27092026']], 'number_of_batch': ((619,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00833621680785237, 'nb_photo': 5425, 'list_port_cont': '31101304,31101595,31102371,31102738,31102859,31103321,31103547,31103830,31104207,31104393,31104532,31104892,31104933,31105111,31105319,31105554,31105832,31105873,31106561,31106771,31107494,31107726,31107999,31108316,31108724,31108844,31109608,31109653,31110012,31110157,31110468,31110604,31110782,31111101,31111225,31111750,31113535,31113830,31113917,31114223,31114468,31114698,31114977,31115266,31115560,31115852,31115964,31116238,31116517,31116672,31116904,31117942,31118559,31118637,31118758,31118950,31119187,31119388,31119696,31119814,31120031,31120313,31120444,31120683,31121013,31121190,31121532,31121844,31121972,31122173,31122562,31122891,31123366,31123639,31123876,31124115,31124319,31124574,31124829,31125085,31125326,31125603,31127152,31127699,31127751,31127784,31127824,31127854,31127889,31128327,31128377,31128411,31128988,31129065,31129356,31129423,31129637,31130220,31130578,31130938,31130970,31131022,31131102,31131274,31131362,31131688,31131948,31132000,31133243,31133301,31133713,31133763,31133802,3113383', 'assoc_port': '31101205:31101304,31101500:31101595,31102242:31102371,31102548:31102738,31102781:31102859,31103149:31103321,31103400:31103547,31103602:31103830,31103861:31104207,31104237:31104393,31104455:31104532,31104675:31104892,31104676:31104933,31105012:31105111,31105216:31105319,31105386:31105554,31105670:31105832,31105671:31105873,31106478:31106561,31106715:31106771,31107400:31107494,31107664:31107726,31107931:31107999,31108204:31108316,31108484:31108724,31108779:31108844,31109135:31109653,31109395:31109608,31109732:31110012,31110043:31110157,31110291:31110468,31110505:31110604,31110680:31110782,31110890:31111101,31111134:31111225,31111550:31111750,31113484:31113535,31113693:31113830,31113864:31113917,31114142:31114223,31114404:31114468,31114673:31114698,31114849:31114977,31115094:31115266,31115348:31115560,31115622:31115852,31115896:31115964,31116137:31116238,31116382:31116517,31116620:31116672,31116823:31116904,31117863:31117942,31118390:31118559,31118391:31118637,31118697:31118758,31118856:31118950,31119058:3111918', 'assoc_mat': '31101205:autre:4230:31101304,31101500:autre:4230:31101595,31102242:autre:4230:31102371,31102548:autre:4230:31102738,31102781:autre:4230:31102859,31103149:autre:4230:31103321,31103400:autre:4230:31103547,31103602:autre:4230:31103830,31103861:autre:4230:31104207,31104237:autre:4230:31104393,31104455:autre:4230:31104532,31104675:autre:4230:31104892,31104676:autre:4230:31104933,31105012:autre:4230:31105111,31105216:autre:4230:31105319,31105386:autre:4230:31105554,31105670:autre:4230:31105832,31105671:autre:4230:31105873,31106478:autre:4230:31106561,31106715:autre:4230:31106771,31107400:autre:4230:31107494,31107664:autre:4230:31107726,31107931:autre:4230:31107999,31108204:autre:4230:31108316,31108484:autre:4230:31108724,31108779:autre:4230:31108844,31109135:autre:4230:31109653,31109395:autre:4230:31109608,31109732:autre:4230:31110012,31110043:autre:4230:31110157,31110291:autre:4230:31110468,31110505:autre:4230:31110604,31110680:autre:4230:31110782,31110890:autre:4230:31111101,31111134:autre:4230:31111225,31111550:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04139735648743596, 'nb_photo': 27142, 'list_port_cont': '31100345,31100597,31100814,31101317,31101600,31101817,31102042,31102380,31102740,31102862,31103322,31103552,31103829,31104210,31104390,31104541,31104900,31104947,31105114,31105324,31105557,31105846,31105884,31106111,31106296,31106568,31106779,31107077,31107236,31107504,31107736,31108010,31108317,31108719,31108857,31109611,31109656,31110006,31110164,31110480,31110613,31110784,31111110,31111235,31111722,31111760,31111802,31112013,31112166,31112448,31112577,31112876,31113076,31113302,31113544,31113820,31113929,31114215,31114465,31114692,31114983,31115263,31115562,31115862,31115976,31116237,31116519,31116683,31116914,31117245,31117284,31117688,31117719,31117952,31117988,31118563,31118631,31118763,31118948,31119193,31119401,31119692,31119818,31120021,31120316,31120440,31120693,31121021,31121194,31121533,31121839,31121971,31122170,31122449,31122574,31122894,31123079,31123373,31123627,31123879,31124112,31124323,31124580,31124827,31125082,31125339,31125599,31127161,31127707,31127747,31127788,31127820,31127858,3112789', 'assoc_port': '31100287:31100345,31100520:31100597,31100752:31100814,31101205:31101317,31101500:31101600,31101746:31101817,31101975:31102042,31102242:31102380,31102548:31102740,31102781:31102862,31103149:31103322,31103400:31103552,31103602:31103829,31103861:31104210,31104237:31104390,31104455:31104541,31104675:31104900,31104676:31104947,31105012:31105114,31105216:31105324,31105386:31105557,31105670:31105846,31105671:31105884,31106048:31106111,31106282:31106296,31106478:31106568,31106715:31106779,31106963:31107077,31107221:31107236,31107400:31107504,31107664:31107736,31107931:31108010,31108204:31108317,31108484:31108719,31108779:31108857,31109135:31109656,31109395:31109611,31109732:31110006,31110043:31110164,31110291:31110480,31110505:31110613,31110680:31110784,31110890:31111110,31111134:31111235,31111304:31111802,31111549:31111722,31111550:31111760,31111917:31112013,31112150:31112166,31112352:31112448,31112553:31112577,31112726:31112876,31113019:31113076,31113233:31113302,31113484:31113544,31113693:31113820,31113864:3111392', 'assoc_mat': '31100287:carton:4230:31100345,31100520:carton:4230:31100597,31100752:carton:4230:31100814,31101205:carton:4230:31101317,31101500:carton:4230:31101600,31101746:carton:4230:31101817,31101975:carton:4230:31102042,31102242:carton:4230:31102380,31102548:carton:4230:31102740,31102781:carton:4230:31102862,31103149:carton:4230:31103322,31103400:carton:4230:31103552,31103602:carton:4230:31103829,31103861:carton:4230:31104210,31104237:carton:4230:31104390,31104455:carton:4230:31104541,31104675:carton:4230:31104900,31104676:carton:4230:31104947,31105012:carton:4230:31105114,31105216:carton:4230:31105324,31105386:carton:4230:31105557,31105670:carton:4230:31105846,31105671:carton:4230:31105884,31106048:carton:4230:31106111,31106282:carton:4230:31106296,31106478:carton:4230:31106568,31106715:carton:4230:31106779,31106963:carton:4230:31107077,31107221:carton:4230:31107236,31107400:carton:4230:31107504,31107664:carton:4230:31107736,31107931:carton:4230:31108010,31108204:carton:4230:31108317,31108484:carton:4230:31108719,3110'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013377244429123084, 'nb_photo': 593, 'list_port_cont': '31104203,31104387,31104525,31107506,31108852,31109606,31110008,31114458,31114688,31114991,31115257,31115551,31115853,31117683,31117956,31118632,31119697,31120304,31124333,31125083,31125322,31125607,31127153,31131021,31133293,31134073,31134535,31134568,31137756,31138117,31138886,31139193,31139283,31139631,31140863,31141224,31145699,31146744,31147987,31150326,31150821,31151334,31151584,31151618,31151959,31152169,31152421,31152632,31152872,31153218,31153433,31153686,31154934,31155307,31155345,31155385,31155854,31155898,31155929,31156225,31156271,31156353,31156719,31157156,31158743,31159208,31160907,31160943,31160978,31161006,31161042,31161127,31161786,31161817,31161863,31162060,31162274,31162340,31162626,31162699,31162918,31162982,31164073,31164325,31164667,31165747,31165781,31165814,31165939,31166357,31166977,31167520,31167831,31168125,31168614,31168654,31168731,31169186,31169218,31170010,31170057,31170098,31170133,31170235,31170261,31170375,31170410,31170653,31170740,31170862,31171120,31171461,31171722,3117177', 'assoc_port': '31103861:31104203,31104237:31104387,31104455:31104525,31107400:31107506,31108779:31108852,31109395:31109606,31109732:31110008,31114404:31114458,31114673:31114688,31114849:31114991,31115094:31115257,31115348:31115551,31115622:31115853,31117558:31117683,31117863:31117956,31118391:31118632,31119547:31119697,31120175:31120304,31124231:31124333,31124977:31125083,31125233:31125322,31125504:31125607,31125823:31127153,31130606:31131021,31132616:31133293,31132808:31134073,31134221:31134535,31134222:31134568,31137686:31137756,31138033:31138117,31138773:31138886,31139004:31139193,31139227:31139283,31139494:31139631,31140612:31140863,31140894:31141224,31145472:31145699,31146589:31146744,31147905:31147987,31150102:31150326,31150647:31150821,31151149:31151334,31151411:31151584,31151463:31151618,31151780:31151959,31151990:31152169,31152249:31152421,31152463:31152632,31152737:31152872,31153168:31153218,31153367:31153433,31153582:31153686,31154679:31154934,31155000:31155854,31155034:31155307,31155151:31155345,31155224:3115538', 'assoc_mat': '31103861:metal:4230:31104203,31104237:metal:4230:31104387,31104455:metal:4230:31104525,31107400:metal:4230:31107506,31108779:metal:4230:31108852,31109395:metal:4230:31109606,31109732:metal:4230:31110008,31114404:metal:4230:31114458,31114673:metal:4230:31114688,31114849:metal:4230:31114991,31115094:metal:4230:31115257,31115348:metal:4230:31115551,31115622:metal:4230:31115853,31117558:metal:4230:31117683,31117863:metal:4230:31117956,31118391:metal:4230:31118632,31119547:metal:4230:31119697,31120175:metal:4230:31120304,31124231:metal:4230:31124333,31124977:metal:4230:31125083,31125233:metal:4230:31125322,31125504:metal:4230:31125607,31125823:metal:4230:31127153,31130606:metal:4230:31131021,31132616:metal:4230:31133293,31132808:metal:4230:31134073,31134221:metal:4230:31134535,31134222:metal:4230:31134568,31137686:metal:4230:31137756,31138033:metal:4230:31138117,31138773:metal:4230:31138886,31139004:metal:4230:31139193,31139227:metal:4230:31139283,31139494:metal:4230:31139631,31140612:metal:4230:31140863,31140894:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.14999512369154486, 'nb_photo': 112729, 'list_port_cont': '31100343,31100598,31100812,31101309,31101392,31101601,31101810,31102050,31102376,31102741,31102867,31103334,31103554,31103832,31104214,31104395,31104537,31104902,31104946,31105107,31105326,31105567,31105842,31105881,31106108,31106305,31106574,31106781,31107075,31107249,31107505,31107732,31108002,31108307,31108718,31108854,31109607,31109657,31110016,31110160,31110471,31110607,31110789,31111104,31111242,31111721,31111759,31111800,31112011,31112170,31112449,31112564,31112869,31113086,31113299,31113545,31113825,31113933,31114224,31114461,31114697,31114990,31115268,31115564,31115861,31115978,31116234,31116515,31116679,31116918,31117242,31117283,31117693,31117724,31117955,31117991,31118560,31118630,31118762,31118942,31119185,31119403,31119691,31119828,31120030,31120317,31120437,31120700,31121024,31121186,31121528,31121845,31121968,31122175,31122452,31122564,31122886,31123087,31123375,31123641,31123875,31124118,31124328,31124585,31124833,31125081,31125333,31125600,31127164,31127706,31127742,31127787,31127823,3112785', 'assoc_port': '31100287:31100343,31100520:31100598,31100752:31100812,31100990:31101392,31101205:31101309,31101500:31101601,31101746:31101810,31101975:31102050,31102242:31102376,31102548:31102741,31102781:31102867,31103149:31103334,31103400:31103554,31103602:31103832,31103861:31104214,31104237:31104395,31104455:31104537,31104675:31104902,31104676:31104946,31105012:31105107,31105216:31105326,31105386:31105567,31105670:31105842,31105671:31105881,31106048:31106108,31106282:31106305,31106478:31106574,31106715:31106781,31106963:31107075,31107221:31107249,31107400:31107505,31107664:31107732,31107931:31108002,31108204:31108307,31108484:31108718,31108779:31108854,31109135:31109657,31109395:31109607,31109732:31110016,31110043:31110160,31110291:31110471,31110505:31110607,31110680:31110789,31110890:31111104,31111134:31111242,31111304:31111800,31111549:31111721,31111550:31111759,31111917:31112011,31112150:31112170,31112352:31112449,31112553:31112564,31112726:31112869,31113019:31113086,31113233:31113299,31113484:31113545,31113693:3111382', 'assoc_mat': '31100287:papier:4230:31100343,31100520:papier:4230:31100598,31100752:papier:4230:31100812,31100990:papier:4230:31101392,31101205:papier:4230:31101309,31101500:papier:4230:31101601,31101746:papier:4230:31101810,31101975:papier:4230:31102050,31102242:papier:4230:31102376,31102548:papier:4230:31102741,31102781:papier:4230:31102867,31103149:papier:4230:31103334,31103400:papier:4230:31103554,31103602:papier:4230:31103832,31103861:papier:4230:31104214,31104237:papier:4230:31104395,31104455:papier:4230:31104537,31104675:papier:4230:31104902,31104676:papier:4230:31104946,31105012:papier:4230:31105107,31105216:papier:4230:31105326,31105386:papier:4230:31105567,31105670:papier:4230:31105842,31105671:papier:4230:31105881,31106048:papier:4230:31106108,31106282:papier:4230:31106305,31106478:papier:4230:31106574,31106715:papier:4230:31106781,31106963:papier:4230:31107075,31107221:papier:4230:31107249,31107400:papier:4230:31107505,31107664:papier:4230:31107732,31107931:papier:4230:31108002,31108204:papier:4230:31108307,3110'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0031306166711609364, 'nb_photo': 968, 'list_port_cont': '31102734,31104897,31104944,31108001,31108312,31108722,31108856,31109650,31110155,31110479,31111109,31113828,31113931,31114220,31114467,31115555,31115866,31115974,31116235,31119198,31119402,31119686,31119825,31120032,31120311,31120445,31121025,31121193,31121526,31121846,31124828,31125089,31125606,31127167,31127708,31127745,31127780,31127813,31127852,31127896,31129429,31129953,31130222,31130572,31130940,31130984,31131361,31131683,31131949,31133832,31133908,31133993,31134068,31134110,31134546,31134577,31134895,31135137,31135421,31135636,31135890,31135931,31136239,31138879,31139201,31139290,31139629,31140004,31140319,31140581,31140869,31141135,31141214,31141436,31141540,31141749,31143150,31143712,31143769,31144397,31144568,31144836,31145177,31145450,31145715,31145967,31146205,31146486,31146567,31146752,31147194,31149380,31149674,31150052,31150340,31150619,31150822,31151332,31151593,31151631,31151963,31152176,31154076,31155298,31155349,31155384,31155859,31155897,31155936,31156232,31156275,31156350,31157274,3115735', 'assoc_port': '31102548:31102734,31104675:31104897,31104676:31104944,31107931:31108001,31108204:31108312,31108484:31108722,31108779:31108856,31109135:31109650,31110043:31110155,31110291:31110479,31110890:31111109,31113693:31113828,31113864:31113931,31114142:31114220,31114404:31114467,31115348:31115555,31115622:31115866,31115896:31115974,31116137:31116235,31119058:31119198,31119304:31119402,31119547:31119686,31119767:31119825,31120007:31120032,31120175:31120311,31120422:31120445,31120880:31121025,31121094:31121193,31121374:31121526,31121641:31121846,31124691:31124828,31124977:31125089,31125504:31125606,31125823:31127167,31127186:31127708,31127187:31127745,31127188:31127780,31127189:31127813,31127190:31127852,31127191:31127896,31129105:31129429,31129709:31129953,31129937:31130222,31130280:31130572,31130604:31130940,31130605:31130984,31131167:31131361,31131631:31131683,31131789:31131949,31132677:31133832,31132679:31133908,31132681:31133993,31132808:31134068,31133195:31134110,31134221:31134546,31134222:31134577,31134643:3113489', 'assoc_mat': '31102548:pehd:4230:31102734,31104675:pehd:4230:31104897,31104676:pehd:4230:31104944,31107931:pehd:4230:31108001,31108204:pehd:4230:31108312,31108484:pehd:4230:31108722,31108779:pehd:4230:31108856,31109135:pehd:4230:31109650,31110043:pehd:4230:31110155,31110291:pehd:4230:31110479,31110890:pehd:4230:31111109,31113693:pehd:4230:31113828,31113864:pehd:4230:31113931,31114142:pehd:4230:31114220,31114404:pehd:4230:31114467,31115348:pehd:4230:31115555,31115622:pehd:4230:31115866,31115896:pehd:4230:31115974,31116137:pehd:4230:31116235,31119058:pehd:4230:31119198,31119304:pehd:4230:31119402,31119547:pehd:4230:31119686,31119767:pehd:4230:31119825,31120007:pehd:4230:31120032,31120175:pehd:4230:31120311,31120422:pehd:4230:31120445,31120880:pehd:4230:31121025,31121094:pehd:4230:31121193,31121374:pehd:4230:31121526,31121641:pehd:4230:31121846,31124691:pehd:4230:31124828,31124977:pehd:4230:31125089,31125504:pehd:4230:31125606,31125823:pehd:4230:31127167,31127186:pehd:4230:31127708,31127187:pehd:4230:31127745,31127188:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007179663552443536, 'nb_photo': 6084, 'list_port_cont': '31100806,31101814,31102046,31102375,31102737,31102866,31103328,31103557,31103819,31104212,31104394,31104542,31104898,31104942,31105321,31108008,31108311,31108710,31108849,31109597,31109658,31110015,31110162,31110481,31110606,31110780,31111111,31112015,31112439,31112578,31112868,31113303,31113831,31113920,31114210,31114471,31114683,31114988,31115255,31115563,31115867,31115968,31116236,31116516,31116681,31116920,31117238,31117691,31117729,31117954,31118624,31118756,31118949,31119199,31119404,31119695,31119824,31120029,31120309,31120436,31120695,31121027,31121189,31121531,31121841,31121966,31122172,31122575,31122895,31123086,31123371,31123637,31124109,31124335,31124584,31124832,31125075,31125338,31125594,31127163,31127714,31127752,31127782,31127817,31127850,31127882,31128329,31128375,31128416,31128997,31129069,31129360,31129434,31129664,31129955,31130212,31130575,31130943,31130983,31131023,31131100,31131273,31131356,31131689,31131952,31132008,31132223,31133255,31133289,31133718,31133799,31133841,31133869,3113395', 'assoc_port': '31100752:31100806,31101746:31101814,31101975:31102046,31102242:31102375,31102548:31102737,31102781:31102866,31103149:31103328,31103400:31103557,31103602:31103819,31103861:31104212,31104237:31104394,31104455:31104542,31104675:31104898,31104676:31104942,31105216:31105321,31107931:31108008,31108204:31108311,31108484:31108710,31108779:31108849,31109135:31109658,31109395:31109597,31109732:31110015,31110043:31110162,31110291:31110481,31110505:31110606,31110680:31110780,31110890:31111111,31111917:31112015,31112352:31112439,31112553:31112578,31112726:31112868,31113233:31113303,31113693:31113831,31113864:31113920,31114142:31114210,31114404:31114471,31114673:31114683,31114849:31114988,31115094:31115255,31115348:31115563,31115622:31115867,31115896:31115968,31116137:31116236,31116382:31116516,31116620:31116681,31116823:31116920,31117099:31117238,31117558:31117691,31117559:31117729,31117863:31117954,31118391:31118624,31118697:31118756,31118856:31118949,31119058:31119199,31119304:31119404,31119547:31119695,31119767:3111982', 'assoc_mat': '31100752:pet_clair:4230:31100806,31101746:pet_clair:4230:31101814,31101975:pet_clair:4230:31102046,31102242:pet_clair:4230:31102375,31102548:pet_clair:4230:31102737,31102781:pet_clair:4230:31102866,31103149:pet_clair:4230:31103328,31103400:pet_clair:4230:31103557,31103602:pet_clair:4230:31103819,31103861:pet_clair:4230:31104212,31104237:pet_clair:4230:31104394,31104455:pet_clair:4230:31104542,31104675:pet_clair:4230:31104898,31104676:pet_clair:4230:31104942,31105216:pet_clair:4230:31105321,31107931:pet_clair:4230:31108008,31108204:pet_clair:4230:31108311,31108484:pet_clair:4230:31108710,31108779:pet_clair:4230:31108849,31109135:pet_clair:4230:31109658,31109395:pet_clair:4230:31109597,31109732:pet_clair:4230:31110015,31110043:pet_clair:4230:31110162,31110291:pet_clair:4230:31110481,31110505:pet_clair:4230:31110606,31110680:pet_clair:4230:31110780,31110890:pet_clair:4230:31111111,31111917:pet_clair:4230:31112015,31112352:pet_clair:4230:31112439,31112553:pet_clair:4230:31112578,31112726:pet_clair:4230:31112868,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002254607773608, 'nb_photo': 250, 'list_port_cont': '31102742,31103333,31104206,31108858,31110018,31110168,31110603,31113829,31114218,31114469,31114690,31115556,31116228,31119693,31119827,31120443,31120696,31124577,31125328,31127159,31127819,31129661,31129957,31130217,31130573,31130945,31131354,31131955,31134074,31134112,31134549,31134582,31134906,31135139,31135916,31137442,31138133,31139202,31139292,31139635,31140007,31140321,31149382,31149678,31150338,31151098,31154369,31155336,31155931,31156233,31158997,31160868,31160977,31161083,31162921,31162997,31163463,31164121,31166909,31166948,31166982,31167533,31168700,31170022,31170053,31170099,31170140,31170268,31170310,31170369,31170418,31170646,31170750,31171393,31173033,31173072,31173233,31173276,31173316,31173348,31173385,31175096,31175136,31175246,31175288,31175330,31175373,31176213,31176245,31179003,31179383,31179663,31179920,31180420,31180646,31180868,31181040,31181156,31184109,31184434,31185017,31186544,31186839,31189771,31190052,31190290,31190551,31194744,31194997,31195232,31200217,31205467,31206701,3120757', 'assoc_port': '31102548:31102742,31103149:31103333,31103861:31104206,31108779:31108858,31109732:31110018,31110043:31110168,31110505:31110603,31113693:31113829,31114142:31114218,31114404:31114469,31114673:31114690,31115348:31115556,31116137:31116228,31119547:31119693,31119767:31119827,31120422:31120443,31120629:31120696,31124478:31124577,31125233:31125328,31125823:31127159,31127189:31127819,31129465:31129661,31129709:31129957,31129937:31130217,31130280:31130573,31130604:31130945,31131167:31131354,31131789:31131955,31132808:31134074,31133195:31134112,31134221:31134549,31134222:31134582,31134643:31134906,31134928:31135139,31135666:31135916,31137321:31137442,31138033:31138133,31139004:31139202,31139227:31139292,31139494:31139635,31139776:31140007,31140031:31140321,31149242:31149382,31149534:31149678,31150102:31150338,31150858:31151098,31154199:31154369,31155151:31155336,31155488:31155931,31156002:31156233,31158932:31158997,31159671:31173033,31159847:31173072,31159888:31160868,31160016:31160977,31160079:31161083,31162509:3116292', 'assoc_mat': '31102548:pet_fonce:4230:31102742,31103149:pet_fonce:4230:31103333,31103861:pet_fonce:4230:31104206,31108779:pet_fonce:4230:31108858,31109732:pet_fonce:4230:31110018,31110043:pet_fonce:4230:31110168,31110505:pet_fonce:4230:31110603,31113693:pet_fonce:4230:31113829,31114142:pet_fonce:4230:31114218,31114404:pet_fonce:4230:31114469,31114673:pet_fonce:4230:31114690,31115348:pet_fonce:4230:31115556,31116137:pet_fonce:4230:31116228,31119547:pet_fonce:4230:31119693,31119767:pet_fonce:4230:31119827,31120422:pet_fonce:4230:31120443,31120629:pet_fonce:4230:31120696,31124478:pet_fonce:4230:31124577,31125233:pet_fonce:4230:31125328,31125823:pet_fonce:4230:31127159,31127189:pet_fonce:4230:31127819,31129465:pet_fonce:4230:31129661,31129709:pet_fonce:4230:31129957,31129937:pet_fonce:4230:31130217,31130280:pet_fonce:4230:31130573,31130604:pet_fonce:4230:31130945,31131167:pet_fonce:4230:31131354,31131789:pet_fonce:4230:31131955,31132808:pet_fonce:4230:31134074,31133195:pet_fonce:4230:31134112,31134221:pet_fonce:4230:31134549,3'}), 'main_stat': {'nb_photos': 1573}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31195428,31195429,31195430,31195431,31195432,31195433,31195434?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-09', 0.8890112501069118),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1573,),), 'unwanted_material_monthly_percentage': ((0.8890112501069118,),), 'material_repartition': (('incineration', 1572),), 'material_dict': {'incineration': 1572}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 9, 1), 0.9538512579782608, 4), (datetime.date(2026, 9, 2), 0.9526576194682628, 2), (datetime.date(2026, 9, 3), 0.940637816239077, 2), (datetime.date(2026, 9, 4), 0.9316191456831745, 3), (datetime.date(2026, 9, 5), 0.9176997353149637, 3), (datetime.date(2026, 9, 6), 0.8888661868770995, 2), (datetime.date(2026, 9, 7), 0.9159439366253582, 2), (datetime.date(2026, 9, 8), 0.9125179778426291, 2), (datetime.date(2026, 9, 9), 0.9009041897660901, 1), (datetime.date(2026, 9, 10), 0.9105000901866234, 3), (datetime.date(2026, 9, 11), 0.9000718439776128, 1), (datetime.date(2026, 9, 12), 0.9059875731965183, 2), (datetime.date(2026, 9, 13), 0.900200374992515, 2), (datetime.date(2026, 9, 14), 0.8990390594670202, 2), (datetime.date(2026, 9, 15), 0.9040092436508275, 3), (datetime.date(2026, 9, 16), 0.9304939782309143, 2), (datetime.date(2026, 9, 17), 0.9163933750223434, 2), (datetime.date(2026, 9, 18), 0.931551074416864, 3), (datetime.date(2026, 9, 19), 0.9194386350738438, 3), (datetime.date(2026, 9, 20), 0.915793554104075, 2), (datetime.date(2026, 9, 21), 0.9097361559874708, 1), (datetime.date(2026, 9, 22), 0.9237405861194358, 1), (datetime.date(2026, 9, 23), 0.7833457657441472, 2), (datetime.date(2026, 9, 24), 0.6957922594364896, 2), (datetime.date(2026, 9, 25), 0.7191343931646158, 2), (datetime.date(2026, 9, 26), 0.7581889844619039, 2), (datetime.date(2026, 9, 27), 0.7644351258268582, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 9, 1), 0.9538512579782608, 4), (datetime.date(2026, 9, 2), 0.9526576194682628, 2), (datetime.date(2026, 9, 3), 0.940637816239077, 2), (datetime.date(2026, 9, 4), 0.9316191456831745, 3), (datetime.date(2026, 9, 5), 0.9176997353149637, 3), (datetime.date(2026, 9, 6), 0.8888661868770995, 2), (datetime.date(2026, 9, 7), 0.9159439366253582, 2), (datetime.date(2026, 9, 8), 0.9125179778426291, 2), (datetime.date(2026, 9, 9), 0.9009041897660901, 1), (datetime.date(2026, 9, 10), 0.9105000901866234, 3), (datetime.date(2026, 9, 11), 0.9000718439776128, 1), (datetime.date(2026, 9, 12), 0.9059875731965183, 2), (datetime.date(2026, 9, 13), 0.900200374992515, 2), (datetime.date(2026, 9, 14), 0.8990390594670202, 2), (datetime.date(2026, 9, 15), 0.9040092436508275, 3), (datetime.date(2026, 9, 16), 0.9304939782309143, 2), (datetime.date(2026, 9, 17), 0.9163933750223434, 2), (datetime.date(2026, 9, 18), 0.931551074416864, 3), (datetime.date(2026, 9, 19), 0.9194386350738438, 3), (datetime.date(2026, 9, 20), 0.915793554104075, 2), (datetime.date(2026, 9, 21), 0.9097361559874708, 1), (datetime.date(2026, 9, 22), 0.9237405861194358, 1), (datetime.date(2026, 9, 23), 0.7833457657441472, 2), (datetime.date(2026, 9, 24), 0.6957922594364896, 2), (datetime.date(2026, 9, 25), 0.7191343931646158, 2), (datetime.date(2026, 9, 26), 0.7581889844619039, 2), (datetime.date(2026, 9, 27), 0.7644351258268582, 2))}, 'quality_array': [['-0.9761994374481754', '01092026'], ['-0.7454300262790777', '02092026'], ['-1.3948722243850296', '03092026'], ['-2.4417051724603196', '04092026'], ['-2.7246961987396', '05092026'], ['-3.1943900471242492', '06092026'], ['-2.7036703803885493', '07092026'], ['-2.339399656880901', '08092026'], ['-2.371909224583474', '09092026'], ['-2.2511034135486288', '10092026'], ['-2.7262184872300965', '11092026'], ['-2.5282113137910556', '12092026'], ['-2.7353229402628445', '13092026'], ['-2.6416337356898345', '14092026'], ['-2.6186972221522886', '15092026'], ['-2.0476448964897664', '16092026'], ['-2.1387896349953603', '17092026'], ['-1.8338383193212118', '18092026'], ['-2.1631783944884746', '19092026'], ['-2.228884101078126', '20092026'], ['-2.3196553962524025', '21092026'], ['-1.99805426017423', '22092026'], ['-6.344876017071158', '23092026'], ['-9.011202246633045', '24092026'], ['-9.052811972707737', '25092026'], ['-8.922264271093917', '26092026'], ['-9.078886006431551', '27092026']], 'number_of_batch': ((619,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00833621680785237, 'nb_photo': 5425, 'list_port_cont': '31101304,31101595,31102371,31102738,31102859,31103321,31103547,31103830,31104207,31104393,31104532,31104892,31104933,31105111,31105319,31105554,31105832,31105873,31106561,31106771,31107494,31107726,31107999,31108316,31108724,31108844,31109608,31109653,31110012,31110157,31110468,31110604,31110782,31111101,31111225,31111750,31113535,31113830,31113917,31114223,31114468,31114698,31114977,31115266,31115560,31115852,31115964,31116238,31116517,31116672,31116904,31117942,31118559,31118637,31118758,31118950,31119187,31119388,31119696,31119814,31120031,31120313,31120444,31120683,31121013,31121190,31121532,31121844,31121972,31122173,31122562,31122891,31123366,31123639,31123876,31124115,31124319,31124574,31124829,31125085,31125326,31125603,31127152,31127699,31127751,31127784,31127824,31127854,31127889,31128327,31128377,31128411,31128988,31129065,31129356,31129423,31129637,31130220,31130578,31130938,31130970,31131022,31131102,31131274,31131362,31131688,31131948,31132000,31133243,31133301,31133713,31133763,31133802,3113383', 'assoc_port': '31101205:31101304,31101500:31101595,31102242:31102371,31102548:31102738,31102781:31102859,31103149:31103321,31103400:31103547,31103602:31103830,31103861:31104207,31104237:31104393,31104455:31104532,31104675:31104892,31104676:31104933,31105012:31105111,31105216:31105319,31105386:31105554,31105670:31105832,31105671:31105873,31106478:31106561,31106715:31106771,31107400:31107494,31107664:31107726,31107931:31107999,31108204:31108316,31108484:31108724,31108779:31108844,31109135:31109653,31109395:31109608,31109732:31110012,31110043:31110157,31110291:31110468,31110505:31110604,31110680:31110782,31110890:31111101,31111134:31111225,31111550:31111750,31113484:31113535,31113693:31113830,31113864:31113917,31114142:31114223,31114404:31114468,31114673:31114698,31114849:31114977,31115094:31115266,31115348:31115560,31115622:31115852,31115896:31115964,31116137:31116238,31116382:31116517,31116620:31116672,31116823:31116904,31117863:31117942,31118390:31118559,31118391:31118637,31118697:31118758,31118856:31118950,31119058:3111918', 'assoc_mat': '31101205:autre:4230:31101304,31101500:autre:4230:31101595,31102242:autre:4230:31102371,31102548:autre:4230:31102738,31102781:autre:4230:31102859,31103149:autre:4230:31103321,31103400:autre:4230:31103547,31103602:autre:4230:31103830,31103861:autre:4230:31104207,31104237:autre:4230:31104393,31104455:autre:4230:31104532,31104675:autre:4230:31104892,31104676:autre:4230:31104933,31105012:autre:4230:31105111,31105216:autre:4230:31105319,31105386:autre:4230:31105554,31105670:autre:4230:31105832,31105671:autre:4230:31105873,31106478:autre:4230:31106561,31106715:autre:4230:31106771,31107400:autre:4230:31107494,31107664:autre:4230:31107726,31107931:autre:4230:31107999,31108204:autre:4230:31108316,31108484:autre:4230:31108724,31108779:autre:4230:31108844,31109135:autre:4230:31109653,31109395:autre:4230:31109608,31109732:autre:4230:31110012,31110043:autre:4230:31110157,31110291:autre:4230:31110468,31110505:autre:4230:31110604,31110680:autre:4230:31110782,31110890:autre:4230:31111101,31111134:autre:4230:31111225,31111550:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04139735648743596, 'nb_photo': 27142, 'list_port_cont': '31100345,31100597,31100814,31101317,31101600,31101817,31102042,31102380,31102740,31102862,31103322,31103552,31103829,31104210,31104390,31104541,31104900,31104947,31105114,31105324,31105557,31105846,31105884,31106111,31106296,31106568,31106779,31107077,31107236,31107504,31107736,31108010,31108317,31108719,31108857,31109611,31109656,31110006,31110164,31110480,31110613,31110784,31111110,31111235,31111722,31111760,31111802,31112013,31112166,31112448,31112577,31112876,31113076,31113302,31113544,31113820,31113929,31114215,31114465,31114692,31114983,31115263,31115562,31115862,31115976,31116237,31116519,31116683,31116914,31117245,31117284,31117688,31117719,31117952,31117988,31118563,31118631,31118763,31118948,31119193,31119401,31119692,31119818,31120021,31120316,31120440,31120693,31121021,31121194,31121533,31121839,31121971,31122170,31122449,31122574,31122894,31123079,31123373,31123627,31123879,31124112,31124323,31124580,31124827,31125082,31125339,31125599,31127161,31127707,31127747,31127788,31127820,31127858,3112789', 'assoc_port': '31100287:31100345,31100520:31100597,31100752:31100814,31101205:31101317,31101500:31101600,31101746:31101817,31101975:31102042,31102242:31102380,31102548:31102740,31102781:31102862,31103149:31103322,31103400:31103552,31103602:31103829,31103861:31104210,31104237:31104390,31104455:31104541,31104675:31104900,31104676:31104947,31105012:31105114,31105216:31105324,31105386:31105557,31105670:31105846,31105671:31105884,31106048:31106111,31106282:31106296,31106478:31106568,31106715:31106779,31106963:31107077,31107221:31107236,31107400:31107504,31107664:31107736,31107931:31108010,31108204:31108317,31108484:31108719,31108779:31108857,31109135:31109656,31109395:31109611,31109732:31110006,31110043:31110164,31110291:31110480,31110505:31110613,31110680:31110784,31110890:31111110,31111134:31111235,31111304:31111802,31111549:31111722,31111550:31111760,31111917:31112013,31112150:31112166,31112352:31112448,31112553:31112577,31112726:31112876,31113019:31113076,31113233:31113302,31113484:31113544,31113693:31113820,31113864:3111392', 'assoc_mat': '31100287:carton:4230:31100345,31100520:carton:4230:31100597,31100752:carton:4230:31100814,31101205:carton:4230:31101317,31101500:carton:4230:31101600,31101746:carton:4230:31101817,31101975:carton:4230:31102042,31102242:carton:4230:31102380,31102548:carton:4230:31102740,31102781:carton:4230:31102862,31103149:carton:4230:31103322,31103400:carton:4230:31103552,31103602:carton:4230:31103829,31103861:carton:4230:31104210,31104237:carton:4230:31104390,31104455:carton:4230:31104541,31104675:carton:4230:31104900,31104676:carton:4230:31104947,31105012:carton:4230:31105114,31105216:carton:4230:31105324,31105386:carton:4230:31105557,31105670:carton:4230:31105846,31105671:carton:4230:31105884,31106048:carton:4230:31106111,31106282:carton:4230:31106296,31106478:carton:4230:31106568,31106715:carton:4230:31106779,31106963:carton:4230:31107077,31107221:carton:4230:31107236,31107400:carton:4230:31107504,31107664:carton:4230:31107736,31107931:carton:4230:31108010,31108204:carton:4230:31108317,31108484:carton:4230:31108719,3110'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013377244429123084, 'nb_photo': 593, 'list_port_cont': '31104203,31104387,31104525,31107506,31108852,31109606,31110008,31114458,31114688,31114991,31115257,31115551,31115853,31117683,31117956,31118632,31119697,31120304,31124333,31125083,31125322,31125607,31127153,31131021,31133293,31134073,31134535,31134568,31137756,31138117,31138886,31139193,31139283,31139631,31140863,31141224,31145699,31146744,31147987,31150326,31150821,31151334,31151584,31151618,31151959,31152169,31152421,31152632,31152872,31153218,31153433,31153686,31154934,31155307,31155345,31155385,31155854,31155898,31155929,31156225,31156271,31156353,31156719,31157156,31158743,31159208,31160907,31160943,31160978,31161006,31161042,31161127,31161786,31161817,31161863,31162060,31162274,31162340,31162626,31162699,31162918,31162982,31164073,31164325,31164667,31165747,31165781,31165814,31165939,31166357,31166977,31167520,31167831,31168125,31168614,31168654,31168731,31169186,31169218,31170010,31170057,31170098,31170133,31170235,31170261,31170375,31170410,31170653,31170740,31170862,31171120,31171461,31171722,3117177', 'assoc_port': '31103861:31104203,31104237:31104387,31104455:31104525,31107400:31107506,31108779:31108852,31109395:31109606,31109732:31110008,31114404:31114458,31114673:31114688,31114849:31114991,31115094:31115257,31115348:31115551,31115622:31115853,31117558:31117683,31117863:31117956,31118391:31118632,31119547:31119697,31120175:31120304,31124231:31124333,31124977:31125083,31125233:31125322,31125504:31125607,31125823:31127153,31130606:31131021,31132616:31133293,31132808:31134073,31134221:31134535,31134222:31134568,31137686:31137756,31138033:31138117,31138773:31138886,31139004:31139193,31139227:31139283,31139494:31139631,31140612:31140863,31140894:31141224,31145472:31145699,31146589:31146744,31147905:31147987,31150102:31150326,31150647:31150821,31151149:31151334,31151411:31151584,31151463:31151618,31151780:31151959,31151990:31152169,31152249:31152421,31152463:31152632,31152737:31152872,31153168:31153218,31153367:31153433,31153582:31153686,31154679:31154934,31155000:31155854,31155034:31155307,31155151:31155345,31155224:3115538', 'assoc_mat': '31103861:metal:4230:31104203,31104237:metal:4230:31104387,31104455:metal:4230:31104525,31107400:metal:4230:31107506,31108779:metal:4230:31108852,31109395:metal:4230:31109606,31109732:metal:4230:31110008,31114404:metal:4230:31114458,31114673:metal:4230:31114688,31114849:metal:4230:31114991,31115094:metal:4230:31115257,31115348:metal:4230:31115551,31115622:metal:4230:31115853,31117558:metal:4230:31117683,31117863:metal:4230:31117956,31118391:metal:4230:31118632,31119547:metal:4230:31119697,31120175:metal:4230:31120304,31124231:metal:4230:31124333,31124977:metal:4230:31125083,31125233:metal:4230:31125322,31125504:metal:4230:31125607,31125823:metal:4230:31127153,31130606:metal:4230:31131021,31132616:metal:4230:31133293,31132808:metal:4230:31134073,31134221:metal:4230:31134535,31134222:metal:4230:31134568,31137686:metal:4230:31137756,31138033:metal:4230:31138117,31138773:metal:4230:31138886,31139004:metal:4230:31139193,31139227:metal:4230:31139283,31139494:metal:4230:31139631,31140612:metal:4230:31140863,31140894:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.14999512369154486, 'nb_photo': 112729, 'list_port_cont': '31100343,31100598,31100812,31101309,31101392,31101601,31101810,31102050,31102376,31102741,31102867,31103334,31103554,31103832,31104214,31104395,31104537,31104902,31104946,31105107,31105326,31105567,31105842,31105881,31106108,31106305,31106574,31106781,31107075,31107249,31107505,31107732,31108002,31108307,31108718,31108854,31109607,31109657,31110016,31110160,31110471,31110607,31110789,31111104,31111242,31111721,31111759,31111800,31112011,31112170,31112449,31112564,31112869,31113086,31113299,31113545,31113825,31113933,31114224,31114461,31114697,31114990,31115268,31115564,31115861,31115978,31116234,31116515,31116679,31116918,31117242,31117283,31117693,31117724,31117955,31117991,31118560,31118630,31118762,31118942,31119185,31119403,31119691,31119828,31120030,31120317,31120437,31120700,31121024,31121186,31121528,31121845,31121968,31122175,31122452,31122564,31122886,31123087,31123375,31123641,31123875,31124118,31124328,31124585,31124833,31125081,31125333,31125600,31127164,31127706,31127742,31127787,31127823,3112785', 'assoc_port': '31100287:31100343,31100520:31100598,31100752:31100812,31100990:31101392,31101205:31101309,31101500:31101601,31101746:31101810,31101975:31102050,31102242:31102376,31102548:31102741,31102781:31102867,31103149:31103334,31103400:31103554,31103602:31103832,31103861:31104214,31104237:31104395,31104455:31104537,31104675:31104902,31104676:31104946,31105012:31105107,31105216:31105326,31105386:31105567,31105670:31105842,31105671:31105881,31106048:31106108,31106282:31106305,31106478:31106574,31106715:31106781,31106963:31107075,31107221:31107249,31107400:31107505,31107664:31107732,31107931:31108002,31108204:31108307,31108484:31108718,31108779:31108854,31109135:31109657,31109395:31109607,31109732:31110016,31110043:31110160,31110291:31110471,31110505:31110607,31110680:31110789,31110890:31111104,31111134:31111242,31111304:31111800,31111549:31111721,31111550:31111759,31111917:31112011,31112150:31112170,31112352:31112449,31112553:31112564,31112726:31112869,31113019:31113086,31113233:31113299,31113484:31113545,31113693:3111382', 'assoc_mat': '31100287:papier:4230:31100343,31100520:papier:4230:31100598,31100752:papier:4230:31100812,31100990:papier:4230:31101392,31101205:papier:4230:31101309,31101500:papier:4230:31101601,31101746:papier:4230:31101810,31101975:papier:4230:31102050,31102242:papier:4230:31102376,31102548:papier:4230:31102741,31102781:papier:4230:31102867,31103149:papier:4230:31103334,31103400:papier:4230:31103554,31103602:papier:4230:31103832,31103861:papier:4230:31104214,31104237:papier:4230:31104395,31104455:papier:4230:31104537,31104675:papier:4230:31104902,31104676:papier:4230:31104946,31105012:papier:4230:31105107,31105216:papier:4230:31105326,31105386:papier:4230:31105567,31105670:papier:4230:31105842,31105671:papier:4230:31105881,31106048:papier:4230:31106108,31106282:papier:4230:31106305,31106478:papier:4230:31106574,31106715:papier:4230:31106781,31106963:papier:4230:31107075,31107221:papier:4230:31107249,31107400:papier:4230:31107505,31107664:papier:4230:31107732,31107931:papier:4230:31108002,31108204:papier:4230:31108307,3110'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0031306166711609364, 'nb_photo': 968, 'list_port_cont': '31102734,31104897,31104944,31108001,31108312,31108722,31108856,31109650,31110155,31110479,31111109,31113828,31113931,31114220,31114467,31115555,31115866,31115974,31116235,31119198,31119402,31119686,31119825,31120032,31120311,31120445,31121025,31121193,31121526,31121846,31124828,31125089,31125606,31127167,31127708,31127745,31127780,31127813,31127852,31127896,31129429,31129953,31130222,31130572,31130940,31130984,31131361,31131683,31131949,31133832,31133908,31133993,31134068,31134110,31134546,31134577,31134895,31135137,31135421,31135636,31135890,31135931,31136239,31138879,31139201,31139290,31139629,31140004,31140319,31140581,31140869,31141135,31141214,31141436,31141540,31141749,31143150,31143712,31143769,31144397,31144568,31144836,31145177,31145450,31145715,31145967,31146205,31146486,31146567,31146752,31147194,31149380,31149674,31150052,31150340,31150619,31150822,31151332,31151593,31151631,31151963,31152176,31154076,31155298,31155349,31155384,31155859,31155897,31155936,31156232,31156275,31156350,31157274,3115735', 'assoc_port': '31102548:31102734,31104675:31104897,31104676:31104944,31107931:31108001,31108204:31108312,31108484:31108722,31108779:31108856,31109135:31109650,31110043:31110155,31110291:31110479,31110890:31111109,31113693:31113828,31113864:31113931,31114142:31114220,31114404:31114467,31115348:31115555,31115622:31115866,31115896:31115974,31116137:31116235,31119058:31119198,31119304:31119402,31119547:31119686,31119767:31119825,31120007:31120032,31120175:31120311,31120422:31120445,31120880:31121025,31121094:31121193,31121374:31121526,31121641:31121846,31124691:31124828,31124977:31125089,31125504:31125606,31125823:31127167,31127186:31127708,31127187:31127745,31127188:31127780,31127189:31127813,31127190:31127852,31127191:31127896,31129105:31129429,31129709:31129953,31129937:31130222,31130280:31130572,31130604:31130940,31130605:31130984,31131167:31131361,31131631:31131683,31131789:31131949,31132677:31133832,31132679:31133908,31132681:31133993,31132808:31134068,31133195:31134110,31134221:31134546,31134222:31134577,31134643:3113489', 'assoc_mat': '31102548:pehd:4230:31102734,31104675:pehd:4230:31104897,31104676:pehd:4230:31104944,31107931:pehd:4230:31108001,31108204:pehd:4230:31108312,31108484:pehd:4230:31108722,31108779:pehd:4230:31108856,31109135:pehd:4230:31109650,31110043:pehd:4230:31110155,31110291:pehd:4230:31110479,31110890:pehd:4230:31111109,31113693:pehd:4230:31113828,31113864:pehd:4230:31113931,31114142:pehd:4230:31114220,31114404:pehd:4230:31114467,31115348:pehd:4230:31115555,31115622:pehd:4230:31115866,31115896:pehd:4230:31115974,31116137:pehd:4230:31116235,31119058:pehd:4230:31119198,31119304:pehd:4230:31119402,31119547:pehd:4230:31119686,31119767:pehd:4230:31119825,31120007:pehd:4230:31120032,31120175:pehd:4230:31120311,31120422:pehd:4230:31120445,31120880:pehd:4230:31121025,31121094:pehd:4230:31121193,31121374:pehd:4230:31121526,31121641:pehd:4230:31121846,31124691:pehd:4230:31124828,31124977:pehd:4230:31125089,31125504:pehd:4230:31125606,31125823:pehd:4230:31127167,31127186:pehd:4230:31127708,31127187:pehd:4230:31127745,31127188:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007179663552443536, 'nb_photo': 6084, 'list_port_cont': '31100806,31101814,31102046,31102375,31102737,31102866,31103328,31103557,31103819,31104212,31104394,31104542,31104898,31104942,31105321,31108008,31108311,31108710,31108849,31109597,31109658,31110015,31110162,31110481,31110606,31110780,31111111,31112015,31112439,31112578,31112868,31113303,31113831,31113920,31114210,31114471,31114683,31114988,31115255,31115563,31115867,31115968,31116236,31116516,31116681,31116920,31117238,31117691,31117729,31117954,31118624,31118756,31118949,31119199,31119404,31119695,31119824,31120029,31120309,31120436,31120695,31121027,31121189,31121531,31121841,31121966,31122172,31122575,31122895,31123086,31123371,31123637,31124109,31124335,31124584,31124832,31125075,31125338,31125594,31127163,31127714,31127752,31127782,31127817,31127850,31127882,31128329,31128375,31128416,31128997,31129069,31129360,31129434,31129664,31129955,31130212,31130575,31130943,31130983,31131023,31131100,31131273,31131356,31131689,31131952,31132008,31132223,31133255,31133289,31133718,31133799,31133841,31133869,3113395', 'assoc_port': '31100752:31100806,31101746:31101814,31101975:31102046,31102242:31102375,31102548:31102737,31102781:31102866,31103149:31103328,31103400:31103557,31103602:31103819,31103861:31104212,31104237:31104394,31104455:31104542,31104675:31104898,31104676:31104942,31105216:31105321,31107931:31108008,31108204:31108311,31108484:31108710,31108779:31108849,31109135:31109658,31109395:31109597,31109732:31110015,31110043:31110162,31110291:31110481,31110505:31110606,31110680:31110780,31110890:31111111,31111917:31112015,31112352:31112439,31112553:31112578,31112726:31112868,31113233:31113303,31113693:31113831,31113864:31113920,31114142:31114210,31114404:31114471,31114673:31114683,31114849:31114988,31115094:31115255,31115348:31115563,31115622:31115867,31115896:31115968,31116137:31116236,31116382:31116516,31116620:31116681,31116823:31116920,31117099:31117238,31117558:31117691,31117559:31117729,31117863:31117954,31118391:31118624,31118697:31118756,31118856:31118949,31119058:31119199,31119304:31119404,31119547:31119695,31119767:3111982', 'assoc_mat': '31100752:pet_clair:4230:31100806,31101746:pet_clair:4230:31101814,31101975:pet_clair:4230:31102046,31102242:pet_clair:4230:31102375,31102548:pet_clair:4230:31102737,31102781:pet_clair:4230:31102866,31103149:pet_clair:4230:31103328,31103400:pet_clair:4230:31103557,31103602:pet_clair:4230:31103819,31103861:pet_clair:4230:31104212,31104237:pet_clair:4230:31104394,31104455:pet_clair:4230:31104542,31104675:pet_clair:4230:31104898,31104676:pet_clair:4230:31104942,31105216:pet_clair:4230:31105321,31107931:pet_clair:4230:31108008,31108204:pet_clair:4230:31108311,31108484:pet_clair:4230:31108710,31108779:pet_clair:4230:31108849,31109135:pet_clair:4230:31109658,31109395:pet_clair:4230:31109597,31109732:pet_clair:4230:31110015,31110043:pet_clair:4230:31110162,31110291:pet_clair:4230:31110481,31110505:pet_clair:4230:31110606,31110680:pet_clair:4230:31110780,31110890:pet_clair:4230:31111111,31111917:pet_clair:4230:31112015,31112352:pet_clair:4230:31112439,31112553:pet_clair:4230:31112578,31112726:pet_clair:4230:31112868,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002254607773608, 'nb_photo': 250, 'list_port_cont': '31102742,31103333,31104206,31108858,31110018,31110168,31110603,31113829,31114218,31114469,31114690,31115556,31116228,31119693,31119827,31120443,31120696,31124577,31125328,31127159,31127819,31129661,31129957,31130217,31130573,31130945,31131354,31131955,31134074,31134112,31134549,31134582,31134906,31135139,31135916,31137442,31138133,31139202,31139292,31139635,31140007,31140321,31149382,31149678,31150338,31151098,31154369,31155336,31155931,31156233,31158997,31160868,31160977,31161083,31162921,31162997,31163463,31164121,31166909,31166948,31166982,31167533,31168700,31170022,31170053,31170099,31170140,31170268,31170310,31170369,31170418,31170646,31170750,31171393,31173033,31173072,31173233,31173276,31173316,31173348,31173385,31175096,31175136,31175246,31175288,31175330,31175373,31176213,31176245,31179003,31179383,31179663,31179920,31180420,31180646,31180868,31181040,31181156,31184109,31184434,31185017,31186544,31186839,31189771,31190052,31190290,31190551,31194744,31194997,31195232,31200217,31205467,31206701,3120757', 'assoc_port': '31102548:31102742,31103149:31103333,31103861:31104206,31108779:31108858,31109732:31110018,31110043:31110168,31110505:31110603,31113693:31113829,31114142:31114218,31114404:31114469,31114673:31114690,31115348:31115556,31116137:31116228,31119547:31119693,31119767:31119827,31120422:31120443,31120629:31120696,31124478:31124577,31125233:31125328,31125823:31127159,31127189:31127819,31129465:31129661,31129709:31129957,31129937:31130217,31130280:31130573,31130604:31130945,31131167:31131354,31131789:31131955,31132808:31134074,31133195:31134112,31134221:31134549,31134222:31134582,31134643:31134906,31134928:31135139,31135666:31135916,31137321:31137442,31138033:31138133,31139004:31139202,31139227:31139292,31139494:31139635,31139776:31140007,31140031:31140321,31149242:31149382,31149534:31149678,31150102:31150338,31150858:31151098,31154199:31154369,31155151:31155336,31155488:31155931,31156002:31156233,31158932:31158997,31159671:31173033,31159847:31173072,31159888:31160868,31160016:31160977,31160079:31161083,31162509:3116292', 'assoc_mat': '31102548:pet_fonce:4230:31102742,31103149:pet_fonce:4230:31103333,31103861:pet_fonce:4230:31104206,31108779:pet_fonce:4230:31108858,31109732:pet_fonce:4230:31110018,31110043:pet_fonce:4230:31110168,31110505:pet_fonce:4230:31110603,31113693:pet_fonce:4230:31113829,31114142:pet_fonce:4230:31114218,31114404:pet_fonce:4230:31114469,31114673:pet_fonce:4230:31114690,31115348:pet_fonce:4230:31115556,31116137:pet_fonce:4230:31116228,31119547:pet_fonce:4230:31119693,31119767:pet_fonce:4230:31119827,31120422:pet_fonce:4230:31120443,31120629:pet_fonce:4230:31120696,31124478:pet_fonce:4230:31124577,31125233:pet_fonce:4230:31125328,31125823:pet_fonce:4230:31127159,31127189:pet_fonce:4230:31127819,31129465:pet_fonce:4230:31129661,31129709:pet_fonce:4230:31129957,31129937:pet_fonce:4230:31130217,31130280:pet_fonce:4230:31130573,31130604:pet_fonce:4230:31130945,31131167:pet_fonce:4230:31131354,31131789:pet_fonce:4230:31131955,31132808:pet_fonce:4230:31134074,31133195:pet_fonce:4230:31134112,31134221:pet_fonce:4230:31134549,3'}), 'main_stat': {'nb_photos': 1573}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31195428,31195429,31195430,31195431,31195432,31195433,31195434?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-09', 0.8890112501069118),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_09_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', '0.83%', 5425], 'carton': ['carton', '4.14%', 27142], 'metal': ['metal', '0.13%', 593], 'papier': ['papier', '15.0%', 112729], 'pehd': ['pehd', '0.31%', 968], 'pet_clair': ['pet_clair', '0.72%', 6084], 'pet_fonce': ['pet_fonce', '0.23%', 250]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_09_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.56user 2.97system 0:04.82elapsed 114%CPU (0avgtext+0avgdata 193040maxresident)k 16inputs+296outputs (9major+54071minor)pagefaults 0swaps