python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --job=sla_mensuel --raspi=20092 --dashboard_places=refus_amiens --rootfolder_sla=/data_2/data_log/job/memo/refus_amiens -v --mtr_id=983 --date=`date -d"$nowdate 1 day ago" +%Y-%m` ' -s sla_mensuel -M 0 -S 0 -U 90,80,95
 import MySQLdb succeeded 
Import error (python version)
Need env var : LOGRASPI
Raspi : 20092, Date : 2025-05
 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py
 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py
warning , we can't find thcl infos in json_data
warning , we can't find pdt infos in json_data
 nb_day : (3, 31)
 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 !
 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 !
 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 !
 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 !
 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 !
 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 !
 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 !
SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142

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=3142
 
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= 3142
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=3142
# 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=3996

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=3996
 
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= 3996
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=3996
# 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 !
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 10383 mask_detect is not consistent : 3 used against 2 in the step definition !
WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition !
WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition !
Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used !
Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition !
WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition !
WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition !
Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used !
Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used !
Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10385 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 2 of step 10383 doesn't seem to be define in the database(
WARNING : type of input 2 of step 10387 doesn't seem to be define in the database(
WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7
WARNING : type of output 2 of step 10390 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10384 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 1 of step 10391 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of output 1 of step 10392 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of input 5 of step 10393 doesn't seem to be define in the database(
WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None
WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18
WARNING : type of output 3 of step 11838 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 2 of step 11838 doesn't seem to be define in the database(
WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None
WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2
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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}}
Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier 
TODO : Insert select and so on
SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="refus_amiens";
SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142

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=3142
 
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= 3142
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=3142
# 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=3996

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=3996
 
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= 3996
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=3996
# 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 !
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 10383 mask_detect is not consistent : 3 used against 2 in the step definition !
WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition !
WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition !
Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used !
Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition !
WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition !
WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition !
Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used !
Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used !
Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10385 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 2 of step 10383 doesn't seem to be define in the database(
WARNING : type of input 2 of step 10387 doesn't seem to be define in the database(
WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7
WARNING : type of output 2 of step 10390 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10384 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 1 of step 10391 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of output 1 of step 10392 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of input 5 of step 10393 doesn't seem to be define in the database(
WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None
WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18
WARNING : type of output 3 of step 11838 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 2 of step 11838 doesn't seem to be define in the database(
WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None
WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2
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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}}
Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier 
   Fonction SLA_MENSUEL   
 nb_day : (3, 31)
 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 !
 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 !
 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 !
 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 !
 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 !
 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 !
 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 !
SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142

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=3142
 
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= 3142
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=3142
# 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=3996

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=3996
 
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= 3996
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=3996
# 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 !
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 10383 mask_detect is not consistent : 3 used against 2 in the step definition !
WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition !
WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition !
Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used !
Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition !
WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition !
WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition !
Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used !
Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used !
Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10385 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 2 of step 10383 doesn't seem to be define in the database(
WARNING : type of input 2 of step 10387 doesn't seem to be define in the database(
WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7
WARNING : type of output 2 of step 10390 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10384 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 1 of step 10391 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of output 1 of step 10392 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of input 5 of step 10393 doesn't seem to be define in the database(
WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None
WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18
WARNING : type of output 3 of step 11838 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 2 of step 11838 doesn't seem to be define in the database(
WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None
WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2
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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}}
Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier 
TODO : Insert select and so on
SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="refus_amiens";
SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142

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=3142
 
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= 3142
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=3142
# 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=3996

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=3996
 
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= 3996
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=3996
# 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 !
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 10383 mask_detect is not consistent : 3 used against 2 in the step definition !
WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition !
WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition !
Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used !
Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition !
WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition !
WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition !
Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used !
Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used !
Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10385 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 2 of step 10383 doesn't seem to be define in the database(
WARNING : type of input 2 of step 10387 doesn't seem to be define in the database(
WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7
WARNING : type of output 2 of step 10390 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10384 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 1 of step 10391 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of output 1 of step 10392 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of input 5 of step 10393 doesn't seem to be define in the database(
WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None
WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18
WARNING : type of output 3 of step 11838 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 2 of step 11838 doesn't seem to be define in the database(
WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None
WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2
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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}}
Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier 
place_id : 15
month : 05
mtr_id : 983
dashboard_places : refus_amiens
date : 2025-05
year : 2025
raspi : 20092
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 = 'refus_amiens' and date like '%2025-05%') and created_at like '%2025-05%')));
 nb_day : (3, 31)
after unwanted_material_data
 nb_day : (3, 31)
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
WARNING: No hour configured for port 20092, from 00:00 to 24:00 used
SQL: SELECT ms.id, ms.name, mst.name as type, ms.test_group, ms.test_name, ms.server, ms.version_code, ms.result_str, ms.result_bool, ms.result_float, ms.lien, ms.created_at FROM MTRAdmin.monitor_sys ms
                 INNER JOIN MTRAdmin.monitor_sys_type mst on mst.id = ms.type 
                 WHERE ms.test_name like '%20092%' AND ms.result_str like '%2025/05%'ORDER BY ms.id desc LIMIT 0, 1000000;
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
Missing day sla_per_day needs to be called !
 We will need to call the sla_per_day for these missing days : 2025-05-01 00:00:00,2025-05-02 00:00:00,2025-05-03 00:00:00,2025-05-04 00:00:00,2025-05-05 00:00:00,2025-05-06 00:00:00,2025-05-07 00:00:00,2025-05-08 00:00:00,2025-05-09 00:00:00,2025-05-10 00:00:00,2025-05-11 00:00:00,2025-05-12 00:00:00,2025-05-13 00:00:00,2025-05-14 00:00:00,2025-05-15 00:00:00,2025-05-16 00:00:00,2025-05-17 00:00:00,2025-05-18 00:00:00,2025-05-19 00:00:00,2025-05-20 00:00:00,2025-05-21 00:00:00,2025-05-22 00:00:00,2025-05-23 00:00:00,2025-05-24 00:00:00,2025-05-25 00:00:00,2025-05-26 00:00:00,2025-05-27 00:00:00,2025-05-28 00:00:00,2025-05-29 00:00:00,2025-05-30 00:00:00,2025-05-31 00:00:00
after coverage_data
SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 15 and month(ded.date) = 05 and year(ded.date) = 2025 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), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______refus' and ded.dashboard_place_id = 15 and month(ded.date) = 05 and year(ded.date) = 2025 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 = 15 and mp.name like '%052025%' and cps.thcl =  1533 GROUP BY sbstr ;
after number_of_batch
 date_start : 2025-05-01 :  <class 'str'>
 dt_date_just_month_year : 2025-05-01 00:00:00 :  <class 'datetime.datetime'>
 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= "refus_amiens"
            AND ded.dashboard_place_id=dp.id
            AND dri.dashboard_entry_day=ded.id
            AND dri.id=ded.last_run_id AND ded.date >= "2025-05-01" AND ded.date <= "2025-05-31"
