Symfony Profiler

# 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/d6cab68798654dccaa82d370ceffba01', '/fts/custom/contact', '/navigation/8cdc2eabbd08462badf21298702c943a', '/navigation/7ba1eb3b29ad4e5e8823fade26c3db38', '/navigation/34619ef1ee8c4bc79792c242df2a237c', '/navigation/4045b0be41f641528233e0ba46b37602', '/navigation/af47622d77da43aa9788c1f3426c0962', '/navigation/87c86b255c784be7b2eebacd4ca87422', '/navigation/356a4a2234f94af7b8ec77a57731335e', '/navigation/305cc59fcd2445438f6b263eb3c59613', '/navigation/f220574e2c5b49d3850303e3bb6842cb', '/navigation/12298808f73a4bf781a9dcc9b2800801', '/navigation/2e8eb18374c5436ea8d0f9f47b5da11f', '/navigation/30aab211ab074b36b4e15b1ac221f91e', '/navigation/55f4c2cab52c4d9a954d903f7a8c422f', '/navigation/eb27df81065f4f6fa3fc825e4a49bdd6', '/navigation/67b6e45172bc46a19d8354fe2258e02b', '/navigation/a1f86f0088c34e2583b589a5875bbede', '/navigation/01978381e7277fb994a5a5cd9a5929c9', '/navigation/776954a310ff45d489af875d6c5efbf7', '/navigation/18415f87ea1d4d208b8be53b0758bf39', '/navigation/018d8e94340b707f99daa31722fe6a42', '/navigation/018d8e9493a37811883bb2f2af9a795f', '/navigation/018d8e952983789391a718c7e416e037', '/navigation/018d8e95393e7d69aff89ef2e98f5c26', '/navigation/018d8e98abb575188e049edcf79c0e81', '/navigation/018d8e9e4e027a3c835f24ef8d080273', '/navigation/019193225fb5718bb0c45a705aa983d8', '/navigation/9eb36a5b9fce4b6bab4e59b104bebf1c', '/navigation/08004cee7d844a898aeb9667d53cdde4', '/navigation/9f9b08845b48418e9c9b3bd4fa5df252', '/navigation/0191dbcce05479f5a13508f74aea6698', '/navigation/0192233190be7a6d91e3b422c2677fe2', '/navigation/01922335966376bfaa36945d697a48ca', '/navigation/01922335c3257040a52316651e088afe', '/navigation/01922335f6597f3788383b0183c0f199', '/navigation/03dde8d20e974b1881911ac5c29fa0b5', '/navigation/8fc138334a99485fb3f2a655a661d9ce', '/navigation/fd158f9e1a754c27a4f00a2a248f1632', '/navigation/018f7b0ad7157803ab23c164f017477c', '/detail/fd1d83a6172f4cd3a7a86117a3687f85', '/navigation/e62ae19b9c5945db9d8280d4bcf29da6', '/navigation/1210d6547f3d48548df0e0b850d9d9cd', '/navigation/319cd30d30484cf0b5c3c4c260c6478a', '/navigation/0193b52f452573a4b5f64defa57b96b3', '/navigation/0193b52f8cb17cb9be635ed3e5951e85', '/navigation/d9ae4bbe91814454b741efdb1d9a798a', '/navigation/115df3a580c142ff84f0845399637532', '/navigation/16be299bef6b4058a3ef45165572eea2', '/navigation/d89b20ca7e584e42904d97042b037df2', '/navigation/971ca86ad60d4149991792ae440a2c78', '/navigation/f3710866aeb740e1b2f2d224cb96751f', '/navigation/0193b9c0cb5c7a8f87d1dfd97ada039b', '/navigation/0198ea8f7d88726c9946b40417a764c9', '/navigation/312289b38a494dd182913c1eb5e0bc65', '/navigation/295cb4cc904648af8e623a37949d6053', '/navigation/a061e2742d524966a5cc36e365ec8da0', '/navigation/7dcaba9203c9435c812b63824a3ba14f', '/navigation/b4154230393c4c638ba1a62727cf27e1', '/navigation/82bb910d94064f30835256de422af480', '/navigation/faf3b5df2c8a409985efde4d3afa9c93', '/navigation/164c10c32cb1450dbb8828d477a58036', '/navigation/f4cb1de3c3dc41e7901a34623f0aa09f', '/navigation/953e43f391744d899b07c16bb6a60b37', '/navigation/f387061892b04d04bdf38c30bb4a9894', '/navigation/19b76b26ada34a29bba967b9a10943bd', '/navigation/685cf0aa104740fc8ff09754472d4913', '/navigation/dd423f04067c42059fc90c7bd91c59f6', '/navigation/9d51fae00121475fb1b53119cca9cb6c', '/navigation/9971779ae7554daeb8a0dc05020c2172', '/navigation/5cab358463a44af0aa72884825ae503b', '/navigation/b5ca2018d1804d08bbed846f04315251', '/navigation/97205f7d3c9f4be28e4a3661b52e5f4b', '/navigation/a94adb25797442b4bde65548c68d1ad2', '/navigation/2f8594ca109b4400bb35eb0d411a0a53', '/navigation/92ea3f04f5c84f7994f7fa88514cfa92', '/navigation/009f131b1e6341e29d97811901c473b2', '/navigation/5e94578e230e40978dde294163fbef5a', '/navigation/a4848581fcec4627891c4deb855f6fc3', '/navigation/e7b99030fe7f4e87a5acea3081ff585f', '/navigation/ce12a82e03be4f2d9d042748404163c5', '/navigation/66983bdc2764477ca97fc114c7e7ad3b', '/navigation/7e727fe4035e46799ea6fb1a54e1a092', '/navigation/28ef82db85ec40baa6303c59f41b9c68', '/navigation/0e3ddd394dd04ec595ac094344ccd7d2', '/navigation/f63b21d7d6ef410c887a0a9e6dd5f5da', '/navigation/a371ccf24e0047b7aa0085f7b0ea25b3', '/navigation/7b61f1c673a14ba7a90ea1aed2f7a74a', '/navigation/595fcd5230814ea798f248355142594b', '/navigation/bb648acf4e8e4bf5a5b8280bfc3b0a2c', '/navigation/05585e73905540a0af4b1ad598c5bdbb', '/navigation/c6f880e9e2d14daab2ba44d17d5a7754', '/navigation/5fbef7274294466aa73256ffce2a6e91', '/navigation/444c734fa6a74eeba12ab6797622fdb1', '/navigation/280c957e01e2420a9f85035fd69e2e13', '/navigation/d684062ece3d46efb7196c42b674c95e', '/navigation/a44b5990cf64411ca34b0186f52ee657', '/navigation/9675ab4dc11e4c5cbe95870969e0cc99', '/navigation/191cb88879ab45f7836f97a265fd57e9', '/navigation/d09866acc90a41ba9bc348ee4dd6d911', '/navigation/22fa0ebd60ab44f09ea7ca3144a0ee0a', '/navigation/7b8a1ea5295a422ab3f8d6f24c016bdc', '/navigation/6305e4f1cea343b087ce6819605d1303', '/navigation/dc01851063b2485583b195a3d7bddae4', '/navigation/50a4bae93ecb4fc583302e2666335d8c', '/navigation/6c3bec26bea246d3916ff995407378af', '/navigation/607e1b0ab492430f8a559c141280158b', '/navigation/018bd2c0f7fa794f91aac1e1a94beb89', '/navigation/018bd2c1590d7cd1b59a3e801661f816', '/navigation/018bd2c1723072afbf126ce7628050ba', '/navigation/f6252de8549c43b08b7fc500c89b9914', '/navigation/50b542094a394c798ee5d877fe61c41e', '/navigation/0baa38c25e7f412d87c04b058b8e9c5a', '/navigation/b1f11c5abdfd44b7a3963429f7ed0224', '/navigation/4052cdd1bced42cd9beb95f09bdd7350', '/navigation/54437c301b104b01ad357db0026e3b04', '/navigation/4c3f6712bbe94e8e86f532c4fb3e4cf8', '/navigation/829235db887e48adb5704af79c23b1d2', '/navigation/6dc4cdf1015847a28e7d7f35ba355ad2', '/navigation/3143dda10e884e9ea481613de9ab8dda', '/navigation/8b9e6c569ab644869fcc023e4c37a79a', '/navigation/262b5533ca414017b6d473f85e4d8fe5', '/navigation/55ae85fce7fc4d0f811e8aea1dc24fa6', '/navigation/5c5a0f366c0d4960bbfc24e17290575b', '/navigation/7cb1b78c070742d3ae56a32550cc13c5', '/navigation/912b2f98b79e4720b4051d578e66c160', '/navigation/9fed2c466f5d47d0b1b3f50974568aa1', '/navigation/07b74f649f014fcc865f5bffb4295233', '/navigation/47e1b3a06fd54c6b85a2353e2bf052e9', '/navigation/1c8bddb8ff4e4483a4a5f5b333a9774d', '/navigation/5c04199fdafd4035bfc5120383dddf5e', '/navigation/7caa63505eb444909c170c9218ea9e4d', '/navigation/de8f95b647b3483086801de0e92962c5', '/navigation/8de66ff0056747a1bfc7347b9dd98289', '/navigation/f965f0416c7f496d926c773a750d9d5b', '/navigation/a26d165506f84653aa8ea0a884d0e244', '/navigation/dea66e1c1ad94acebb238450e0db91b4', '/navigation/ca5dd92a87dc4621ace5b7aafe26d4cf', '/navigation/82ae99d370dd40db9229cea17554f175', '/navigation/966242f552464b86b7fd1928ef2a1d2b', '/navigation/708449bf55f247608e2d88e9ba4a75ec', '/navigation/36e7b3f877ae46709dd82ccf281733ea', '/navigation/10441f1a5362408d8b8eb7eddbad88cc', '/navigation/29ed1a88ffeb49eab1b221ebcc52a07a', '/navigation/c7d99c58f3b24afb905cc5917bfd2a6b', '/navigation/6ada88a2f05248da970dcdbdc070acf1', '/navigation/74ff5ca91baf46e097d2b3bafc0532e4', '/navigation/c9b47a50102d41ef9798daf089cc7895', '/navigation/f6a6f4dc492744138c5344e94cba78a9', '/navigation/3b5655fe20754e768182c579c78156f3', '/navigation/d37ff5b062464bf8ac9f7f5c9e68d24e', '/navigation/f0675875a5574663bde0a05dea96c0fd', '/navigation/b4e0b873a1184f88ab1cb90b4ada3d9b', '/navigation/8229cb9d505a4457aae27299a3d35a04', '/navigation/99d686ad568748818331067ef62d2b83', '/navigation/8d8eb2e572524a558b748cfc9ed45736', '/navigation/8aad128fa498410e9eb2b41084f5e3b0', '/navigation/cf0010f086ae4b3f9001a692dea8cc96', '/navigation/0ea836d087d04681ac4e49e08a703484', '/navigation/76eb88fbe63e45bda772c2001fbd52f3', '/navigation/9157c3e6373c47e7bb092c5436e78b91', '/navigation/1787b3d0e51d4ae5bf94bd3f59483703', '/navigation/0b2341a30a2f4bdaaa4f627d7922b551', '/navigation/e8457c8beac747a48901db895675b052', '/navigation/f212ea012b3d47f4a9568a0d81e7b124', '/navigation/867bc7067f9c48609e1374ad1b0fb72d', '/navigation/1c4f199b208a4990b96e2b90f13b4a29', '/navigation/e93bab12d62b4d11912f4de29694e6b9', '/navigation/0aaab16423fd4419adccee8ba0d329b6', '/navigation/67517a96fec247fbab2c37f9c764aa72', '/navigation/6b8949a4d8b04664b4099b198dea4057', '/navigation/6624e730057c46eebff1b29d5e7b208b', '/navigation/75fb04ebb5f1476f9b75a62fc31a8810', '/navigation/8b9afc42afc8456daa8ed2ce0b7bc0e0', '/navigation/f044295423064b588557822dfc9e2b40', '/navigation/bf2eb5a89e2b433080ff6cb9e3afe21a', '/navigation/94c25309ed324a5fba5ca500b7ff1871', '/navigation/273a0a024d76403d85a656753cb2e316', '/navigation/6cfa07ac9db441829663aa7cdeff24df', '/navigation/680fe1e2de634b0cbdc55f28ca1c90f0', '/navigation/44204952f48647b891c44b8a4476b600', '/navigation/92ca829f532f43b98f422d16b1a61fe9', '/navigation/cbbb14c819094376b33f3700d8787ff7', '/navigation/26b15bb504984bc2832f14340e5adeab', '/navigation/a083351f24c14c9196edae83290f4ee4', '/navigation/84b659f1ddaa491c9cd7768d44d0e596', '/navigation/184695505b9b47a0b883153457491a15', '/navigation/9b8e4f834b9a49cda9cbb3d54df4a27d', '/navigation/fd1c0181ed444be6a5899e6e8fb89318', '/navigation/8b6e9888767a4600bf90b1969d90f9c8', '/navigation/57c0fef4d8344b84a861b7722e1b7f2d', '/navigation/d45017ad6825440c8600dc3c354d937c', '/navigation/8e600cbfb4ea4ed3b70f2092fd02feb4', '/navigation/5b77ff6906974496a883bed325489643', '/navigation/94ceb675a5bc41febf89eac3fe1efd41', '/navigation/620a998ccd3946c6b28692506fd33090', '/navigation/74011241b25e4dc78ceba42dc45a4585', '/navigation/4811bfc2905d4eb980b8d78a12b1236b', '/navigation/6d516f61c43747fd80271cef8b5a53c3', '/navigation/879b25e5976d49c783fedad46c55b5f6', '/navigation/2d0f961724a8428f970bea7c22193840', '/navigation/aac9696231274574ace3731d0fb4e2c5', '/navigation/55f5e05bf8f846a7ad4f101f18e062dd', '/navigation/cc11fe134e7d416f935bd42f67cd8dad', '/navigation/180fa5af3a3047439ce26b27787ea802', '/navigation/6a0f9395cb6e4db0890dfcecd077aa28', '/navigation/4950000bfa6f4eb78264948c493dadad', '/navigation/ff26c879706241e8b79d126177a806bc', '/navigation/19f788f18d0c4b26a3e6c44447742268', '/navigation/d1fca8434c574c84a8eca1bd5499c0b4', '/navigation/eedcd158535945feaa58530cec30eb74', '/navigation/f23aa005048c4f2fb04b8049f95d0a2f', '/navigation/270ad170e0c649c088ea9fdd47517b73', '/navigation/9934ffab7ddf419892eaee684bd79db2', '/navigation/435e789f5fa14f5a828e390d940d4cdc', '/navigation/6eeb1ca80e81408a8352a6736b8d9644', '/navigation/c8395573ac2746af96628501a2d992fb', '/navigation/2ccac8094565431eba1be7ed03474df7', '/navigation/550710dc11cd484dac1e3022fedb2bb1', '/navigation/bbede76e2cd84eb3b71ab3fecf541b30', '/navigation/67d11069a7b647ab850dc2df1740b465', '/navigation/507aca5995ba481bb6064b2a73eb2347', '/navigation/1e12fa6953494abdac33bdaf17df3ec1', '/navigation/44ab10a7a3564485a157262ea3449628', '/navigation/848397c0293346a880e1f19894014cef', '/navigation/f66e543c866141cca9b25dd0c628c530', '/navigation/a677bb7a5c474a5987dee720243fee6c', '/navigation/f8ace26c53fa44399553504678153c57', '/navigation/992ffe2fa19f48ecad7ca39f019ba4ee', '/navigation/27f9e3ecf3b642e5afe0bc2c87a81d21', '/navigation/dbd66438ee7a40a185238ab0daca3f5a', '/navigation/4422476b7c044566b18f4d74a0ba8a19', '/navigation/3747392b096146cda8b51f7f3d8b696c', '/navigation/473650f3a87141ec968c76d206ec6720', '/navigation/9cc528dd13044c73b38b3de72895327d', '/navigation/bfa4a924608443ec879892e253981c0f', '/navigation/3fe8d87d7c9340d1be9488f7e8c04bec', '/navigation/0133ab6b6d8a4f91b3c4b5faab1acc44', '/navigation/f0b3d4ed189549a7becc138b8c682ff2', '/navigation/e0f6d2af3aef434c922c66d7d417e1ab', '/navigation/4bade8c991134c7da07079637ceb1fb1', '/navigation/5ddc82e0eced475789b4b05c9ac9818f', '/navigation/2772cb2179464fab86da46ec935d4f01', '/navigation/c8392dd455d84250bc23b4a5eb905294', '/navigation/d1502a04ad8e419781dad85b75d07489', '/navigation/f27925bbeaa747c9ab0f5bc5613f498f', '/navigation/18208cba390942fd83f4f97775331d2b', '/navigation/1ef6c9ca962e48fa9b4ef046f6f0dd80', '/navigation/150e47e96fab4360b0e1d893a9e1143a', '/navigation/6fd26fab461943fbbd3dd5de8636ea27', '/navigation/c17f5c727cea45e48efac1f1f2997af1', '/navigation/c2eea0c043e245578c8e9af2a61d9340', '/navigation/6a25d70919b84917af14a0fc3db203a6', '/navigation/1d9d9e997868485ba8e477a6efbe0ed8', '/navigation/e021782b295b400a825a84171e8978f3', '/navigation/8d87106f1d1148c1b20fbff6d0c16b0c', '/navigation/c7dfde28be394b10a42b00d994b1c3e8', '/navigation/0effffe90dbb43cca0882b38f4cd34d4', '/navigation/6ade75048fbe4070ad61b1e3ccefc64f', '/navigation/ea0e8cad2e3243b2a1a05a732746cf9b', '/navigation/49bb98f4ba2647bd8cfd0c1ae3929bfd', '/navigation/a765cdd72e504c02abc435cd621c4840', '/navigation/b098544f31754c1e8ec3cc12d84b1c86', '/navigation/086a971721604786a5d6d6adfef9a3bb', '/navigation/b1c52b92d1be4fa3b3b3dea1888ad06f', '/navigation/c92f069a9bfe4a159d120332cb4190a0', '/navigation/6d0c4a26839547e285f06363fc10a083', '/navigation/0a882bfed0ba41ea95e44a7888d0673a', '/navigation/f8b730a9c87d4fffafd6650fe19f99d6', '/navigation/6d8a195e6d424ebdb0e28b881de80df9', '/navigation/93e9218d9765485bbffa88a7db23ba3b', '/navigation/8a76af42fab14baf8e7c4f3205827aa6', '/navigation/ac36a0ed39264cfba083ce6327c64e78', '/navigation/7bb32d96815f4c95843610f750d8dca3', '/navigation/addb5df280c9403fbf100fab0506e14a', '/navigation/d33094af03014467b5e7d00c552fd8d3', '/navigation/fc7b174e443c43c69bff5769866c2024', '/navigation/0492f884d2bd44e596aa863a321f20ef', '/navigation/68a75f4693234fdfa052f9b8e597ab05', '/navigation/75464f569bf941f78cbd4ff77141a775', '/navigation/674f8c4bb48c4c07a7be360d8e79d868', '/navigation/f48e1485f40b4da9a2b680b82ff82a4e', '/navigation/e15d575a61f04da0a763a70396276d6d', '/navigation/fc2efa24253d402ea0b9077b143a5f82', '/navigation/c468ae406dae4b01a0ed66b1adf4be04', '/navigation/b8f70b7f2a2f4ac0bbc33efad76422f9', '/navigation/e3e41be79bf0469181ba2d9488088d49', '/navigation/fd344e037fdb44469a58beef8a60e630', '/navigation/248dd1c6f03a4f33bcb54e98d2433bee', '/navigation/9040ffa507fc4f19ad106d6db1d1b12d', '/navigation/504e539c257442078e06ef06620d8ee3', '/navigation/22a84d52667f4ce18eb3a7a28a4de2e8', '/navigation/dbeb846c8e1c4b6cbfd70c1e97bf5dd7', '/navigation/12a8946351eb45e297dc8632f917643b', '/navigation/bc9ac1d2a19e49e78343257be8022c5d', '/navigation/490f66f73ead45b2b7795e4095a72f15', '/navigation/1e28423ec8cd4430aa57922cb892099f', '/navigation/072d30fa03bf4fafb86ab8baac52464c', '/navigation/e8de267d0e234c998d13e7113ddcafce', '/navigation/4f325ac5501a40fa98f239034ed2f949', '/navigation/b9b451997c214440a0c2fdde63492331', '/navigation/c2ae32cf01d64b04a20f1145ab12aea3', '/navigation/f8f116095d9a48c7a95dc79c7ab3ab55', '/navigation/e797b77047e84d24a2e01bb471812b90', '/navigation/9dbff7a478c44a729b2cbaa49a50d111', '/navigation/24fed206bada4696b795a96eb1c95868', '/navigation/b727e4fc4b5446f89e7e07c98b75542f', '/navigation/1ad9fe6a78ec44e694cb0dbca41cfec0', '/navigation/07510e0dbe304cc78f2c460e0c9ba4a1', '/navigation/caa76ca8d1864f599af952cb3a447b2d', '/navigation/8995bd061b454b41925050dba71b8ad0', '/navigation/48e394041ae74a198b84cce4bfd6aa66', '/navigation/4ae136f224f14a50bb3a91f70f262e8a', '/navigation/18e5d0372de74ee59757aedc38a10a58', '/navigation/3e4825fe00bd4abea5038df97740838d', '/navigation/0dd85b07411d49ffbf50b4a25a82ab9b', '/navigation/af8fe4d82f5b4c00a9ddcaca5504f136', '/navigation/2919e4964b10408a991a6393c525d8b8', '/widgets/cms/019025e45ec87fecaebb578be17609e6?pname=1.8T,%20R32,%20TFSI%20%26%20TDI%20Zentralausr%C3%BCcklager%20Sachs%20Race&pnumber=2118t294', '/detail/9fd7933ce8564e87aba5beb9c67d4d4c', '/detail/46cdb1af49be41f8809ee3258e740f1e', '/detail/153c5b5f2e6540a1a9fb358043766a22', '/detail/be8d7daaf952489295b886749c35fea5', '/navigation/f3a4aa3fb9e94e5f9612a9715f99e445', '/navigation/ab5bddb81bd94d14953cdb3666d8ebfb', '/navigation/9467ca7dcb324379b3fc7c6ce80806a1', '/navigation/fd249b8a30a349339fbcf40cfd70ef4c', '/navigation/79d3ab79ec1b4fccbdf2a2f1640bb2ab', '/navigation/ef7e7a2f1fa14939b10ad659d28c9e95', '/navigation/dfda4b9c87a447a4a2e281d7652915c8', '/navigation/018e74b8a7d07acbbbbe1c087e9a89db', '/navigation/74a903f5cef6411eba74d1f82f545f7c', '/navigation/0194a7df4c4a7294807ff19f428476f4')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

