$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC$œ’m…Îmo“LÒDüÜ;˜%gÏ?wêÁÅ·øîùovH0õÉa‡5£Ú*î Ø’ÃÌlÍ››S iyä”rÕO7ª“ž�%L]Ý×%±ºÇhk¶«·÷>v1­HB£®±ßÞÚd\�(e oIx¢>3´6BS%ÌØá“( œÛf$Ãhýé ¿¶åeÔŽôÚèHœ�‚`ݶ f{�Fo©Yò¿Ôó@00uMb’z-ëìXI$&ÂgfÖú¶7Ó´Þu|'K.ÌoP PÝÀùFË.Ðýoûò9B<~.’ïÅË[’´˜Ë<Ù­„$¯•¢·ä{1¹A�•.òbKxºL �¯�Ý·'¯u8n5 ’ºe,]ñH©–’ÆV¨ŒWwÃ$ùCƒel¹“|zys«™KŠi-ðqÊݬbk,wnGÿâ;¥ ~ ÖeÉrÍ’‰ÜÔ~' 1`V⦫¹-*[ÉñLÔKÄ'2@ŸÜþÐ仪 ²n‘Íß2¸N߈ƶµG•¢ói/U¢µ'Eï@¦`H湘;J•�¼¼ÜŽÅ +Jén#»¼‚6Ú´—ĹG•ü¡NÒGð'—Z!öáí¸‰Wi�»NJ @óàšAûÜZ|ª[¨ï$q}i�Ò·µQbtTEC2668766,492725882'}] thcl {'id': 2725, 'mtr_user_id': 31, 'name': 'learn_qualipapia_rle_210302_2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,environnement,kraft,metal,papier,plastique', 'svm_portfolios_learning': '3460440,3460441,3460446,3460434,3460439,3467416,3460442,3460443,3486028,3460445', 'photo_hashtag_type': 3410, 'photo_desc_type': 5186, 'type_classification': 'caffe', 'hashtag_id_list': '2107753024,2107753020,2107752385,2107752406,702398920,493012381,493202403,492628673,492668766,492725882'} Update svm_hashtag_type_desc : 5186 remove imagettes from duplicated photo Iterating over portfolio : 21655196 get user id for portfolio 21655196 get sub ptf for main ptf 21655196, type 3726 and hashtags ['cartonnette', 'Carton_brun', 'mal_croppe', 'kraft', 'Carton_gris', 'Teint_Dans_La_Masse', 'autre_refus', 'papier', 'plastique', 'environnement', 'flou', 'metal'] SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21655196 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','Carton_brun','mal_croppe','kraft','Carton_gris','Teint_Dans_La_Masse','autre_refus','papier','plastique','environnement','flou','metal')) AND mptpi.`min_score`=0.5 SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21655196 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','Carton_brun','mal_croppe','kraft','Carton_gris','Teint_Dans_La_Masse','autre_refus','papier','plastique','environnement','flou','metal')) AND mptpi.`min_score`=0.5 To do To do query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_cartonnette_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_Carton_brun_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_mal_croppe_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_kraft_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_Carton_gris_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_Teint_Dans_La_Masse_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_autre_refus_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_papier_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_plastique_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_environnement_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_flou_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_3726_metal_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio INSERT IGNORE INTO MTRPhoto.mtr_port_to_port_ids (`mtr_portfolio_id_1`, `mtr_portfolio_id_2`, `type`, `min_score`, `hashtag_id`, `mtr_user_id`) VALUES (%s,%s,%s,%s,%s,%s)[[21655196, 21655259, 3726, 0.5, 702398920, 979], [21655196, 21655260, 3726, 0.5, 2107753024, 979], [21655196, 21655261, 3726, 0.5, 2107755527, 979], [21655196, 21655262, 3726, 0.5, 493202403, 979], [21655196, 21655263, 3726, 0.5, 2107753020, 979], [21655196, 21655264, 3726, 0.5, 2107752385, 979], [21655196, 21655265, 3726, 0.5, 2107752406, 979], [21655196, 21655266, 3726, 0.5, 492668766, 979], [21655196, 21655267, 3726, 0.5, 492725882, 979], [21655196, 21655268, 3726, 0.5, 493012381, 979], [21655196, 21655269, 3726, 0.5, 492777938, 979], [21655196, 21655270, 3726, 0.5, 492628673, 979]] SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21655196 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','Carton_brun','mal_croppe','kraft','Carton_gris','Teint_Dans_La_Masse','autre_refus','papier','plastique','environnement','flou','metal')) AND mptpi.`min_score`=0.5 SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21655196 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','Carton_brun','mal_croppe','kraft','Carton_gris','Teint_Dans_La_Masse','autre_refus','papier','plastique','environnement','flou','metal')) AND mptpi.`min_score`=0.5 To do returned map {'cartonnette': {'main_port_id': 21655196, 'sub_port_id': 21655259, 'hashtag': 'cartonnette', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190912, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'Carton_brun': {'main_port_id': 21655196, 'sub_port_id': 21655260, 'hashtag': 'Carton_brun', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190913, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'mal_croppe': {'main_port_id': 21655196, 'sub_port_id': 21655261, 'hashtag': 'mal_croppe', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190914, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'kraft': {'main_port_id': 21655196, 'sub_port_id': 21655262, 'hashtag': 'kraft', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190915, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'Carton_gris': {'main_port_id': 21655196, 'sub_port_id': 21655263, 'hashtag': 'Carton_gris', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190916, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'Teint_Dans_La_Masse': {'main_port_id': 21655196, 'sub_port_id': 21655264, 'hashtag': 'Teint_Dans_La_Masse', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190917, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'autre_refus': {'main_port_id': 21655196, 'sub_port_id': 21655265, 'hashtag': 'autre_refus', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190918, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'papier': {'main_port_id': 21655196, 'sub_port_id': 21655266, 'hashtag': 'papier', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190919, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'plastique': {'main_port_id': 21655196, 'sub_port_id': 21655267, 'hashtag': 'plastique', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190920, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'environnement': {'main_port_id': 21655196, 'sub_port_id': 21655268, 'hashtag': 'environnement', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190921, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'flou': {'main_port_id': 21655196, 'sub_port_id': 21655269, 'hashtag': 'flou', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190922, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}, 'metal': {'main_port_id': 21655196, 'sub_port_id': 21655270, 'hashtag': 'metal', 'pht': 3726, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190923, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 27), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 27)}} insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655259 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='cartonnette' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655259) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655260 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='Carton_brun' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655260) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655261 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='mal_croppe' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655261) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655262 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='kraft' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655262) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655263 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='Carton_gris' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655263) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655264 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='Teint_Dans_La_Masse' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655264) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655265 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='autre_refus' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655265) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655266 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='papier' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655266) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655267 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='plastique' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655267) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655268 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='environnement' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655268) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655269 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='flou' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655269) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") insert ignore into MTRUser.mtr_portfolio_photos (mtr_portfolio_id, mtr_photo_id, mtr_user_id,created_at) SELECT 21655270 , sub_photo_id, 979,now() FROM (SELECT csp.sub_photo_id, csp.crop_hashtag_id, csp.created_at FROM MTRPhoto.crop_sub_photo_ids csp, MTRPhoto.crop_hashtag_ids chi, MTRBack.hashtags h, MTRUser.mtr_portfolio_photos mpp WHERE mpp.mtr_portfolio_id=21655196 AND mpp.mtr_photo_id=chi.photo_id AND chi.id=csp.crop_hashtag_id AND chi.score>0.5 AND chi.type=3726 AND chi.hashtag_id=h.hashtag_id AND h.hashtag='metal' GROUP BY csp.crop_hashtag_id, csp.created_at order by csp.created_at desc) as a group by crop_hashtag_id; SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655270) result : () SELECT mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id IN (21655196) result : ((1346842545,), (1346842584,), (1346842624,), (1346842688,), (1346842988,), (1346843041,), (1346843071,), (1346843079,), (1346843106,)) select distinct(cspi.sub_photo_id) from MTRPhoto.crop_hashtag_ids chi, MTRPhoto.crop_sub_photo_ids cspi where chi.type=3726 and chi.photo_id in () and cspi.crop_hashtag_id = chi.id; Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") To do ! Use context local managing function ! SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21655196 AND mptpi.`type`=4417 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','Carton_brun','mal_croppe','kraft','Carton_gris','Teint_Dans_La_Masse','autre_refus','papier','plastique','environnement','flou','metal')) AND mptpi.`min_score`=0.5 SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21655196 AND mptpi.`type`=4417 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','Carton_brun','mal_croppe','kraft','Carton_gris','Teint_Dans_La_Masse','autre_refus','papier','plastique','environnement','flou','metal')) AND mptpi.`min_score`=0.5 To do To do query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_cartonnette_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_Carton_brun_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_mal_croppe_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_kraft_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_Carton_gris_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_Teint_Dans_La_Masse_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_autre_refus_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_papier_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_plastique_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_environnement_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_flou_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio query : SELECT id FROM MTRUser.mtr_portfolios WHERE name="JRM_diff_batch__24032025_17_00_04_10141_4417_metal_0.5_chtin_0" AND mtr_user_id=979 Creating new portfolio INSERT IGNORE INTO MTRPhoto.mtr_port_to_port_ids (`mtr_portfolio_id_1`, `mtr_portfolio_id_2`, `type`, `min_score`, `hashtag_id`, `mtr_user_id`) VALUES (%s,%s,%s,%s,%s,%s)[[21655196, 21655271, 4417, 0.5, 702398920, 979], [21655196, 21655272, 4417, 0.5, 2107753024, 979], [21655196, 21655273, 4417, 0.5, 2107755527, 979], [21655196, 21655274, 4417, 0.5, 493202403, 979], [21655196, 21655275, 4417, 0.5, 2107753020, 979], [21655196, 21655276, 4417, 0.5, 2107752385, 979], [21655196, 21655277, 4417, 0.5, 2107752406, 979], [21655196, 21655278, 4417, 0.5, 492668766, 979], [21655196, 21655279, 4417, 0.5, 492725882, 979], [21655196, 21655280, 4417, 0.5, 493012381, 979], [21655196, 21655281, 4417, 0.5, 492777938, 979], [21655196, 21655282, 4417, 0.5, 492628673, 979]] SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21655196 AND mptpi.`type`=4417 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','Carton_brun','mal_croppe','kraft','Carton_gris','Teint_Dans_La_Masse','autre_refus','papier','plastique','environnement','flou','metal')) AND mptpi.`min_score`=0.5 SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21655196 AND mptpi.`type`=4417 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','Carton_brun','mal_croppe','kraft','Carton_gris','Teint_Dans_La_Masse','autre_refus','papier','plastique','environnement','flou','metal')) AND mptpi.`min_score`=0.5 To do returned map {'cartonnette': {'main_port_id': 21655196, 'sub_port_id': 21655271, 'hashtag': 'cartonnette', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190924, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'Carton_brun': {'main_port_id': 21655196, 'sub_port_id': 21655272, 'hashtag': 'Carton_brun', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190925, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'mal_croppe': {'main_port_id': 21655196, 'sub_port_id': 21655273, 'hashtag': 'mal_croppe', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190926, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'kraft': {'main_port_id': 21655196, 'sub_port_id': 21655274, 'hashtag': 'kraft', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190927, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'Carton_gris': {'main_port_id': 21655196, 'sub_port_id': 21655275, 'hashtag': 'Carton_gris', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190928, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'Teint_Dans_La_Masse': {'main_port_id': 21655196, 'sub_port_id': 21655276, 'hashtag': 'Teint_Dans_La_Masse', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190929, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'autre_refus': {'main_port_id': 21655196, 'sub_port_id': 21655277, 'hashtag': 'autre_refus', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190930, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'papier': {'main_port_id': 21655196, 'sub_port_id': 21655278, 'hashtag': 'papier', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190931, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'plastique': {'main_port_id': 21655196, 'sub_port_id': 21655279, 'hashtag': 'plastique', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190932, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'environnement': {'main_port_id': 21655196, 'sub_port_id': 21655280, 'hashtag': 'environnement', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190933, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'flou': {'main_port_id': 21655196, 'sub_port_id': 21655281, 'hashtag': 'flou', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190934, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}, 'metal': {'main_port_id': 21655196, 'sub_port_id': 21655282, 'hashtag': 'metal', 'pht': 4417, 'min_score': 0.5, 'mtr_user_id': 979, 'id': 14190935, 'last_updated_at': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_desc': datetime.datetime(2025, 3, 24, 17, 5, 29), 'last_updated_at_asc': datetime.datetime(2025, 3, 24, 17, 5, 29)}} insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655271,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655259 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655272,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655260 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655273,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655261 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655274,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655262 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655275,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655263 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655276,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655264 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655277,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655265 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655278,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655266 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655279,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655267 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655280,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655268 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655281,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655269 insert ignore into MTRUser.mtr_portfolio_photos(mtr_portfolio_id,mtr_photo_id,mtr_user_id) select 21655282,mtr_photo_id,mtr_user_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id = 21655270 lien utilise dans velours : https://www.fotonower.com/velours/21655271,21655272,21655273,21655274,21655275,21655276,21655277,21655278,21655279,21655280,21655281,21655282?tags=cartonnette,Carton_brun,mal_croppe,kraft,Carton_gris,Teint_Dans_La_Masse,autre_refus,papier,plastique,environnement,flou,metal After datou_step_exec type output : map_portfolio_photo : len 1 keys : dict_keys([21655196]) Inside saveOutput : final : False verbose : True saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545] map_info['map_portfolio_photo'] : {21655196: [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545]} final : False mtd_id 4302 list_pids : [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545] Looping around the photos to save general results len do output : 1 /21655196. before output type Here is an output not treated by saveGeneral : Managing all output in save final without adding information in the mtr_datou_result ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843106', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843079', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843071', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843041', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842988', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842688', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842624', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842584', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842545', None, None, None, None, None, '2686266') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 10 insert ignore into MTRPhoto.mtr_datou_result (mtd_id, mtr_portfolio_id,mtr_photo_id,result,result_long,result_double,hashtag_id,proba, mtr_current_id) values (%s,%s,%s,%s,%s,%s,%s,%s,%s) on duplicate key update mtr_portfolio_id = mtr_portfolio_id list_values : [('4302', None, '21655196', "{'cartonnette': 21655259, 'Carton_brun': 21655260, 'mal_croppe': 21655261, 'kraft': 21655262, 'Carton_gris': 21655263, 'Teint_Dans_La_Masse': 21655264, 'autre_refus': 21655265, 'papier': 21655266, 'plastique': 21655267, 'environnement': 21655268, 'flou': 21655269, 'metal': 21655270}", None, None, None, None, '2686266'), ('4302', '21655196', '1346843106', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346843079', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346843071', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346843041', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842988', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842688', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842624', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842584', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842545', None, None, None, None, None, '2686266')] time used for this insertion : 0.8484747409820557 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.1345314979553223 time spend to save output : 0.8487915992736816 total time spend for step 1 : 2.983323097229004 step2:final Mon Mar 24 17:05:30 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure input_args_next_step, len :0, first value : [] After prepare type args : select max(UNIX_TIMESTAMP(created_at)) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (21655196) Here we display some param of map_info ! map_filenames : {} map_photo_id_path_extension : {} map_subphoto_mainphoto : {} Beginning of datou step final ! query to retrieve results for portfolio 21655196 : SELECT photo_id, hashtag_id, ratio from MTRPhoto.photo_carac_ratio where hashtag_type = 3726 and photo_id in (1346842688,1346842624,1346842584,1346842545,1346843106,1346843079,1346843071,1346843041,1346842988); After datou_step_exec type output : map_portfolio_photo : len 1 keys : dict_keys([21655196]) Inside saveOutput : final : False verbose : True original output for save of step final : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} new output for save of step final : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545] map_info['map_portfolio_photo'] : {21655196: [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545]} final : False mtd_id 4302 list_pids : [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545] Looping around the photos to save general results len do output : 9 /1346843106.Didn't retrieve data . /1346843079.Didn't retrieve data . /1346843071.Didn't retrieve data . /1346843041.Didn't retrieve data . /1346842988.Didn't retrieve data . /1346842688.Didn't retrieve data . /1346842624.Didn't retrieve data . /1346842584.Didn't retrieve data . /1346842545.Didn't retrieve data . before output type Used above Used above Managing all output in save final without adding information in the mtr_datou_result ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843106', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843079', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843071', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843041', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842988', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842688', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842624', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842584', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842545', None, None, None, None, None, '2686266') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 27 insert ignore into MTRPhoto.mtr_datou_result (mtd_id, mtr_portfolio_id,mtr_photo_id,result,result_long,result_double,hashtag_id,proba, mtr_current_id) values (%s,%s,%s,%s,%s,%s,%s,%s,%s) on duplicate key update mtr_portfolio_id = mtr_portfolio_id list_values : [('4302', '21655196', '1346843106', '0.0', None, None, None, None, '2686266'), ('4302', '21655196', '1346843079', '0.0', None, None, None, None, '2686266'), ('4302', '21655196', '1346843071', '0.0', None, None, None, None, '2686266'), ('4302', '21655196', '1346843041', '0.0', None, None, None, None, '2686266'), ('4302', '21655196', '1346842988', '0.0', None, None, None, None, '2686266'), ('4302', '21655196', '1346842688', '0.0', None, None, None, None, '2686266'), ('4302', '21655196', '1346842624', '0.0', None, None, None, None, '2686266'), ('4302', '21655196', '1346842584', '0.0', None, None, None, None, '2686266'), ('4302', '21655196', '1346842545', '0.0', None, None, None, None, '2686266')] time used for this insertion : 0.014434099197387695 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.015590667724609375 time spend to save output : 0.015034198760986328 total time spend for step 2 : 0.030624866485595703 step3:velours_tree Mon Mar 24 17:05:30 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 : {21655196: [{'cartonnette': 21655259, 'Carton_brun': 21655260, 'mal_croppe': 21655261, 'kraft': 21655262, 'Carton_gris': 21655263, 'Teint_Dans_La_Masse': 21655264, 'autre_refus': 21655265, 'papier': 21655266, 'plastique': 21655267, 'environnement': 21655268, 'flou': 21655269, 'metal': 21655270}]} input_args_next_step : {21655196: ()} output_args : {21655196: [{'cartonnette': 21655259, 'Carton_brun': 21655260, 'mal_croppe': 21655261, 'kraft': 21655262, 'Carton_gris': 21655263, 'Teint_Dans_La_Masse': 21655264, 'autre_refus': 21655265, 'papier': 21655266, 'plastique': 21655267, 'environnement': 21655268, 'flou': 21655269, 'metal': 21655270}]} args : 21655196 depend.output_id : 0 VR 22-3-18 : For now we do not clean correctly the datou structure input_args_next_step, len :1, first value : ({'cartonnette': 21655259, 'Carton_brun': 21655260, 'mal_croppe': 21655261, 'kraft': 21655262, 'Carton_gris': 21655263, 'Teint_Dans_La_Masse': 21655264, 'autre_refus': 21655265, 'papier': 21655266, 'plastique': 21655267, 'environnement': 21655268, 'flou': 21655269, 'metal': 21655270},) After prepare type args : select max(UNIX_TIMESTAMP(created_at)) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (21655196) Here we display some param of map_info ! map_filenames : {} map_photo_id_path_extension : {} map_subphoto_mainphoto : {} can't find the photo_desc_type After datou_step_exec type output : map_portfolio_photo : len 1 keys : dict_keys([21655196]) Inside saveOutput : final : False verbose : True ouput is None No outpout to save, returning out of save general time spend for datou_step_exec : 0.33797669410705566 time spend to save output : 7.534027099609375e-05 total time spend for step 3 : 0.33805203437805176 step4:send_mail_cod Mon Mar 24 17:05:30 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 2 : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} input_args_next_step : {1346843106: ()} output_args : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} args : 1346843106 depend.output_id : 0 input_args_next_step : {1346843106: ('0.0',), 1346843079: ()} output_args : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} args : 1346843079 depend.output_id : 0 input_args_next_step : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ()} output_args : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} args : 1346843071 depend.output_id : 0 input_args_next_step : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ()} output_args : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} args : 1346843041 depend.output_id : 0 input_args_next_step : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ()} output_args : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} args : 1346842988 depend.output_id : 0 input_args_next_step : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ()} output_args : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} args : 1346842688 depend.output_id : 0 input_args_next_step : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ()} output_args : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} args : 1346842624 depend.output_id : 0 input_args_next_step : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ()} output_args : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} args : 1346842584 depend.output_id : 0 input_args_next_step : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ()} output_args : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',)} args : 1346842545 depend.output_id : 0 Inconsistent number of input and output, step which parrallelize and manage error in input by avoiding sending an output for this data can't be used in tree dependencies of input and output complete output_args for input 3 : {21655196: [{'cartonnette': 21655259, 'Carton_brun': 21655260, 'mal_croppe': 21655261, 'kraft': 21655262, 'Carton_gris': 21655263, 'Teint_Dans_La_Masse': 21655264, 'autre_refus': 21655265, 'papier': 21655266, 'plastique': 21655267, 'environnement': 21655268, 'flou': 21655269, 'metal': 21655270}]} input_args_next_step : {1346843106: ('0.0',), 1346843079: ('0.0',), 1346843071: ('0.0',), 1346843041: ('0.0',), 1346842988: ('0.0',), 1346842688: ('0.0',), 1346842624: ('0.0',), 1346842584: ('0.0',), 1346842545: ('0.0',), 21655196: ()} output_args : {21655196: [{'cartonnette': 21655259, 'Carton_brun': 21655260, 'mal_croppe': 21655261, 'kraft': 21655262, 'Carton_gris': 21655263, 'Teint_Dans_La_Masse': 21655264, 'autre_refus': 21655265, 'papier': 21655266, 'plastique': 21655267, 'environnement': 21655268, 'flou': 21655269, 'metal': 21655270}]} args : 21655196 depend.output_id : 0 We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure input_args_next_step, len :10, first value : ('0.0',) After prepare type args : select max(UNIX_TIMESTAMP(created_at)) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (21655196) Here we display some param of map_info ! map_filenames : {} map_photo_id_path_extension : {} map_subphoto_mainphoto : {} dans la step send mail cod work_area: /home/admin/workarea/git/Velours/python in order to get the selector url, please entre the license of selector SELECT photo_id, url FROM MTRBack.photos ph WHERE photo_id IN (1346843106,1346843079,1346843071,1346843041,1346842988,1346842688,1346842624,1346842584,1346842545) Found this number of photos: 9 ##### Call download_photos : nb_thread : 5 begin to download photo : 1346842545 begin to download photo : 1346842624 begin to download photo : 1346842988 begin to download photo : 1346843071 begin to download photo : 1346843106 download finish for photo 1346842545 begin to download photo : 1346842584 download finish for photo 1346842988 begin to download photo : 1346843041 download finish for photo 1346843071 begin to download photo : 1346843079 download finish for photo 1346842624 begin to download photo : 1346842688 download finish for photo 1346843106 download finish for photo 1346842688 download finish for photo 1346843041 download finish for photo 1346843079 download finish for photo 1346842584 we have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB ##### After download_photos imagette216552591742832330/ imagette216552611742832330/ imagette216552621742832330/ imagette216552651742832330/ imagette216552671742832330/ imagette216552691742832330/ imagette216552701742832330/ imagette216552601742832330/ imagette216552631742832330/ imagette216552641742832330/ length of list_filenames : 9 ; length of list_pids : 9 ; length of list_args : 9 results_Auto_P21655196_24-03-2025_17_05_30.pdf 21655259 SELECT ph.photo_id,ph.url,ph.username,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655259 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 20 map_photo_id_text : {} imagette216552591742832330 21655261 SELECT ph.photo_id,ph.url,ph.username,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655261 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 20 map_photo_id_text : {} imagette216552611742832330 21655262 SELECT ph.photo_id,ph.url,ph.username,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655262 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 20 map_photo_id_text : {} imagette216552621742832330 21655265 SELECT ph.photo_id,ph.url,ph.username,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655265 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 20 map_photo_id_text : {} imagette216552651742832330 21655267 SELECT ph.photo_id,ph.url,ph.username,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655267 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 20 map_photo_id_text : {} imagette216552671742832330 21655269 SELECT ph.photo_id,ph.url,ph.username,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655269 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 20 map_photo_id_text : {} imagette216552691742832330 21655270 SELECT ph.photo_id,ph.url,ph.username,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655270 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 20 map_photo_id_text : {} imagette216552701742832330 21655260 SELECT ph.photo_id,ph.url,ph.username,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655260 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 20 map_photo_id_text : {} imagette216552601742832330 21655263 SELECT ph.photo_id,ph.url,ph.username,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655263 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 20 map_photo_id_text : {} imagette216552631742832330 21655264 SELECT ph.photo_id,ph.url,ph.username,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655264 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 20 map_photo_id_text : {} imagette216552641742832330 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=21655196 and hashtag_type = 3726 and pcr.hashtag_id = h.hashtag_id; velour_link : https://www.fotonower.com/velours/21655271,21655272,21655273,21655274,21655275,21655276,21655277,21655278,21655279,21655280,21655281,21655282?tags=cartonnette,Carton_brun,mal_croppe,kraft,Carton_gris,Teint_Dans_La_Masse,autre_refus,papier,plastique,environnement,flou,metal your option no_mail is active, we will not send the real mail to your client args[1346843106] : ('0.0',) no score found for photo 1346843106 We are sending mail with results at report@fotonower.com args[1346843079] : ('0.0',) no score found for photo 1346843079 We are sending mail with results at report@fotonower.com args[1346843071] : ('0.0',) no score found for photo 1346843071 We are sending mail with results at report@fotonower.com args[1346843041] : ('0.0',) no score found for photo 1346843041 We are sending mail with results at report@fotonower.com args[1346842988] : ('0.0',) no score found for photo 1346842988 We are sending mail with results at report@fotonower.com args[1346842688] : ('0.0',) no score found for photo 1346842688 We are sending mail with results at report@fotonower.com args[1346842624] : ('0.0',) no score found for photo 1346842624 We are sending mail with results at report@fotonower.com args[1346842584] : ('0.0',) no score found for photo 1346842584 We are sending mail with results at report@fotonower.com args[1346842545] : ('0.0',) no score found for photo 1346842545 We are sending mail with results at report@fotonower.com refus_total : 0.0 2022-04-13 10:29:59 0 SELECT ph.photo_id,ph.url,ph.username,ph.uploaded_at,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21655196 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 1000 start upload file to ovh https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21655196_24-03-2025_17_05_30.pdf results_Auto_P21655196_24-03-2025_17_05_30.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21655196_24-03-2025_17_05_30.pdf start insert file to database insert into MTRUser.mtr_files (mtd_id,mtr_portfolio_id,text,url,format,tags,file_size,value) values ('4302','21655196','results_Auto_P21655196_24-03-2025_17_05_30.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21655196_24-03-2025_17_05_30.pdf','pdf','','0.09','0.0') After datou_step_exec type output : map_portfolio_photo : len 1 keys : dict_keys([21655196]) Inside saveOutput : final : False verbose : True saveOutput not yet implemented for datou_step.type : send_mail_cod we use saveGeneral [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545] map_info['map_portfolio_photo'] : {21655196: [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545]} final : False mtd_id 4302 list_pids : [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545] Looping around the photos to save general results len do output : 0 before output type Used above Managing all output in save final without adding information in the mtr_datou_result ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843106', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843079', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843071', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843041', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842988', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842688', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842624', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842584', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842545', None, None, None, None, None, '2686266') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 9 insert ignore into MTRPhoto.mtr_datou_result (mtd_id, mtr_portfolio_id,mtr_photo_id,result,result_long,result_double,hashtag_id,proba, mtr_current_id) values (%s,%s,%s,%s,%s,%s,%s,%s,%s) on duplicate key update mtr_portfolio_id = mtr_portfolio_id list_values : [('4302', '21655196', '1346843106', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346843079', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346843071', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346843041', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842988', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842688', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842624', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842584', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842545', None, None, None, None, None, '2686266')] time used for this insertion : 0.012264728546142578 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.9492993354797363 time spend to save output : 0.01248478889465332 total time spend for step 4 : 2.9617841243743896 step5:split_time_score Mon Mar 24 17:05:33 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 : ['21655196'] We expect there is only one output and this part is used while all output are not tuple or array Inconsistent number of input and output, step which parrallelize and manage error in input by avoiding sending an output for this data can't be used in tree dependencies of input and output complete output_args for input 1 : VR 22-3-18 : For now we do not clean correctly the datou structure input_args_next_step, len :1, first value : [('21655196',)] After prepare type args : select max(UNIX_TIMESTAMP(created_at)) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (21655196) Here we display some param of map_info ! map_filenames : {} map_photo_id_path_extension : {1346843106: {'path': 'temp/1742832330_1005469_1346843106_6c152dd96c4458c5f56dac0234e481e5.jpg', 'extension': 'jpg'}, 1346842624: {'path': 'temp/1742832330_1005469_1346842624_f0a650ae170d51b1fec635cef143cddb.jpg', 'extension': 'jpg'}, 1346842688: {'path': 'temp/1742832330_1005469_1346842688_133e6742d33ee122b9c733229861bfb2.jpg', 'extension': 'jpg'}, 1346842988: {'path': 'temp/1742832330_1005469_1346842988_9e8a8ecdd594fadba26ef412c2bda0bc.jpg', 'extension': 'jpg'}, 1346843041: {'path': 'temp/1742832330_1005469_1346843041_eb5b084c989d026817300462951f09ff.jpg', 'extension': 'jpg'}, 1346843071: {'path': 'temp/1742832330_1005469_1346843071_dba102239fa1826fd105688ca563606e.jpg', 'extension': 'jpg'}, 1346843079: {'path': 'temp/1742832330_1005469_1346843079_916004dd71d360b80552ab29bf7e4116.jpg', 'extension': 'jpg'}, 1346842545: {'path': 'temp/1742832330_1005469_1346842545_550bfd8d0f9d9d3e72715be825a413a4.jpg', 'extension': 'jpg'}, 1346842584: {'path': 'temp/1742832330_1005469_1346842584_ce3eb1a80607d71f0df00062c467516c.jpg', 'extension': 'jpg'}} map_subphoto_mainphoto : {} begin split time score SELECT app_name, token FROM MTRUser.mtr_app_api_token WHERE mtr_user_id=979 AND app_name="token_split_time_score" AND expire_at > NOW() select distinct dp.name from MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp, MTRPhoto.dashboard_results dr where ded.dashboard_place_id = dp.id and ded.last_run_id = dr.dashboard_run_id and dp.id = ded.dashboard_place_id and dr.mtr_portfolio_id = 21655196; Dont find camara_place_name for portfolio_id : 21655196 After datou_step_exec type output : map_portfolio_photo : len 1 keys : dict_keys([21655196]) Inside saveOutput : final : True verbose : True saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545] map_info['map_portfolio_photo'] : {21655196: [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545]} final : True mtd_id 4302 list_pids : [1346843106, 1346843079, 1346843071, 1346843041, 1346842988, 1346842688, 1346842624, 1346842584, 1346842545] Looping around the photos to save general results len do output : 0 before output type Here is an output not treated by saveGeneral : Managing all output in save final without adding information in the mtr_datou_result ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843106', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843079', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843071', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346843041', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842988', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842688', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842624', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842584', None, None, None, None, None, '2686266') ('4302', None, None, None, None, None, None, None, '2686266') ('4302', '21655196', '1346842545', None, None, None, None, None, '2686266') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 9 insert ignore into MTRPhoto.mtr_datou_result (mtd_id, mtr_portfolio_id,mtr_photo_id,result,result_long,result_double,hashtag_id,proba, mtr_current_id) values (%s,%s,%s,%s,%s,%s,%s,%s,%s) on duplicate key update mtr_portfolio_id = mtr_portfolio_id list_values : [('4302', '21655196', '1346843106', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346843079', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346843071', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346843041', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842988', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842688', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842624', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842584', None, None, None, None, None, '2686266'), ('4302', '21655196', '1346842545', None, None, None, None, None, '2686266')] time used for this insertion : 0.012542963027954102 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.02203512191772461 time spend to save output : 0.012715578079223633 total time spend for step 5 : 0.03475069999694824 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 DELETE from MTRPhoto.mtr_datou_current where id in (2686266) 2.16user 1.79system 0:09.34elapsed 42%CPU (0avgtext+0avgdata 159380maxresident)k 344inputs+5248outputs (7major+73790minor)pagefaults 0swaps