apple3 {'refus': {'mat': 'refus', 'pht': 4213, 'datou_carac_id': 3996, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus,textiles_sanitaires'}}
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  (1773498,1777713,1780296,1780797,1785149,1789244,1793701,1797447,1801614,1803940,1804123,1807766,1811943,1815767,1819848,1823398,1824223)
                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': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003641112539478753, 'nb_photo': 2389, 'list_port_cont': '22580010,22580043,22580115,22580178,22580222,22580257,22580416,22582243,22583129,22583684,22584191,22584425,22587513,22588842,22588863,22592645,22593036,22593299,22593422,22593998,22594592,22594689,22594734,22596520,22599105,22602843,22603242,22603468,22604467,22606579,22608670,22611334,22614649,22617807,22618851,22621650,22624669,22628740,22630441,22637409,22637571,22637622,22637930,22638030,22638255,22639904,22640091,22640255,22640881,22640993,22642222,22643458,22644074,22645072,22645488,22646598,22646641,22646903,22647439,22650056,22650103,22650136,22655234,22655272,22655280,22655331,22655434,22655475,22655514,22655546,22655574,22655621,22655656,22655686,22655717,22655748,22655816,22655859,22655891,22655915,22655931,22655994,22656024,22656051,22656537,22656582,22660237,22661093,22661181,22661447,22661547,22661670,22661824,22664210,22665881,22668590,22670464,22671814,22673939,22675613,22684061,22686520,22686723,22689806,22690591,22693323,22696068,22701714,22701743,22702431,22708286,22708479,22708703,2270894', 'assoc_port': '22579895:22580222,22579896:22580257,22579897:22580115,22579898:22580178,22579899:22580010,22579900:22580043,22580332:22580416,22582223:22582243,22583005:22583129,22583532:22583684,22584171:22584191,22584408:22584425,22587177:22587513,22588823:22588863,22588824:22588842,22591685:22594734,22591686:22593036,22591687:22593299,22591688:22593422,22591689:22594592,22591690:22592645,22593666:22594689,22593667:22593998,22596387:22596520,22598767:22599105,22602554:22602843,22603023:22603468,22603025:22603242,22604316:22604467,22606121:22606579,22608596:22608670,22610993:22611334,22614519:22614649,22617416:22617807,22618639:22618851,22621383:22621650,22624122:22624669,22628398:22628740,22630325:22630441,22637348:22640881,22637349:22638030,22637350:22637930,22637351:22637622,22637352:22637409,22637353:22637571,22637992:22638255,22639304:22639904,22639971:22640255,22639972:22640091,22640911:22640993,22641870:22642222,22643360:22643458,22643978:22644074,22644963:22645072,22645331:22645488,22646470:22646641,22646471:2264659', 'assoc_mat': '22579895:barquette_opaque:4213:22580222,22579896:barquette_opaque:4213:22580257,22579897:barquette_opaque:4213:22580115,22579898:barquette_opaque:4213:22580178,22579899:barquette_opaque:4213:22580010,22579900:barquette_opaque:4213:22580043,22580332:barquette_opaque:4213:22580416,22582223:barquette_opaque:4213:22582243,22583005:barquette_opaque:4213:22583129,22583532:barquette_opaque:4213:22583684,22584171:barquette_opaque:4213:22584191,22584408:barquette_opaque:4213:22584425,22587177:barquette_opaque:4213:22587513,22588823:barquette_opaque:4213:22588863,22588824:barquette_opaque:4213:22588842,22591685:barquette_opaque:4213:22594734,22591686:barquette_opaque:4213:22593036,22591687:barquette_opaque:4213:22593299,22591688:barquette_opaque:4213:22593422,22591689:barquette_opaque:4213:22594592,22591690:barquette_opaque:4213:22592645,22593666:barquette_opaque:4213:22594689,22593667:barquette_opaque:4213:22593998,22596387:barquette_opaque:4213:22596520,22598767:barquette_opaque:4213:22599105,22602554:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.002438628733274117, 'nb_photo': 2332, 'list_port_cont': '22579999,22580039,22580087,22580125,22580176,22580209,22580248,22580426,22582240,22583687,22584192,22584429,22587521,22588829,22588866,22592646,22593051,22593305,22593432,22594004,22594593,22594691,22594730,22596519,22599097,22602853,22603250,22603482,22604481,22606576,22608649,22611339,22614658,22617812,22618863,22621640,22624673,22628745,22630438,22637413,22637564,22637625,22637919,22638035,22638243,22639905,22640256,22640882,22640994,22642223,22643454,22644070,22645073,22645499,22645748,22646595,22646631,22646909,22650068,22650102,22650121,22655233,22655274,22655290,22655342,22655436,22655479,22655487,22655549,22655577,22655611,22655640,22655690,22655714,22655749,22655818,22655850,22655884,22655918,22655943,22655984,22656032,22656065,22656546,22656590,22660241,22661089,22661193,22661446,22661561,22661656,22661834,22664213,22665885,22668603,22670470,22671809,22673933,22675608,22684071,22686528,22686724,22689810,22690594,22693338,22701712,22701750,22702434,22708294,22708484,22708701,22708939,22709179,2270921', 'assoc_port': '22579895:22580209,22579896:22580248,22579897:22580125,22579898:22580176,22579899:22579999,22579900:22580039,22579901:22580087,22580332:22580426,22582223:22582240,22583532:22583687,22584171:22584192,22584408:22584429,22587177:22587521,22588823:22588866,22588824:22588829,22591685:22594730,22591686:22593051,22591687:22593305,22591688:22593432,22591689:22594593,22591690:22592646,22593666:22594691,22593667:22594004,22596387:22596519,22598767:22599097,22602554:22602853,22603023:22603482,22603025:22603250,22604316:22604481,22606121:22606576,22608596:22608649,22610993:22611339,22614519:22614658,22617416:22617812,22618639:22618863,22621383:22621640,22624122:22624673,22628398:22628745,22630325:22630438,22637348:22640882,22637349:22638035,22637350:22637919,22637351:22637625,22637352:22637413,22637353:22637564,22637992:22638243,22639304:22639905,22639971:22640256,22640911:22640994,22641870:22642223,22643360:22643454,22643978:22644070,22644963:22645073,22645331:22645499,22645717:22645748,22646470:22646631,22646471:2264659', 'assoc_mat': '22579895:carton:4213:22580209,22579896:carton:4213:22580248,22579897:carton:4213:22580125,22579898:carton:4213:22580176,22579899:carton:4213:22579999,22579900:carton:4213:22580039,22579901:carton:4213:22580087,22580332:carton:4213:22580426,22582223:carton:4213:22582240,22583532:carton:4213:22583687,22584171:carton:4213:22584192,22584408:carton:4213:22584429,22587177:carton:4213:22587521,22588823:carton:4213:22588866,22588824:carton:4213:22588829,22591685:carton:4213:22594730,22591686:carton:4213:22593051,22591687:carton:4213:22593305,22591688:carton:4213:22593432,22591689:carton:4213:22594593,22591690:carton:4213:22592646,22593666:carton:4213:22594691,22593667:carton:4213:22594004,22596387:carton:4213:22596519,22598767:carton:4213:22599097,22602554:carton:4213:22602853,22603023:carton:4213:22603482,22603025:carton:4213:22603250,22604316:carton:4213:22604481,22606121:carton:4213:22606576,22608596:carton:4213:22608649,22610993:carton:4213:22611339,22614519:carton:4213:22614658,22617416:carton:4213:22617812,2261'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003577989831983466, 'nb_photo': 755, 'list_port_cont': '22579998,22580078,22580123,22580188,22580221,22580253,22580410,22583676,22584205,22584416,22587493,22588844,22588869,22592642,22593039,22593304,22593418,22594003,22594600,22594696,22594731,22596532,22599091,22602847,22603470,22604473,22606573,22611348,22614644,22617813,22618862,22621656,22624676,22628751,22630436,22637412,22637567,22637917,22638043,22638242,22639900,22640264,22640883,22640992,22642214,22643453,22645067,22645494,22646605,22646900,22650053,22650087,22650130,22655226,22655300,22655341,22655495,22655583,22655612,22655651,22655677,22655823,22655861,22655883,22655996,22656029,22656539,22656584,22660244,22661100,22661194,22661450,22661560,22661664,22661836,22664203,22665882,22673930,22675597,22684067,22686518,22686718,22689803,22696061,22701708,22701737,22702430,22708299,22708487,22708702,22708946,22709183,22709606,22710947,22712052,22713520,22714654,22715481,22718170,22721916,22724281,22726176,22728141,22729461,22730948,22735996,22745058,22753925,22754728,22754910,22755128,22755329,22758377,2276016', 'assoc_port': '22579895:22580221,22579896:22580253,22579897:22580123,22579898:22580188,22579899:22579998,22579901:22580078,22580332:22580410,22583532:22583676,22584171:22584205,22584408:22584416,22587177:22587493,22588823:22588869,22588824:22588844,22591685:22594731,22591686:22593039,22591687:22593304,22591688:22593418,22591689:22594600,22591690:22592642,22593666:22594696,22593667:22594003,22596387:22596532,22598767:22599091,22602554:22602847,22603023:22603470,22604316:22604473,22606121:22606573,22610993:22611348,22614519:22614644,22617416:22617813,22618639:22618862,22621383:22621656,22624122:22624676,22628398:22628751,22630325:22630436,22637348:22640883,22637349:22638043,22637350:22637917,22637352:22637412,22637353:22637567,22637992:22638242,22639304:22639900,22639971:22640264,22640911:22640992,22641870:22642214,22643360:22643453,22644963:22645067,22645331:22645494,22646471:22646605,22646800:22646900,22649978:22650053,22649979:22650130,22649980:22650087,22655128:22655583,22655129:22655612,22655130:22655883,22655152:2265602', 'assoc_mat': '22579895:ela:4213:22580221,22579896:ela:4213:22580253,22579897:ela:4213:22580123,22579898:ela:4213:22580188,22579899:ela:4213:22579998,22579901:ela:4213:22580078,22580332:ela:4213:22580410,22583532:ela:4213:22583676,22584171:ela:4213:22584205,22584408:ela:4213:22584416,22587177:ela:4213:22587493,22588823:ela:4213:22588869,22588824:ela:4213:22588844,22591685:ela:4213:22594731,22591686:ela:4213:22593039,22591687:ela:4213:22593304,22591688:ela:4213:22593418,22591689:ela:4213:22594600,22591690:ela:4213:22592642,22593666:ela:4213:22594696,22593667:ela:4213:22594003,22596387:ela:4213:22596532,22598767:ela:4213:22599091,22602554:ela:4213:22602847,22603023:ela:4213:22603470,22604316:ela:4213:22604473,22606121:ela:4213:22606573,22610993:ela:4213:22611348,22614519:ela:4213:22614644,22617416:ela:4213:22617813,22618639:ela:4213:22618862,22621383:ela:4213:22621656,22624122:ela:4213:22624676,22628398:ela:4213:22628751,22630325:ela:4213:22630436,22637348:ela:4213:22640883,22637349:ela:4213:22638043,22637350:ela:4213:2263791'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003339989417732796, 'nb_photo': 3563, 'list_port_cont': '22580002,22580031,22580082,22580111,22580180,22580213,22580252,22580417,22582237,22583122,22583679,22584193,22584426,22587516,22588831,22588871,22592650,22593040,22593314,22593428,22594009,22594597,22594692,22594728,22596530,22599093,22602841,22603239,22603483,22604482,22606581,22608652,22611345,22614655,22617808,22618858,22621643,22624663,22628736,22630447,22637416,22637566,22637623,22637918,22638031,22638244,22639907,22640102,22640269,22640877,22640989,22642221,22643455,22644081,22645066,22645490,22645756,22646589,22646634,22646910,22647431,22650054,22650093,22650134,22655241,22655260,22655286,22655339,22655446,22655470,22655485,22655535,22655579,22655606,22655647,22655678,22655708,22655756,22655812,22655860,22655885,22655928,22655937,22655995,22656020,22656066,22656541,22656578,22660231,22661092,22661188,22661434,22661545,22661665,22661827,22664202,22665888,22668591,22670473,22671813,22673931,22675602,22684066,22686523,22686714,22689804,22690583,22693325,22696063,22701707,22701746,22702427,22708289,2270848', 'assoc_port': '22579895:22580213,22579896:22580252,22579897:22580111,22579898:22580180,22579899:22580002,22579900:22580031,22579901:22580082,22580332:22580417,22582223:22582237,22583005:22583122,22583532:22583679,22584171:22584193,22584408:22584426,22587177:22587516,22588823:22588871,22588824:22588831,22591685:22594728,22591686:22593040,22591687:22593314,22591688:22593428,22591689:22594597,22591690:22592650,22593666:22594692,22593667:22594009,22596387:22596530,22598767:22599093,22602554:22602841,22603023:22603483,22603025:22603239,22604316:22604482,22606121:22606581,22608596:22608652,22610993:22611345,22614519:22614655,22617416:22617808,22618639:22618858,22621383:22621643,22624122:22624663,22628398:22628736,22630325:22630447,22637348:22640877,22637349:22638031,22637350:22637918,22637351:22637623,22637352:22637416,22637353:22637566,22637992:22638244,22639304:22639907,22639971:22640269,22639972:22640102,22640911:22640989,22641870:22642221,22643360:22643455,22643978:22644081,22644963:22645066,22645331:22645490,22645717:2264575', 'assoc_mat': '22579895:etiquette:4213:22580213,22579896:etiquette:4213:22580252,22579897:etiquette:4213:22580111,22579898:etiquette:4213:22580180,22579899:etiquette:4213:22580002,22579900:etiquette:4213:22580031,22579901:etiquette:4213:22580082,22580332:etiquette:4213:22580417,22582223:etiquette:4213:22582237,22583005:etiquette:4213:22583122,22583532:etiquette:4213:22583679,22584171:etiquette:4213:22584193,22584408:etiquette:4213:22584426,22587177:etiquette:4213:22587516,22588823:etiquette:4213:22588871,22588824:etiquette:4213:22588831,22591685:etiquette:4213:22594728,22591686:etiquette:4213:22593040,22591687:etiquette:4213:22593314,22591688:etiquette:4213:22593428,22591689:etiquette:4213:22594597,22591690:etiquette:4213:22592650,22593666:etiquette:4213:22594692,22593667:etiquette:4213:22594009,22596387:etiquette:4213:22596530,22598767:etiquette:4213:22599093,22602554:etiquette:4213:22602841,22603023:etiquette:4213:22603483,22603025:etiquette:4213:22603239,22604316:etiquette:4213:22604482,22606121:etiquette:4213:22606581,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0321886213260326, 'nb_photo': 7883, 'list_port_cont': '22580005,22580037,22580077,22580114,22580185,22580210,22580255,22580423,22582239,22583120,22583678,22584204,22584413,22587517,22588837,22588865,22592652,22593041,22593307,22593424,22594008,22594594,22594688,22594726,22596527,22599090,22602846,22603249,22603476,22604471,22606580,22608654,22611337,22614654,22617816,22618849,22621653,22624668,22628749,22630446,22637418,22637570,22637618,22637932,22638032,22638252,22639909,22640088,22640261,22640878,22640996,22642215,22643443,22644079,22645070,22645502,22645755,22646599,22646639,22646905,22647437,22650063,22650098,22650124,22655235,22655267,22655277,22655343,22655440,22655476,22655497,22655540,22655575,22655615,22655655,22655681,22655720,22655758,22655828,22655856,22655896,22655920,22655942,22655998,22656021,22656056,22656553,22656577,22660235,22661105,22661196,22661435,22661557,22661671,22661840,22664217,22665887,22668588,22670460,22671801,22673943,22675603,22684070,22686522,22686720,22689800,22690582,22693335,22696056,22701703,22701738,22702425,22708290,2270848', 'assoc_port': '22579895:22580210,22579896:22580255,22579897:22580114,22579898:22580185,22579899:22580005,22579900:22580037,22579901:22580077,22580332:22580423,22582223:22582239,22583005:22583120,22583532:22583678,22584171:22584204,22584408:22584413,22587177:22587517,22588823:22588865,22588824:22588837,22591685:22594726,22591686:22593041,22591687:22593307,22591688:22593424,22591689:22594594,22591690:22592652,22593666:22594688,22593667:22594008,22596387:22596527,22598767:22599090,22602554:22602846,22603023:22603476,22603025:22603249,22604316:22604471,22606121:22606580,22608596:22608654,22610993:22611337,22614519:22614654,22617416:22617816,22618639:22618849,22621383:22621653,22624122:22624668,22628398:22628749,22630325:22630446,22637348:22640878,22637349:22638032,22637350:22637932,22637351:22637618,22637352:22637418,22637353:22637570,22637992:22638252,22639304:22639909,22639971:22640261,22639972:22640088,22640911:22640996,22641870:22642215,22643360:22643443,22643978:22644079,22644963:22645070,22645331:22645502,22645717:2264575', 'assoc_mat': '22579895:film_plastique:4213:22580210,22579896:film_plastique:4213:22580255,22579897:film_plastique:4213:22580114,22579898:film_plastique:4213:22580185,22579899:film_plastique:4213:22580005,22579900:film_plastique:4213:22580037,22579901:film_plastique:4213:22580077,22580332:film_plastique:4213:22580423,22582223:film_plastique:4213:22582239,22583005:film_plastique:4213:22583120,22583532:film_plastique:4213:22583678,22584171:film_plastique:4213:22584204,22584408:film_plastique:4213:22584413,22587177:film_plastique:4213:22587517,22588823:film_plastique:4213:22588865,22588824:film_plastique:4213:22588837,22591685:film_plastique:4213:22594726,22591686:film_plastique:4213:22593041,22591687:film_plastique:4213:22593307,22591688:film_plastique:4213:22593424,22591689:film_plastique:4213:22594594,22591690:film_plastique:4213:22592652,22593666:film_plastique:4213:22594688,22593667:film_plastique:4213:22594008,22596387:film_plastique:4213:22596527,22598767:film_plastique:4213:22599090,22602554:film_plastique:4213:2260284'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.00047712249075355245, 'nb_photo': 36, 'list_port_cont': '22580118,22580174,22580206,22588875,22593315,22594704,22637568,22637931,22655587,22656580,22660239,22668592,22712054,22730942,22797065,22841356,22862360,22865172,22866357,22869415,22869438,22869853,22895291,22895528,22916084,22934818,22945187,23059870,23088358,23088526,23089775,23094057', 'assoc_port': '22579895:22580206,22579897:22580118,22579898:22580174,22588823:22588875,22591687:22593315,22593666:22594704,22637350:22637931,22637353:22637568,22655128:22655587,22656474:22656580,22659811:22660239,22667573:22668592,22712013:22712054,22725839:22730942,22796993:22797065,22841223:22841356,22856557:22862360,22862213:22865172,22866275:22866357,22869341:22869853,22869353:22869415,22869361:22869438,22892622:22895291,22892627:22895528,22913801:22916084,22928767:22945187,22934624:22934818,23017071:23059870,23052804:23088358,23052807:23088526,23056886:23089775,23074784:23094057', 'assoc_mat': '22579895:kraft:4213:22580206,22579897:kraft:4213:22580118,22579898:kraft:4213:22580174,22588823:kraft:4213:22588875,22591687:kraft:4213:22593315,22593666:kraft:4213:22594704,22637350:kraft:4213:22637931,22637353:kraft:4213:22637568,22655128:kraft:4213:22655587,22656474:kraft:4213:22656580,22659811:kraft:4213:22660239,22667573:kraft:4213:22668592,22712013:kraft:4213:22712054,22725839:kraft:4213:22730942,22796993:kraft:4213:22797065,22841223:kraft:4213:22841356,22856557:kraft:4213:22862360,22862213:kraft:4213:22865172,22866275:kraft:4213:22866357,22869341:kraft:4213:22869853,22869353:kraft:4213:22869415,22869361:kraft:4213:22869438,22892622:kraft:4213:22895291,22892627:kraft:4213:22895528,22913801:kraft:4213:22916084,22928767:kraft:4213:22945187,22934624:kraft:4213:22934818,23017071:kraft:4213:23059870,23052804:kraft:4213:23088358,23052807:kraft:4213:23088526,23056886:kraft:4213:23089775,23074784:kraft:4213:23094057'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0037179347862978775, 'nb_photo': 4582, 'list_port_cont': '22579997,22580030,22580084,22580120,22580183,22580214,22580247,22580413,22582242,22583118,22583680,22584190,22584420,22587489,22588835,22588873,22592641,22593045,22593301,22593419,22594006,22594596,22594702,22594735,22596524,22599104,22602838,22603254,22603474,22604477,22606582,22608650,22611341,22614659,22617810,22618855,22621644,22624674,22628737,22630440,22637422,22637563,22637629,22637933,22638028,22638250,22639912,22640103,22640262,22640885,22640990,22642229,22643447,22645064,22645495,22645740,22646592,22646633,22646904,22650061,22650094,22650123,22655237,22655271,22655276,22655332,22655432,22655478,22655489,22655543,22655571,22655607,22655642,22655675,22655718,22655753,22655824,22655862,22655889,22655927,22655932,22655982,22656019,22656055,22656550,22656576,22660246,22661104,22661182,22661445,22661555,22661657,22661825,22664207,22665889,22668600,22670461,22671805,22673941,22675611,22684060,22686530,22686722,22689799,22690581,22693328,22696060,22701709,22701748,22702421,22708291,22708482,22708711,2270895', 'assoc_port': '22579895:22580214,22579896:22580247,22579897:22580120,22579898:22580183,22579899:22579997,22579900:22580030,22579901:22580084,22580332:22580413,22582223:22582242,22583005:22583118,22583532:22583680,22584171:22584190,22584408:22584420,22587177:22587489,22588823:22588873,22588824:22588835,22591685:22594735,22591686:22593045,22591687:22593301,22591688:22593419,22591689:22594596,22591690:22592641,22593666:22594702,22593667:22594006,22596387:22596524,22598767:22599104,22602554:22602838,22603023:22603474,22603025:22603254,22604316:22604477,22606121:22606582,22608596:22608650,22610993:22611341,22614519:22614659,22617416:22617810,22618639:22618855,22621383:22621644,22624122:22624674,22628398:22628737,22630325:22630440,22637348:22640885,22637349:22638028,22637350:22637933,22637351:22637629,22637352:22637422,22637353:22637563,22637992:22638250,22639304:22639912,22639971:22640262,22639972:22640103,22640911:22640990,22641870:22642229,22643360:22643447,22644963:22645064,22645331:22645495,22645717:22645740,22646470:2264663', 'assoc_mat': '22579895:metal:4213:22580214,22579896:metal:4213:22580247,22579897:metal:4213:22580120,22579898:metal:4213:22580183,22579899:metal:4213:22579997,22579900:metal:4213:22580030,22579901:metal:4213:22580084,22580332:metal:4213:22580413,22582223:metal:4213:22582242,22583005:metal:4213:22583118,22583532:metal:4213:22583680,22584171:metal:4213:22584190,22584408:metal:4213:22584420,22587177:metal:4213:22587489,22588823:metal:4213:22588873,22588824:metal:4213:22588835,22591685:metal:4213:22594735,22591686:metal:4213:22593045,22591687:metal:4213:22593301,22591688:metal:4213:22593419,22591689:metal:4213:22594596,22591690:metal:4213:22592641,22593666:metal:4213:22594702,22593667:metal:4213:22594006,22596387:metal:4213:22596524,22598767:metal:4213:22599104,22602554:metal:4213:22602838,22603023:metal:4213:22603474,22603025:metal:4213:22603254,22604316:metal:4213:22604477,22606121:metal:4213:22606582,22608596:metal:4213:22608650,22610993:metal:4213:22611341,22614519:metal:4213:22614659,22617416:metal:4213:22617810,22618639:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0395553781603902, 'nb_photo': 13142, 'list_port_cont': '22580004,22580038,22580073,22580117,22580186,22580219,22580243,22580424,22582230,22583133,22583683,22584201,22584428,22587503,22588833,22588864,22592648,22593037,22593313,22593421,22594000,22594595,22594697,22594738,22596525,22599089,22602849,22603244,22603484,22604480,22606583,22608655,22611347,22614657,22617815,22618860,22621648,22624675,22628742,22630445,22637420,22637576,22637626,22637920,22638038,22638251,22639897,22640097,22640265,22640891,22641002,22642216,22643445,22644080,22645068,22645500,22645744,22646590,22646637,22646911,22647438,22650064,22650100,22650122,22655236,22655263,22655288,22655333,22655433,22655477,22655511,22655537,22655580,22655613,22655644,22655674,22655716,22655754,22655827,22655858,22655895,22655914,22655939,22655988,22656028,22656058,22656545,22656583,22660238,22661098,22661180,22661442,22661556,22661662,22661830,22664200,22665883,22668595,22670463,22671802,22673934,22675605,22684056,22686521,22686725,22689807,22690589,22693326,22696057,22701718,22701740,22702420,22708295,2270848', 'assoc_port': '22579895:22580219,22579896:22580243,22579897:22580117,22579898:22580186,22579899:22580004,22579900:22580038,22579901:22580073,22580332:22580424,22582223:22582230,22583005:22583133,22583532:22583683,22584171:22584201,22584408:22584428,22587177:22587503,22588823:22588864,22588824:22588833,22591685:22594738,22591686:22593037,22591687:22593313,22591688:22593421,22591689:22594595,22591690:22592648,22593666:22594697,22593667:22594000,22596387:22596525,22598767:22599089,22602554:22602849,22603023:22603484,22603025:22603244,22604316:22604480,22606121:22606583,22608596:22608655,22610993:22611347,22614519:22614657,22617416:22617815,22618639:22618860,22621383:22621648,22624122:22624675,22628398:22628742,22630325:22630445,22637348:22640891,22637349:22638038,22637350:22637920,22637351:22637626,22637352:22637420,22637353:22637576,22637992:22638251,22639304:22639897,22639971:22640265,22639972:22640097,22640911:22641002,22641870:22642216,22643360:22643445,22643978:22644080,22644963:22645068,22645331:22645500,22645717:2264574', 'assoc_mat': '22579895:papier:4213:22580219,22579896:papier:4213:22580243,22579897:papier:4213:22580117,22579898:papier:4213:22580186,22579899:papier:4213:22580004,22579900:papier:4213:22580038,22579901:papier:4213:22580073,22580332:papier:4213:22580424,22582223:papier:4213:22582230,22583005:papier:4213:22583133,22583532:papier:4213:22583683,22584171:papier:4213:22584201,22584408:papier:4213:22584428,22587177:papier:4213:22587503,22588823:papier:4213:22588864,22588824:papier:4213:22588833,22591685:papier:4213:22594738,22591686:papier:4213:22593037,22591687:papier:4213:22593313,22591688:papier:4213:22593421,22591689:papier:4213:22594595,22591690:papier:4213:22592648,22593666:papier:4213:22594697,22593667:papier:4213:22594000,22596387:papier:4213:22596525,22598767:papier:4213:22599089,22602554:papier:4213:22602849,22603023:papier:4213:22603484,22603025:papier:4213:22603244,22604316:papier:4213:22604480,22606121:papier:4213:22606583,22608596:papier:4213:22608655,22610993:papier:4213:22611347,22614519:papier:4213:22614657,2261'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0036203868380213144, 'nb_photo': 194, 'list_port_cont': '22580173,22580425,22582227,22584422,22588878,22593046,22593425,22594729,22596521,22603253,22604469,22611349,22618854,22637569,22637925,22640889,22640998,22642224,22644073,22645069,22645496,22646906,22650092,22650137,22655230,22655281,22655336,22655491,22655573,22655680,22655752,22655820,22655887,22656022,22656548,22656586,22661096,22661832,22670474,22671810,22686726,22690585,22701710,22708292,22708490,22708947,22709599,22714666,22715478,22718183,22720678,22721919,22724276,22726172,22728137,22730941,22745071,22754721,22755143,22755262,22755983,22758374,22765436,22773150,22778019,22792639,22796145,22798222,22799295,22801149,22807057,22813019,22813176,22815814,22815954,22823323,22829107,22835573,22837704,22839245,22852429,22852571,22859271,22862788,22862912,22865285,22865688,22865769,22865799,22865945,22865981,22866360,22869450,22869472,22869611,22869648,22869854,22869890,22869909,22874451,22874675,22875646,22876211,22883074,22895187,22895282,22895658,22902147,22907425,22909188,22927537,22934829,22941894,2294514', 'assoc_port': '22579898:22580173,22580332:22580425,22582223:22582227,22584408:22584422,22588823:22588878,22591685:22594729,22591686:22593046,22591688:22593425,22596387:22596521,22603025:22603253,22604316:22604469,22610993:22611349,22618639:22618854,22637348:22640889,22637350:22637925,22637353:22637569,22640911:22640998,22641870:22642224,22643978:22644073,22644963:22645069,22645331:22645496,22646800:22646906,22649979:22650137,22649980:22650092,22655128:22655573,22655130:22655887,22655152:22656022,22655175:22655820,22655177:22655680,22655178:22655491,22655179:22655752,22655183:22655230,22655184:22655336,22655186:22655281,22656473:22656548,22656474:22656586,22659807:22661096,22659812:22661832,22669964:22670474,22671357:22671810,22683403:22686726,22690257:22690585,22701571:22701710,22707544:22708490,22707546:22708947,22707549:22709599,22707550:22708292,22714510:22714666,22715124:22715478,22717627:22718183,22719588:22720678,22720606:22721919,22721977:22724276,22725838:22726172,22725839:22730941,22727724:22728137,22744791:2274507', 'assoc_mat': '22579898:pehd:4213:22580173,22580332:pehd:4213:22580425,22582223:pehd:4213:22582227,22584408:pehd:4213:22584422,22588823:pehd:4213:22588878,22591685:pehd:4213:22594729,22591686:pehd:4213:22593046,22591688:pehd:4213:22593425,22596387:pehd:4213:22596521,22603025:pehd:4213:22603253,22604316:pehd:4213:22604469,22610993:pehd:4213:22611349,22618639:pehd:4213:22618854,22637348:pehd:4213:22640889,22637350:pehd:4213:22637925,22637353:pehd:4213:22637569,22640911:pehd:4213:22640998,22641870:pehd:4213:22642224,22643978:pehd:4213:22644073,22644963:pehd:4213:22645069,22645331:pehd:4213:22645496,22646800:pehd:4213:22646906,22649979:pehd:4213:22650137,22649980:pehd:4213:22650092,22655128:pehd:4213:22655573,22655130:pehd:4213:22655887,22655152:pehd:4213:22656022,22655175:pehd:4213:22655820,22655177:pehd:4213:22655680,22655178:pehd:4213:22655491,22655179:pehd:4213:22655752,22655183:pehd:4213:22655230,22655184:pehd:4213:22655336,22655186:pehd:4213:22655281,22656473:pehd:4213:22656548,22656474:pehd:4213:22656586,22659807:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.018854720131323225, 'nb_photo': 9763, 'list_port_cont': '22579995,22580033,22580074,22580119,22580172,22580215,22580244,22580419,22582231,22583119,22583682,22584199,22584427,22587518,22588843,22588862,22592636,22593038,22593308,22593433,22593995,22594588,22594698,22594725,22596531,22599095,22602842,22603255,22603469,22604474,22606572,22608668,22611333,22614645,22617817,22618861,22621647,22624667,22628750,22630448,22637419,22637561,22637619,22637926,22638040,22638248,22639902,22640094,22640270,22640892,22641001,22642218,22643459,22644072,22645061,22645493,22645754,22646600,22646647,22646908,22647442,22650067,22650088,22650127,22655229,22655273,22655296,22655334,22655439,22655467,22655515,22655544,22655576,22655609,22655645,22655682,22655712,22655751,22655813,22655846,22655881,22655929,22655933,22655991,22656025,22656064,22656540,22656574,22660245,22661103,22661189,22661441,22661553,22661655,22661833,22664216,22665880,22668601,22670466,22671816,22673932,22675610,22684065,22686533,22686730,22689808,22690580,22693334,22696067,22701706,22701749,22702432,22708301,2270849', 'assoc_port': '22579895:22580215,22579896:22580244,22579897:22580119,22579898:22580172,22579899:22579995,22579900:22580033,22579901:22580074,22580332:22580419,22582223:22582231,22583005:22583119,22583532:22583682,22584171:22584199,22584408:22584427,22587177:22587518,22588823:22588862,22588824:22588843,22591685:22594725,22591686:22593038,22591687:22593308,22591688:22593433,22591689:22594588,22591690:22592636,22593666:22594698,22593667:22593995,22596387:22596531,22598767:22599095,22602554:22602842,22603023:22603469,22603025:22603255,22604316:22604474,22606121:22606572,22608596:22608668,22610993:22611333,22614519:22614645,22617416:22617817,22618639:22618861,22621383:22621647,22624122:22624667,22628398:22628750,22630325:22630448,22637348:22640892,22637349:22638040,22637350:22637926,22637351:22637619,22637352:22637419,22637353:22637561,22637992:22638248,22639304:22639902,22639971:22640270,22639972:22640094,22640911:22641001,22641870:22642218,22643360:22643459,22643978:22644072,22644963:22645061,22645331:22645493,22645717:2264575', 'assoc_mat': '22579895:pet_clair:4213:22580215,22579896:pet_clair:4213:22580244,22579897:pet_clair:4213:22580119,22579898:pet_clair:4213:22580172,22579899:pet_clair:4213:22579995,22579900:pet_clair:4213:22580033,22579901:pet_clair:4213:22580074,22580332:pet_clair:4213:22580419,22582223:pet_clair:4213:22582231,22583005:pet_clair:4213:22583119,22583532:pet_clair:4213:22583682,22584171:pet_clair:4213:22584199,22584408:pet_clair:4213:22584427,22587177:pet_clair:4213:22587518,22588823:pet_clair:4213:22588862,22588824:pet_clair:4213:22588843,22591685:pet_clair:4213:22594725,22591686:pet_clair:4213:22593038,22591687:pet_clair:4213:22593308,22591688:pet_clair:4213:22593433,22591689:pet_clair:4213:22594588,22591690:pet_clair:4213:22592636,22593666:pet_clair:4213:22594698,22593667:pet_clair:4213:22593995,22596387:pet_clair:4213:22596531,22598767:pet_clair:4213:22599095,22602554:pet_clair:4213:22602842,22603023:pet_clair:4213:22603469,22603025:pet_clair:4213:22603255,22604316:pet_clair:4213:22604474,22606121:pet_clair:4213:22606572,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0003671544816559988, 'nb_photo': 130, 'list_port_cont': '22579996,22580032,22582241,22593303,22593427,22599096,22602852,22603472,22604478,22606578,22628741,22637574,22637621,22638253,22639906,22643446,22645063,22645492,22650125,22655654,22655685,22655826,22655847,22655992,22660243,22664212,22665884,22668598,22684068,22686531,22701713,22701747,22708288,22708950,22709188,22709223,22713526,22715477,22724271,22728146,22730947,22754715,22755129,22755267,22758370,22760155,22784681,22796261,22798238,22801146,22807091,22807947,22816622,22823333,22824871,22835571,22839258,22852576,22859136,22865174,22865287,22865649,22865796,22869618,22869683,22869752,22869822,22869857,22874457,22874970,22875144,22878780,22895043,22896570,22902142,22907427,22909197,22915669,22918877,22927551,22945156,22945229,23039880,23074012,23085706,23088049,23088444,23089774,23090062,23090529,23094060,23095311', 'assoc_port': '22579899:22579996,22579900:22580032,22582223:22582241,22591687:22593303,22591688:22593427,22598767:22599096,22602554:22602852,22603023:22603472,22604316:22604478,22606121:22606578,22628398:22628741,22637351:22637621,22637353:22637574,22637992:22638253,22639304:22639906,22643360:22643446,22644963:22645063,22645331:22645492,22649979:22650125,22655153:22655847,22655172:22655992,22655174:22655654,22655175:22655826,22655177:22655685,22659811:22660243,22662921:22664212,22665550:22665884,22667573:22668598,22683378:22684068,22686196:22686531,22701570:22701747,22701571:22701713,22707546:22708950,22707547:22709188,22707548:22709223,22707550:22708288,22713376:22713526,22715124:22715477,22721977:22724271,22725839:22730947,22727724:22728146,22753273:22754715,22753295:22755129,22753305:22755267,22757930:22758370,22759840:22760155,22784175:22784681,22795866:22796261,22798157:22798238,22798630:22801146,22806754:22807091,22807823:22807947,22816363:22816622,22823160:22823333,22824273:22824871,22835527:22835571,22838964:2283925', 'assoc_mat': '22579899:pet_fonce:4213:22579996,22579900:pet_fonce:4213:22580032,22582223:pet_fonce:4213:22582241,22591687:pet_fonce:4213:22593303,22591688:pet_fonce:4213:22593427,22598767:pet_fonce:4213:22599096,22602554:pet_fonce:4213:22602852,22603023:pet_fonce:4213:22603472,22604316:pet_fonce:4213:22604478,22606121:pet_fonce:4213:22606578,22628398:pet_fonce:4213:22628741,22637351:pet_fonce:4213:22637621,22637353:pet_fonce:4213:22637574,22637992:pet_fonce:4213:22638253,22639304:pet_fonce:4213:22639906,22643360:pet_fonce:4213:22643446,22644963:pet_fonce:4213:22645063,22645331:pet_fonce:4213:22645492,22649979:pet_fonce:4213:22650125,22655153:pet_fonce:4213:22655847,22655172:pet_fonce:4213:22655992,22655174:pet_fonce:4213:22655654,22655175:pet_fonce:4213:22655826,22655177:pet_fonce:4213:22655685,22659811:pet_fonce:4213:22660243,22662921:pet_fonce:4213:22664212,22665550:pet_fonce:4213:22665884,22667573:pet_fonce:4213:22668598,22683378:pet_fonce:4213:22684068,22686196:pet_fonce:4213:22686531,22701570:pet_fonce:4213:22701747,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.008327591816352835, 'nb_photo': 3169, 'list_port_cont': '22580042,22580122,22580187,22580216,22580249,22580412,22582235,22583131,22583690,22584202,22584424,22587519,22588834,22588872,22592649,22593042,22593309,22593420,22593994,22594586,22594693,22594727,22596528,22599100,22602848,22603245,22603478,22604472,22606575,22608674,22611342,22614648,22617811,22618856,22621645,22624665,22628739,22630444,22637421,22637560,22637632,22637927,22638034,22638258,22639901,22640099,22640258,22640886,22640997,22642220,22643450,22644065,22645065,22645498,22645750,22646594,22646646,22646898,22647435,22650069,22650097,22650128,22655225,22655262,22655278,22655335,22655444,22655471,22655509,22655536,22655581,22655605,22655649,22655724,22655750,22655817,22655853,22655888,22655926,22655947,22655985,22656026,22656053,22656542,22656575,22660230,22661102,22661192,22661443,22661554,22661663,22661839,22664208,22665877,22668599,22670469,22671806,22673942,22675599,22684055,22686525,22686715,22689798,22690587,22693324,22696059,22701704,22701739,22702433,22708296,22708483,22708700,22708937,2270918', 'assoc_port': '22579895:22580216,22579896:22580249,22579897:22580122,22579898:22580187,22579900:22580042,22580332:22580412,22582223:22582235,22583005:22583131,22583532:22583690,22584171:22584202,22584408:22584424,22587177:22587519,22588823:22588872,22588824:22588834,22591685:22594727,22591686:22593042,22591687:22593309,22591688:22593420,22591689:22594586,22591690:22592649,22593666:22594693,22593667:22593994,22596387:22596528,22598767:22599100,22602554:22602848,22603023:22603478,22603025:22603245,22604316:22604472,22606121:22606575,22608596:22608674,22610993:22611342,22614519:22614648,22617416:22617811,22618639:22618856,22621383:22621645,22624122:22624665,22628398:22628739,22630325:22630444,22637348:22640886,22637349:22638034,22637350:22637927,22637351:22637632,22637352:22637421,22637353:22637560,22637992:22638258,22639304:22639901,22639971:22640258,22639972:22640099,22640911:22640997,22641870:22642220,22643360:22643450,22643978:22644065,22644963:22645065,22645331:22645498,22645717:22645750,22646470:22646646,22646471:2264659', 'assoc_mat': '22579895:pet_opaque:4213:22580216,22579896:pet_opaque:4213:22580249,22579897:pet_opaque:4213:22580122,22579898:pet_opaque:4213:22580187,22579900:pet_opaque:4213:22580042,22580332:pet_opaque:4213:22580412,22582223:pet_opaque:4213:22582235,22583005:pet_opaque:4213:22583131,22583532:pet_opaque:4213:22583690,22584171:pet_opaque:4213:22584202,22584408:pet_opaque:4213:22584424,22587177:pet_opaque:4213:22587519,22588823:pet_opaque:4213:22588872,22588824:pet_opaque:4213:22588834,22591685:pet_opaque:4213:22594727,22591686:pet_opaque:4213:22593042,22591687:pet_opaque:4213:22593309,22591688:pet_opaque:4213:22593420,22591689:pet_opaque:4213:22594586,22591690:pet_opaque:4213:22592649,22593666:pet_opaque:4213:22594693,22593667:pet_opaque:4213:22593994,22596387:pet_opaque:4213:22596528,22598767:pet_opaque:4213:22599100,22602554:pet_opaque:4213:22602848,22603023:pet_opaque:4213:22603478,22603025:pet_opaque:4213:22603245,22604316:pet_opaque:4213:22604472,22606121:pet_opaque:4213:22606575,22608596:pet_opaque:4213:22608674,2261'})
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(1773498,1777713,1780296,1780797,1785149,1789244,1793701,1797447,1801614,1803940,1804123,1807766,1811943,1815767,1819848,1823398,1824223));
after get_hostname_from_raspi
 hasthag :  refus
 hasthag that could be used but not yet :  _______refus,textiles_sanitaires
SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______refus' and mtr_portfolio_id in (select id FROM MTRUser.mtr_portfolios where mtr_user_id=983)  and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=15 and  date >='2025-05-01' and date <= '2025-05-31') GROUP BY month order by month;
after impurety_average_per_hashtag
{'number_of_analysed_photos': ((12000,),), 'unwanted_material_monthly_percentage': ((0.10331977271394516,),), 'material_repartition': (('refus', 10583),), 'material_dict': {'refus': 10583}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 5, 1), 0.11023146268894168, 458), (datetime.date(2025, 5, 2), 0.1256255107070303, 831), (datetime.date(2025, 5, 3), 0.10416531524651948, 603), (datetime.date(2025, 5, 4), 0.09830845288760594, 776), (datetime.date(2025, 5, 5), 0.10685529330174312, 829), (datetime.date(2025, 5, 6), 0.10485862491321449, 829), (datetime.date(2025, 5, 7), 0.10053641971608346, 636), (datetime.date(2025, 5, 8), 0.10583470739188885, 469), (datetime.date(2025, 5, 9), 0.10895708074921258, 778), (datetime.date(2025, 5, 10), 0.11013524485911749, 948), (datetime.date(2025, 5, 11), 0.09882519522049817, 838), (datetime.date(2025, 5, 12), 0.10041374887781995, 705), (datetime.date(2025, 5, 13), 0.1015255735998246, 819), (datetime.date(2025, 5, 14), 0.006486823746083324, 6), (datetime.date(2025, 5, 15), 0.10192511923576716, 414), (datetime.date(2025, 5, 16), 0.09484677481249783, 644)), 'impurety_average_data_per_hashtag': {'refus': ((datetime.date(2025, 5, 1), 0.11023146268894168, 458), (datetime.date(2025, 5, 2), 0.1256255107070303, 831), (datetime.date(2025, 5, 3), 0.10416531524651948, 603), (datetime.date(2025, 5, 4), 0.09830845288760594, 776), (datetime.date(2025, 5, 5), 0.10685529330174312, 829), (datetime.date(2025, 5, 6), 0.10485862491321449, 829), (datetime.date(2025, 5, 7), 0.10053641971608346, 636), (datetime.date(2025, 5, 8), 0.10583470739188885, 469), (datetime.date(2025, 5, 9), 0.10895708074921258, 778), (datetime.date(2025, 5, 10), 0.11013524485911749, 948), (datetime.date(2025, 5, 11), 0.09882519522049817, 838), (datetime.date(2025, 5, 12), 0.10041374887781995, 705), (datetime.date(2025, 5, 13), 0.1015255735998246, 819), (datetime.date(2025, 5, 14), 0.006486823746083324, 6), (datetime.date(2025, 5, 15), 0.10192511923576716, 414), (datetime.date(2025, 5, 16), 0.09484677481249783, 644))}, 'quality_array': [['-1.8881715545134514', '01052025'], ['-1.955362537527592', '02052025'], ['-1.9762816394913643', '03052025'], ['-2.1372272964361096', '04052025'], ['-2.2327913969653936', '05052025'], ['-2.1636799433060148', '06052025'], ['-2.101845084313718', '07052025'], ['-2.053263810732728', '08052025'], ['-2.358643080142321', '09052025'], ['-2.5663848874651047', '10052025'], ['-2.4650847583000224', '11052025'], ['-2.507615589967877', '12052025'], ['-2.358631525465645', '13052025'], ['0.8699901333875243', '14052025'], ['-2.536269304004159', '15052025'], ['-2.5601825115150345', '16052025']], 'number_of_batch': ((363,),), 'datou_id_sts': 3142, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003641112539478753, 'nb_photo': 2389, 'list_port_cont': '22580010,22580043,22580115,22580178,22580222,22580257,22580416,22582243,22583129,22583684,22584191,22584425,22587513,22588842,22588863,22592645,22593036,22593299,22593422,22593998,22594592,22594689,22594734,22596520,22599105,22602843,22603242,22603468,22604467,22606579,22608670,22611334,22614649,22617807,22618851,22621650,22624669,22628740,22630441,22637409,22637571,22637622,22637930,22638030,22638255,22639904,22640091,22640255,22640881,22640993,22642222,22643458,22644074,22645072,22645488,22646598,22646641,22646903,22647439,22650056,22650103,22650136,22655234,22655272,22655280,22655331,22655434,22655475,22655514,22655546,22655574,22655621,22655656,22655686,22655717,22655748,22655816,22655859,22655891,22655915,22655931,22655994,22656024,22656051,22656537,22656582,22660237,22661093,22661181,22661447,22661547,22661670,22661824,22664210,22665881,22668590,22670464,22671814,22673939,22675613,22684061,22686520,22686723,22689806,22690591,22693323,22696068,22701714,22701743,22702431,22708286,22708479,22708703,2270894', 'assoc_port': '22579895:22580222,22579896:22580257,22579897:22580115,22579898:22580178,22579899:22580010,22579900:22580043,22580332:22580416,22582223:22582243,22583005:22583129,22583532:22583684,22584171:22584191,22584408:22584425,22587177:22587513,22588823:22588863,22588824:22588842,22591685:22594734,22591686:22593036,22591687:22593299,22591688:22593422,22591689:22594592,22591690:22592645,22593666:22594689,22593667:22593998,22596387:22596520,22598767:22599105,22602554:22602843,22603023:22603468,22603025:22603242,22604316:22604467,22606121:22606579,22608596:22608670,22610993:22611334,22614519:22614649,22617416:22617807,22618639:22618851,22621383:22621650,22624122:22624669,22628398:22628740,22630325:22630441,22637348:22640881,22637349:22638030,22637350:22637930,22637351:22637622,22637352:22637409,22637353:22637571,22637992:22638255,22639304:22639904,22639971:22640255,22639972:22640091,22640911:22640993,22641870:22642222,22643360:22643458,22643978:22644074,22644963:22645072,22645331:22645488,22646470:22646641,22646471:2264659', 'assoc_mat': '22579895:barquette_opaque:4213:22580222,22579896:barquette_opaque:4213:22580257,22579897:barquette_opaque:4213:22580115,22579898:barquette_opaque:4213:22580178,22579899:barquette_opaque:4213:22580010,22579900:barquette_opaque:4213:22580043,22580332:barquette_opaque:4213:22580416,22582223:barquette_opaque:4213:22582243,22583005:barquette_opaque:4213:22583129,22583532:barquette_opaque:4213:22583684,22584171:barquette_opaque:4213:22584191,22584408:barquette_opaque:4213:22584425,22587177:barquette_opaque:4213:22587513,22588823:barquette_opaque:4213:22588863,22588824:barquette_opaque:4213:22588842,22591685:barquette_opaque:4213:22594734,22591686:barquette_opaque:4213:22593036,22591687:barquette_opaque:4213:22593299,22591688:barquette_opaque:4213:22593422,22591689:barquette_opaque:4213:22594592,22591690:barquette_opaque:4213:22592645,22593666:barquette_opaque:4213:22594689,22593667:barquette_opaque:4213:22593998,22596387:barquette_opaque:4213:22596520,22598767:barquette_opaque:4213:22599105,22602554:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.002438628733274117, 'nb_photo': 2332, 'list_port_cont': '22579999,22580039,22580087,22580125,22580176,22580209,22580248,22580426,22582240,22583687,22584192,22584429,22587521,22588829,22588866,22592646,22593051,22593305,22593432,22594004,22594593,22594691,22594730,22596519,22599097,22602853,22603250,22603482,22604481,22606576,22608649,22611339,22614658,22617812,22618863,22621640,22624673,22628745,22630438,22637413,22637564,22637625,22637919,22638035,22638243,22639905,22640256,22640882,22640994,22642223,22643454,22644070,22645073,22645499,22645748,22646595,22646631,22646909,22650068,22650102,22650121,22655233,22655274,22655290,22655342,22655436,22655479,22655487,22655549,22655577,22655611,22655640,22655690,22655714,22655749,22655818,22655850,22655884,22655918,22655943,22655984,22656032,22656065,22656546,22656590,22660241,22661089,22661193,22661446,22661561,22661656,22661834,22664213,22665885,22668603,22670470,22671809,22673933,22675608,22684071,22686528,22686724,22689810,22690594,22693338,22701712,22701750,22702434,22708294,22708484,22708701,22708939,22709179,2270921', 'assoc_port': '22579895:22580209,22579896:22580248,22579897:22580125,22579898:22580176,22579899:22579999,22579900:22580039,22579901:22580087,22580332:22580426,22582223:22582240,22583532:22583687,22584171:22584192,22584408:22584429,22587177:22587521,22588823:22588866,22588824:22588829,22591685:22594730,22591686:22593051,22591687:22593305,22591688:22593432,22591689:22594593,22591690:22592646,22593666:22594691,22593667:22594004,22596387:22596519,22598767:22599097,22602554:22602853,22603023:22603482,22603025:22603250,22604316:22604481,22606121:22606576,22608596:22608649,22610993:22611339,22614519:22614658,22617416:22617812,22618639:22618863,22621383:22621640,22624122:22624673,22628398:22628745,22630325:22630438,22637348:22640882,22637349:22638035,22637350:22637919,22637351:22637625,22637352:22637413,22637353:22637564,22637992:22638243,22639304:22639905,22639971:22640256,22640911:22640994,22641870:22642223,22643360:22643454,22643978:22644070,22644963:22645073,22645331:22645499,22645717:22645748,22646470:22646631,22646471:2264659', 'assoc_mat': '22579895:carton:4213:22580209,22579896:carton:4213:22580248,22579897:carton:4213:22580125,22579898:carton:4213:22580176,22579899:carton:4213:22579999,22579900:carton:4213:22580039,22579901:carton:4213:22580087,22580332:carton:4213:22580426,22582223:carton:4213:22582240,22583532:carton:4213:22583687,22584171:carton:4213:22584192,22584408:carton:4213:22584429,22587177:carton:4213:22587521,22588823:carton:4213:22588866,22588824:carton:4213:22588829,22591685:carton:4213:22594730,22591686:carton:4213:22593051,22591687:carton:4213:22593305,22591688:carton:4213:22593432,22591689:carton:4213:22594593,22591690:carton:4213:22592646,22593666:carton:4213:22594691,22593667:carton:4213:22594004,22596387:carton:4213:22596519,22598767:carton:4213:22599097,22602554:carton:4213:22602853,22603023:carton:4213:22603482,22603025:carton:4213:22603250,22604316:carton:4213:22604481,22606121:carton:4213:22606576,22608596:carton:4213:22608649,22610993:carton:4213:22611339,22614519:carton:4213:22614658,22617416:carton:4213:22617812,2261'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003577989831983466, 'nb_photo': 755, 'list_port_cont': '22579998,22580078,22580123,22580188,22580221,22580253,22580410,22583676,22584205,22584416,22587493,22588844,22588869,22592642,22593039,22593304,22593418,22594003,22594600,22594696,22594731,22596532,22599091,22602847,22603470,22604473,22606573,22611348,22614644,22617813,22618862,22621656,22624676,22628751,22630436,22637412,22637567,22637917,22638043,22638242,22639900,22640264,22640883,22640992,22642214,22643453,22645067,22645494,22646605,22646900,22650053,22650087,22650130,22655226,22655300,22655341,22655495,22655583,22655612,22655651,22655677,22655823,22655861,22655883,22655996,22656029,22656539,22656584,22660244,22661100,22661194,22661450,22661560,22661664,22661836,22664203,22665882,22673930,22675597,22684067,22686518,22686718,22689803,22696061,22701708,22701737,22702430,22708299,22708487,22708702,22708946,22709183,22709606,22710947,22712052,22713520,22714654,22715481,22718170,22721916,22724281,22726176,22728141,22729461,22730948,22735996,22745058,22753925,22754728,22754910,22755128,22755329,22758377,2276016', 'assoc_port': '22579895:22580221,22579896:22580253,22579897:22580123,22579898:22580188,22579899:22579998,22579901:22580078,22580332:22580410,22583532:22583676,22584171:22584205,22584408:22584416,22587177:22587493,22588823:22588869,22588824:22588844,22591685:22594731,22591686:22593039,22591687:22593304,22591688:22593418,22591689:22594600,22591690:22592642,22593666:22594696,22593667:22594003,22596387:22596532,22598767:22599091,22602554:22602847,22603023:22603470,22604316:22604473,22606121:22606573,22610993:22611348,22614519:22614644,22617416:22617813,22618639:22618862,22621383:22621656,22624122:22624676,22628398:22628751,22630325:22630436,22637348:22640883,22637349:22638043,22637350:22637917,22637352:22637412,22637353:22637567,22637992:22638242,22639304:22639900,22639971:22640264,22640911:22640992,22641870:22642214,22643360:22643453,22644963:22645067,22645331:22645494,22646471:22646605,22646800:22646900,22649978:22650053,22649979:22650130,22649980:22650087,22655128:22655583,22655129:22655612,22655130:22655883,22655152:2265602', 'assoc_mat': '22579895:ela:4213:22580221,22579896:ela:4213:22580253,22579897:ela:4213:22580123,22579898:ela:4213:22580188,22579899:ela:4213:22579998,22579901:ela:4213:22580078,22580332:ela:4213:22580410,22583532:ela:4213:22583676,22584171:ela:4213:22584205,22584408:ela:4213:22584416,22587177:ela:4213:22587493,22588823:ela:4213:22588869,22588824:ela:4213:22588844,22591685:ela:4213:22594731,22591686:ela:4213:22593039,22591687:ela:4213:22593304,22591688:ela:4213:22593418,22591689:ela:4213:22594600,22591690:ela:4213:22592642,22593666:ela:4213:22594696,22593667:ela:4213:22594003,22596387:ela:4213:22596532,22598767:ela:4213:22599091,22602554:ela:4213:22602847,22603023:ela:4213:22603470,22604316:ela:4213:22604473,22606121:ela:4213:22606573,22610993:ela:4213:22611348,22614519:ela:4213:22614644,22617416:ela:4213:22617813,22618639:ela:4213:22618862,22621383:ela:4213:22621656,22624122:ela:4213:22624676,22628398:ela:4213:22628751,22630325:ela:4213:22630436,22637348:ela:4213:22640883,22637349:ela:4213:22638043,22637350:ela:4213:2263791'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003339989417732796, 'nb_photo': 3563, 'list_port_cont': '22580002,22580031,22580082,22580111,22580180,22580213,22580252,22580417,22582237,22583122,22583679,22584193,22584426,22587516,22588831,22588871,22592650,22593040,22593314,22593428,22594009,22594597,22594692,22594728,22596530,22599093,22602841,22603239,22603483,22604482,22606581,22608652,22611345,22614655,22617808,22618858,22621643,22624663,22628736,22630447,22637416,22637566,22637623,22637918,22638031,22638244,22639907,22640102,22640269,22640877,22640989,22642221,22643455,22644081,22645066,22645490,22645756,22646589,22646634,22646910,22647431,22650054,22650093,22650134,22655241,22655260,22655286,22655339,22655446,22655470,22655485,22655535,22655579,22655606,22655647,22655678,22655708,22655756,22655812,22655860,22655885,22655928,22655937,22655995,22656020,22656066,22656541,22656578,22660231,22661092,22661188,22661434,22661545,22661665,22661827,22664202,22665888,22668591,22670473,22671813,22673931,22675602,22684066,22686523,22686714,22689804,22690583,22693325,22696063,22701707,22701746,22702427,22708289,2270848', 'assoc_port': '22579895:22580213,22579896:22580252,22579897:22580111,22579898:22580180,22579899:22580002,22579900:22580031,22579901:22580082,22580332:22580417,22582223:22582237,22583005:22583122,22583532:22583679,22584171:22584193,22584408:22584426,22587177:22587516,22588823:22588871,22588824:22588831,22591685:22594728,22591686:22593040,22591687:22593314,22591688:22593428,22591689:22594597,22591690:22592650,22593666:22594692,22593667:22594009,22596387:22596530,22598767:22599093,22602554:22602841,22603023:22603483,22603025:22603239,22604316:22604482,22606121:22606581,22608596:22608652,22610993:22611345,22614519:22614655,22617416:22617808,22618639:22618858,22621383:22621643,22624122:22624663,22628398:22628736,22630325:22630447,22637348:22640877,22637349:22638031,22637350:22637918,22637351:22637623,22637352:22637416,22637353:22637566,22637992:22638244,22639304:22639907,22639971:22640269,22639972:22640102,22640911:22640989,22641870:22642221,22643360:22643455,22643978:22644081,22644963:22645066,22645331:22645490,22645717:2264575', 'assoc_mat': '22579895:etiquette:4213:22580213,22579896:etiquette:4213:22580252,22579897:etiquette:4213:22580111,22579898:etiquette:4213:22580180,22579899:etiquette:4213:22580002,22579900:etiquette:4213:22580031,22579901:etiquette:4213:22580082,22580332:etiquette:4213:22580417,22582223:etiquette:4213:22582237,22583005:etiquette:4213:22583122,22583532:etiquette:4213:22583679,22584171:etiquette:4213:22584193,22584408:etiquette:4213:22584426,22587177:etiquette:4213:22587516,22588823:etiquette:4213:22588871,22588824:etiquette:4213:22588831,22591685:etiquette:4213:22594728,22591686:etiquette:4213:22593040,22591687:etiquette:4213:22593314,22591688:etiquette:4213:22593428,22591689:etiquette:4213:22594597,22591690:etiquette:4213:22592650,22593666:etiquette:4213:22594692,22593667:etiquette:4213:22594009,22596387:etiquette:4213:22596530,22598767:etiquette:4213:22599093,22602554:etiquette:4213:22602841,22603023:etiquette:4213:22603483,22603025:etiquette:4213:22603239,22604316:etiquette:4213:22604482,22606121:etiquette:4213:22606581,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0321886213260326, 'nb_photo': 7883, 'list_port_cont': '22580005,22580037,22580077,22580114,22580185,22580210,22580255,22580423,22582239,22583120,22583678,22584204,22584413,22587517,22588837,22588865,22592652,22593041,22593307,22593424,22594008,22594594,22594688,22594726,22596527,22599090,22602846,22603249,22603476,22604471,22606580,22608654,22611337,22614654,22617816,22618849,22621653,22624668,22628749,22630446,22637418,22637570,22637618,22637932,22638032,22638252,22639909,22640088,22640261,22640878,22640996,22642215,22643443,22644079,22645070,22645502,22645755,22646599,22646639,22646905,22647437,22650063,22650098,22650124,22655235,22655267,22655277,22655343,22655440,22655476,22655497,22655540,22655575,22655615,22655655,22655681,22655720,22655758,22655828,22655856,22655896,22655920,22655942,22655998,22656021,22656056,22656553,22656577,22660235,22661105,22661196,22661435,22661557,22661671,22661840,22664217,22665887,22668588,22670460,22671801,22673943,22675603,22684070,22686522,22686720,22689800,22690582,22693335,22696056,22701703,22701738,22702425,22708290,2270848', 'assoc_port': '22579895:22580210,22579896:22580255,22579897:22580114,22579898:22580185,22579899:22580005,22579900:22580037,22579901:22580077,22580332:22580423,22582223:22582239,22583005:22583120,22583532:22583678,22584171:22584204,22584408:22584413,22587177:22587517,22588823:22588865,22588824:22588837,22591685:22594726,22591686:22593041,22591687:22593307,22591688:22593424,22591689:22594594,22591690:22592652,22593666:22594688,22593667:22594008,22596387:22596527,22598767:22599090,22602554:22602846,22603023:22603476,22603025:22603249,22604316:22604471,22606121:22606580,22608596:22608654,22610993:22611337,22614519:22614654,22617416:22617816,22618639:22618849,22621383:22621653,22624122:22624668,22628398:22628749,22630325:22630446,22637348:22640878,22637349:22638032,22637350:22637932,22637351:22637618,22637352:22637418,22637353:22637570,22637992:22638252,22639304:22639909,22639971:22640261,22639972:22640088,22640911:22640996,22641870:22642215,22643360:22643443,22643978:22644079,22644963:22645070,22645331:22645502,22645717:2264575', 'assoc_mat': '22579895:film_plastique:4213:22580210,22579896:film_plastique:4213:22580255,22579897:film_plastique:4213:22580114,22579898:film_plastique:4213:22580185,22579899:film_plastique:4213:22580005,22579900:film_plastique:4213:22580037,22579901:film_plastique:4213:22580077,22580332:film_plastique:4213:22580423,22582223:film_plastique:4213:22582239,22583005:film_plastique:4213:22583120,22583532:film_plastique:4213:22583678,22584171:film_plastique:4213:22584204,22584408:film_plastique:4213:22584413,22587177:film_plastique:4213:22587517,22588823:film_plastique:4213:22588865,22588824:film_plastique:4213:22588837,22591685:film_plastique:4213:22594726,22591686:film_plastique:4213:22593041,22591687:film_plastique:4213:22593307,22591688:film_plastique:4213:22593424,22591689:film_plastique:4213:22594594,22591690:film_plastique:4213:22592652,22593666:film_plastique:4213:22594688,22593667:film_plastique:4213:22594008,22596387:film_plastique:4213:22596527,22598767:film_plastique:4213:22599090,22602554:film_plastique:4213:2260284'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.00047712249075355245, 'nb_photo': 36, 'list_port_cont': '22580118,22580174,22580206,22588875,22593315,22594704,22637568,22637931,22655587,22656580,22660239,22668592,22712054,22730942,22797065,22841356,22862360,22865172,22866357,22869415,22869438,22869853,22895291,22895528,22916084,22934818,22945187,23059870,23088358,23088526,23089775,23094057', 'assoc_port': '22579895:22580206,22579897:22580118,22579898:22580174,22588823:22588875,22591687:22593315,22593666:22594704,22637350:22637931,22637353:22637568,22655128:22655587,22656474:22656580,22659811:22660239,22667573:22668592,22712013:22712054,22725839:22730942,22796993:22797065,22841223:22841356,22856557:22862360,22862213:22865172,22866275:22866357,22869341:22869853,22869353:22869415,22869361:22869438,22892622:22895291,22892627:22895528,22913801:22916084,22928767:22945187,22934624:22934818,23017071:23059870,23052804:23088358,23052807:23088526,23056886:23089775,23074784:23094057', 'assoc_mat': '22579895:kraft:4213:22580206,22579897:kraft:4213:22580118,22579898:kraft:4213:22580174,22588823:kraft:4213:22588875,22591687:kraft:4213:22593315,22593666:kraft:4213:22594704,22637350:kraft:4213:22637931,22637353:kraft:4213:22637568,22655128:kraft:4213:22655587,22656474:kraft:4213:22656580,22659811:kraft:4213:22660239,22667573:kraft:4213:22668592,22712013:kraft:4213:22712054,22725839:kraft:4213:22730942,22796993:kraft:4213:22797065,22841223:kraft:4213:22841356,22856557:kraft:4213:22862360,22862213:kraft:4213:22865172,22866275:kraft:4213:22866357,22869341:kraft:4213:22869853,22869353:kraft:4213:22869415,22869361:kraft:4213:22869438,22892622:kraft:4213:22895291,22892627:kraft:4213:22895528,22913801:kraft:4213:22916084,22928767:kraft:4213:22945187,22934624:kraft:4213:22934818,23017071:kraft:4213:23059870,23052804:kraft:4213:23088358,23052807:kraft:4213:23088526,23056886:kraft:4213:23089775,23074784:kraft:4213:23094057'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0037179347862978775, 'nb_photo': 4582, 'list_port_cont': '22579997,22580030,22580084,22580120,22580183,22580214,22580247,22580413,22582242,22583118,22583680,22584190,22584420,22587489,22588835,22588873,22592641,22593045,22593301,22593419,22594006,22594596,22594702,22594735,22596524,22599104,22602838,22603254,22603474,22604477,22606582,22608650,22611341,22614659,22617810,22618855,22621644,22624674,22628737,22630440,22637422,22637563,22637629,22637933,22638028,22638250,22639912,22640103,22640262,22640885,22640990,22642229,22643447,22645064,22645495,22645740,22646592,22646633,22646904,22650061,22650094,22650123,22655237,22655271,22655276,22655332,22655432,22655478,22655489,22655543,22655571,22655607,22655642,22655675,22655718,22655753,22655824,22655862,22655889,22655927,22655932,22655982,22656019,22656055,22656550,22656576,22660246,22661104,22661182,22661445,22661555,22661657,22661825,22664207,22665889,22668600,22670461,22671805,22673941,22675611,22684060,22686530,22686722,22689799,22690581,22693328,22696060,22701709,22701748,22702421,22708291,22708482,22708711,2270895', 'assoc_port': '22579895:22580214,22579896:22580247,22579897:22580120,22579898:22580183,22579899:22579997,22579900:22580030,22579901:22580084,22580332:22580413,22582223:22582242,22583005:22583118,22583532:22583680,22584171:22584190,22584408:22584420,22587177:22587489,22588823:22588873,22588824:22588835,22591685:22594735,22591686:22593045,22591687:22593301,22591688:22593419,22591689:22594596,22591690:22592641,22593666:22594702,22593667:22594006,22596387:22596524,22598767:22599104,22602554:22602838,22603023:22603474,22603025:22603254,22604316:22604477,22606121:22606582,22608596:22608650,22610993:22611341,22614519:22614659,22617416:22617810,22618639:22618855,22621383:22621644,22624122:22624674,22628398:22628737,22630325:22630440,22637348:22640885,22637349:22638028,22637350:22637933,22637351:22637629,22637352:22637422,22637353:22637563,22637992:22638250,22639304:22639912,22639971:22640262,22639972:22640103,22640911:22640990,22641870:22642229,22643360:22643447,22644963:22645064,22645331:22645495,22645717:22645740,22646470:2264663', 'assoc_mat': '22579895:metal:4213:22580214,22579896:metal:4213:22580247,22579897:metal:4213:22580120,22579898:metal:4213:22580183,22579899:metal:4213:22579997,22579900:metal:4213:22580030,22579901:metal:4213:22580084,22580332:metal:4213:22580413,22582223:metal:4213:22582242,22583005:metal:4213:22583118,22583532:metal:4213:22583680,22584171:metal:4213:22584190,22584408:metal:4213:22584420,22587177:metal:4213:22587489,22588823:metal:4213:22588873,22588824:metal:4213:22588835,22591685:metal:4213:22594735,22591686:metal:4213:22593045,22591687:metal:4213:22593301,22591688:metal:4213:22593419,22591689:metal:4213:22594596,22591690:metal:4213:22592641,22593666:metal:4213:22594702,22593667:metal:4213:22594006,22596387:metal:4213:22596524,22598767:metal:4213:22599104,22602554:metal:4213:22602838,22603023:metal:4213:22603474,22603025:metal:4213:22603254,22604316:metal:4213:22604477,22606121:metal:4213:22606582,22608596:metal:4213:22608650,22610993:metal:4213:22611341,22614519:metal:4213:22614659,22617416:metal:4213:22617810,22618639:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0395553781603902, 'nb_photo': 13142, 'list_port_cont': '22580004,22580038,22580073,22580117,22580186,22580219,22580243,22580424,22582230,22583133,22583683,22584201,22584428,22587503,22588833,22588864,22592648,22593037,22593313,22593421,22594000,22594595,22594697,22594738,22596525,22599089,22602849,22603244,22603484,22604480,22606583,22608655,22611347,22614657,22617815,22618860,22621648,22624675,22628742,22630445,22637420,22637576,22637626,22637920,22638038,22638251,22639897,22640097,22640265,22640891,22641002,22642216,22643445,22644080,22645068,22645500,22645744,22646590,22646637,22646911,22647438,22650064,22650100,22650122,22655236,22655263,22655288,22655333,22655433,22655477,22655511,22655537,22655580,22655613,22655644,22655674,22655716,22655754,22655827,22655858,22655895,22655914,22655939,22655988,22656028,22656058,22656545,22656583,22660238,22661098,22661180,22661442,22661556,22661662,22661830,22664200,22665883,22668595,22670463,22671802,22673934,22675605,22684056,22686521,22686725,22689807,22690589,22693326,22696057,22701718,22701740,22702420,22708295,2270848', 'assoc_port': '22579895:22580219,22579896:22580243,22579897:22580117,22579898:22580186,22579899:22580004,22579900:22580038,22579901:22580073,22580332:22580424,22582223:22582230,22583005:22583133,22583532:22583683,22584171:22584201,22584408:22584428,22587177:22587503,22588823:22588864,22588824:22588833,22591685:22594738,22591686:22593037,22591687:22593313,22591688:22593421,22591689:22594595,22591690:22592648,22593666:22594697,22593667:22594000,22596387:22596525,22598767:22599089,22602554:22602849,22603023:22603484,22603025:22603244,22604316:22604480,22606121:22606583,22608596:22608655,22610993:22611347,22614519:22614657,22617416:22617815,22618639:22618860,22621383:22621648,22624122:22624675,22628398:22628742,22630325:22630445,22637348:22640891,22637349:22638038,22637350:22637920,22637351:22637626,22637352:22637420,22637353:22637576,22637992:22638251,22639304:22639897,22639971:22640265,22639972:22640097,22640911:22641002,22641870:22642216,22643360:22643445,22643978:22644080,22644963:22645068,22645331:22645500,22645717:2264574', 'assoc_mat': '22579895:papier:4213:22580219,22579896:papier:4213:22580243,22579897:papier:4213:22580117,22579898:papier:4213:22580186,22579899:papier:4213:22580004,22579900:papier:4213:22580038,22579901:papier:4213:22580073,22580332:papier:4213:22580424,22582223:papier:4213:22582230,22583005:papier:4213:22583133,22583532:papier:4213:22583683,22584171:papier:4213:22584201,22584408:papier:4213:22584428,22587177:papier:4213:22587503,22588823:papier:4213:22588864,22588824:papier:4213:22588833,22591685:papier:4213:22594738,22591686:papier:4213:22593037,22591687:papier:4213:22593313,22591688:papier:4213:22593421,22591689:papier:4213:22594595,22591690:papier:4213:22592648,22593666:papier:4213:22594697,22593667:papier:4213:22594000,22596387:papier:4213:22596525,22598767:papier:4213:22599089,22602554:papier:4213:22602849,22603023:papier:4213:22603484,22603025:papier:4213:22603244,22604316:papier:4213:22604480,22606121:papier:4213:22606583,22608596:papier:4213:22608655,22610993:papier:4213:22611347,22614519:papier:4213:22614657,2261'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0036203868380213144, 'nb_photo': 194, 'list_port_cont': '22580173,22580425,22582227,22584422,22588878,22593046,22593425,22594729,22596521,22603253,22604469,22611349,22618854,22637569,22637925,22640889,22640998,22642224,22644073,22645069,22645496,22646906,22650092,22650137,22655230,22655281,22655336,22655491,22655573,22655680,22655752,22655820,22655887,22656022,22656548,22656586,22661096,22661832,22670474,22671810,22686726,22690585,22701710,22708292,22708490,22708947,22709599,22714666,22715478,22718183,22720678,22721919,22724276,22726172,22728137,22730941,22745071,22754721,22755143,22755262,22755983,22758374,22765436,22773150,22778019,22792639,22796145,22798222,22799295,22801149,22807057,22813019,22813176,22815814,22815954,22823323,22829107,22835573,22837704,22839245,22852429,22852571,22859271,22862788,22862912,22865285,22865688,22865769,22865799,22865945,22865981,22866360,22869450,22869472,22869611,22869648,22869854,22869890,22869909,22874451,22874675,22875646,22876211,22883074,22895187,22895282,22895658,22902147,22907425,22909188,22927537,22934829,22941894,2294514', 'assoc_port': '22579898:22580173,22580332:22580425,22582223:22582227,22584408:22584422,22588823:22588878,22591685:22594729,22591686:22593046,22591688:22593425,22596387:22596521,22603025:22603253,22604316:22604469,22610993:22611349,22618639:22618854,22637348:22640889,22637350:22637925,22637353:22637569,22640911:22640998,22641870:22642224,22643978:22644073,22644963:22645069,22645331:22645496,22646800:22646906,22649979:22650137,22649980:22650092,22655128:22655573,22655130:22655887,22655152:22656022,22655175:22655820,22655177:22655680,22655178:22655491,22655179:22655752,22655183:22655230,22655184:22655336,22655186:22655281,22656473:22656548,22656474:22656586,22659807:22661096,22659812:22661832,22669964:22670474,22671357:22671810,22683403:22686726,22690257:22690585,22701571:22701710,22707544:22708490,22707546:22708947,22707549:22709599,22707550:22708292,22714510:22714666,22715124:22715478,22717627:22718183,22719588:22720678,22720606:22721919,22721977:22724276,22725838:22726172,22725839:22730941,22727724:22728137,22744791:2274507', 'assoc_mat': '22579898:pehd:4213:22580173,22580332:pehd:4213:22580425,22582223:pehd:4213:22582227,22584408:pehd:4213:22584422,22588823:pehd:4213:22588878,22591685:pehd:4213:22594729,22591686:pehd:4213:22593046,22591688:pehd:4213:22593425,22596387:pehd:4213:22596521,22603025:pehd:4213:22603253,22604316:pehd:4213:22604469,22610993:pehd:4213:22611349,22618639:pehd:4213:22618854,22637348:pehd:4213:22640889,22637350:pehd:4213:22637925,22637353:pehd:4213:22637569,22640911:pehd:4213:22640998,22641870:pehd:4213:22642224,22643978:pehd:4213:22644073,22644963:pehd:4213:22645069,22645331:pehd:4213:22645496,22646800:pehd:4213:22646906,22649979:pehd:4213:22650137,22649980:pehd:4213:22650092,22655128:pehd:4213:22655573,22655130:pehd:4213:22655887,22655152:pehd:4213:22656022,22655175:pehd:4213:22655820,22655177:pehd:4213:22655680,22655178:pehd:4213:22655491,22655179:pehd:4213:22655752,22655183:pehd:4213:22655230,22655184:pehd:4213:22655336,22655186:pehd:4213:22655281,22656473:pehd:4213:22656548,22656474:pehd:4213:22656586,22659807:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.018854720131323225, 'nb_photo': 9763, 'list_port_cont': '22579995,22580033,22580074,22580119,22580172,22580215,22580244,22580419,22582231,22583119,22583682,22584199,22584427,22587518,22588843,22588862,22592636,22593038,22593308,22593433,22593995,22594588,22594698,22594725,22596531,22599095,22602842,22603255,22603469,22604474,22606572,22608668,22611333,22614645,22617817,22618861,22621647,22624667,22628750,22630448,22637419,22637561,22637619,22637926,22638040,22638248,22639902,22640094,22640270,22640892,22641001,22642218,22643459,22644072,22645061,22645493,22645754,22646600,22646647,22646908,22647442,22650067,22650088,22650127,22655229,22655273,22655296,22655334,22655439,22655467,22655515,22655544,22655576,22655609,22655645,22655682,22655712,22655751,22655813,22655846,22655881,22655929,22655933,22655991,22656025,22656064,22656540,22656574,22660245,22661103,22661189,22661441,22661553,22661655,22661833,22664216,22665880,22668601,22670466,22671816,22673932,22675610,22684065,22686533,22686730,22689808,22690580,22693334,22696067,22701706,22701749,22702432,22708301,2270849', 'assoc_port': '22579895:22580215,22579896:22580244,22579897:22580119,22579898:22580172,22579899:22579995,22579900:22580033,22579901:22580074,22580332:22580419,22582223:22582231,22583005:22583119,22583532:22583682,22584171:22584199,22584408:22584427,22587177:22587518,22588823:22588862,22588824:22588843,22591685:22594725,22591686:22593038,22591687:22593308,22591688:22593433,22591689:22594588,22591690:22592636,22593666:22594698,22593667:22593995,22596387:22596531,22598767:22599095,22602554:22602842,22603023:22603469,22603025:22603255,22604316:22604474,22606121:22606572,22608596:22608668,22610993:22611333,22614519:22614645,22617416:22617817,22618639:22618861,22621383:22621647,22624122:22624667,22628398:22628750,22630325:22630448,22637348:22640892,22637349:22638040,22637350:22637926,22637351:22637619,22637352:22637419,22637353:22637561,22637992:22638248,22639304:22639902,22639971:22640270,22639972:22640094,22640911:22641001,22641870:22642218,22643360:22643459,22643978:22644072,22644963:22645061,22645331:22645493,22645717:2264575', 'assoc_mat': '22579895:pet_clair:4213:22580215,22579896:pet_clair:4213:22580244,22579897:pet_clair:4213:22580119,22579898:pet_clair:4213:22580172,22579899:pet_clair:4213:22579995,22579900:pet_clair:4213:22580033,22579901:pet_clair:4213:22580074,22580332:pet_clair:4213:22580419,22582223:pet_clair:4213:22582231,22583005:pet_clair:4213:22583119,22583532:pet_clair:4213:22583682,22584171:pet_clair:4213:22584199,22584408:pet_clair:4213:22584427,22587177:pet_clair:4213:22587518,22588823:pet_clair:4213:22588862,22588824:pet_clair:4213:22588843,22591685:pet_clair:4213:22594725,22591686:pet_clair:4213:22593038,22591687:pet_clair:4213:22593308,22591688:pet_clair:4213:22593433,22591689:pet_clair:4213:22594588,22591690:pet_clair:4213:22592636,22593666:pet_clair:4213:22594698,22593667:pet_clair:4213:22593995,22596387:pet_clair:4213:22596531,22598767:pet_clair:4213:22599095,22602554:pet_clair:4213:22602842,22603023:pet_clair:4213:22603469,22603025:pet_clair:4213:22603255,22604316:pet_clair:4213:22604474,22606121:pet_clair:4213:22606572,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0003671544816559988, 'nb_photo': 130, 'list_port_cont': '22579996,22580032,22582241,22593303,22593427,22599096,22602852,22603472,22604478,22606578,22628741,22637574,22637621,22638253,22639906,22643446,22645063,22645492,22650125,22655654,22655685,22655826,22655847,22655992,22660243,22664212,22665884,22668598,22684068,22686531,22701713,22701747,22708288,22708950,22709188,22709223,22713526,22715477,22724271,22728146,22730947,22754715,22755129,22755267,22758370,22760155,22784681,22796261,22798238,22801146,22807091,22807947,22816622,22823333,22824871,22835571,22839258,22852576,22859136,22865174,22865287,22865649,22865796,22869618,22869683,22869752,22869822,22869857,22874457,22874970,22875144,22878780,22895043,22896570,22902142,22907427,22909197,22915669,22918877,22927551,22945156,22945229,23039880,23074012,23085706,23088049,23088444,23089774,23090062,23090529,23094060,23095311', 'assoc_port': '22579899:22579996,22579900:22580032,22582223:22582241,22591687:22593303,22591688:22593427,22598767:22599096,22602554:22602852,22603023:22603472,22604316:22604478,22606121:22606578,22628398:22628741,22637351:22637621,22637353:22637574,22637992:22638253,22639304:22639906,22643360:22643446,22644963:22645063,22645331:22645492,22649979:22650125,22655153:22655847,22655172:22655992,22655174:22655654,22655175:22655826,22655177:22655685,22659811:22660243,22662921:22664212,22665550:22665884,22667573:22668598,22683378:22684068,22686196:22686531,22701570:22701747,22701571:22701713,22707546:22708950,22707547:22709188,22707548:22709223,22707550:22708288,22713376:22713526,22715124:22715477,22721977:22724271,22725839:22730947,22727724:22728146,22753273:22754715,22753295:22755129,22753305:22755267,22757930:22758370,22759840:22760155,22784175:22784681,22795866:22796261,22798157:22798238,22798630:22801146,22806754:22807091,22807823:22807947,22816363:22816622,22823160:22823333,22824273:22824871,22835527:22835571,22838964:2283925', 'assoc_mat': '22579899:pet_fonce:4213:22579996,22579900:pet_fonce:4213:22580032,22582223:pet_fonce:4213:22582241,22591687:pet_fonce:4213:22593303,22591688:pet_fonce:4213:22593427,22598767:pet_fonce:4213:22599096,22602554:pet_fonce:4213:22602852,22603023:pet_fonce:4213:22603472,22604316:pet_fonce:4213:22604478,22606121:pet_fonce:4213:22606578,22628398:pet_fonce:4213:22628741,22637351:pet_fonce:4213:22637621,22637353:pet_fonce:4213:22637574,22637992:pet_fonce:4213:22638253,22639304:pet_fonce:4213:22639906,22643360:pet_fonce:4213:22643446,22644963:pet_fonce:4213:22645063,22645331:pet_fonce:4213:22645492,22649979:pet_fonce:4213:22650125,22655153:pet_fonce:4213:22655847,22655172:pet_fonce:4213:22655992,22655174:pet_fonce:4213:22655654,22655175:pet_fonce:4213:22655826,22655177:pet_fonce:4213:22655685,22659811:pet_fonce:4213:22660243,22662921:pet_fonce:4213:22664212,22665550:pet_fonce:4213:22665884,22667573:pet_fonce:4213:22668598,22683378:pet_fonce:4213:22684068,22686196:pet_fonce:4213:22686531,22701570:pet_fonce:4213:22701747,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.008327591816352835, 'nb_photo': 3169, 'list_port_cont': '22580042,22580122,22580187,22580216,22580249,22580412,22582235,22583131,22583690,22584202,22584424,22587519,22588834,22588872,22592649,22593042,22593309,22593420,22593994,22594586,22594693,22594727,22596528,22599100,22602848,22603245,22603478,22604472,22606575,22608674,22611342,22614648,22617811,22618856,22621645,22624665,22628739,22630444,22637421,22637560,22637632,22637927,22638034,22638258,22639901,22640099,22640258,22640886,22640997,22642220,22643450,22644065,22645065,22645498,22645750,22646594,22646646,22646898,22647435,22650069,22650097,22650128,22655225,22655262,22655278,22655335,22655444,22655471,22655509,22655536,22655581,22655605,22655649,22655724,22655750,22655817,22655853,22655888,22655926,22655947,22655985,22656026,22656053,22656542,22656575,22660230,22661102,22661192,22661443,22661554,22661663,22661839,22664208,22665877,22668599,22670469,22671806,22673942,22675599,22684055,22686525,22686715,22689798,22690587,22693324,22696059,22701704,22701739,22702433,22708296,22708483,22708700,22708937,2270918', 'assoc_port': '22579895:22580216,22579896:22580249,22579897:22580122,22579898:22580187,22579900:22580042,22580332:22580412,22582223:22582235,22583005:22583131,22583532:22583690,22584171:22584202,22584408:22584424,22587177:22587519,22588823:22588872,22588824:22588834,22591685:22594727,22591686:22593042,22591687:22593309,22591688:22593420,22591689:22594586,22591690:22592649,22593666:22594693,22593667:22593994,22596387:22596528,22598767:22599100,22602554:22602848,22603023:22603478,22603025:22603245,22604316:22604472,22606121:22606575,22608596:22608674,22610993:22611342,22614519:22614648,22617416:22617811,22618639:22618856,22621383:22621645,22624122:22624665,22628398:22628739,22630325:22630444,22637348:22640886,22637349:22638034,22637350:22637927,22637351:22637632,22637352:22637421,22637353:22637560,22637992:22638258,22639304:22639901,22639971:22640258,22639972:22640099,22640911:22640997,22641870:22642220,22643360:22643450,22643978:22644065,22644963:22645065,22645331:22645498,22645717:22645750,22646470:22646646,22646471:2264659', 'assoc_mat': '22579895:pet_opaque:4213:22580216,22579896:pet_opaque:4213:22580249,22579897:pet_opaque:4213:22580122,22579898:pet_opaque:4213:22580187,22579900:pet_opaque:4213:22580042,22580332:pet_opaque:4213:22580412,22582223:pet_opaque:4213:22582235,22583005:pet_opaque:4213:22583131,22583532:pet_opaque:4213:22583690,22584171:pet_opaque:4213:22584202,22584408:pet_opaque:4213:22584424,22587177:pet_opaque:4213:22587519,22588823:pet_opaque:4213:22588872,22588824:pet_opaque:4213:22588834,22591685:pet_opaque:4213:22594727,22591686:pet_opaque:4213:22593042,22591687:pet_opaque:4213:22593309,22591688:pet_opaque:4213:22593420,22591689:pet_opaque:4213:22594586,22591690:pet_opaque:4213:22592649,22593666:pet_opaque:4213:22594693,22593667:pet_opaque:4213:22593994,22596387:pet_opaque:4213:22596528,22598767:pet_opaque:4213:22599100,22602554:pet_opaque:4213:22602848,22603023:pet_opaque:4213:22603478,22603025:pet_opaque:4213:22603245,22604316:pet_opaque:4213:22604472,22606121:pet_opaque:4213:22606575,22608596:pet_opaque:4213:22608674,2261'}), 'main_stat': {'nb_photos': 12000}}, 'hostname': (), 'impurety_average_per_hashtag': [(('refus', '2025-05', 0.10331977271394516),)]}
 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 !
 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 !
 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 !
 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 !
 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 !
 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 !
 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 !
SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142

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=3142
 
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= 3142
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=3142
# 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=3996

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=3996
 
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= 3996
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=3996
# 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 !
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 10383 mask_detect is not consistent : 3 used against 2 in the step definition !
WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition !
WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition !
Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used !
Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition !
WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition !
WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition !
Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used !
Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used !
Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10385 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 2 of step 10383 doesn't seem to be define in the database(
WARNING : type of input 2 of step 10387 doesn't seem to be define in the database(
WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7
WARNING : type of output 2 of step 10390 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10384 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 1 of step 10391 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of output 1 of step 10392 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of input 5 of step 10393 doesn't seem to be define in the database(
WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None
WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18
WARNING : type of output 3 of step 11838 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 2 of step 11838 doesn't seem to be define in the database(
WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None
WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2
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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}}
Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier 
TODO : Insert select and so on
SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="refus_amiens";
SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142

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=3142
 
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= 3142
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=3142
# 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=3996

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=3996
 
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= 3996
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=3996
# 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 !
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 10383 mask_detect is not consistent : 3 used against 2 in the step definition !
WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition !
WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition !
Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used !
Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition !
WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition !
Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs !
WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition !
WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition !
Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs !
Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used !
Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used !
Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10385 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 2 of step 10383 doesn't seem to be define in the database(
WARNING : type of input 2 of step 10387 doesn't seem to be define in the database(
WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7
WARNING : type of output 2 of step 10390 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10384 doesn't seem to be define in the database(
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6
We ignore checkConsistencyTypeOutputInput for datou_step final !
WARNING : type of output 1 of step 10391 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of output 1 of step 10392 doesn't seem to be define in the database(
WARNING : type of input 3 of step 10387 doesn't seem to be define in the database(
WARNING : type of input 5 of step 10393 doesn't seem to be define in the database(
WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None
WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18
WARNING : type of output 3 of step 11838 doesn't seem to be define in the database(
WARNING : type of input 1 of step 10386 doesn't seem to be define in the database(
WARNING : type of input 2 of step 11838 doesn't seem to be define in the database(
WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None
WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2
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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}}
Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier 
{'number_of_analysed_photos': ((12000,),), 'unwanted_material_monthly_percentage': ((0.10331977271394516,),), 'material_repartition': (('refus', 10583),), 'material_dict': {'refus': 10583}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 5, 1), 0.11023146268894168, 458), (datetime.date(2025, 5, 2), 0.1256255107070303, 831), (datetime.date(2025, 5, 3), 0.10416531524651948, 603), (datetime.date(2025, 5, 4), 0.09830845288760594, 776), (datetime.date(2025, 5, 5), 0.10685529330174312, 829), (datetime.date(2025, 5, 6), 0.10485862491321449, 829), (datetime.date(2025, 5, 7), 0.10053641971608346, 636), (datetime.date(2025, 5, 8), 0.10583470739188885, 469), (datetime.date(2025, 5, 9), 0.10895708074921258, 778), (datetime.date(2025, 5, 10), 0.11013524485911749, 948), (datetime.date(2025, 5, 11), 0.09882519522049817, 838), (datetime.date(2025, 5, 12), 0.10041374887781995, 705), (datetime.date(2025, 5, 13), 0.1015255735998246, 819), (datetime.date(2025, 5, 14), 0.006486823746083324, 6), (datetime.date(2025, 5, 15), 0.10192511923576716, 414), (datetime.date(2025, 5, 16), 0.09484677481249783, 644)), 'impurety_average_data_per_hashtag': {'refus': ((datetime.date(2025, 5, 1), 0.11023146268894168, 458), (datetime.date(2025, 5, 2), 0.1256255107070303, 831), (datetime.date(2025, 5, 3), 0.10416531524651948, 603), (datetime.date(2025, 5, 4), 0.09830845288760594, 776), (datetime.date(2025, 5, 5), 0.10685529330174312, 829), (datetime.date(2025, 5, 6), 0.10485862491321449, 829), (datetime.date(2025, 5, 7), 0.10053641971608346, 636), (datetime.date(2025, 5, 8), 0.10583470739188885, 469), (datetime.date(2025, 5, 9), 0.10895708074921258, 778), (datetime.date(2025, 5, 10), 0.11013524485911749, 948), (datetime.date(2025, 5, 11), 0.09882519522049817, 838), (datetime.date(2025, 5, 12), 0.10041374887781995, 705), (datetime.date(2025, 5, 13), 0.1015255735998246, 819), (datetime.date(2025, 5, 14), 0.006486823746083324, 6), (datetime.date(2025, 5, 15), 0.10192511923576716, 414), (datetime.date(2025, 5, 16), 0.09484677481249783, 644))}, 'quality_array': [['-1.8881715545134514', '01052025'], ['-1.955362537527592', '02052025'], ['-1.9762816394913643', '03052025'], ['-2.1372272964361096', '04052025'], ['-2.2327913969653936', '05052025'], ['-2.1636799433060148', '06052025'], ['-2.101845084313718', '07052025'], ['-2.053263810732728', '08052025'], ['-2.358643080142321', '09052025'], ['-2.5663848874651047', '10052025'], ['-2.4650847583000224', '11052025'], ['-2.507615589967877', '12052025'], ['-2.358631525465645', '13052025'], ['0.8699901333875243', '14052025'], ['-2.536269304004159', '15052025'], ['-2.5601825115150345', '16052025']], 'number_of_batch': ((363,),), 'datou_id_sts': 3142, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003641112539478753, 'nb_photo': 2389, 'list_port_cont': '22580010,22580043,22580115,22580178,22580222,22580257,22580416,22582243,22583129,22583684,22584191,22584425,22587513,22588842,22588863,22592645,22593036,22593299,22593422,22593998,22594592,22594689,22594734,22596520,22599105,22602843,22603242,22603468,22604467,22606579,22608670,22611334,22614649,22617807,22618851,22621650,22624669,22628740,22630441,22637409,22637571,22637622,22637930,22638030,22638255,22639904,22640091,22640255,22640881,22640993,22642222,22643458,22644074,22645072,22645488,22646598,22646641,22646903,22647439,22650056,22650103,22650136,22655234,22655272,22655280,22655331,22655434,22655475,22655514,22655546,22655574,22655621,22655656,22655686,22655717,22655748,22655816,22655859,22655891,22655915,22655931,22655994,22656024,22656051,22656537,22656582,22660237,22661093,22661181,22661447,22661547,22661670,22661824,22664210,22665881,22668590,22670464,22671814,22673939,22675613,22684061,22686520,22686723,22689806,22690591,22693323,22696068,22701714,22701743,22702431,22708286,22708479,22708703,2270894', 'assoc_port': '22579895:22580222,22579896:22580257,22579897:22580115,22579898:22580178,22579899:22580010,22579900:22580043,22580332:22580416,22582223:22582243,22583005:22583129,22583532:22583684,22584171:22584191,22584408:22584425,22587177:22587513,22588823:22588863,22588824:22588842,22591685:22594734,22591686:22593036,22591687:22593299,22591688:22593422,22591689:22594592,22591690:22592645,22593666:22594689,22593667:22593998,22596387:22596520,22598767:22599105,22602554:22602843,22603023:22603468,22603025:22603242,22604316:22604467,22606121:22606579,22608596:22608670,22610993:22611334,22614519:22614649,22617416:22617807,22618639:22618851,22621383:22621650,22624122:22624669,22628398:22628740,22630325:22630441,22637348:22640881,22637349:22638030,22637350:22637930,22637351:22637622,22637352:22637409,22637353:22637571,22637992:22638255,22639304:22639904,22639971:22640255,22639972:22640091,22640911:22640993,22641870:22642222,22643360:22643458,22643978:22644074,22644963:22645072,22645331:22645488,22646470:22646641,22646471:2264659', 'assoc_mat': '22579895:barquette_opaque:4213:22580222,22579896:barquette_opaque:4213:22580257,22579897:barquette_opaque:4213:22580115,22579898:barquette_opaque:4213:22580178,22579899:barquette_opaque:4213:22580010,22579900:barquette_opaque:4213:22580043,22580332:barquette_opaque:4213:22580416,22582223:barquette_opaque:4213:22582243,22583005:barquette_opaque:4213:22583129,22583532:barquette_opaque:4213:22583684,22584171:barquette_opaque:4213:22584191,22584408:barquette_opaque:4213:22584425,22587177:barquette_opaque:4213:22587513,22588823:barquette_opaque:4213:22588863,22588824:barquette_opaque:4213:22588842,22591685:barquette_opaque:4213:22594734,22591686:barquette_opaque:4213:22593036,22591687:barquette_opaque:4213:22593299,22591688:barquette_opaque:4213:22593422,22591689:barquette_opaque:4213:22594592,22591690:barquette_opaque:4213:22592645,22593666:barquette_opaque:4213:22594689,22593667:barquette_opaque:4213:22593998,22596387:barquette_opaque:4213:22596520,22598767:barquette_opaque:4213:22599105,22602554:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.002438628733274117, 'nb_photo': 2332, 'list_port_cont': '22579999,22580039,22580087,22580125,22580176,22580209,22580248,22580426,22582240,22583687,22584192,22584429,22587521,22588829,22588866,22592646,22593051,22593305,22593432,22594004,22594593,22594691,22594730,22596519,22599097,22602853,22603250,22603482,22604481,22606576,22608649,22611339,22614658,22617812,22618863,22621640,22624673,22628745,22630438,22637413,22637564,22637625,22637919,22638035,22638243,22639905,22640256,22640882,22640994,22642223,22643454,22644070,22645073,22645499,22645748,22646595,22646631,22646909,22650068,22650102,22650121,22655233,22655274,22655290,22655342,22655436,22655479,22655487,22655549,22655577,22655611,22655640,22655690,22655714,22655749,22655818,22655850,22655884,22655918,22655943,22655984,22656032,22656065,22656546,22656590,22660241,22661089,22661193,22661446,22661561,22661656,22661834,22664213,22665885,22668603,22670470,22671809,22673933,22675608,22684071,22686528,22686724,22689810,22690594,22693338,22701712,22701750,22702434,22708294,22708484,22708701,22708939,22709179,2270921', 'assoc_port': '22579895:22580209,22579896:22580248,22579897:22580125,22579898:22580176,22579899:22579999,22579900:22580039,22579901:22580087,22580332:22580426,22582223:22582240,22583532:22583687,22584171:22584192,22584408:22584429,22587177:22587521,22588823:22588866,22588824:22588829,22591685:22594730,22591686:22593051,22591687:22593305,22591688:22593432,22591689:22594593,22591690:22592646,22593666:22594691,22593667:22594004,22596387:22596519,22598767:22599097,22602554:22602853,22603023:22603482,22603025:22603250,22604316:22604481,22606121:22606576,22608596:22608649,22610993:22611339,22614519:22614658,22617416:22617812,22618639:22618863,22621383:22621640,22624122:22624673,22628398:22628745,22630325:22630438,22637348:22640882,22637349:22638035,22637350:22637919,22637351:22637625,22637352:22637413,22637353:22637564,22637992:22638243,22639304:22639905,22639971:22640256,22640911:22640994,22641870:22642223,22643360:22643454,22643978:22644070,22644963:22645073,22645331:22645499,22645717:22645748,22646470:22646631,22646471:2264659', 'assoc_mat': '22579895:carton:4213:22580209,22579896:carton:4213:22580248,22579897:carton:4213:22580125,22579898:carton:4213:22580176,22579899:carton:4213:22579999,22579900:carton:4213:22580039,22579901:carton:4213:22580087,22580332:carton:4213:22580426,22582223:carton:4213:22582240,22583532:carton:4213:22583687,22584171:carton:4213:22584192,22584408:carton:4213:22584429,22587177:carton:4213:22587521,22588823:carton:4213:22588866,22588824:carton:4213:22588829,22591685:carton:4213:22594730,22591686:carton:4213:22593051,22591687:carton:4213:22593305,22591688:carton:4213:22593432,22591689:carton:4213:22594593,22591690:carton:4213:22592646,22593666:carton:4213:22594691,22593667:carton:4213:22594004,22596387:carton:4213:22596519,22598767:carton:4213:22599097,22602554:carton:4213:22602853,22603023:carton:4213:22603482,22603025:carton:4213:22603250,22604316:carton:4213:22604481,22606121:carton:4213:22606576,22608596:carton:4213:22608649,22610993:carton:4213:22611339,22614519:carton:4213:22614658,22617416:carton:4213:22617812,2261'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003577989831983466, 'nb_photo': 755, 'list_port_cont': '22579998,22580078,22580123,22580188,22580221,22580253,22580410,22583676,22584205,22584416,22587493,22588844,22588869,22592642,22593039,22593304,22593418,22594003,22594600,22594696,22594731,22596532,22599091,22602847,22603470,22604473,22606573,22611348,22614644,22617813,22618862,22621656,22624676,22628751,22630436,22637412,22637567,22637917,22638043,22638242,22639900,22640264,22640883,22640992,22642214,22643453,22645067,22645494,22646605,22646900,22650053,22650087,22650130,22655226,22655300,22655341,22655495,22655583,22655612,22655651,22655677,22655823,22655861,22655883,22655996,22656029,22656539,22656584,22660244,22661100,22661194,22661450,22661560,22661664,22661836,22664203,22665882,22673930,22675597,22684067,22686518,22686718,22689803,22696061,22701708,22701737,22702430,22708299,22708487,22708702,22708946,22709183,22709606,22710947,22712052,22713520,22714654,22715481,22718170,22721916,22724281,22726176,22728141,22729461,22730948,22735996,22745058,22753925,22754728,22754910,22755128,22755329,22758377,2276016', 'assoc_port': '22579895:22580221,22579896:22580253,22579897:22580123,22579898:22580188,22579899:22579998,22579901:22580078,22580332:22580410,22583532:22583676,22584171:22584205,22584408:22584416,22587177:22587493,22588823:22588869,22588824:22588844,22591685:22594731,22591686:22593039,22591687:22593304,22591688:22593418,22591689:22594600,22591690:22592642,22593666:22594696,22593667:22594003,22596387:22596532,22598767:22599091,22602554:22602847,22603023:22603470,22604316:22604473,22606121:22606573,22610993:22611348,22614519:22614644,22617416:22617813,22618639:22618862,22621383:22621656,22624122:22624676,22628398:22628751,22630325:22630436,22637348:22640883,22637349:22638043,22637350:22637917,22637352:22637412,22637353:22637567,22637992:22638242,22639304:22639900,22639971:22640264,22640911:22640992,22641870:22642214,22643360:22643453,22644963:22645067,22645331:22645494,22646471:22646605,22646800:22646900,22649978:22650053,22649979:22650130,22649980:22650087,22655128:22655583,22655129:22655612,22655130:22655883,22655152:2265602', 'assoc_mat': '22579895:ela:4213:22580221,22579896:ela:4213:22580253,22579897:ela:4213:22580123,22579898:ela:4213:22580188,22579899:ela:4213:22579998,22579901:ela:4213:22580078,22580332:ela:4213:22580410,22583532:ela:4213:22583676,22584171:ela:4213:22584205,22584408:ela:4213:22584416,22587177:ela:4213:22587493,22588823:ela:4213:22588869,22588824:ela:4213:22588844,22591685:ela:4213:22594731,22591686:ela:4213:22593039,22591687:ela:4213:22593304,22591688:ela:4213:22593418,22591689:ela:4213:22594600,22591690:ela:4213:22592642,22593666:ela:4213:22594696,22593667:ela:4213:22594003,22596387:ela:4213:22596532,22598767:ela:4213:22599091,22602554:ela:4213:22602847,22603023:ela:4213:22603470,22604316:ela:4213:22604473,22606121:ela:4213:22606573,22610993:ela:4213:22611348,22614519:ela:4213:22614644,22617416:ela:4213:22617813,22618639:ela:4213:22618862,22621383:ela:4213:22621656,22624122:ela:4213:22624676,22628398:ela:4213:22628751,22630325:ela:4213:22630436,22637348:ela:4213:22640883,22637349:ela:4213:22638043,22637350:ela:4213:2263791'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003339989417732796, 'nb_photo': 3563, 'list_port_cont': '22580002,22580031,22580082,22580111,22580180,22580213,22580252,22580417,22582237,22583122,22583679,22584193,22584426,22587516,22588831,22588871,22592650,22593040,22593314,22593428,22594009,22594597,22594692,22594728,22596530,22599093,22602841,22603239,22603483,22604482,22606581,22608652,22611345,22614655,22617808,22618858,22621643,22624663,22628736,22630447,22637416,22637566,22637623,22637918,22638031,22638244,22639907,22640102,22640269,22640877,22640989,22642221,22643455,22644081,22645066,22645490,22645756,22646589,22646634,22646910,22647431,22650054,22650093,22650134,22655241,22655260,22655286,22655339,22655446,22655470,22655485,22655535,22655579,22655606,22655647,22655678,22655708,22655756,22655812,22655860,22655885,22655928,22655937,22655995,22656020,22656066,22656541,22656578,22660231,22661092,22661188,22661434,22661545,22661665,22661827,22664202,22665888,22668591,22670473,22671813,22673931,22675602,22684066,22686523,22686714,22689804,22690583,22693325,22696063,22701707,22701746,22702427,22708289,2270848', 'assoc_port': '22579895:22580213,22579896:22580252,22579897:22580111,22579898:22580180,22579899:22580002,22579900:22580031,22579901:22580082,22580332:22580417,22582223:22582237,22583005:22583122,22583532:22583679,22584171:22584193,22584408:22584426,22587177:22587516,22588823:22588871,22588824:22588831,22591685:22594728,22591686:22593040,22591687:22593314,22591688:22593428,22591689:22594597,22591690:22592650,22593666:22594692,22593667:22594009,22596387:22596530,22598767:22599093,22602554:22602841,22603023:22603483,22603025:22603239,22604316:22604482,22606121:22606581,22608596:22608652,22610993:22611345,22614519:22614655,22617416:22617808,22618639:22618858,22621383:22621643,22624122:22624663,22628398:22628736,22630325:22630447,22637348:22640877,22637349:22638031,22637350:22637918,22637351:22637623,22637352:22637416,22637353:22637566,22637992:22638244,22639304:22639907,22639971:22640269,22639972:22640102,22640911:22640989,22641870:22642221,22643360:22643455,22643978:22644081,22644963:22645066,22645331:22645490,22645717:2264575', 'assoc_mat': '22579895:etiquette:4213:22580213,22579896:etiquette:4213:22580252,22579897:etiquette:4213:22580111,22579898:etiquette:4213:22580180,22579899:etiquette:4213:22580002,22579900:etiquette:4213:22580031,22579901:etiquette:4213:22580082,22580332:etiquette:4213:22580417,22582223:etiquette:4213:22582237,22583005:etiquette:4213:22583122,22583532:etiquette:4213:22583679,22584171:etiquette:4213:22584193,22584408:etiquette:4213:22584426,22587177:etiquette:4213:22587516,22588823:etiquette:4213:22588871,22588824:etiquette:4213:22588831,22591685:etiquette:4213:22594728,22591686:etiquette:4213:22593040,22591687:etiquette:4213:22593314,22591688:etiquette:4213:22593428,22591689:etiquette:4213:22594597,22591690:etiquette:4213:22592650,22593666:etiquette:4213:22594692,22593667:etiquette:4213:22594009,22596387:etiquette:4213:22596530,22598767:etiquette:4213:22599093,22602554:etiquette:4213:22602841,22603023:etiquette:4213:22603483,22603025:etiquette:4213:22603239,22604316:etiquette:4213:22604482,22606121:etiquette:4213:22606581,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0321886213260326, 'nb_photo': 7883, 'list_port_cont': '22580005,22580037,22580077,22580114,22580185,22580210,22580255,22580423,22582239,22583120,22583678,22584204,22584413,22587517,22588837,22588865,22592652,22593041,22593307,22593424,22594008,22594594,22594688,22594726,22596527,22599090,22602846,22603249,22603476,22604471,22606580,22608654,22611337,22614654,22617816,22618849,22621653,22624668,22628749,22630446,22637418,22637570,22637618,22637932,22638032,22638252,22639909,22640088,22640261,22640878,22640996,22642215,22643443,22644079,22645070,22645502,22645755,22646599,22646639,22646905,22647437,22650063,22650098,22650124,22655235,22655267,22655277,22655343,22655440,22655476,22655497,22655540,22655575,22655615,22655655,22655681,22655720,22655758,22655828,22655856,22655896,22655920,22655942,22655998,22656021,22656056,22656553,22656577,22660235,22661105,22661196,22661435,22661557,22661671,22661840,22664217,22665887,22668588,22670460,22671801,22673943,22675603,22684070,22686522,22686720,22689800,22690582,22693335,22696056,22701703,22701738,22702425,22708290,2270848', 'assoc_port': '22579895:22580210,22579896:22580255,22579897:22580114,22579898:22580185,22579899:22580005,22579900:22580037,22579901:22580077,22580332:22580423,22582223:22582239,22583005:22583120,22583532:22583678,22584171:22584204,22584408:22584413,22587177:22587517,22588823:22588865,22588824:22588837,22591685:22594726,22591686:22593041,22591687:22593307,22591688:22593424,22591689:22594594,22591690:22592652,22593666:22594688,22593667:22594008,22596387:22596527,22598767:22599090,22602554:22602846,22603023:22603476,22603025:22603249,22604316:22604471,22606121:22606580,22608596:22608654,22610993:22611337,22614519:22614654,22617416:22617816,22618639:22618849,22621383:22621653,22624122:22624668,22628398:22628749,22630325:22630446,22637348:22640878,22637349:22638032,22637350:22637932,22637351:22637618,22637352:22637418,22637353:22637570,22637992:22638252,22639304:22639909,22639971:22640261,22639972:22640088,22640911:22640996,22641870:22642215,22643360:22643443,22643978:22644079,22644963:22645070,22645331:22645502,22645717:2264575', 'assoc_mat': '22579895:film_plastique:4213:22580210,22579896:film_plastique:4213:22580255,22579897:film_plastique:4213:22580114,22579898:film_plastique:4213:22580185,22579899:film_plastique:4213:22580005,22579900:film_plastique:4213:22580037,22579901:film_plastique:4213:22580077,22580332:film_plastique:4213:22580423,22582223:film_plastique:4213:22582239,22583005:film_plastique:4213:22583120,22583532:film_plastique:4213:22583678,22584171:film_plastique:4213:22584204,22584408:film_plastique:4213:22584413,22587177:film_plastique:4213:22587517,22588823:film_plastique:4213:22588865,22588824:film_plastique:4213:22588837,22591685:film_plastique:4213:22594726,22591686:film_plastique:4213:22593041,22591687:film_plastique:4213:22593307,22591688:film_plastique:4213:22593424,22591689:film_plastique:4213:22594594,22591690:film_plastique:4213:22592652,22593666:film_plastique:4213:22594688,22593667:film_plastique:4213:22594008,22596387:film_plastique:4213:22596527,22598767:film_plastique:4213:22599090,22602554:film_plastique:4213:2260284'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.00047712249075355245, 'nb_photo': 36, 'list_port_cont': '22580118,22580174,22580206,22588875,22593315,22594704,22637568,22637931,22655587,22656580,22660239,22668592,22712054,22730942,22797065,22841356,22862360,22865172,22866357,22869415,22869438,22869853,22895291,22895528,22916084,22934818,22945187,23059870,23088358,23088526,23089775,23094057', 'assoc_port': '22579895:22580206,22579897:22580118,22579898:22580174,22588823:22588875,22591687:22593315,22593666:22594704,22637350:22637931,22637353:22637568,22655128:22655587,22656474:22656580,22659811:22660239,22667573:22668592,22712013:22712054,22725839:22730942,22796993:22797065,22841223:22841356,22856557:22862360,22862213:22865172,22866275:22866357,22869341:22869853,22869353:22869415,22869361:22869438,22892622:22895291,22892627:22895528,22913801:22916084,22928767:22945187,22934624:22934818,23017071:23059870,23052804:23088358,23052807:23088526,23056886:23089775,23074784:23094057', 'assoc_mat': '22579895:kraft:4213:22580206,22579897:kraft:4213:22580118,22579898:kraft:4213:22580174,22588823:kraft:4213:22588875,22591687:kraft:4213:22593315,22593666:kraft:4213:22594704,22637350:kraft:4213:22637931,22637353:kraft:4213:22637568,22655128:kraft:4213:22655587,22656474:kraft:4213:22656580,22659811:kraft:4213:22660239,22667573:kraft:4213:22668592,22712013:kraft:4213:22712054,22725839:kraft:4213:22730942,22796993:kraft:4213:22797065,22841223:kraft:4213:22841356,22856557:kraft:4213:22862360,22862213:kraft:4213:22865172,22866275:kraft:4213:22866357,22869341:kraft:4213:22869853,22869353:kraft:4213:22869415,22869361:kraft:4213:22869438,22892622:kraft:4213:22895291,22892627:kraft:4213:22895528,22913801:kraft:4213:22916084,22928767:kraft:4213:22945187,22934624:kraft:4213:22934818,23017071:kraft:4213:23059870,23052804:kraft:4213:23088358,23052807:kraft:4213:23088526,23056886:kraft:4213:23089775,23074784:kraft:4213:23094057'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0037179347862978775, 'nb_photo': 4582, 'list_port_cont': '22579997,22580030,22580084,22580120,22580183,22580214,22580247,22580413,22582242,22583118,22583680,22584190,22584420,22587489,22588835,22588873,22592641,22593045,22593301,22593419,22594006,22594596,22594702,22594735,22596524,22599104,22602838,22603254,22603474,22604477,22606582,22608650,22611341,22614659,22617810,22618855,22621644,22624674,22628737,22630440,22637422,22637563,22637629,22637933,22638028,22638250,22639912,22640103,22640262,22640885,22640990,22642229,22643447,22645064,22645495,22645740,22646592,22646633,22646904,22650061,22650094,22650123,22655237,22655271,22655276,22655332,22655432,22655478,22655489,22655543,22655571,22655607,22655642,22655675,22655718,22655753,22655824,22655862,22655889,22655927,22655932,22655982,22656019,22656055,22656550,22656576,22660246,22661104,22661182,22661445,22661555,22661657,22661825,22664207,22665889,22668600,22670461,22671805,22673941,22675611,22684060,22686530,22686722,22689799,22690581,22693328,22696060,22701709,22701748,22702421,22708291,22708482,22708711,2270895', 'assoc_port': '22579895:22580214,22579896:22580247,22579897:22580120,22579898:22580183,22579899:22579997,22579900:22580030,22579901:22580084,22580332:22580413,22582223:22582242,22583005:22583118,22583532:22583680,22584171:22584190,22584408:22584420,22587177:22587489,22588823:22588873,22588824:22588835,22591685:22594735,22591686:22593045,22591687:22593301,22591688:22593419,22591689:22594596,22591690:22592641,22593666:22594702,22593667:22594006,22596387:22596524,22598767:22599104,22602554:22602838,22603023:22603474,22603025:22603254,22604316:22604477,22606121:22606582,22608596:22608650,22610993:22611341,22614519:22614659,22617416:22617810,22618639:22618855,22621383:22621644,22624122:22624674,22628398:22628737,22630325:22630440,22637348:22640885,22637349:22638028,22637350:22637933,22637351:22637629,22637352:22637422,22637353:22637563,22637992:22638250,22639304:22639912,22639971:22640262,22639972:22640103,22640911:22640990,22641870:22642229,22643360:22643447,22644963:22645064,22645331:22645495,22645717:22645740,22646470:2264663', 'assoc_mat': '22579895:metal:4213:22580214,22579896:metal:4213:22580247,22579897:metal:4213:22580120,22579898:metal:4213:22580183,22579899:metal:4213:22579997,22579900:metal:4213:22580030,22579901:metal:4213:22580084,22580332:metal:4213:22580413,22582223:metal:4213:22582242,22583005:metal:4213:22583118,22583532:metal:4213:22583680,22584171:metal:4213:22584190,22584408:metal:4213:22584420,22587177:metal:4213:22587489,22588823:metal:4213:22588873,22588824:metal:4213:22588835,22591685:metal:4213:22594735,22591686:metal:4213:22593045,22591687:metal:4213:22593301,22591688:metal:4213:22593419,22591689:metal:4213:22594596,22591690:metal:4213:22592641,22593666:metal:4213:22594702,22593667:metal:4213:22594006,22596387:metal:4213:22596524,22598767:metal:4213:22599104,22602554:metal:4213:22602838,22603023:metal:4213:22603474,22603025:metal:4213:22603254,22604316:metal:4213:22604477,22606121:metal:4213:22606582,22608596:metal:4213:22608650,22610993:metal:4213:22611341,22614519:metal:4213:22614659,22617416:metal:4213:22617810,22618639:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0395553781603902, 'nb_photo': 13142, 'list_port_cont': '22580004,22580038,22580073,22580117,22580186,22580219,22580243,22580424,22582230,22583133,22583683,22584201,22584428,22587503,22588833,22588864,22592648,22593037,22593313,22593421,22594000,22594595,22594697,22594738,22596525,22599089,22602849,22603244,22603484,22604480,22606583,22608655,22611347,22614657,22617815,22618860,22621648,22624675,22628742,22630445,22637420,22637576,22637626,22637920,22638038,22638251,22639897,22640097,22640265,22640891,22641002,22642216,22643445,22644080,22645068,22645500,22645744,22646590,22646637,22646911,22647438,22650064,22650100,22650122,22655236,22655263,22655288,22655333,22655433,22655477,22655511,22655537,22655580,22655613,22655644,22655674,22655716,22655754,22655827,22655858,22655895,22655914,22655939,22655988,22656028,22656058,22656545,22656583,22660238,22661098,22661180,22661442,22661556,22661662,22661830,22664200,22665883,22668595,22670463,22671802,22673934,22675605,22684056,22686521,22686725,22689807,22690589,22693326,22696057,22701718,22701740,22702420,22708295,2270848', 'assoc_port': '22579895:22580219,22579896:22580243,22579897:22580117,22579898:22580186,22579899:22580004,22579900:22580038,22579901:22580073,22580332:22580424,22582223:22582230,22583005:22583133,22583532:22583683,22584171:22584201,22584408:22584428,22587177:22587503,22588823:22588864,22588824:22588833,22591685:22594738,22591686:22593037,22591687:22593313,22591688:22593421,22591689:22594595,22591690:22592648,22593666:22594697,22593667:22594000,22596387:22596525,22598767:22599089,22602554:22602849,22603023:22603484,22603025:22603244,22604316:22604480,22606121:22606583,22608596:22608655,22610993:22611347,22614519:22614657,22617416:22617815,22618639:22618860,22621383:22621648,22624122:22624675,22628398:22628742,22630325:22630445,22637348:22640891,22637349:22638038,22637350:22637920,22637351:22637626,22637352:22637420,22637353:22637576,22637992:22638251,22639304:22639897,22639971:22640265,22639972:22640097,22640911:22641002,22641870:22642216,22643360:22643445,22643978:22644080,22644963:22645068,22645331:22645500,22645717:2264574', 'assoc_mat': '22579895:papier:4213:22580219,22579896:papier:4213:22580243,22579897:papier:4213:22580117,22579898:papier:4213:22580186,22579899:papier:4213:22580004,22579900:papier:4213:22580038,22579901:papier:4213:22580073,22580332:papier:4213:22580424,22582223:papier:4213:22582230,22583005:papier:4213:22583133,22583532:papier:4213:22583683,22584171:papier:4213:22584201,22584408:papier:4213:22584428,22587177:papier:4213:22587503,22588823:papier:4213:22588864,22588824:papier:4213:22588833,22591685:papier:4213:22594738,22591686:papier:4213:22593037,22591687:papier:4213:22593313,22591688:papier:4213:22593421,22591689:papier:4213:22594595,22591690:papier:4213:22592648,22593666:papier:4213:22594697,22593667:papier:4213:22594000,22596387:papier:4213:22596525,22598767:papier:4213:22599089,22602554:papier:4213:22602849,22603023:papier:4213:22603484,22603025:papier:4213:22603244,22604316:papier:4213:22604480,22606121:papier:4213:22606583,22608596:papier:4213:22608655,22610993:papier:4213:22611347,22614519:papier:4213:22614657,2261'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0036203868380213144, 'nb_photo': 194, 'list_port_cont': '22580173,22580425,22582227,22584422,22588878,22593046,22593425,22594729,22596521,22603253,22604469,22611349,22618854,22637569,22637925,22640889,22640998,22642224,22644073,22645069,22645496,22646906,22650092,22650137,22655230,22655281,22655336,22655491,22655573,22655680,22655752,22655820,22655887,22656022,22656548,22656586,22661096,22661832,22670474,22671810,22686726,22690585,22701710,22708292,22708490,22708947,22709599,22714666,22715478,22718183,22720678,22721919,22724276,22726172,22728137,22730941,22745071,22754721,22755143,22755262,22755983,22758374,22765436,22773150,22778019,22792639,22796145,22798222,22799295,22801149,22807057,22813019,22813176,22815814,22815954,22823323,22829107,22835573,22837704,22839245,22852429,22852571,22859271,22862788,22862912,22865285,22865688,22865769,22865799,22865945,22865981,22866360,22869450,22869472,22869611,22869648,22869854,22869890,22869909,22874451,22874675,22875646,22876211,22883074,22895187,22895282,22895658,22902147,22907425,22909188,22927537,22934829,22941894,2294514', 'assoc_port': '22579898:22580173,22580332:22580425,22582223:22582227,22584408:22584422,22588823:22588878,22591685:22594729,22591686:22593046,22591688:22593425,22596387:22596521,22603025:22603253,22604316:22604469,22610993:22611349,22618639:22618854,22637348:22640889,22637350:22637925,22637353:22637569,22640911:22640998,22641870:22642224,22643978:22644073,22644963:22645069,22645331:22645496,22646800:22646906,22649979:22650137,22649980:22650092,22655128:22655573,22655130:22655887,22655152:22656022,22655175:22655820,22655177:22655680,22655178:22655491,22655179:22655752,22655183:22655230,22655184:22655336,22655186:22655281,22656473:22656548,22656474:22656586,22659807:22661096,22659812:22661832,22669964:22670474,22671357:22671810,22683403:22686726,22690257:22690585,22701571:22701710,22707544:22708490,22707546:22708947,22707549:22709599,22707550:22708292,22714510:22714666,22715124:22715478,22717627:22718183,22719588:22720678,22720606:22721919,22721977:22724276,22725838:22726172,22725839:22730941,22727724:22728137,22744791:2274507', 'assoc_mat': '22579898:pehd:4213:22580173,22580332:pehd:4213:22580425,22582223:pehd:4213:22582227,22584408:pehd:4213:22584422,22588823:pehd:4213:22588878,22591685:pehd:4213:22594729,22591686:pehd:4213:22593046,22591688:pehd:4213:22593425,22596387:pehd:4213:22596521,22603025:pehd:4213:22603253,22604316:pehd:4213:22604469,22610993:pehd:4213:22611349,22618639:pehd:4213:22618854,22637348:pehd:4213:22640889,22637350:pehd:4213:22637925,22637353:pehd:4213:22637569,22640911:pehd:4213:22640998,22641870:pehd:4213:22642224,22643978:pehd:4213:22644073,22644963:pehd:4213:22645069,22645331:pehd:4213:22645496,22646800:pehd:4213:22646906,22649979:pehd:4213:22650137,22649980:pehd:4213:22650092,22655128:pehd:4213:22655573,22655130:pehd:4213:22655887,22655152:pehd:4213:22656022,22655175:pehd:4213:22655820,22655177:pehd:4213:22655680,22655178:pehd:4213:22655491,22655179:pehd:4213:22655752,22655183:pehd:4213:22655230,22655184:pehd:4213:22655336,22655186:pehd:4213:22655281,22656473:pehd:4213:22656548,22656474:pehd:4213:22656586,22659807:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.018854720131323225, 'nb_photo': 9763, 'list_port_cont': '22579995,22580033,22580074,22580119,22580172,22580215,22580244,22580419,22582231,22583119,22583682,22584199,22584427,22587518,22588843,22588862,22592636,22593038,22593308,22593433,22593995,22594588,22594698,22594725,22596531,22599095,22602842,22603255,22603469,22604474,22606572,22608668,22611333,22614645,22617817,22618861,22621647,22624667,22628750,22630448,22637419,22637561,22637619,22637926,22638040,22638248,22639902,22640094,22640270,22640892,22641001,22642218,22643459,22644072,22645061,22645493,22645754,22646600,22646647,22646908,22647442,22650067,22650088,22650127,22655229,22655273,22655296,22655334,22655439,22655467,22655515,22655544,22655576,22655609,22655645,22655682,22655712,22655751,22655813,22655846,22655881,22655929,22655933,22655991,22656025,22656064,22656540,22656574,22660245,22661103,22661189,22661441,22661553,22661655,22661833,22664216,22665880,22668601,22670466,22671816,22673932,22675610,22684065,22686533,22686730,22689808,22690580,22693334,22696067,22701706,22701749,22702432,22708301,2270849', 'assoc_port': '22579895:22580215,22579896:22580244,22579897:22580119,22579898:22580172,22579899:22579995,22579900:22580033,22579901:22580074,22580332:22580419,22582223:22582231,22583005:22583119,22583532:22583682,22584171:22584199,22584408:22584427,22587177:22587518,22588823:22588862,22588824:22588843,22591685:22594725,22591686:22593038,22591687:22593308,22591688:22593433,22591689:22594588,22591690:22592636,22593666:22594698,22593667:22593995,22596387:22596531,22598767:22599095,22602554:22602842,22603023:22603469,22603025:22603255,22604316:22604474,22606121:22606572,22608596:22608668,22610993:22611333,22614519:22614645,22617416:22617817,22618639:22618861,22621383:22621647,22624122:22624667,22628398:22628750,22630325:22630448,22637348:22640892,22637349:22638040,22637350:22637926,22637351:22637619,22637352:22637419,22637353:22637561,22637992:22638248,22639304:22639902,22639971:22640270,22639972:22640094,22640911:22641001,22641870:22642218,22643360:22643459,22643978:22644072,22644963:22645061,22645331:22645493,22645717:2264575', 'assoc_mat': '22579895:pet_clair:4213:22580215,22579896:pet_clair:4213:22580244,22579897:pet_clair:4213:22580119,22579898:pet_clair:4213:22580172,22579899:pet_clair:4213:22579995,22579900:pet_clair:4213:22580033,22579901:pet_clair:4213:22580074,22580332:pet_clair:4213:22580419,22582223:pet_clair:4213:22582231,22583005:pet_clair:4213:22583119,22583532:pet_clair:4213:22583682,22584171:pet_clair:4213:22584199,22584408:pet_clair:4213:22584427,22587177:pet_clair:4213:22587518,22588823:pet_clair:4213:22588862,22588824:pet_clair:4213:22588843,22591685:pet_clair:4213:22594725,22591686:pet_clair:4213:22593038,22591687:pet_clair:4213:22593308,22591688:pet_clair:4213:22593433,22591689:pet_clair:4213:22594588,22591690:pet_clair:4213:22592636,22593666:pet_clair:4213:22594698,22593667:pet_clair:4213:22593995,22596387:pet_clair:4213:22596531,22598767:pet_clair:4213:22599095,22602554:pet_clair:4213:22602842,22603023:pet_clair:4213:22603469,22603025:pet_clair:4213:22603255,22604316:pet_clair:4213:22604474,22606121:pet_clair:4213:22606572,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0003671544816559988, 'nb_photo': 130, 'list_port_cont': '22579996,22580032,22582241,22593303,22593427,22599096,22602852,22603472,22604478,22606578,22628741,22637574,22637621,22638253,22639906,22643446,22645063,22645492,22650125,22655654,22655685,22655826,22655847,22655992,22660243,22664212,22665884,22668598,22684068,22686531,22701713,22701747,22708288,22708950,22709188,22709223,22713526,22715477,22724271,22728146,22730947,22754715,22755129,22755267,22758370,22760155,22784681,22796261,22798238,22801146,22807091,22807947,22816622,22823333,22824871,22835571,22839258,22852576,22859136,22865174,22865287,22865649,22865796,22869618,22869683,22869752,22869822,22869857,22874457,22874970,22875144,22878780,22895043,22896570,22902142,22907427,22909197,22915669,22918877,22927551,22945156,22945229,23039880,23074012,23085706,23088049,23088444,23089774,23090062,23090529,23094060,23095311', 'assoc_port': '22579899:22579996,22579900:22580032,22582223:22582241,22591687:22593303,22591688:22593427,22598767:22599096,22602554:22602852,22603023:22603472,22604316:22604478,22606121:22606578,22628398:22628741,22637351:22637621,22637353:22637574,22637992:22638253,22639304:22639906,22643360:22643446,22644963:22645063,22645331:22645492,22649979:22650125,22655153:22655847,22655172:22655992,22655174:22655654,22655175:22655826,22655177:22655685,22659811:22660243,22662921:22664212,22665550:22665884,22667573:22668598,22683378:22684068,22686196:22686531,22701570:22701747,22701571:22701713,22707546:22708950,22707547:22709188,22707548:22709223,22707550:22708288,22713376:22713526,22715124:22715477,22721977:22724271,22725839:22730947,22727724:22728146,22753273:22754715,22753295:22755129,22753305:22755267,22757930:22758370,22759840:22760155,22784175:22784681,22795866:22796261,22798157:22798238,22798630:22801146,22806754:22807091,22807823:22807947,22816363:22816622,22823160:22823333,22824273:22824871,22835527:22835571,22838964:2283925', 'assoc_mat': '22579899:pet_fonce:4213:22579996,22579900:pet_fonce:4213:22580032,22582223:pet_fonce:4213:22582241,22591687:pet_fonce:4213:22593303,22591688:pet_fonce:4213:22593427,22598767:pet_fonce:4213:22599096,22602554:pet_fonce:4213:22602852,22603023:pet_fonce:4213:22603472,22604316:pet_fonce:4213:22604478,22606121:pet_fonce:4213:22606578,22628398:pet_fonce:4213:22628741,22637351:pet_fonce:4213:22637621,22637353:pet_fonce:4213:22637574,22637992:pet_fonce:4213:22638253,22639304:pet_fonce:4213:22639906,22643360:pet_fonce:4213:22643446,22644963:pet_fonce:4213:22645063,22645331:pet_fonce:4213:22645492,22649979:pet_fonce:4213:22650125,22655153:pet_fonce:4213:22655847,22655172:pet_fonce:4213:22655992,22655174:pet_fonce:4213:22655654,22655175:pet_fonce:4213:22655826,22655177:pet_fonce:4213:22655685,22659811:pet_fonce:4213:22660243,22662921:pet_fonce:4213:22664212,22665550:pet_fonce:4213:22665884,22667573:pet_fonce:4213:22668598,22683378:pet_fonce:4213:22684068,22686196:pet_fonce:4213:22686531,22701570:pet_fonce:4213:22701747,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.008327591816352835, 'nb_photo': 3169, 'list_port_cont': '22580042,22580122,22580187,22580216,22580249,22580412,22582235,22583131,22583690,22584202,22584424,22587519,22588834,22588872,22592649,22593042,22593309,22593420,22593994,22594586,22594693,22594727,22596528,22599100,22602848,22603245,22603478,22604472,22606575,22608674,22611342,22614648,22617811,22618856,22621645,22624665,22628739,22630444,22637421,22637560,22637632,22637927,22638034,22638258,22639901,22640099,22640258,22640886,22640997,22642220,22643450,22644065,22645065,22645498,22645750,22646594,22646646,22646898,22647435,22650069,22650097,22650128,22655225,22655262,22655278,22655335,22655444,22655471,22655509,22655536,22655581,22655605,22655649,22655724,22655750,22655817,22655853,22655888,22655926,22655947,22655985,22656026,22656053,22656542,22656575,22660230,22661102,22661192,22661443,22661554,22661663,22661839,22664208,22665877,22668599,22670469,22671806,22673942,22675599,22684055,22686525,22686715,22689798,22690587,22693324,22696059,22701704,22701739,22702433,22708296,22708483,22708700,22708937,2270918', 'assoc_port': '22579895:22580216,22579896:22580249,22579897:22580122,22579898:22580187,22579900:22580042,22580332:22580412,22582223:22582235,22583005:22583131,22583532:22583690,22584171:22584202,22584408:22584424,22587177:22587519,22588823:22588872,22588824:22588834,22591685:22594727,22591686:22593042,22591687:22593309,22591688:22593420,22591689:22594586,22591690:22592649,22593666:22594693,22593667:22593994,22596387:22596528,22598767:22599100,22602554:22602848,22603023:22603478,22603025:22603245,22604316:22604472,22606121:22606575,22608596:22608674,22610993:22611342,22614519:22614648,22617416:22617811,22618639:22618856,22621383:22621645,22624122:22624665,22628398:22628739,22630325:22630444,22637348:22640886,22637349:22638034,22637350:22637927,22637351:22637632,22637352:22637421,22637353:22637560,22637992:22638258,22639304:22639901,22639971:22640258,22639972:22640099,22640911:22640997,22641870:22642220,22643360:22643450,22643978:22644065,22644963:22645065,22645331:22645498,22645717:22645750,22646470:22646646,22646471:2264659', 'assoc_mat': '22579895:pet_opaque:4213:22580216,22579896:pet_opaque:4213:22580249,22579897:pet_opaque:4213:22580122,22579898:pet_opaque:4213:22580187,22579900:pet_opaque:4213:22580042,22580332:pet_opaque:4213:22580412,22582223:pet_opaque:4213:22582235,22583005:pet_opaque:4213:22583131,22583532:pet_opaque:4213:22583690,22584171:pet_opaque:4213:22584202,22584408:pet_opaque:4213:22584424,22587177:pet_opaque:4213:22587519,22588823:pet_opaque:4213:22588872,22588824:pet_opaque:4213:22588834,22591685:pet_opaque:4213:22594727,22591686:pet_opaque:4213:22593042,22591687:pet_opaque:4213:22593309,22591688:pet_opaque:4213:22593420,22591689:pet_opaque:4213:22594586,22591690:pet_opaque:4213:22592649,22593666:pet_opaque:4213:22594693,22593667:pet_opaque:4213:22593994,22596387:pet_opaque:4213:22596528,22598767:pet_opaque:4213:22599100,22602554:pet_opaque:4213:22602848,22603023:pet_opaque:4213:22603478,22603025:pet_opaque:4213:22603245,22604316:pet_opaque:4213:22604472,22606121:pet_opaque:4213:22606575,22608596:pet_opaque:4213:22608674,2261'}), 'main_stat': {'nb_photos': 12000}}, 'hostname': (), 'impurety_average_per_hashtag': [(('refus', '2025-05', 0.10331977271394516),)]}
filepath : /data_2/data_log/job/memo/refus_amiens/sla_mensuel_refus_amiens_mois_05_annee_2025.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
{'refus': {'barquette_opaque': ['barquette_opaque', '0.36%', 2389], 'carton': ['carton', '0.24%', 2332], 'ela': ['ela', '0.36%', 755], 'etiquette': ['etiquette', '0.33%', 3563], 'film_plastique': ['film_plastique', '3.22%', 7883], 'kraft': ['kraft', '0.05%', 36], 'metal': ['metal', '0.37%', 4582], 'papier': ['papier', '3.96%', 13142], 'pehd': ['pehd', '0.36%', 194], 'pet_clair': ['pet_clair', '1.89%', 9763], 'pet_fonce': ['pet_fonce', '0.04%', 130], 'pet_opaque': ['pet_opaque', '0.83%', 3169]}}
before organize_and_plot_impurety_average_data
before organize_and_plot_quality_photo_data
finish generating
filepath : /data_2/data_log/job/memo/refus_amiens/sla_mensuel_refus_amiens_mois_05_annee_2025.pdf
le fichier se trouve ici : /data_2/data_log/job/memo/refus_amiens
3.32user 2.69system 0:12.06elapsed 49%CPU (0avgtext+0avgdata 193988maxresident)k
176184inputs+576outputs (646major+68469minor)pagefaults 0swaps