python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-08 _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 : (5, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (5, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 08 mtr_id : dashboard_places : SCCU_cam7 date : 2026-08 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam7' and date like '%2026-08%') and created_at like '%2026-08%'))); nb_day : (5, 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 = 204 and month(ded.date) = 08 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 08 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 204 and mp.name like '%082026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-08-01 : dt_date_just_month_year : 2026-08-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-08-01" AND ded.date <= "2026-08-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 (2987114,2987344,2987534,2988216,2988688,2989190,2989718,2990226,2990720,2991232,2991762,2992358,2993106) 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.009065779348952441, 'nb_photo': 1543, 'list_port_cont': '31046935,31046972,31047019,31047041,31047082,31047115,31047160,31047382,31047518,31047685,31047820,31048209,31048246,31048404,31048823,31048866,31049779,31049986,31050276,31050490,31050855,31051123,31051250,31051499,31051724,31051921,31051962,31052240,31052563,31052773,31052977,31053205,31053488,31053688,31053861,31054163,31054448,31054686,31054969,31055225,31055516,31055707,31055907,31056139,31056445,31056702,31056817,31057117,31057359,31057578,31057618,31057914,31058126,31058407,31058582,31058872,31059116,31059344,31059576,31059806,31060055,31060293,31060609,31060803,31061043,31061238,31061491,31061779,31062036,31062165,31062361,31062652,31062883,31063128,31063158,31063783,31064209,31064459,31064837,31065078,31065376,31065592,31065920,31066125,31066333,31066580,31066772,31067197,31067309,31067489,31067672,31068173,31069074,31069389,31069654,31069819,31070234,31070561,31070746,31071033,31071372,31071415,31071631,31071839,31072044,31072260,31072498,31072701,31072918,31073214,31075028,31075157,31075528,3107578', 'assoc_port': '31045064:31046972,31045065:31046935,31045066:31047041,31045067:31047019,31045068:31047082,31045069:31047115,31045070:31047160,31047221:31047382,31047411:31047518,31047563:31047685,31047764:31047820,31048153:31048246,31048154:31048209,31048361:31048404,31048780:31048823,31048781:31048866,31049690:31049779,31049896:31049986,31050101:31050276,31050349:31050490,31050595:31050855,31050889:31051123,31051161:31051250,31051369:31051499,31051619:31051724,31051831:31051921,31051832:31051962,31052141:31052240,31052386:31052563,31052637:31052773,31052881:31052977,31053093:31053205,31053354:31053488,31053637:31053688,31053845:31053861,31054024:31054163,31054317:31054448,31054570:31054686,31054830:31054969,31055090:31055225,31055336:31055516,31055582:31055707,31055822:31055907,31056061:31056139,31056321:31056445,31056564:31056702,31056806:31056817,31057014:31057117,31057266:31057359,31057481:31057618,31057482:31057578,31057787:31057914,31058031:31058126,31058277:31058407,31058525:31058582,31058771:31058872,31058993:3105911', 'assoc_mat': '31045064:autre:4230:31046972,31045065:autre:4230:31046935,31045066:autre:4230:31047041,31045067:autre:4230:31047019,31045068:autre:4230:31047082,31045069:autre:4230:31047115,31045070:autre:4230:31047160,31047221:autre:4230:31047382,31047411:autre:4230:31047518,31047563:autre:4230:31047685,31047764:autre:4230:31047820,31048153:autre:4230:31048246,31048154:autre:4230:31048209,31048361:autre:4230:31048404,31048780:autre:4230:31048823,31048781:autre:4230:31048866,31049690:autre:4230:31049779,31049896:autre:4230:31049986,31050101:autre:4230:31050276,31050349:autre:4230:31050490,31050595:autre:4230:31050855,31050889:autre:4230:31051123,31051161:autre:4230:31051250,31051369:autre:4230:31051499,31051619:autre:4230:31051724,31051831:autre:4230:31051921,31051832:autre:4230:31051962,31052141:autre:4230:31052240,31052386:autre:4230:31052563,31052637:autre:4230:31052773,31052881:autre:4230:31052977,31053093:autre:4230:31053205,31053354:autre:4230:31053488,31053637:autre:4230:31053688,31053845:autre:4230:31053861,31054024:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.022152304656919145, 'nb_photo': 4813, 'list_port_cont': '31046945,31046981,31047018,31047054,31047088,31047124,31047163,31047386,31047522,31047700,31047821,31048220,31048258,31048405,31048832,31048870,31049781,31049994,31050283,31050492,31050847,31051131,31051263,31051500,31051725,31051929,31051963,31052235,31052559,31052769,31052986,31053209,31053490,31053698,31053875,31054166,31054459,31054677,31054981,31055234,31055515,31055721,31055914,31056142,31056449,31056700,31056830,31057111,31057356,31057572,31057621,31057920,31058134,31058415,31058584,31058882,31059130,31059345,31059590,31059812,31060062,31060290,31060605,31060798,31061048,31061255,31061500,31061794,31062037,31062158,31062365,31062643,31062890,31063129,31063166,31063566,31063607,31063797,31064036,31064217,31064454,31064835,31065093,31065372,31065601,31065916,31066115,31066326,31066583,31066782,31067204,31067322,31067491,31067684,31070230,31070572,31070745,31071041,31071382,31071416,31071629,31071837,31072047,31072266,31072509,31072714,31072922,31073215,31074410,31075170,31075543,31075785,31076003,3107625', 'assoc_port': '31045064:31046981,31045065:31046945,31045066:31047054,31045067:31047018,31045068:31047088,31045069:31047124,31045070:31047163,31047221:31047386,31047411:31047522,31047563:31047700,31047764:31047821,31048153:31048258,31048154:31048220,31048361:31048405,31048780:31048832,31048781:31048870,31049690:31049781,31049896:31049994,31050101:31050283,31050349:31050492,31050595:31050847,31050889:31051131,31051161:31051263,31051369:31051500,31051619:31051725,31051831:31051929,31051832:31051963,31052141:31052235,31052386:31052559,31052637:31052769,31052881:31052986,31053093:31053209,31053354:31053490,31053637:31053698,31053845:31053875,31054024:31054166,31054317:31054459,31054570:31054677,31054830:31054981,31055090:31055234,31055336:31055515,31055582:31055721,31055822:31055914,31056061:31056142,31056321:31056449,31056564:31056700,31056806:31056830,31057014:31057111,31057266:31057356,31057481:31057621,31057482:31057572,31057787:31057920,31058031:31058134,31058277:31058415,31058525:31058584,31058771:31058882,31058993:3105913', 'assoc_mat': '31045064:carton:4230:31046981,31045065:carton:4230:31046945,31045066:carton:4230:31047054,31045067:carton:4230:31047018,31045068:carton:4230:31047088,31045069:carton:4230:31047124,31045070:carton:4230:31047163,31047221:carton:4230:31047386,31047411:carton:4230:31047522,31047563:carton:4230:31047700,31047764:carton:4230:31047821,31048153:carton:4230:31048258,31048154:carton:4230:31048220,31048361:carton:4230:31048405,31048780:carton:4230:31048832,31048781:carton:4230:31048870,31049690:carton:4230:31049781,31049896:carton:4230:31049994,31050101:carton:4230:31050283,31050349:carton:4230:31050492,31050595:carton:4230:31050847,31050889:carton:4230:31051131,31051161:carton:4230:31051263,31051369:carton:4230:31051500,31051619:carton:4230:31051725,31051831:carton:4230:31051929,31051832:carton:4230:31051963,31052141:carton:4230:31052235,31052386:carton:4230:31052559,31052637:carton:4230:31052769,31052881:carton:4230:31052986,31053093:carton:4230:31053209,31053354:carton:4230:31053490,31053637:carton:4230:31053698,3105'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.000575015460073561, 'nb_photo': 66, 'list_port_cont': '31046932,31046969,31047004,31047079,31047122,31047381,31048222,31048252,31050272,31050488,31050858,31051130,31051247,31051511,31051713,31051964,31052242,31052554,31052777,31052972,31053193,31054167,31054453,31054979,31055719,31056125,31056460,31056701,31061038,31061243,31061501,31061787,31062024,31071371,31076671,31080405,31082662,31089926,31098683,31098885', 'assoc_port': '31045064:31046969,31045065:31046932,31045067:31047004,31045068:31047079,31045069:31047122,31047221:31047381,31048153:31048252,31048154:31048222,31050101:31050272,31050349:31050488,31050595:31050858,31050889:31051130,31051161:31051247,31051369:31051511,31051619:31051713,31051832:31051964,31052141:31052242,31052386:31052554,31052637:31052777,31052881:31052972,31053093:31053193,31054024:31054167,31054317:31054453,31054830:31054979,31055582:31055719,31056061:31056125,31056321:31056460,31056564:31056701,31060952:31061038,31061195:31061243,31061404:31061501,31061645:31061787,31061901:31062024,31071324:31071371,31076569:31076671,31080311:31080405,31082601:31082662,31089899:31089926,31098522:31098683,31098761:31098885', 'assoc_mat': '31045064:metal:4230:31046969,31045065:metal:4230:31046932,31045067:metal:4230:31047004,31045068:metal:4230:31047079,31045069:metal:4230:31047122,31047221:metal:4230:31047381,31048153:metal:4230:31048252,31048154:metal:4230:31048222,31050101:metal:4230:31050272,31050349:metal:4230:31050488,31050595:metal:4230:31050858,31050889:metal:4230:31051130,31051161:metal:4230:31051247,31051369:metal:4230:31051511,31051619:metal:4230:31051713,31051832:metal:4230:31051964,31052141:metal:4230:31052242,31052386:metal:4230:31052554,31052637:metal:4230:31052777,31052881:metal:4230:31052972,31053093:metal:4230:31053193,31054024:metal:4230:31054167,31054317:metal:4230:31054453,31054830:metal:4230:31054979,31055582:metal:4230:31055719,31056061:metal:4230:31056125,31056321:metal:4230:31056460,31056564:metal:4230:31056701,31060952:metal:4230:31061038,31061195:metal:4230:31061243,31061404:metal:4230:31061501,31061645:metal:4230:31061787,31061901:metal:4230:31062024,31071324:metal:4230:31071371,31076569:metal:4230:31076671,31080311:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.12943859176534755, 'nb_photo': 22986, 'list_port_cont': '31046943,31046978,31047012,31047050,31047091,31047126,31047158,31047385,31047526,31047699,31047819,31048213,31048253,31048411,31048834,31048872,31049788,31049997,31050274,31050493,31050851,31051134,31051259,31051512,31051722,31051930,31051971,31052241,31052555,31052770,31052978,31053199,31053494,31053700,31053877,31054159,31054456,31054687,31054983,31055230,31055512,31055718,31055919,31056138,31056459,31056691,31056831,31057118,31057363,31057585,31057620,31057917,31058133,31058401,31058586,31058879,31059125,31059346,31059589,31059811,31060068,31060295,31060598,31060814,31061053,31061254,31061498,31061792,31062031,31062154,31062373,31062649,31062888,31063120,31063167,31063569,31063606,31063791,31064038,31064221,31064457,31064838,31065084,31065377,31065608,31065914,31066124,31066327,31066582,31066781,31067208,31067310,31067482,31067677,31067972,31070225,31070571,31070749,31071043,31071384,31071422,31071624,31071844,31072046,31072262,31072505,31072709,31072915,31073209,31073415,31073694,31073731,31074130,3107417', 'assoc_port': '31045064:31046978,31045065:31046943,31045066:31047050,31045067:31047012,31045068:31047091,31045069:31047126,31045070:31047158,31047221:31047385,31047411:31047526,31047563:31047699,31047764:31047819,31048153:31048253,31048154:31048213,31048361:31048411,31048780:31048834,31048781:31048872,31049690:31049788,31049896:31049997,31050101:31050274,31050349:31050493,31050595:31050851,31050889:31051134,31051161:31051259,31051369:31051512,31051619:31051722,31051831:31051930,31051832:31051971,31052141:31052241,31052386:31052555,31052637:31052770,31052881:31052978,31053093:31053199,31053354:31053494,31053637:31053700,31053845:31053877,31054024:31054159,31054317:31054456,31054570:31054687,31054830:31054983,31055090:31055230,31055336:31055512,31055582:31055718,31055822:31055919,31056061:31056138,31056321:31056459,31056564:31056691,31056806:31056831,31057014:31057118,31057266:31057363,31057481:31057620,31057482:31057585,31057787:31057917,31058031:31058133,31058277:31058401,31058525:31058586,31058771:31058879,31058993:3105912', 'assoc_mat': '31045064:papier:4230:31046978,31045065:papier:4230:31046943,31045066:papier:4230:31047050,31045067:papier:4230:31047012,31045068:papier:4230:31047091,31045069:papier:4230:31047126,31045070:papier:4230:31047158,31047221:papier:4230:31047385,31047411:papier:4230:31047526,31047563:papier:4230:31047699,31047764:papier:4230:31047819,31048153:papier:4230:31048253,31048154:papier:4230:31048213,31048361:papier:4230:31048411,31048780:papier:4230:31048834,31048781:papier:4230:31048872,31049690:papier:4230:31049788,31049896:papier:4230:31049997,31050101:papier:4230:31050274,31050349:papier:4230:31050493,31050595:papier:4230:31050851,31050889:papier:4230:31051134,31051161:papier:4230:31051259,31051369:papier:4230:31051512,31051619:papier:4230:31051722,31051831:papier:4230:31051930,31051832:papier:4230:31051971,31052141:papier:4230:31052241,31052386:papier:4230:31052555,31052637:papier:4230:31052770,31052881:papier:4230:31052978,31053093:papier:4230:31053199,31053354:papier:4230:31053494,31053637:papier:4230:31053700,3105'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017128752535139214, 'nb_photo': 144, 'list_port_cont': '31046982,31047017,31047053,31047085,31047116,31047148,31047389,31047525,31047817,31048219,31049995,31050281,31050494,31050852,31051135,31051262,31051509,31051927,31052776,31054682,31054977,31055233,31055709,31056458,31056822,31057116,31057623,31058402,31059127,31059337,31059592,31059809,31060287,31060610,31061049,31061793,31066121,31067490,31071625,31071832,31072716,31072924,31076004,31076415,31076840,31077118,31077329,31077576,31081238,31081441,31082420,31082676,31083085,31085827,31086079,31086297,31086548,31086788,31087079,31087305,31087426,31087656,31087926,31088146,31088342,31091127,31091656,31091870,31092311,31092758,31092997,31093245,31093516,31096669,31096888,31097310,31097678,31097866,31098173,31098901', 'assoc_port': '31045064:31046982,31045066:31047053,31045067:31047017,31045068:31047085,31045069:31047116,31045070:31047148,31047221:31047389,31047411:31047525,31047764:31047817,31048154:31048219,31049896:31049995,31050101:31050281,31050349:31050494,31050595:31050852,31050889:31051135,31051161:31051262,31051369:31051509,31051831:31051927,31052637:31052776,31054570:31054682,31054830:31054977,31055090:31055233,31055582:31055709,31056321:31056458,31056806:31056822,31057014:31057116,31057481:31057623,31058277:31058402,31058993:31059127,31059241:31059337,31059487:31059592,31059702:31059809,31060218:31060287,31060475:31060610,31060952:31061049,31061645:31061793,31066058:31066121,31067426:31067490,31071531:31071625,31071776:31071832,31072690:31072716,31072862:31072924,31075971:31076004,31076396:31076415,31076813:31076840,31077024:31077118,31077260:31077329,31077517:31077576,31081206:31081238,31081381:31081441,31082359:31082420,31082601:31082676,31083018:31083085,31085732:31085827,31085975:31086079,31086223:31086297,31086481:3108654', 'assoc_mat': '31045064:pehd:4230:31046982,31045066:pehd:4230:31047053,31045067:pehd:4230:31047017,31045068:pehd:4230:31047085,31045069:pehd:4230:31047116,31045070:pehd:4230:31047148,31047221:pehd:4230:31047389,31047411:pehd:4230:31047525,31047764:pehd:4230:31047817,31048154:pehd:4230:31048219,31049896:pehd:4230:31049995,31050101:pehd:4230:31050281,31050349:pehd:4230:31050494,31050595:pehd:4230:31050852,31050889:pehd:4230:31051135,31051161:pehd:4230:31051262,31051369:pehd:4230:31051509,31051831:pehd:4230:31051927,31052637:pehd:4230:31052776,31054570:pehd:4230:31054682,31054830:pehd:4230:31054977,31055090:pehd:4230:31055233,31055582:pehd:4230:31055709,31056321:pehd:4230:31056458,31056806:pehd:4230:31056822,31057014:pehd:4230:31057116,31057481:pehd:4230:31057623,31058277:pehd:4230:31058402,31058993:pehd:4230:31059127,31059241:pehd:4230:31059337,31059487:pehd:4230:31059592,31059702:pehd:4230:31059809,31060218:pehd:4230:31060287,31060475:pehd:4230:31060610,31060952:pehd:4230:31061049,31061645:pehd:4230:31061793,31066058:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017688344174203955, 'nb_photo': 1878, 'list_port_cont': '31046946,31046980,31047014,31047048,31047083,31047119,31047161,31047379,31047523,31047702,31047813,31048224,31048260,31048410,31048831,31048871,31049784,31049998,31050282,31050485,31050856,31051128,31051256,31051507,31051709,31051928,31051967,31052238,31052556,31052772,31052981,31053208,31053496,31053689,31053876,31054164,31054458,31054683,31054982,31055223,31055513,31055713,31055912,31056137,31056454,31056694,31056827,31057110,31057366,31057581,31057622,31058131,31058583,31058870,31059131,31059334,31059581,31059810,31060064,31060284,31060611,31060800,31061055,31061249,31061502,31061796,31062040,31062162,31062369,31062640,31065380,31065924,31066118,31066324,31066572,31066776,31067212,31067311,31067486,31071386,31071420,31071622,31071841,31072041,31072267,31072511,31072706,31075796,31076002,31076253,31076410,31076672,31076838,31077119,31077327,31077853,31081237,31081438,31081689,31082009,31082172,31082410,31082669,31082909,31083082,31083292,31083534,31085551,31085829,31086075,31086292,31086547,31086783,3108708', 'assoc_port': '31045064:31046980,31045065:31046946,31045066:31047048,31045067:31047014,31045068:31047083,31045069:31047119,31045070:31047161,31047221:31047379,31047411:31047523,31047563:31047702,31047764:31047813,31048153:31048260,31048154:31048224,31048361:31048410,31048780:31048831,31048781:31048871,31049690:31049784,31049896:31049998,31050101:31050282,31050349:31050485,31050595:31050856,31050889:31051128,31051161:31051256,31051369:31051507,31051619:31051709,31051831:31051928,31051832:31051967,31052141:31052238,31052386:31052556,31052637:31052772,31052881:31052981,31053093:31053208,31053354:31053496,31053637:31053689,31053845:31053876,31054024:31054164,31054317:31054458,31054570:31054683,31054830:31054982,31055090:31055223,31055336:31055513,31055582:31055713,31055822:31055912,31056061:31056137,31056321:31056454,31056564:31056694,31056806:31056827,31057014:31057110,31057266:31057366,31057481:31057622,31057482:31057581,31058031:31058131,31058525:31058583,31058771:31058870,31058993:31059131,31059241:31059334,31059487:3105958', 'assoc_mat': '31045064:pet_clair:4230:31046980,31045065:pet_clair:4230:31046946,31045066:pet_clair:4230:31047048,31045067:pet_clair:4230:31047014,31045068:pet_clair:4230:31047083,31045069:pet_clair:4230:31047119,31045070:pet_clair:4230:31047161,31047221:pet_clair:4230:31047379,31047411:pet_clair:4230:31047523,31047563:pet_clair:4230:31047702,31047764:pet_clair:4230:31047813,31048153:pet_clair:4230:31048260,31048154:pet_clair:4230:31048224,31048361:pet_clair:4230:31048410,31048780:pet_clair:4230:31048831,31048781:pet_clair:4230:31048871,31049690:pet_clair:4230:31049784,31049896:pet_clair:4230:31049998,31050101:pet_clair:4230:31050282,31050349:pet_clair:4230:31050485,31050595:pet_clair:4230:31050856,31050889:pet_clair:4230:31051128,31051161:pet_clair:4230:31051256,31051369:pet_clair:4230:31051507,31051619:pet_clair:4230:31051709,31051831:pet_clair:4230:31051928,31051832:pet_clair:4230:31051967,31052141:pet_clair:4230:31052238,31052386:pet_clair:4230:31052556,31052637:pet_clair:4230:31052772,31052881:pet_clair:4230:31052981,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018814295852732114, 'nb_photo': 81, 'list_port_cont': '31046934,31046979,31047156,31048248,31050277,31050496,31050857,31051138,31051258,31051934,31052771,31053489,31053702,31054450,31054684,31056451,31056687,31056828,31059799,31060071,31060603,31060805,31061046,31061245,31066574,31075787,31076416,31076666,31076833,31082010,31082174,31082668,31082912,31085835,31086078,31086288,31086540,31087438,31091396,31091866,31092313,31092509,31096672,31097315,31097669', 'assoc_port': '31045064:31046979,31045065:31046934,31045070:31047156,31048153:31048248,31050101:31050277,31050349:31050496,31050595:31050857,31050889:31051138,31051161:31051258,31051831:31051934,31052637:31052771,31053354:31053489,31053637:31053702,31054317:31054450,31054570:31054684,31056321:31056451,31056564:31056687,31056806:31056828,31059702:31059799,31059963:31060071,31060475:31060603,31060713:31060805,31060952:31061046,31061195:31061245,31066519:31066574,31075729:31075787,31076396:31076416,31076569:31076666,31076813:31076833,31081872:31082010,31082112:31082174,31082601:31082668,31082816:31082912,31085732:31085835,31085975:31086078,31086223:31086288,31086481:31086540,31087413:31087438,31091303:31091396,31091805:31091866,31092252:31092313,31092493:31092509,31096537:31096672,31097067:31097315,31097457:31097669', 'assoc_mat': '31045064:pet_fonce:4230:31046979,31045065:pet_fonce:4230:31046934,31045070:pet_fonce:4230:31047156,31048153:pet_fonce:4230:31048248,31050101:pet_fonce:4230:31050277,31050349:pet_fonce:4230:31050496,31050595:pet_fonce:4230:31050857,31050889:pet_fonce:4230:31051138,31051161:pet_fonce:4230:31051258,31051831:pet_fonce:4230:31051934,31052637:pet_fonce:4230:31052771,31053354:pet_fonce:4230:31053489,31053637:pet_fonce:4230:31053702,31054317:pet_fonce:4230:31054450,31054570:pet_fonce:4230:31054684,31056321:pet_fonce:4230:31056451,31056564:pet_fonce:4230:31056687,31056806:pet_fonce:4230:31056828,31059702:pet_fonce:4230:31059799,31059963:pet_fonce:4230:31060071,31060475:pet_fonce:4230:31060603,31060713:pet_fonce:4230:31060805,31060952:pet_fonce:4230:31061046,31061195:pet_fonce:4230:31061245,31066519:pet_fonce:4230:31066574,31075729:pet_fonce:4230:31075787,31076396:pet_fonce:4230:31076416,31076569:pet_fonce:4230:31076666,31076813:pet_fonce:4230:31076833,31081872:pet_fonce:4230:31082010,31082112:pet_fonce:4230:31082174,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(2987114,2987344,2987534,2988216,2988688,2989190,2989718,2990226,2990720,2991232,2991762,2992358,2993106)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048697, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046935,31046972,31047019,31047041,31047082,31047115,31047160,31047382,31047518,31047685,31047820,31048209,31048246,31048404,31048823,31048866,31049779,31049986,31050276,31050490,31050855,31051123,31051250,31051499,31051724,31051921,31051962,31052240,31052563,31052773,31052977,31053205,31053488,31053688,31053861,31054163,31054448,31054686,31054969,31055225,31055516,31055707,31055907,31056139,31056445,31056702,31056817,31057117,31057359,31057578,31057618,31057914,31058126,31058407,31058582,31058872,31059116,31059344,31059576,31059806,31060055,31060293,31060609,31060803,31061043,31061238,31061491,31061779,31062036,31062165,31062361,31062652,31062883,31063128,31063158,31063783,31064209,31064459,31064837,31065078,31065376,31065592,31065920,31066125,31066333,31066580,31066772,31067197,31067309,31067489,31067672,31068173,31069074,31069389,31069654,31069819,31070234,31070561,31070746,31071033,31071372,31071415,31071631,31071839,31072044,31072260,31072498,31072701,31072918,31073214,31075028,31075157,31075528,3107578 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048698, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046945,31046981,31047018,31047054,31047088,31047124,31047163,31047386,31047522,31047700,31047821,31048220,31048258,31048405,31048832,31048870,31049781,31049994,31050283,31050492,31050847,31051131,31051263,31051500,31051725,31051929,31051963,31052235,31052559,31052769,31052986,31053209,31053490,31053698,31053875,31054166,31054459,31054677,31054981,31055234,31055515,31055721,31055914,31056142,31056449,31056700,31056830,31057111,31057356,31057572,31057621,31057920,31058134,31058415,31058584,31058882,31059130,31059345,31059590,31059812,31060062,31060290,31060605,31060798,31061048,31061255,31061500,31061794,31062037,31062158,31062365,31062643,31062890,31063129,31063166,31063566,31063607,31063797,31064036,31064217,31064454,31064835,31065093,31065372,31065601,31065916,31066115,31066326,31066583,31066782,31067204,31067322,31067491,31067684,31070230,31070572,31070745,31071041,31071382,31071416,31071629,31071837,31072047,31072266,31072509,31072714,31072922,31073215,31074410,31075170,31075543,31075785,31076003,3107625 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048699, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046932,31046969,31047004,31047079,31047122,31047381,31048222,31048252,31050272,31050488,31050858,31051130,31051247,31051511,31051713,31051964,31052242,31052554,31052777,31052972,31053193,31054167,31054453,31054979,31055719,31056125,31056460,31056701,31061038,31061243,31061501,31061787,31062024,31071371,31076671,31080405,31082662,31089926,31098683,31098885 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048700, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046943,31046978,31047012,31047050,31047091,31047126,31047158,31047385,31047526,31047699,31047819,31048213,31048253,31048411,31048834,31048872,31049788,31049997,31050274,31050493,31050851,31051134,31051259,31051512,31051722,31051930,31051971,31052241,31052555,31052770,31052978,31053199,31053494,31053700,31053877,31054159,31054456,31054687,31054983,31055230,31055512,31055718,31055919,31056138,31056459,31056691,31056831,31057118,31057363,31057585,31057620,31057917,31058133,31058401,31058586,31058879,31059125,31059346,31059589,31059811,31060068,31060295,31060598,31060814,31061053,31061254,31061498,31061792,31062031,31062154,31062373,31062649,31062888,31063120,31063167,31063569,31063606,31063791,31064038,31064221,31064457,31064838,31065084,31065377,31065608,31065914,31066124,31066327,31066582,31066781,31067208,31067310,31067482,31067677,31067972,31070225,31070571,31070749,31071043,31071384,31071422,31071624,31071844,31072046,31072262,31072505,31072709,31072915,31073209,31073415,31073694,31073731,31074130,3107417 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048701, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046982,31047017,31047053,31047085,31047116,31047148,31047389,31047525,31047817,31048219,31049995,31050281,31050494,31050852,31051135,31051262,31051509,31051927,31052776,31054682,31054977,31055233,31055709,31056458,31056822,31057116,31057623,31058402,31059127,31059337,31059592,31059809,31060287,31060610,31061049,31061793,31066121,31067490,31071625,31071832,31072716,31072924,31076004,31076415,31076840,31077118,31077329,31077576,31081238,31081441,31082420,31082676,31083085,31085827,31086079,31086297,31086548,31086788,31087079,31087305,31087426,31087656,31087926,31088146,31088342,31091127,31091656,31091870,31092311,31092758,31092997,31093245,31093516,31096669,31096888,31097310,31097678,31097866,31098173,31098901 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048702, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046946,31046980,31047014,31047048,31047083,31047119,31047161,31047379,31047523,31047702,31047813,31048224,31048260,31048410,31048831,31048871,31049784,31049998,31050282,31050485,31050856,31051128,31051256,31051507,31051709,31051928,31051967,31052238,31052556,31052772,31052981,31053208,31053496,31053689,31053876,31054164,31054458,31054683,31054982,31055223,31055513,31055713,31055912,31056137,31056454,31056694,31056827,31057110,31057366,31057581,31057622,31058131,31058583,31058870,31059131,31059334,31059581,31059810,31060064,31060284,31060611,31060800,31061055,31061249,31061502,31061796,31062040,31062162,31062369,31062640,31065380,31065924,31066118,31066324,31066572,31066776,31067212,31067311,31067486,31071386,31071420,31071622,31071841,31072041,31072267,31072511,31072706,31075796,31076002,31076253,31076410,31076672,31076838,31077119,31077327,31077853,31081237,31081438,31081689,31082009,31082172,31082410,31082669,31082909,31083082,31083292,31083534,31085551,31085829,31086075,31086292,31086547,31086783,3108708 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048703, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046934,31046979,31047156,31048248,31050277,31050496,31050857,31051138,31051258,31051934,31052771,31053489,31053702,31054450,31054684,31056451,31056687,31056828,31059799,31060071,31060603,31060805,31061046,31061245,31066574,31075787,31076416,31076666,31076833,31082010,31082174,31082668,31082912,31085835,31086078,31086288,31086540,31087438,31091396,31091866,31092313,31092509,31096672,31097315,31097669 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31048697,31048698,31048699,31048700,31048701,31048702,31048703?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2026-08-01' and date <= '2026-08-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((575,),), 'unwanted_material_monthly_percentage': ((0.9268715718800284,),), 'material_repartition': (('incineration', 572),), 'material_dict': {'incineration': 572}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 8, 14), 0.7991885963154561, 3), (datetime.date(2026, 8, 15), 0.8029459091935757, 1), (datetime.date(2026, 8, 16), 0.8241171846386712, 1), (datetime.date(2026, 8, 22), 0.7391521885542333, 1), (datetime.date(2026, 8, 23), 0.8437063663198935, 1), (datetime.date(2026, 8, 24), 0.9497040199572856, 2), (datetime.date(2026, 8, 25), 0.9569927424092491, 1), (datetime.date(2026, 8, 26), 0.9650913012847355, 2), (datetime.date(2026, 8, 27), 0.9611668166855702, 3), (datetime.date(2026, 8, 28), 0.9498335013303154, 2), (datetime.date(2026, 8, 29), 0.9487451872967624, 1), (datetime.date(2026, 8, 30), 0.9599071651803017, 1), (datetime.date(2026, 8, 31), 0.9586761618661372, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 8, 14), 0.7991885963154561, 3), (datetime.date(2026, 8, 15), 0.8029459091935757, 1), (datetime.date(2026, 8, 16), 0.8241171846386712, 1), (datetime.date(2026, 8, 22), 0.7391521885542333, 1), (datetime.date(2026, 8, 23), 0.8437063663198935, 1), (datetime.date(2026, 8, 24), 0.9497040199572856, 2), (datetime.date(2026, 8, 25), 0.9569927424092491, 1), (datetime.date(2026, 8, 26), 0.9650913012847355, 2), (datetime.date(2026, 8, 27), 0.9611668166855702, 3), (datetime.date(2026, 8, 28), 0.9498335013303154, 2), (datetime.date(2026, 8, 29), 0.9487451872967624, 1), (datetime.date(2026, 8, 30), 0.9599071651803017, 1), (datetime.date(2026, 8, 31), 0.9586761618661372, 3))}, 'quality_array': [['-7.834164452777389', '14082026'], ['-8.15396188000904', '15082026'], ['-8.00489469434096', '16082026'], ['-7.679896178077161', '22082026'], ['-6.316761121533944', '23082026'], ['-0.37250969273738005', '24082026'], ['0.21362827895679257', '25082026'], ['1.1267804873773823', '26082026'], ['0.5863492256907815', '27082026'], ['-0.49264678069853307', '28082026'], ['-0.9354698622970279', '29082026'], ['-0.6463306382084663', '30082026'], ['-0.6476575450140734', '31082026']], 'number_of_batch': ((238,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.009065779348952441, 'nb_photo': 1543, 'list_port_cont': '31046935,31046972,31047019,31047041,31047082,31047115,31047160,31047382,31047518,31047685,31047820,31048209,31048246,31048404,31048823,31048866,31049779,31049986,31050276,31050490,31050855,31051123,31051250,31051499,31051724,31051921,31051962,31052240,31052563,31052773,31052977,31053205,31053488,31053688,31053861,31054163,31054448,31054686,31054969,31055225,31055516,31055707,31055907,31056139,31056445,31056702,31056817,31057117,31057359,31057578,31057618,31057914,31058126,31058407,31058582,31058872,31059116,31059344,31059576,31059806,31060055,31060293,31060609,31060803,31061043,31061238,31061491,31061779,31062036,31062165,31062361,31062652,31062883,31063128,31063158,31063783,31064209,31064459,31064837,31065078,31065376,31065592,31065920,31066125,31066333,31066580,31066772,31067197,31067309,31067489,31067672,31068173,31069074,31069389,31069654,31069819,31070234,31070561,31070746,31071033,31071372,31071415,31071631,31071839,31072044,31072260,31072498,31072701,31072918,31073214,31075028,31075157,31075528,3107578', 'assoc_port': '31045064:31046972,31045065:31046935,31045066:31047041,31045067:31047019,31045068:31047082,31045069:31047115,31045070:31047160,31047221:31047382,31047411:31047518,31047563:31047685,31047764:31047820,31048153:31048246,31048154:31048209,31048361:31048404,31048780:31048823,31048781:31048866,31049690:31049779,31049896:31049986,31050101:31050276,31050349:31050490,31050595:31050855,31050889:31051123,31051161:31051250,31051369:31051499,31051619:31051724,31051831:31051921,31051832:31051962,31052141:31052240,31052386:31052563,31052637:31052773,31052881:31052977,31053093:31053205,31053354:31053488,31053637:31053688,31053845:31053861,31054024:31054163,31054317:31054448,31054570:31054686,31054830:31054969,31055090:31055225,31055336:31055516,31055582:31055707,31055822:31055907,31056061:31056139,31056321:31056445,31056564:31056702,31056806:31056817,31057014:31057117,31057266:31057359,31057481:31057618,31057482:31057578,31057787:31057914,31058031:31058126,31058277:31058407,31058525:31058582,31058771:31058872,31058993:3105911', 'assoc_mat': '31045064:autre:4230:31046972,31045065:autre:4230:31046935,31045066:autre:4230:31047041,31045067:autre:4230:31047019,31045068:autre:4230:31047082,31045069:autre:4230:31047115,31045070:autre:4230:31047160,31047221:autre:4230:31047382,31047411:autre:4230:31047518,31047563:autre:4230:31047685,31047764:autre:4230:31047820,31048153:autre:4230:31048246,31048154:autre:4230:31048209,31048361:autre:4230:31048404,31048780:autre:4230:31048823,31048781:autre:4230:31048866,31049690:autre:4230:31049779,31049896:autre:4230:31049986,31050101:autre:4230:31050276,31050349:autre:4230:31050490,31050595:autre:4230:31050855,31050889:autre:4230:31051123,31051161:autre:4230:31051250,31051369:autre:4230:31051499,31051619:autre:4230:31051724,31051831:autre:4230:31051921,31051832:autre:4230:31051962,31052141:autre:4230:31052240,31052386:autre:4230:31052563,31052637:autre:4230:31052773,31052881:autre:4230:31052977,31053093:autre:4230:31053205,31053354:autre:4230:31053488,31053637:autre:4230:31053688,31053845:autre:4230:31053861,31054024:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.022152304656919145, 'nb_photo': 4813, 'list_port_cont': '31046945,31046981,31047018,31047054,31047088,31047124,31047163,31047386,31047522,31047700,31047821,31048220,31048258,31048405,31048832,31048870,31049781,31049994,31050283,31050492,31050847,31051131,31051263,31051500,31051725,31051929,31051963,31052235,31052559,31052769,31052986,31053209,31053490,31053698,31053875,31054166,31054459,31054677,31054981,31055234,31055515,31055721,31055914,31056142,31056449,31056700,31056830,31057111,31057356,31057572,31057621,31057920,31058134,31058415,31058584,31058882,31059130,31059345,31059590,31059812,31060062,31060290,31060605,31060798,31061048,31061255,31061500,31061794,31062037,31062158,31062365,31062643,31062890,31063129,31063166,31063566,31063607,31063797,31064036,31064217,31064454,31064835,31065093,31065372,31065601,31065916,31066115,31066326,31066583,31066782,31067204,31067322,31067491,31067684,31070230,31070572,31070745,31071041,31071382,31071416,31071629,31071837,31072047,31072266,31072509,31072714,31072922,31073215,31074410,31075170,31075543,31075785,31076003,3107625', 'assoc_port': '31045064:31046981,31045065:31046945,31045066:31047054,31045067:31047018,31045068:31047088,31045069:31047124,31045070:31047163,31047221:31047386,31047411:31047522,31047563:31047700,31047764:31047821,31048153:31048258,31048154:31048220,31048361:31048405,31048780:31048832,31048781:31048870,31049690:31049781,31049896:31049994,31050101:31050283,31050349:31050492,31050595:31050847,31050889:31051131,31051161:31051263,31051369:31051500,31051619:31051725,31051831:31051929,31051832:31051963,31052141:31052235,31052386:31052559,31052637:31052769,31052881:31052986,31053093:31053209,31053354:31053490,31053637:31053698,31053845:31053875,31054024:31054166,31054317:31054459,31054570:31054677,31054830:31054981,31055090:31055234,31055336:31055515,31055582:31055721,31055822:31055914,31056061:31056142,31056321:31056449,31056564:31056700,31056806:31056830,31057014:31057111,31057266:31057356,31057481:31057621,31057482:31057572,31057787:31057920,31058031:31058134,31058277:31058415,31058525:31058584,31058771:31058882,31058993:3105913', 'assoc_mat': '31045064:carton:4230:31046981,31045065:carton:4230:31046945,31045066:carton:4230:31047054,31045067:carton:4230:31047018,31045068:carton:4230:31047088,31045069:carton:4230:31047124,31045070:carton:4230:31047163,31047221:carton:4230:31047386,31047411:carton:4230:31047522,31047563:carton:4230:31047700,31047764:carton:4230:31047821,31048153:carton:4230:31048258,31048154:carton:4230:31048220,31048361:carton:4230:31048405,31048780:carton:4230:31048832,31048781:carton:4230:31048870,31049690:carton:4230:31049781,31049896:carton:4230:31049994,31050101:carton:4230:31050283,31050349:carton:4230:31050492,31050595:carton:4230:31050847,31050889:carton:4230:31051131,31051161:carton:4230:31051263,31051369:carton:4230:31051500,31051619:carton:4230:31051725,31051831:carton:4230:31051929,31051832:carton:4230:31051963,31052141:carton:4230:31052235,31052386:carton:4230:31052559,31052637:carton:4230:31052769,31052881:carton:4230:31052986,31053093:carton:4230:31053209,31053354:carton:4230:31053490,31053637:carton:4230:31053698,3105'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.000575015460073561, 'nb_photo': 66, 'list_port_cont': '31046932,31046969,31047004,31047079,31047122,31047381,31048222,31048252,31050272,31050488,31050858,31051130,31051247,31051511,31051713,31051964,31052242,31052554,31052777,31052972,31053193,31054167,31054453,31054979,31055719,31056125,31056460,31056701,31061038,31061243,31061501,31061787,31062024,31071371,31076671,31080405,31082662,31089926,31098683,31098885', 'assoc_port': '31045064:31046969,31045065:31046932,31045067:31047004,31045068:31047079,31045069:31047122,31047221:31047381,31048153:31048252,31048154:31048222,31050101:31050272,31050349:31050488,31050595:31050858,31050889:31051130,31051161:31051247,31051369:31051511,31051619:31051713,31051832:31051964,31052141:31052242,31052386:31052554,31052637:31052777,31052881:31052972,31053093:31053193,31054024:31054167,31054317:31054453,31054830:31054979,31055582:31055719,31056061:31056125,31056321:31056460,31056564:31056701,31060952:31061038,31061195:31061243,31061404:31061501,31061645:31061787,31061901:31062024,31071324:31071371,31076569:31076671,31080311:31080405,31082601:31082662,31089899:31089926,31098522:31098683,31098761:31098885', 'assoc_mat': '31045064:metal:4230:31046969,31045065:metal:4230:31046932,31045067:metal:4230:31047004,31045068:metal:4230:31047079,31045069:metal:4230:31047122,31047221:metal:4230:31047381,31048153:metal:4230:31048252,31048154:metal:4230:31048222,31050101:metal:4230:31050272,31050349:metal:4230:31050488,31050595:metal:4230:31050858,31050889:metal:4230:31051130,31051161:metal:4230:31051247,31051369:metal:4230:31051511,31051619:metal:4230:31051713,31051832:metal:4230:31051964,31052141:metal:4230:31052242,31052386:metal:4230:31052554,31052637:metal:4230:31052777,31052881:metal:4230:31052972,31053093:metal:4230:31053193,31054024:metal:4230:31054167,31054317:metal:4230:31054453,31054830:metal:4230:31054979,31055582:metal:4230:31055719,31056061:metal:4230:31056125,31056321:metal:4230:31056460,31056564:metal:4230:31056701,31060952:metal:4230:31061038,31061195:metal:4230:31061243,31061404:metal:4230:31061501,31061645:metal:4230:31061787,31061901:metal:4230:31062024,31071324:metal:4230:31071371,31076569:metal:4230:31076671,31080311:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.12943859176534755, 'nb_photo': 22986, 'list_port_cont': '31046943,31046978,31047012,31047050,31047091,31047126,31047158,31047385,31047526,31047699,31047819,31048213,31048253,31048411,31048834,31048872,31049788,31049997,31050274,31050493,31050851,31051134,31051259,31051512,31051722,31051930,31051971,31052241,31052555,31052770,31052978,31053199,31053494,31053700,31053877,31054159,31054456,31054687,31054983,31055230,31055512,31055718,31055919,31056138,31056459,31056691,31056831,31057118,31057363,31057585,31057620,31057917,31058133,31058401,31058586,31058879,31059125,31059346,31059589,31059811,31060068,31060295,31060598,31060814,31061053,31061254,31061498,31061792,31062031,31062154,31062373,31062649,31062888,31063120,31063167,31063569,31063606,31063791,31064038,31064221,31064457,31064838,31065084,31065377,31065608,31065914,31066124,31066327,31066582,31066781,31067208,31067310,31067482,31067677,31067972,31070225,31070571,31070749,31071043,31071384,31071422,31071624,31071844,31072046,31072262,31072505,31072709,31072915,31073209,31073415,31073694,31073731,31074130,3107417', 'assoc_port': '31045064:31046978,31045065:31046943,31045066:31047050,31045067:31047012,31045068:31047091,31045069:31047126,31045070:31047158,31047221:31047385,31047411:31047526,31047563:31047699,31047764:31047819,31048153:31048253,31048154:31048213,31048361:31048411,31048780:31048834,31048781:31048872,31049690:31049788,31049896:31049997,31050101:31050274,31050349:31050493,31050595:31050851,31050889:31051134,31051161:31051259,31051369:31051512,31051619:31051722,31051831:31051930,31051832:31051971,31052141:31052241,31052386:31052555,31052637:31052770,31052881:31052978,31053093:31053199,31053354:31053494,31053637:31053700,31053845:31053877,31054024:31054159,31054317:31054456,31054570:31054687,31054830:31054983,31055090:31055230,31055336:31055512,31055582:31055718,31055822:31055919,31056061:31056138,31056321:31056459,31056564:31056691,31056806:31056831,31057014:31057118,31057266:31057363,31057481:31057620,31057482:31057585,31057787:31057917,31058031:31058133,31058277:31058401,31058525:31058586,31058771:31058879,31058993:3105912', 'assoc_mat': '31045064:papier:4230:31046978,31045065:papier:4230:31046943,31045066:papier:4230:31047050,31045067:papier:4230:31047012,31045068:papier:4230:31047091,31045069:papier:4230:31047126,31045070:papier:4230:31047158,31047221:papier:4230:31047385,31047411:papier:4230:31047526,31047563:papier:4230:31047699,31047764:papier:4230:31047819,31048153:papier:4230:31048253,31048154:papier:4230:31048213,31048361:papier:4230:31048411,31048780:papier:4230:31048834,31048781:papier:4230:31048872,31049690:papier:4230:31049788,31049896:papier:4230:31049997,31050101:papier:4230:31050274,31050349:papier:4230:31050493,31050595:papier:4230:31050851,31050889:papier:4230:31051134,31051161:papier:4230:31051259,31051369:papier:4230:31051512,31051619:papier:4230:31051722,31051831:papier:4230:31051930,31051832:papier:4230:31051971,31052141:papier:4230:31052241,31052386:papier:4230:31052555,31052637:papier:4230:31052770,31052881:papier:4230:31052978,31053093:papier:4230:31053199,31053354:papier:4230:31053494,31053637:papier:4230:31053700,3105'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017128752535139214, 'nb_photo': 144, 'list_port_cont': '31046982,31047017,31047053,31047085,31047116,31047148,31047389,31047525,31047817,31048219,31049995,31050281,31050494,31050852,31051135,31051262,31051509,31051927,31052776,31054682,31054977,31055233,31055709,31056458,31056822,31057116,31057623,31058402,31059127,31059337,31059592,31059809,31060287,31060610,31061049,31061793,31066121,31067490,31071625,31071832,31072716,31072924,31076004,31076415,31076840,31077118,31077329,31077576,31081238,31081441,31082420,31082676,31083085,31085827,31086079,31086297,31086548,31086788,31087079,31087305,31087426,31087656,31087926,31088146,31088342,31091127,31091656,31091870,31092311,31092758,31092997,31093245,31093516,31096669,31096888,31097310,31097678,31097866,31098173,31098901', 'assoc_port': '31045064:31046982,31045066:31047053,31045067:31047017,31045068:31047085,31045069:31047116,31045070:31047148,31047221:31047389,31047411:31047525,31047764:31047817,31048154:31048219,31049896:31049995,31050101:31050281,31050349:31050494,31050595:31050852,31050889:31051135,31051161:31051262,31051369:31051509,31051831:31051927,31052637:31052776,31054570:31054682,31054830:31054977,31055090:31055233,31055582:31055709,31056321:31056458,31056806:31056822,31057014:31057116,31057481:31057623,31058277:31058402,31058993:31059127,31059241:31059337,31059487:31059592,31059702:31059809,31060218:31060287,31060475:31060610,31060952:31061049,31061645:31061793,31066058:31066121,31067426:31067490,31071531:31071625,31071776:31071832,31072690:31072716,31072862:31072924,31075971:31076004,31076396:31076415,31076813:31076840,31077024:31077118,31077260:31077329,31077517:31077576,31081206:31081238,31081381:31081441,31082359:31082420,31082601:31082676,31083018:31083085,31085732:31085827,31085975:31086079,31086223:31086297,31086481:3108654', 'assoc_mat': '31045064:pehd:4230:31046982,31045066:pehd:4230:31047053,31045067:pehd:4230:31047017,31045068:pehd:4230:31047085,31045069:pehd:4230:31047116,31045070:pehd:4230:31047148,31047221:pehd:4230:31047389,31047411:pehd:4230:31047525,31047764:pehd:4230:31047817,31048154:pehd:4230:31048219,31049896:pehd:4230:31049995,31050101:pehd:4230:31050281,31050349:pehd:4230:31050494,31050595:pehd:4230:31050852,31050889:pehd:4230:31051135,31051161:pehd:4230:31051262,31051369:pehd:4230:31051509,31051831:pehd:4230:31051927,31052637:pehd:4230:31052776,31054570:pehd:4230:31054682,31054830:pehd:4230:31054977,31055090:pehd:4230:31055233,31055582:pehd:4230:31055709,31056321:pehd:4230:31056458,31056806:pehd:4230:31056822,31057014:pehd:4230:31057116,31057481:pehd:4230:31057623,31058277:pehd:4230:31058402,31058993:pehd:4230:31059127,31059241:pehd:4230:31059337,31059487:pehd:4230:31059592,31059702:pehd:4230:31059809,31060218:pehd:4230:31060287,31060475:pehd:4230:31060610,31060952:pehd:4230:31061049,31061645:pehd:4230:31061793,31066058:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017688344174203955, 'nb_photo': 1878, 'list_port_cont': '31046946,31046980,31047014,31047048,31047083,31047119,31047161,31047379,31047523,31047702,31047813,31048224,31048260,31048410,31048831,31048871,31049784,31049998,31050282,31050485,31050856,31051128,31051256,31051507,31051709,31051928,31051967,31052238,31052556,31052772,31052981,31053208,31053496,31053689,31053876,31054164,31054458,31054683,31054982,31055223,31055513,31055713,31055912,31056137,31056454,31056694,31056827,31057110,31057366,31057581,31057622,31058131,31058583,31058870,31059131,31059334,31059581,31059810,31060064,31060284,31060611,31060800,31061055,31061249,31061502,31061796,31062040,31062162,31062369,31062640,31065380,31065924,31066118,31066324,31066572,31066776,31067212,31067311,31067486,31071386,31071420,31071622,31071841,31072041,31072267,31072511,31072706,31075796,31076002,31076253,31076410,31076672,31076838,31077119,31077327,31077853,31081237,31081438,31081689,31082009,31082172,31082410,31082669,31082909,31083082,31083292,31083534,31085551,31085829,31086075,31086292,31086547,31086783,3108708', 'assoc_port': '31045064:31046980,31045065:31046946,31045066:31047048,31045067:31047014,31045068:31047083,31045069:31047119,31045070:31047161,31047221:31047379,31047411:31047523,31047563:31047702,31047764:31047813,31048153:31048260,31048154:31048224,31048361:31048410,31048780:31048831,31048781:31048871,31049690:31049784,31049896:31049998,31050101:31050282,31050349:31050485,31050595:31050856,31050889:31051128,31051161:31051256,31051369:31051507,31051619:31051709,31051831:31051928,31051832:31051967,31052141:31052238,31052386:31052556,31052637:31052772,31052881:31052981,31053093:31053208,31053354:31053496,31053637:31053689,31053845:31053876,31054024:31054164,31054317:31054458,31054570:31054683,31054830:31054982,31055090:31055223,31055336:31055513,31055582:31055713,31055822:31055912,31056061:31056137,31056321:31056454,31056564:31056694,31056806:31056827,31057014:31057110,31057266:31057366,31057481:31057622,31057482:31057581,31058031:31058131,31058525:31058583,31058771:31058870,31058993:31059131,31059241:31059334,31059487:3105958', 'assoc_mat': '31045064:pet_clair:4230:31046980,31045065:pet_clair:4230:31046946,31045066:pet_clair:4230:31047048,31045067:pet_clair:4230:31047014,31045068:pet_clair:4230:31047083,31045069:pet_clair:4230:31047119,31045070:pet_clair:4230:31047161,31047221:pet_clair:4230:31047379,31047411:pet_clair:4230:31047523,31047563:pet_clair:4230:31047702,31047764:pet_clair:4230:31047813,31048153:pet_clair:4230:31048260,31048154:pet_clair:4230:31048224,31048361:pet_clair:4230:31048410,31048780:pet_clair:4230:31048831,31048781:pet_clair:4230:31048871,31049690:pet_clair:4230:31049784,31049896:pet_clair:4230:31049998,31050101:pet_clair:4230:31050282,31050349:pet_clair:4230:31050485,31050595:pet_clair:4230:31050856,31050889:pet_clair:4230:31051128,31051161:pet_clair:4230:31051256,31051369:pet_clair:4230:31051507,31051619:pet_clair:4230:31051709,31051831:pet_clair:4230:31051928,31051832:pet_clair:4230:31051967,31052141:pet_clair:4230:31052238,31052386:pet_clair:4230:31052556,31052637:pet_clair:4230:31052772,31052881:pet_clair:4230:31052981,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018814295852732114, 'nb_photo': 81, 'list_port_cont': '31046934,31046979,31047156,31048248,31050277,31050496,31050857,31051138,31051258,31051934,31052771,31053489,31053702,31054450,31054684,31056451,31056687,31056828,31059799,31060071,31060603,31060805,31061046,31061245,31066574,31075787,31076416,31076666,31076833,31082010,31082174,31082668,31082912,31085835,31086078,31086288,31086540,31087438,31091396,31091866,31092313,31092509,31096672,31097315,31097669', 'assoc_port': '31045064:31046979,31045065:31046934,31045070:31047156,31048153:31048248,31050101:31050277,31050349:31050496,31050595:31050857,31050889:31051138,31051161:31051258,31051831:31051934,31052637:31052771,31053354:31053489,31053637:31053702,31054317:31054450,31054570:31054684,31056321:31056451,31056564:31056687,31056806:31056828,31059702:31059799,31059963:31060071,31060475:31060603,31060713:31060805,31060952:31061046,31061195:31061245,31066519:31066574,31075729:31075787,31076396:31076416,31076569:31076666,31076813:31076833,31081872:31082010,31082112:31082174,31082601:31082668,31082816:31082912,31085732:31085835,31085975:31086078,31086223:31086288,31086481:31086540,31087413:31087438,31091303:31091396,31091805:31091866,31092252:31092313,31092493:31092509,31096537:31096672,31097067:31097315,31097457:31097669', 'assoc_mat': '31045064:pet_fonce:4230:31046979,31045065:pet_fonce:4230:31046934,31045070:pet_fonce:4230:31047156,31048153:pet_fonce:4230:31048248,31050101:pet_fonce:4230:31050277,31050349:pet_fonce:4230:31050496,31050595:pet_fonce:4230:31050857,31050889:pet_fonce:4230:31051138,31051161:pet_fonce:4230:31051258,31051831:pet_fonce:4230:31051934,31052637:pet_fonce:4230:31052771,31053354:pet_fonce:4230:31053489,31053637:pet_fonce:4230:31053702,31054317:pet_fonce:4230:31054450,31054570:pet_fonce:4230:31054684,31056321:pet_fonce:4230:31056451,31056564:pet_fonce:4230:31056687,31056806:pet_fonce:4230:31056828,31059702:pet_fonce:4230:31059799,31059963:pet_fonce:4230:31060071,31060475:pet_fonce:4230:31060603,31060713:pet_fonce:4230:31060805,31060952:pet_fonce:4230:31061046,31061195:pet_fonce:4230:31061245,31066519:pet_fonce:4230:31066574,31075729:pet_fonce:4230:31075787,31076396:pet_fonce:4230:31076416,31076569:pet_fonce:4230:31076666,31076813:pet_fonce:4230:31076833,31081872:pet_fonce:4230:31082010,31082112:pet_fonce:4230:31082174,3'}), 'main_stat': {'nb_photos': 575}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31048697,31048698,31048699,31048700,31048701,31048702,31048703?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-08', 0.9268715718800284),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((575,),), 'unwanted_material_monthly_percentage': ((0.9268715718800284,),), 'material_repartition': (('incineration', 572),), 'material_dict': {'incineration': 572}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 8, 14), 0.7991885963154561, 3), (datetime.date(2026, 8, 15), 0.8029459091935757, 1), (datetime.date(2026, 8, 16), 0.8241171846386712, 1), (datetime.date(2026, 8, 22), 0.7391521885542333, 1), (datetime.date(2026, 8, 23), 0.8437063663198935, 1), (datetime.date(2026, 8, 24), 0.9497040199572856, 2), (datetime.date(2026, 8, 25), 0.9569927424092491, 1), (datetime.date(2026, 8, 26), 0.9650913012847355, 2), (datetime.date(2026, 8, 27), 0.9611668166855702, 3), (datetime.date(2026, 8, 28), 0.9498335013303154, 2), (datetime.date(2026, 8, 29), 0.9487451872967624, 1), (datetime.date(2026, 8, 30), 0.9599071651803017, 1), (datetime.date(2026, 8, 31), 0.9586761618661372, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 8, 14), 0.7991885963154561, 3), (datetime.date(2026, 8, 15), 0.8029459091935757, 1), (datetime.date(2026, 8, 16), 0.8241171846386712, 1), (datetime.date(2026, 8, 22), 0.7391521885542333, 1), (datetime.date(2026, 8, 23), 0.8437063663198935, 1), (datetime.date(2026, 8, 24), 0.9497040199572856, 2), (datetime.date(2026, 8, 25), 0.9569927424092491, 1), (datetime.date(2026, 8, 26), 0.9650913012847355, 2), (datetime.date(2026, 8, 27), 0.9611668166855702, 3), (datetime.date(2026, 8, 28), 0.9498335013303154, 2), (datetime.date(2026, 8, 29), 0.9487451872967624, 1), (datetime.date(2026, 8, 30), 0.9599071651803017, 1), (datetime.date(2026, 8, 31), 0.9586761618661372, 3))}, 'quality_array': [['-7.834164452777389', '14082026'], ['-8.15396188000904', '15082026'], ['-8.00489469434096', '16082026'], ['-7.679896178077161', '22082026'], ['-6.316761121533944', '23082026'], ['-0.37250969273738005', '24082026'], ['0.21362827895679257', '25082026'], ['1.1267804873773823', '26082026'], ['0.5863492256907815', '27082026'], ['-0.49264678069853307', '28082026'], ['-0.9354698622970279', '29082026'], ['-0.6463306382084663', '30082026'], ['-0.6476575450140734', '31082026']], 'number_of_batch': ((238,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.009065779348952441, 'nb_photo': 1543, 'list_port_cont': '31046935,31046972,31047019,31047041,31047082,31047115,31047160,31047382,31047518,31047685,31047820,31048209,31048246,31048404,31048823,31048866,31049779,31049986,31050276,31050490,31050855,31051123,31051250,31051499,31051724,31051921,31051962,31052240,31052563,31052773,31052977,31053205,31053488,31053688,31053861,31054163,31054448,31054686,31054969,31055225,31055516,31055707,31055907,31056139,31056445,31056702,31056817,31057117,31057359,31057578,31057618,31057914,31058126,31058407,31058582,31058872,31059116,31059344,31059576,31059806,31060055,31060293,31060609,31060803,31061043,31061238,31061491,31061779,31062036,31062165,31062361,31062652,31062883,31063128,31063158,31063783,31064209,31064459,31064837,31065078,31065376,31065592,31065920,31066125,31066333,31066580,31066772,31067197,31067309,31067489,31067672,31068173,31069074,31069389,31069654,31069819,31070234,31070561,31070746,31071033,31071372,31071415,31071631,31071839,31072044,31072260,31072498,31072701,31072918,31073214,31075028,31075157,31075528,3107578', 'assoc_port': '31045064:31046972,31045065:31046935,31045066:31047041,31045067:31047019,31045068:31047082,31045069:31047115,31045070:31047160,31047221:31047382,31047411:31047518,31047563:31047685,31047764:31047820,31048153:31048246,31048154:31048209,31048361:31048404,31048780:31048823,31048781:31048866,31049690:31049779,31049896:31049986,31050101:31050276,31050349:31050490,31050595:31050855,31050889:31051123,31051161:31051250,31051369:31051499,31051619:31051724,31051831:31051921,31051832:31051962,31052141:31052240,31052386:31052563,31052637:31052773,31052881:31052977,31053093:31053205,31053354:31053488,31053637:31053688,31053845:31053861,31054024:31054163,31054317:31054448,31054570:31054686,31054830:31054969,31055090:31055225,31055336:31055516,31055582:31055707,31055822:31055907,31056061:31056139,31056321:31056445,31056564:31056702,31056806:31056817,31057014:31057117,31057266:31057359,31057481:31057618,31057482:31057578,31057787:31057914,31058031:31058126,31058277:31058407,31058525:31058582,31058771:31058872,31058993:3105911', 'assoc_mat': '31045064:autre:4230:31046972,31045065:autre:4230:31046935,31045066:autre:4230:31047041,31045067:autre:4230:31047019,31045068:autre:4230:31047082,31045069:autre:4230:31047115,31045070:autre:4230:31047160,31047221:autre:4230:31047382,31047411:autre:4230:31047518,31047563:autre:4230:31047685,31047764:autre:4230:31047820,31048153:autre:4230:31048246,31048154:autre:4230:31048209,31048361:autre:4230:31048404,31048780:autre:4230:31048823,31048781:autre:4230:31048866,31049690:autre:4230:31049779,31049896:autre:4230:31049986,31050101:autre:4230:31050276,31050349:autre:4230:31050490,31050595:autre:4230:31050855,31050889:autre:4230:31051123,31051161:autre:4230:31051250,31051369:autre:4230:31051499,31051619:autre:4230:31051724,31051831:autre:4230:31051921,31051832:autre:4230:31051962,31052141:autre:4230:31052240,31052386:autre:4230:31052563,31052637:autre:4230:31052773,31052881:autre:4230:31052977,31053093:autre:4230:31053205,31053354:autre:4230:31053488,31053637:autre:4230:31053688,31053845:autre:4230:31053861,31054024:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.022152304656919145, 'nb_photo': 4813, 'list_port_cont': '31046945,31046981,31047018,31047054,31047088,31047124,31047163,31047386,31047522,31047700,31047821,31048220,31048258,31048405,31048832,31048870,31049781,31049994,31050283,31050492,31050847,31051131,31051263,31051500,31051725,31051929,31051963,31052235,31052559,31052769,31052986,31053209,31053490,31053698,31053875,31054166,31054459,31054677,31054981,31055234,31055515,31055721,31055914,31056142,31056449,31056700,31056830,31057111,31057356,31057572,31057621,31057920,31058134,31058415,31058584,31058882,31059130,31059345,31059590,31059812,31060062,31060290,31060605,31060798,31061048,31061255,31061500,31061794,31062037,31062158,31062365,31062643,31062890,31063129,31063166,31063566,31063607,31063797,31064036,31064217,31064454,31064835,31065093,31065372,31065601,31065916,31066115,31066326,31066583,31066782,31067204,31067322,31067491,31067684,31070230,31070572,31070745,31071041,31071382,31071416,31071629,31071837,31072047,31072266,31072509,31072714,31072922,31073215,31074410,31075170,31075543,31075785,31076003,3107625', 'assoc_port': '31045064:31046981,31045065:31046945,31045066:31047054,31045067:31047018,31045068:31047088,31045069:31047124,31045070:31047163,31047221:31047386,31047411:31047522,31047563:31047700,31047764:31047821,31048153:31048258,31048154:31048220,31048361:31048405,31048780:31048832,31048781:31048870,31049690:31049781,31049896:31049994,31050101:31050283,31050349:31050492,31050595:31050847,31050889:31051131,31051161:31051263,31051369:31051500,31051619:31051725,31051831:31051929,31051832:31051963,31052141:31052235,31052386:31052559,31052637:31052769,31052881:31052986,31053093:31053209,31053354:31053490,31053637:31053698,31053845:31053875,31054024:31054166,31054317:31054459,31054570:31054677,31054830:31054981,31055090:31055234,31055336:31055515,31055582:31055721,31055822:31055914,31056061:31056142,31056321:31056449,31056564:31056700,31056806:31056830,31057014:31057111,31057266:31057356,31057481:31057621,31057482:31057572,31057787:31057920,31058031:31058134,31058277:31058415,31058525:31058584,31058771:31058882,31058993:3105913', 'assoc_mat': '31045064:carton:4230:31046981,31045065:carton:4230:31046945,31045066:carton:4230:31047054,31045067:carton:4230:31047018,31045068:carton:4230:31047088,31045069:carton:4230:31047124,31045070:carton:4230:31047163,31047221:carton:4230:31047386,31047411:carton:4230:31047522,31047563:carton:4230:31047700,31047764:carton:4230:31047821,31048153:carton:4230:31048258,31048154:carton:4230:31048220,31048361:carton:4230:31048405,31048780:carton:4230:31048832,31048781:carton:4230:31048870,31049690:carton:4230:31049781,31049896:carton:4230:31049994,31050101:carton:4230:31050283,31050349:carton:4230:31050492,31050595:carton:4230:31050847,31050889:carton:4230:31051131,31051161:carton:4230:31051263,31051369:carton:4230:31051500,31051619:carton:4230:31051725,31051831:carton:4230:31051929,31051832:carton:4230:31051963,31052141:carton:4230:31052235,31052386:carton:4230:31052559,31052637:carton:4230:31052769,31052881:carton:4230:31052986,31053093:carton:4230:31053209,31053354:carton:4230:31053490,31053637:carton:4230:31053698,3105'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.000575015460073561, 'nb_photo': 66, 'list_port_cont': '31046932,31046969,31047004,31047079,31047122,31047381,31048222,31048252,31050272,31050488,31050858,31051130,31051247,31051511,31051713,31051964,31052242,31052554,31052777,31052972,31053193,31054167,31054453,31054979,31055719,31056125,31056460,31056701,31061038,31061243,31061501,31061787,31062024,31071371,31076671,31080405,31082662,31089926,31098683,31098885', 'assoc_port': '31045064:31046969,31045065:31046932,31045067:31047004,31045068:31047079,31045069:31047122,31047221:31047381,31048153:31048252,31048154:31048222,31050101:31050272,31050349:31050488,31050595:31050858,31050889:31051130,31051161:31051247,31051369:31051511,31051619:31051713,31051832:31051964,31052141:31052242,31052386:31052554,31052637:31052777,31052881:31052972,31053093:31053193,31054024:31054167,31054317:31054453,31054830:31054979,31055582:31055719,31056061:31056125,31056321:31056460,31056564:31056701,31060952:31061038,31061195:31061243,31061404:31061501,31061645:31061787,31061901:31062024,31071324:31071371,31076569:31076671,31080311:31080405,31082601:31082662,31089899:31089926,31098522:31098683,31098761:31098885', 'assoc_mat': '31045064:metal:4230:31046969,31045065:metal:4230:31046932,31045067:metal:4230:31047004,31045068:metal:4230:31047079,31045069:metal:4230:31047122,31047221:metal:4230:31047381,31048153:metal:4230:31048252,31048154:metal:4230:31048222,31050101:metal:4230:31050272,31050349:metal:4230:31050488,31050595:metal:4230:31050858,31050889:metal:4230:31051130,31051161:metal:4230:31051247,31051369:metal:4230:31051511,31051619:metal:4230:31051713,31051832:metal:4230:31051964,31052141:metal:4230:31052242,31052386:metal:4230:31052554,31052637:metal:4230:31052777,31052881:metal:4230:31052972,31053093:metal:4230:31053193,31054024:metal:4230:31054167,31054317:metal:4230:31054453,31054830:metal:4230:31054979,31055582:metal:4230:31055719,31056061:metal:4230:31056125,31056321:metal:4230:31056460,31056564:metal:4230:31056701,31060952:metal:4230:31061038,31061195:metal:4230:31061243,31061404:metal:4230:31061501,31061645:metal:4230:31061787,31061901:metal:4230:31062024,31071324:metal:4230:31071371,31076569:metal:4230:31076671,31080311:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.12943859176534755, 'nb_photo': 22986, 'list_port_cont': '31046943,31046978,31047012,31047050,31047091,31047126,31047158,31047385,31047526,31047699,31047819,31048213,31048253,31048411,31048834,31048872,31049788,31049997,31050274,31050493,31050851,31051134,31051259,31051512,31051722,31051930,31051971,31052241,31052555,31052770,31052978,31053199,31053494,31053700,31053877,31054159,31054456,31054687,31054983,31055230,31055512,31055718,31055919,31056138,31056459,31056691,31056831,31057118,31057363,31057585,31057620,31057917,31058133,31058401,31058586,31058879,31059125,31059346,31059589,31059811,31060068,31060295,31060598,31060814,31061053,31061254,31061498,31061792,31062031,31062154,31062373,31062649,31062888,31063120,31063167,31063569,31063606,31063791,31064038,31064221,31064457,31064838,31065084,31065377,31065608,31065914,31066124,31066327,31066582,31066781,31067208,31067310,31067482,31067677,31067972,31070225,31070571,31070749,31071043,31071384,31071422,31071624,31071844,31072046,31072262,31072505,31072709,31072915,31073209,31073415,31073694,31073731,31074130,3107417', 'assoc_port': '31045064:31046978,31045065:31046943,31045066:31047050,31045067:31047012,31045068:31047091,31045069:31047126,31045070:31047158,31047221:31047385,31047411:31047526,31047563:31047699,31047764:31047819,31048153:31048253,31048154:31048213,31048361:31048411,31048780:31048834,31048781:31048872,31049690:31049788,31049896:31049997,31050101:31050274,31050349:31050493,31050595:31050851,31050889:31051134,31051161:31051259,31051369:31051512,31051619:31051722,31051831:31051930,31051832:31051971,31052141:31052241,31052386:31052555,31052637:31052770,31052881:31052978,31053093:31053199,31053354:31053494,31053637:31053700,31053845:31053877,31054024:31054159,31054317:31054456,31054570:31054687,31054830:31054983,31055090:31055230,31055336:31055512,31055582:31055718,31055822:31055919,31056061:31056138,31056321:31056459,31056564:31056691,31056806:31056831,31057014:31057118,31057266:31057363,31057481:31057620,31057482:31057585,31057787:31057917,31058031:31058133,31058277:31058401,31058525:31058586,31058771:31058879,31058993:3105912', 'assoc_mat': '31045064:papier:4230:31046978,31045065:papier:4230:31046943,31045066:papier:4230:31047050,31045067:papier:4230:31047012,31045068:papier:4230:31047091,31045069:papier:4230:31047126,31045070:papier:4230:31047158,31047221:papier:4230:31047385,31047411:papier:4230:31047526,31047563:papier:4230:31047699,31047764:papier:4230:31047819,31048153:papier:4230:31048253,31048154:papier:4230:31048213,31048361:papier:4230:31048411,31048780:papier:4230:31048834,31048781:papier:4230:31048872,31049690:papier:4230:31049788,31049896:papier:4230:31049997,31050101:papier:4230:31050274,31050349:papier:4230:31050493,31050595:papier:4230:31050851,31050889:papier:4230:31051134,31051161:papier:4230:31051259,31051369:papier:4230:31051512,31051619:papier:4230:31051722,31051831:papier:4230:31051930,31051832:papier:4230:31051971,31052141:papier:4230:31052241,31052386:papier:4230:31052555,31052637:papier:4230:31052770,31052881:papier:4230:31052978,31053093:papier:4230:31053199,31053354:papier:4230:31053494,31053637:papier:4230:31053700,3105'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017128752535139214, 'nb_photo': 144, 'list_port_cont': '31046982,31047017,31047053,31047085,31047116,31047148,31047389,31047525,31047817,31048219,31049995,31050281,31050494,31050852,31051135,31051262,31051509,31051927,31052776,31054682,31054977,31055233,31055709,31056458,31056822,31057116,31057623,31058402,31059127,31059337,31059592,31059809,31060287,31060610,31061049,31061793,31066121,31067490,31071625,31071832,31072716,31072924,31076004,31076415,31076840,31077118,31077329,31077576,31081238,31081441,31082420,31082676,31083085,31085827,31086079,31086297,31086548,31086788,31087079,31087305,31087426,31087656,31087926,31088146,31088342,31091127,31091656,31091870,31092311,31092758,31092997,31093245,31093516,31096669,31096888,31097310,31097678,31097866,31098173,31098901', 'assoc_port': '31045064:31046982,31045066:31047053,31045067:31047017,31045068:31047085,31045069:31047116,31045070:31047148,31047221:31047389,31047411:31047525,31047764:31047817,31048154:31048219,31049896:31049995,31050101:31050281,31050349:31050494,31050595:31050852,31050889:31051135,31051161:31051262,31051369:31051509,31051831:31051927,31052637:31052776,31054570:31054682,31054830:31054977,31055090:31055233,31055582:31055709,31056321:31056458,31056806:31056822,31057014:31057116,31057481:31057623,31058277:31058402,31058993:31059127,31059241:31059337,31059487:31059592,31059702:31059809,31060218:31060287,31060475:31060610,31060952:31061049,31061645:31061793,31066058:31066121,31067426:31067490,31071531:31071625,31071776:31071832,31072690:31072716,31072862:31072924,31075971:31076004,31076396:31076415,31076813:31076840,31077024:31077118,31077260:31077329,31077517:31077576,31081206:31081238,31081381:31081441,31082359:31082420,31082601:31082676,31083018:31083085,31085732:31085827,31085975:31086079,31086223:31086297,31086481:3108654', 'assoc_mat': '31045064:pehd:4230:31046982,31045066:pehd:4230:31047053,31045067:pehd:4230:31047017,31045068:pehd:4230:31047085,31045069:pehd:4230:31047116,31045070:pehd:4230:31047148,31047221:pehd:4230:31047389,31047411:pehd:4230:31047525,31047764:pehd:4230:31047817,31048154:pehd:4230:31048219,31049896:pehd:4230:31049995,31050101:pehd:4230:31050281,31050349:pehd:4230:31050494,31050595:pehd:4230:31050852,31050889:pehd:4230:31051135,31051161:pehd:4230:31051262,31051369:pehd:4230:31051509,31051831:pehd:4230:31051927,31052637:pehd:4230:31052776,31054570:pehd:4230:31054682,31054830:pehd:4230:31054977,31055090:pehd:4230:31055233,31055582:pehd:4230:31055709,31056321:pehd:4230:31056458,31056806:pehd:4230:31056822,31057014:pehd:4230:31057116,31057481:pehd:4230:31057623,31058277:pehd:4230:31058402,31058993:pehd:4230:31059127,31059241:pehd:4230:31059337,31059487:pehd:4230:31059592,31059702:pehd:4230:31059809,31060218:pehd:4230:31060287,31060475:pehd:4230:31060610,31060952:pehd:4230:31061049,31061645:pehd:4230:31061793,31066058:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017688344174203955, 'nb_photo': 1878, 'list_port_cont': '31046946,31046980,31047014,31047048,31047083,31047119,31047161,31047379,31047523,31047702,31047813,31048224,31048260,31048410,31048831,31048871,31049784,31049998,31050282,31050485,31050856,31051128,31051256,31051507,31051709,31051928,31051967,31052238,31052556,31052772,31052981,31053208,31053496,31053689,31053876,31054164,31054458,31054683,31054982,31055223,31055513,31055713,31055912,31056137,31056454,31056694,31056827,31057110,31057366,31057581,31057622,31058131,31058583,31058870,31059131,31059334,31059581,31059810,31060064,31060284,31060611,31060800,31061055,31061249,31061502,31061796,31062040,31062162,31062369,31062640,31065380,31065924,31066118,31066324,31066572,31066776,31067212,31067311,31067486,31071386,31071420,31071622,31071841,31072041,31072267,31072511,31072706,31075796,31076002,31076253,31076410,31076672,31076838,31077119,31077327,31077853,31081237,31081438,31081689,31082009,31082172,31082410,31082669,31082909,31083082,31083292,31083534,31085551,31085829,31086075,31086292,31086547,31086783,3108708', 'assoc_port': '31045064:31046980,31045065:31046946,31045066:31047048,31045067:31047014,31045068:31047083,31045069:31047119,31045070:31047161,31047221:31047379,31047411:31047523,31047563:31047702,31047764:31047813,31048153:31048260,31048154:31048224,31048361:31048410,31048780:31048831,31048781:31048871,31049690:31049784,31049896:31049998,31050101:31050282,31050349:31050485,31050595:31050856,31050889:31051128,31051161:31051256,31051369:31051507,31051619:31051709,31051831:31051928,31051832:31051967,31052141:31052238,31052386:31052556,31052637:31052772,31052881:31052981,31053093:31053208,31053354:31053496,31053637:31053689,31053845:31053876,31054024:31054164,31054317:31054458,31054570:31054683,31054830:31054982,31055090:31055223,31055336:31055513,31055582:31055713,31055822:31055912,31056061:31056137,31056321:31056454,31056564:31056694,31056806:31056827,31057014:31057110,31057266:31057366,31057481:31057622,31057482:31057581,31058031:31058131,31058525:31058583,31058771:31058870,31058993:31059131,31059241:31059334,31059487:3105958', 'assoc_mat': '31045064:pet_clair:4230:31046980,31045065:pet_clair:4230:31046946,31045066:pet_clair:4230:31047048,31045067:pet_clair:4230:31047014,31045068:pet_clair:4230:31047083,31045069:pet_clair:4230:31047119,31045070:pet_clair:4230:31047161,31047221:pet_clair:4230:31047379,31047411:pet_clair:4230:31047523,31047563:pet_clair:4230:31047702,31047764:pet_clair:4230:31047813,31048153:pet_clair:4230:31048260,31048154:pet_clair:4230:31048224,31048361:pet_clair:4230:31048410,31048780:pet_clair:4230:31048831,31048781:pet_clair:4230:31048871,31049690:pet_clair:4230:31049784,31049896:pet_clair:4230:31049998,31050101:pet_clair:4230:31050282,31050349:pet_clair:4230:31050485,31050595:pet_clair:4230:31050856,31050889:pet_clair:4230:31051128,31051161:pet_clair:4230:31051256,31051369:pet_clair:4230:31051507,31051619:pet_clair:4230:31051709,31051831:pet_clair:4230:31051928,31051832:pet_clair:4230:31051967,31052141:pet_clair:4230:31052238,31052386:pet_clair:4230:31052556,31052637:pet_clair:4230:31052772,31052881:pet_clair:4230:31052981,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018814295852732114, 'nb_photo': 81, 'list_port_cont': '31046934,31046979,31047156,31048248,31050277,31050496,31050857,31051138,31051258,31051934,31052771,31053489,31053702,31054450,31054684,31056451,31056687,31056828,31059799,31060071,31060603,31060805,31061046,31061245,31066574,31075787,31076416,31076666,31076833,31082010,31082174,31082668,31082912,31085835,31086078,31086288,31086540,31087438,31091396,31091866,31092313,31092509,31096672,31097315,31097669', 'assoc_port': '31045064:31046979,31045065:31046934,31045070:31047156,31048153:31048248,31050101:31050277,31050349:31050496,31050595:31050857,31050889:31051138,31051161:31051258,31051831:31051934,31052637:31052771,31053354:31053489,31053637:31053702,31054317:31054450,31054570:31054684,31056321:31056451,31056564:31056687,31056806:31056828,31059702:31059799,31059963:31060071,31060475:31060603,31060713:31060805,31060952:31061046,31061195:31061245,31066519:31066574,31075729:31075787,31076396:31076416,31076569:31076666,31076813:31076833,31081872:31082010,31082112:31082174,31082601:31082668,31082816:31082912,31085732:31085835,31085975:31086078,31086223:31086288,31086481:31086540,31087413:31087438,31091303:31091396,31091805:31091866,31092252:31092313,31092493:31092509,31096537:31096672,31097067:31097315,31097457:31097669', 'assoc_mat': '31045064:pet_fonce:4230:31046979,31045065:pet_fonce:4230:31046934,31045070:pet_fonce:4230:31047156,31048153:pet_fonce:4230:31048248,31050101:pet_fonce:4230:31050277,31050349:pet_fonce:4230:31050496,31050595:pet_fonce:4230:31050857,31050889:pet_fonce:4230:31051138,31051161:pet_fonce:4230:31051258,31051831:pet_fonce:4230:31051934,31052637:pet_fonce:4230:31052771,31053354:pet_fonce:4230:31053489,31053637:pet_fonce:4230:31053702,31054317:pet_fonce:4230:31054450,31054570:pet_fonce:4230:31054684,31056321:pet_fonce:4230:31056451,31056564:pet_fonce:4230:31056687,31056806:pet_fonce:4230:31056828,31059702:pet_fonce:4230:31059799,31059963:pet_fonce:4230:31060071,31060475:pet_fonce:4230:31060603,31060713:pet_fonce:4230:31060805,31060952:pet_fonce:4230:31061046,31061195:pet_fonce:4230:31061245,31066519:pet_fonce:4230:31066574,31075729:pet_fonce:4230:31075787,31076396:pet_fonce:4230:31076416,31076569:pet_fonce:4230:31076666,31076813:pet_fonce:4230:31076833,31081872:pet_fonce:4230:31082010,31082112:pet_fonce:4230:31082174,3'}), 'main_stat': {'nb_photos': 575}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31048697,31048698,31048699,31048700,31048701,31048702,31048703?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-08', 0.9268715718800284),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_08_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%', 1543], 'carton': ['carton', '2.22%', 4813], 'metal': ['metal', '0.06%', 66], 'papier': ['papier', '12.94%', 22986], 'pehd': ['pehd', '0.17%', 144], 'pet_clair': ['pet_clair', '1.77%', 1878], 'pet_fonce': ['pet_fonce', '0.19%', 81]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_08_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.28user 2.83system 0:08.94elapsed 57%CPU (0avgtext+0avgdata 190268maxresident)k 127224inputs+280outputs (651major+53691minor)pagefaults 0swaps