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-02-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-02-06" )  as temp group by pid;
            
2025-02-06
no data for this date
retrieve info for 2025-02-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-02-05" )  as temp group by pid;
            
2025-02-05
no data for this date
retrieve info for 2025-02-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-02-04" )  as temp group by pid;
            
2025-02-04
no data for this date
retrieve info for 2025-02-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-02-03" )  as temp group by pid;
            
2025-02-03
no data for this date
retrieve info for 2025-02-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-02-02" )  as temp group by pid;
            
2025-02-02
no data for this date
retrieve info for 2025-02-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-02-01" )  as temp group by pid;
            
2025-02-01
no data for this date
retrieve info for 2025-01-31
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-01-31" )  as temp group by pid;
            
2025-01-31
no data for this date
retrieve info for 2025-01-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-01-30" )  as temp group by pid;
            
2025-01-30
no data for this date
retrieve info for 2025-01-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-01-29" )  as temp group by pid;
            
2025-01-29
no data for this date
retrieve info for 2025-01-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-01-28" )  as temp group by pid;
            
2025-01-28
no data for this date
retrieve info for 2025-01-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-01-27" )  as temp group by pid;
            
2025-01-27
no data for this date
retrieve info for 2025-01-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-01-26" )  as temp group by pid;
            
2025-01-26
no data for this date
retrieve info for 2025-01-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-01-25" )  as temp group by pid;
            
2025-01-25
no data for this date
retrieve info for 2025-01-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-01-24" )  as temp group by pid;
            
2025-01-24
no data for this date
retrieve info for 2025-01-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-01-23" )  as temp group by pid;
            
2025-01-23
no data for this date
retrieve info for 2025-01-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-01-22" )  as temp group by pid;
            
2025-01-22
no data for this date
retrieve info for 2025-01-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-01-21" )  as temp group by pid;
            
2025-01-21
no data for this date
retrieve info for 2025-01-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-01-20" )  as temp group by pid;
            
2025-01-20
no data for this date
retrieve info for 2025-01-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-01-19" )  as temp group by pid;
            
2025-01-19
no data for this date
retrieve info for 2025-01-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-01-18" )  as temp group by pid;
            
2025-01-18
no data for this date
retrieve info for 2025-01-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-01-17" )  as temp group by pid;
            
2025-01-17
no data for this date
retrieve info for 2025-01-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-01-16" )  as temp group by pid;
            
2025-01-16
no data for this date
retrieve info for 2025-01-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-01-15" )  as temp group by pid;
            
2025-01-15
no data for this date
retrieve info for 2025-01-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-01-14" )  as temp group by pid;
            
2025-01-14
no data for this date
retrieve info for 2025-01-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-01-13" )  as temp group by pid;
            
2025-01-13
no data for this date
retrieve info for 2025-01-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-01-12" )  as temp group by pid;
            
2025-01-12
no data for this date
retrieve info for 2025-01-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-01-11" )  as temp group by pid;
            
2025-01-11
no data for this date
retrieve info for 2025-01-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-01-10" )  as temp group by pid;
            
2025-01-10
no data for this date
retrieve info for 2025-01-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-01-09" )  as temp group by pid;
            
2025-01-09
no data for this date
retrieve info for 2025-01-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-01-08" )  as temp group by pid;
            
2025-01-08
no data for this date

We got nothing!
no time info
1.13user 0.46system 0:03.89elapsed 40%CPU (0avgtext+0avgdata 99568maxresident)k
32inputs+56outputs (2major+19628minor)pagefaults 0swaps