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-03-14" ) as temp group by pid; 2025-03-14 no data for this date retrieve info for 2025-03-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-03-13" ) as temp group by pid; 2025-03-13 no data for this date retrieve info for 2025-03-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-03-12" ) as temp group by pid; 2025-03-12 no data for this date retrieve info for 2025-03-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-03-11" ) as temp group by pid; 2025-03-11 no data for this date retrieve info for 2025-03-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-03-10" ) as temp group by pid; 2025-03-10 no data for this date retrieve info for 2025-03-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-03-09" ) as temp group by pid; 2025-03-09 no data for this date retrieve info for 2025-03-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-03-08" ) as temp group by pid; 2025-03-08 no data for this date retrieve info for 2025-03-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-03-07" ) as temp group by pid; 2025-03-07 no data for this date retrieve info for 2025-03-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-03-06" ) as temp group by pid; 2025-03-06 no data for this date retrieve info for 2025-03-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-03-05" ) as temp group by pid; 2025-03-05 no data for this date retrieve info for 2025-03-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-03-04" ) as temp group by pid; 2025-03-04 no data for this date retrieve info for 2025-03-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-03-03" ) as temp group by pid; 2025-03-03 no data for this date retrieve info for 2025-03-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-03-02" ) as temp group by pid; 2025-03-02 no data for this date retrieve info for 2025-03-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-03-01" ) as temp group by pid; 2025-03-01 no data for this date retrieve info for 2025-02-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-02-28" ) as temp group by pid; 2025-02-28 no data for this date We got nothing! no time info 1.13user 0.76system 0:04.56elapsed 41%CPU (0avgtext+0avgdata 98372maxresident)k 0inputs+64outputs (13major+19850minor)pagefaults 0swaps