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

We got nothing!
no time info
1.09user 0.87system 0:38.43elapsed 5%CPU (0avgtext+0avgdata 99252maxresident)k
0inputs+88outputs (0major+19849minor)pagefaults 0swaps