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_merge -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_merge ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-10 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_merge"; 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 WARNING mismatch dashboard_places_from_datou and dashboard_places are different Fonction SLA_MENSUEL nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_merge"; 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 WARNING mismatch dashboard_places_from_datou and dashboard_places are different place_id : 234 month : 10 mtr_id : dashboard_places : SCCU_merge date : 2026-10 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_merge' and date like '%2026-10%') and created_at like '%2026-10%'))); nb_day : (3, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 234 and month(ded.date) = 10 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 234 and month(ded.date) = 10 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 234 and mp.name like '%102026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-10-01 : dt_date_just_month_year : 2026-10-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_merge" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-10-01" AND ded.date <= "2026-10-31" SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (3010670,3011742,3012056,3013152,3013846,3014428,3015044,3015142,3015576,3016550,3017068,3017114,3018014,3018650,3018900,3019524,3020408,3020932,3020966,3021534,3022090,3023082,3023528,3023884,3024246,3024634) 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.016970345242900677, 'nb_photo': 24385, 'list_port_cont': '31243260,31243691,31243738,31243832,31244403,31244439,31244476,31248005,31249628,31249665,31249702,31249744,31249787,31249833,31249858,31249933,31250074,31250247,31250560,31250690,31251153,31251278,31252059,31252100,31252142,31252231,31252265,31252800,31254441,31254483,31254521,31254574,31254630,31254657,31254696,31254739,31254893,31258103,31258529,31258694,31258858,31259354,31259708,31259753,31259978,31260385,31260745,31261057,31261221,31261712,31261795,31262136,31262358,31262447,31262706,31262817,31263092,31263410,31263634,31263724,31263848,31264062,31264522,31264780,31264994,31265289,31265637,31266119,31266184,31266679,31266708,31267383,31267417,31267777,31268356,31268730,31269096,31269137,31269299,31269487,31269716,31270168,31270350,31270498,31270962,31271102,31271140,31271315,31271361,31271461,31271524,31271679,31271799,31272293,31272461,31272756,31272982,31273028,31273098,31273419,31273484,31273997,31274221,31274534,31274560,31274610,31274930,31275010,31275153,31275359,31275739,31276103,31276261,3127685', 'assoc_port': '31242914:31243260,31243488:31243691,31243489:31243738,31243490:31243832,31244104:31249628,31244105:31244403,31244106:31244439,31244107:31244476,31247974:31248005,31249526:31249665,31249545:31249702,31249564:31250074,31249565:31249744,31249566:31249787,31249567:31249858,31249568:31249833,31249569:31249933,31250140:31250247,31250470:31250690,31250471:31250560,31250914:31251278,31250915:31251153,31251853:31252059,31251854:31252100,31251855:31252265,31251856:31252231,31251857:31252142,31252731:31252800,31254344:31254483,31254345:31254441,31254346:31254521,31254347:31254574,31254348:31254630,31254349:31254657,31254350:31254893,31254351:31254739,31254352:31254696,31258037:31258103,31258292:31258529,31258561:31258694,31258684:31258858,31259026:31259354,31259335:31259708,31259336:31259753,31259730:31259978,31260050:31260385,31260376:31260745,31260778:31261057,31260967:31261221,31260968:31261712,31261414:31261795,31261735:31262136,31262086:31262358,31262283:31262447,31262469:31262817,31262491:31262706,31262995:3126309', 'assoc_mat': '31242914:autre:4230:31243260,31243488:autre:4230:31243691,31243489:autre:4230:31243738,31243490:autre:4230:31243832,31244104:autre:4230:31249628,31244105:autre:4230:31244403,31244106:autre:4230:31244439,31244107:autre:4230:31244476,31247974:autre:4230:31248005,31249526:autre:4230:31249665,31249545:autre:4230:31249702,31249564:autre:4230:31250074,31249565:autre:4230:31249744,31249566:autre:4230:31249787,31249567:autre:4230:31249858,31249568:autre:4230:31249833,31249569:autre:4230:31249933,31250140:autre:4230:31250247,31250470:autre:4230:31250690,31250471:autre:4230:31250560,31250914:autre:4230:31251278,31250915:autre:4230:31251153,31251853:autre:4230:31252059,31251854:autre:4230:31252100,31251855:autre:4230:31252265,31251856:autre:4230:31252231,31251857:autre:4230:31252142,31252731:autre:4230:31252800,31254344:autre:4230:31254483,31254345:autre:4230:31254441,31254346:autre:4230:31254521,31254347:autre:4230:31254574,31254348:autre:4230:31254630,31254349:autre:4230:31254657,31254350:autre:4230:31254893,31254351:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06161312108615994, 'nb_photo': 128488, 'list_port_cont': '31243263,31243689,31243747,31243823,31244409,31244445,31244483,31248012,31249626,31249653,31249710,31249742,31249784,31249824,31249866,31249945,31250085,31250242,31250562,31250698,31251157,31251279,31252067,31252105,31252145,31252223,31252271,31252792,31254440,31254482,31254516,31254570,31254625,31254660,31254693,31254733,31254906,31258099,31258536,31258704,31258860,31259351,31259709,31259745,31259991,31260394,31260759,31261060,31261236,31261709,31261788,31262148,31262360,31262441,31262709,31262815,31263094,31263413,31263643,31263729,31263849,31264065,31264518,31264786,31264991,31265297,31265632,31266117,31266192,31266670,31266718,31267386,31267420,31267782,31268370,31268734,31269107,31269139,31269302,31269493,31269727,31270172,31270352,31270510,31270963,31271103,31271138,31271320,31271363,31271468,31271529,31271666,31271809,31272282,31272460,31272760,31272990,31273024,31273104,31273423,31273482,31274004,31274227,31274531,31274566,31274613,31274924,31275025,31275152,31275356,31275738,31276110,31276264,3127685', 'assoc_port': '31242914:31243263,31243488:31243689,31243489:31243747,31243490:31243823,31244104:31249626,31244105:31244409,31244106:31244445,31244107:31244483,31247974:31248012,31249526:31249653,31249545:31249710,31249564:31250085,31249565:31249742,31249566:31249784,31249567:31249866,31249568:31249824,31249569:31249945,31250140:31250242,31250470:31250698,31250471:31250562,31250914:31251279,31250915:31251157,31251853:31252067,31251854:31252105,31251855:31252271,31251856:31252223,31251857:31252145,31252731:31252792,31254344:31254482,31254345:31254440,31254346:31254516,31254347:31254570,31254348:31254625,31254349:31254660,31254350:31254906,31254351:31254733,31254352:31254693,31258037:31258099,31258292:31258536,31258561:31258704,31258684:31258860,31259026:31259351,31259335:31259709,31259336:31259745,31259730:31259991,31260050:31260394,31260376:31260759,31260778:31261060,31260967:31261236,31260968:31261709,31261414:31261788,31261735:31262148,31262086:31262360,31262283:31262441,31262469:31262815,31262491:31262709,31262995:3126309', 'assoc_mat': '31242914:carton:4230:31243263,31243488:carton:4230:31243689,31243489:carton:4230:31243747,31243490:carton:4230:31243823,31244104:carton:4230:31249626,31244105:carton:4230:31244409,31244106:carton:4230:31244445,31244107:carton:4230:31244483,31247974:carton:4230:31248012,31249526:carton:4230:31249653,31249545:carton:4230:31249710,31249564:carton:4230:31250085,31249565:carton:4230:31249742,31249566:carton:4230:31249784,31249567:carton:4230:31249866,31249568:carton:4230:31249824,31249569:carton:4230:31249945,31250140:carton:4230:31250242,31250470:carton:4230:31250698,31250471:carton:4230:31250562,31250914:carton:4230:31251279,31250915:carton:4230:31251157,31251853:carton:4230:31252067,31251854:carton:4230:31252105,31251855:carton:4230:31252271,31251856:carton:4230:31252223,31251857:carton:4230:31252145,31252731:carton:4230:31252792,31254344:carton:4230:31254482,31254345:carton:4230:31254440,31254346:carton:4230:31254516,31254347:carton:4230:31254570,31254348:carton:4230:31254625,31254349:carton:4230:31254660,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0016328321664829022, 'nb_photo': 2902, 'list_port_cont': '31243261,31243698,31243740,31243834,31244411,31244444,31248006,31249625,31249663,31249698,31249745,31249778,31249827,31249857,31249934,31250075,31250251,31250556,31250694,31251159,31251270,31252063,31252110,31252156,31252228,31252275,31254427,31254489,31254515,31254572,31254618,31254653,31254697,31254740,31254910,31258098,31258539,31258692,31259350,31259699,31259737,31259988,31260397,31260758,31261056,31261220,31261702,31261786,31262140,31262367,31262436,31262708,31262807,31263091,31263635,31263737,31263835,31264058,31264515,31264789,31264981,31265280,31265639,31266118,31266181,31266666,31266722,31267376,31267421,31267781,31268362,31268729,31269100,31269140,31269298,31269501,31269710,31270157,31270337,31270492,31270959,31271090,31271142,31271325,31271359,31271467,31271517,31271677,31271810,31272278,31272457,31272755,31272979,31273022,31273096,31273407,31273476,31273992,31274230,31274533,31274572,31274603,31274917,31275023,31275141,31275346,31275734,31276107,31276262,31276840,31276899,31277070,31277220,3127738', 'assoc_port': '31242914:31243261,31243488:31243698,31243489:31243740,31243490:31243834,31244104:31249625,31244105:31244411,31244106:31244444,31247974:31248006,31249526:31249663,31249545:31249698,31249564:31250075,31249565:31249745,31249566:31249778,31249567:31249857,31249568:31249827,31249569:31249934,31250140:31250251,31250470:31250694,31250471:31250556,31250914:31251270,31250915:31251159,31251853:31252063,31251854:31252110,31251855:31252275,31251856:31252228,31251857:31252156,31254344:31254489,31254345:31254427,31254346:31254515,31254347:31254572,31254348:31254618,31254349:31254653,31254350:31254910,31254351:31254740,31254352:31254697,31258037:31258098,31258292:31258539,31258561:31258692,31259026:31259350,31259335:31259699,31259336:31259737,31259730:31259988,31260050:31260397,31260376:31260758,31260778:31261056,31260967:31261220,31260968:31261702,31261414:31261786,31261735:31262140,31262086:31262367,31262283:31262436,31262469:31262807,31262491:31262708,31262995:31263091,31263439:31263635,31263672:31263737,31263679:3126383', 'assoc_mat': '31242914:metal:4230:31243261,31243488:metal:4230:31243698,31243489:metal:4230:31243740,31243490:metal:4230:31243834,31244104:metal:4230:31249625,31244105:metal:4230:31244411,31244106:metal:4230:31244444,31247974:metal:4230:31248006,31249526:metal:4230:31249663,31249545:metal:4230:31249698,31249564:metal:4230:31250075,31249565:metal:4230:31249745,31249566:metal:4230:31249778,31249567:metal:4230:31249857,31249568:metal:4230:31249827,31249569:metal:4230:31249934,31250140:metal:4230:31250251,31250470:metal:4230:31250694,31250471:metal:4230:31250556,31250914:metal:4230:31251270,31250915:metal:4230:31251159,31251853:metal:4230:31252063,31251854:metal:4230:31252110,31251855:metal:4230:31252275,31251856:metal:4230:31252228,31251857:metal:4230:31252156,31254344:metal:4230:31254489,31254345:metal:4230:31254427,31254346:metal:4230:31254515,31254347:metal:4230:31254572,31254348:metal:4230:31254618,31254349:metal:4230:31254653,31254350:metal:4230:31254910,31254351:metal:4230:31254740,31254352:metal:4230:31254697,31258037:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.22286765363488847, 'nb_photo': 513757, 'list_port_cont': '31243267,31243699,31243737,31243831,31244412,31244450,31244486,31247999,31249623,31249655,31249712,31249743,31249789,31249823,31249871,31249947,31250088,31250240,31250568,31250703,31251163,31251280,31252069,31252108,31252144,31252224,31252269,31252802,31254437,31254478,31254511,31254566,31254617,31254667,31254700,31254735,31254908,31258092,31258535,31258702,31258849,31259340,31259707,31259747,31259982,31260393,31260747,31261067,31261231,31261708,31261793,31262144,31262356,31262440,31262699,31262816,31263096,31263414,31263645,31263738,31263841,31264066,31264519,31264784,31264993,31265288,31265638,31266106,31266195,31266678,31266719,31267379,31267425,31267773,31268364,31268731,31269103,31269142,31269304,31269490,31269723,31270170,31270348,31270503,31270958,31271098,31271145,31271323,31271370,31271475,31271527,31271675,31271816,31272290,31272466,31272750,31272987,31273029,31273103,31273414,31273480,31274007,31274229,31274535,31274571,31274614,31274933,31275018,31275157,31275352,31275731,31276105,31276260,3127685', 'assoc_port': '31242914:31243267,31243488:31243699,31243489:31243737,31243490:31243831,31244104:31249623,31244105:31244412,31244106:31244450,31244107:31244486,31247974:31247999,31249526:31249655,31249545:31249712,31249564:31250088,31249565:31249743,31249566:31249789,31249567:31249871,31249568:31249823,31249569:31249947,31250140:31250240,31250470:31250703,31250471:31250568,31250914:31251280,31250915:31251163,31251853:31252069,31251854:31252108,31251855:31252269,31251856:31252224,31251857:31252144,31252731:31252802,31254344:31254478,31254345:31254437,31254346:31254511,31254347:31254566,31254348:31254617,31254349:31254667,31254350:31254908,31254351:31254735,31254352:31254700,31258037:31258092,31258292:31258535,31258561:31258702,31258684:31258849,31259026:31259340,31259335:31259707,31259336:31259747,31259730:31259982,31260050:31260393,31260376:31260747,31260778:31261067,31260967:31261231,31260968:31261708,31261414:31261793,31261735:31262144,31262086:31262356,31262283:31262440,31262469:31262816,31262491:31262699,31262995:3126309', 'assoc_mat': '31242914:papier:4230:31243267,31243488:papier:4230:31243699,31243489:papier:4230:31243737,31243490:papier:4230:31243831,31244104:papier:4230:31249623,31244105:papier:4230:31244412,31244106:papier:4230:31244450,31244107:papier:4230:31244486,31247974:papier:4230:31247999,31249526:papier:4230:31249655,31249545:papier:4230:31249712,31249564:papier:4230:31250088,31249565:papier:4230:31249743,31249566:papier:4230:31249789,31249567:papier:4230:31249871,31249568:papier:4230:31249823,31249569:papier:4230:31249947,31250140:papier:4230:31250240,31250470:papier:4230:31250703,31250471:papier:4230:31250568,31250914:papier:4230:31251280,31250915:papier:4230:31251163,31251853:papier:4230:31252069,31251854:papier:4230:31252108,31251855:papier:4230:31252269,31251856:papier:4230:31252224,31251857:papier:4230:31252144,31252731:papier:4230:31252802,31254344:papier:4230:31254478,31254345:papier:4230:31254437,31254346:papier:4230:31254511,31254347:papier:4230:31254566,31254348:papier:4230:31254617,31254349:papier:4230:31254667,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004652474551718237, 'nb_photo': 3807, 'list_port_cont': '31243265,31243702,31243745,31243822,31244410,31244451,31244481,31248004,31249627,31249666,31249706,31249739,31249785,31249832,31249869,31249948,31250087,31250250,31250569,31250701,31251160,31251281,31252064,31252113,31252155,31252232,31252279,31252797,31254439,31254488,31254522,31254573,31254615,31254664,31254695,31254738,31254903,31258538,31258707,31259345,31259703,31259750,31259989,31260396,31260755,31261066,31261232,31261707,31261792,31262133,31262363,31262445,31262704,31262810,31263095,31263408,31263638,31263733,31263846,31264524,31264989,31265640,31266115,31266194,31266673,31266714,31267387,31267422,31267771,31268368,31268723,31269106,31269141,31269290,31269494,31270164,31270345,31270502,31270960,31271107,31271137,31271327,31271369,31271472,31271516,31271671,31271807,31272279,31272463,31272751,31272993,31273036,31273111,31273417,31273483,31274009,31274228,31274537,31274574,31274617,31275149,31275351,31275737,31276109,31276257,31276854,31276893,31277067,31277208,31277386,31277567,31277684,31277770,3127826', 'assoc_port': '31242914:31243265,31243488:31243702,31243489:31243745,31243490:31243822,31244104:31249627,31244105:31244410,31244106:31244451,31244107:31244481,31247974:31248004,31249526:31249666,31249545:31249706,31249564:31250087,31249565:31249739,31249566:31249785,31249567:31249869,31249568:31249832,31249569:31249948,31250140:31250250,31250470:31250701,31250471:31250569,31250914:31251281,31250915:31251160,31251853:31252064,31251854:31252113,31251855:31252279,31251856:31252232,31251857:31252155,31252731:31252797,31254344:31254488,31254345:31254439,31254346:31254522,31254347:31254573,31254348:31254615,31254349:31254664,31254350:31254903,31254351:31254738,31254352:31254695,31258292:31258538,31258561:31258707,31259026:31259345,31259335:31259703,31259336:31259750,31259730:31259989,31260050:31260396,31260376:31260755,31260778:31261066,31260967:31261232,31260968:31261707,31261414:31261792,31261735:31262133,31262086:31262363,31262283:31262445,31262469:31262810,31262491:31262704,31262995:31263095,31263128:31263408,31263439:3126363', 'assoc_mat': '31242914:pehd:4230:31243265,31243488:pehd:4230:31243702,31243489:pehd:4230:31243745,31243490:pehd:4230:31243822,31244104:pehd:4230:31249627,31244105:pehd:4230:31244410,31244106:pehd:4230:31244451,31244107:pehd:4230:31244481,31247974:pehd:4230:31248004,31249526:pehd:4230:31249666,31249545:pehd:4230:31249706,31249564:pehd:4230:31250087,31249565:pehd:4230:31249739,31249566:pehd:4230:31249785,31249567:pehd:4230:31249869,31249568:pehd:4230:31249832,31249569:pehd:4230:31249948,31250140:pehd:4230:31250250,31250470:pehd:4230:31250701,31250471:pehd:4230:31250569,31250914:pehd:4230:31251281,31250915:pehd:4230:31251160,31251853:pehd:4230:31252064,31251854:pehd:4230:31252113,31251855:pehd:4230:31252279,31251856:pehd:4230:31252232,31251857:pehd:4230:31252155,31252731:pehd:4230:31252797,31254344:pehd:4230:31254488,31254345:pehd:4230:31254439,31254346:pehd:4230:31254522,31254347:pehd:4230:31254573,31254348:pehd:4230:31254615,31254349:pehd:4230:31254664,31254350:pehd:4230:31254903,31254351:pehd:4230:31254738,31254352:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012538166213307925, 'nb_photo': 30617, 'list_port_cont': '31243268,31243697,31243743,31243824,31244399,31244446,31244487,31248014,31249622,31249652,31249714,31249752,31249779,31249822,31249867,31249946,31250089,31250248,31250566,31250702,31251164,31251272,31252060,31252102,31252153,31252229,31252268,31252798,31254433,31254484,31254520,31254565,31254626,31254658,31254704,31254744,31254909,31258096,31258528,31258706,31258864,31259352,31259704,31259752,31259984,31260389,31260757,31261062,31261230,31261703,31261796,31262138,31262355,31262442,31262707,31262812,31263090,31263407,31263646,31263731,31263845,31264063,31264520,31264788,31264996,31265287,31265642,31266116,31266186,31266675,31266709,31267391,31267431,31267783,31268371,31268735,31269097,31269145,31269306,31269498,31269726,31270167,31270347,31270504,31270961,31271096,31271135,31271326,31271366,31271465,31271523,31271673,31271813,31272285,31272464,31272765,31272984,31273027,31273109,31273418,31273489,31274002,31274225,31274532,31274568,31274616,31274931,31275019,31275158,31275354,31275733,31276104,31276258,3127685', 'assoc_port': '31242914:31243268,31243488:31243697,31243489:31243743,31243490:31243824,31244104:31249622,31244105:31244399,31244106:31244446,31244107:31244487,31247974:31248014,31249526:31249652,31249545:31249714,31249564:31250089,31249565:31249752,31249566:31249779,31249567:31249867,31249568:31249822,31249569:31249946,31250140:31250248,31250470:31250702,31250471:31250566,31250914:31251272,31250915:31251164,31251853:31252060,31251854:31252102,31251855:31252268,31251856:31252229,31251857:31252153,31252731:31252798,31254344:31254484,31254345:31254433,31254346:31254520,31254347:31254565,31254348:31254626,31254349:31254658,31254350:31254909,31254351:31254744,31254352:31254704,31258037:31258096,31258292:31258528,31258561:31258706,31258684:31258864,31259026:31259352,31259335:31259704,31259336:31259752,31259730:31259984,31260050:31260389,31260376:31260757,31260778:31261062,31260967:31261230,31260968:31261703,31261414:31261796,31261735:31262138,31262086:31262355,31262283:31262442,31262469:31262812,31262491:31262707,31262995:3126309', 'assoc_mat': '31242914:pet_clair:4230:31243268,31243488:pet_clair:4230:31243697,31243489:pet_clair:4230:31243743,31243490:pet_clair:4230:31243824,31244104:pet_clair:4230:31249622,31244105:pet_clair:4230:31244399,31244106:pet_clair:4230:31244446,31244107:pet_clair:4230:31244487,31247974:pet_clair:4230:31248014,31249526:pet_clair:4230:31249652,31249545:pet_clair:4230:31249714,31249564:pet_clair:4230:31250089,31249565:pet_clair:4230:31249752,31249566:pet_clair:4230:31249779,31249567:pet_clair:4230:31249867,31249568:pet_clair:4230:31249822,31249569:pet_clair:4230:31249946,31250140:pet_clair:4230:31250248,31250470:pet_clair:4230:31250702,31250471:pet_clair:4230:31250566,31250914:pet_clair:4230:31251272,31250915:pet_clair:4230:31251164,31251853:pet_clair:4230:31252060,31251854:pet_clair:4230:31252102,31251855:pet_clair:4230:31252268,31251856:pet_clair:4230:31252229,31251857:pet_clair:4230:31252153,31252731:pet_clair:4230:31252798,31254344:pet_clair:4230:31254484,31254345:pet_clair:4230:31254433,31254346:pet_clair:4230:31254520,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0027341805394300142, 'nb_photo': 1429, 'list_port_cont': '31243271,31243695,31243741,31243826,31244406,31244448,31249618,31249661,31249713,31249786,31249831,31249863,31249944,31250076,31250243,31250570,31250699,31251162,31251268,31252062,31252107,31252150,31252233,31252274,31254429,31254490,31254524,31254571,31254624,31254665,31254904,31258532,31258700,31259347,31259697,31259748,31259986,31260400,31260749,31261065,31261234,31261711,31261798,31262145,31262365,31262448,31262711,31262818,31263084,31263405,31263639,31264521,31264995,31265635,31266110,31266188,31266677,31267390,31267430,31267778,31268373,31268737,31269105,31269143,31269296,31269502,31269724,31270171,31270339,31270508,31270950,31271101,31271147,31271328,31271368,31271474,31271680,31271815,31272291,31272468,31272759,31272985,31273035,31273113,31273422,31273488,31274006,31274222,31274529,31274564,31274615,31274927,31275017,31275150,31275349,31275728,31276111,31276263,31276845,31276900,31277066,31277219,31277384,31277570,31277680,31277765,31278254,31278334,31278624,31279959,31280872,31284240,31284318,3129047', 'assoc_port': '31242914:31243271,31243488:31243695,31243489:31243741,31243490:31243826,31244104:31249618,31244105:31244406,31244106:31244448,31249526:31249661,31249545:31249713,31249564:31250076,31249566:31249786,31249567:31249863,31249568:31249831,31249569:31249944,31250140:31250243,31250470:31250699,31250471:31250570,31250914:31251268,31250915:31251162,31251853:31252062,31251854:31252107,31251855:31252274,31251856:31252233,31251857:31252150,31254344:31254490,31254345:31254429,31254346:31254524,31254347:31254571,31254348:31254624,31254349:31254665,31254350:31254904,31258292:31258532,31258561:31258700,31259026:31259347,31259335:31259697,31259336:31259748,31259730:31259986,31260050:31260400,31260376:31260749,31260778:31261065,31260967:31261234,31260968:31261711,31261414:31261798,31261735:31262145,31262086:31262365,31262283:31262448,31262469:31262818,31262491:31262711,31262995:31263084,31263128:31263405,31263439:31263639,31264244:31264521,31264820:31264995,31265363:31265635,31265738:31266110,31265739:31266188,31266346:3126667', 'assoc_mat': '31242914:pet_fonce:4230:31243271,31243488:pet_fonce:4230:31243695,31243489:pet_fonce:4230:31243741,31243490:pet_fonce:4230:31243826,31244104:pet_fonce:4230:31249618,31244105:pet_fonce:4230:31244406,31244106:pet_fonce:4230:31244448,31249526:pet_fonce:4230:31249661,31249545:pet_fonce:4230:31249713,31249564:pet_fonce:4230:31250076,31249566:pet_fonce:4230:31249786,31249567:pet_fonce:4230:31249863,31249568:pet_fonce:4230:31249831,31249569:pet_fonce:4230:31249944,31250140:pet_fonce:4230:31250243,31250470:pet_fonce:4230:31250699,31250471:pet_fonce:4230:31250570,31250914:pet_fonce:4230:31251268,31250915:pet_fonce:4230:31251162,31251853:pet_fonce:4230:31252062,31251854:pet_fonce:4230:31252107,31251855:pet_fonce:4230:31252274,31251856:pet_fonce:4230:31252233,31251857:pet_fonce:4230:31252150,31254344:pet_fonce:4230:31254490,31254345:pet_fonce:4230:31254429,31254346:pet_fonce:4230:31254524,31254347:pet_fonce:4230:31254571,31254348:pet_fonce:4230:31254624,31254349:pet_fonce:4230:31254665,31254350:pet_fonce:4230:31254904,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(3010670,3011742,3012056,3013152,3013846,3014428,3015044,3015142,3015576,3016550,3017068,3017114,3018014,3018650,3018900,3019524,3020408,3020932,3020966,3021534,3022090,3023082,3023528,3023884,3024246,3024634)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341120, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243260,31243691,31243738,31243832,31244403,31244439,31244476,31248005,31249628,31249665,31249702,31249744,31249787,31249833,31249858,31249933,31250074,31250247,31250560,31250690,31251153,31251278,31252059,31252100,31252142,31252231,31252265,31252800,31254441,31254483,31254521,31254574,31254630,31254657,31254696,31254739,31254893,31258103,31258529,31258694,31258858,31259354,31259708,31259753,31259978,31260385,31260745,31261057,31261221,31261712,31261795,31262136,31262358,31262447,31262706,31262817,31263092,31263410,31263634,31263724,31263848,31264062,31264522,31264780,31264994,31265289,31265637,31266119,31266184,31266679,31266708,31267383,31267417,31267777,31268356,31268730,31269096,31269137,31269299,31269487,31269716,31270168,31270350,31270498,31270962,31271102,31271140,31271315,31271361,31271461,31271524,31271679,31271799,31272293,31272461,31272756,31272982,31273028,31273098,31273419,31273484,31273997,31274221,31274534,31274560,31274610,31274930,31275010,31275153,31275359,31275739,31276103,31276261,3127685 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341121, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243263,31243689,31243747,31243823,31244409,31244445,31244483,31248012,31249626,31249653,31249710,31249742,31249784,31249824,31249866,31249945,31250085,31250242,31250562,31250698,31251157,31251279,31252067,31252105,31252145,31252223,31252271,31252792,31254440,31254482,31254516,31254570,31254625,31254660,31254693,31254733,31254906,31258099,31258536,31258704,31258860,31259351,31259709,31259745,31259991,31260394,31260759,31261060,31261236,31261709,31261788,31262148,31262360,31262441,31262709,31262815,31263094,31263413,31263643,31263729,31263849,31264065,31264518,31264786,31264991,31265297,31265632,31266117,31266192,31266670,31266718,31267386,31267420,31267782,31268370,31268734,31269107,31269139,31269302,31269493,31269727,31270172,31270352,31270510,31270963,31271103,31271138,31271320,31271363,31271468,31271529,31271666,31271809,31272282,31272460,31272760,31272990,31273024,31273104,31273423,31273482,31274004,31274227,31274531,31274566,31274613,31274924,31275025,31275152,31275356,31275738,31276110,31276264,3127685 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341122, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243261,31243698,31243740,31243834,31244411,31244444,31248006,31249625,31249663,31249698,31249745,31249778,31249827,31249857,31249934,31250075,31250251,31250556,31250694,31251159,31251270,31252063,31252110,31252156,31252228,31252275,31254427,31254489,31254515,31254572,31254618,31254653,31254697,31254740,31254910,31258098,31258539,31258692,31259350,31259699,31259737,31259988,31260397,31260758,31261056,31261220,31261702,31261786,31262140,31262367,31262436,31262708,31262807,31263091,31263635,31263737,31263835,31264058,31264515,31264789,31264981,31265280,31265639,31266118,31266181,31266666,31266722,31267376,31267421,31267781,31268362,31268729,31269100,31269140,31269298,31269501,31269710,31270157,31270337,31270492,31270959,31271090,31271142,31271325,31271359,31271467,31271517,31271677,31271810,31272278,31272457,31272755,31272979,31273022,31273096,31273407,31273476,31273992,31274230,31274533,31274572,31274603,31274917,31275023,31275141,31275346,31275734,31276107,31276262,31276840,31276899,31277070,31277220,3127738 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341123, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243267,31243699,31243737,31243831,31244412,31244450,31244486,31247999,31249623,31249655,31249712,31249743,31249789,31249823,31249871,31249947,31250088,31250240,31250568,31250703,31251163,31251280,31252069,31252108,31252144,31252224,31252269,31252802,31254437,31254478,31254511,31254566,31254617,31254667,31254700,31254735,31254908,31258092,31258535,31258702,31258849,31259340,31259707,31259747,31259982,31260393,31260747,31261067,31261231,31261708,31261793,31262144,31262356,31262440,31262699,31262816,31263096,31263414,31263645,31263738,31263841,31264066,31264519,31264784,31264993,31265288,31265638,31266106,31266195,31266678,31266719,31267379,31267425,31267773,31268364,31268731,31269103,31269142,31269304,31269490,31269723,31270170,31270348,31270503,31270958,31271098,31271145,31271323,31271370,31271475,31271527,31271675,31271816,31272290,31272466,31272750,31272987,31273029,31273103,31273414,31273480,31274007,31274229,31274535,31274571,31274614,31274933,31275018,31275157,31275352,31275731,31276105,31276260,3127685 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341125, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243265,31243702,31243745,31243822,31244410,31244451,31244481,31248004,31249627,31249666,31249706,31249739,31249785,31249832,31249869,31249948,31250087,31250250,31250569,31250701,31251160,31251281,31252064,31252113,31252155,31252232,31252279,31252797,31254439,31254488,31254522,31254573,31254615,31254664,31254695,31254738,31254903,31258538,31258707,31259345,31259703,31259750,31259989,31260396,31260755,31261066,31261232,31261707,31261792,31262133,31262363,31262445,31262704,31262810,31263095,31263408,31263638,31263733,31263846,31264524,31264989,31265640,31266115,31266194,31266673,31266714,31267387,31267422,31267771,31268368,31268723,31269106,31269141,31269290,31269494,31270164,31270345,31270502,31270960,31271107,31271137,31271327,31271369,31271472,31271516,31271671,31271807,31272279,31272463,31272751,31272993,31273036,31273111,31273417,31273483,31274009,31274228,31274537,31274574,31274617,31275149,31275351,31275737,31276109,31276257,31276854,31276893,31277067,31277208,31277386,31277567,31277684,31277770,3127826 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341126, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243268,31243697,31243743,31243824,31244399,31244446,31244487,31248014,31249622,31249652,31249714,31249752,31249779,31249822,31249867,31249946,31250089,31250248,31250566,31250702,31251164,31251272,31252060,31252102,31252153,31252229,31252268,31252798,31254433,31254484,31254520,31254565,31254626,31254658,31254704,31254744,31254909,31258096,31258528,31258706,31258864,31259352,31259704,31259752,31259984,31260389,31260757,31261062,31261230,31261703,31261796,31262138,31262355,31262442,31262707,31262812,31263090,31263407,31263646,31263731,31263845,31264063,31264520,31264788,31264996,31265287,31265642,31266116,31266186,31266675,31266709,31267391,31267431,31267783,31268371,31268735,31269097,31269145,31269306,31269498,31269726,31270167,31270347,31270504,31270961,31271096,31271135,31271326,31271366,31271465,31271523,31271673,31271813,31272285,31272464,31272765,31272984,31273027,31273109,31273418,31273489,31274002,31274225,31274532,31274568,31274616,31274931,31275019,31275158,31275354,31275733,31276104,31276258,3127685 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341127, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243271,31243695,31243741,31243826,31244406,31244448,31249618,31249661,31249713,31249786,31249831,31249863,31249944,31250076,31250243,31250570,31250699,31251162,31251268,31252062,31252107,31252150,31252233,31252274,31254429,31254490,31254524,31254571,31254624,31254665,31254904,31258532,31258700,31259347,31259697,31259748,31259986,31260400,31260749,31261065,31261234,31261711,31261798,31262145,31262365,31262448,31262711,31262818,31263084,31263405,31263639,31264521,31264995,31265635,31266110,31266188,31266677,31267390,31267430,31267778,31268373,31268737,31269105,31269143,31269296,31269502,31269724,31270171,31270339,31270508,31270950,31271101,31271147,31271328,31271368,31271474,31271680,31271815,31272291,31272468,31272759,31272985,31273035,31273113,31273422,31273488,31274006,31274222,31274529,31274564,31274615,31274927,31275017,31275150,31275349,31275728,31276111,31276263,31276845,31276900,31277066,31277219,31277384,31277570,31277680,31277765,31278254,31278334,31278624,31279959,31280872,31284240,31284318,3129047 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31341120,31341121,31341122,31341123,31341125,31341126,31341127?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=234 and date >='2026-10-01' and date <= '2026-10-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1883,),), 'unwanted_material_monthly_percentage': ((0.7037172646430468,),), 'material_repartition': (('incineration', 1876),), 'material_dict': {'incineration': 1876}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 10, 1), 0.6492767566849276, 5), (datetime.date(2026, 10, 2), 0.6417012002322415, 1), (datetime.date(2026, 10, 3), 0.6846058629738686, 1), (datetime.date(2026, 10, 4), 0.7542557921774824, 1), (datetime.date(2026, 10, 5), 0.7317255711328257, 4), (datetime.date(2026, 10, 6), 0.6807777602878539, 5), (datetime.date(2026, 10, 7), 0.623419060725359, 3), (datetime.date(2026, 10, 8), 0.679161617018546, 5), (datetime.date(2026, 10, 9), 0.7303357352710288, 4), (datetime.date(2026, 10, 10), 0.6588830359561095, 6), (datetime.date(2026, 10, 11), 0.7712319635889838, 5), (datetime.date(2026, 10, 12), 0.7970622560252446, 3), (datetime.date(2026, 10, 13), 0.6884896186684308, 5), (datetime.date(2026, 10, 14), 0.6772769395055063, 3), (datetime.date(2026, 10, 15), 0.696507144608532, 3), (datetime.date(2026, 10, 16), 0.6349326706316754, 5), (datetime.date(2026, 10, 17), 0.6376603165692355, 6), (datetime.date(2026, 10, 18), 0.7263374542697155, 3), (datetime.date(2026, 10, 19), 0.8076417698898262, 6), (datetime.date(2026, 10, 20), 0.7500036295875541, 5), (datetime.date(2026, 10, 21), 0.816288835005653, 3), (datetime.date(2026, 10, 22), 0.7180616143526241, 3), (datetime.date(2026, 10, 23), 0.6897747778808643, 2), (datetime.date(2026, 10, 24), 0.7233289824260203, 4), (datetime.date(2026, 10, 25), 0.8308665456614566, 1), (datetime.date(2026, 10, 26), 0.7659057794702342, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 10, 1), 0.6492767566849276, 5), (datetime.date(2026, 10, 2), 0.6417012002322415, 1), (datetime.date(2026, 10, 3), 0.6846058629738686, 1), (datetime.date(2026, 10, 4), 0.7542557921774824, 1), (datetime.date(2026, 10, 5), 0.7317255711328257, 4), (datetime.date(2026, 10, 6), 0.6807777602878539, 5), (datetime.date(2026, 10, 7), 0.623419060725359, 3), (datetime.date(2026, 10, 8), 0.679161617018546, 5), (datetime.date(2026, 10, 9), 0.7303357352710288, 4), (datetime.date(2026, 10, 10), 0.6588830359561095, 6), (datetime.date(2026, 10, 11), 0.7712319635889838, 5), (datetime.date(2026, 10, 12), 0.7970622560252446, 3), (datetime.date(2026, 10, 13), 0.6884896186684308, 5), (datetime.date(2026, 10, 14), 0.6772769395055063, 3), (datetime.date(2026, 10, 15), 0.696507144608532, 3), (datetime.date(2026, 10, 16), 0.6349326706316754, 5), (datetime.date(2026, 10, 17), 0.6376603165692355, 6), (datetime.date(2026, 10, 18), 0.7263374542697155, 3), (datetime.date(2026, 10, 19), 0.8076417698898262, 6), (datetime.date(2026, 10, 20), 0.7500036295875541, 5), (datetime.date(2026, 10, 21), 0.816288835005653, 3), (datetime.date(2026, 10, 22), 0.7180616143526241, 3), (datetime.date(2026, 10, 23), 0.6897747778808643, 2), (datetime.date(2026, 10, 24), 0.7233289824260203, 4), (datetime.date(2026, 10, 25), 0.8308665456614566, 1), (datetime.date(2026, 10, 26), 0.7659057794702342, 3))}, 'quality_array': [['-8.455306953940395', '09102026'], ['-8.81498551011714', '01102026'], ['-8.60225277167766', '02102026'], ['-8.967097436134768', '03102026'], ['-7.950721879768964', '04102026'], ['-7.924444428841542', '05102026'], ['-8.56764289496376', '06102026'], ['-8.865648137938473', '07102026'], ['-8.341225631272533', '08102026'], ['-8.185552949813363', '10102026'], ['-8.319453855272585', '11102026'], ['-8.341830213976213', '12102026'], ['-8.338261475687172', '13102026'], ['-8.521262554591305', '14102026'], ['-8.400224704320976', '15102026'], ['-8.563540947389281', '16102026'], ['-8.630508555521846', '17102026'], ['-8.269701513864785', '18102026'], ['-8.451604792339722', '19102026'], ['-8.627838320353993', '20102026'], ['-8.588999654780281', '21102026'], ['-8.408630760277093', '22102026'], ['-8.284447589161076', '23102026'], ['-8.301739398502733', '24102026'], ['-8.071848236867636', '25102026'], ['-7.896687006885122', '26102026']], 'number_of_batch': ((417,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.016970345242900677, 'nb_photo': 24385, 'list_port_cont': '31243260,31243691,31243738,31243832,31244403,31244439,31244476,31248005,31249628,31249665,31249702,31249744,31249787,31249833,31249858,31249933,31250074,31250247,31250560,31250690,31251153,31251278,31252059,31252100,31252142,31252231,31252265,31252800,31254441,31254483,31254521,31254574,31254630,31254657,31254696,31254739,31254893,31258103,31258529,31258694,31258858,31259354,31259708,31259753,31259978,31260385,31260745,31261057,31261221,31261712,31261795,31262136,31262358,31262447,31262706,31262817,31263092,31263410,31263634,31263724,31263848,31264062,31264522,31264780,31264994,31265289,31265637,31266119,31266184,31266679,31266708,31267383,31267417,31267777,31268356,31268730,31269096,31269137,31269299,31269487,31269716,31270168,31270350,31270498,31270962,31271102,31271140,31271315,31271361,31271461,31271524,31271679,31271799,31272293,31272461,31272756,31272982,31273028,31273098,31273419,31273484,31273997,31274221,31274534,31274560,31274610,31274930,31275010,31275153,31275359,31275739,31276103,31276261,3127685', 'assoc_port': '31242914:31243260,31243488:31243691,31243489:31243738,31243490:31243832,31244104:31249628,31244105:31244403,31244106:31244439,31244107:31244476,31247974:31248005,31249526:31249665,31249545:31249702,31249564:31250074,31249565:31249744,31249566:31249787,31249567:31249858,31249568:31249833,31249569:31249933,31250140:31250247,31250470:31250690,31250471:31250560,31250914:31251278,31250915:31251153,31251853:31252059,31251854:31252100,31251855:31252265,31251856:31252231,31251857:31252142,31252731:31252800,31254344:31254483,31254345:31254441,31254346:31254521,31254347:31254574,31254348:31254630,31254349:31254657,31254350:31254893,31254351:31254739,31254352:31254696,31258037:31258103,31258292:31258529,31258561:31258694,31258684:31258858,31259026:31259354,31259335:31259708,31259336:31259753,31259730:31259978,31260050:31260385,31260376:31260745,31260778:31261057,31260967:31261221,31260968:31261712,31261414:31261795,31261735:31262136,31262086:31262358,31262283:31262447,31262469:31262817,31262491:31262706,31262995:3126309', 'assoc_mat': '31242914:autre:4230:31243260,31243488:autre:4230:31243691,31243489:autre:4230:31243738,31243490:autre:4230:31243832,31244104:autre:4230:31249628,31244105:autre:4230:31244403,31244106:autre:4230:31244439,31244107:autre:4230:31244476,31247974:autre:4230:31248005,31249526:autre:4230:31249665,31249545:autre:4230:31249702,31249564:autre:4230:31250074,31249565:autre:4230:31249744,31249566:autre:4230:31249787,31249567:autre:4230:31249858,31249568:autre:4230:31249833,31249569:autre:4230:31249933,31250140:autre:4230:31250247,31250470:autre:4230:31250690,31250471:autre:4230:31250560,31250914:autre:4230:31251278,31250915:autre:4230:31251153,31251853:autre:4230:31252059,31251854:autre:4230:31252100,31251855:autre:4230:31252265,31251856:autre:4230:31252231,31251857:autre:4230:31252142,31252731:autre:4230:31252800,31254344:autre:4230:31254483,31254345:autre:4230:31254441,31254346:autre:4230:31254521,31254347:autre:4230:31254574,31254348:autre:4230:31254630,31254349:autre:4230:31254657,31254350:autre:4230:31254893,31254351:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06161312108615994, 'nb_photo': 128488, 'list_port_cont': '31243263,31243689,31243747,31243823,31244409,31244445,31244483,31248012,31249626,31249653,31249710,31249742,31249784,31249824,31249866,31249945,31250085,31250242,31250562,31250698,31251157,31251279,31252067,31252105,31252145,31252223,31252271,31252792,31254440,31254482,31254516,31254570,31254625,31254660,31254693,31254733,31254906,31258099,31258536,31258704,31258860,31259351,31259709,31259745,31259991,31260394,31260759,31261060,31261236,31261709,31261788,31262148,31262360,31262441,31262709,31262815,31263094,31263413,31263643,31263729,31263849,31264065,31264518,31264786,31264991,31265297,31265632,31266117,31266192,31266670,31266718,31267386,31267420,31267782,31268370,31268734,31269107,31269139,31269302,31269493,31269727,31270172,31270352,31270510,31270963,31271103,31271138,31271320,31271363,31271468,31271529,31271666,31271809,31272282,31272460,31272760,31272990,31273024,31273104,31273423,31273482,31274004,31274227,31274531,31274566,31274613,31274924,31275025,31275152,31275356,31275738,31276110,31276264,3127685', 'assoc_port': '31242914:31243263,31243488:31243689,31243489:31243747,31243490:31243823,31244104:31249626,31244105:31244409,31244106:31244445,31244107:31244483,31247974:31248012,31249526:31249653,31249545:31249710,31249564:31250085,31249565:31249742,31249566:31249784,31249567:31249866,31249568:31249824,31249569:31249945,31250140:31250242,31250470:31250698,31250471:31250562,31250914:31251279,31250915:31251157,31251853:31252067,31251854:31252105,31251855:31252271,31251856:31252223,31251857:31252145,31252731:31252792,31254344:31254482,31254345:31254440,31254346:31254516,31254347:31254570,31254348:31254625,31254349:31254660,31254350:31254906,31254351:31254733,31254352:31254693,31258037:31258099,31258292:31258536,31258561:31258704,31258684:31258860,31259026:31259351,31259335:31259709,31259336:31259745,31259730:31259991,31260050:31260394,31260376:31260759,31260778:31261060,31260967:31261236,31260968:31261709,31261414:31261788,31261735:31262148,31262086:31262360,31262283:31262441,31262469:31262815,31262491:31262709,31262995:3126309', 'assoc_mat': '31242914:carton:4230:31243263,31243488:carton:4230:31243689,31243489:carton:4230:31243747,31243490:carton:4230:31243823,31244104:carton:4230:31249626,31244105:carton:4230:31244409,31244106:carton:4230:31244445,31244107:carton:4230:31244483,31247974:carton:4230:31248012,31249526:carton:4230:31249653,31249545:carton:4230:31249710,31249564:carton:4230:31250085,31249565:carton:4230:31249742,31249566:carton:4230:31249784,31249567:carton:4230:31249866,31249568:carton:4230:31249824,31249569:carton:4230:31249945,31250140:carton:4230:31250242,31250470:carton:4230:31250698,31250471:carton:4230:31250562,31250914:carton:4230:31251279,31250915:carton:4230:31251157,31251853:carton:4230:31252067,31251854:carton:4230:31252105,31251855:carton:4230:31252271,31251856:carton:4230:31252223,31251857:carton:4230:31252145,31252731:carton:4230:31252792,31254344:carton:4230:31254482,31254345:carton:4230:31254440,31254346:carton:4230:31254516,31254347:carton:4230:31254570,31254348:carton:4230:31254625,31254349:carton:4230:31254660,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0016328321664829022, 'nb_photo': 2902, 'list_port_cont': '31243261,31243698,31243740,31243834,31244411,31244444,31248006,31249625,31249663,31249698,31249745,31249778,31249827,31249857,31249934,31250075,31250251,31250556,31250694,31251159,31251270,31252063,31252110,31252156,31252228,31252275,31254427,31254489,31254515,31254572,31254618,31254653,31254697,31254740,31254910,31258098,31258539,31258692,31259350,31259699,31259737,31259988,31260397,31260758,31261056,31261220,31261702,31261786,31262140,31262367,31262436,31262708,31262807,31263091,31263635,31263737,31263835,31264058,31264515,31264789,31264981,31265280,31265639,31266118,31266181,31266666,31266722,31267376,31267421,31267781,31268362,31268729,31269100,31269140,31269298,31269501,31269710,31270157,31270337,31270492,31270959,31271090,31271142,31271325,31271359,31271467,31271517,31271677,31271810,31272278,31272457,31272755,31272979,31273022,31273096,31273407,31273476,31273992,31274230,31274533,31274572,31274603,31274917,31275023,31275141,31275346,31275734,31276107,31276262,31276840,31276899,31277070,31277220,3127738', 'assoc_port': '31242914:31243261,31243488:31243698,31243489:31243740,31243490:31243834,31244104:31249625,31244105:31244411,31244106:31244444,31247974:31248006,31249526:31249663,31249545:31249698,31249564:31250075,31249565:31249745,31249566:31249778,31249567:31249857,31249568:31249827,31249569:31249934,31250140:31250251,31250470:31250694,31250471:31250556,31250914:31251270,31250915:31251159,31251853:31252063,31251854:31252110,31251855:31252275,31251856:31252228,31251857:31252156,31254344:31254489,31254345:31254427,31254346:31254515,31254347:31254572,31254348:31254618,31254349:31254653,31254350:31254910,31254351:31254740,31254352:31254697,31258037:31258098,31258292:31258539,31258561:31258692,31259026:31259350,31259335:31259699,31259336:31259737,31259730:31259988,31260050:31260397,31260376:31260758,31260778:31261056,31260967:31261220,31260968:31261702,31261414:31261786,31261735:31262140,31262086:31262367,31262283:31262436,31262469:31262807,31262491:31262708,31262995:31263091,31263439:31263635,31263672:31263737,31263679:3126383', 'assoc_mat': '31242914:metal:4230:31243261,31243488:metal:4230:31243698,31243489:metal:4230:31243740,31243490:metal:4230:31243834,31244104:metal:4230:31249625,31244105:metal:4230:31244411,31244106:metal:4230:31244444,31247974:metal:4230:31248006,31249526:metal:4230:31249663,31249545:metal:4230:31249698,31249564:metal:4230:31250075,31249565:metal:4230:31249745,31249566:metal:4230:31249778,31249567:metal:4230:31249857,31249568:metal:4230:31249827,31249569:metal:4230:31249934,31250140:metal:4230:31250251,31250470:metal:4230:31250694,31250471:metal:4230:31250556,31250914:metal:4230:31251270,31250915:metal:4230:31251159,31251853:metal:4230:31252063,31251854:metal:4230:31252110,31251855:metal:4230:31252275,31251856:metal:4230:31252228,31251857:metal:4230:31252156,31254344:metal:4230:31254489,31254345:metal:4230:31254427,31254346:metal:4230:31254515,31254347:metal:4230:31254572,31254348:metal:4230:31254618,31254349:metal:4230:31254653,31254350:metal:4230:31254910,31254351:metal:4230:31254740,31254352:metal:4230:31254697,31258037:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.22286765363488847, 'nb_photo': 513757, 'list_port_cont': '31243267,31243699,31243737,31243831,31244412,31244450,31244486,31247999,31249623,31249655,31249712,31249743,31249789,31249823,31249871,31249947,31250088,31250240,31250568,31250703,31251163,31251280,31252069,31252108,31252144,31252224,31252269,31252802,31254437,31254478,31254511,31254566,31254617,31254667,31254700,31254735,31254908,31258092,31258535,31258702,31258849,31259340,31259707,31259747,31259982,31260393,31260747,31261067,31261231,31261708,31261793,31262144,31262356,31262440,31262699,31262816,31263096,31263414,31263645,31263738,31263841,31264066,31264519,31264784,31264993,31265288,31265638,31266106,31266195,31266678,31266719,31267379,31267425,31267773,31268364,31268731,31269103,31269142,31269304,31269490,31269723,31270170,31270348,31270503,31270958,31271098,31271145,31271323,31271370,31271475,31271527,31271675,31271816,31272290,31272466,31272750,31272987,31273029,31273103,31273414,31273480,31274007,31274229,31274535,31274571,31274614,31274933,31275018,31275157,31275352,31275731,31276105,31276260,3127685', 'assoc_port': '31242914:31243267,31243488:31243699,31243489:31243737,31243490:31243831,31244104:31249623,31244105:31244412,31244106:31244450,31244107:31244486,31247974:31247999,31249526:31249655,31249545:31249712,31249564:31250088,31249565:31249743,31249566:31249789,31249567:31249871,31249568:31249823,31249569:31249947,31250140:31250240,31250470:31250703,31250471:31250568,31250914:31251280,31250915:31251163,31251853:31252069,31251854:31252108,31251855:31252269,31251856:31252224,31251857:31252144,31252731:31252802,31254344:31254478,31254345:31254437,31254346:31254511,31254347:31254566,31254348:31254617,31254349:31254667,31254350:31254908,31254351:31254735,31254352:31254700,31258037:31258092,31258292:31258535,31258561:31258702,31258684:31258849,31259026:31259340,31259335:31259707,31259336:31259747,31259730:31259982,31260050:31260393,31260376:31260747,31260778:31261067,31260967:31261231,31260968:31261708,31261414:31261793,31261735:31262144,31262086:31262356,31262283:31262440,31262469:31262816,31262491:31262699,31262995:3126309', 'assoc_mat': '31242914:papier:4230:31243267,31243488:papier:4230:31243699,31243489:papier:4230:31243737,31243490:papier:4230:31243831,31244104:papier:4230:31249623,31244105:papier:4230:31244412,31244106:papier:4230:31244450,31244107:papier:4230:31244486,31247974:papier:4230:31247999,31249526:papier:4230:31249655,31249545:papier:4230:31249712,31249564:papier:4230:31250088,31249565:papier:4230:31249743,31249566:papier:4230:31249789,31249567:papier:4230:31249871,31249568:papier:4230:31249823,31249569:papier:4230:31249947,31250140:papier:4230:31250240,31250470:papier:4230:31250703,31250471:papier:4230:31250568,31250914:papier:4230:31251280,31250915:papier:4230:31251163,31251853:papier:4230:31252069,31251854:papier:4230:31252108,31251855:papier:4230:31252269,31251856:papier:4230:31252224,31251857:papier:4230:31252144,31252731:papier:4230:31252802,31254344:papier:4230:31254478,31254345:papier:4230:31254437,31254346:papier:4230:31254511,31254347:papier:4230:31254566,31254348:papier:4230:31254617,31254349:papier:4230:31254667,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004652474551718237, 'nb_photo': 3807, 'list_port_cont': '31243265,31243702,31243745,31243822,31244410,31244451,31244481,31248004,31249627,31249666,31249706,31249739,31249785,31249832,31249869,31249948,31250087,31250250,31250569,31250701,31251160,31251281,31252064,31252113,31252155,31252232,31252279,31252797,31254439,31254488,31254522,31254573,31254615,31254664,31254695,31254738,31254903,31258538,31258707,31259345,31259703,31259750,31259989,31260396,31260755,31261066,31261232,31261707,31261792,31262133,31262363,31262445,31262704,31262810,31263095,31263408,31263638,31263733,31263846,31264524,31264989,31265640,31266115,31266194,31266673,31266714,31267387,31267422,31267771,31268368,31268723,31269106,31269141,31269290,31269494,31270164,31270345,31270502,31270960,31271107,31271137,31271327,31271369,31271472,31271516,31271671,31271807,31272279,31272463,31272751,31272993,31273036,31273111,31273417,31273483,31274009,31274228,31274537,31274574,31274617,31275149,31275351,31275737,31276109,31276257,31276854,31276893,31277067,31277208,31277386,31277567,31277684,31277770,3127826', 'assoc_port': '31242914:31243265,31243488:31243702,31243489:31243745,31243490:31243822,31244104:31249627,31244105:31244410,31244106:31244451,31244107:31244481,31247974:31248004,31249526:31249666,31249545:31249706,31249564:31250087,31249565:31249739,31249566:31249785,31249567:31249869,31249568:31249832,31249569:31249948,31250140:31250250,31250470:31250701,31250471:31250569,31250914:31251281,31250915:31251160,31251853:31252064,31251854:31252113,31251855:31252279,31251856:31252232,31251857:31252155,31252731:31252797,31254344:31254488,31254345:31254439,31254346:31254522,31254347:31254573,31254348:31254615,31254349:31254664,31254350:31254903,31254351:31254738,31254352:31254695,31258292:31258538,31258561:31258707,31259026:31259345,31259335:31259703,31259336:31259750,31259730:31259989,31260050:31260396,31260376:31260755,31260778:31261066,31260967:31261232,31260968:31261707,31261414:31261792,31261735:31262133,31262086:31262363,31262283:31262445,31262469:31262810,31262491:31262704,31262995:31263095,31263128:31263408,31263439:3126363', 'assoc_mat': '31242914:pehd:4230:31243265,31243488:pehd:4230:31243702,31243489:pehd:4230:31243745,31243490:pehd:4230:31243822,31244104:pehd:4230:31249627,31244105:pehd:4230:31244410,31244106:pehd:4230:31244451,31244107:pehd:4230:31244481,31247974:pehd:4230:31248004,31249526:pehd:4230:31249666,31249545:pehd:4230:31249706,31249564:pehd:4230:31250087,31249565:pehd:4230:31249739,31249566:pehd:4230:31249785,31249567:pehd:4230:31249869,31249568:pehd:4230:31249832,31249569:pehd:4230:31249948,31250140:pehd:4230:31250250,31250470:pehd:4230:31250701,31250471:pehd:4230:31250569,31250914:pehd:4230:31251281,31250915:pehd:4230:31251160,31251853:pehd:4230:31252064,31251854:pehd:4230:31252113,31251855:pehd:4230:31252279,31251856:pehd:4230:31252232,31251857:pehd:4230:31252155,31252731:pehd:4230:31252797,31254344:pehd:4230:31254488,31254345:pehd:4230:31254439,31254346:pehd:4230:31254522,31254347:pehd:4230:31254573,31254348:pehd:4230:31254615,31254349:pehd:4230:31254664,31254350:pehd:4230:31254903,31254351:pehd:4230:31254738,31254352:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012538166213307925, 'nb_photo': 30617, 'list_port_cont': '31243268,31243697,31243743,31243824,31244399,31244446,31244487,31248014,31249622,31249652,31249714,31249752,31249779,31249822,31249867,31249946,31250089,31250248,31250566,31250702,31251164,31251272,31252060,31252102,31252153,31252229,31252268,31252798,31254433,31254484,31254520,31254565,31254626,31254658,31254704,31254744,31254909,31258096,31258528,31258706,31258864,31259352,31259704,31259752,31259984,31260389,31260757,31261062,31261230,31261703,31261796,31262138,31262355,31262442,31262707,31262812,31263090,31263407,31263646,31263731,31263845,31264063,31264520,31264788,31264996,31265287,31265642,31266116,31266186,31266675,31266709,31267391,31267431,31267783,31268371,31268735,31269097,31269145,31269306,31269498,31269726,31270167,31270347,31270504,31270961,31271096,31271135,31271326,31271366,31271465,31271523,31271673,31271813,31272285,31272464,31272765,31272984,31273027,31273109,31273418,31273489,31274002,31274225,31274532,31274568,31274616,31274931,31275019,31275158,31275354,31275733,31276104,31276258,3127685', 'assoc_port': '31242914:31243268,31243488:31243697,31243489:31243743,31243490:31243824,31244104:31249622,31244105:31244399,31244106:31244446,31244107:31244487,31247974:31248014,31249526:31249652,31249545:31249714,31249564:31250089,31249565:31249752,31249566:31249779,31249567:31249867,31249568:31249822,31249569:31249946,31250140:31250248,31250470:31250702,31250471:31250566,31250914:31251272,31250915:31251164,31251853:31252060,31251854:31252102,31251855:31252268,31251856:31252229,31251857:31252153,31252731:31252798,31254344:31254484,31254345:31254433,31254346:31254520,31254347:31254565,31254348:31254626,31254349:31254658,31254350:31254909,31254351:31254744,31254352:31254704,31258037:31258096,31258292:31258528,31258561:31258706,31258684:31258864,31259026:31259352,31259335:31259704,31259336:31259752,31259730:31259984,31260050:31260389,31260376:31260757,31260778:31261062,31260967:31261230,31260968:31261703,31261414:31261796,31261735:31262138,31262086:31262355,31262283:31262442,31262469:31262812,31262491:31262707,31262995:3126309', 'assoc_mat': '31242914:pet_clair:4230:31243268,31243488:pet_clair:4230:31243697,31243489:pet_clair:4230:31243743,31243490:pet_clair:4230:31243824,31244104:pet_clair:4230:31249622,31244105:pet_clair:4230:31244399,31244106:pet_clair:4230:31244446,31244107:pet_clair:4230:31244487,31247974:pet_clair:4230:31248014,31249526:pet_clair:4230:31249652,31249545:pet_clair:4230:31249714,31249564:pet_clair:4230:31250089,31249565:pet_clair:4230:31249752,31249566:pet_clair:4230:31249779,31249567:pet_clair:4230:31249867,31249568:pet_clair:4230:31249822,31249569:pet_clair:4230:31249946,31250140:pet_clair:4230:31250248,31250470:pet_clair:4230:31250702,31250471:pet_clair:4230:31250566,31250914:pet_clair:4230:31251272,31250915:pet_clair:4230:31251164,31251853:pet_clair:4230:31252060,31251854:pet_clair:4230:31252102,31251855:pet_clair:4230:31252268,31251856:pet_clair:4230:31252229,31251857:pet_clair:4230:31252153,31252731:pet_clair:4230:31252798,31254344:pet_clair:4230:31254484,31254345:pet_clair:4230:31254433,31254346:pet_clair:4230:31254520,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0027341805394300142, 'nb_photo': 1429, 'list_port_cont': '31243271,31243695,31243741,31243826,31244406,31244448,31249618,31249661,31249713,31249786,31249831,31249863,31249944,31250076,31250243,31250570,31250699,31251162,31251268,31252062,31252107,31252150,31252233,31252274,31254429,31254490,31254524,31254571,31254624,31254665,31254904,31258532,31258700,31259347,31259697,31259748,31259986,31260400,31260749,31261065,31261234,31261711,31261798,31262145,31262365,31262448,31262711,31262818,31263084,31263405,31263639,31264521,31264995,31265635,31266110,31266188,31266677,31267390,31267430,31267778,31268373,31268737,31269105,31269143,31269296,31269502,31269724,31270171,31270339,31270508,31270950,31271101,31271147,31271328,31271368,31271474,31271680,31271815,31272291,31272468,31272759,31272985,31273035,31273113,31273422,31273488,31274006,31274222,31274529,31274564,31274615,31274927,31275017,31275150,31275349,31275728,31276111,31276263,31276845,31276900,31277066,31277219,31277384,31277570,31277680,31277765,31278254,31278334,31278624,31279959,31280872,31284240,31284318,3129047', 'assoc_port': '31242914:31243271,31243488:31243695,31243489:31243741,31243490:31243826,31244104:31249618,31244105:31244406,31244106:31244448,31249526:31249661,31249545:31249713,31249564:31250076,31249566:31249786,31249567:31249863,31249568:31249831,31249569:31249944,31250140:31250243,31250470:31250699,31250471:31250570,31250914:31251268,31250915:31251162,31251853:31252062,31251854:31252107,31251855:31252274,31251856:31252233,31251857:31252150,31254344:31254490,31254345:31254429,31254346:31254524,31254347:31254571,31254348:31254624,31254349:31254665,31254350:31254904,31258292:31258532,31258561:31258700,31259026:31259347,31259335:31259697,31259336:31259748,31259730:31259986,31260050:31260400,31260376:31260749,31260778:31261065,31260967:31261234,31260968:31261711,31261414:31261798,31261735:31262145,31262086:31262365,31262283:31262448,31262469:31262818,31262491:31262711,31262995:31263084,31263128:31263405,31263439:31263639,31264244:31264521,31264820:31264995,31265363:31265635,31265738:31266110,31265739:31266188,31266346:3126667', 'assoc_mat': '31242914:pet_fonce:4230:31243271,31243488:pet_fonce:4230:31243695,31243489:pet_fonce:4230:31243741,31243490:pet_fonce:4230:31243826,31244104:pet_fonce:4230:31249618,31244105:pet_fonce:4230:31244406,31244106:pet_fonce:4230:31244448,31249526:pet_fonce:4230:31249661,31249545:pet_fonce:4230:31249713,31249564:pet_fonce:4230:31250076,31249566:pet_fonce:4230:31249786,31249567:pet_fonce:4230:31249863,31249568:pet_fonce:4230:31249831,31249569:pet_fonce:4230:31249944,31250140:pet_fonce:4230:31250243,31250470:pet_fonce:4230:31250699,31250471:pet_fonce:4230:31250570,31250914:pet_fonce:4230:31251268,31250915:pet_fonce:4230:31251162,31251853:pet_fonce:4230:31252062,31251854:pet_fonce:4230:31252107,31251855:pet_fonce:4230:31252274,31251856:pet_fonce:4230:31252233,31251857:pet_fonce:4230:31252150,31254344:pet_fonce:4230:31254490,31254345:pet_fonce:4230:31254429,31254346:pet_fonce:4230:31254524,31254347:pet_fonce:4230:31254571,31254348:pet_fonce:4230:31254624,31254349:pet_fonce:4230:31254665,31254350:pet_fonce:4230:31254904,3'}), 'main_stat': {'nb_photos': 1883}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31341120,31341121,31341122,31341123,31341125,31341126,31341127?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-10', 0.7037406336246335),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_merge"; 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 WARNING mismatch dashboard_places_from_datou and dashboard_places are different {'number_of_analysed_photos': ((1883,),), 'unwanted_material_monthly_percentage': ((0.7037172646430468,),), 'material_repartition': (('incineration', 1876),), 'material_dict': {'incineration': 1876}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 10, 1), 0.6492767566849276, 5), (datetime.date(2026, 10, 2), 0.6417012002322415, 1), (datetime.date(2026, 10, 3), 0.6846058629738686, 1), (datetime.date(2026, 10, 4), 0.7542557921774824, 1), (datetime.date(2026, 10, 5), 0.7317255711328257, 4), (datetime.date(2026, 10, 6), 0.6807777602878539, 5), (datetime.date(2026, 10, 7), 0.623419060725359, 3), (datetime.date(2026, 10, 8), 0.679161617018546, 5), (datetime.date(2026, 10, 9), 0.7303357352710288, 4), (datetime.date(2026, 10, 10), 0.6588830359561095, 6), (datetime.date(2026, 10, 11), 0.7712319635889838, 5), (datetime.date(2026, 10, 12), 0.7970622560252446, 3), (datetime.date(2026, 10, 13), 0.6884896186684308, 5), (datetime.date(2026, 10, 14), 0.6772769395055063, 3), (datetime.date(2026, 10, 15), 0.696507144608532, 3), (datetime.date(2026, 10, 16), 0.6349326706316754, 5), (datetime.date(2026, 10, 17), 0.6376603165692355, 6), (datetime.date(2026, 10, 18), 0.7263374542697155, 3), (datetime.date(2026, 10, 19), 0.8076417698898262, 6), (datetime.date(2026, 10, 20), 0.7500036295875541, 5), (datetime.date(2026, 10, 21), 0.816288835005653, 3), (datetime.date(2026, 10, 22), 0.7180616143526241, 3), (datetime.date(2026, 10, 23), 0.6897747778808643, 2), (datetime.date(2026, 10, 24), 0.7233289824260203, 4), (datetime.date(2026, 10, 25), 0.8308665456614566, 1), (datetime.date(2026, 10, 26), 0.7659057794702342, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 10, 1), 0.6492767566849276, 5), (datetime.date(2026, 10, 2), 0.6417012002322415, 1), (datetime.date(2026, 10, 3), 0.6846058629738686, 1), (datetime.date(2026, 10, 4), 0.7542557921774824, 1), (datetime.date(2026, 10, 5), 0.7317255711328257, 4), (datetime.date(2026, 10, 6), 0.6807777602878539, 5), (datetime.date(2026, 10, 7), 0.623419060725359, 3), (datetime.date(2026, 10, 8), 0.679161617018546, 5), (datetime.date(2026, 10, 9), 0.7303357352710288, 4), (datetime.date(2026, 10, 10), 0.6588830359561095, 6), (datetime.date(2026, 10, 11), 0.7712319635889838, 5), (datetime.date(2026, 10, 12), 0.7970622560252446, 3), (datetime.date(2026, 10, 13), 0.6884896186684308, 5), (datetime.date(2026, 10, 14), 0.6772769395055063, 3), (datetime.date(2026, 10, 15), 0.696507144608532, 3), (datetime.date(2026, 10, 16), 0.6349326706316754, 5), (datetime.date(2026, 10, 17), 0.6376603165692355, 6), (datetime.date(2026, 10, 18), 0.7263374542697155, 3), (datetime.date(2026, 10, 19), 0.8076417698898262, 6), (datetime.date(2026, 10, 20), 0.7500036295875541, 5), (datetime.date(2026, 10, 21), 0.816288835005653, 3), (datetime.date(2026, 10, 22), 0.7180616143526241, 3), (datetime.date(2026, 10, 23), 0.6897747778808643, 2), (datetime.date(2026, 10, 24), 0.7233289824260203, 4), (datetime.date(2026, 10, 25), 0.8308665456614566, 1), (datetime.date(2026, 10, 26), 0.7659057794702342, 3))}, 'quality_array': [['-8.455306953940395', '09102026'], ['-8.81498551011714', '01102026'], ['-8.60225277167766', '02102026'], ['-8.967097436134768', '03102026'], ['-7.950721879768964', '04102026'], ['-7.924444428841542', '05102026'], ['-8.56764289496376', '06102026'], ['-8.865648137938473', '07102026'], ['-8.341225631272533', '08102026'], ['-8.185552949813363', '10102026'], ['-8.319453855272585', '11102026'], ['-8.341830213976213', '12102026'], ['-8.338261475687172', '13102026'], ['-8.521262554591305', '14102026'], ['-8.400224704320976', '15102026'], ['-8.563540947389281', '16102026'], ['-8.630508555521846', '17102026'], ['-8.269701513864785', '18102026'], ['-8.451604792339722', '19102026'], ['-8.627838320353993', '20102026'], ['-8.588999654780281', '21102026'], ['-8.408630760277093', '22102026'], ['-8.284447589161076', '23102026'], ['-8.301739398502733', '24102026'], ['-8.071848236867636', '25102026'], ['-7.896687006885122', '26102026']], 'number_of_batch': ((417,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.016970345242900677, 'nb_photo': 24385, 'list_port_cont': '31243260,31243691,31243738,31243832,31244403,31244439,31244476,31248005,31249628,31249665,31249702,31249744,31249787,31249833,31249858,31249933,31250074,31250247,31250560,31250690,31251153,31251278,31252059,31252100,31252142,31252231,31252265,31252800,31254441,31254483,31254521,31254574,31254630,31254657,31254696,31254739,31254893,31258103,31258529,31258694,31258858,31259354,31259708,31259753,31259978,31260385,31260745,31261057,31261221,31261712,31261795,31262136,31262358,31262447,31262706,31262817,31263092,31263410,31263634,31263724,31263848,31264062,31264522,31264780,31264994,31265289,31265637,31266119,31266184,31266679,31266708,31267383,31267417,31267777,31268356,31268730,31269096,31269137,31269299,31269487,31269716,31270168,31270350,31270498,31270962,31271102,31271140,31271315,31271361,31271461,31271524,31271679,31271799,31272293,31272461,31272756,31272982,31273028,31273098,31273419,31273484,31273997,31274221,31274534,31274560,31274610,31274930,31275010,31275153,31275359,31275739,31276103,31276261,3127685', 'assoc_port': '31242914:31243260,31243488:31243691,31243489:31243738,31243490:31243832,31244104:31249628,31244105:31244403,31244106:31244439,31244107:31244476,31247974:31248005,31249526:31249665,31249545:31249702,31249564:31250074,31249565:31249744,31249566:31249787,31249567:31249858,31249568:31249833,31249569:31249933,31250140:31250247,31250470:31250690,31250471:31250560,31250914:31251278,31250915:31251153,31251853:31252059,31251854:31252100,31251855:31252265,31251856:31252231,31251857:31252142,31252731:31252800,31254344:31254483,31254345:31254441,31254346:31254521,31254347:31254574,31254348:31254630,31254349:31254657,31254350:31254893,31254351:31254739,31254352:31254696,31258037:31258103,31258292:31258529,31258561:31258694,31258684:31258858,31259026:31259354,31259335:31259708,31259336:31259753,31259730:31259978,31260050:31260385,31260376:31260745,31260778:31261057,31260967:31261221,31260968:31261712,31261414:31261795,31261735:31262136,31262086:31262358,31262283:31262447,31262469:31262817,31262491:31262706,31262995:3126309', 'assoc_mat': '31242914:autre:4230:31243260,31243488:autre:4230:31243691,31243489:autre:4230:31243738,31243490:autre:4230:31243832,31244104:autre:4230:31249628,31244105:autre:4230:31244403,31244106:autre:4230:31244439,31244107:autre:4230:31244476,31247974:autre:4230:31248005,31249526:autre:4230:31249665,31249545:autre:4230:31249702,31249564:autre:4230:31250074,31249565:autre:4230:31249744,31249566:autre:4230:31249787,31249567:autre:4230:31249858,31249568:autre:4230:31249833,31249569:autre:4230:31249933,31250140:autre:4230:31250247,31250470:autre:4230:31250690,31250471:autre:4230:31250560,31250914:autre:4230:31251278,31250915:autre:4230:31251153,31251853:autre:4230:31252059,31251854:autre:4230:31252100,31251855:autre:4230:31252265,31251856:autre:4230:31252231,31251857:autre:4230:31252142,31252731:autre:4230:31252800,31254344:autre:4230:31254483,31254345:autre:4230:31254441,31254346:autre:4230:31254521,31254347:autre:4230:31254574,31254348:autre:4230:31254630,31254349:autre:4230:31254657,31254350:autre:4230:31254893,31254351:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06161312108615994, 'nb_photo': 128488, 'list_port_cont': '31243263,31243689,31243747,31243823,31244409,31244445,31244483,31248012,31249626,31249653,31249710,31249742,31249784,31249824,31249866,31249945,31250085,31250242,31250562,31250698,31251157,31251279,31252067,31252105,31252145,31252223,31252271,31252792,31254440,31254482,31254516,31254570,31254625,31254660,31254693,31254733,31254906,31258099,31258536,31258704,31258860,31259351,31259709,31259745,31259991,31260394,31260759,31261060,31261236,31261709,31261788,31262148,31262360,31262441,31262709,31262815,31263094,31263413,31263643,31263729,31263849,31264065,31264518,31264786,31264991,31265297,31265632,31266117,31266192,31266670,31266718,31267386,31267420,31267782,31268370,31268734,31269107,31269139,31269302,31269493,31269727,31270172,31270352,31270510,31270963,31271103,31271138,31271320,31271363,31271468,31271529,31271666,31271809,31272282,31272460,31272760,31272990,31273024,31273104,31273423,31273482,31274004,31274227,31274531,31274566,31274613,31274924,31275025,31275152,31275356,31275738,31276110,31276264,3127685', 'assoc_port': '31242914:31243263,31243488:31243689,31243489:31243747,31243490:31243823,31244104:31249626,31244105:31244409,31244106:31244445,31244107:31244483,31247974:31248012,31249526:31249653,31249545:31249710,31249564:31250085,31249565:31249742,31249566:31249784,31249567:31249866,31249568:31249824,31249569:31249945,31250140:31250242,31250470:31250698,31250471:31250562,31250914:31251279,31250915:31251157,31251853:31252067,31251854:31252105,31251855:31252271,31251856:31252223,31251857:31252145,31252731:31252792,31254344:31254482,31254345:31254440,31254346:31254516,31254347:31254570,31254348:31254625,31254349:31254660,31254350:31254906,31254351:31254733,31254352:31254693,31258037:31258099,31258292:31258536,31258561:31258704,31258684:31258860,31259026:31259351,31259335:31259709,31259336:31259745,31259730:31259991,31260050:31260394,31260376:31260759,31260778:31261060,31260967:31261236,31260968:31261709,31261414:31261788,31261735:31262148,31262086:31262360,31262283:31262441,31262469:31262815,31262491:31262709,31262995:3126309', 'assoc_mat': '31242914:carton:4230:31243263,31243488:carton:4230:31243689,31243489:carton:4230:31243747,31243490:carton:4230:31243823,31244104:carton:4230:31249626,31244105:carton:4230:31244409,31244106:carton:4230:31244445,31244107:carton:4230:31244483,31247974:carton:4230:31248012,31249526:carton:4230:31249653,31249545:carton:4230:31249710,31249564:carton:4230:31250085,31249565:carton:4230:31249742,31249566:carton:4230:31249784,31249567:carton:4230:31249866,31249568:carton:4230:31249824,31249569:carton:4230:31249945,31250140:carton:4230:31250242,31250470:carton:4230:31250698,31250471:carton:4230:31250562,31250914:carton:4230:31251279,31250915:carton:4230:31251157,31251853:carton:4230:31252067,31251854:carton:4230:31252105,31251855:carton:4230:31252271,31251856:carton:4230:31252223,31251857:carton:4230:31252145,31252731:carton:4230:31252792,31254344:carton:4230:31254482,31254345:carton:4230:31254440,31254346:carton:4230:31254516,31254347:carton:4230:31254570,31254348:carton:4230:31254625,31254349:carton:4230:31254660,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0016328321664829022, 'nb_photo': 2902, 'list_port_cont': '31243261,31243698,31243740,31243834,31244411,31244444,31248006,31249625,31249663,31249698,31249745,31249778,31249827,31249857,31249934,31250075,31250251,31250556,31250694,31251159,31251270,31252063,31252110,31252156,31252228,31252275,31254427,31254489,31254515,31254572,31254618,31254653,31254697,31254740,31254910,31258098,31258539,31258692,31259350,31259699,31259737,31259988,31260397,31260758,31261056,31261220,31261702,31261786,31262140,31262367,31262436,31262708,31262807,31263091,31263635,31263737,31263835,31264058,31264515,31264789,31264981,31265280,31265639,31266118,31266181,31266666,31266722,31267376,31267421,31267781,31268362,31268729,31269100,31269140,31269298,31269501,31269710,31270157,31270337,31270492,31270959,31271090,31271142,31271325,31271359,31271467,31271517,31271677,31271810,31272278,31272457,31272755,31272979,31273022,31273096,31273407,31273476,31273992,31274230,31274533,31274572,31274603,31274917,31275023,31275141,31275346,31275734,31276107,31276262,31276840,31276899,31277070,31277220,3127738', 'assoc_port': '31242914:31243261,31243488:31243698,31243489:31243740,31243490:31243834,31244104:31249625,31244105:31244411,31244106:31244444,31247974:31248006,31249526:31249663,31249545:31249698,31249564:31250075,31249565:31249745,31249566:31249778,31249567:31249857,31249568:31249827,31249569:31249934,31250140:31250251,31250470:31250694,31250471:31250556,31250914:31251270,31250915:31251159,31251853:31252063,31251854:31252110,31251855:31252275,31251856:31252228,31251857:31252156,31254344:31254489,31254345:31254427,31254346:31254515,31254347:31254572,31254348:31254618,31254349:31254653,31254350:31254910,31254351:31254740,31254352:31254697,31258037:31258098,31258292:31258539,31258561:31258692,31259026:31259350,31259335:31259699,31259336:31259737,31259730:31259988,31260050:31260397,31260376:31260758,31260778:31261056,31260967:31261220,31260968:31261702,31261414:31261786,31261735:31262140,31262086:31262367,31262283:31262436,31262469:31262807,31262491:31262708,31262995:31263091,31263439:31263635,31263672:31263737,31263679:3126383', 'assoc_mat': '31242914:metal:4230:31243261,31243488:metal:4230:31243698,31243489:metal:4230:31243740,31243490:metal:4230:31243834,31244104:metal:4230:31249625,31244105:metal:4230:31244411,31244106:metal:4230:31244444,31247974:metal:4230:31248006,31249526:metal:4230:31249663,31249545:metal:4230:31249698,31249564:metal:4230:31250075,31249565:metal:4230:31249745,31249566:metal:4230:31249778,31249567:metal:4230:31249857,31249568:metal:4230:31249827,31249569:metal:4230:31249934,31250140:metal:4230:31250251,31250470:metal:4230:31250694,31250471:metal:4230:31250556,31250914:metal:4230:31251270,31250915:metal:4230:31251159,31251853:metal:4230:31252063,31251854:metal:4230:31252110,31251855:metal:4230:31252275,31251856:metal:4230:31252228,31251857:metal:4230:31252156,31254344:metal:4230:31254489,31254345:metal:4230:31254427,31254346:metal:4230:31254515,31254347:metal:4230:31254572,31254348:metal:4230:31254618,31254349:metal:4230:31254653,31254350:metal:4230:31254910,31254351:metal:4230:31254740,31254352:metal:4230:31254697,31258037:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.22286765363488847, 'nb_photo': 513757, 'list_port_cont': '31243267,31243699,31243737,31243831,31244412,31244450,31244486,31247999,31249623,31249655,31249712,31249743,31249789,31249823,31249871,31249947,31250088,31250240,31250568,31250703,31251163,31251280,31252069,31252108,31252144,31252224,31252269,31252802,31254437,31254478,31254511,31254566,31254617,31254667,31254700,31254735,31254908,31258092,31258535,31258702,31258849,31259340,31259707,31259747,31259982,31260393,31260747,31261067,31261231,31261708,31261793,31262144,31262356,31262440,31262699,31262816,31263096,31263414,31263645,31263738,31263841,31264066,31264519,31264784,31264993,31265288,31265638,31266106,31266195,31266678,31266719,31267379,31267425,31267773,31268364,31268731,31269103,31269142,31269304,31269490,31269723,31270170,31270348,31270503,31270958,31271098,31271145,31271323,31271370,31271475,31271527,31271675,31271816,31272290,31272466,31272750,31272987,31273029,31273103,31273414,31273480,31274007,31274229,31274535,31274571,31274614,31274933,31275018,31275157,31275352,31275731,31276105,31276260,3127685', 'assoc_port': '31242914:31243267,31243488:31243699,31243489:31243737,31243490:31243831,31244104:31249623,31244105:31244412,31244106:31244450,31244107:31244486,31247974:31247999,31249526:31249655,31249545:31249712,31249564:31250088,31249565:31249743,31249566:31249789,31249567:31249871,31249568:31249823,31249569:31249947,31250140:31250240,31250470:31250703,31250471:31250568,31250914:31251280,31250915:31251163,31251853:31252069,31251854:31252108,31251855:31252269,31251856:31252224,31251857:31252144,31252731:31252802,31254344:31254478,31254345:31254437,31254346:31254511,31254347:31254566,31254348:31254617,31254349:31254667,31254350:31254908,31254351:31254735,31254352:31254700,31258037:31258092,31258292:31258535,31258561:31258702,31258684:31258849,31259026:31259340,31259335:31259707,31259336:31259747,31259730:31259982,31260050:31260393,31260376:31260747,31260778:31261067,31260967:31261231,31260968:31261708,31261414:31261793,31261735:31262144,31262086:31262356,31262283:31262440,31262469:31262816,31262491:31262699,31262995:3126309', 'assoc_mat': '31242914:papier:4230:31243267,31243488:papier:4230:31243699,31243489:papier:4230:31243737,31243490:papier:4230:31243831,31244104:papier:4230:31249623,31244105:papier:4230:31244412,31244106:papier:4230:31244450,31244107:papier:4230:31244486,31247974:papier:4230:31247999,31249526:papier:4230:31249655,31249545:papier:4230:31249712,31249564:papier:4230:31250088,31249565:papier:4230:31249743,31249566:papier:4230:31249789,31249567:papier:4230:31249871,31249568:papier:4230:31249823,31249569:papier:4230:31249947,31250140:papier:4230:31250240,31250470:papier:4230:31250703,31250471:papier:4230:31250568,31250914:papier:4230:31251280,31250915:papier:4230:31251163,31251853:papier:4230:31252069,31251854:papier:4230:31252108,31251855:papier:4230:31252269,31251856:papier:4230:31252224,31251857:papier:4230:31252144,31252731:papier:4230:31252802,31254344:papier:4230:31254478,31254345:papier:4230:31254437,31254346:papier:4230:31254511,31254347:papier:4230:31254566,31254348:papier:4230:31254617,31254349:papier:4230:31254667,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004652474551718237, 'nb_photo': 3807, 'list_port_cont': '31243265,31243702,31243745,31243822,31244410,31244451,31244481,31248004,31249627,31249666,31249706,31249739,31249785,31249832,31249869,31249948,31250087,31250250,31250569,31250701,31251160,31251281,31252064,31252113,31252155,31252232,31252279,31252797,31254439,31254488,31254522,31254573,31254615,31254664,31254695,31254738,31254903,31258538,31258707,31259345,31259703,31259750,31259989,31260396,31260755,31261066,31261232,31261707,31261792,31262133,31262363,31262445,31262704,31262810,31263095,31263408,31263638,31263733,31263846,31264524,31264989,31265640,31266115,31266194,31266673,31266714,31267387,31267422,31267771,31268368,31268723,31269106,31269141,31269290,31269494,31270164,31270345,31270502,31270960,31271107,31271137,31271327,31271369,31271472,31271516,31271671,31271807,31272279,31272463,31272751,31272993,31273036,31273111,31273417,31273483,31274009,31274228,31274537,31274574,31274617,31275149,31275351,31275737,31276109,31276257,31276854,31276893,31277067,31277208,31277386,31277567,31277684,31277770,3127826', 'assoc_port': '31242914:31243265,31243488:31243702,31243489:31243745,31243490:31243822,31244104:31249627,31244105:31244410,31244106:31244451,31244107:31244481,31247974:31248004,31249526:31249666,31249545:31249706,31249564:31250087,31249565:31249739,31249566:31249785,31249567:31249869,31249568:31249832,31249569:31249948,31250140:31250250,31250470:31250701,31250471:31250569,31250914:31251281,31250915:31251160,31251853:31252064,31251854:31252113,31251855:31252279,31251856:31252232,31251857:31252155,31252731:31252797,31254344:31254488,31254345:31254439,31254346:31254522,31254347:31254573,31254348:31254615,31254349:31254664,31254350:31254903,31254351:31254738,31254352:31254695,31258292:31258538,31258561:31258707,31259026:31259345,31259335:31259703,31259336:31259750,31259730:31259989,31260050:31260396,31260376:31260755,31260778:31261066,31260967:31261232,31260968:31261707,31261414:31261792,31261735:31262133,31262086:31262363,31262283:31262445,31262469:31262810,31262491:31262704,31262995:31263095,31263128:31263408,31263439:3126363', 'assoc_mat': '31242914:pehd:4230:31243265,31243488:pehd:4230:31243702,31243489:pehd:4230:31243745,31243490:pehd:4230:31243822,31244104:pehd:4230:31249627,31244105:pehd:4230:31244410,31244106:pehd:4230:31244451,31244107:pehd:4230:31244481,31247974:pehd:4230:31248004,31249526:pehd:4230:31249666,31249545:pehd:4230:31249706,31249564:pehd:4230:31250087,31249565:pehd:4230:31249739,31249566:pehd:4230:31249785,31249567:pehd:4230:31249869,31249568:pehd:4230:31249832,31249569:pehd:4230:31249948,31250140:pehd:4230:31250250,31250470:pehd:4230:31250701,31250471:pehd:4230:31250569,31250914:pehd:4230:31251281,31250915:pehd:4230:31251160,31251853:pehd:4230:31252064,31251854:pehd:4230:31252113,31251855:pehd:4230:31252279,31251856:pehd:4230:31252232,31251857:pehd:4230:31252155,31252731:pehd:4230:31252797,31254344:pehd:4230:31254488,31254345:pehd:4230:31254439,31254346:pehd:4230:31254522,31254347:pehd:4230:31254573,31254348:pehd:4230:31254615,31254349:pehd:4230:31254664,31254350:pehd:4230:31254903,31254351:pehd:4230:31254738,31254352:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012538166213307925, 'nb_photo': 30617, 'list_port_cont': '31243268,31243697,31243743,31243824,31244399,31244446,31244487,31248014,31249622,31249652,31249714,31249752,31249779,31249822,31249867,31249946,31250089,31250248,31250566,31250702,31251164,31251272,31252060,31252102,31252153,31252229,31252268,31252798,31254433,31254484,31254520,31254565,31254626,31254658,31254704,31254744,31254909,31258096,31258528,31258706,31258864,31259352,31259704,31259752,31259984,31260389,31260757,31261062,31261230,31261703,31261796,31262138,31262355,31262442,31262707,31262812,31263090,31263407,31263646,31263731,31263845,31264063,31264520,31264788,31264996,31265287,31265642,31266116,31266186,31266675,31266709,31267391,31267431,31267783,31268371,31268735,31269097,31269145,31269306,31269498,31269726,31270167,31270347,31270504,31270961,31271096,31271135,31271326,31271366,31271465,31271523,31271673,31271813,31272285,31272464,31272765,31272984,31273027,31273109,31273418,31273489,31274002,31274225,31274532,31274568,31274616,31274931,31275019,31275158,31275354,31275733,31276104,31276258,3127685', 'assoc_port': '31242914:31243268,31243488:31243697,31243489:31243743,31243490:31243824,31244104:31249622,31244105:31244399,31244106:31244446,31244107:31244487,31247974:31248014,31249526:31249652,31249545:31249714,31249564:31250089,31249565:31249752,31249566:31249779,31249567:31249867,31249568:31249822,31249569:31249946,31250140:31250248,31250470:31250702,31250471:31250566,31250914:31251272,31250915:31251164,31251853:31252060,31251854:31252102,31251855:31252268,31251856:31252229,31251857:31252153,31252731:31252798,31254344:31254484,31254345:31254433,31254346:31254520,31254347:31254565,31254348:31254626,31254349:31254658,31254350:31254909,31254351:31254744,31254352:31254704,31258037:31258096,31258292:31258528,31258561:31258706,31258684:31258864,31259026:31259352,31259335:31259704,31259336:31259752,31259730:31259984,31260050:31260389,31260376:31260757,31260778:31261062,31260967:31261230,31260968:31261703,31261414:31261796,31261735:31262138,31262086:31262355,31262283:31262442,31262469:31262812,31262491:31262707,31262995:3126309', 'assoc_mat': '31242914:pet_clair:4230:31243268,31243488:pet_clair:4230:31243697,31243489:pet_clair:4230:31243743,31243490:pet_clair:4230:31243824,31244104:pet_clair:4230:31249622,31244105:pet_clair:4230:31244399,31244106:pet_clair:4230:31244446,31244107:pet_clair:4230:31244487,31247974:pet_clair:4230:31248014,31249526:pet_clair:4230:31249652,31249545:pet_clair:4230:31249714,31249564:pet_clair:4230:31250089,31249565:pet_clair:4230:31249752,31249566:pet_clair:4230:31249779,31249567:pet_clair:4230:31249867,31249568:pet_clair:4230:31249822,31249569:pet_clair:4230:31249946,31250140:pet_clair:4230:31250248,31250470:pet_clair:4230:31250702,31250471:pet_clair:4230:31250566,31250914:pet_clair:4230:31251272,31250915:pet_clair:4230:31251164,31251853:pet_clair:4230:31252060,31251854:pet_clair:4230:31252102,31251855:pet_clair:4230:31252268,31251856:pet_clair:4230:31252229,31251857:pet_clair:4230:31252153,31252731:pet_clair:4230:31252798,31254344:pet_clair:4230:31254484,31254345:pet_clair:4230:31254433,31254346:pet_clair:4230:31254520,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0027341805394300142, 'nb_photo': 1429, 'list_port_cont': '31243271,31243695,31243741,31243826,31244406,31244448,31249618,31249661,31249713,31249786,31249831,31249863,31249944,31250076,31250243,31250570,31250699,31251162,31251268,31252062,31252107,31252150,31252233,31252274,31254429,31254490,31254524,31254571,31254624,31254665,31254904,31258532,31258700,31259347,31259697,31259748,31259986,31260400,31260749,31261065,31261234,31261711,31261798,31262145,31262365,31262448,31262711,31262818,31263084,31263405,31263639,31264521,31264995,31265635,31266110,31266188,31266677,31267390,31267430,31267778,31268373,31268737,31269105,31269143,31269296,31269502,31269724,31270171,31270339,31270508,31270950,31271101,31271147,31271328,31271368,31271474,31271680,31271815,31272291,31272468,31272759,31272985,31273035,31273113,31273422,31273488,31274006,31274222,31274529,31274564,31274615,31274927,31275017,31275150,31275349,31275728,31276111,31276263,31276845,31276900,31277066,31277219,31277384,31277570,31277680,31277765,31278254,31278334,31278624,31279959,31280872,31284240,31284318,3129047', 'assoc_port': '31242914:31243271,31243488:31243695,31243489:31243741,31243490:31243826,31244104:31249618,31244105:31244406,31244106:31244448,31249526:31249661,31249545:31249713,31249564:31250076,31249566:31249786,31249567:31249863,31249568:31249831,31249569:31249944,31250140:31250243,31250470:31250699,31250471:31250570,31250914:31251268,31250915:31251162,31251853:31252062,31251854:31252107,31251855:31252274,31251856:31252233,31251857:31252150,31254344:31254490,31254345:31254429,31254346:31254524,31254347:31254571,31254348:31254624,31254349:31254665,31254350:31254904,31258292:31258532,31258561:31258700,31259026:31259347,31259335:31259697,31259336:31259748,31259730:31259986,31260050:31260400,31260376:31260749,31260778:31261065,31260967:31261234,31260968:31261711,31261414:31261798,31261735:31262145,31262086:31262365,31262283:31262448,31262469:31262818,31262491:31262711,31262995:31263084,31263128:31263405,31263439:31263639,31264244:31264521,31264820:31264995,31265363:31265635,31265738:31266110,31265739:31266188,31266346:3126667', 'assoc_mat': '31242914:pet_fonce:4230:31243271,31243488:pet_fonce:4230:31243695,31243489:pet_fonce:4230:31243741,31243490:pet_fonce:4230:31243826,31244104:pet_fonce:4230:31249618,31244105:pet_fonce:4230:31244406,31244106:pet_fonce:4230:31244448,31249526:pet_fonce:4230:31249661,31249545:pet_fonce:4230:31249713,31249564:pet_fonce:4230:31250076,31249566:pet_fonce:4230:31249786,31249567:pet_fonce:4230:31249863,31249568:pet_fonce:4230:31249831,31249569:pet_fonce:4230:31249944,31250140:pet_fonce:4230:31250243,31250470:pet_fonce:4230:31250699,31250471:pet_fonce:4230:31250570,31250914:pet_fonce:4230:31251268,31250915:pet_fonce:4230:31251162,31251853:pet_fonce:4230:31252062,31251854:pet_fonce:4230:31252107,31251855:pet_fonce:4230:31252274,31251856:pet_fonce:4230:31252233,31251857:pet_fonce:4230:31252150,31254344:pet_fonce:4230:31254490,31254345:pet_fonce:4230:31254429,31254346:pet_fonce:4230:31254524,31254347:pet_fonce:4230:31254571,31254348:pet_fonce:4230:31254624,31254349:pet_fonce:4230:31254665,31254350:pet_fonce:4230:31254904,3'}), 'main_stat': {'nb_photos': 1883}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31341120,31341121,31341122,31341123,31341125,31341126,31341127?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-10', 0.7037406336246335),)]} filepath : /data_4/data_log/job/memo/SCCU_merge/sla_mensuel_SCCU_merge_mois_10_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.7%', 24385], 'carton': ['carton', '6.16%', 128488], 'metal': ['metal', '0.16%', 2902], 'papier': ['papier', '22.29%', 513757], 'pehd': ['pehd', '0.47%', 3807], 'pet_clair': ['pet_clair', '1.25%', 30617], 'pet_fonce': ['pet_fonce', '0.27%', 1429]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_merge/sla_mensuel_SCCU_merge_mois_10_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_merge 2.81user 2.85system 0:19.34elapsed 29%CPU (0avgtext+0avgdata 185800maxresident)k 126848inputs+312outputs (591major+48636minor)pagefaults 0swaps