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_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -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-05 _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 : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 05 mtr_id : dashboard_places : SCCU_cam8 date : 2026-05 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_cam8' and date like '%2026-05%') and created_at like '%2026-05%'))); nb_day : (4, 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 = 203 and month(ded.date) = 05 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 = 203 and month(ded.date) = 05 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 = 203 and mp.name like '%052026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-05-01 : dt_date_just_month_year : 2026-05-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_cam8" 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-05-01" AND ded.date <= "2026-05-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 (2986794,2986992,2987472,2988036,2988558,2988980,2989498,2989944,2990150) 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.009053049717190908, 'nb_photo': 3041, 'list_port_cont': '31046528,31046571,31046612,31046658,31046708,31046739,31047080,31047125,31047185,31047409,31047436,31047487,31047507,31047553,31047591,31047630,31047673,31047746,31049124,31049152,31049187,31049231,31049266,31049307,31049328,31049394,31049728,31049775,31049820,31049853,31050059,31050305,31050345,31050543,31050911,31051172,31051206,31051430,31052240,31052287,31052330,31052391,31052428,31052467,31052496,31052547,31052597,31052627,31052674,31052707,31052755,31052794,31052837,31052934,31053400,31053453,31053482,31053518,31053998,31054047,31054089,31054129,31054213,31054481,31054545,31054888,31054920,31055318,31055358,31055420,31055634,31055859,31056039,31056282,31056504,31056746,31056778,31056978,31057192,31057444,31057637,31057995,31058017,31058101,31058446,31058694,31058937,31059285,31059329,31059362,31059830,31059867,31060139,31060198,31060399,31060610,31060832,31061034,31061236,31061498,31061557,31061665,31061905,31062113,31062378,31062765,31062981,31063032,31063228,31063471,31063768,31064107,31064138,3106422', 'assoc_port': '31044731:31052240,31044732:31052287,31044734:31052330,31044735:31052934,31044736:31052391,31044737:31052428,31044738:31046528,31044739:31046571,31044740:31046612,31044741:31052467,31044742:31052496,31045940:31052547,31045941:31046658,31045942:31052597,31045943:31052627,31045944:31052674,31045945:31052707,31045946:31052755,31045947:31052794,31045948:31046708,31046291:31046739,31046292:31052837,31046306:31047080,31046307:31047125,31046308:31047185,31047210:31049124,31047211:31049152,31047212:31049231,31047213:31047409,31047214:31047436,31047215:31047487,31047291:31047507,31047293:31047591,31047294:31047553,31047348:31047673,31047349:31047630,31047350:31047746,31047351:31049394,31047705:31049187,31047706:31049266,31047707:31049307,31047708:31049328,31049377:31049728,31049378:31049775,31049379:31049820,31049380:31049853,31049427:31050059,31050039:31050305,31050040:31050345,31050381:31050543,31050636:31050911,31050890:31051172,31050891:31051206,31051252:31051430,31052875:31053400,31052876:31053453,31052877:3105348', 'assoc_mat': '31044731:autre:4230:31052240,31044732:autre:4230:31052287,31044734:autre:4230:31052330,31044735:autre:4230:31052934,31044736:autre:4230:31052391,31044737:autre:4230:31052428,31044738:autre:4230:31046528,31044739:autre:4230:31046571,31044740:autre:4230:31046612,31044741:autre:4230:31052467,31044742:autre:4230:31052496,31045940:autre:4230:31052547,31045941:autre:4230:31046658,31045942:autre:4230:31052597,31045943:autre:4230:31052627,31045944:autre:4230:31052674,31045945:autre:4230:31052707,31045946:autre:4230:31052755,31045947:autre:4230:31052794,31045948:autre:4230:31046708,31046291:autre:4230:31046739,31046292:autre:4230:31052837,31046306:autre:4230:31047080,31046307:autre:4230:31047125,31046308:autre:4230:31047185,31047210:autre:4230:31049124,31047211:autre:4230:31049152,31047212:autre:4230:31049231,31047213:autre:4230:31047409,31047214:autre:4230:31047436,31047215:autre:4230:31047487,31047291:autre:4230:31047507,31047293:autre:4230:31047591,31047294:autre:4230:31047553,31047348:autre:4230:31047673,31047349:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06661873855710615, 'nb_photo': 19712, 'list_port_cont': '31046534,31046575,31046619,31046656,31046704,31046742,31047091,31047126,31047187,31047406,31047440,31047483,31047522,31047561,31047592,31047633,31047670,31047750,31049120,31049153,31049194,31049233,31049270,31049303,31049345,31049404,31049743,31049772,31049816,31049850,31050048,31050311,31050340,31050546,31050909,31051175,31051218,31051433,31052251,31052282,31052327,31052388,31052429,31052473,31052499,31052554,31052590,31052634,31052668,31052718,31052758,31052797,31052834,31052947,31053411,31053445,31053484,31053519,31054011,31054051,31054090,31054133,31054222,31054473,31054543,31054891,31054930,31055321,31055363,31055424,31055630,31055862,31056040,31056284,31056499,31056741,31056784,31056981,31057197,31057434,31057646,31057992,31058030,31058106,31058460,31058695,31058935,31059299,31059332,31059376,31059833,31059863,31060151,31060192,31060398,31060606,31060829,31061043,31061233,31061511,31061546,31061673,31061907,31062119,31062381,31062766,31062991,31063035,31063227,31063483,31063780,31064108,31064141,3106421', 'assoc_port': '31044731:31052251,31044732:31052282,31044734:31052327,31044735:31052947,31044736:31052388,31044737:31052429,31044738:31046534,31044739:31046575,31044740:31046619,31044741:31052473,31044742:31052499,31045940:31052554,31045941:31046656,31045942:31052590,31045943:31052634,31045944:31052668,31045945:31052718,31045946:31052758,31045947:31052797,31045948:31046704,31046291:31046742,31046292:31052834,31046306:31047091,31046307:31047126,31046308:31047187,31047210:31049120,31047211:31049153,31047212:31049233,31047213:31047406,31047214:31047440,31047215:31047483,31047291:31047522,31047293:31047592,31047294:31047561,31047348:31047670,31047349:31047633,31047350:31047750,31047351:31049404,31047705:31049194,31047706:31049270,31047707:31049303,31047708:31049345,31049377:31049743,31049378:31049772,31049379:31049816,31049380:31049850,31049427:31050048,31050039:31050311,31050040:31050340,31050381:31050546,31050636:31050909,31050890:31051175,31050891:31051218,31051252:31051433,31052875:31053411,31052876:31053445,31052877:3105348', 'assoc_mat': '31044731:carton:4230:31052251,31044732:carton:4230:31052282,31044734:carton:4230:31052327,31044735:carton:4230:31052947,31044736:carton:4230:31052388,31044737:carton:4230:31052429,31044738:carton:4230:31046534,31044739:carton:4230:31046575,31044740:carton:4230:31046619,31044741:carton:4230:31052473,31044742:carton:4230:31052499,31045940:carton:4230:31052554,31045941:carton:4230:31046656,31045942:carton:4230:31052590,31045943:carton:4230:31052634,31045944:carton:4230:31052668,31045945:carton:4230:31052718,31045946:carton:4230:31052758,31045947:carton:4230:31052797,31045948:carton:4230:31046704,31046291:carton:4230:31046742,31046292:carton:4230:31052834,31046306:carton:4230:31047091,31046307:carton:4230:31047126,31046308:carton:4230:31047187,31047210:carton:4230:31049120,31047211:carton:4230:31049153,31047212:carton:4230:31049233,31047213:carton:4230:31047406,31047214:carton:4230:31047440,31047215:carton:4230:31047483,31047291:carton:4230:31047522,31047293:carton:4230:31047592,31047294:carton:4230:31047561,3104'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012706475119804057, 'nb_photo': 287, 'list_port_cont': '31046530,31046570,31046605,31046655,31046694,31046740,31047094,31047136,31047183,31047411,31047449,31047470,31047548,31047585,31047629,31047677,31047741,31049108,31049149,31049197,31049226,31049268,31049293,31049332,31049401,31049737,31049780,31049807,31049840,31050057,31051424,31052248,31052289,31052332,31052379,31052421,31052470,31052552,31052592,31052625,31052667,31052715,31052750,31052784,31052828,31052950,31053439,31054003,31054055,31054079,31054120,31054471,31054875,31055308,31055349,31055434,31055622,31056048,31056291,31056781,31056973,31057185,31057447,31057647,31057978,31058930,31059326,31060200,31060619,31060831,31061503,31061676,31062382,31063037,31063771,31064435,31064680,31065179,31065515,31066139,31066833,31066879,31067317,31068099,31068142,31069001,31069534,31070735,31071844,31071938,31072213,31072415,31072647,31073881,31073909,31074453,31074887,31075163,31077533,31077828,31078125,31078751,31079015,31079364,31080001,31080301,31080567,31080595,31080842,31081051,31081333,31081508', 'assoc_port': '31044731:31052248,31044732:31052289,31044734:31052332,31044735:31052950,31044736:31052379,31044737:31052421,31044738:31046530,31044739:31046570,31044740:31046605,31044741:31052470,31045940:31052552,31045941:31046655,31045942:31052592,31045943:31052625,31045944:31052667,31045945:31052715,31045946:31052750,31045947:31052784,31045948:31046694,31046291:31046740,31046292:31052828,31046306:31047094,31046307:31047136,31046308:31047183,31047210:31049108,31047211:31049149,31047212:31049226,31047213:31047411,31047214:31047449,31047215:31047470,31047293:31047585,31047294:31047548,31047348:31047677,31047349:31047629,31047350:31047741,31047351:31049401,31047705:31049197,31047706:31049268,31047707:31049293,31047708:31049332,31049377:31049737,31049378:31049780,31049379:31049807,31049380:31049840,31049427:31050057,31051252:31051424,31052876:31053439,31053562:31054003,31053563:31054055,31053564:31054079,31053565:31054120,31054248:31054471,31054574:31054875,31054993:31055308,31054994:31055349,31054995:31055434,31055403:3105562', 'assoc_mat': '31044731:metal:4230:31052248,31044732:metal:4230:31052289,31044734:metal:4230:31052332,31044735:metal:4230:31052950,31044736:metal:4230:31052379,31044737:metal:4230:31052421,31044738:metal:4230:31046530,31044739:metal:4230:31046570,31044740:metal:4230:31046605,31044741:metal:4230:31052470,31045940:metal:4230:31052552,31045941:metal:4230:31046655,31045942:metal:4230:31052592,31045943:metal:4230:31052625,31045944:metal:4230:31052667,31045945:metal:4230:31052715,31045946:metal:4230:31052750,31045947:metal:4230:31052784,31045948:metal:4230:31046694,31046291:metal:4230:31046740,31046292:metal:4230:31052828,31046306:metal:4230:31047094,31046307:metal:4230:31047136,31046308:metal:4230:31047183,31047210:metal:4230:31049108,31047211:metal:4230:31049149,31047212:metal:4230:31049226,31047213:metal:4230:31047411,31047214:metal:4230:31047449,31047215:metal:4230:31047470,31047293:metal:4230:31047585,31047294:metal:4230:31047548,31047348:metal:4230:31047677,31047349:metal:4230:31047629,31047350:metal:4230:31047741,31047351:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.22683539653359125, 'nb_photo': 80493, 'list_port_cont': '31046540,31046580,31046610,31046657,31046710,31046746,31047089,31047133,31047186,31047404,31047445,31047476,31047517,31047554,31047594,31047636,31047671,31047747,31049123,31049157,31049186,31049228,31049256,31049296,31049336,31049389,31049739,31049776,31049810,31049856,31050058,31050317,31050348,31050537,31050908,31051183,31051211,31051431,31052254,31052291,31052326,31052387,31052433,31052474,31052510,31052548,31052593,31052626,31052673,31052713,31052748,31052799,31052840,31052944,31053408,31053452,31053480,31053528,31054001,31054044,31054091,31054130,31054223,31054478,31054538,31054890,31054919,31055322,31055362,31055419,31055633,31055854,31056037,31056299,31056507,31056743,31056775,31056974,31057195,31057441,31057642,31057985,31058027,31058105,31058455,31058692,31058943,31059301,31059328,31059373,31059823,31059866,31060148,31060201,31060409,31060617,31060821,31061047,31061235,31061513,31061550,31061669,31061910,31062122,31062384,31062770,31062989,31063040,31063224,31063487,31063772,31064098,31064140,3106421', 'assoc_port': '31044731:31052254,31044732:31052291,31044734:31052326,31044735:31052944,31044736:31052387,31044737:31052433,31044738:31046540,31044739:31046580,31044740:31046610,31044741:31052474,31044742:31052510,31045940:31052548,31045941:31046657,31045942:31052593,31045943:31052626,31045944:31052673,31045945:31052713,31045946:31052748,31045947:31052799,31045948:31046710,31046291:31046746,31046292:31052840,31046306:31047089,31046307:31047133,31046308:31047186,31047210:31049123,31047211:31049157,31047212:31049228,31047213:31047404,31047214:31047445,31047215:31047476,31047291:31047517,31047293:31047594,31047294:31047554,31047348:31047671,31047349:31047636,31047350:31047747,31047351:31049389,31047705:31049186,31047706:31049256,31047707:31049296,31047708:31049336,31049377:31049739,31049378:31049776,31049379:31049810,31049380:31049856,31049427:31050058,31050039:31050317,31050040:31050348,31050381:31050537,31050636:31050908,31050890:31051183,31050891:31051211,31051252:31051431,31052875:31053408,31052876:31053452,31052877:3105348', 'assoc_mat': '31044731:papier:4230:31052254,31044732:papier:4230:31052291,31044734:papier:4230:31052326,31044735:papier:4230:31052944,31044736:papier:4230:31052387,31044737:papier:4230:31052433,31044738:papier:4230:31046540,31044739:papier:4230:31046580,31044740:papier:4230:31046610,31044741:papier:4230:31052474,31044742:papier:4230:31052510,31045940:papier:4230:31052548,31045941:papier:4230:31046657,31045942:papier:4230:31052593,31045943:papier:4230:31052626,31045944:papier:4230:31052673,31045945:papier:4230:31052713,31045946:papier:4230:31052748,31045947:papier:4230:31052799,31045948:papier:4230:31046710,31046291:papier:4230:31046746,31046292:papier:4230:31052840,31046306:papier:4230:31047089,31046307:papier:4230:31047133,31046308:papier:4230:31047186,31047210:papier:4230:31049123,31047211:papier:4230:31049157,31047212:papier:4230:31049228,31047213:papier:4230:31047404,31047214:papier:4230:31047445,31047215:papier:4230:31047476,31047291:papier:4230:31047517,31047293:papier:4230:31047594,31047294:papier:4230:31047554,3104'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004675927196879726, 'nb_photo': 554, 'list_port_cont': '31046537,31046582,31046609,31046651,31046698,31046748,31047134,31047184,31047407,31047448,31047482,31047511,31047551,31047589,31047634,31047675,31047743,31049122,31049161,31049195,31049232,31049263,31049300,31049342,31049403,31049738,31049784,31049808,31049855,31050060,31050308,31050547,31050902,31051181,31051212,31052242,31052293,31052331,31052382,31052434,31052463,31052506,31052553,31052595,31052635,31052669,31052721,31052751,31052795,31052838,31052948,31053409,31053448,31053527,31054050,31054479,31057191,31057446,31057645,31057990,31058018,31058098,31058454,31058700,31058941,31059293,31059338,31060407,31060608,31060828,31061045,31061239,31061560,31063238,31063777,31064213,31064679,31064796,31065142,31065184,31065511,31065684,31069007,31070816,31071927,31072656,31076257,31076529,31076726,31076837,31077089,31077522,31077784,31077836,31078105,31078140,31078329,31078562,31078747,31078979,31079026,31079375,31079573,31079728,31080312,31081046,31081332', 'assoc_port': '31044731:31052242,31044732:31052293,31044734:31052331,31044735:31052948,31044736:31052382,31044737:31052434,31044738:31046537,31044739:31046582,31044740:31046609,31044741:31052463,31044742:31052506,31045940:31052553,31045941:31046651,31045942:31052595,31045943:31052635,31045944:31052669,31045945:31052721,31045946:31052751,31045947:31052795,31045948:31046698,31046291:31046748,31046292:31052838,31046307:31047134,31046308:31047184,31047210:31049122,31047211:31049161,31047212:31049232,31047213:31047407,31047214:31047448,31047215:31047482,31047291:31047511,31047293:31047589,31047294:31047551,31047348:31047675,31047349:31047634,31047350:31047743,31047351:31049403,31047705:31049195,31047706:31049263,31047707:31049300,31047708:31049342,31049377:31049738,31049378:31049784,31049379:31049808,31049380:31049855,31049427:31050060,31050039:31050308,31050381:31050547,31050636:31050902,31050890:31051181,31050891:31051212,31052875:31053409,31052876:31053448,31052879:31053527,31053563:31054050,31054248:31054479,31057014:3105719', 'assoc_mat': '31044731:pehd:4230:31052242,31044732:pehd:4230:31052293,31044734:pehd:4230:31052331,31044735:pehd:4230:31052948,31044736:pehd:4230:31052382,31044737:pehd:4230:31052434,31044738:pehd:4230:31046537,31044739:pehd:4230:31046582,31044740:pehd:4230:31046609,31044741:pehd:4230:31052463,31044742:pehd:4230:31052506,31045940:pehd:4230:31052553,31045941:pehd:4230:31046651,31045942:pehd:4230:31052595,31045943:pehd:4230:31052635,31045944:pehd:4230:31052669,31045945:pehd:4230:31052721,31045946:pehd:4230:31052751,31045947:pehd:4230:31052795,31045948:pehd:4230:31046698,31046291:pehd:4230:31046748,31046292:pehd:4230:31052838,31046307:pehd:4230:31047134,31046308:pehd:4230:31047184,31047210:pehd:4230:31049122,31047211:pehd:4230:31049161,31047212:pehd:4230:31049232,31047213:pehd:4230:31047407,31047214:pehd:4230:31047448,31047215:pehd:4230:31047482,31047291:pehd:4230:31047511,31047293:pehd:4230:31047589,31047294:pehd:4230:31047551,31047348:pehd:4230:31047675,31047349:pehd:4230:31047634,31047350:pehd:4230:31047743,31047351:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013580600474853571, 'nb_photo': 4479, 'list_port_cont': '31046535,31046581,31046621,31046659,31046706,31046747,31047081,31047135,31047180,31047402,31047442,31047475,31047512,31047556,31047597,31047623,31047676,31047738,31049121,31049158,31049185,31049230,31049264,31049308,31049340,31049400,31049732,31049782,31049819,31049854,31050056,31050316,31050354,31050539,31050912,31051184,31051214,31051422,31052252,31052292,31052333,31052390,31052432,31052471,31052502,31052543,31052589,31052633,31052676,31052720,31052752,31052796,31052832,31052941,31053403,31053447,31053485,31053525,31054012,31054056,31054095,31054123,31054227,31054480,31054537,31054885,31054927,31055316,31055357,31055430,31055637,31055856,31056047,31056296,31056505,31056749,31056786,31056985,31057188,31057437,31057644,31057991,31058024,31058103,31058458,31058698,31058946,31059298,31059341,31059374,31059824,31059865,31060144,31060197,31060408,31060613,31060819,31061049,31061227,31061505,31061552,31061672,31061903,31062121,31062371,31062771,31062994,31063034,31063237,31063486,31063774,31064103,31064142,3106422', 'assoc_port': '31044731:31052252,31044732:31052292,31044734:31052333,31044735:31052941,31044736:31052390,31044737:31052432,31044738:31046535,31044739:31046581,31044740:31046621,31044741:31052471,31044742:31052502,31045940:31052543,31045941:31046659,31045942:31052589,31045943:31052633,31045944:31052676,31045945:31052720,31045946:31052752,31045947:31052796,31045948:31046706,31046291:31046747,31046292:31052832,31046306:31047081,31046307:31047135,31046308:31047180,31047210:31049121,31047211:31049158,31047212:31049230,31047213:31047402,31047214:31047442,31047215:31047475,31047291:31047512,31047293:31047597,31047294:31047556,31047348:31047676,31047349:31047623,31047350:31047738,31047351:31049400,31047705:31049185,31047706:31049264,31047707:31049308,31047708:31049340,31049377:31049732,31049378:31049782,31049379:31049819,31049380:31049854,31049427:31050056,31050039:31050316,31050040:31050354,31050381:31050539,31050636:31050912,31050890:31051184,31050891:31051214,31051252:31051422,31052875:31053403,31052876:31053447,31052877:3105348', 'assoc_mat': '31044731:pet_clair:4230:31052252,31044732:pet_clair:4230:31052292,31044734:pet_clair:4230:31052333,31044735:pet_clair:4230:31052941,31044736:pet_clair:4230:31052390,31044737:pet_clair:4230:31052432,31044738:pet_clair:4230:31046535,31044739:pet_clair:4230:31046581,31044740:pet_clair:4230:31046621,31044741:pet_clair:4230:31052471,31044742:pet_clair:4230:31052502,31045940:pet_clair:4230:31052543,31045941:pet_clair:4230:31046659,31045942:pet_clair:4230:31052589,31045943:pet_clair:4230:31052633,31045944:pet_clair:4230:31052676,31045945:pet_clair:4230:31052720,31045946:pet_clair:4230:31052752,31045947:pet_clair:4230:31052796,31045948:pet_clair:4230:31046706,31046291:pet_clair:4230:31046747,31046292:pet_clair:4230:31052832,31046306:pet_clair:4230:31047081,31046307:pet_clair:4230:31047135,31046308:pet_clair:4230:31047180,31047210:pet_clair:4230:31049121,31047211:pet_clair:4230:31049158,31047212:pet_clair:4230:31049230,31047213:pet_clair:4230:31047402,31047214:pet_clair:4230:31047442,31047215:pet_clair:4230:31047475,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0026920165485080504, 'nb_photo': 187, 'list_port_cont': '31046579,31046611,31046699,31046744,31047092,31047127,31047178,31047401,31047447,31047485,31047513,31047587,31047748,31049114,31049156,31049225,31049341,31049398,31049742,31049783,31050353,31051208,31051429,31052280,31052329,31052389,31052419,31052475,31052546,31052591,31052670,31052719,31052757,31052801,31052951,31053522,31055355,31056289,31056752,31057443,31057640,31058450,31060830,31061050,31061509,31061554,31061674,31061913,31062112,31062380,31062768,31063474,31063781,31064137,31064222,31064437,31064671,31064790,31065149,31065478,31065743,31068153,31068816,31070530,31071256,31072206,31072423,31072654,31072829,31073661,31073879,31074895,31076267,31076727,31077080,31077531,31077792,31077842,31078101,31078141,31078327,31078561,31078754,31078987,31079014,31079378,31079572,31080005,31080307,31080605,31080845,31081050,31081336,31081522', 'assoc_port': '31044732:31052280,31044734:31052329,31044735:31052951,31044736:31052389,31044737:31052419,31044739:31046579,31044740:31046611,31044741:31052475,31045940:31052546,31045942:31052591,31045944:31052670,31045945:31052719,31045946:31052757,31045947:31052801,31045948:31046699,31046291:31046744,31046306:31047092,31046307:31047127,31046308:31047178,31047210:31049114,31047211:31049156,31047212:31049225,31047213:31047401,31047214:31047447,31047215:31047485,31047291:31047513,31047293:31047587,31047350:31047748,31047351:31049398,31047708:31049341,31049377:31049742,31049378:31049783,31050040:31050353,31050891:31051208,31051252:31051429,31052879:31053522,31054994:31055355,31056026:31056289,31056480:31056752,31057179:31057443,31057424:31057640,31058228:31058450,31060648:31060830,31060810:31061050,31061216:31061509,31061217:31061554,31061539:31061674,31061738:31061913,31061985:31062112,31062187:31062380,31062451:31062768,31063270:31063474,31063561:31063781,31063806:31064137,31063807:31064222,31064286:31064437,31064415:3106467', 'assoc_mat': '31044732:pet_fonce:4230:31052280,31044734:pet_fonce:4230:31052329,31044735:pet_fonce:4230:31052951,31044736:pet_fonce:4230:31052389,31044737:pet_fonce:4230:31052419,31044739:pet_fonce:4230:31046579,31044740:pet_fonce:4230:31046611,31044741:pet_fonce:4230:31052475,31045940:pet_fonce:4230:31052546,31045942:pet_fonce:4230:31052591,31045944:pet_fonce:4230:31052670,31045945:pet_fonce:4230:31052719,31045946:pet_fonce:4230:31052757,31045947:pet_fonce:4230:31052801,31045948:pet_fonce:4230:31046699,31046291:pet_fonce:4230:31046744,31046306:pet_fonce:4230:31047092,31046307:pet_fonce:4230:31047127,31046308:pet_fonce:4230:31047178,31047210:pet_fonce:4230:31049114,31047211:pet_fonce:4230:31049156,31047212:pet_fonce:4230:31049225,31047213:pet_fonce:4230:31047401,31047214:pet_fonce:4230:31047447,31047215:pet_fonce:4230:31047485,31047291:pet_fonce:4230:31047513,31047293:pet_fonce:4230:31047587,31047350:pet_fonce:4230:31047748,31047351:pet_fonce:4230:31049398,31047708:pet_fonce:4230:31049341,31049377:pet_fonce:4230:31049742,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(2986794,2986992,2987472,2988036,2988558,2988980,2989498,2989944,2990150)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081570, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046528,31046571,31046612,31046658,31046708,31046739,31047080,31047125,31047185,31047409,31047436,31047487,31047507,31047553,31047591,31047630,31047673,31047746,31049124,31049152,31049187,31049231,31049266,31049307,31049328,31049394,31049728,31049775,31049820,31049853,31050059,31050305,31050345,31050543,31050911,31051172,31051206,31051430,31052240,31052287,31052330,31052391,31052428,31052467,31052496,31052547,31052597,31052627,31052674,31052707,31052755,31052794,31052837,31052934,31053400,31053453,31053482,31053518,31053998,31054047,31054089,31054129,31054213,31054481,31054545,31054888,31054920,31055318,31055358,31055420,31055634,31055859,31056039,31056282,31056504,31056746,31056778,31056978,31057192,31057444,31057637,31057995,31058017,31058101,31058446,31058694,31058937,31059285,31059329,31059362,31059830,31059867,31060139,31060198,31060399,31060610,31060832,31061034,31061236,31061498,31061557,31061665,31061905,31062113,31062378,31062765,31062981,31063032,31063228,31063471,31063768,31064107,31064138,3106422 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081571, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046534,31046575,31046619,31046656,31046704,31046742,31047091,31047126,31047187,31047406,31047440,31047483,31047522,31047561,31047592,31047633,31047670,31047750,31049120,31049153,31049194,31049233,31049270,31049303,31049345,31049404,31049743,31049772,31049816,31049850,31050048,31050311,31050340,31050546,31050909,31051175,31051218,31051433,31052251,31052282,31052327,31052388,31052429,31052473,31052499,31052554,31052590,31052634,31052668,31052718,31052758,31052797,31052834,31052947,31053411,31053445,31053484,31053519,31054011,31054051,31054090,31054133,31054222,31054473,31054543,31054891,31054930,31055321,31055363,31055424,31055630,31055862,31056040,31056284,31056499,31056741,31056784,31056981,31057197,31057434,31057646,31057992,31058030,31058106,31058460,31058695,31058935,31059299,31059332,31059376,31059833,31059863,31060151,31060192,31060398,31060606,31060829,31061043,31061233,31061511,31061546,31061673,31061907,31062119,31062381,31062766,31062991,31063035,31063227,31063483,31063780,31064108,31064141,3106421 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081572, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046530,31046570,31046605,31046655,31046694,31046740,31047094,31047136,31047183,31047411,31047449,31047470,31047548,31047585,31047629,31047677,31047741,31049108,31049149,31049197,31049226,31049268,31049293,31049332,31049401,31049737,31049780,31049807,31049840,31050057,31051424,31052248,31052289,31052332,31052379,31052421,31052470,31052552,31052592,31052625,31052667,31052715,31052750,31052784,31052828,31052950,31053439,31054003,31054055,31054079,31054120,31054471,31054875,31055308,31055349,31055434,31055622,31056048,31056291,31056781,31056973,31057185,31057447,31057647,31057978,31058930,31059326,31060200,31060619,31060831,31061503,31061676,31062382,31063037,31063771,31064435,31064680,31065179,31065515,31066139,31066833,31066879,31067317,31068099,31068142,31069001,31069534,31070735,31071844,31071938,31072213,31072415,31072647,31073881,31073909,31074453,31074887,31075163,31077533,31077828,31078125,31078751,31079015,31079364,31080001,31080301,31080567,31080595,31080842,31081051,31081333,31081508 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081573, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046540,31046580,31046610,31046657,31046710,31046746,31047089,31047133,31047186,31047404,31047445,31047476,31047517,31047554,31047594,31047636,31047671,31047747,31049123,31049157,31049186,31049228,31049256,31049296,31049336,31049389,31049739,31049776,31049810,31049856,31050058,31050317,31050348,31050537,31050908,31051183,31051211,31051431,31052254,31052291,31052326,31052387,31052433,31052474,31052510,31052548,31052593,31052626,31052673,31052713,31052748,31052799,31052840,31052944,31053408,31053452,31053480,31053528,31054001,31054044,31054091,31054130,31054223,31054478,31054538,31054890,31054919,31055322,31055362,31055419,31055633,31055854,31056037,31056299,31056507,31056743,31056775,31056974,31057195,31057441,31057642,31057985,31058027,31058105,31058455,31058692,31058943,31059301,31059328,31059373,31059823,31059866,31060148,31060201,31060409,31060617,31060821,31061047,31061235,31061513,31061550,31061669,31061910,31062122,31062384,31062770,31062989,31063040,31063224,31063487,31063772,31064098,31064140,3106421 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081574, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046537,31046582,31046609,31046651,31046698,31046748,31047134,31047184,31047407,31047448,31047482,31047511,31047551,31047589,31047634,31047675,31047743,31049122,31049161,31049195,31049232,31049263,31049300,31049342,31049403,31049738,31049784,31049808,31049855,31050060,31050308,31050547,31050902,31051181,31051212,31052242,31052293,31052331,31052382,31052434,31052463,31052506,31052553,31052595,31052635,31052669,31052721,31052751,31052795,31052838,31052948,31053409,31053448,31053527,31054050,31054479,31057191,31057446,31057645,31057990,31058018,31058098,31058454,31058700,31058941,31059293,31059338,31060407,31060608,31060828,31061045,31061239,31061560,31063238,31063777,31064213,31064679,31064796,31065142,31065184,31065511,31065684,31069007,31070816,31071927,31072656,31076257,31076529,31076726,31076837,31077089,31077522,31077784,31077836,31078105,31078140,31078329,31078562,31078747,31078979,31079026,31079375,31079573,31079728,31080312,31081046,31081332 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081575, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046535,31046581,31046621,31046659,31046706,31046747,31047081,31047135,31047180,31047402,31047442,31047475,31047512,31047556,31047597,31047623,31047676,31047738,31049121,31049158,31049185,31049230,31049264,31049308,31049340,31049400,31049732,31049782,31049819,31049854,31050056,31050316,31050354,31050539,31050912,31051184,31051214,31051422,31052252,31052292,31052333,31052390,31052432,31052471,31052502,31052543,31052589,31052633,31052676,31052720,31052752,31052796,31052832,31052941,31053403,31053447,31053485,31053525,31054012,31054056,31054095,31054123,31054227,31054480,31054537,31054885,31054927,31055316,31055357,31055430,31055637,31055856,31056047,31056296,31056505,31056749,31056786,31056985,31057188,31057437,31057644,31057991,31058024,31058103,31058458,31058698,31058946,31059298,31059341,31059374,31059824,31059865,31060144,31060197,31060408,31060613,31060819,31061049,31061227,31061505,31061552,31061672,31061903,31062121,31062371,31062771,31062994,31063034,31063237,31063486,31063774,31064103,31064142,3106422 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081576, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046579,31046611,31046699,31046744,31047092,31047127,31047178,31047401,31047447,31047485,31047513,31047587,31047748,31049114,31049156,31049225,31049341,31049398,31049742,31049783,31050353,31051208,31051429,31052280,31052329,31052389,31052419,31052475,31052546,31052591,31052670,31052719,31052757,31052801,31052951,31053522,31055355,31056289,31056752,31057443,31057640,31058450,31060830,31061050,31061509,31061554,31061674,31061913,31062112,31062380,31062768,31063474,31063781,31064137,31064222,31064437,31064671,31064790,31065149,31065478,31065743,31068153,31068816,31070530,31071256,31072206,31072423,31072654,31072829,31073661,31073879,31074895,31076267,31076727,31077080,31077531,31077792,31077842,31078101,31078141,31078327,31078561,31078754,31078987,31079014,31079378,31079572,31080005,31080307,31080605,31080845,31081050,31081336,31081522 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31081570,31081571,31081572,31081573,31081574,31081575,31081576?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=203 and date >='2026-05-01' and date <= '2026-05-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((454,),), 'unwanted_material_monthly_percentage': ((0.747684689760811,),), 'material_repartition': (('incineration', 453),), 'material_dict': {'incineration': 453}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 5, 9), 0.5256462973874203, 2), (datetime.date(2026, 5, 10), 0.6480850816841879, 2), (datetime.date(2026, 5, 11), 0.8176824682709378, 4), (datetime.date(2026, 5, 12), 0.7930599703650785, 3), (datetime.date(2026, 5, 13), 0.7999183154322536, 1), (datetime.date(2026, 5, 14), 0.8039334918777752, 3), (datetime.date(2026, 5, 15), 0.8488457459420624, 3), (datetime.date(2026, 5, 16), 0.7857118391900736, 2), (datetime.date(2026, 5, 17), 0.7567119351145078, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 5, 9), 0.5256462973874203, 2), (datetime.date(2026, 5, 10), 0.6480850816841879, 2), (datetime.date(2026, 5, 11), 0.8176824682709378, 4), (datetime.date(2026, 5, 12), 0.7930599703650785, 3), (datetime.date(2026, 5, 13), 0.7999183154322536, 1), (datetime.date(2026, 5, 14), 0.8039334918777752, 3), (datetime.date(2026, 5, 15), 0.8488457459420624, 3), (datetime.date(2026, 5, 16), 0.7857118391900736, 2), (datetime.date(2026, 5, 17), 0.7567119351145078, 2))}, 'quality_array': [['-8.972491144807936', '09052026'], ['-8.888909122324726', '10052026'], ['-8.488301629520107', '11052026'], ['-7.903267725665594', '12052026'], ['-7.839672681411037', '13052026'], ['-8.009160563830342', '14052026'], ['-7.834591582766006', '15052026'], ['-7.53749746862773', '16052026'], ['-7.524698528778309', '17052026']], 'number_of_batch': ((203,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.009053049717190908, 'nb_photo': 3041, 'list_port_cont': '31046528,31046571,31046612,31046658,31046708,31046739,31047080,31047125,31047185,31047409,31047436,31047487,31047507,31047553,31047591,31047630,31047673,31047746,31049124,31049152,31049187,31049231,31049266,31049307,31049328,31049394,31049728,31049775,31049820,31049853,31050059,31050305,31050345,31050543,31050911,31051172,31051206,31051430,31052240,31052287,31052330,31052391,31052428,31052467,31052496,31052547,31052597,31052627,31052674,31052707,31052755,31052794,31052837,31052934,31053400,31053453,31053482,31053518,31053998,31054047,31054089,31054129,31054213,31054481,31054545,31054888,31054920,31055318,31055358,31055420,31055634,31055859,31056039,31056282,31056504,31056746,31056778,31056978,31057192,31057444,31057637,31057995,31058017,31058101,31058446,31058694,31058937,31059285,31059329,31059362,31059830,31059867,31060139,31060198,31060399,31060610,31060832,31061034,31061236,31061498,31061557,31061665,31061905,31062113,31062378,31062765,31062981,31063032,31063228,31063471,31063768,31064107,31064138,3106422', 'assoc_port': '31044731:31052240,31044732:31052287,31044734:31052330,31044735:31052934,31044736:31052391,31044737:31052428,31044738:31046528,31044739:31046571,31044740:31046612,31044741:31052467,31044742:31052496,31045940:31052547,31045941:31046658,31045942:31052597,31045943:31052627,31045944:31052674,31045945:31052707,31045946:31052755,31045947:31052794,31045948:31046708,31046291:31046739,31046292:31052837,31046306:31047080,31046307:31047125,31046308:31047185,31047210:31049124,31047211:31049152,31047212:31049231,31047213:31047409,31047214:31047436,31047215:31047487,31047291:31047507,31047293:31047591,31047294:31047553,31047348:31047673,31047349:31047630,31047350:31047746,31047351:31049394,31047705:31049187,31047706:31049266,31047707:31049307,31047708:31049328,31049377:31049728,31049378:31049775,31049379:31049820,31049380:31049853,31049427:31050059,31050039:31050305,31050040:31050345,31050381:31050543,31050636:31050911,31050890:31051172,31050891:31051206,31051252:31051430,31052875:31053400,31052876:31053453,31052877:3105348', 'assoc_mat': '31044731:autre:4230:31052240,31044732:autre:4230:31052287,31044734:autre:4230:31052330,31044735:autre:4230:31052934,31044736:autre:4230:31052391,31044737:autre:4230:31052428,31044738:autre:4230:31046528,31044739:autre:4230:31046571,31044740:autre:4230:31046612,31044741:autre:4230:31052467,31044742:autre:4230:31052496,31045940:autre:4230:31052547,31045941:autre:4230:31046658,31045942:autre:4230:31052597,31045943:autre:4230:31052627,31045944:autre:4230:31052674,31045945:autre:4230:31052707,31045946:autre:4230:31052755,31045947:autre:4230:31052794,31045948:autre:4230:31046708,31046291:autre:4230:31046739,31046292:autre:4230:31052837,31046306:autre:4230:31047080,31046307:autre:4230:31047125,31046308:autre:4230:31047185,31047210:autre:4230:31049124,31047211:autre:4230:31049152,31047212:autre:4230:31049231,31047213:autre:4230:31047409,31047214:autre:4230:31047436,31047215:autre:4230:31047487,31047291:autre:4230:31047507,31047293:autre:4230:31047591,31047294:autre:4230:31047553,31047348:autre:4230:31047673,31047349:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06661873855710615, 'nb_photo': 19712, 'list_port_cont': '31046534,31046575,31046619,31046656,31046704,31046742,31047091,31047126,31047187,31047406,31047440,31047483,31047522,31047561,31047592,31047633,31047670,31047750,31049120,31049153,31049194,31049233,31049270,31049303,31049345,31049404,31049743,31049772,31049816,31049850,31050048,31050311,31050340,31050546,31050909,31051175,31051218,31051433,31052251,31052282,31052327,31052388,31052429,31052473,31052499,31052554,31052590,31052634,31052668,31052718,31052758,31052797,31052834,31052947,31053411,31053445,31053484,31053519,31054011,31054051,31054090,31054133,31054222,31054473,31054543,31054891,31054930,31055321,31055363,31055424,31055630,31055862,31056040,31056284,31056499,31056741,31056784,31056981,31057197,31057434,31057646,31057992,31058030,31058106,31058460,31058695,31058935,31059299,31059332,31059376,31059833,31059863,31060151,31060192,31060398,31060606,31060829,31061043,31061233,31061511,31061546,31061673,31061907,31062119,31062381,31062766,31062991,31063035,31063227,31063483,31063780,31064108,31064141,3106421', 'assoc_port': '31044731:31052251,31044732:31052282,31044734:31052327,31044735:31052947,31044736:31052388,31044737:31052429,31044738:31046534,31044739:31046575,31044740:31046619,31044741:31052473,31044742:31052499,31045940:31052554,31045941:31046656,31045942:31052590,31045943:31052634,31045944:31052668,31045945:31052718,31045946:31052758,31045947:31052797,31045948:31046704,31046291:31046742,31046292:31052834,31046306:31047091,31046307:31047126,31046308:31047187,31047210:31049120,31047211:31049153,31047212:31049233,31047213:31047406,31047214:31047440,31047215:31047483,31047291:31047522,31047293:31047592,31047294:31047561,31047348:31047670,31047349:31047633,31047350:31047750,31047351:31049404,31047705:31049194,31047706:31049270,31047707:31049303,31047708:31049345,31049377:31049743,31049378:31049772,31049379:31049816,31049380:31049850,31049427:31050048,31050039:31050311,31050040:31050340,31050381:31050546,31050636:31050909,31050890:31051175,31050891:31051218,31051252:31051433,31052875:31053411,31052876:31053445,31052877:3105348', 'assoc_mat': '31044731:carton:4230:31052251,31044732:carton:4230:31052282,31044734:carton:4230:31052327,31044735:carton:4230:31052947,31044736:carton:4230:31052388,31044737:carton:4230:31052429,31044738:carton:4230:31046534,31044739:carton:4230:31046575,31044740:carton:4230:31046619,31044741:carton:4230:31052473,31044742:carton:4230:31052499,31045940:carton:4230:31052554,31045941:carton:4230:31046656,31045942:carton:4230:31052590,31045943:carton:4230:31052634,31045944:carton:4230:31052668,31045945:carton:4230:31052718,31045946:carton:4230:31052758,31045947:carton:4230:31052797,31045948:carton:4230:31046704,31046291:carton:4230:31046742,31046292:carton:4230:31052834,31046306:carton:4230:31047091,31046307:carton:4230:31047126,31046308:carton:4230:31047187,31047210:carton:4230:31049120,31047211:carton:4230:31049153,31047212:carton:4230:31049233,31047213:carton:4230:31047406,31047214:carton:4230:31047440,31047215:carton:4230:31047483,31047291:carton:4230:31047522,31047293:carton:4230:31047592,31047294:carton:4230:31047561,3104'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012706475119804057, 'nb_photo': 287, 'list_port_cont': '31046530,31046570,31046605,31046655,31046694,31046740,31047094,31047136,31047183,31047411,31047449,31047470,31047548,31047585,31047629,31047677,31047741,31049108,31049149,31049197,31049226,31049268,31049293,31049332,31049401,31049737,31049780,31049807,31049840,31050057,31051424,31052248,31052289,31052332,31052379,31052421,31052470,31052552,31052592,31052625,31052667,31052715,31052750,31052784,31052828,31052950,31053439,31054003,31054055,31054079,31054120,31054471,31054875,31055308,31055349,31055434,31055622,31056048,31056291,31056781,31056973,31057185,31057447,31057647,31057978,31058930,31059326,31060200,31060619,31060831,31061503,31061676,31062382,31063037,31063771,31064435,31064680,31065179,31065515,31066139,31066833,31066879,31067317,31068099,31068142,31069001,31069534,31070735,31071844,31071938,31072213,31072415,31072647,31073881,31073909,31074453,31074887,31075163,31077533,31077828,31078125,31078751,31079015,31079364,31080001,31080301,31080567,31080595,31080842,31081051,31081333,31081508', 'assoc_port': '31044731:31052248,31044732:31052289,31044734:31052332,31044735:31052950,31044736:31052379,31044737:31052421,31044738:31046530,31044739:31046570,31044740:31046605,31044741:31052470,31045940:31052552,31045941:31046655,31045942:31052592,31045943:31052625,31045944:31052667,31045945:31052715,31045946:31052750,31045947:31052784,31045948:31046694,31046291:31046740,31046292:31052828,31046306:31047094,31046307:31047136,31046308:31047183,31047210:31049108,31047211:31049149,31047212:31049226,31047213:31047411,31047214:31047449,31047215:31047470,31047293:31047585,31047294:31047548,31047348:31047677,31047349:31047629,31047350:31047741,31047351:31049401,31047705:31049197,31047706:31049268,31047707:31049293,31047708:31049332,31049377:31049737,31049378:31049780,31049379:31049807,31049380:31049840,31049427:31050057,31051252:31051424,31052876:31053439,31053562:31054003,31053563:31054055,31053564:31054079,31053565:31054120,31054248:31054471,31054574:31054875,31054993:31055308,31054994:31055349,31054995:31055434,31055403:3105562', 'assoc_mat': '31044731:metal:4230:31052248,31044732:metal:4230:31052289,31044734:metal:4230:31052332,31044735:metal:4230:31052950,31044736:metal:4230:31052379,31044737:metal:4230:31052421,31044738:metal:4230:31046530,31044739:metal:4230:31046570,31044740:metal:4230:31046605,31044741:metal:4230:31052470,31045940:metal:4230:31052552,31045941:metal:4230:31046655,31045942:metal:4230:31052592,31045943:metal:4230:31052625,31045944:metal:4230:31052667,31045945:metal:4230:31052715,31045946:metal:4230:31052750,31045947:metal:4230:31052784,31045948:metal:4230:31046694,31046291:metal:4230:31046740,31046292:metal:4230:31052828,31046306:metal:4230:31047094,31046307:metal:4230:31047136,31046308:metal:4230:31047183,31047210:metal:4230:31049108,31047211:metal:4230:31049149,31047212:metal:4230:31049226,31047213:metal:4230:31047411,31047214:metal:4230:31047449,31047215:metal:4230:31047470,31047293:metal:4230:31047585,31047294:metal:4230:31047548,31047348:metal:4230:31047677,31047349:metal:4230:31047629,31047350:metal:4230:31047741,31047351:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.22683539653359125, 'nb_photo': 80493, 'list_port_cont': '31046540,31046580,31046610,31046657,31046710,31046746,31047089,31047133,31047186,31047404,31047445,31047476,31047517,31047554,31047594,31047636,31047671,31047747,31049123,31049157,31049186,31049228,31049256,31049296,31049336,31049389,31049739,31049776,31049810,31049856,31050058,31050317,31050348,31050537,31050908,31051183,31051211,31051431,31052254,31052291,31052326,31052387,31052433,31052474,31052510,31052548,31052593,31052626,31052673,31052713,31052748,31052799,31052840,31052944,31053408,31053452,31053480,31053528,31054001,31054044,31054091,31054130,31054223,31054478,31054538,31054890,31054919,31055322,31055362,31055419,31055633,31055854,31056037,31056299,31056507,31056743,31056775,31056974,31057195,31057441,31057642,31057985,31058027,31058105,31058455,31058692,31058943,31059301,31059328,31059373,31059823,31059866,31060148,31060201,31060409,31060617,31060821,31061047,31061235,31061513,31061550,31061669,31061910,31062122,31062384,31062770,31062989,31063040,31063224,31063487,31063772,31064098,31064140,3106421', 'assoc_port': '31044731:31052254,31044732:31052291,31044734:31052326,31044735:31052944,31044736:31052387,31044737:31052433,31044738:31046540,31044739:31046580,31044740:31046610,31044741:31052474,31044742:31052510,31045940:31052548,31045941:31046657,31045942:31052593,31045943:31052626,31045944:31052673,31045945:31052713,31045946:31052748,31045947:31052799,31045948:31046710,31046291:31046746,31046292:31052840,31046306:31047089,31046307:31047133,31046308:31047186,31047210:31049123,31047211:31049157,31047212:31049228,31047213:31047404,31047214:31047445,31047215:31047476,31047291:31047517,31047293:31047594,31047294:31047554,31047348:31047671,31047349:31047636,31047350:31047747,31047351:31049389,31047705:31049186,31047706:31049256,31047707:31049296,31047708:31049336,31049377:31049739,31049378:31049776,31049379:31049810,31049380:31049856,31049427:31050058,31050039:31050317,31050040:31050348,31050381:31050537,31050636:31050908,31050890:31051183,31050891:31051211,31051252:31051431,31052875:31053408,31052876:31053452,31052877:3105348', 'assoc_mat': '31044731:papier:4230:31052254,31044732:papier:4230:31052291,31044734:papier:4230:31052326,31044735:papier:4230:31052944,31044736:papier:4230:31052387,31044737:papier:4230:31052433,31044738:papier:4230:31046540,31044739:papier:4230:31046580,31044740:papier:4230:31046610,31044741:papier:4230:31052474,31044742:papier:4230:31052510,31045940:papier:4230:31052548,31045941:papier:4230:31046657,31045942:papier:4230:31052593,31045943:papier:4230:31052626,31045944:papier:4230:31052673,31045945:papier:4230:31052713,31045946:papier:4230:31052748,31045947:papier:4230:31052799,31045948:papier:4230:31046710,31046291:papier:4230:31046746,31046292:papier:4230:31052840,31046306:papier:4230:31047089,31046307:papier:4230:31047133,31046308:papier:4230:31047186,31047210:papier:4230:31049123,31047211:papier:4230:31049157,31047212:papier:4230:31049228,31047213:papier:4230:31047404,31047214:papier:4230:31047445,31047215:papier:4230:31047476,31047291:papier:4230:31047517,31047293:papier:4230:31047594,31047294:papier:4230:31047554,3104'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004675927196879726, 'nb_photo': 554, 'list_port_cont': '31046537,31046582,31046609,31046651,31046698,31046748,31047134,31047184,31047407,31047448,31047482,31047511,31047551,31047589,31047634,31047675,31047743,31049122,31049161,31049195,31049232,31049263,31049300,31049342,31049403,31049738,31049784,31049808,31049855,31050060,31050308,31050547,31050902,31051181,31051212,31052242,31052293,31052331,31052382,31052434,31052463,31052506,31052553,31052595,31052635,31052669,31052721,31052751,31052795,31052838,31052948,31053409,31053448,31053527,31054050,31054479,31057191,31057446,31057645,31057990,31058018,31058098,31058454,31058700,31058941,31059293,31059338,31060407,31060608,31060828,31061045,31061239,31061560,31063238,31063777,31064213,31064679,31064796,31065142,31065184,31065511,31065684,31069007,31070816,31071927,31072656,31076257,31076529,31076726,31076837,31077089,31077522,31077784,31077836,31078105,31078140,31078329,31078562,31078747,31078979,31079026,31079375,31079573,31079728,31080312,31081046,31081332', 'assoc_port': '31044731:31052242,31044732:31052293,31044734:31052331,31044735:31052948,31044736:31052382,31044737:31052434,31044738:31046537,31044739:31046582,31044740:31046609,31044741:31052463,31044742:31052506,31045940:31052553,31045941:31046651,31045942:31052595,31045943:31052635,31045944:31052669,31045945:31052721,31045946:31052751,31045947:31052795,31045948:31046698,31046291:31046748,31046292:31052838,31046307:31047134,31046308:31047184,31047210:31049122,31047211:31049161,31047212:31049232,31047213:31047407,31047214:31047448,31047215:31047482,31047291:31047511,31047293:31047589,31047294:31047551,31047348:31047675,31047349:31047634,31047350:31047743,31047351:31049403,31047705:31049195,31047706:31049263,31047707:31049300,31047708:31049342,31049377:31049738,31049378:31049784,31049379:31049808,31049380:31049855,31049427:31050060,31050039:31050308,31050381:31050547,31050636:31050902,31050890:31051181,31050891:31051212,31052875:31053409,31052876:31053448,31052879:31053527,31053563:31054050,31054248:31054479,31057014:3105719', 'assoc_mat': '31044731:pehd:4230:31052242,31044732:pehd:4230:31052293,31044734:pehd:4230:31052331,31044735:pehd:4230:31052948,31044736:pehd:4230:31052382,31044737:pehd:4230:31052434,31044738:pehd:4230:31046537,31044739:pehd:4230:31046582,31044740:pehd:4230:31046609,31044741:pehd:4230:31052463,31044742:pehd:4230:31052506,31045940:pehd:4230:31052553,31045941:pehd:4230:31046651,31045942:pehd:4230:31052595,31045943:pehd:4230:31052635,31045944:pehd:4230:31052669,31045945:pehd:4230:31052721,31045946:pehd:4230:31052751,31045947:pehd:4230:31052795,31045948:pehd:4230:31046698,31046291:pehd:4230:31046748,31046292:pehd:4230:31052838,31046307:pehd:4230:31047134,31046308:pehd:4230:31047184,31047210:pehd:4230:31049122,31047211:pehd:4230:31049161,31047212:pehd:4230:31049232,31047213:pehd:4230:31047407,31047214:pehd:4230:31047448,31047215:pehd:4230:31047482,31047291:pehd:4230:31047511,31047293:pehd:4230:31047589,31047294:pehd:4230:31047551,31047348:pehd:4230:31047675,31047349:pehd:4230:31047634,31047350:pehd:4230:31047743,31047351:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013580600474853571, 'nb_photo': 4479, 'list_port_cont': '31046535,31046581,31046621,31046659,31046706,31046747,31047081,31047135,31047180,31047402,31047442,31047475,31047512,31047556,31047597,31047623,31047676,31047738,31049121,31049158,31049185,31049230,31049264,31049308,31049340,31049400,31049732,31049782,31049819,31049854,31050056,31050316,31050354,31050539,31050912,31051184,31051214,31051422,31052252,31052292,31052333,31052390,31052432,31052471,31052502,31052543,31052589,31052633,31052676,31052720,31052752,31052796,31052832,31052941,31053403,31053447,31053485,31053525,31054012,31054056,31054095,31054123,31054227,31054480,31054537,31054885,31054927,31055316,31055357,31055430,31055637,31055856,31056047,31056296,31056505,31056749,31056786,31056985,31057188,31057437,31057644,31057991,31058024,31058103,31058458,31058698,31058946,31059298,31059341,31059374,31059824,31059865,31060144,31060197,31060408,31060613,31060819,31061049,31061227,31061505,31061552,31061672,31061903,31062121,31062371,31062771,31062994,31063034,31063237,31063486,31063774,31064103,31064142,3106422', 'assoc_port': '31044731:31052252,31044732:31052292,31044734:31052333,31044735:31052941,31044736:31052390,31044737:31052432,31044738:31046535,31044739:31046581,31044740:31046621,31044741:31052471,31044742:31052502,31045940:31052543,31045941:31046659,31045942:31052589,31045943:31052633,31045944:31052676,31045945:31052720,31045946:31052752,31045947:31052796,31045948:31046706,31046291:31046747,31046292:31052832,31046306:31047081,31046307:31047135,31046308:31047180,31047210:31049121,31047211:31049158,31047212:31049230,31047213:31047402,31047214:31047442,31047215:31047475,31047291:31047512,31047293:31047597,31047294:31047556,31047348:31047676,31047349:31047623,31047350:31047738,31047351:31049400,31047705:31049185,31047706:31049264,31047707:31049308,31047708:31049340,31049377:31049732,31049378:31049782,31049379:31049819,31049380:31049854,31049427:31050056,31050039:31050316,31050040:31050354,31050381:31050539,31050636:31050912,31050890:31051184,31050891:31051214,31051252:31051422,31052875:31053403,31052876:31053447,31052877:3105348', 'assoc_mat': '31044731:pet_clair:4230:31052252,31044732:pet_clair:4230:31052292,31044734:pet_clair:4230:31052333,31044735:pet_clair:4230:31052941,31044736:pet_clair:4230:31052390,31044737:pet_clair:4230:31052432,31044738:pet_clair:4230:31046535,31044739:pet_clair:4230:31046581,31044740:pet_clair:4230:31046621,31044741:pet_clair:4230:31052471,31044742:pet_clair:4230:31052502,31045940:pet_clair:4230:31052543,31045941:pet_clair:4230:31046659,31045942:pet_clair:4230:31052589,31045943:pet_clair:4230:31052633,31045944:pet_clair:4230:31052676,31045945:pet_clair:4230:31052720,31045946:pet_clair:4230:31052752,31045947:pet_clair:4230:31052796,31045948:pet_clair:4230:31046706,31046291:pet_clair:4230:31046747,31046292:pet_clair:4230:31052832,31046306:pet_clair:4230:31047081,31046307:pet_clair:4230:31047135,31046308:pet_clair:4230:31047180,31047210:pet_clair:4230:31049121,31047211:pet_clair:4230:31049158,31047212:pet_clair:4230:31049230,31047213:pet_clair:4230:31047402,31047214:pet_clair:4230:31047442,31047215:pet_clair:4230:31047475,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0026920165485080504, 'nb_photo': 187, 'list_port_cont': '31046579,31046611,31046699,31046744,31047092,31047127,31047178,31047401,31047447,31047485,31047513,31047587,31047748,31049114,31049156,31049225,31049341,31049398,31049742,31049783,31050353,31051208,31051429,31052280,31052329,31052389,31052419,31052475,31052546,31052591,31052670,31052719,31052757,31052801,31052951,31053522,31055355,31056289,31056752,31057443,31057640,31058450,31060830,31061050,31061509,31061554,31061674,31061913,31062112,31062380,31062768,31063474,31063781,31064137,31064222,31064437,31064671,31064790,31065149,31065478,31065743,31068153,31068816,31070530,31071256,31072206,31072423,31072654,31072829,31073661,31073879,31074895,31076267,31076727,31077080,31077531,31077792,31077842,31078101,31078141,31078327,31078561,31078754,31078987,31079014,31079378,31079572,31080005,31080307,31080605,31080845,31081050,31081336,31081522', 'assoc_port': '31044732:31052280,31044734:31052329,31044735:31052951,31044736:31052389,31044737:31052419,31044739:31046579,31044740:31046611,31044741:31052475,31045940:31052546,31045942:31052591,31045944:31052670,31045945:31052719,31045946:31052757,31045947:31052801,31045948:31046699,31046291:31046744,31046306:31047092,31046307:31047127,31046308:31047178,31047210:31049114,31047211:31049156,31047212:31049225,31047213:31047401,31047214:31047447,31047215:31047485,31047291:31047513,31047293:31047587,31047350:31047748,31047351:31049398,31047708:31049341,31049377:31049742,31049378:31049783,31050040:31050353,31050891:31051208,31051252:31051429,31052879:31053522,31054994:31055355,31056026:31056289,31056480:31056752,31057179:31057443,31057424:31057640,31058228:31058450,31060648:31060830,31060810:31061050,31061216:31061509,31061217:31061554,31061539:31061674,31061738:31061913,31061985:31062112,31062187:31062380,31062451:31062768,31063270:31063474,31063561:31063781,31063806:31064137,31063807:31064222,31064286:31064437,31064415:3106467', 'assoc_mat': '31044732:pet_fonce:4230:31052280,31044734:pet_fonce:4230:31052329,31044735:pet_fonce:4230:31052951,31044736:pet_fonce:4230:31052389,31044737:pet_fonce:4230:31052419,31044739:pet_fonce:4230:31046579,31044740:pet_fonce:4230:31046611,31044741:pet_fonce:4230:31052475,31045940:pet_fonce:4230:31052546,31045942:pet_fonce:4230:31052591,31045944:pet_fonce:4230:31052670,31045945:pet_fonce:4230:31052719,31045946:pet_fonce:4230:31052757,31045947:pet_fonce:4230:31052801,31045948:pet_fonce:4230:31046699,31046291:pet_fonce:4230:31046744,31046306:pet_fonce:4230:31047092,31046307:pet_fonce:4230:31047127,31046308:pet_fonce:4230:31047178,31047210:pet_fonce:4230:31049114,31047211:pet_fonce:4230:31049156,31047212:pet_fonce:4230:31049225,31047213:pet_fonce:4230:31047401,31047214:pet_fonce:4230:31047447,31047215:pet_fonce:4230:31047485,31047291:pet_fonce:4230:31047513,31047293:pet_fonce:4230:31047587,31047350:pet_fonce:4230:31047748,31047351:pet_fonce:4230:31049398,31047708:pet_fonce:4230:31049341,31049377:pet_fonce:4230:31049742,3'}), 'main_stat': {'nb_photos': 454}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31081570,31081571,31081572,31081573,31081574,31081575,31081576?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-05', 0.747684689760811),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((454,),), 'unwanted_material_monthly_percentage': ((0.747684689760811,),), 'material_repartition': (('incineration', 453),), 'material_dict': {'incineration': 453}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 5, 9), 0.5256462973874203, 2), (datetime.date(2026, 5, 10), 0.6480850816841879, 2), (datetime.date(2026, 5, 11), 0.8176824682709378, 4), (datetime.date(2026, 5, 12), 0.7930599703650785, 3), (datetime.date(2026, 5, 13), 0.7999183154322536, 1), (datetime.date(2026, 5, 14), 0.8039334918777752, 3), (datetime.date(2026, 5, 15), 0.8488457459420624, 3), (datetime.date(2026, 5, 16), 0.7857118391900736, 2), (datetime.date(2026, 5, 17), 0.7567119351145078, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 5, 9), 0.5256462973874203, 2), (datetime.date(2026, 5, 10), 0.6480850816841879, 2), (datetime.date(2026, 5, 11), 0.8176824682709378, 4), (datetime.date(2026, 5, 12), 0.7930599703650785, 3), (datetime.date(2026, 5, 13), 0.7999183154322536, 1), (datetime.date(2026, 5, 14), 0.8039334918777752, 3), (datetime.date(2026, 5, 15), 0.8488457459420624, 3), (datetime.date(2026, 5, 16), 0.7857118391900736, 2), (datetime.date(2026, 5, 17), 0.7567119351145078, 2))}, 'quality_array': [['-8.972491144807936', '09052026'], ['-8.888909122324726', '10052026'], ['-8.488301629520107', '11052026'], ['-7.903267725665594', '12052026'], ['-7.839672681411037', '13052026'], ['-8.009160563830342', '14052026'], ['-7.834591582766006', '15052026'], ['-7.53749746862773', '16052026'], ['-7.524698528778309', '17052026']], 'number_of_batch': ((203,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.009053049717190908, 'nb_photo': 3041, 'list_port_cont': '31046528,31046571,31046612,31046658,31046708,31046739,31047080,31047125,31047185,31047409,31047436,31047487,31047507,31047553,31047591,31047630,31047673,31047746,31049124,31049152,31049187,31049231,31049266,31049307,31049328,31049394,31049728,31049775,31049820,31049853,31050059,31050305,31050345,31050543,31050911,31051172,31051206,31051430,31052240,31052287,31052330,31052391,31052428,31052467,31052496,31052547,31052597,31052627,31052674,31052707,31052755,31052794,31052837,31052934,31053400,31053453,31053482,31053518,31053998,31054047,31054089,31054129,31054213,31054481,31054545,31054888,31054920,31055318,31055358,31055420,31055634,31055859,31056039,31056282,31056504,31056746,31056778,31056978,31057192,31057444,31057637,31057995,31058017,31058101,31058446,31058694,31058937,31059285,31059329,31059362,31059830,31059867,31060139,31060198,31060399,31060610,31060832,31061034,31061236,31061498,31061557,31061665,31061905,31062113,31062378,31062765,31062981,31063032,31063228,31063471,31063768,31064107,31064138,3106422', 'assoc_port': '31044731:31052240,31044732:31052287,31044734:31052330,31044735:31052934,31044736:31052391,31044737:31052428,31044738:31046528,31044739:31046571,31044740:31046612,31044741:31052467,31044742:31052496,31045940:31052547,31045941:31046658,31045942:31052597,31045943:31052627,31045944:31052674,31045945:31052707,31045946:31052755,31045947:31052794,31045948:31046708,31046291:31046739,31046292:31052837,31046306:31047080,31046307:31047125,31046308:31047185,31047210:31049124,31047211:31049152,31047212:31049231,31047213:31047409,31047214:31047436,31047215:31047487,31047291:31047507,31047293:31047591,31047294:31047553,31047348:31047673,31047349:31047630,31047350:31047746,31047351:31049394,31047705:31049187,31047706:31049266,31047707:31049307,31047708:31049328,31049377:31049728,31049378:31049775,31049379:31049820,31049380:31049853,31049427:31050059,31050039:31050305,31050040:31050345,31050381:31050543,31050636:31050911,31050890:31051172,31050891:31051206,31051252:31051430,31052875:31053400,31052876:31053453,31052877:3105348', 'assoc_mat': '31044731:autre:4230:31052240,31044732:autre:4230:31052287,31044734:autre:4230:31052330,31044735:autre:4230:31052934,31044736:autre:4230:31052391,31044737:autre:4230:31052428,31044738:autre:4230:31046528,31044739:autre:4230:31046571,31044740:autre:4230:31046612,31044741:autre:4230:31052467,31044742:autre:4230:31052496,31045940:autre:4230:31052547,31045941:autre:4230:31046658,31045942:autre:4230:31052597,31045943:autre:4230:31052627,31045944:autre:4230:31052674,31045945:autre:4230:31052707,31045946:autre:4230:31052755,31045947:autre:4230:31052794,31045948:autre:4230:31046708,31046291:autre:4230:31046739,31046292:autre:4230:31052837,31046306:autre:4230:31047080,31046307:autre:4230:31047125,31046308:autre:4230:31047185,31047210:autre:4230:31049124,31047211:autre:4230:31049152,31047212:autre:4230:31049231,31047213:autre:4230:31047409,31047214:autre:4230:31047436,31047215:autre:4230:31047487,31047291:autre:4230:31047507,31047293:autre:4230:31047591,31047294:autre:4230:31047553,31047348:autre:4230:31047673,31047349:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06661873855710615, 'nb_photo': 19712, 'list_port_cont': '31046534,31046575,31046619,31046656,31046704,31046742,31047091,31047126,31047187,31047406,31047440,31047483,31047522,31047561,31047592,31047633,31047670,31047750,31049120,31049153,31049194,31049233,31049270,31049303,31049345,31049404,31049743,31049772,31049816,31049850,31050048,31050311,31050340,31050546,31050909,31051175,31051218,31051433,31052251,31052282,31052327,31052388,31052429,31052473,31052499,31052554,31052590,31052634,31052668,31052718,31052758,31052797,31052834,31052947,31053411,31053445,31053484,31053519,31054011,31054051,31054090,31054133,31054222,31054473,31054543,31054891,31054930,31055321,31055363,31055424,31055630,31055862,31056040,31056284,31056499,31056741,31056784,31056981,31057197,31057434,31057646,31057992,31058030,31058106,31058460,31058695,31058935,31059299,31059332,31059376,31059833,31059863,31060151,31060192,31060398,31060606,31060829,31061043,31061233,31061511,31061546,31061673,31061907,31062119,31062381,31062766,31062991,31063035,31063227,31063483,31063780,31064108,31064141,3106421', 'assoc_port': '31044731:31052251,31044732:31052282,31044734:31052327,31044735:31052947,31044736:31052388,31044737:31052429,31044738:31046534,31044739:31046575,31044740:31046619,31044741:31052473,31044742:31052499,31045940:31052554,31045941:31046656,31045942:31052590,31045943:31052634,31045944:31052668,31045945:31052718,31045946:31052758,31045947:31052797,31045948:31046704,31046291:31046742,31046292:31052834,31046306:31047091,31046307:31047126,31046308:31047187,31047210:31049120,31047211:31049153,31047212:31049233,31047213:31047406,31047214:31047440,31047215:31047483,31047291:31047522,31047293:31047592,31047294:31047561,31047348:31047670,31047349:31047633,31047350:31047750,31047351:31049404,31047705:31049194,31047706:31049270,31047707:31049303,31047708:31049345,31049377:31049743,31049378:31049772,31049379:31049816,31049380:31049850,31049427:31050048,31050039:31050311,31050040:31050340,31050381:31050546,31050636:31050909,31050890:31051175,31050891:31051218,31051252:31051433,31052875:31053411,31052876:31053445,31052877:3105348', 'assoc_mat': '31044731:carton:4230:31052251,31044732:carton:4230:31052282,31044734:carton:4230:31052327,31044735:carton:4230:31052947,31044736:carton:4230:31052388,31044737:carton:4230:31052429,31044738:carton:4230:31046534,31044739:carton:4230:31046575,31044740:carton:4230:31046619,31044741:carton:4230:31052473,31044742:carton:4230:31052499,31045940:carton:4230:31052554,31045941:carton:4230:31046656,31045942:carton:4230:31052590,31045943:carton:4230:31052634,31045944:carton:4230:31052668,31045945:carton:4230:31052718,31045946:carton:4230:31052758,31045947:carton:4230:31052797,31045948:carton:4230:31046704,31046291:carton:4230:31046742,31046292:carton:4230:31052834,31046306:carton:4230:31047091,31046307:carton:4230:31047126,31046308:carton:4230:31047187,31047210:carton:4230:31049120,31047211:carton:4230:31049153,31047212:carton:4230:31049233,31047213:carton:4230:31047406,31047214:carton:4230:31047440,31047215:carton:4230:31047483,31047291:carton:4230:31047522,31047293:carton:4230:31047592,31047294:carton:4230:31047561,3104'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012706475119804057, 'nb_photo': 287, 'list_port_cont': '31046530,31046570,31046605,31046655,31046694,31046740,31047094,31047136,31047183,31047411,31047449,31047470,31047548,31047585,31047629,31047677,31047741,31049108,31049149,31049197,31049226,31049268,31049293,31049332,31049401,31049737,31049780,31049807,31049840,31050057,31051424,31052248,31052289,31052332,31052379,31052421,31052470,31052552,31052592,31052625,31052667,31052715,31052750,31052784,31052828,31052950,31053439,31054003,31054055,31054079,31054120,31054471,31054875,31055308,31055349,31055434,31055622,31056048,31056291,31056781,31056973,31057185,31057447,31057647,31057978,31058930,31059326,31060200,31060619,31060831,31061503,31061676,31062382,31063037,31063771,31064435,31064680,31065179,31065515,31066139,31066833,31066879,31067317,31068099,31068142,31069001,31069534,31070735,31071844,31071938,31072213,31072415,31072647,31073881,31073909,31074453,31074887,31075163,31077533,31077828,31078125,31078751,31079015,31079364,31080001,31080301,31080567,31080595,31080842,31081051,31081333,31081508', 'assoc_port': '31044731:31052248,31044732:31052289,31044734:31052332,31044735:31052950,31044736:31052379,31044737:31052421,31044738:31046530,31044739:31046570,31044740:31046605,31044741:31052470,31045940:31052552,31045941:31046655,31045942:31052592,31045943:31052625,31045944:31052667,31045945:31052715,31045946:31052750,31045947:31052784,31045948:31046694,31046291:31046740,31046292:31052828,31046306:31047094,31046307:31047136,31046308:31047183,31047210:31049108,31047211:31049149,31047212:31049226,31047213:31047411,31047214:31047449,31047215:31047470,31047293:31047585,31047294:31047548,31047348:31047677,31047349:31047629,31047350:31047741,31047351:31049401,31047705:31049197,31047706:31049268,31047707:31049293,31047708:31049332,31049377:31049737,31049378:31049780,31049379:31049807,31049380:31049840,31049427:31050057,31051252:31051424,31052876:31053439,31053562:31054003,31053563:31054055,31053564:31054079,31053565:31054120,31054248:31054471,31054574:31054875,31054993:31055308,31054994:31055349,31054995:31055434,31055403:3105562', 'assoc_mat': '31044731:metal:4230:31052248,31044732:metal:4230:31052289,31044734:metal:4230:31052332,31044735:metal:4230:31052950,31044736:metal:4230:31052379,31044737:metal:4230:31052421,31044738:metal:4230:31046530,31044739:metal:4230:31046570,31044740:metal:4230:31046605,31044741:metal:4230:31052470,31045940:metal:4230:31052552,31045941:metal:4230:31046655,31045942:metal:4230:31052592,31045943:metal:4230:31052625,31045944:metal:4230:31052667,31045945:metal:4230:31052715,31045946:metal:4230:31052750,31045947:metal:4230:31052784,31045948:metal:4230:31046694,31046291:metal:4230:31046740,31046292:metal:4230:31052828,31046306:metal:4230:31047094,31046307:metal:4230:31047136,31046308:metal:4230:31047183,31047210:metal:4230:31049108,31047211:metal:4230:31049149,31047212:metal:4230:31049226,31047213:metal:4230:31047411,31047214:metal:4230:31047449,31047215:metal:4230:31047470,31047293:metal:4230:31047585,31047294:metal:4230:31047548,31047348:metal:4230:31047677,31047349:metal:4230:31047629,31047350:metal:4230:31047741,31047351:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.22683539653359125, 'nb_photo': 80493, 'list_port_cont': '31046540,31046580,31046610,31046657,31046710,31046746,31047089,31047133,31047186,31047404,31047445,31047476,31047517,31047554,31047594,31047636,31047671,31047747,31049123,31049157,31049186,31049228,31049256,31049296,31049336,31049389,31049739,31049776,31049810,31049856,31050058,31050317,31050348,31050537,31050908,31051183,31051211,31051431,31052254,31052291,31052326,31052387,31052433,31052474,31052510,31052548,31052593,31052626,31052673,31052713,31052748,31052799,31052840,31052944,31053408,31053452,31053480,31053528,31054001,31054044,31054091,31054130,31054223,31054478,31054538,31054890,31054919,31055322,31055362,31055419,31055633,31055854,31056037,31056299,31056507,31056743,31056775,31056974,31057195,31057441,31057642,31057985,31058027,31058105,31058455,31058692,31058943,31059301,31059328,31059373,31059823,31059866,31060148,31060201,31060409,31060617,31060821,31061047,31061235,31061513,31061550,31061669,31061910,31062122,31062384,31062770,31062989,31063040,31063224,31063487,31063772,31064098,31064140,3106421', 'assoc_port': '31044731:31052254,31044732:31052291,31044734:31052326,31044735:31052944,31044736:31052387,31044737:31052433,31044738:31046540,31044739:31046580,31044740:31046610,31044741:31052474,31044742:31052510,31045940:31052548,31045941:31046657,31045942:31052593,31045943:31052626,31045944:31052673,31045945:31052713,31045946:31052748,31045947:31052799,31045948:31046710,31046291:31046746,31046292:31052840,31046306:31047089,31046307:31047133,31046308:31047186,31047210:31049123,31047211:31049157,31047212:31049228,31047213:31047404,31047214:31047445,31047215:31047476,31047291:31047517,31047293:31047594,31047294:31047554,31047348:31047671,31047349:31047636,31047350:31047747,31047351:31049389,31047705:31049186,31047706:31049256,31047707:31049296,31047708:31049336,31049377:31049739,31049378:31049776,31049379:31049810,31049380:31049856,31049427:31050058,31050039:31050317,31050040:31050348,31050381:31050537,31050636:31050908,31050890:31051183,31050891:31051211,31051252:31051431,31052875:31053408,31052876:31053452,31052877:3105348', 'assoc_mat': '31044731:papier:4230:31052254,31044732:papier:4230:31052291,31044734:papier:4230:31052326,31044735:papier:4230:31052944,31044736:papier:4230:31052387,31044737:papier:4230:31052433,31044738:papier:4230:31046540,31044739:papier:4230:31046580,31044740:papier:4230:31046610,31044741:papier:4230:31052474,31044742:papier:4230:31052510,31045940:papier:4230:31052548,31045941:papier:4230:31046657,31045942:papier:4230:31052593,31045943:papier:4230:31052626,31045944:papier:4230:31052673,31045945:papier:4230:31052713,31045946:papier:4230:31052748,31045947:papier:4230:31052799,31045948:papier:4230:31046710,31046291:papier:4230:31046746,31046292:papier:4230:31052840,31046306:papier:4230:31047089,31046307:papier:4230:31047133,31046308:papier:4230:31047186,31047210:papier:4230:31049123,31047211:papier:4230:31049157,31047212:papier:4230:31049228,31047213:papier:4230:31047404,31047214:papier:4230:31047445,31047215:papier:4230:31047476,31047291:papier:4230:31047517,31047293:papier:4230:31047594,31047294:papier:4230:31047554,3104'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004675927196879726, 'nb_photo': 554, 'list_port_cont': '31046537,31046582,31046609,31046651,31046698,31046748,31047134,31047184,31047407,31047448,31047482,31047511,31047551,31047589,31047634,31047675,31047743,31049122,31049161,31049195,31049232,31049263,31049300,31049342,31049403,31049738,31049784,31049808,31049855,31050060,31050308,31050547,31050902,31051181,31051212,31052242,31052293,31052331,31052382,31052434,31052463,31052506,31052553,31052595,31052635,31052669,31052721,31052751,31052795,31052838,31052948,31053409,31053448,31053527,31054050,31054479,31057191,31057446,31057645,31057990,31058018,31058098,31058454,31058700,31058941,31059293,31059338,31060407,31060608,31060828,31061045,31061239,31061560,31063238,31063777,31064213,31064679,31064796,31065142,31065184,31065511,31065684,31069007,31070816,31071927,31072656,31076257,31076529,31076726,31076837,31077089,31077522,31077784,31077836,31078105,31078140,31078329,31078562,31078747,31078979,31079026,31079375,31079573,31079728,31080312,31081046,31081332', 'assoc_port': '31044731:31052242,31044732:31052293,31044734:31052331,31044735:31052948,31044736:31052382,31044737:31052434,31044738:31046537,31044739:31046582,31044740:31046609,31044741:31052463,31044742:31052506,31045940:31052553,31045941:31046651,31045942:31052595,31045943:31052635,31045944:31052669,31045945:31052721,31045946:31052751,31045947:31052795,31045948:31046698,31046291:31046748,31046292:31052838,31046307:31047134,31046308:31047184,31047210:31049122,31047211:31049161,31047212:31049232,31047213:31047407,31047214:31047448,31047215:31047482,31047291:31047511,31047293:31047589,31047294:31047551,31047348:31047675,31047349:31047634,31047350:31047743,31047351:31049403,31047705:31049195,31047706:31049263,31047707:31049300,31047708:31049342,31049377:31049738,31049378:31049784,31049379:31049808,31049380:31049855,31049427:31050060,31050039:31050308,31050381:31050547,31050636:31050902,31050890:31051181,31050891:31051212,31052875:31053409,31052876:31053448,31052879:31053527,31053563:31054050,31054248:31054479,31057014:3105719', 'assoc_mat': '31044731:pehd:4230:31052242,31044732:pehd:4230:31052293,31044734:pehd:4230:31052331,31044735:pehd:4230:31052948,31044736:pehd:4230:31052382,31044737:pehd:4230:31052434,31044738:pehd:4230:31046537,31044739:pehd:4230:31046582,31044740:pehd:4230:31046609,31044741:pehd:4230:31052463,31044742:pehd:4230:31052506,31045940:pehd:4230:31052553,31045941:pehd:4230:31046651,31045942:pehd:4230:31052595,31045943:pehd:4230:31052635,31045944:pehd:4230:31052669,31045945:pehd:4230:31052721,31045946:pehd:4230:31052751,31045947:pehd:4230:31052795,31045948:pehd:4230:31046698,31046291:pehd:4230:31046748,31046292:pehd:4230:31052838,31046307:pehd:4230:31047134,31046308:pehd:4230:31047184,31047210:pehd:4230:31049122,31047211:pehd:4230:31049161,31047212:pehd:4230:31049232,31047213:pehd:4230:31047407,31047214:pehd:4230:31047448,31047215:pehd:4230:31047482,31047291:pehd:4230:31047511,31047293:pehd:4230:31047589,31047294:pehd:4230:31047551,31047348:pehd:4230:31047675,31047349:pehd:4230:31047634,31047350:pehd:4230:31047743,31047351:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013580600474853571, 'nb_photo': 4479, 'list_port_cont': '31046535,31046581,31046621,31046659,31046706,31046747,31047081,31047135,31047180,31047402,31047442,31047475,31047512,31047556,31047597,31047623,31047676,31047738,31049121,31049158,31049185,31049230,31049264,31049308,31049340,31049400,31049732,31049782,31049819,31049854,31050056,31050316,31050354,31050539,31050912,31051184,31051214,31051422,31052252,31052292,31052333,31052390,31052432,31052471,31052502,31052543,31052589,31052633,31052676,31052720,31052752,31052796,31052832,31052941,31053403,31053447,31053485,31053525,31054012,31054056,31054095,31054123,31054227,31054480,31054537,31054885,31054927,31055316,31055357,31055430,31055637,31055856,31056047,31056296,31056505,31056749,31056786,31056985,31057188,31057437,31057644,31057991,31058024,31058103,31058458,31058698,31058946,31059298,31059341,31059374,31059824,31059865,31060144,31060197,31060408,31060613,31060819,31061049,31061227,31061505,31061552,31061672,31061903,31062121,31062371,31062771,31062994,31063034,31063237,31063486,31063774,31064103,31064142,3106422', 'assoc_port': '31044731:31052252,31044732:31052292,31044734:31052333,31044735:31052941,31044736:31052390,31044737:31052432,31044738:31046535,31044739:31046581,31044740:31046621,31044741:31052471,31044742:31052502,31045940:31052543,31045941:31046659,31045942:31052589,31045943:31052633,31045944:31052676,31045945:31052720,31045946:31052752,31045947:31052796,31045948:31046706,31046291:31046747,31046292:31052832,31046306:31047081,31046307:31047135,31046308:31047180,31047210:31049121,31047211:31049158,31047212:31049230,31047213:31047402,31047214:31047442,31047215:31047475,31047291:31047512,31047293:31047597,31047294:31047556,31047348:31047676,31047349:31047623,31047350:31047738,31047351:31049400,31047705:31049185,31047706:31049264,31047707:31049308,31047708:31049340,31049377:31049732,31049378:31049782,31049379:31049819,31049380:31049854,31049427:31050056,31050039:31050316,31050040:31050354,31050381:31050539,31050636:31050912,31050890:31051184,31050891:31051214,31051252:31051422,31052875:31053403,31052876:31053447,31052877:3105348', 'assoc_mat': '31044731:pet_clair:4230:31052252,31044732:pet_clair:4230:31052292,31044734:pet_clair:4230:31052333,31044735:pet_clair:4230:31052941,31044736:pet_clair:4230:31052390,31044737:pet_clair:4230:31052432,31044738:pet_clair:4230:31046535,31044739:pet_clair:4230:31046581,31044740:pet_clair:4230:31046621,31044741:pet_clair:4230:31052471,31044742:pet_clair:4230:31052502,31045940:pet_clair:4230:31052543,31045941:pet_clair:4230:31046659,31045942:pet_clair:4230:31052589,31045943:pet_clair:4230:31052633,31045944:pet_clair:4230:31052676,31045945:pet_clair:4230:31052720,31045946:pet_clair:4230:31052752,31045947:pet_clair:4230:31052796,31045948:pet_clair:4230:31046706,31046291:pet_clair:4230:31046747,31046292:pet_clair:4230:31052832,31046306:pet_clair:4230:31047081,31046307:pet_clair:4230:31047135,31046308:pet_clair:4230:31047180,31047210:pet_clair:4230:31049121,31047211:pet_clair:4230:31049158,31047212:pet_clair:4230:31049230,31047213:pet_clair:4230:31047402,31047214:pet_clair:4230:31047442,31047215:pet_clair:4230:31047475,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0026920165485080504, 'nb_photo': 187, 'list_port_cont': '31046579,31046611,31046699,31046744,31047092,31047127,31047178,31047401,31047447,31047485,31047513,31047587,31047748,31049114,31049156,31049225,31049341,31049398,31049742,31049783,31050353,31051208,31051429,31052280,31052329,31052389,31052419,31052475,31052546,31052591,31052670,31052719,31052757,31052801,31052951,31053522,31055355,31056289,31056752,31057443,31057640,31058450,31060830,31061050,31061509,31061554,31061674,31061913,31062112,31062380,31062768,31063474,31063781,31064137,31064222,31064437,31064671,31064790,31065149,31065478,31065743,31068153,31068816,31070530,31071256,31072206,31072423,31072654,31072829,31073661,31073879,31074895,31076267,31076727,31077080,31077531,31077792,31077842,31078101,31078141,31078327,31078561,31078754,31078987,31079014,31079378,31079572,31080005,31080307,31080605,31080845,31081050,31081336,31081522', 'assoc_port': '31044732:31052280,31044734:31052329,31044735:31052951,31044736:31052389,31044737:31052419,31044739:31046579,31044740:31046611,31044741:31052475,31045940:31052546,31045942:31052591,31045944:31052670,31045945:31052719,31045946:31052757,31045947:31052801,31045948:31046699,31046291:31046744,31046306:31047092,31046307:31047127,31046308:31047178,31047210:31049114,31047211:31049156,31047212:31049225,31047213:31047401,31047214:31047447,31047215:31047485,31047291:31047513,31047293:31047587,31047350:31047748,31047351:31049398,31047708:31049341,31049377:31049742,31049378:31049783,31050040:31050353,31050891:31051208,31051252:31051429,31052879:31053522,31054994:31055355,31056026:31056289,31056480:31056752,31057179:31057443,31057424:31057640,31058228:31058450,31060648:31060830,31060810:31061050,31061216:31061509,31061217:31061554,31061539:31061674,31061738:31061913,31061985:31062112,31062187:31062380,31062451:31062768,31063270:31063474,31063561:31063781,31063806:31064137,31063807:31064222,31064286:31064437,31064415:3106467', 'assoc_mat': '31044732:pet_fonce:4230:31052280,31044734:pet_fonce:4230:31052329,31044735:pet_fonce:4230:31052951,31044736:pet_fonce:4230:31052389,31044737:pet_fonce:4230:31052419,31044739:pet_fonce:4230:31046579,31044740:pet_fonce:4230:31046611,31044741:pet_fonce:4230:31052475,31045940:pet_fonce:4230:31052546,31045942:pet_fonce:4230:31052591,31045944:pet_fonce:4230:31052670,31045945:pet_fonce:4230:31052719,31045946:pet_fonce:4230:31052757,31045947:pet_fonce:4230:31052801,31045948:pet_fonce:4230:31046699,31046291:pet_fonce:4230:31046744,31046306:pet_fonce:4230:31047092,31046307:pet_fonce:4230:31047127,31046308:pet_fonce:4230:31047178,31047210:pet_fonce:4230:31049114,31047211:pet_fonce:4230:31049156,31047212:pet_fonce:4230:31049225,31047213:pet_fonce:4230:31047401,31047214:pet_fonce:4230:31047447,31047215:pet_fonce:4230:31047485,31047291:pet_fonce:4230:31047513,31047293:pet_fonce:4230:31047587,31047350:pet_fonce:4230:31047748,31047351:pet_fonce:4230:31049398,31047708:pet_fonce:4230:31049341,31049377:pet_fonce:4230:31049742,3'}), 'main_stat': {'nb_photos': 454}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31081570,31081571,31081572,31081573,31081574,31081575,31081576?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-05', 0.747684689760811),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_05_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '0.91%', 3041], 'carton': ['carton', '6.66%', 19712], 'metal': ['metal', '0.13%', 287], 'papier': ['papier', '22.68%', 80493], 'pehd': ['pehd', '0.47%', 554], 'pet_clair': ['pet_clair', '1.36%', 4479], 'pet_fonce': ['pet_fonce', '0.27%', 187]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_05_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.19user 2.74system 0:05.88elapsed 83%CPU (0avgtext+0avgdata 187220maxresident)k 8inputs+280outputs (5major+48912minor)pagefaults 0swaps