python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/mtr/utils/time_rubbia_live.py --last_days=30 --first_batch --dashboard_name="arc_en_ciel_jrm_peu_dense" -v ' -s temps_de_traitement -M 0 -S 0 -U 90,80,95
 import MySQLdb succeeded 
Import error (python version)
warning , we can't find thcl infos in json_data
warning , we can't find pdt infos in json_data

We are trying to retrieve info for the dashboard arc_en_ciel_jrm_peu_dense 

retrieve info for 2025-07-19
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-19" )  as temp group by pid;
            
2025-07-19
no data for this date
retrieve info for 2025-07-18
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-18" )  as temp group by pid;
            
2025-07-18
no data for this date
retrieve info for 2025-07-17
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-17" )  as temp group by pid;
            
2025-07-17
no data for this date
retrieve info for 2025-07-16
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-16" )  as temp group by pid;
            
2025-07-16
no data for this date
retrieve info for 2025-07-15
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-15" )  as temp group by pid;
            
2025-07-15
no data for this date
retrieve info for 2025-07-14
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-14" )  as temp group by pid;
            
2025-07-14
no data for this date
retrieve info for 2025-07-13
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-13" )  as temp group by pid;
            
2025-07-13
no data for this date
retrieve info for 2025-07-12
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-12" )  as temp group by pid;
            
2025-07-12
no data for this date
retrieve info for 2025-07-11
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-11" )  as temp group by pid;
            
2025-07-11
no data for this date
retrieve info for 2025-07-10
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-10" )  as temp group by pid;
            
2025-07-10
no data for this date
retrieve info for 2025-07-09
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-09" )  as temp group by pid;
            
2025-07-09
no data for this date
retrieve info for 2025-07-08
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-08" )  as temp group by pid;
            
2025-07-08
no data for this date
retrieve info for 2025-07-07
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-07" )  as temp group by pid;
            
2025-07-07
no data for this date
retrieve info for 2025-07-06
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-06" )  as temp group by pid;
            
2025-07-06
no data for this date
retrieve info for 2025-07-05
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-05" )  as temp group by pid;
            
2025-07-05
no data for this date
retrieve info for 2025-07-04
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-04" )  as temp group by pid;
            
2025-07-04
no data for this date
retrieve info for 2025-07-03
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-03" )  as temp group by pid;
            
2025-07-03
no data for this date
retrieve info for 2025-07-02
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-02" )  as temp group by pid;
            
2025-07-02
no data for this date
retrieve info for 2025-07-01
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-07-01" )  as temp group by pid;
            
2025-07-01
no data for this date
retrieve info for 2025-06-30
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-30" )  as temp group by pid;
            
2025-06-30
no data for this date
retrieve info for 2025-06-29
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-29" )  as temp group by pid;
            
2025-06-29
no data for this date
retrieve info for 2025-06-28
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-28" )  as temp group by pid;
            
2025-06-28
no data for this date
retrieve info for 2025-06-27
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-27" )  as temp group by pid;
            
2025-06-27
no data for this date
retrieve info for 2025-06-26
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-26" )  as temp group by pid;
            
2025-06-26
no data for this date
retrieve info for 2025-06-25
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-25" )  as temp group by pid;
            
2025-06-25
no data for this date
retrieve info for 2025-06-24
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-24" )  as temp group by pid;
            
2025-06-24
no data for this date
retrieve info for 2025-06-23
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-23" )  as temp group by pid;
            
2025-06-23
no data for this date
retrieve info for 2025-06-22
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-22" )  as temp group by pid;
            
2025-06-22
no data for this date
retrieve info for 2025-06-21
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-21" )  as temp group by pid;
            
2025-06-21
no data for this date
retrieve info for 2025-06-20
select pid,date_prise, min(traitement), taille_batch,  timestampdiff(minute,date_prise,min(traitement)) as diff from
                (select dr.date_debut as date_prise ,dr.nombre_balle as taille_batch ,dr.mtr_portfolio_id as pid , mdr.created_at as traitement
                from MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, 
                MTRPhoto.mtr_datou_result mdr, MTRUser.mtr_portfolio_photos mpp
                where dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and dp.name = "arc_en_ciel_jrm_peu_dense"
                and dr.mtr_portfolio_id not in (select mtr_portfolio_id from MTRPhoto.mtr_datou_current)
                and mpp.mtr_portfolio_id = dr.mtr_portfolio_id
                and mdr.mtr_photo_id = mpp.mtr_photo_id 
                and mdr.mtd_id = 4877 and mdr.proba > 0
                and ded.date = "2025-06-20" )  as temp group by pid;
            
2025-06-20
no data for this date

We got nothing!
no time info
1.04user 0.76system 0:21.56elapsed 8%CPU (0avgtext+0avgdata 99132maxresident)k
0inputs+72outputs (5major+19744minor)pagefaults 0swaps