Symfony Profiler

SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, (SELECT GROUP_CONCAT(HEX(`country.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
                  FROM `sales_channel_country` `country.salesChannels.mapping`
                  WHERE `country.salesChannels.mapping`.`country_id` = `country`.`id` ) as `country.salesChannels.id_mapping`, `country.translation.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01ÉÑð£suÇ\x1DPx\rF\x1C┤"
  b"\x01ÉÑðÂõqÎíÈ\x18¡é\x1E\x17ô"
  b"\x01ÉÑðÂÞsÌ¿ı\x06\x06┬┌,Ã"
  b"\x01ÉÑð╣CpЫ├ºÑ\x10\x1F©╗"
  b"\x01ÉÑð╣FpºÀbS▒vÝe╠"
  b"\x01ÉÑð╣IqÁîUɹ»─rì"
  b"\x01ÉÑð╣MqíƒÏî£\x13║ƒÝ"
  b"\x01ÉÑð╣Qq\x1Cí▒¤ƒpe§Ö"
  b"\x01ÉÑð╣Ur\x00ù▀Ä┤\A=·"
  b"\x01ÉÑð╣Yqvôá\f/3ò]]"
  b"\x01ÉÑð╣\r\x05ök\{£4ã\x1F"
  b"\x01ÉÑð╣_s▓¢y± \x15┼L¤"
  b"\x01ÉÑð╣csI£\x0E\x0F}`q¹A"
  b"\x01ÉÑð╣gp═░\x1AQ7ø█rñ"
  b"\x01ÉÑð╣jp┌¬ù║\x14.#╚i"
  b"\x01ÉÑð╣ms\x03┐5=Ë\x03Õ╣'"
  b"\x01ÉÑð╣pr0ƒ/å┴║ Ôã"
  b"\x01ÉÑð╣spoØhJ▒\x05û\x18û"
  b"\x01ÉÑð║\x1Cq‗¡b\x1C,h┬ù{"
  b"\x01ÉÑð║#p┴ér║\x07ØIð\n"
  b"""
    \x01ÉÑð║*r\x06åg3¦ìæ\n
    þ
    """
  b"\x01ÉÑð║.sv«¬\x13lÓ█╔6"
  b"\x01ÉÑð║2s&│\x15öë~û~°"
  b"\x01ÉÑð║7s­¼,:M│¥6Í"
  b"\x01ÉÑð║;s;░¿c\x1Aþ░áÇ"
  b"\x01ÉÑð║?rJ×D:×r▒▀¯"
  b"\x01ÉÑð║Bp‗ÀB\eË\x03ÍÿB"
  b"\x01ÉÑð║Fqpÿ4\x1Ab\x15¨Xá"
  b"\x01ÉÑð║Kp\x16«▀┤Í\x05¸)‗"
  b"\x01ÉÑð║Np:▒^ïM»z,▄"
  b"\x01ÉÑð║SpIÄ \x00OODê\x1D"
  b"\x01ÉÑð║Yp├éªKã\x00╩mJ"
  b"\x01ÉÑð║_pIÂß┴BÀ½├¨"
  b"\x01ÉÑÐ\x07xpv░Æ¢║Ùv╠§"
  b"\x01ÉÑÐ\x07ïs═í×\vsv\x12\x13Ô"
  b"\x01ÉÑÐ\x07áp/║Jð╬┬öqó"
  b"\x01ÉÑÐ\x07┤s═óú;\x03+Ö|Ü"
  b"\x01ÉÑÐ\x07╔p╚╣ßÚ}âPóE"
  b"\x01ÉÑÐ\x07Ór¤ïJ¥-Y╩¾«"
  b"\x01ÉÑÐ\x07¾p+«K┼\r£õÖÿ"
  b"\x01ÉÑÐ\x08\x06p.¿ö\x15Å:á&÷"
  b"\x01ÉÑÐ\x08\x1Aq\t╗g\x07\x0EPÆP\x1D"
  b"\x01ÉÑÐ\x08.r¥ûL¤"VÂA\f"
  b"\x01ÉÑÐ\x08Ap\x7F▓±9E,\x19W\v"
  b"\x01ÉÑÐ\x08Ws¶Ø¿M§Ö\Ù‗"
  b"\x01ÉÑÐ\x08ks¦ÿ┐µTgr ¬"
  b"\x01ÉÑÐ\x08\x7Fr■ïÿ0è§\x1E.ð"
  b"\x01ÉÑÐ\x08òsÕ½"ÔÏÃ7&V"
  b"\x01ÉÑÐ\x08½qÞå¸▒\x00Ȥ╗+"
  b"\x01ÉÑÐ\x08└pwï⿃ƒT_b"
  b"\x01ÉÑÐ\x08Ès╦¬5╗Y░┤Ð\x11"
  b"\x01ÉÑÐ\x08ýp▄╝Í\x7FA┬╩¯³"
  b"\x01ÉÑÐ\t\x02qtä[█LYóJÂ"
  b"\x01ÉÑÐ\t\x18rÞÅ╦ª½£¾»Q"
  b"\x01ÉÑÐ\tOs\x0FÅÖN\x7F¬æ\tJ"
  b"\x01ÉÑÐ\t|r³ôMQÞ®\x00ØÝ"
  b"\x01ÉÑÐ\tñrV£\x12╠É«,ª\x10"
  b"\x01ÉÑÐ\t┘pJÄ\x07u·ËÒ¼¡"
  b"\x01ÉÑÐ\t­pÇÑ▓ÎEö┼q·"
  b"""
    \x01ÉÑÐ\n
    \x03pÊ░(îÍ\x08|±┬
    """
  b"""
    \x01ÉÑÐ\n
    \x17s]ô¤ïÄÒv¹«
    """
  b"""
    \x01ÉÑÐ\n
    -s>ѶÚ-Ü\x1E÷Ç
    """
  b"""
    \x01ÉÑÐ\n
    Bs┐Ö\x07Z├h╗r»
    """
  b"""
    \x01ÉÑÐ\n
    XsLÜÛ»£7ZHÂ
    """
  b"""
    \x01ÉÑÐ\n
    ls├Ö'á└ä└ö<
    """
  b"""
    \x01ÉÑÐ\n
    üp▀æ`Ô\x12\x1C.Ö3
    """
  b"""
    \x01ÉÑÐ\n
    ÖrúÑ@:Æ.í\x07\x13
    """
  b"""
    \x01ÉÑÐ\n
    ¼sOæ¶\eG*¨ÞT
    """
  b"""
    \x01ÉÑÐ\n
    └rIîæpµhqça
    """
  b"""
    \x01ÉÑÐ\n
    Ëqøù·±é╦I─ý
    """
  b"\x01ÉÑÐ\nÛq[ç7\x00Þ▄DÝ\x1C"
  b"""
    \x01ÉÑÐ\n
     sQÖæ\x1A\x18æ█Vä
    """
  b"\x01ÉÑÐ\v\x13s¯▓Äð│º!┐³"
  b"\x01ÉÑÐ\v&qþí├\x1CÕ?Ù\x05@"
  b"\x01ÉÑÐ\v9rõïÑÐ\r|'cH"
  b"\x01ÉÑÐ\vLs»®Y\x0F\x0FÖS▀ "
  b"\x01ÉÑÐ\vgr<àGj\x06:¬ÉÐ"
  b"\x01ÉÑÐ\v{q§ê┼;LÄ峩"
  b"\x01ÉÑÐ\vÅq[▒Î\tÚpõôÃ"
  b"\x01ÉÑÐ\vÑs╔╗╦ò\x11¬Y\x7Fý"
  b"\x01ÉÑÐ\v║q\x03ù\x15}qùbæı"
  b"\x01ÉÑÐ\v╬p·ä\tÁx╗ Ö³"
  b"\x01ÉÑÐ\vÒqFù\x1D┘ït\x02‗["
  b"\x01ÉÑÐ\v·s\x1DåR▓▒øÏeÕ"
  b"\x01ÉÑÐ\f\rqéÉìDâSØ¡ý"
  b"\x01ÉÑÐ\f$p5ó±ÌÝ`ößF"
  b"\x01ÉÑÐ\f7pÇ»\x1D½Þp┘Å║"
  b"""
    \x01ÉÑÐ\fMsvü\n
    \r$í¤cE
    """
  b"\x01ÉÑÐ\fapné¿òç«\x19Éh"
  b"\x01ÉÑÐ\fwpªñ6*Ç║;▓\x11"
  b"\x01ÉÑÐ\fïqàƒXs‗;Óë!"
  b"\x01ÉÑÐ\fƒq5╗\x08u6¡└Ô┘"
  b"\x01ÉÑÐ\f│rûºY█\x00\x1Cÿ─@"
  b"\x01ÉÑÐ\fÃpWÀ└\x0FÞBãÓm"
  b"\x01ÉÑÐ\f█rå┤\x06$so0¡L"
  b"\x01ÉÑÐ\f­r\rÜNj$l3æ\x1A"
  b"\x01ÉÑÐ\r\rr¾£c2é\f|ø`"
  b"\x01ÉÑÐ\r0p¹á*¸Ró┼½M"
  b"\x01ÉÑÐ\r[q\x0Fëgmÿ@»¡*"
  b"\x01ÉÑÐ\r\x7Fq&ÿØP\x1Axéqj"
  b"\x01ÉÑÐ\ræp├Á┘║ÿü:\x0F'"
  b"\x01ÉÑÐ\rªpvë╣5ßX·\x1A\n"
  b"\x01ÉÑÐ\r¢r\vùGìVûà└±"
  b"\x01ÉÑÐ\rÐrÌ▓ß▀c(A\x03Ë"
  b"\x01ÉÑÐ\rÒpR▓wýÑÒpWh"
  b"\x01ÉÑÐ\r¸sû┤Õ\x7FÚuãøx"
  b"\x01ÉÑÐ\x0E\vqÞÿNu\x0F\x16Éël"
  b"\x01ÉÑÐ\x0E q;▒╠╩P\tnÕà"
  b"\x01ÉÑÐ\x0E5r]é┘(`ú¡$H"
  b"\x01ÉÑÐ\x0EUr\eæ\x02ôQÿ\x12~╔"
  b"\x01ÉÑÐ\x0EjqEìt└<ê  ¬"
  b"\x01ÉÑÐ\x0E~qjÜù;Û¡Ä@y"
  b"\x01ÉÑÐ\x0EôrÛé\x0Eƒ\x154Ù:T"
  b"\x01ÉÑÐ\x0Eªq·Ü¾hëÒ┼1\"
  b"\x01ÉÑÐ\x0E©sc░!ÀcÓ-qL"
  b"\x01ÉÑÐ\x0E╠q[╗╣IîL:@Ö"
  b"\x01ÉÑÐ\x0E▀q0×\x7F\x1En\x05VµÏ"
  b"\x01ÉÑÐ\x0E¾r┬▓J│ÞM%±7"
  b"\x01ÉÑÐ\x0F\x06qoÉ>_qõ▓ã³"
  b"\x01ÉÑÐ\x0F\x19sSëùé\x007\x7F\x1C9"
  b"\x01ÉÑÐ\x0F,rÛ«;├¯~]Õ\v"
  b"\x01ÉÑÐ\x0FAq\x00áı\x16rÛƒ\x15\v"
  b"\x01ÉÑÐ\x0FUrá▓\fäo­d2f"
  b"\x01ÉÑÐ\x0Fipºå³¯╗kèÙx"
  b"\x01ÉÑÐ\x0Fzs_祳ª\x16­ZÎ"
  b"\x01ÉÑÐ\x0FìrP½¬E╝nÄr\x19"
  b"\x01ÉÑÐ\x0Fóp ÇÜdë°b▓²"
  b"\x01ÉÑÐ\x0F©q?ôÄNC\x03¡ÃÞ"
  b"\x01ÉÑÐ\x0F╦q1ÇÏ&╔+rÁ\x04"
  b"\x01ÉÑÐ\x0FÌrKán┘┼àózZ"
  b"\x01ÉÑÐ\x0F±p\x04ü+³┴<µ;Ä"
  b"\x01ÉÑÐ\x10\x05pHèx ê \╬╦"
  b"\x01ÉÑÐ\x10\x18q?©ÁaüòiR "
  b"\x01ÉÑÐ\x10*p\x03ç°▀\x0E\x05_▒¦"
  b"\x01ÉÑÐ\x10Fqì┐úÛ/Úu\x1F╠"
  b"\x01ÉÑÐ\x10Spôƒ¯\x08jÈ■hE"
  b"\x01ÉÑÐ\x10ks³╗ïÕ~{d ┐"
  b"\x01ÉÑÐ\x10àr\x1A┐asæzÍ\x160"
  b"\x01ÉÑÐ\x10ÂsÝ¡ÄÈ\x02‗¯û─"
  b"\x01ÉÑÐ\x10┐pVÜ▓#Ñ#¡Px"
  b"\x01ÉÑÐ\x10┼sr¥Ø:\tJë\x1D4"
  b"\x01ÉÑÐ\x10╠r¹ƒ\x02▄Òâ╚;\x12"
  b"\x01ÉÑÐ\x10ÓrQìQ ╣ð░ÆE"
  b"\x01ÉÑÐ\x10¸rñÄo\x14╔ÝÂý¥"
  b"\x01ÉÑÐ\x11"qpñ»HîRu»â"
  b"\x01ÉÑÐ\x11QsÓÇö'$rÆ5\x11"
  b"\x01ÉÑÐ\x11}p$ö¿ûÌï\x1D\x05j"
  b"\x01ÉÑÐ\x11▒p!¡\x02¼"pªø."
  b"\x01ÉÑÐ\x11²r!ÂK¾ \x0Eâu\x03"
  b"\x01ÉÑÐ\x12\x03s?è╔´</\x00H-"
  b"\x01ÉÑÐ\x12\x08p¦╣I\┌!kQ■"
  b"\x01ÉÑÐ\x12\x12q>│ø,/`²ãZ"
  b"\x01ÉÑÐ\x12%s¦åÏ┘MèÅú\f"
  b"""
    \x01ÉÑÐ\x12<q\n
    ç\x19½¥u»Íc
    """
  b"\x01ÉÑÐ\x12Or└¿KÛy^wÞf"
  b"\x01ÉÑÐ\x12Çq-¼þjß[åÜ÷"
  b"\x01ÉÑÐ\x12åpàé4[p©╠³¿"
  b"\x01ÉÑÐ\x12ïq\x07íñ´,u╠¸s"
  b"\x01ÉÑÐ\x12Ær!┤)┴\x1C½ù3\x0F"
  b"\x01ÉÑÐ\x12®r>¢«é╣G├9\x1C"
  b"\x01ÉÑÐ\x12╗pØ×··ò¹\x00¨¨"
  b"\x01ÉÑÐ\x12Ðrªº¡Îy‗C\x02""
  b"\x01ÉÑÐ\x12‗pÿªòR\x15[ƒ\x16┘"
  b"\x01ÉÑÐ\x13\x03p°½╝║soıh\x02"
  b"\x01ÉÑÐ\x13\x16s\x1A░µ^}Vf÷z"
  b"\x01ÉÑÐ\x13*s8░ÒHà╩ñF┐"
  b"\x01ÉÑÐ\x13=p®gk┐-âJ─"
  b"\x01ÉÑÐ\x13Pq4ø­L¿\x19fÄ┴"
  b"\x01ÉÑÐ\x13asRê(³EVí\x10Z"
  b"\x01ÉÑÐ\x13sq¹▓Qj \x0EP\x045"
  b"\x01ÉÑÐ\x13çq?¢í\x03£IM\x07╝"
  b"\x01ÉÑÐ\x13ÜrWîîÃ‗`\x1C¡É"
  b"\x01ÉÑÐ\x13┤r§¢\x00f\x02╔\x134¥"
  b"\x01ÉÑÐ\x13¢r%ó\x13\x1Aà-Þ┴2"
  b"\x01ÉÑÐ\x13Êq\tòô\x15Ì┤╗³Ì"
  b"\x01ÉÑÐ\x13µp\x01áE·¬Æ^\x00&"
  b"\x01ÉÑÐ\x14\fsQøK´¨$©\fÅ"
  b"\x01ÉÑÐ\x14\x12rKÀf╣\eaÔ└_"
  b"\x01ÉÑÐ\x14\x1FsúÁþ┘ÊÏ╗Ľ"
  b"\x01ÉÑÐ\x140sÿ╗)g}▄\x17┌ë"
  b"\x01ÉÑÐ\x14Dq·ª\¤îp\x13\x14╝"
  b"\x01ÉÑÐ\x14\rÕÄlxß~┤ÂO"
  b"\x01ÉÑÐ\x14oq═£¯f╠XB\x01c"
  b"\x01ÉÑÐ\x14är‗íðspìt■N"
  b"\x01ÉÑÐ\x14£rßü¶âùZ\x04ÏY"
  b"\x01ÉÑÐ\x14»sÉöf╩òhÊ2º"
  b"\x01ÉÑÐ\x14┼sÂÆ┴ò!\x17ó¼õ"
  b"\x01ÉÑÐ\x14þpıï‗ÃôòÑÎþ"
  b"\x01ÉÑÐ\x15\x0EpK╣Ãî²\x0E$▄Ç"
  b"\x01ÉÑÐ\x15<qÌÅ┘a|\x01öÇc"
  b"\x01ÉÑÐ\x15bs.ÿ¿K\x08¥R\x01\x04"
  b"\x01ÉÑÐ\x15îr╔¥÷▒^døþø"
  b"\x01ÉÑÐ\x15▓pMûÞxL"■U\x0F"
  b"\x01ÉÑÐ\x15Ãq¾ªÒ\x0EFTë·¤"
  b"\x01ÉÑÐ\x15┘pÂóAß┘~┬ßJ"
  b"\x01ÉÑÐ\x15ýq│ïM²}ùkÐ×"
  b"\x01ÉÑÐ\x15 roë┌µéMw■\x06"
  b"\x01ÉÑÐ\x16\x12qQë\x07[\rEIØï"
  b"\x01ÉÑÐ\x16'rd¡tåÒú¢¬m"
  b"\x01ÉÑÐ\x168p\x19ûÑ>°¶╗Z¦"
  b"\x01ÉÑÐ\x16MqàÜ\x07ßH▓UVj"
  b"\x01ÉÑÐ\x16`q-ç\x04ækpÅ\x10H"
  b"\x01ÉÑÐ\x16sr\x02øø┐ÉL¿²ó"
  b"\x01ÉÑÐ\x16àquî\x7F¸ß┼─ÏÍ"
  b"\x01ÉÑÐ\x16Ör!┤▄\rï─\x17j<"
  b"\x01ÉÑÐ\x16¡p ØÆÐN:ëë¨"
  b"\x01ÉÑÐ\x16┬rPôû.ò\x18\x1C■R"
  b"\x01ÉÑÐ\x16Ís\x01╗░´w_B¼*"
  b"\x01ÉÑÐ\x16Úst░┘\x13Ù┴m\x1Dz"
  b"\x01ÉÑÐ\x16·r&èש%«¤»{"
  b"\x01ÉÑÐ\x17\x11sAÂv\x05;n┤¬\r"
  b"\x01ÉÑÐ\x17"s¼¼%oÔ]7µ\x10"
  b"\x01ÉÑÐ\x176rºîV÷Êg^Ê;"
  b"\x01ÉÑÐ\x17Jrߢ}cùx/\x1Dí"
  b"\x01ÉÑÐ\x17^pí╗k┘[?è,W"
  b"\x01ÉÑÐ\x17qs\x04ú\x14£1;áóì"
  b"\x01ÉÑÐ\x17àpƒÄ¦íVÂ\eð═"
  b"\x01ÉÑÐ\x17ªpÞòº|╔Þ´╬░"
  b"""
    \x01ÉÑÐ\x17¥rÀû║└\n
    îq\x055
    """
  b"\x01ÉÑÐ\x17ÍsAà¶ÓÒ¨╦o\x00"
  b"\x01ÉÑÐ\x17ÕqÝú▀+y╠,\f═"
  b"\x01ÉÑÐ\x18 sÅ«ÑñMU\x18P┌"
  b"\x01ÉÑÐ\x182q+ô+▄ôÚÐ\x1DE"
  b"\x01ÉÑÐ\x18Hr«║Òi\x17;Z¸▒"
  b"\x01ÉÑÐ\x18\q■ÿI╣e[·┌\x04"
  b"\x01ÉÑÐ\x18rpØñ¦\x7F¦ö╔ä├"
  b"\x01ÉÑÐ\x18åp├ô-ü╔­À_"
  b"\x01ÉÑÐ\x18Öpp│\x04ãi╚P▄\x19"
  b"\x01ÉÑÐ\x18«pS░¹L-¤>úl"
  b"\x01ÉÑÐ\x18Ðs-Ä\x18╝¸BØZÖ"
  b"\x01ÉÑÐ\x18Ôq█ëG}\vç4Ðf"
  b"\x01ÉÑÐ\x18¨srñ\vcݹîGC"
  b"""
    \x01ÉÑÐ\x19\n
    qä¿©ñrÛ└)¬
    """
  b"\x01ÉÑÐ\x19!q\x7F¬÷Ù/ô(HÅ"
  b"\x01ÉÑÐ\x195qö»98═-Í┌:"
  b"\x01ÉÑÐ\x19Nq#í¸+¥┘9Fß"
  b"\x01ÉÑÐ\x19bprǺ>\x15g7³q"
  b"\x01ÉÑÐ\x19xqÿëù·P\x1AúvÇ"
  b"\x01ÉÑÐ\x19Äs(©¨²x-Ø\x01J"
  b"\x01ÉÑÐ\x19áqOóëe(╩\Xè"
  b"\x01ÉÑÐ\x19▓rÞ©┌|├ƪ±┐"
  b"\x01ÉÑÐ\x19ÃriüL\x7FÐ░┬.A"
  b"\x01ÉÑÐ\x19Ïrå▒G±ý¸]öô"
  b"\x01ÉÑÐ\x19¯s`Çèõe╚6║â"
  b"\x01ÉÑÐ\x1A\x04pù½Üð║\x17\x1489"
  b"\x01ÉÑÐ\x1A\x17s\x1F▓Ï┘╔cß6ÿ"
  b"\x01ÉÑÐ\x1A)rÀôë╦jD·ï▒"
  b"\x01ÉÑÐ\x1A<q\x00Â`L╗ඡù"
  b"\x01ÉÑÐ\x1ASpıè-΃QB╩┘"
  b"\x01ÉÑÐ\x1AfpH┤©\x05\x16Óè\x11Î"
]

SELECT
  `country`.`id` as `country.id`,
  `country`.`iso` as `country.iso`,
  `country`.`position` as `country.position`,
  `country`.`active` as `country.active`,
  `country`.`shipping_available` as `country.shippingAvailable`,
  `country`.`iso3` as `country.iso3`,
  `country`.`display_state_in_registration` as `country.displayStateInRegistration`,
  `country`.`force_state_in_registration` as `country.forceStateInRegistration`,
  `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`,
  `country`.`vat_id_required` as `country.vatIdRequired`,
  `country`.`vat_id_pattern` as `country.vatIdPattern`,
  `country`.`customer_tax` as `country.customerTax`,
  `country`.`company_tax` as `country.companyTax`,
  `country`.`postal_code_required` as `country.postalCodeRequired`,
  `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`,
  `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`,
  `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`,
  `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`,
  `country`.`is_eu` as `country.isEu`,
  `country`.`created_at` as `country.createdAt`,
  `country`.`updated_at` as `country.updatedAt`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(
          `country.salesChannels.mapping`.`sales_channel_id`
        ) SEPARATOR '||'
      )
    FROM
      `sales_channel_country` `country.salesChannels.mapping`
    WHERE
      `country.salesChannels.mapping`.`country_id` = `country`.`id`
  ) as `country.salesChannels.id_mapping`,
  `country.translation.name`,
  `country.translation.name` as `country.name`,
  `country.translation.addressFormat`,
  `country.translation.addressFormat` as `country.addressFormat`,
  `country.translation.customFields`,
  `country.translation.customFields` as `country.customFields`
