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 emr' -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 "%emr" 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-14 10:09:38 ; 27791447 ; ; https://www.fotonower.com/velours/27791682,27791683,27791684,27791685,27791686,27791687,27791688,27791689,27791690,27791691,27791692,27791693,27791694,27791695,27791696,27791697?tags=pet_fonce,carton,barquette_opaque,kraft,metal,film_plastique,environnement,ela,flou,pehd,mal_croppe,papier,textiles_sanitaires,etiquette,pet_opaque,pet_clair
2025-10-14 19:09:28 ; 27809498 ; ; https://www.fotonower.com/velours/27821704,27821705,27821706,27821707,27821708,27821709,27821710,27821711,27821712,27821713,27821714,27821715,27821716,27821717,27821718,27821719?tags=kraft,flou,textiles_sanitaires,environnement,barquette_opaque,pet_clair,film_plastique,pehd,metal,mal_croppe,etiquette,carton,pet_opaque,ela,papier,pet_fonce
2025-10-16 07:39:09 ; 27864192 ; ; https://www.fotonower.com/velours/27864427,27864428,27864429,27864430,27864431,27864432,27864433,27864434,27864435,27864436,27864437,27864438,27864439,27864440,27864441,27864442?tags=pet_fonce,ela,papier,kraft,textiles_sanitaires,flou,film_plastique,pehd,carton,barquette_opaque,etiquette,metal,pet_opaque,mal_croppe,environnement,pet_clair
2025-10-09 20:18:08 ; 27661915 ; ; https://www.fotonower.com/velours/27661962,27661963,27661964,27661965,27661966,27661967,27661968,27661969,27661970,27661971,27661972,27661973,27661974,27661975,27661976,27661977?tags=ela,kraft,metal,etiquette,pehd,flou,mal_croppe,pet_fonce,papier,pet_clair,environnement,textiles_sanitaires,pet_opaque,carton,barquette_opaque,film_plastique
2025-10-08 15:29:58 ; 27741721 ; ; https://www.fotonower.com/velours/27741906,27741907,27741908,27741909,27741910,27741911,27741912,27741913,27741914,27741915,27741916,27741917,27741918,27741919,27741920,27741921?tags=film_plastique,environnement,kraft,pehd,ela,metal,pet_fonce,mal_croppe,carton,pet_clair,papier,flou,textiles_sanitaires,barquette_opaque,etiquette,pet_opaque
2025-10-15 08:17:58 ; 27825818 ; ; https://www.fotonower.com/velours/27825944,27825945,27825946,27825947,27825948,27825949,27825950,27825951,27825952,27825953,27825954,27825955,27825956,27825957,27825958,27825959?tags=ela,etiquette,pehd,textiles_sanitaires,kraft,flou,film_plastique,metal,mal_croppe,pet_opaque,pet_clair,pet_fonce,environnement,carton,papier,barquette_opaque
2025-10-01 09:45:49 ; 27395957 ; ; https://www.fotonower.com/velours/27396018,27396019,27396020,27396021,27396022,27396023,27396024,27396025,27396026,27396027,27396028,27396029,27396030,27396031,27396032,27396033?tags=papier,metal,carton,etiquette,kraft,pehd,pet_opaque,textiles_sanitaires,mal_croppe,ela,pet_fonce,barquette_opaque,pet_clair,flou,environnement,film_plastique
2025-10-15 15:27:39 ; 27833968 ; ; https://www.fotonower.com/velours/27833973,27833974,27833975,27833976,27833977,27833978,27833979,27833980,27833981,27833982,27833983,27833984,27833985,27833986,27833987,27833988?tags=pehd,metal,pet_fonce,pet_clair,mal_croppe,film_plastique,kraft,ela,flou,carton,papier,pet_opaque,etiquette,textiles_sanitaires,barquette_opaque,environnement
2025-10-01 17:48:19 ; 27413363 ; ; https://www.fotonower.com/velours/27413428,27413429,27413430,27413431,27413432,27413433,27413434,27413435,27413436,27413437,27413438,27413439,27413440,27413441,27413442,27413443?tags=pet_clair,pet_opaque,film_plastique,pet_fonce,papier,mal_croppe,ela,kraft,metal,pehd,carton,flou,etiquette,textiles_sanitaires,environnement,barquette_opaque
1.00user 0.66system 0:01.18elapsed 140%CPU (0avgtext+0avgdata 97904maxresident)k
0inputs+16outputs (4major+28029minor)pagefaults 0swaps