python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 20 -a ' -a 4935' -s datou_current_4935 -M 0 -S 0 -U 95,95,120 import MySQLdb succeeded Import error (python version) ['/Users/moilerat/Documents/Fotonower/install/caffe/distribute/python', '/home/admin/workarea/git/Velours/python/prod', '/home/admin/workarea/install/caffe_cuda8_python3/python', '/home/admin/workarea/install/darknet', '/home/admin/workarea/git/Velours/python', '/home/admin/workarea/install/caffe_frcnn_python3/py-faster-rcnn/caffe-fast-rcnn/python', '/home/admin/mtr/.credentials', '/home/admin/workarea/install/caffe/python', '/home/admin/workarea/install/caffe_frcnn/py-faster-rcnn/tools', '/home/admin/workarea/git/fotonowerpip', '/home/admin/workarea/install/segment-anything', '/home/admin/workarea/git/pyfvs', '/usr/lib/python38.zip', '/usr/lib/python3.8', '/usr/lib/python3.8/lib-dynload', '/home/admin/.local/lib/python3.8/site-packages', '/usr/local/lib/python3.8/dist-packages', '/usr/lib/python3/dist-packages'] process id : 2587637 load datou : 4935 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Unexpected type for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? load thcls load pdts Running datou job : batch_current TODO datou_current to load to do maybe to take outside batchDatouExec no input labels no input values updating current state to 1 we have a portfolio with more photos than limit : 2603>1000 please execute split_portfolio.py -i 23444115 -l 1000 size over we load limit photo not treated list_input_json: {} Current got : datou_id : 4935, datou_cur_ids : ['2991339'] with mtr_portfolio_ids : ['23444115'] and first list_photo_ids : [] new path : /proc/2587637/ Inside batchDatouExec : verbose : 0 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! List Step Type Loaded in datou : merge_dashboard over limit max, limiting to limit_max 100 list_input_json : {} origin We have 1 , WARNING: data may be incomplete, need to offset and complete ! we have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB time to download the photos : 0.025667190551757812 About to test input to load Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 1 step1:merge_dashboard Sat May 31 00:00:29 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec 2022-04-13 10:29:59 0 TODO : Insert select and so on TODO : Insert select and so on to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do to do TODO : Insert select and so on INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 04:48:04', '2025-05-30 04:59:54', 10, 23445263, 0.05443944812640592, 2985637, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23445263_30-05-2025_05_26_31.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 23445276, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23445277, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23445278, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23445279, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23445280, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23445281, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23445282, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23445283, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23445284, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23445285, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23445286, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23445287, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 05:31:14', '2025-05-30 05:44:34', 8, 23445706, 0.08866459193146103, 2985730, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23445706_30-05-2025_07_26_02.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23445707, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23445708, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23445709, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23445710, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23445711, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23445712, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23445713, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23445714, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23445715, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23445716, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23445717, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23445718, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 06:02:54', '2025-05-30 06:14:44', 9, 23446036, -1.0, -1, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23446036_30-05-2025_06_43_01.pdf', 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23446051, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23446052, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23446053, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23446054, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23446055, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23446056, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23446057, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23446058, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23446059, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23446060, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23446061, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23446062, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 06:15:03', '2025-05-30 06:20:44', 14, 23446155, 0.09002697768069923, 2985811, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23446155_30-05-2025_07_02_59.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23446159, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23446160, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23446161, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23446162, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23446163, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23446164, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23446165, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23446166, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23446167, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23446168, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23446169, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23446170, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 13:16:04', '2025-05-30 13:29:54', 37, 23450391, 0.06861036754506752, 2986682, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23450391_30-05-2025_13_54_59.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23450392, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23450393, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23450394, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23450395, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23450396, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23450397, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23450398, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23450399, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23450400, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23450401, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23450402, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23450403, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 13:30:04', '2025-05-30 13:44:33', 73, 23450552, 0.05435491869478011, 2986756, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23450552_30-05-2025_14_11_32.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23450553, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23450554, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23450555, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23450556, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23450557, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23450558, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23450559, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23450560, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23450561, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23450562, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23450563, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23450564, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 13:45:14', '2025-05-30 13:59:54', 70, 23450832, 0.07584842652474179, 2986834, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23450832_30-05-2025_14_24_58.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 23450834, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23450835, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23450836, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23450837, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23450838, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23450839, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23450840, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23450841, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23450842, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23450843, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23450844, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23450845, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 14:00:04', '2025-05-30 14:14:54', 74, 23451020, 0.03213120169654901, 2986900, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23451020_30-05-2025_14_40_57.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 23451027, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23451028, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23451029, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23451030, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23451031, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23451032, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23451033, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23451034, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23451035, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23451036, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23451037, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23451038, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 14:15:04', '2025-05-30 14:29:54', 74, 23451411, 0.05996728967833512, 2987056, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23451411_30-05-2025_14_54_30.pdf', 'metal': {'hashtag': 'metal', 'sub_port_id': 23451416, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23451417, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23451418, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23451419, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23451420, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23451421, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23451422, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23451423, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23451424, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23451425, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23451426, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23451427, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 14:30:04', '2025-05-30 14:44:54', 73, 23451749, 0.050864360618282284, 2987208, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23451749_30-05-2025_15_09_31.pdf', 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23451750, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23451751, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23451752, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23451753, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23451754, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23451755, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23451756, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23451757, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23451758, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23451759, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23451760, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23451761, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 14:45:04', '2025-05-30 14:58:54', 68, 23452146, 0.040171989927842926, 2987308, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23452146_30-05-2025_15_26_59.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23452153, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23452154, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23452155, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23452156, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23452157, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23452158, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23452159, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23452160, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23452161, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23452162, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23452163, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23452164, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 15:00:14', '2025-05-30 15:14:54', 72, 23452638, 0.06099857793039236, 2987467, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23452638_30-05-2025_15_39_58.pdf', 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23452639, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23452640, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23452641, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23452642, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23452643, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23452644, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23452645, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23452646, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23452647, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23452648, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23452649, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23452650, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 15:15:35', '2025-05-30 15:29:55', 60, 23452865, -1.0, -1, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23452865_30-05-2025_15_56_59.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23452866, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23452867, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23452868, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23452869, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23452870, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23452871, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23452872, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23452873, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23452874, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23452875, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23452876, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23452877, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 15:30:04', '2025-05-30 15:44:54', 74, 23453145, 0.0708284110751183, 2987643, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23453145_30-05-2025_16_12_59.pdf', 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23453188, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23453189, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23453190, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23453191, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23453192, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23453193, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23453194, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23453195, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23453196, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23453197, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23453198, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23453199, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 15:45:14', '2025-05-30 15:59:53', 55, 23453891, 0.018156925894714862, 2987823, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23453891_30-05-2025_16_26_58.pdf', 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23453917, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23453918, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23453919, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23453920, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23453921, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23453922, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23453923, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23453924, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23453925, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23453926, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23453927, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23453928, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 16:00:03', '2025-05-30 16:14:53', 76, 23454337, 0.06885123786277302, 2987940, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23454337_30-05-2025_16_42_59.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23454355, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23454356, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23454357, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23454358, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23454359, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23454360, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23454361, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23454362, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23454363, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23454364, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23454365, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23454366, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 16:15:33', '2025-05-30 16:29:53', 72, 23454787, 0.06472985030379809, 2988039, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23454787_30-05-2025_16_56_59.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23454841, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23454842, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23454843, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23454844, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23454845, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23454846, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23454847, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23454848, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23454849, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23454850, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23454851, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23454852, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 16:30:03', '2025-05-30 16:44:54', 70, 23455174, 0.05611344137097217, 2988183, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23455174_30-05-2025_17_13_01.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23455176, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23455177, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23455178, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23455179, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23455180, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23455181, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23455182, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23455183, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23455184, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23455185, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23455186, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23455187, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 16:45:03', '2025-05-30 16:59:54', 59, 23455935, 0.0349807326902023, 2988354, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23455935_30-05-2025_17_26_59.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23455960, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23455961, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23455962, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23455963, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23455964, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23455965, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23455966, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23455967, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23455968, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23455969, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23455970, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23455971, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 17:00:04', '2025-05-30 17:09:54', 23, 23456234, 0.07391909282226151, 2988438, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23456234_30-05-2025_19_24_59.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 23456275, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23456276, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23456277, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23456278, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23456279, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23456280, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23456281, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23456282, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23456283, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23456284, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23456285, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23456286, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 17:37:44', '2025-05-30 17:44:34', 34, 23457055, 0.04587829957790436, 2988656, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23457055_30-05-2025_18_12_59.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23457092, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23457093, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23457094, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23457095, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23457096, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23457097, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23457098, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23457099, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23457100, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23457101, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23457102, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23457103, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 17:45:03', '2025-05-30 17:58:54', 69, 23457261, 0.030464520359368422, 2988688, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23457261_30-05-2025_18_27_28.pdf', 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23457292, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23457293, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23457294, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23457295, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23457296, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23457297, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23457298, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23457299, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23457300, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23457301, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23457302, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23457303, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 18:00:14', '2025-05-30 18:14:54', 77, 23457567, 0.04809540582550454, 2988780, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23457567_30-05-2025_18_43_29.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23457568, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23457569, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23457570, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23457571, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23457572, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23457573, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23457574, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23457575, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23457576, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23457577, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23457578, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23457579, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 18:15:04', '2025-05-30 18:29:54', 69, 23458000, 0.02514963598039627, 2988899, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23458000_30-05-2025_18_56_58.pdf', 'metal': {'hashtag': 'metal', 'sub_port_id': 23458005, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23458006, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23458007, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23458008, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23458009, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23458010, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23458011, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23458012, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23458013, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23458014, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23458015, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23458016, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 18:30:04', '2025-05-30 18:44:55', 74, 23458427, 0.062438400226993776, 2989053, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23458427_30-05-2025_19_13_00.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23458433, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23458434, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23458435, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23458436, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23458437, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23458438, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23458439, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23458440, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23458441, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23458442, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23458443, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23458444, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 18:45:05', '2025-05-30 18:59:43', 73, 23459138, 0.0336257634897161, 2989182, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23459138_30-05-2025_19_27_01.pdf', 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23459144, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23459145, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23459146, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23459147, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23459148, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23459149, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23459150, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23459151, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23459152, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23459153, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23459154, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23459155, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 19:00:04', '2025-05-30 19:14:54', 54, 23459437, 0.045073916957695, 2989263, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23459437_30-05-2025_19_42_59.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23459443, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23459444, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23459445, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23459446, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23459447, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23459448, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23459449, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23459450, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23459451, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23459452, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23459453, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23459454, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 19:15:03', '2025-05-30 19:29:53', 71, 23459877, 0.0321767603195604, 2989371, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23459877_30-05-2025_19_56_58.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 23459916, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23459917, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23459918, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23459919, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23459920, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23459921, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23459922, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23459923, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23459924, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23459925, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23459926, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23459927, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 19:30:03', '2025-05-30 19:44:54', 67, 23460253, 0.060090712282567814, 2989505, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23460253_30-05-2025_20_13_00.pdf', 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23460254, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23460255, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23460256, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23460257, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23460258, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23460259, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23460260, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23460261, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23460262, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23460263, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23460264, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23460265, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 19:45:04', '2025-05-30 19:58:53', 58, 23460849, 0.052674891488855485, 2989625, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23460849_30-05-2025_20_26_58.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23460874, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23460875, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23460876, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23460877, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23460878, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23460879, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23460880, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23460881, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23460882, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23460883, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23460884, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23460885, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 20:00:13', '2025-05-30 20:14:54', 51, 23461163, 0.03752981573626564, 2989734, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23461163_30-05-2025_22_24_59.pdf', 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23461170, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23461171, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23461172, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23461173, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23461174, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23461175, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23461176, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23461177, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23461178, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23461179, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23461180, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23461181, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 20:37:33', '2025-05-30 20:44:54', 21, 23462045, 0.06026959756680172, 2989987, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23462045_30-05-2025_21_11_57.pdf', 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23462046, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23462047, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23462048, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23462049, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23462050, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23462051, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23462052, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23462053, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23462054, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23462055, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23462056, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23462057, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 20:45:04', '2025-05-30 20:58:54', 69, 23462274, 0.051492190276170954, 2990009, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23462274_30-05-2025_21_26_58.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23462279, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23462280, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23462281, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23462282, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23462283, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23462284, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23462285, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23462286, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23462287, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23462288, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23462289, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23462290, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 21:00:13', '2025-05-30 21:14:34', 66, 23462679, 0.07014630485850133, 2990099, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23462679_30-05-2025_21_42_59.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 23462686, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23462687, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23462688, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23462689, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23462690, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23462691, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23462692, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23462693, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23462694, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23462695, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23462696, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23462697, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 21:15:24', '2025-05-30 21:29:54', 70, 23463079, 0.06524797385409807, 2990184, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23463079_30-05-2025_21_56_58.pdf', 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23463120, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23463121, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23463122, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23463123, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23463124, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23463125, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23463126, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23463127, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23463128, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23463129, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23463130, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23463131, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 21:30:23', '2025-05-30 21:44:54', 63, 23463616, 0.048923575237025584, 2990354, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23463616_30-05-2025_22_12_58.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23463628, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23463629, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23463630, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23463631, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23463632, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23463633, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23463634, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23463635, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23463636, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23463637, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23463638, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23463639, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 21:45:04', '2025-05-30 21:58:43', 63, 23464494, 0.05433128765689094, 2990505, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23464494_30-05-2025_22_26_59.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23464539, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23464540, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23464541, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23464542, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23464543, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23464544, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23464545, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23464546, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23464547, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23464548, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23464549, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23464550, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 22:00:14', '2025-05-30 22:14:54', 51, 23464924, 0.06899949224886988, 2990617, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23464924_30-05-2025_22_42_58.pdf', 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23464965, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23464966, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23464967, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23464968, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23464969, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23464970, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23464971, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23464972, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23464973, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23464974, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23464975, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23464976, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 22:15:04', '2025-05-30 22:29:55', 58, 23465452, 0.06183314641008609, 2990717, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23465452_30-05-2025_22_56_59.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 23465466, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23465467, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23465468, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23465469, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23465470, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23465471, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23465472, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23465473, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23465474, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23465475, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23465476, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23465477, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 22:30:04', '2025-05-30 22:44:54', 66, 23465879, 0.05921590099161291, 2990840, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23465879_30-05-2025_23_12_57.pdf', 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23465881, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23465882, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23465883, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23465884, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23465885, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23465886, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23465887, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23465888, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23465889, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23465890, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23465891, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23465892, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 22:45:04', '2025-05-30 22:57:35', 33, 23466432, 0.034336530150309456, 2990978, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23466432_30-05-2025_23_25_00.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 23466438, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23466439, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23466440, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23466442, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23466443, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23466444, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23466445, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23466446, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23466447, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23466448, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23466449, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23466450, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 23:00:04', '2025-05-30 23:14:53', 72, 23466763, 0.06633293173065849, 2991080, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23466763_30-05-2025_23_42_59.pdf', 'flou': {'hashtag': 'flou', 'sub_port_id': 23466781, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23466782, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23466783, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23466784, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23466785, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23466786, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23466787, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23466788, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23466789, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23466790, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23466791, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23466792, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 23:15:03', '2025-05-30 23:29:44', 51, 23467164, 0.05916405164610108, 2991183, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23467164_30-05-2025_23_56_57.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23467201, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23467202, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23467203, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23467204, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23467205, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23467206, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23467207, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23467208, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23467209, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23467210, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23467211, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23467212, 'pht': 3726}}" ); INSERT INTO `MTRPhoto`.`dashboard_results` (`dashboard_run_id`, `hashtag`, `date_debut`, `date_fin`, `nombre_balle`, `mtr_portfolio_id`, `qualite`, `datou_result_id_qualite`, `completion_percentage`, `completion_json`) VALUES (1858422, '_______JRM', '2025-05-30 23:30:04', '2025-05-30 23:32:44', 14, 23467560, -1.0, -1, '-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P23467560_30-05-2025_23_58_59.pdf', 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 23467562, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 23467563, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 23467564, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 23467565, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 23467566, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 23467567, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 23467568, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 23467569, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 23467570, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 23467571, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 23467572, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 23467573, 'pht': 3726}}" ); Inside saveOutput : final : True verbose : 0 ouput is None saving photo_ids in datou_result begin to insert list_values into mtr_datou_result : length of list_values in save_final : 100 time used for this insertion : 0.04868507385253906 time spend for datou_step_exec : 0.8115036487579346 time spend to save output : 0.04906725883483887 total time spend for step 1 : 0.8605709075927734 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 1 set_done_treatment 1.69user 0.51system 0:03.53elapsed 62%CPU (0avgtext+0avgdata 99556maxresident)k 0inputs+144outputs (60major+35829minor)pagefaults 0swaps