FROM
  `country`
  LEFT JOIN (
    SELECT
      `country.translation`.`country_id`,
      `country.translation`.`name` as `country.translation.name`,
      `country.translation`.`custom_fields` as `country.translation.customFields`,
      `country.translation`.`address_format` as `country.translation.addressFormat`
    FROM
      `country_translation` `country.translation`
    WHERE
      `country.translation`.`language_id` = ?
  ) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id`
WHERE
  `country`.`id` IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, (SELECT GROUP_CONCAT(HEX(`country.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
                  FROM `sales_channel_country` `country.salesChannels.mapping`
                  WHERE `country.salesChannels.mapping`.`country_id` = `country`.`id` ) as `country.salesChannels.id_mapping`, `country.translation.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (0x0190A5D0B69C7375801D50780D461CB4, 0x0190A5D0B6E471D7A1D418AD821E1793, 0x0190A5D0B6E873DEA8D50606C2DA2CC7, 0x0190A5D0B94370D1AEC3A7A5101FB8BB, 0x0190A5D0B94670A7B76253B176ED65CC, 0x0190A5D0B94971B58C5590FBAFC4728D, 0x0190A5D0B94D71A19FD88C9C13BA9FED, 0x0190A5D0B951711CA1B1CF9F7065F599, 0x0190A5D0B955720097DF8EB45C413DFA, 0x0190A5D0B959717693A00C2F33955D5D, 0x0190A5D0B95C7205946B5C7B9C34C61F, 0x0190A5D0B95F73B2BD79F1FF15C54CCF, 0x0190A5D0B96373499C0E0F7D6071FB41, 0x0190A5D0B96770CDB01A51379BDB72A4, 0x0190A5D0B96A70DAAA97BA142E23C869, 0x0190A5D0B96D7303BF353DD303E5B927, 0x0190A5D0B97072309F2F86C1BAFFE2C6, 0x0190A5D0B973706F9D684AB105961896, 0x0190A5D0BA1C71F2AD621C2C68C2977B, 0x0190A5D0BA2370C18272BA079D49D00A, 0x0190A5D0BA2A7206866733DD8D910AE7, 0x0190A5D0BA2E7376AEAA136CE0DBC936, 0x0190A5D0BA327326B31594897E967EF8, 0x0190A5D0BA3773F0AC2C3A4DB3BE36D6, 0x0190A5D0BA3B733BB0A8631AE7B0A080, 0x0190A5D0BA3F724A9E443A9E72B1DFEE, 0x0190A5D0BA4270F2B7421BD303D69842, 0x0190A5D0BA46717098341A6215F958A0, 0x0190A5D0BA4B7016AEDFB4D605F729F2, 0x0190A5D0BA4E703AB15E8B4DAF7A2CDC, 0x0190A5D0BA5370498EFF004F4F44881D, 0x0190A5D0BA5970C382A64BC600CA6D4A, 0x0190A5D0BA5F7049B6E1C142B7ABC3F9, 0x0190A5D107787076B092BDBAEB76CCF5, 0x0190A5D1078B73CDA19E0B73761213E2, 0x0190A5D107A0702FBA4AD0CEC29471A2, 0x0190A5D107B473CDA2A33B032B997C9A, 0x0190A5D107C970C8B9E1E97D8350A245, 0x0190A5D107E072CF8B4ABE2D59CAF3AE, 0x0190A5D107F3702BAE4BC50D9CE49998, 0x0190A5D10806702EA894158F3AA026F6, 0x0190A5D1081A7109BB67070E5092501D, 0x0190A5D1082E72BE964CCF2256B6410C, 0x0190A5D10841707FB2F139452C19570B, 0x0190A5D1085773F49DA84DF5995CEBF2, 0x0190A5D1086B73DD98BFE654677220AA, 0x0190A5D1087F72FE8B98308AF51E2ED0, 0x0190A5D1089573E5AB22E2D8C7372656, 0x0190A5D108AB71E886F7B100D4CFBB2B, 0x0190A5D108C070778B83A89F9F545F62, 0x0190A5D108D473CBAA35BB59B0B4D111, 0x0190A5D108EC70DCBCD67F41C2CAEEFC, 0x0190A5D109027174845BDB4C59A24AB6, 0x0190A5D1091872E88FCBA6AB9CF3AF51, 0x0190A5D1094F730F8F994E7FAA91094A, 0x0190A5D1097C72FC934D51E8A9009DED, 0x0190A5D109A472569C12CC90AE2CA610, 0x0190A5D109D9704A8E0775FAD3E3ACAD, 0x0190A5D109F07080A5B2D74594C571FA, 0x0190A5D10A0370D2B0288CD6087CF1C2, 0x0190A5D10A17735D93CF8B8EE376FBAE, 0x0190A5D10A2D733EA5F4E92D9A1EF680, 0x0190A5D10A4273BF99075AC368BB72AF, 0x0190A5D10A58734C9AEAAF9C375A48B6, 0x0190A5D10A6C73C39927A0C084C0943C, 0x0190A5D10A8170DF9160E2121C2E9933, 0x0190A5D10A9972A3A5403A922EA10713, 0x0190A5D10AAC734F91F41B472AF9E854, 0x0190A5D10AC072498C9170E668718761, 0x0190A5D10AD3719B97FAF182CB49C4EC, 0x0190A5D10AEA715B873700E8DC44ED1C, 0x0190A5D10AFF735199911A1891DB5684, 0x0190A5D10B1373EEB28ED0B3A721BFFC, 0x0190A5D10B2671E7A1C31CE53FEB0540, 0x0190A5D10B3972E48BA5D10D7C276348, 0x0190A5D10B4C73AFA9590F0F9953DF20, 0x0190A5D10B67723C85476A063AAA90D1, 0x0190A5D10B7B71F588C53B4C8E86FCB8, 0x0190A5D10B8F715BB1D709E970E493C7, 0x0190A5D10BA573C9BBCB9511AA597FEC, 0x0190A5D10BBA710397157D71976291D5, 0x0190A5D10BCE70FA8409B578BB2099FC, 0x0190A5D10BE37146971DD98B7402F25B, 0x0190A5D10BFA731D8652B2B19BD865E5, 0x0190A5D10C0D7182908D4483539DADEC, 0x0190A5D10C247035A2F1DEED6094E146, 0x0190A5D10C377080AF1DABE870D98FBA, 0x0190A5D10C4D7376810A0D24A1CF6345, 0x0190A5D10C61706E82A89587AE199068, 0x0190A5D10C7770A6A4362A80BA3BB211, 0x0190A5D10C8B71859F5873F23BE08921, 0x0190A5D10C9F7135BB087536ADC0E2D9, 0x0190A5D10CB37296A759DB001C98C440, 0x0190A5D10CC77057B7C00FE842C6E06D, 0x0190A5D10CDB7286B40624736F30AD4C, 0x0190A5D10CF0720D9A4E6A246C33911A, 0x0190A5D10D0D72F39C6332820C7C9B60, 0x0190A5D10D3070FBA02AF752A2C5AB4D, 0x0190A5D10D5B710F89676D9840AFAD2A, 0x0190A5D10D7F7126989D501A7882716A, 0x0190A5D10D9170C3B5D9BA98813A0F27, 0x0190A5D10DA6707689B935E158FA1A0A, 0x0190A5D10DBD720B97478D569685C0F1, 0x0190A5D10DD172DEB2E1DF63284103D3, 0x0190A5D10DE37052B277ECA5E3705768, 0x0190A5D10DF77396B4E57FE975C69B78, 0x0190A5D10E0B71E8984E750F1690896C, 0x0190A5D10E20713BB1CCCA50096EE585, 0x0190A5D10E35725D82D92860A3AD2448, 0x0190A5D10E55721B9102935198127EC9, 0x0190A5D10E6A71458D74C03C88FF20AA, 0x0190A5D10E7E716A9A973BEAAD8E4079, 0x0190A5D10E9372EA820E9F1534EB3A54, 0x0190A5D10EA671FA9AF36889E3C5315C, 0x0190A5D10EB87363B021B763E02D714C, 0x0190A5D10ECC715BBBB9498C4C3A4099, 0x0190A5D10EDF71309E7F1E6E0556E6D8, 0x0190A5D10EF372C2B24AB3E84D25F137, 0x0190A5D10F06716F903E5F71E4B2C6FC, 0x0190A5D10F19735389978200377F1C39, 0x0190A5D10F2C72EAAE3BC3EE7E5DE50B, 0x0190A5D10F417100A0D51672EA9F150B, 0x0190A5D10F5572A0B20C846FF0643266, 0x0190A5D10F6970A786FCEEBB6B8AEB78, 0x0190A5D10F7A735F87BEFCA616F05AD7, 0x0190A5D10F8D7250ABAA45BC6E8E7219, 0x0190A5D10FA270FF809A6489F862B2FD, 0x0190A5D10FB8713F938E4E4303ADC7E8, 0x0190A5D10FCB713180D826C92B72B504, 0x0190A5D10FDE724BA06ED9C585A27A5A, 0x0190A5D10FF17004812BFCC13CE63B8E, 0x0190A5D1100570488A782088205CCECB, 0x0190A5D11018713FB8B5618195695220, 0x0190A5D1102A700387F8DF0E055FB1DD, 0x0190A5D11046718DBFA3EA2FE9751FCC, 0x0190A5D1105370939FEE086AD4FE6845, 0x0190A5D1106B73FCBB8BE57E7B6420BF, 0x0190A5D11085721ABF6173917AD61630, 0x0190A5D110B673EDAD8ED402F2EE96C4, 0x0190A5D110BF70569AB223A523AD5078, 0x0190A5D110C57372BE9D3A094A891D34, 0x0190A5D110CC72FB9F02DCE383C83B12, 0x0190A5D110E072518D51FFB9D0B09245, 0x0190A5D110F772A48E6F14C9EDB6ECBE, 0x0190A5D111227170A4AF488C5275AF83, 0x0190A5D1115173E08094272472923511, 0x0190A5D1117D702494A896DE8B1D056A, 0x0190A5D111B17021AD02AC2270A69B2E, 0x0190A5D111FD7221B64BF3FF0E837503, 0x0190A5D11203733F8AC9EF3C2F00482D, 0x0190A5D1120870DDB9495CDA216B51FE, 0x0190A5D11212713EB39B2C2F60FDC65A, 0x0190A5D1122573DD86D8D94D8A8FA30C, 0x0190A5D1123C710A8719ABBE75AFD663, 0x0190A5D1124F72C0A84BEA795E77E866, 0x0190A5D11280712DACE76AE15B869AF6, 0x0190A5D11286708582345B70B8CCFCA8, 0x0190A5D1128B7107A1A4EF2C75CCF773, 0x0190A5D112927221B429C11CAB97330F, 0x0190A5D112A9723EBDAE82B947C3391C, 0x0190A5D112BB709D9EFAFA95FB00F9F9, 0x0190A5D112D172A6A7ADD779F2430222, 0x0190A5D112F27098A69552155B9F16D9, 0x0190A5D1130370F8ABBCBA736FD56802, 0x0190A5D11316731AB0E65E7D5666F67A, 0x0190A5D1132A7338B0E34885CAA446BF, 0x0190A5D1133D70B6A9676BBF2D834AC4, 0x0190A5D1135071349BF04CA819668EC1, 0x0190A5D1136173528828FC4556A1105A, 0x0190A5D1137371FBB2516AFF0E500435, 0x0190A5D11387713FBDA1039C494D07BC, 0x0190A5D1139A72578C8CC7F2601CAD90, 0x0190A5D113B472F5BD006602C91334BE, 0x0190A5D113BD7225A2131A852DE8C132, 0x0190A5D113D27109959315DEB4BBFCDE, 0x0190A5D113E67001A045FAAA925E0026, 0x0190A5D1140C73519B4BEFF924B80C8F, 0x0190A5D11412724BB766B91B61E2C05F, 0x0190A5D1141F73A3B5E7D9D2D8BB8EAB, 0x0190A5D114307398BB29677DDC17DA89, 0x0190A5D1144471FAA65CCF8C701314BC, 0x0190A5D1145C72E58E6C78E17EB4B64F, 0x0190A5D1146F71CD9CEE66CC58420163, 0x0190A5D1148472F2A1D073708D74FE4E, 0x0190A5D1149C72E181F483975A04D859, 0x0190A5D114AF73909466CA9568D232A7, 0x0190A5D114C573B692C1952117A2ACE4, 0x0190A5D114E770D58BF2C79395A5D7E7, 0x0190A5D1150E704BB9C78CFD0E24DC80, 0x0190A5D1153C71DE8FD9617C01948063, 0x0190A5D11562732E98A84B08BE520104, 0x0190A5D1158C72C9BEF6B15E649BE79B, 0x0190A5D115B2704D96E8784C22FE550F, 0x0190A5D115C771F3A6E30E465489FACF, 0x0190A5D115D970B6A241E1D97EC2E14A, 0x0190A5D115EC71B38B4DFD7D976BD19E, 0x0190A5D115FF726F89DAE6824D77FE06, 0x0190A5D11612715189075B0D45499D8B, 0x0190A5D116277264AD7486E3A3BDAA6D, 0x0190A5D11638701996A53EF8F4BB5ADD, 0x0190A5D1164D71859A07E148B255566A, 0x0190A5D11660712D8704916B708F1048, 0x0190A5D1167372029B9BBF904CA8FDA2, 0x0190A5D1168571758C7FF7E1C5C4D8D6, 0x0190A5D116997221B4DC0D8BC4176A3C, 0x0190A5D116AD70209D92D14E3A8989F9, 0x0190A5D116C2725093962E95181CFE52, 0x0190A5D116D67301BBB0EF775F42AC2A, 0x0190A5D116E97374B0D913EBC16D1D7A, 0x0190A5D116FA72268A9EB825AECFAF7B, 0x0190A5D117117341B676053B6EB4AA0D, 0x0190A5D1172273ACAC256FE25D37E610, 0x0190A5D1173672A78C56F6D2675ED23B, 0x0190A5D1174A72E1BD7D6397782F1DA1, 0x0190A5D1175E70A1BB6BD95B3F8A2C57, 0x0190A5D117717304A3149C313BA0A28D, 0x0190A5D11785709F8EDDA156B61BD0CD, 0x0190A5D117A670E895A77CC9E8EFCEB0, 0x0190A5D117BE72B796BAC00A8C710535, 0x0190A5D117D6734185F4E0E3F9CB6F00, 0x0190A5D117E571EDA3DF2B79CC2C0CCD, 0x0190A5D11820738FAEA5A44D551850DA, 0x0190A5D11832712B932BDC93E9D11D45, 0x0190A5D1184872AEBAE369173B5AF7B1, 0x0190A5D1185C71FE9849B9655BFADA04, 0x0190A5D11872709DA4DD7FDD94C984C3, 0x0190A5D1188670C3932DC7ACC9F0B75F, 0x0190A5D118997070B304C669C850DC19, 0x0190A5D118AE7053B0FB4C2DCF3EA36C, 0x0190A5D118D1732D8E18BCF7429D5A99, 0x0190A5D118E271DB89477D0B8734D166, 0x0190A5D118F97372A40B63EDFB8C4743, 0x0190A5D1190A7184A8B8A472EAC029AA, 0x0190A5D11921717FAAF6EB2F9328488F, 0x0190A5D119357194AF3938CD2DD6DA3A, 0x0190A5D1194E7123A1F72BBED93946E1, 0x0190A5D11962707280A73E156737FC71, 0x0190A5D1197871988997FA501AA37680, 0x0190A5D1198E7328B8F9FD782D9D014A, 0x0190A5D119A0714FA2896528CA5C588A, 0x0190A5D119B272E8B8DA7CC392A6F1BF, 0x0190A5D119C77269814C7FD1B0C22E41, 0x0190A5D119D87286B147F1ECF75D9493, 0x0190A5D119EE7360808AE465C836BA83, 0x0190A5D11A047097AB9AD0BA17143839, 0x0190A5D11A17731FB2D8D9C963E13698, 0x0190A5D11A2972B79389CB6A44FA8BB1, 0x0190A5D11A3C7100B6604CBB85F4AD97, 0x0190A5D11A5370D58A2DD79F5142CAD9, 0x0190A5D11A667048B4B80516E08A11D7);

SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE (`currency`.`iso_code` IN (?, ?))

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "CHF"
  "EUR"
]

SELECT
  `currency`.`id` as `currency.id`,
  `currency`.`factor` as `currency.factor`,
  `currency`.`symbol` as `currency.symbol`,
  `currency`.`iso_code` as `currency.isoCode`,
  `currency`.`position` as `currency.position`,
  `currency`.`tax_free_from` as `currency.taxFreeFrom`,
  `currency`.`item_rounding` as `currency.itemRounding`,
  `currency`.`total_rounding` as `currency.totalRounding`,
  `currency`.`created_at` as `currency.createdAt`,
  `currency`.`updated_at` as `currency.updatedAt`,
  `currency.translation.shortName`,
  `currency.translation.shortName` as `currency.shortName`,
  `currency.translation.name`,
  `currency.translation.name` as `currency.name`,
  `currency.translation.customFields`,
  `currency.translation.customFields` as `currency.customFields`
FROM
  `currency`
  LEFT JOIN (
    SELECT
      `currency.translation`.`currency_id`,
      `currency.translation`.`short_name` as `currency.translation.shortName`,
      `currency.translation`.`name` as `currency.translation.name`,
      `currency.translation`.`custom_fields` as `currency.translation.customFields`
    FROM
      `currency_translation` `currency.translation`
    WHERE
      `currency.translation`.`language_id` = ?
  ) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id`
