python /home/admin/mtr/script_for_cron.py -j default -m 30 -a 'python3 ~/workarea/git/Velours/python/mtr/utils/prepare_link_perlen_to_consolidate.py --dashboard angers_montee_convoyeur --date_debut 2025-10-01 --date_fin 2025-10-31 --matiere jrm' -s prepare_link -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
select dr.mtr_portfolio_id,dr.date_debut,dr.hashtag,dr.qualite,count(mpp.mtr_photo_id),dr.completion_json 
            from MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp where
            dr.hashtag like "%jrm" and dr.qualite>0 and dr.dashboard_run_id in (
            select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=36 and date in ('2025-10-01','2025-10-02','2025-10-03','2025-10-04','2025-10-05','2025-10-06','2025-10-07','2025-10-08','2025-10-09','2025-10-10','2025-10-11','2025-10-12','2025-10-13','2025-10-14','2025-10-15','2025-10-16','2025-10-17','2025-10-18','2025-10-19','2025-10-20','2025-10-21','2025-10-22','2025-10-23','2025-10-24','2025-10-25','2025-10-26','2025-10-27','2025-10-28','2025-10-29','2025-10-30','2025-10-31'))
            and mpp.mtr_portfolio_id=dr.mtr_portfolio_id group by dr.mtr_portfolio_id order by 
            qualite desc, count(mpp.mtr_photo_id) desc limit 9;
2025-10-06 15:37:44 ; 27632626 ; ; https://www.fotonower.com/velours/27633125,27633126,27633127,27633128,27633129,27633130,27633131,27633132,27633133,27633134,27633135,27633136?tags=Carton_gris,metal,kraft,autre_refus,mal_croppe,papier,flou,Carton_brun,plastique,Teint_Dans_La_Masse,environnement,cartonnette
2025-10-18 04:53:47 ; 27900573 ; ; https://www.fotonower.com/velours/27900764,27900765,27900766,27900767,27900769,27900770,27900771,27900774,27900776,27900779,27900782,27900785?tags=autre_refus,metal,Carton_brun,environnement,cartonnette,kraft,mal_croppe,plastique,flou,Carton_gris,Teint_Dans_La_Masse,papier
2025-10-21 23:06:07 ; 28010690 ; ; https://www.fotonower.com/velours/28011284,28011286,28011287,28011288,28011289,28011291,28011292,28011293,28011294,28011295,28011296,28011297?tags=environnement,papier,autre_refus,flou,Carton_brun,Teint_Dans_La_Masse,metal,cartonnette,plastique,mal_croppe,Carton_gris,kraft
2025-10-10 22:07:45 ; 27720164 ; ; https://www.fotonower.com/velours/27720201,27720202,27720203,27720204,27720205,27720206,27720207,27720208,27720209,27720210,27720211,27720212?tags=Carton_gris,autre_refus,kraft,cartonnette,mal_croppe,metal,plastique,Teint_Dans_La_Masse,flou,environnement,Carton_brun,papier
2025-10-06 15:03:45 ; 27632623 ; ; https://www.fotonower.com/velours/27632881,27632882,27632883,27632884,27632885,27632886,27632887,27632888,27632889,27632890,27632891,27632892?tags=autre_refus,papier,Carton_brun,kraft,Teint_Dans_La_Masse,environnement,mal_croppe,Carton_gris,flou,plastique,cartonnette,metal
2025-10-21 22:59:27 ; 28010637 ; ; https://www.fotonower.com/velours/28011148,28011149,28011150,28011151,28011152,28011153,28011154,28011155,28011156,28011157,28011158,28011159?tags=Carton_gris,plastique,metal,papier,Teint_Dans_La_Masse,mal_croppe,autre_refus,cartonnette,Carton_brun,flou,environnement,kraft
2025-10-01 16:50:38 ; 27413332 ; ; https://www.fotonower.com/velours/27413444,27413445,27413446,27413447,27413448,27413449,27413450,27413451,27413452,27413453,27413454,27413455?tags=Teint_Dans_La_Masse,mal_croppe,Carton_gris,kraft,metal,flou,autre_refus,papier,cartonnette,Carton_brun,plastique,environnement
2025-10-31 08:23:40 ; 28008659 ; ; https://www.fotonower.com/velours/28037347,28037348,28037349,28037350,28037351,28037352,28037353,28037354,28037355,28037356,28037357,28037358?tags=cartonnette,Carton_gris,mal_croppe,flou,plastique,kraft,metal,Teint_Dans_La_Masse,autre_refus,environnement,papier,Carton_brun
2025-10-31 03:43:09 ; 28001990 ; ; https://www.fotonower.com/velours/28003299,28003300,28003301,28003302,28003303,28003304,28003305,28003306,28003307,28003308,28003309,28003310?tags=autre_refus,Teint_Dans_La_Masse,kraft,flou,papier,mal_croppe,metal,environnement,Carton_brun,plastique,cartonnette,Carton_gris
0.92user 0.72system 0:01.12elapsed 146%CPU (0avgtext+0avgdata 98244maxresident)k
24inputs+8outputs (6major+19682minor)pagefaults 0swaps