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' -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.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 and dr.qualite>0 group by dr.mtr_portfolio_id  order by qualite desc, count(mpp.mtr_photo_id) desc limit 9;
2025-10-31 14:45:39 ; 28034589 ; ; https://www.fotonower.com/velours/28044574,28044575,28044576,28044578,28044580,28044582,28044584,28044587,28044589,28044591,28044593,28044595,28044597,28044599,28044601,28044603?tags=metal,flou,papier,film_plastique,environnement,pet_clair,mal_croppe,carton,pet_fonce,etiquette,kraft,barquette_opaque,pehd,textiles_sanitaires,ela,pet_opaque
2025-10-08 20:19:49 ; 27748908 ; ; https://www.fotonower.com/velours/27749155,27749156,27749157,27749158,27749159,27749160,27749161,27749162,27749163,27749164,27749165,27749166,27749167,27749168,27749169,27749170?tags=carton,etiquette,barquette_opaque,pet_clair,textiles_sanitaires,kraft,mal_croppe,pehd,film_plastique,pet_fonce,ela,flou,metal,papier,environnement,pet_opaque
2025-10-23 17:47:17 ; 28008559 ; ; https://www.fotonower.com/velours/28009611,28009612,28009613,28009614,28009615,28009616,28009617,28009618,28009619,28009620,28009621,28009622,28009623,28009624,28009625,28009626?tags=pehd,pet_clair,barquette_opaque,kraft,carton,environnement,metal,papier,pet_opaque,textiles_sanitaires,ela,film_plastique,pet_fonce,etiquette,flou,mal_croppe
2025-10-10 17:17:57 ; 27720163 ; ; https://www.fotonower.com/velours/27720267,27720268,27720269,27720270,27720271,27720272,27720273,27720274,27720275,27720276,27720277,27720278,27720279,27720280,27720281,27720282?tags=etiquette,environnement,flou,barquette_opaque,pet_clair,pet_fonce,pehd,textiles_sanitaires,ela,kraft,mal_croppe,papier,carton,film_plastique,metal,pet_opaque
2025-10-15 09:37:37 ; 27828073 ; ; https://www.fotonower.com/velours/27828257,27828258,27828259,27828260,27828261,27828262,27828263,27828264,27828265,27828266,27828267,27828268,27828269,27828270,27828271,27828272?tags=kraft,pet_opaque,pet_fonce,film_plastique,flou,textiles_sanitaires,metal,ela,carton,pet_clair,pehd,environnement,papier,mal_croppe,etiquette,barquette_opaque
2025-10-10 17:57:28 ; 27711664 ; ; https://www.fotonower.com/velours/27712049,27712050,27712051,27712052,27712053,27712054,27712055,27712056,27712057,27712058,27712059,27712060,27712061,27712062,27712063,27712064?tags=metal,pet_fonce,film_plastique,kraft,flou,papier,pet_clair,textiles_sanitaires,carton,environnement,barquette_opaque,etiquette,mal_croppe,pehd,pet_opaque,ela
2025-10-29 17:41:37 ; 28090421 ; ; https://www.fotonower.com/velours/28117161,28117162,28117163,28117164,28117165,28117166,28117167,28117168,28117169,28117170,28117171,28117172,28117173,28117174,28117175,28117176?tags=pet_opaque,kraft,carton,environnement,mal_croppe,flou,pehd,ela,pet_clair,barquette_opaque,metal,etiquette,textiles_sanitaires,pet_fonce,film_plastique,papier
2025-10-01 19:00:09 ; 27415525 ; ; https://www.fotonower.com/velours/27415742,27415743,27415744,27415745,27415746,27415747,27415748,27415749,27415750,27415751,27415752,27415753,27415754,27415755,27415756,27415757?tags=kraft,mal_croppe,etiquette,ela,pet_opaque,pet_fonce,metal,environnement,pet_clair,papier,barquette_opaque,film_plastique,flou,carton,pehd,textiles_sanitaires
2025-10-16 10:13:38 ; 27900884 ; ; https://www.fotonower.com/velours/27909643,27909644,27909645,27909646,27909647,27909648,27909649,27909650,27909651,27909652,27909653,27909654,27909655,27909656,27909657,27909658?tags=textiles_sanitaires,pet_clair,environnement,film_plastique,kraft,etiquette,mal_croppe,pehd,metal,carton,pet_opaque,pet_fonce,papier,barquette_opaque,flou,ela
0.90user 0.68system 0:01.29elapsed 121%CPU (0avgtext+0avgdata 97836maxresident)k
24inputs+8outputs (0major+19634minor)pagefaults 0swaps