WHERE
  (
    `currency`.`iso_code` IN (?, ?)
  )

SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE (`currency`.`iso_code` IN ('CHF', 'EUR'));

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)

[
  "/detail/3cb21e9a5a02f44f2386ca00350360e1"
  "/navigation/0191991d5eb67fd4b567fba328e920b9"
  "/navigation/0191ee79a6787f3ebee5fac531dd762f"
  "/navigation/0191ee79d625774ea134623944f3fcbb"
  "/navigation/0191ee79f4297d84b7916c7493090310"
  "/navigation/0191ee8834aa7e0bacebfed3705d2f42"
  "/navigation/0191ee7b08dc78f49e8cc3d05be28f77"
  "/navigation/0191ee6d4d6b7fc5bcad94019bf1e96b"
  "/navigation/0191ee6d70757a6ca9c423539622f9ae"
  "/navigation/0191ee6d8fb27f8eb69858c1e836a16a"
  "/navigation/0191ee6db9f3790d80e39026e4cd8ebb"
  "/navigation/0191ee6ddae6739ba84e5b6196ec2c88"
  "/navigation/0191ee6dfd087c0dacb354db6e3d36ef"
  "/navigation/0191ee6e265d768a91a683a7ef2d63fc"
  "/navigation/0191ee6e4a32731a900bb77db5d36c32"
  "/navigation/0191ee6e78d2746ca16d6b93bada0a81"
  "/navigation/0191ee6ea63a7c8bbdbda9515feddae9"
  "/navigation/0191ee6edf2d765283cc5d79189f0394"
  "/navigation/0191ee6ef1fe75429f15660a27ec31ba"
  "/navigation/019bbc13360772d48aa0e775b36078fc"
  "/navigation/0191ee7a8eff7f1ebc65845f5e28284c"
  "/navigation/0191ee8f84c671d78bd828bdfaa24128"
  "/navigation/0191ee8fb87e7680b42765fffe64b6c2"
  "/navigation/0191ee8fcf8c70738480b2ab98219716"
  "/navigation/019bbc8addde7ec0b9de3c09f9d67c79"
  "/navigation/0191ee8b859d7e7da514bdc0768cc521"
  "/navigation/0191ee8ba2087cf980fe6bcb30af6db2"
  "/navigation/0191ee8bbda37bd7b9e0fad4751a32ce"
  "/navigation/0191ee8bcfe27cbaa3ff3939db0de93a"
  "/navigation/0191ee8bf4fb72e48edc1694c64a24be"
  "/navigation/0191ee8bfdd076bbb2a4eb12e1fbb085"
  "/navigation/0191ee8c0f2a7b958b4976e43d13f1bd"
  "/navigation/0191ee8c2af57498845593f11f801c1e"
  "/navigation/0191ee8c39b071929ec9011fc654c0d4"
  "/navigation/0191ee8c48587f56b6507202f96c078a"
  "/navigation/0191ee8c6b317bf8bac59dd0539ee242"
  "/navigation/0191ee8c9ffd7531921fa96cd08e6870"
  "/navigation/019bbc1f5a437136aab323feda1d2318"
  "/navigation/0191ee88ef8870e39e23e5c220b067fb"
  "/navigation/0191ee8904567fe7adbab40cfc5d69d5"
  "/navigation/0191ee8923c472ab81aa73663f7cf3f7"
  "/navigation/0191ee894a09763b8057e91754cef150"
  "/navigation/0191ee8968177963ac3aa14c10d37bc9"
  "/navigation/0191ee89779879ef963e6f1540030795"
  "/navigation/0191ee89884e78368492ab963012db6c"
  "/navigation/0191ee8998cc7222b91ba046b53192f9"
  "/navigation/019bbc8c364e78b38debf325c0948ed3"
  "/navigation/0197eab99a3e75dd8ad2c73889740341"
  "/navigation/0197d448ba2c7b199942eb3f22924203"
  "/navigation/0197eaba7b8c7e55abd85d988e9cee74"
  "/navigation/0197eaba9d2e7732bf768c604fd3f081"
  "/navigation/0191ee7ba89c75a2ba0ab988a5d8eb41"
  "/navigation/0197c6cd65837af7b7b5bb1d07118f90"
  "/navigation/0197c6cda35d73078fe33fce062c3f8f"
  "/navigation/0197c6cdef4e7480ad18f56a29f1c2de"
  "/navigation/0197c6ce0f52712a82719412b96a72cc"
  "/navigation/0197c6ce2a9d71d29ab20a61450751f4"
  "/navigation/0197c6ce5f5877dab18548a7feca9cb0"
  "/navigation/0191ee7bbca17c70b8fafb3b5ba5e986"
  "/navigation/0197cbf7289070ac9957fb8239ac36f3"
  "/navigation/0197cbf7897d714382426d8376f4bfc8"
  "/navigation/0191ee7bd61d725cb9b1f1665a57ff2b"
  "/navigation/0191ee7bf27c7f0b9d4b926ed5083238"
  "/navigation/0197e971cb747e65b6c65a1d256f4ea2"
  "/navigation/0197e97244247d2bb74e791fd85fb1fd"
  "/navigation/019690bc6707711e88da28969c511a89"
  "/navigation/0197cbb94c187370ae556386a7468a03"
  "/navigation/0197cbb986f570fb8b2eed529ea53e75"
  "/navigation/0191ee7c21677f4595a2b91b0303681d"
  "/moorl-magazine/article/8a4b6f0cb82a16e9af059a7302f087ce"
  "/author/Weaver,%20Sue"
  "/detail/23a05f7eb0ca6ff0e296b6a0347143bb"
  "/detail/725317b348c6b978cc806e0cb932726c"
  "/detail/d0ba97fc30720ebf7b47632ace783dbc"
  "/detail/c2f6efa477986429271a9b6fd6b8150c"
  "/detail/60631352e0ccc6475002125cff12bd48"
  "/detail/e67423d59efcbc1cec146b955ab83e45"
  "/navigation/0190ba53fe0673a28d789f957f8c8db7"
  "/navigation/0190ba542b957fab996cb7ede232036e"
  "/navigation/0190ba5447c07f729e5aac14ab3977b8"
  "/navigation/0190ba546be170968b14cb8c25875a2a"
  "/navigation/0190ba58be4b7a20a08c5bb8c1a6daaf"
  "/navigation/0190ba556daf75c1a2780021b765e2d9"
  "/navigation/0190ba558dea7f4ca2e1a2d8a22b1081"
  "/navigation/0190ba55964f7ad9bcf0d435407e367f"
  "/navigation/0190ba55c18b70218fa12367468dc14a"
  "/navigation/0190ba5826c97e72ad021d9ac2ab2ffb"
  "/navigation/0190ba583d7d773387a1506471bed744"
  "/navigation/0190ba5869fe70f79e656dfa6b015df2"
  "/navigation/01968c734b3f7eef8c0efce23dddc529"
  "/navigation/0190ba58834b73568e28fef89cb2b86f"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01ɪJ£&pò▓Ãè ÌôÜÓ"
]