SELECT
  `product`.`id` as `product.id`,
  `product`.`version_id` as `product.versionId`,
  `product`.`parent_id` as `product.parentId`,
  `product`.`parent_version_id` as `product.parentVersionId`,
  COALESCE(
    `product`.`product_manufacturer_id`,
    `product.parent`.`product_manufacturer_id`
  ) as `product.manufacturerId`,
  COALESCE(
    `product`.`product_manufacturer_version_id`,
    `product.parent`.`product_manufacturer_version_id`
  ) as `product.productManufacturerVersionId`,
  COALESCE(
    `product`.`unit_id`, `product.parent`.`unit_id`
  ) as `product.unitId`,
  COALESCE(
    `product`.`tax_id`, `product.parent`.`tax_id`
  ) as `product.taxId`,
  COALESCE(
    `product`.`product_media_id`, `product.parent`.`product_media_id`
  ) as `product.coverId`,
  COALESCE(
    `product`.`product_media_version_id`,
    `product.parent`.`product_media_version_id`
  ) as `product.productMediaVersionId`,
  COALESCE(
    `product`.`delivery_time_id`, `product.parent`.`delivery_time_id`
  ) as `product.deliveryTimeId`,
  COALESCE(
    `product`.`product_feature_set_id`,
    `product.parent`.`product_feature_set_id`
  ) as `product.featureSetId`,
  COALESCE(
    `product`.`canonical_product_id`,
    `product.parent`.`canonical_product_id`
  ) as `product.canonicalProductId`,
  COALESCE(
    `product`.`canonical_product_version_id`,
    `product.parent`.`canonical_product_version_id`
  ) as `product.canonicalProductVersionId`,
  COALESCE(
    `product`.`cms_page_id`, `product.parent`.`cms_page_id`
  ) as `product.cmsPageId`,
  COALESCE(
    `product`.`cms_page_version_id`,
    `product.parent`.`cms_page_version_id`
  ) as `product.cmsPageVersionId`,
  `product.parent`.`price` as `product.price.inherited`,
  COALESCE(
    `product`.`price`, `product.parent`.`price`
  ) as `product.price`,
  `product`.`product_number` as `product.productNumber`,
  COALESCE(
    `product`.`restock_time`, `product.parent`.`restock_time`
  ) as `product.restockTime`,
  `product`.`auto_increment` as `product.autoIncrement`,
  COALESCE(
    `product`.`active`, `product.parent`.`active`
  ) as `product.active`,
  `product`.`available` as `product.available`,
  COALESCE(
    `product`.`is_closeout`, `product.parent`.`is_closeout`
  ) as `product.isCloseout`,
  `product`.`available_stock` as `product.availableStock`,
  `product`.`stock` as `product.stock`,
  `product`.`display_group` as `product.displayGroup`,
  `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`,
  COALESCE(
    `product`.`variant_listing_config`,
    `product.parent`.`variant_listing_config`
  ) as `product.variantListingConfig`,
  `product`.`variant_restrictions` as `product.variantRestrictions`,
  COALESCE(
    `product`.`manufacturer_number`,
    `product.parent`.`manufacturer_number`
  ) as `product.manufacturerNumber`,
  COALESCE(
    `product`.`ean`, `product.parent`.`ean`
  ) as `product.ean`,
  COALESCE(
    `product`.`purchase_steps`, `product.parent`.`purchase_steps`
  ) as `product.purchaseSteps`,
  COALESCE(
    `product`.`max_purchase`, `product.parent`.`max_purchase`
  ) as `product.maxPurchase`,
  COALESCE(
    `product`.`min_purchase`, `product.parent`.`min_purchase`
  ) as `product.minPurchase`,
  COALESCE(
    `product`.`purchase_unit`, `product.parent`.`purchase_unit`
  ) as `product.purchaseUnit`,
  COALESCE(
    `product`.`reference_unit`, `product.parent`.`reference_unit`
  ) as `product.referenceUnit`,
  COALESCE(
    `product`.`shipping_free`, `product.parent`.`shipping_free`
  ) as `product.shippingFree`,
  `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`,
  COALESCE(
    `product`.`purchase_prices`, `product.parent`.`purchase_prices`
  ) as `product.purchasePrices`,
  COALESCE(
    `product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`
  ) as `product.markAsTopseller`,
  COALESCE(
    `product`.`weight`, `product.parent`.`weight`
  ) as `product.weight`,
  COALESCE(
    `product`.`width`, `product.parent`.`width`
  ) as `product.width`,
  COALESCE(
    `product`.`height`, `product.parent`.`height`
  ) as `product.height`,
  COALESCE(
    `product`.`length`, `product.parent`.`length`
  ) as `product.length`,
  COALESCE(
    `product`.`release_date`, `product.parent`.`release_date`
  ) as `product.releaseDate`,
  COALESCE(
    `product`.`rating_average`, `product.parent`.`rating_average`
  ) as `product.ratingAverage`,
  `product.parent`.`category_tree` as `product.categoryTree.inherited`,
  COALESCE(
    `product`.`category_tree`, `product.parent`.`category_tree`
  ) as `product.categoryTree`,
  `product.parent`.`property_ids` as `product.propertyIds.inherited`,
  COALESCE(
    `product`.`property_ids`, `product.parent`.`property_ids`
  ) as `product.propertyIds`,
  `product.parent`.`option_ids` as `product.optionIds.inherited`,
  COALESCE(
    `product`.`option_ids`, `product.parent`.`option_ids`
  ) as `product.optionIds`,
  `product.parent`.`stream_ids` as `product.streamIds.inherited`,
  COALESCE(
    `product`.`stream_ids`, `product.parent`.`stream_ids`
  ) as `product.streamIds`,
  `product.parent`.`tag_ids` as `product.tagIds.inherited`,
  COALESCE(
    `product`.`tag_ids`, `product.parent`.`tag_ids`
  ) as `product.tagIds`,
  `product.parent`.`category_ids` as `product.categoryIds.inherited`,
  COALESCE(
    `product`.`category_ids`, `product.parent`.`category_ids`
  ) as `product.categoryIds`,
  `product`.`child_count` as `product.childCount`,
  COALESCE(
    `product`.`custom_field_set_selection_active`,
    `product.parent`.`custom_field_set_selection_active`
  ) as `product.customFieldSetSelectionActive`,
  `product`.`sales` as `product.sales`,
  `product`.`states` as `product.states`,
  `product.tax`.`id` as `product.tax.id`,
  `product.tax`.`tax_rate` as `product.tax.taxRate`,
  `product.tax`.`name` as `product.tax.name`,
  `product.tax`.`position` as `product.tax.position`,
  `product.tax`.`custom_fields` as `product.tax.customFields`,
  `product.tax`.`created_at` as `product.tax.createdAt`,
  `product.tax`.`updated_at` as `product.tax.updatedAt`,
  `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`,
  COALESCE(
    `product`.`cheapest_price`, `product.parent`.`cheapest_price`
  ) as `product.cheapestPrice`,
  `product`.`created_at` as `product.createdAt`,
  `product`.`updated_at` as `product.updatedAt`,
  `product.internalNotes`.`id` as `product.internalNotes.id`,
  `product.internalNotes`.`parent_id` as `product.internalNotes.parentId`,
  `product.internalNotes`.`product_id` as `product.internalNotes.productId`,
  `product.internalNotes`.`note` as `product.internalNotes.note`,
  `product.internalNotes`.`chief_note` as `product.internalNotes.chiefNote`,
  `product.internalNotes`.`product_version_id` as `product.internalNotes.productVersionId`,
  `product.internalNotes`.`created_at` as `product.internalNotes.createdAt`,
  `product.internalNotes`.`updated_at` as `product.internalNotes.updatedAt`,
  `product.productAvailability`.`id` as `product.productAvailability.id`,
  `product.productAvailability`.`product_id` as `product.productAvailability.productId`,
  `product.productAvailability`.`notify` as `product.productAvailability.notify`,
  `product.productAvailability`.`availability_technical_name` as `product.productAvailability.availabilityTechnicalName`,
  `product.productAvailability`.`product_version_id` as `product.productAvailability.productVersionId`,
  `product.productAvailability`.`created_at` as `product.productAvailability.createdAt`,
  `product.productAvailability`.`updated_at` as `product.productAvailability.updatedAt`,
  `product.cover`.`id` as `product.cover.id`,
  `product.cover`.`version_id` as `product.cover.versionId`,
  `product.cover`.`product_id` as `product.cover.productId`,
  `product.cover`.`product_version_id` as `product.cover.productVersionId`,
  `product.cover`.`media_id` as `product.cover.mediaId`,
  `product.cover`.`position` as `product.cover.position`,
  `product.cover.media`.`id` as `product.cover.media.id`,
  `product.cover.media`.`user_id` as `product.cover.media.userId`,
  `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`,
  `product.cover.media`.`mime_type` as `product.cover.media.mimeType`,
  `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`,
  `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`,
  `product.cover.media`.`file_name` as `product.cover.media.fileName`,
  `product.cover.media`.`file_size` as `product.cover.media.fileSize`,
  `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`,
  `product.cover.media`.`meta_data` as `product.cover.media.metaData`,
  `product.cover.media`.`config` as `product.cover.media.config`,
  `product.cover.media`.`path` as `product.cover.media.path`,
  `product.cover.media`.`private` as `product.cover.media.private`,
  `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`,
  `product.cover.media`.`created_at` as `product.cover.media.createdAt`,
  `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`,
  `product.cover.media.translation.title`,
  `product.cover.media.translation.title` as `product.cover.media.title`,
  `product.cover.media.translation.alt`,
  `product.cover.media.translation.alt` as `product.cover.media.alt`,
  `product.cover.media.translation.customFields`,
  `product.cover.media.translation.customFields` as `product.cover.media.customFields`,
  `product.cover`.`custom_fields` as `product.cover.customFields`,
  `product.cover`.`created_at` as `product.cover.createdAt`,
  `product.cover`.`updated_at` as `product.cover.updatedAt`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(
          `product.options.mapping`.`property_group_option_id`
        ) SEPARATOR '||'
      )
    FROM
      `product_option` `product.options.mapping`
    WHERE
      `product.options.mapping`.`product_id` = `product`.`id`
  ) as `product.options.id_mapping`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(
          `product.properties.mapping`.`property_group_option_id`
        ) SEPARATOR '||'
      )
    FROM
      `product_property` `product.properties.mapping`
    WHERE
      `product.properties.mapping`.`product_id` = `product`.`properties`
  ) as `product.properties.id_mapping`,
  `product.manufacturer`.`id` as `product.manufacturer.id`,
  `product.manufacturer`.`version_id` as `product.manufacturer.versionId`,
  `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`,
  `product.manufacturer`.`link` as `product.manufacturer.link`,
  `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`,
  `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`,
  `product.manufacturer.media`.`id` as `product.manufacturer.media.id`,
  `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`,
  `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`,
  `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`,
  `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`,
  `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`,
  `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`,
  `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`,
  `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`,
  `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`,
  `product.manufacturer.media`.`config` as `product.manufacturer.media.config`,
  `product.manufacturer.media`.`path` as `product.manufacturer.media.path`,
  `product.manufacturer.media`.`private` as `product.manufacturer.media.private`,
  `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`,
  `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`,
  `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`,
  `product.manufacturer.media.translation.title`,
  `product.manufacturer.media.translation.title` as `product.manufacturer.media.title`,
  `product.manufacturer.media.translation.alt`,
  `product.manufacturer.media.translation.alt` as `product.manufacturer.media.alt`,
  `product.manufacturer.media.translation.customFields`,
  `product.manufacturer.media.translation.customFields` as `product.manufacturer.media.customFields`,
  `product.manufacturer.translation.name`,
  `product.manufacturer.translation.name` as `product.manufacturer.name`,
  `product.manufacturer.translation.description`,
  `product.manufacturer.translation.description` as `product.manufacturer.description`,
  `product.manufacturer.translation.customFields`,
  `product.manufacturer.translation.customFields` as `product.manufacturer.customFields`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(
          `product.categoriesRo.mapping`.`category_id`
        ) SEPARATOR '||'
      )
    FROM
      `product_category_tree` `product.categoriesRo.mapping`
    WHERE
      `product.categoriesRo.mapping`.`product_id` = `product`.`id`
      AND `product.categoriesRo.mapping`.product_version_id = `product`.version_id
  ) as `product.categoriesRo.id_mapping`,
  `product.unit`.`id` as `product.unit.id`,
  `product.unit`.`created_at` as `product.unit.createdAt`,
  `product.unit`.`updated_at` as `product.unit.updatedAt`,
  `product.unit.translation.shortCode`,
  `product.unit.translation.shortCode` as `product.unit.shortCode`,
  `product.unit.translation.name`,
  `product.unit.translation.name` as `product.unit.name`,
  `product.unit.translation.customFields`,
  `product.unit.translation.customFields` as `product.unit.customFields`,
  `product.deliveryTime`.`id` as `product.deliveryTime.id`,
  `product.deliveryTime`.`min` as `product.deliveryTime.min`,
  `product.deliveryTime`.`max` as `product.deliveryTime.max`,
  `product.deliveryTime`.`unit` as `product.deliveryTime.unit`,
  `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`,
  `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`,
  `product.deliveryTime.translation.name`,
  `product.deliveryTime.translation.name` as `product.deliveryTime.name`,
  `product.deliveryTime.translation.customFields`,
  `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`,
  `product.translation.metaDescription`,
  `product.parent.translation.metaDescription`,
  COALESCE(
    `product.translation.metaDescription`,
    `product.parent.translation.metaDescription`
  ) as `product.metaDescription`,
  `product.translation.name`,
  `product.parent.translation.name`,
  COALESCE(
    `product.translation.name`, `product.parent.translation.name`
  ) as `product.name`,
  `product.translation.keywords`,
  `product.parent.translation.keywords`,
  COALESCE(
    `product.translation.keywords`,
    `product.parent.translation.keywords`
  ) as `product.keywords`,
  `product.translation.description`,
  `product.parent.translation.description`,
  COALESCE(
    `product.translation.description`,
    `product.parent.translation.description`
  ) as `product.description`,
  `product.translation.metaTitle`,
  `product.parent.translation.metaTitle`,
  COALESCE(
    `product.translation.metaTitle`,
    `product.parent.translation.metaTitle`
  ) as `product.metaTitle`,
  `product.translation.packUnit`,
  `product.parent.translation.packUnit`,
  COALESCE(
    `product.translation.packUnit`,
    `product.parent.translation.packUnit`
  ) as `product.packUnit`,
  `product.translation.packUnitPlural`,
  `product.parent.translation.packUnitPlural`,
  COALESCE(
    `product.translation.packUnitPlural`,
    `product.parent.translation.packUnitPlural`
  ) as `product.packUnitPlural`,
  `product.translation.customSearchKeywords`,
  `product.parent.translation.customSearchKeywords`,
  COALESCE(
    `product.translation.customSearchKeywords`,
    `product.parent.translation.customSearchKeywords`
  ) as `product.customSearchKeywords`,
  `product.translation.slotConfig`,
  `product.parent.translation.slotConfig`,
  COALESCE(
    `product.translation.slotConfig`,
    `product.parent.translation.slotConfig`
  ) as `product.slotConfig`,
  `product.translation.customFields`,
  `product.parent.translation.customFields`,
  COALESCE(
    `product.translation.customFields`,
    `product.parent.translation.customFields`
  ) as `product.customFields`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id`
  LEFT JOIN `internal_notes_extension` `product.internalNotes` ON `product`.`internalNotes` = `product.internalNotes`.`product_id`
  LEFT JOIN `product_availability_extension` `product.productAvailability` ON `product`.`id` = `product.productAvailability`.`product_id`
  LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id`
  AND IFNULL(
    `product`.`product_media_version_id`,
    `product.parent`.`product_media_version_id`
  ) = `product.cover`.`version_id`
  LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id`
  AND IFNULL(
    `product`.`product_manufacturer_version_id`,
    `product.parent`.`product_manufacturer_version_id`
  ) = `product.manufacturer`.`version_id`
  LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id`
  LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id`
  LEFT JOIN (
    SELECT
      `product.translation`.`product_id`,
      `product.translation`.`product_version_id`,
      `product.translation`.`meta_description` as `product.translation.metaDescription`,
      `product.translation`.`name` as `product.translation.name`,
      `product.translation`.`keywords` as `product.translation.keywords`,
      `product.translation`.`description` as `product.translation.description`,
      `product.translation`.`meta_title` as `product.translation.metaTitle`,
      `product.translation`.`pack_unit` as `product.translation.packUnit`,
      `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`,
      `product.translation`.`custom_fields` as `product.translation.customFields`,
      `product.translation`.`slot_config` as `product.translation.slotConfig`,
      `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`
    FROM
      `product_translation` `product.translation`
    WHERE
      `product.translation`.`language_id` = ?
  ) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id`
  AND `product.product_translation`.`product_version_id` = `product`.`version_id`
  LEFT JOIN (
    SELECT
      `product.parent.translation`.`product_id`,
      `product.parent.translation`.`product_version_id`,
      `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`,
      `product.parent.translation`.`name` as `product.parent.translation.name`,
      `product.parent.translation`.`keywords` as `product.parent.translation.keywords`,
      `product.parent.translation`.`description` as `product.parent.translation.description`,
      `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`,
      `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`,
      `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`,
      `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`,
      `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`,
      `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`
    FROM
      `product_translation` `product.parent.translation`
    WHERE
      `product.parent.translation`.`language_id` = ?
  ) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id`
  AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id`
  LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id`
  LEFT JOIN (
    SELECT
      `product.cover.media.translation`.`media_id`,
      `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`,
      `product.cover.media.translation`.`title` as `product.cover.media.translation.title`,
      `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields`
    FROM
      `media_translation` `product.cover.media.translation`
    WHERE
      `product.cover.media.translation`.`language_id` = ?
  ) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id`
  LEFT JOIN `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id`
  LEFT JOIN (
    SELECT
      `product.manufacturer.translation`.`product_manufacturer_id`,
      `product.manufacturer.translation`.`product_manufacturer_version_id`,
      `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`,
      `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`,
      `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields`
    FROM
      `product_manufacturer_translation` `product.manufacturer.translation`
    WHERE
      `product.manufacturer.translation`.`language_id` = ?
  ) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id`
  AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id`
  LEFT JOIN (
    SELECT
      `product.manufacturer.media.translation`.`media_id`,
      `product.manufacturer.media.translation`.`alt` as `product.manufacturer.media.translation.alt`,
      `product.manufacturer.media.translation`.`title` as `product.manufacturer.media.translation.title`,
      `product.manufacturer.media.translation`.`custom_fields` as `product.manufacturer.media.translation.customFields`
    FROM
      `media_translation` `product.manufacturer.media.translation`
    WHERE
      `product.manufacturer.media.translation`.`language_id` = ?
  ) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id`
  LEFT JOIN (
    SELECT
      `product.unit.translation`.`unit_id`,
      `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`,
      `product.unit.translation`.`name` as `product.unit.translation.name`,
      `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields`
    FROM
      `unit_translation` `product.unit.translation`
    WHERE
      `product.unit.translation`.`language_id` = ?
  ) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id`
  LEFT JOIN (
    SELECT
      `product.deliveryTime.translation`.`delivery_time_id`,
      `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`,
      `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields`
    FROM
      `delivery_time_translation` `product.deliveryTime.translation`
    WHERE
      `product.deliveryTime.translation`.`language_id` = ?
  ) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    `product`.`id` IN (?)
  )

SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.internalNotes`.`id` as `product.internalNotes.id`, `product.internalNotes`.`parent_id` as `product.internalNotes.parentId`, `product.internalNotes`.`product_id` as `product.internalNotes.productId`, `product.internalNotes`.`note` as `product.internalNotes.note`, `product.internalNotes`.`chief_note` as `product.internalNotes.chiefNote`, `product.internalNotes`.`product_version_id` as `product.internalNotes.productVersionId`, `product.internalNotes`.`created_at` as `product.internalNotes.createdAt`, `product.internalNotes`.`updated_at` as `product.internalNotes.updatedAt`, `product.productAvailability`.`id` as `product.productAvailability.id`, `product.productAvailability`.`product_id` as `product.productAvailability.productId`, `product.productAvailability`.`notify` as `product.productAvailability.notify`, `product.productAvailability`.`availability_technical_name` as `product.productAvailability.availabilityTechnicalName`, `product.productAvailability`.`product_version_id` as `product.productAvailability.productVersionId`, `product.productAvailability`.`created_at` as `product.productAvailability.createdAt`, `product.productAvailability`.`updated_at` as `product.productAvailability.updatedAt`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_property` `product.properties.mapping`
                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.media`.`id` as `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` as `product.manufacturer.media.config`, `product.manufacturer.media`.`path` as `product.manufacturer.media.path`, `product.manufacturer.media`.`private` as `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation.title` as `product.manufacturer.media.title`, `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation.alt` as `product.manufacturer.media.alt`, `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation.customFields` as `product.manufacturer.media.customFields`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `product.manufacturer.translation.description`, `product.manufacturer.translation.description` as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, `product.manufacturer.translation.customFields` as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.categoriesRo.mapping`.`category_id`) SEPARATOR '||')
                  FROM `product_category_tree` `product.categoriesRo.mapping`
                  WHERE `product.categoriesRo.mapping`.`product_id` = `product`.`id` AND `product.categoriesRo.mapping`.product_version_id = `product`.version_id ) as `product.categoriesRo.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `internal_notes_extension` `product.internalNotes` ON `product`.`internalNotes` = `product.internalNotes`.`product_id` LEFT JOIN `product_availability_extension` `product.productAvailability` ON `product`.`id` = `product.productAvailability`.`product_id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` LEFT JOIN `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.media.translation`.`media_id`, `product.manufacturer.media.translation`.`alt` as `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation`.`title` as `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation`.`custom_fields` as `product.manufacturer.media.translation.customFields` FROM `media_translation` `product.manufacturer.media.translation` WHERE `product.manufacturer.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product`.`id` IN (0xD6CAB68798654DCCAA82D370CEFFBA01));