# seo_url::replacement
SELECT
  seo_path_info,
  path_info,
  sales_channel_id
FROM
  seo_url
WHERE
  (seo_url.is_canonical = 1)
  AND (
    seo_url.path_info IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  AND (seo_url.language_id = ?)
  AND (
    seo_url.sales_channel_id = ?
    OR seo_url.sales_channel_id IS NULL
  )
  AND (seo_url.is_deleted = 0)

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/detail/3cb21e9a5a02f44f2386ca00350360e1', '/navigation/0191991d5eb67fd4b567fba328e920b9', '/navigation/0191ee79a6787f3ebee5fac531dd762f', '/navigation/0191ee79d625774ea134623944f3fcbb', '/navigation/0191ee79f4297d84b7916c7493090310', '/navigation/0191ee8834aa7e0bacebfed3705d2f42', '/navigation/0191ee7b08dc78f49e8cc3d05be28f77', '/navigation/0191ee6d4d6b7fc5bcad94019bf1e96b', '/navigation/0191ee6d70757a6ca9c423539622f9ae', '/navigation/0191ee6d8fb27f8eb69858c1e836a16a', '/navigation/0191ee6db9f3790d80e39026e4cd8ebb', '/navigation/0191ee6ddae6739ba84e5b6196ec2c88', '/navigation/0191ee6dfd087c0dacb354db6e3d36ef', '/navigation/0191ee6e265d768a91a683a7ef2d63fc', '/navigation/0191ee6e4a32731a900bb77db5d36c32', '/navigation/0191ee6e78d2746ca16d6b93bada0a81', '/navigation/0191ee6ea63a7c8bbdbda9515feddae9', '/navigation/0191ee6edf2d765283cc5d79189f0394', '/navigation/0191ee6ef1fe75429f15660a27ec31ba', '/navigation/019bbc13360772d48aa0e775b36078fc', '/navigation/0191ee7a8eff7f1ebc65845f5e28284c', '/navigation/0191ee8f84c671d78bd828bdfaa24128', '/navigation/0191ee8fb87e7680b42765fffe64b6c2', '/navigation/0191ee8fcf8c70738480b2ab98219716', '/navigation/019bbc8addde7ec0b9de3c09f9d67c79', '/navigation/0191ee8b859d7e7da514bdc0768cc521', '/navigation/0191ee8ba2087cf980fe6bcb30af6db2', '/navigation/0191ee8bbda37bd7b9e0fad4751a32ce', '/navigation/0191ee8bcfe27cbaa3ff3939db0de93a', '/navigation/0191ee8bf4fb72e48edc1694c64a24be', '/navigation/0191ee8bfdd076bbb2a4eb12e1fbb085', '/navigation/0191ee8c0f2a7b958b4976e43d13f1bd', '/navigation/0191ee8c2af57498845593f11f801c1e', '/navigation/0191ee8c39b071929ec9011fc654c0d4', '/navigation/0191ee8c48587f56b6507202f96c078a', '/navigation/0191ee8c6b317bf8bac59dd0539ee242', '/navigation/0191ee8c9ffd7531921fa96cd08e6870', '/navigation/019bbc1f5a437136aab323feda1d2318', '/navigation/0191ee88ef8870e39e23e5c220b067fb', '/navigation/0191ee8904567fe7adbab40cfc5d69d5', '/navigation/0191ee8923c472ab81aa73663f7cf3f7', '/navigation/0191ee894a09763b8057e91754cef150', '/navigation/0191ee8968177963ac3aa14c10d37bc9', '/navigation/0191ee89779879ef963e6f1540030795', '/navigation/0191ee89884e78368492ab963012db6c', '/navigation/0191ee8998cc7222b91ba046b53192f9', '/navigation/019bbc8c364e78b38debf325c0948ed3', '/navigation/0197eab99a3e75dd8ad2c73889740341', '/navigation/0197d448ba2c7b199942eb3f22924203', '/navigation/0197eaba7b8c7e55abd85d988e9cee74', '/navigation/0197eaba9d2e7732bf768c604fd3f081', '/navigation/0191ee7ba89c75a2ba0ab988a5d8eb41', '/navigation/0197c6cd65837af7b7b5bb1d07118f90', '/navigation/0197c6cda35d73078fe33fce062c3f8f', '/navigation/0197c6cdef4e7480ad18f56a29f1c2de', '/navigation/0197c6ce0f52712a82719412b96a72cc', '/navigation/0197c6ce2a9d71d29ab20a61450751f4', '/navigation/0197c6ce5f5877dab18548a7feca9cb0', '/navigation/0191ee7bbca17c70b8fafb3b5ba5e986', '/navigation/0197cbf7289070ac9957fb8239ac36f3', '/navigation/0197cbf7897d714382426d8376f4bfc8', '/navigation/0191ee7bd61d725cb9b1f1665a57ff2b', '/navigation/0191ee7bf27c7f0b9d4b926ed5083238', '/navigation/0197e971cb747e65b6c65a1d256f4ea2', '/navigation/0197e97244247d2bb74e791fd85fb1fd', '/navigation/019690bc6707711e88da28969c511a89', '/navigation/0197cbb94c187370ae556386a7468a03', '/navigation/0197cbb986f570fb8b2eed529ea53e75', '/navigation/0191ee7c21677f4595a2b91b0303681d', '/moorl-magazine/article/8a4b6f0cb82a16e9af059a7302f087ce', '/author/Weaver,%20Sue', '/detail/23a05f7eb0ca6ff0e296b6a0347143bb', '/detail/725317b348c6b978cc806e0cb932726c', '/detail/d0ba97fc30720ebf7b47632ace783dbc', '/detail/c2f6efa477986429271a9b6fd6b8150c', '/detail/60631352e0ccc6475002125cff12bd48', '/detail/e67423d59efcbc1cec146b955ab83e45', '/navigation/0190ba53fe0673a28d789f957f8c8db7', '/navigation/0190ba542b957fab996cb7ede232036e', '/navigation/0190ba5447c07f729e5aac14ab3977b8', '/navigation/0190ba546be170968b14cb8c25875a2a', '/navigation/0190ba58be4b7a20a08c5bb8c1a6daaf', '/navigation/0190ba556daf75c1a2780021b765e2d9', '/navigation/0190ba558dea7f4ca2e1a2d8a22b1081', '/navigation/0190ba55964f7ad9bcf0d435407e367f', '/navigation/0190ba55c18b70218fa12367468dc14a', '/navigation/0190ba5826c97e72ad021d9ac2ab2ffb', '/navigation/0190ba583d7d773387a1506471bed744', '/navigation/0190ba5869fe70f79e656dfa6b015df2', '/navigation/01968c734b3f7eef8c0efce23dddc529', '/navigation/0190ba58834b73568e28fef89cb2b86f')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x0190A64A9C267095B2C78AFFDE939AE0 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?, ?, ?, ?, ?, ?))

[
  "frontend.detail.page"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"# _~°Êoðâ–¶ 4qC»"
  b"rS\x17³HƹxÌ€n\f¹2rl"
  b"к—ü0r\x0E¿{Gc*Îx=¼"
  b"Âöï¤w˜d)'\x1A›oÖ¸\x15\f"
  b"`c\x13RàÌÆGP\x02\x12\ÿ\x12½H"
  b"æt#Õžü¼\x1Cì\x14k•Z¸>E"
]

SELECT
  LOWER(
    HEX(seo_url.id)
  ) as id,
  LOWER(
    HEX(seo_url.foreign_key)
  ) foreignKey,
  LOWER(
    HEX(seo_url.sales_channel_id)
  ) salesChannelId,
  seo_url.is_modified as isModified,
  seo_url.seo_path_info seoPathInfo
FROM
  seo_url seo_url
WHERE
  (seo_url.route_name = ?)
  AND (seo_url.language_id = ?)
  AND (seo_url.is_canonical = 1)
  AND (
    seo_url.foreign_key IN (?, ?, ?, ?, ?, ?)
  )

SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url.route_name = 'frontend.detail.page') AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (0x23A05F7EB0CA6FF0E296B6A0347143BB, 0x725317B348C6B978CC806E0CB932726C, 0xD0BA97FC30720EBF7B47632ACE783DBC, 0xC2F6EFA477986429271A9B6FD6B8150C, 0x60631352E0CCC6475002125CFF12BD48, 0xE67423D59EFCBC1CEC146B955AB83E45));

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1

[
  b"\x01ɪJ£&pò▓Ãè ÌôÜÓ"
  "MMhwzZynZLeJ3HjuGTkYK6j5BOYMWpVj"
]

SELECT
  *
FROM
  sales_channel_api_context
WHERE
  (sales_channel_id = ?)
  AND (token = ?)
LIMIT
  1

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x0190A64A9C267095B2C78AFFDE939AE0) AND (token = 'MMhwzZynZLeJ3HjuGTkYK6j5BOYMWpVj') LIMIT 1;

SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?))

[
  "frontend.detail.page"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"<²\x1EšZ\x02ôO#†Ê\x005\x03`á"
]

SELECT
  LOWER(
    HEX(seo_url.id)
  ) as id,
  LOWER(
    HEX(seo_url.foreign_key)
  ) foreignKey,
  LOWER(
    HEX(seo_url.sales_channel_id)
  ) salesChannelId,
  seo_url.is_modified as isModified,
  seo_url.seo_path_info seoPathInfo
FROM
  seo_url seo_url
WHERE
  (seo_url.route_name = ?)
  AND (seo_url.language_id = ?)
  AND (seo_url.is_canonical = 1)
  AND (
    seo_url.foreign_key IN (?)
  )

SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url.route_name = 'frontend.detail.page') AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (0x3CB21E9A5A02F44F2386CA00350360E1));

UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?, ?, ?, ?, ?, ?)) AND (sales_channel_id = ?)

[
  b"# _~°Êoðâ–¶ 4qC»"
  b"rS\x17³HƹxÌ€n\f¹2rl"
  b"к—ü0r\x0E¿{Gc*Îx=¼"
  b"Âöï¤w˜d)'\x1A›oÖ¸\x15\f"
  b"`c\x13RàÌÆGP\x02\x12\ÿ\x12½H"
  b"æt#Õžü¼\x1Cì\x14k•Z¸>E"
  b"\x01ɪJ£&pò▓Ãè ÌôÜÓ"
]

UPDATE
  seo_url
SET
  is_deleted = 0
WHERE
  (
    foreign_key IN (?, ?, ?, ?, ?, ?)
  )
  AND (sales_channel_id = ?)

UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (0x23A05F7EB0CA6FF0E296B6A0347143BB, 0x725317B348C6B978CC806E0CB932726C, 0xD0BA97FC30720EBF7B47632ACE783DBC, 0xC2F6EFA477986429271A9B6FD6B8150C, 0x60631352E0CCC6475002125CFF12BD48, 0xE67423D59EFCBC1CEC146B955AB83E45)) AND (sales_channel_id = 0x0190A64A9C267095B2C78AFFDE939AE0);

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT `moorl_magazine_article`.`id` as `moorl_magazine_article.id`, `moorl_magazine_article`.`origin_id` as `moorl_magazine_article.originId`, `moorl_magazine_article`.`media_id` as `moorl_magazine_article.mediaId`, `moorl_magazine_article`.`moorl_creator_id` as `moorl_magazine_article.creatorId`, `moorl_magazine_article`.`cms_page_id` as `moorl_magazine_article.cmsPageId`, `moorl_magazine_article`.`cms_page_version_id` as `moorl_magazine_article.cmsPageVersionId`, `moorl_magazine_article`.`content_cms_page_id` as `moorl_magazine_article.contentCmsPageId`, `moorl_magazine_article`.`sales_channel_id` as `moorl_magazine_article.salesChannelId`, `moorl_magazine_article`.`user_id` as `moorl_magazine_article.userId`, `moorl_magazine_article`.`auto_increment` as `moorl_magazine_article.autoIncrement`, `moorl_magazine_article`.`custom1` as `moorl_magazine_article.custom1`, `moorl_magazine_article`.`custom2` as `moorl_magazine_article.custom2`, `moorl_magazine_article`.`custom3` as `moorl_magazine_article.custom3`, `moorl_magazine_article`.`custom4` as `moorl_magazine_article.custom4`, `moorl_magazine_article`.`active` as `moorl_magazine_article.active`, `moorl_magazine_article`.`sticky` as `moorl_magazine_article.sticky`, `moorl_magazine_article`.`invisible` as `moorl_magazine_article.invisible`, `moorl_magazine_article`.`enable_comments` as `moorl_magazine_article.enableComments`, `moorl_magazine_article`.`date` as `moorl_magazine_article.date`, `moorl_magazine_article`.`show_from` as `moorl_magazine_article.showFrom`, `moorl_magazine_article`.`show_until` as `moorl_magazine_article.showUntil`, `moorl_magazine_article`.`author` as `moorl_magazine_article.author`, `moorl_magazine_article`.`custom_fields` as `moorl_magazine_article.customFields`, `moorl_magazine_article.media`.`id` as `moorl_magazine_article.media.id`, `moorl_magazine_article.media`.`user_id` as `moorl_magazine_article.media.userId`, `moorl_magazine_article.media`.`media_folder_id` as `moorl_magazine_article.media.mediaFolderId`, `moorl_magazine_article.media`.`mime_type` as `moorl_magazine_article.media.mimeType`, `moorl_magazine_article.media`.`file_extension` as `moorl_magazine_article.media.fileExtension`, `moorl_magazine_article.media`.`uploaded_at` as `moorl_magazine_article.media.uploadedAt`, `moorl_magazine_article.media`.`file_name` as `moorl_magazine_article.media.fileName`, `moorl_magazine_article.media`.`file_size` as `moorl_magazine_article.media.fileSize`, `moorl_magazine_article.media`.`media_type` as `moorl_magazine_article.media.mediaTypeRaw`, `moorl_magazine_article.media`.`meta_data` as `moorl_magazine_article.media.metaData`, `moorl_magazine_article.media`.`config` as `moorl_magazine_article.media.config`, `moorl_magazine_article.media`.`path` as `moorl_magazine_article.media.path`, `moorl_magazine_article.media`.`private` as `moorl_magazine_article.media.private`, `moorl_magazine_article.media`.`thumbnails_ro` as `moorl_magazine_article.media.thumbnailsRo`, `moorl_magazine_article.media`.`file_hash` as `moorl_magazine_article.media.fileHash`, `moorl_magazine_article.media`.`created_at` as `moorl_magazine_article.media.createdAt`, `moorl_magazine_article.media`.`updated_at` as `moorl_magazine_article.media.updatedAt`, `moorl_magazine_article.media.translation.title`, `moorl_magazine_article.media.translation.title` as `moorl_magazine_article.media.title`, `moorl_magazine_article.media.translation.alt`, `moorl_magazine_article.media.translation.alt` as `moorl_magazine_article.media.alt`, `moorl_magazine_article.media.translation.customFields`, `moorl_magazine_article.media.translation.customFields` as `moorl_magazine_article.media.customFields`, `moorl_magazine_article.creator`.`id` as `moorl_magazine_article.creator.id`, `moorl_magazine_article.creator`.`moorl_creator_type_id` as `moorl_magazine_article.creator.creatorTypeId`, `moorl_magazine_article.creator`.`customer_id` as `moorl_magazine_article.creator.customerId`, `moorl_magazine_article.creator`.`cms_page_id` as `moorl_magazine_article.creator.cmsPageId`, `moorl_magazine_article.creator`.`cms_page_version_id` as `moorl_magazine_article.creator.cmsPageVersionId`, `moorl_magazine_article.creator`.`avatar_id` as `moorl_magazine_article.creator.avatarId`, `moorl_magazine_article.creator`.`banner_id` as `moorl_magazine_article.creator.bannerId`, `moorl_magazine_article.creator`.`active` as `moorl_magazine_article.creator.active`, `moorl_magazine_article.creator`.`schema_org_property` as `moorl_magazine_article.creator.schemaOrgProperty`, `moorl_magazine_article.creator`.`schema_org_type` as `moorl_magazine_article.creator.schemaOrgType`, `moorl_magazine_article.creator`.`link` as `moorl_magazine_article.creator.link`, `moorl_magazine_article.creator`.`banner_color` as `moorl_magazine_article.creator.bannerColor`, `moorl_magazine_article.creator`.`custom_fields` as `moorl_magazine_article.creator.customFields`, `moorl_magazine_article.creator.creatorType`.`id` as `moorl_magazine_article.creator.creatorType.id`, `moorl_magazine_article.creator.creatorType`.`cms_page_id` as `moorl_magazine_article.creator.creatorType.cmsPageId`, `moorl_magazine_article.creator.creatorType`.`cms_page_version_id` as `moorl_magazine_article.creator.creatorType.cmsPageVersionId`, `moorl_magazine_article.creator.creatorType`.`active` as `moorl_magazine_article.creator.creatorType.active`, `moorl_magazine_article.creator.creatorType`.`technical_name` as `moorl_magazine_article.creator.creatorType.technicalName`, `moorl_magazine_article.creator.creatorType`.`locked` as `moorl_magazine_article.creator.creatorType.locked`, `moorl_magazine_article.creator.creatorType`.`created_at` as `moorl_magazine_article.creator.creatorType.createdAt`, `moorl_magazine_article.creator.creatorType`.`updated_at` as `moorl_magazine_article.creator.creatorType.updatedAt`, `moorl_magazine_article.creator.creatorType.translation.name`, `moorl_magazine_article.creator.creatorType.translation.name` as `moorl_magazine_article.creator.creatorType.name`, `moorl_magazine_article.creator.creatorType.translation.description`, `moorl_magazine_article.creator.creatorType.translation.description` as `moorl_magazine_article.creator.creatorType.description`, `moorl_magazine_article.creator.creatorType.translation.teaser`, `moorl_magazine_article.creator.creatorType.translation.teaser` as `moorl_magazine_article.creator.creatorType.teaser`, `moorl_magazine_article.creator.creatorType.translation.imprint`, `moorl_magazine_article.creator.creatorType.translation.imprint` as `moorl_magazine_article.creator.creatorType.imprint`, `moorl_magazine_article.creator.avatar`.`id` as `moorl_magazine_article.creator.avatar.id`, `moorl_magazine_article.creator.avatar`.`user_id` as `moorl_magazine_article.creator.avatar.userId`, `moorl_magazine_article.creator.avatar`.`media_folder_id` as `moorl_magazine_article.creator.avatar.mediaFolderId`, `moorl_magazine_article.creator.avatar`.`mime_type` as `moorl_magazine_article.creator.avatar.mimeType`, `moorl_magazine_article.creator.avatar`.`file_extension` as `moorl_magazine_article.creator.avatar.fileExtension`, `moorl_magazine_article.creator.avatar`.`uploaded_at` as `moorl_magazine_article.creator.avatar.uploadedAt`, `moorl_magazine_article.creator.avatar`.`file_name` as `moorl_magazine_article.creator.avatar.fileName`, `moorl_magazine_article.creator.avatar`.`file_size` as `moorl_magazine_article.creator.avatar.fileSize`, `moorl_magazine_article.creator.avatar`.`media_type` as `moorl_magazine_article.creator.avatar.mediaTypeRaw`, `moorl_magazine_article.creator.avatar`.`meta_data` as `moorl_magazine_article.creator.avatar.metaData`, `moorl_magazine_article.creator.avatar`.`config` as `moorl_magazine_article.creator.avatar.config`, `moorl_magazine_article.creator.avatar`.`path` as `moorl_magazine_article.creator.avatar.path`, `moorl_magazine_article.creator.avatar`.`private` as `moorl_magazine_article.creator.avatar.private`, `moorl_magazine_article.creator.avatar`.`thumbnails_ro` as `moorl_magazine_article.creator.avatar.thumbnailsRo`, `moorl_magazine_article.creator.avatar`.`file_hash` as `moorl_magazine_article.creator.avatar.fileHash`, `moorl_magazine_article.creator.avatar`.`created_at` as `moorl_magazine_article.creator.avatar.createdAt`, `moorl_magazine_article.creator.avatar`.`updated_at` as `moorl_magazine_article.creator.avatar.updatedAt`, `moorl_magazine_article.creator.avatar.translation.title`, `moorl_magazine_article.creator.avatar.translation.title` as `moorl_magazine_article.creator.avatar.title`, `moorl_magazine_article.creator.avatar.translation.alt`, `moorl_magazine_article.creator.avatar.translation.alt` as `moorl_magazine_article.creator.avatar.alt`, `moorl_magazine_article.creator.avatar.translation.customFields`, `moorl_magazine_article.creator.avatar.translation.customFields` as `moorl_magazine_article.creator.avatar.customFields`, `moorl_magazine_article.creator.banner`.`id` as `moorl_magazine_article.creator.banner.id`, `moorl_magazine_article.creator.banner`.`user_id` as `moorl_magazine_article.creator.banner.userId`, `moorl_magazine_article.creator.banner`.`media_folder_id` as `moorl_magazine_article.creator.banner.mediaFolderId`, `moorl_magazine_article.creator.banner`.`mime_type` as `moorl_magazine_article.creator.banner.mimeType`, `moorl_magazine_article.creator.banner`.`file_extension` as `moorl_magazine_article.creator.banner.fileExtension`, `moorl_magazine_article.creator.banner`.`uploaded_at` as `moorl_magazine_article.creator.banner.uploadedAt`, `moorl_magazine_article.creator.banner`.`file_name` as `moorl_magazine_article.creator.banner.fileName`, `moorl_magazine_article.creator.banner`.`file_size` as `moorl_magazine_article.creator.banner.fileSize`, `moorl_magazine_article.creator.banner`.`media_type` as `moorl_magazine_article.creator.banner.mediaTypeRaw`, `moorl_magazine_article.creator.banner`.`meta_data` as `moorl_magazine_article.creator.banner.metaData`, `moorl_magazine_article.creator.banner`.`config` as `moorl_magazine_article.creator.banner.config`, `moorl_magazine_article.creator.banner`.`path` as `moorl_magazine_article.creator.banner.path`, `moorl_magazine_article.creator.banner`.`private` as `moorl_magazine_article.creator.banner.private`, `moorl_magazine_article.creator.banner`.`thumbnails_ro` as `moorl_magazine_article.creator.banner.thumbnailsRo`, `moorl_magazine_article.creator.banner`.`file_hash` as `moorl_magazine_article.creator.banner.fileHash`, `moorl_magazine_article.creator.banner`.`created_at` as `moorl_magazine_article.creator.banner.createdAt`, `moorl_magazine_article.creator.banner`.`updated_at` as `moorl_magazine_article.creator.banner.updatedAt`, `moorl_magazine_article.creator.banner.translation.title`, `moorl_magazine_article.creator.banner.translation.title` as `moorl_magazine_article.creator.banner.title`, `moorl_magazine_article.creator.banner.translation.alt`, `moorl_magazine_article.creator.banner.translation.alt` as `moorl_magazine_article.creator.banner.alt`, `moorl_magazine_article.creator.banner.translation.customFields`, `moorl_magazine_article.creator.banner.translation.customFields` as `moorl_magazine_article.creator.banner.customFields`, `moorl_magazine_article.creator`.`created_at` as `moorl_magazine_article.creator.createdAt`, `moorl_magazine_article.creator`.`updated_at` as `moorl_magazine_article.creator.updatedAt`, `moorl_magazine_article.creator.translation.name`, `moorl_magazine_article.creator.translation.name` as `moorl_magazine_article.creator.name`, `moorl_magazine_article.creator.translation.description`, `moorl_magazine_article.creator.translation.description` as `moorl_magazine_article.creator.description`, `moorl_magazine_article.creator.translation.teaser`, `moorl_magazine_article.creator.translation.teaser` as `moorl_magazine_article.creator.teaser`, `moorl_magazine_article.creator.translation.imprint`, `moorl_magazine_article.creator.translation.imprint` as `moorl_magazine_article.creator.imprint`, `moorl_magazine_article.creator.translation.metaTitle`, `moorl_magazine_article.creator.translation.metaTitle` as `moorl_magazine_article.creator.metaTitle`, `moorl_magazine_article.creator.translation.metaDescription`, `moorl_magazine_article.creator.translation.metaDescription` as `moorl_magazine_article.creator.metaDescription`, `moorl_magazine_article.creator.translation.keywords`, `moorl_magazine_article.creator.translation.keywords` as `moorl_magazine_article.creator.keywords`, `moorl_magazine_article.creator.translation.metaKeywords`, `moorl_magazine_article.creator.translation.metaKeywords` as `moorl_magazine_article.creator.metaKeywords`, `moorl_magazine_article.creator.translation.role`, `moorl_magazine_article.creator.translation.role` as `moorl_magazine_article.creator.role`, `moorl_magazine_article.creator.translation.slotConfig`, `moorl_magazine_article.creator.translation.slotConfig` as `moorl_magazine_article.creator.slotConfig`, `moorl_magazine_article`.`created_at` as `moorl_magazine_article.createdAt`, `moorl_magazine_article`.`updated_at` as `moorl_magazine_article.updatedAt`, (SELECT GROUP_CONCAT(HEX(`moorl_magazine_article.tags.mapping`.`tag_id`) SEPARATOR '||')
                  FROM `moorl_magazine_article_tag` `moorl_magazine_article.tags.mapping`
                  WHERE `moorl_magazine_article.tags.mapping`.`article_id` = `moorl_magazine_article`.`id` ) as `moorl_magazine_article.tags.id_mapping`, (SELECT GROUP_CONCAT(HEX(`moorl_magazine_article.categories.mapping`.`category_id`) SEPARATOR '||')
                  FROM `moorl_magazine_article_category` `moorl_magazine_article.categories.mapping`
                  WHERE `moorl_magazine_article.categories.mapping`.`article_id` = `moorl_magazine_article`.`id` ) as `moorl_magazine_article.categories.id_mapping`, (SELECT GROUP_CONCAT(HEX(`moorl_magazine_article.swCategories.mapping`.`category_id`) SEPARATOR '||')
                  FROM `moorl_magazine_article_sw_category` `moorl_magazine_article.swCategories.mapping`
                  WHERE `moorl_magazine_article.swCategories.mapping`.`article_id` = `moorl_magazine_article`.`id` ) as `moorl_magazine_article.swCategories.id_mapping`, (SELECT GROUP_CONCAT(HEX(`moorl_magazine_article.products.mapping`.`product_id`) SEPARATOR '||')
                  FROM `moorl_magazine_article_product` `moorl_magazine_article.products.mapping`
                  WHERE `moorl_magazine_article.products.mapping`.`article_id` = `moorl_magazine_article`.`id` ) as `moorl_magazine_article.products.id_mapping`, (SELECT GROUP_CONCAT(HEX(`moorl_magazine_article.medias.mapping`.`media_id`) SEPARATOR '||')
                  FROM `moorl_magazine_article_media` `moorl_magazine_article.medias.mapping`
                  WHERE `moorl_magazine_article.medias.mapping`.`article_id` = `moorl_magazine_article`.`id` ) as `moorl_magazine_article.medias.id_mapping`, `moorl_magazine_article.translation.title`, `moorl_magazine_article.translation.title` as `moorl_magazine_article.title`, `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation.name` as `moorl_magazine_article.name`, `moorl_magazine_article.translation.teaser`, `moorl_magazine_article.translation.teaser` as `moorl_magazine_article.teaser`, `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation.content` as `moorl_magazine_article.content`, `moorl_magazine_article.translation.metaTitle`, `moorl_magazine_article.translation.metaTitle` as `moorl_magazine_article.metaTitle`, `moorl_magazine_article.translation.metaDescription`, `moorl_magazine_article.translation.metaDescription` as `moorl_magazine_article.metaDescription`, `moorl_magazine_article.translation.seoUrl`, `moorl_magazine_article.translation.seoUrl` as `moorl_magazine_article.seoUrl`, `moorl_magazine_article.translation.slotConfig`, `moorl_magazine_article.translation.slotConfig` as `moorl_magazine_article.slotConfig` FROM `moorl_magazine_article` LEFT JOIN `media` `moorl_magazine_article.media` ON `moorl_magazine_article`.`media_id` = `moorl_magazine_article.media`.`id` LEFT JOIN `moorl_creator` `moorl_magazine_article.creator` ON `moorl_magazine_article`.`moorl_creator_id` = `moorl_magazine_article.creator`.`id` LEFT JOIN (SELECT `moorl_magazine_article.translation`.`moorl_magazine_article_id`, `moorl_magazine_article.translation`.`title` as `moorl_magazine_article.translation.title`, `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation`.`teaser` as `moorl_magazine_article.translation.teaser`, `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation`.`meta_title` as `moorl_magazine_article.translation.metaTitle`, `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription`, `moorl_magazine_article.translation`.`slot_config` as `moorl_magazine_article.translation.slotConfig`, `moorl_magazine_article.translation`.`seo_url` as `moorl_magazine_article.translation.seoUrl` FROM `moorl_magazine_article_translation` `moorl_magazine_article.translation` WHERE `moorl_magazine_article.translation`.`language_id` = ?) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id` LEFT JOIN (SELECT `moorl_magazine_article.media.translation`.`media_id`, `moorl_magazine_article.media.translation`.`alt` as `moorl_magazine_article.media.translation.alt`, `moorl_magazine_article.media.translation`.`title` as `moorl_magazine_article.media.translation.title`, `moorl_magazine_article.media.translation`.`custom_fields` as `moorl_magazine_article.media.translation.customFields` FROM `media_translation` `moorl_magazine_article.media.translation` WHERE `moorl_magazine_article.media.translation`.`language_id` = ?) `moorl_magazine_article.media.media_translation` ON `moorl_magazine_article.media.media_translation`.`media_id` = `moorl_magazine_article.media`.`id` LEFT JOIN `moorl_creator_type` `moorl_magazine_article.creator.creatorType` ON `moorl_magazine_article.creator`.`moorl_creator_type_id` = `moorl_magazine_article.creator.creatorType`.`id` LEFT JOIN `media` `moorl_magazine_article.creator.avatar` ON `moorl_magazine_article.creator`.`avatar_id` = `moorl_magazine_article.creator.avatar`.`id` LEFT JOIN `media` `moorl_magazine_article.creator.banner` ON `moorl_magazine_article.creator`.`banner_id` = `moorl_magazine_article.creator.banner`.`id` LEFT JOIN (SELECT `moorl_magazine_article.creator.translation`.`moorl_creator_id`, `moorl_magazine_article.creator.translation`.`teaser` as `moorl_magazine_article.creator.translation.teaser`, `moorl_magazine_article.creator.translation`.`imprint` as `moorl_magazine_article.creator.translation.imprint`, `moorl_magazine_article.creator.translation`.`keywords` as `moorl_magazine_article.creator.translation.keywords`, `moorl_magazine_article.creator.translation`.`description` as `moorl_magazine_article.creator.translation.description`, `moorl_magazine_article.creator.translation`.`name` as `moorl_magazine_article.creator.translation.name`, `moorl_magazine_article.creator.translation`.`role` as `moorl_magazine_article.creator.translation.role`, `moorl_magazine_article.creator.translation`.`meta_title` as `moorl_magazine_article.creator.translation.metaTitle`, `moorl_magazine_article.creator.translation`.`meta_description` as `moorl_magazine_article.creator.translation.metaDescription`, `moorl_magazine_article.creator.translation`.`meta_keywords` as `moorl_magazine_article.creator.translation.metaKeywords`, `moorl_magazine_article.creator.translation`.`slot_config` as `moorl_magazine_article.creator.translation.slotConfig` FROM `moorl_creator_translation` `moorl_magazine_article.creator.translation` WHERE `moorl_magazine_article.creator.translation`.`language_id` = ?) `moorl_magazine_article.creator.moorl_creator_translation` ON `moorl_magazine_article.creator.moorl_creator_translation`.`moorl_creator_id` = `moorl_magazine_article.creator`.`id` LEFT JOIN (SELECT `moorl_magazine_article.creator.creatorType.translation`.`moorl_creator_type_id`, `moorl_magazine_article.creator.creatorType.translation`.`teaser` as `moorl_magazine_article.creator.creatorType.translation.teaser`, `moorl_magazine_article.creator.creatorType.translation`.`imprint` as `moorl_magazine_article.creator.creatorType.translation.imprint`, `moorl_magazine_article.creator.creatorType.translation`.`description` as `moorl_magazine_article.creator.creatorType.translation.description`, `moorl_magazine_article.creator.creatorType.translation`.`name` as `moorl_magazine_article.creator.creatorType.translation.name` FROM `moorl_creator_type_translation` `moorl_magazine_article.creator.creatorType.translation` WHERE `moorl_magazine_article.creator.creatorType.translation`.`language_id` = ?) `moorl_magazine_article.creator.creatorType.moorl_creator_type_translation` ON `moorl_magazine_article.creator.creatorType.moorl_creator_type_translation`.`moorl_creator_type_id` = `moorl_magazine_article.creator.creatorType`.`id` LEFT JOIN (SELECT `moorl_magazine_article.creator.avatar.translation`.`media_id`, `moorl_magazine_article.creator.avatar.translation`.`alt` as `moorl_magazine_article.creator.avatar.translation.alt`, `moorl_magazine_article.creator.avatar.translation`.`title` as `moorl_magazine_article.creator.avatar.translation.title`, `moorl_magazine_article.creator.avatar.translation`.`custom_fields` as `moorl_magazine_article.creator.avatar.translation.customFields` FROM `media_translation` `moorl_magazine_article.creator.avatar.translation` WHERE `moorl_magazine_article.creator.avatar.translation`.`language_id` = ?) `moorl_magazine_article.creator.avatar.media_translation` ON `moorl_magazine_article.creator.avatar.media_translation`.`media_id` = `moorl_magazine_article.creator.avatar`.`id` LEFT JOIN (SELECT `moorl_magazine_article.creator.banner.translation`.`media_id`, `moorl_magazine_article.creator.banner.translation`.`alt` as `moorl_magazine_article.creator.banner.translation.alt`, `moorl_magazine_article.creator.banner.translation`.`title` as `moorl_magazine_article.creator.banner.translation.title`, `moorl_magazine_article.creator.banner.translation`.`custom_fields` as `moorl_magazine_article.creator.banner.translation.customFields` FROM `media_translation` `moorl_magazine_article.creator.banner.translation` WHERE `moorl_magazine_article.creator.banner.translation`.`language_id` = ?) `moorl_magazine_article.creator.banner.media_translation` ON `moorl_magazine_article.creator.banner.media_translation`.`media_id` = `moorl_magazine_article.creator.banner`.`id` WHERE `moorl_magazine_article`.`id` IN (?)