Symfony Profiler

SELECT
  `product_configurator_setting`.`id` as `product_configurator_setting.id`,
  `product_configurator_setting`.`version_id` as `product_configurator_setting.versionId`,
  `product_configurator_setting`.`product_id` as `product_configurator_setting.productId`,
  `product_configurator_setting`.`product_version_id` as `product_configurator_setting.productVersionId`,
  `product_configurator_setting`.`media_id` as `product_configurator_setting.mediaId`,
  `product_configurator_setting`.`property_group_option_id` as `product_configurator_setting.optionId`,
  `product_configurator_setting`.`price` as `product_configurator_setting.price`,
  `product_configurator_setting`.`position` as `product_configurator_setting.position`,
  `product_configurator_setting`.`custom_fields` as `product_configurator_setting.customFields`,
  `product_configurator_setting`.`created_at` as `product_configurator_setting.createdAt`,
  `product_configurator_setting`.`updated_at` as `product_configurator_setting.updatedAt`,
  `product_configurator_setting.option`.`id` as `product_configurator_setting.option.id`,
  `product_configurator_setting.option`.`property_group_id` as `product_configurator_setting.option.groupId`,
  `product_configurator_setting.option`.`color_hex_code` as `product_configurator_setting.option.colorHexCode`,
  `product_configurator_setting.option`.`media_id` as `product_configurator_setting.option.mediaId`,
  `product_configurator_setting.option`.`created_at` as `product_configurator_setting.option.createdAt`,
  `product_configurator_setting.option`.`updated_at` as `product_configurator_setting.option.updatedAt`,
  `product_configurator_setting.option.group`.`id` as `product_configurator_setting.option.group.id`,
  `product_configurator_setting.option.group`.`display_type` as `product_configurator_setting.option.group.displayType`,
  `product_configurator_setting.option.group`.`sorting_type` as `product_configurator_setting.option.group.sortingType`,
  `product_configurator_setting.option.group`.`filterable` as `product_configurator_setting.option.group.filterable`,
  `product_configurator_setting.option.group`.`visible_on_product_detail_page` as `product_configurator_setting.option.group.visibleOnProductDetailPage`,
  `product_configurator_setting.option.group`.`created_at` as `product_configurator_setting.option.group.createdAt`,
  `product_configurator_setting.option.group`.`updated_at` as `product_configurator_setting.option.group.updatedAt`,
  `product_configurator_setting.option.group.translation.override_1.name`,
  `product_configurator_setting.option.group.translation.name`,
  COALESCE(
    `product_configurator_setting.option.group.translation.override_1.name`,
    `product_configurator_setting.option.group.translation.name`
  ) as `product_configurator_setting.option.group.name`,
  `product_configurator_setting.option.group.translation.override_1.description`,
  `product_configurator_setting.option.group.translation.description`,
  COALESCE(
    `product_configurator_setting.option.group.translation.override_1.description`,
    `product_configurator_setting.option.group.translation.description`
  ) as `product_configurator_setting.option.group.description`,
  `product_configurator_setting.option.group.translation.override_1.position`,
  `product_configurator_setting.option.group.translation.position`,
  COALESCE(
    `product_configurator_setting.option.group.translation.override_1.position`,
    `product_configurator_setting.option.group.translation.position`
  ) as `product_configurator_setting.option.group.position`,
  `product_configurator_setting.option.group.translation.override_1.customFields`,
  `product_configurator_setting.option.group.translation.customFields`,
  COALESCE(
    `product_configurator_setting.option.group.translation.override_1.customFields`,
    `product_configurator_setting.option.group.translation.customFields`
  ) as `product_configurator_setting.option.group.customFields`,
  `product_configurator_setting.option.media`.`id` as `product_configurator_setting.option.media.id`,
  `product_configurator_setting.option.media`.`user_id` as `product_configurator_setting.option.media.userId`,
  `product_configurator_setting.option.media`.`media_folder_id` as `product_configurator_setting.option.media.mediaFolderId`,
  `product_configurator_setting.option.media`.`mime_type` as `product_configurator_setting.option.media.mimeType`,
  `product_configurator_setting.option.media`.`file_extension` as `product_configurator_setting.option.media.fileExtension`,
  `product_configurator_setting.option.media`.`uploaded_at` as `product_configurator_setting.option.media.uploadedAt`,
  `product_configurator_setting.option.media`.`file_name` as `product_configurator_setting.option.media.fileName`,
  `product_configurator_setting.option.media`.`file_size` as `product_configurator_setting.option.media.fileSize`,
  `product_configurator_setting.option.media`.`media_type` as `product_configurator_setting.option.media.mediaTypeRaw`,
  `product_configurator_setting.option.media`.`meta_data` as `product_configurator_setting.option.media.metaData`,
  `product_configurator_setting.option.media`.`config` as `product_configurator_setting.option.media.config`,
  `product_configurator_setting.option.media`.`path` as `product_configurator_setting.option.media.path`,
  `product_configurator_setting.option.media`.`private` as `product_configurator_setting.option.media.private`,
  `product_configurator_setting.option.media`.`thumbnails_ro` as `product_configurator_setting.option.media.thumbnailsRo`,
  `product_configurator_setting.option.media`.`created_at` as `product_configurator_setting.option.media.createdAt`,
  `product_configurator_setting.option.media`.`updated_at` as `product_configurator_setting.option.media.updatedAt`,
  `product_configurator_setting.option.media.translation.override_1.title`,
  `product_configurator_setting.option.media.translation.title`,
  COALESCE(
    `product_configurator_setting.option.media.translation.override_1.title`,
    `product_configurator_setting.option.media.translation.title`
  ) as `product_configurator_setting.option.media.title`,
  `product_configurator_setting.option.media.translation.override_1.alt`,
  `product_configurator_setting.option.media.translation.alt`,
  COALESCE(
    `product_configurator_setting.option.media.translation.override_1.alt`,
    `product_configurator_setting.option.media.translation.alt`
  ) as `product_configurator_setting.option.media.alt`,
  `product_configurator_setting.option.media.translation.override_1.customFields`,
  `product_configurator_setting.option.media.translation.customFields`,
  COALESCE(
    `product_configurator_setting.option.media.translation.override_1.customFields`,
    `product_configurator_setting.option.media.translation.customFields`
  ) as `product_configurator_setting.option.media.customFields`,
  `product_configurator_setting.option.translation.override_1.name`,
  `product_configurator_setting.option.translation.name`,
  COALESCE(
    `product_configurator_setting.option.translation.override_1.name`,
    `product_configurator_setting.option.translation.name`
  ) as `product_configurator_setting.option.name`,
  `product_configurator_setting.option.translation.override_1.position`,
  `product_configurator_setting.option.translation.position`,
  COALESCE(
    `product_configurator_setting.option.translation.override_1.position`,
    `product_configurator_setting.option.translation.position`
  ) as `product_configurator_setting.option.position`,
  `product_configurator_setting.option.translation.override_1.customFields`,
  `product_configurator_setting.option.translation.customFields`,
  COALESCE(
    `product_configurator_setting.option.translation.override_1.customFields`,
    `product_configurator_setting.option.translation.customFields`
  ) as `product_configurator_setting.option.customFields`,
  `product_configurator_setting.media`.`id` as `product_configurator_setting.media.id`,
  `product_configurator_setting.media`.`user_id` as `product_configurator_setting.media.userId`,
  `product_configurator_setting.media`.`media_folder_id` as `product_configurator_setting.media.mediaFolderId`,
  `product_configurator_setting.media`.`mime_type` as `product_configurator_setting.media.mimeType`,
  `product_configurator_setting.media`.`file_extension` as `product_configurator_setting.media.fileExtension`,
  `product_configurator_setting.media`.`uploaded_at` as `product_configurator_setting.media.uploadedAt`,
  `product_configurator_setting.media`.`file_name` as `product_configurator_setting.media.fileName`,
  `product_configurator_setting.media`.`file_size` as `product_configurator_setting.media.fileSize`,
  `product_configurator_setting.media`.`media_type` as `product_configurator_setting.media.mediaTypeRaw`,
  `product_configurator_setting.media`.`meta_data` as `product_configurator_setting.media.metaData`,
  `product_configurator_setting.media`.`config` as `product_configurator_setting.media.config`,
  `product_configurator_setting.media`.`path` as `product_configurator_setting.media.path`,
  `product_configurator_setting.media`.`private` as `product_configurator_setting.media.private`,
  `product_configurator_setting.media`.`thumbnails_ro` as `product_configurator_setting.media.thumbnailsRo`,
  `product_configurator_setting.media`.`created_at` as `product_configurator_setting.media.createdAt`,
  `product_configurator_setting.media`.`updated_at` as `product_configurator_setting.media.updatedAt`,
  `product_configurator_setting.media.translation.override_1.title`,
  `product_configurator_setting.media.translation.title`,
  COALESCE(
    `product_configurator_setting.media.translation.override_1.title`,
    `product_configurator_setting.media.translation.title`
  ) as `product_configurator_setting.media.title`,
  `product_configurator_setting.media.translation.override_1.alt`,
  `product_configurator_setting.media.translation.alt`,
  COALESCE(
    `product_configurator_setting.media.translation.override_1.alt`,
    `product_configurator_setting.media.translation.alt`
  ) as `product_configurator_setting.media.alt`,
  `product_configurator_setting.media.translation.override_1.customFields`,
  `product_configurator_setting.media.translation.customFields`,
  COALESCE(
    `product_configurator_setting.media.translation.override_1.customFields`,
    `product_configurator_setting.media.translation.customFields`
  ) as `product_configurator_setting.media.customFields`
FROM
  `product_configurator_setting`
  LEFT JOIN `property_group_option` `product_configurator_setting.option` ON `product_configurator_setting`.`property_group_option_id` = `product_configurator_setting.option`.`id`
  LEFT JOIN `media` `product_configurator_setting.media` ON `product_configurator_setting`.`media_id` = `product_configurator_setting.media`.`id`
  LEFT JOIN `property_group` `product_configurator_setting.option.group` ON `product_configurator_setting.option`.`property_group_id` = `product_configurator_setting.option.group`.`id`
  LEFT JOIN `media` `product_configurator_setting.option.media` ON `product_configurator_setting.option`.`media_id` = `product_configurator_setting.option.media`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.option.translation`.`property_group_option_id`,
      `product_configurator_setting.option.translation`.`name` as `product_configurator_setting.option.translation.name`,
      `product_configurator_setting.option.translation.override_1`.`name` as `product_configurator_setting.option.translation.override_1.name`,
      `product_configurator_setting.option.translation`.`position` as `product_configurator_setting.option.translation.position`,
      `product_configurator_setting.option.translation.override_1`.`position` as `product_configurator_setting.option.translation.override_1.position`,
      `product_configurator_setting.option.translation`.`custom_fields` as `product_configurator_setting.option.translation.customFields`,
      `product_configurator_setting.option.translation.override_1`.`custom_fields` as `product_configurator_setting.option.translation.override_1.customFields`
    FROM
      `property_group_option_translation` `product_configurator_setting.option.translation`
      LEFT JOIN `property_group_option_translation` `product_configurator_setting.option.translation.override_1` ON `product_configurator_setting.option.translation`.`property_group_option_id` = `product_configurator_setting.option.translation.override_1`.`property_group_option_id`
      AND `product_configurator_setting.option.translation.override_1`.`language_id` = ?
    WHERE
      `product_configurator_setting.option.translation`.`language_id` = ?
  ) `product_configurator_setting.option.property_group_option_translation` ON `product_configurator_setting.option.property_group_option_translation`.`property_group_option_id` = `product_configurator_setting.option`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.option.group.translation`.`property_group_id`,
      `product_configurator_setting.option.group.translation`.`name` as `product_configurator_setting.option.group.translation.name`,
      `product_configurator_setting.option.group.translation.override_1`.`name` as `product_configurator_setting.option.group.translation.override_1.name`,
      `product_configurator_setting.option.group.translation`.`description` as `product_configurator_setting.option.group.translation.description`,
      `product_configurator_setting.option.group.translation.override_1`.`description` as `product_configurator_setting.option.group.translation.override_1.description`,
      `product_configurator_setting.option.group.translation`.`position` as `product_configurator_setting.option.group.translation.position`,
      `product_configurator_setting.option.group.translation.override_1`.`position` as `product_configurator_setting.option.group.translation.override_1.position`,
      `product_configurator_setting.option.group.translation`.`custom_fields` as `product_configurator_setting.option.group.translation.customFields`,
      `product_configurator_setting.option.group.translation.override_1`.`custom_fields` as `product_configurator_setting.option.group.translation.override_1.customFields`
    FROM
      `property_group_translation` `product_configurator_setting.option.group.translation`
      LEFT JOIN `property_group_translation` `product_configurator_setting.option.group.translation.override_1` ON `product_configurator_setting.option.group.translation`.`property_group_id` = `product_configurator_setting.option.group.translation.override_1`.`property_group_id`
      AND `product_configurator_setting.option.group.translation.override_1`.`language_id` = ?
    WHERE
      `product_configurator_setting.option.group.translation`.`language_id` = ?
  ) `product_configurator_setting.option.group.property_group_translation` ON `product_configurator_setting.option.group.property_group_translation`.`property_group_id` = `product_configurator_setting.option.group`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.option.media.translation`.`media_id`,
      `product_configurator_setting.option.media.translation`.`alt` as `product_configurator_setting.option.media.translation.alt`,
      `product_configurator_setting.option.media.translation.override_1`.`alt` as `product_configurator_setting.option.media.translation.override_1.alt`,
      `product_configurator_setting.option.media.translation`.`title` as `product_configurator_setting.option.media.translation.title`,
      `product_configurator_setting.option.media.translation.override_1`.`title` as `product_configurator_setting.option.media.translation.override_1.title`,
      `product_configurator_setting.option.media.translation`.`custom_fields` as `product_configurator_setting.option.media.translation.customFields`,
      `product_configurator_setting.option.media.translation.override_1`.`custom_fields` as `product_configurator_setting.option.media.translation.override_1.customFields`
    FROM
      `media_translation` `product_configurator_setting.option.media.translation`
      LEFT JOIN `media_translation` `product_configurator_setting.option.media.translation.override_1` ON `product_configurator_setting.option.media.translation`.`media_id` = `product_configurator_setting.option.media.translation.override_1`.`media_id`
      AND `product_configurator_setting.option.media.translation.override_1`.`language_id` = ?
    WHERE
      `product_configurator_setting.option.media.translation`.`language_id` = ?
  ) `product_configurator_setting.option.media.media_translation` ON `product_configurator_setting.option.media.media_translation`.`media_id` = `product_configurator_setting.option.media`.`id`
  LEFT JOIN (
    SELECT
      `product_configurator_setting.media.translation`.`media_id`,
      `product_configurator_setting.media.translation`.`alt` as `product_configurator_setting.media.translation.alt`,
      `product_configurator_setting.media.translation.override_1`.`alt` as `product_configurator_setting.media.translation.override_1.alt`,
      `product_configurator_setting.media.translation`.`title` as `product_configurator_setting.media.translation.title`,
      `product_configurator_setting.media.translation.override_1`.`title` as `product_configurator_setting.media.translation.override_1.title`,
      `product_configurator_setting.media.translation`.`custom_fields` as `product_configurator_setting.media.translation.customFields`,
      `product_configurator_setting.media.translation.override_1`.`custom_fields` as `product_configurator_setting.media.translation.override_1.customFields`
    FROM
      `media_translation` `product_configurator_setting.media.translation`
      LEFT JOIN `media_translation` `product_configurator_setting.media.translation.override_1` ON `product_configurator_setting.media.translation`.`media_id` = `product_configurator_setting.media.translation.override_1`.`media_id`
      AND `product_configurator_setting.media.translation.override_1`.`language_id` = ?
    WHERE
      `product_configurator_setting.media.translation`.`language_id` = ?
  ) `product_configurator_setting.media.media_translation` ON `product_configurator_setting.media.media_translation`.`media_id` = `product_configurator_setting.media`.`id`
WHERE
  (
    `product_configurator_setting`.`version_id` = ?
  )
  AND (
    (
      `product_configurator_setting`.`product_id` = ?
    )
  )

SELECT `product_configurator_setting`.`id` as `product_configurator_setting.id`, `product_configurator_setting`.`version_id` as `product_configurator_setting.versionId`, `product_configurator_setting`.`product_id` as `product_configurator_setting.productId`, `product_configurator_setting`.`product_version_id` as `product_configurator_setting.productVersionId`, `product_configurator_setting`.`media_id` as `product_configurator_setting.mediaId`, `product_configurator_setting`.`property_group_option_id` as `product_configurator_setting.optionId`, `product_configurator_setting`.`price` as `product_configurator_setting.price`, `product_configurator_setting`.`position` as `product_configurator_setting.position`, `product_configurator_setting`.`custom_fields` as `product_configurator_setting.customFields`, `product_configurator_setting`.`created_at` as `product_configurator_setting.createdAt`, `product_configurator_setting`.`updated_at` as `product_configurator_setting.updatedAt`, `product_configurator_setting.option`.`id` as `product_configurator_setting.option.id`, `product_configurator_setting.option`.`property_group_id` as `product_configurator_setting.option.groupId`, `product_configurator_setting.option`.`color_hex_code` as `product_configurator_setting.option.colorHexCode`, `product_configurator_setting.option`.`media_id` as `product_configurator_setting.option.mediaId`, `product_configurator_setting.option`.`created_at` as `product_configurator_setting.option.createdAt`, `product_configurator_setting.option`.`updated_at` as `product_configurator_setting.option.updatedAt`, `product_configurator_setting.option.group`.`id` as `product_configurator_setting.option.group.id`, `product_configurator_setting.option.group`.`display_type` as `product_configurator_setting.option.group.displayType`, `product_configurator_setting.option.group`.`sorting_type` as `product_configurator_setting.option.group.sortingType`, `product_configurator_setting.option.group`.`filterable` as `product_configurator_setting.option.group.filterable`, `product_configurator_setting.option.group`.`visible_on_product_detail_page` as `product_configurator_setting.option.group.visibleOnProductDetailPage`, `product_configurator_setting.option.group`.`created_at` as `product_configurator_setting.option.group.createdAt`, `product_configurator_setting.option.group`.`updated_at` as `product_configurator_setting.option.group.updatedAt`, `product_configurator_setting.option.group.translation.override_1.name`, `product_configurator_setting.option.group.translation.name`, COALESCE(`product_configurator_setting.option.group.translation.override_1.name`,`product_configurator_setting.option.group.translation.name`) as `product_configurator_setting.option.group.name`, `product_configurator_setting.option.group.translation.override_1.description`, `product_configurator_setting.option.group.translation.description`, COALESCE(`product_configurator_setting.option.group.translation.override_1.description`,`product_configurator_setting.option.group.translation.description`) as `product_configurator_setting.option.group.description`, `product_configurator_setting.option.group.translation.override_1.position`, `product_configurator_setting.option.group.translation.position`, COALESCE(`product_configurator_setting.option.group.translation.override_1.position`,`product_configurator_setting.option.group.translation.position`) as `product_configurator_setting.option.group.position`, `product_configurator_setting.option.group.translation.override_1.customFields`, `product_configurator_setting.option.group.translation.customFields`, COALESCE(`product_configurator_setting.option.group.translation.override_1.customFields`,`product_configurator_setting.option.group.translation.customFields`) as `product_configurator_setting.option.group.customFields`, `product_configurator_setting.option.media`.`id` as `product_configurator_setting.option.media.id`, `product_configurator_setting.option.media`.`user_id` as `product_configurator_setting.option.media.userId`, `product_configurator_setting.option.media`.`media_folder_id` as `product_configurator_setting.option.media.mediaFolderId`, `product_configurator_setting.option.media`.`mime_type` as `product_configurator_setting.option.media.mimeType`, `product_configurator_setting.option.media`.`file_extension` as `product_configurator_setting.option.media.fileExtension`, `product_configurator_setting.option.media`.`uploaded_at` as `product_configurator_setting.option.media.uploadedAt`, `product_configurator_setting.option.media`.`file_name` as `product_configurator_setting.option.media.fileName`, `product_configurator_setting.option.media`.`file_size` as `product_configurator_setting.option.media.fileSize`, `product_configurator_setting.option.media`.`media_type` as `product_configurator_setting.option.media.mediaTypeRaw`, `product_configurator_setting.option.media`.`meta_data` as `product_configurator_setting.option.media.metaData`, `product_configurator_setting.option.media`.`config` as `product_configurator_setting.option.media.config`, `product_configurator_setting.option.media`.`path` as `product_configurator_setting.option.media.path`, `product_configurator_setting.option.media`.`private` as `product_configurator_setting.option.media.private`, `product_configurator_setting.option.media`.`thumbnails_ro` as `product_configurator_setting.option.media.thumbnailsRo`, `product_configurator_setting.option.media`.`created_at` as `product_configurator_setting.option.media.createdAt`, `product_configurator_setting.option.media`.`updated_at` as `product_configurator_setting.option.media.updatedAt`, `product_configurator_setting.option.media.translation.override_1.title`, `product_configurator_setting.option.media.translation.title`, COALESCE(`product_configurator_setting.option.media.translation.override_1.title`,`product_configurator_setting.option.media.translation.title`) as `product_configurator_setting.option.media.title`, `product_configurator_setting.option.media.translation.override_1.alt`, `product_configurator_setting.option.media.translation.alt`, COALESCE(`product_configurator_setting.option.media.translation.override_1.alt`,`product_configurator_setting.option.media.translation.alt`) as `product_configurator_setting.option.media.alt`, `product_configurator_setting.option.media.translation.override_1.customFields`, `product_configurator_setting.option.media.translation.customFields`, COALESCE(`product_configurator_setting.option.media.translation.override_1.customFields`,`product_configurator_setting.option.media.translation.customFields`) as `product_configurator_setting.option.media.customFields`, `product_configurator_setting.option.translation.override_1.name`, `product_configurator_setting.option.translation.name`, COALESCE(`product_configurator_setting.option.translation.override_1.name`,`product_configurator_setting.option.translation.name`) as `product_configurator_setting.option.name`, `product_configurator_setting.option.translation.override_1.position`, `product_configurator_setting.option.translation.position`, COALESCE(`product_configurator_setting.option.translation.override_1.position`,`product_configurator_setting.option.translation.position`) as `product_configurator_setting.option.position`, `product_configurator_setting.option.translation.override_1.customFields`, `product_configurator_setting.option.translation.customFields`, COALESCE(`product_configurator_setting.option.translation.override_1.customFields`,`product_configurator_setting.option.translation.customFields`) as `product_configurator_setting.option.customFields`, `product_configurator_setting.media`.`id` as `product_configurator_setting.media.id`, `product_configurator_setting.media`.`user_id` as `product_configurator_setting.media.userId`, `product_configurator_setting.media`.`media_folder_id` as `product_configurator_setting.media.mediaFolderId`, `product_configurator_setting.media`.`mime_type` as `product_configurator_setting.media.mimeType`, `product_configurator_setting.media`.`file_extension` as `product_configurator_setting.media.fileExtension`, `product_configurator_setting.media`.`uploaded_at` as `product_configurator_setting.media.uploadedAt`, `product_configurator_setting.media`.`file_name` as `product_configurator_setting.media.fileName`, `product_configurator_setting.media`.`file_size` as `product_configurator_setting.media.fileSize`, `product_configurator_setting.media`.`media_type` as `product_configurator_setting.media.mediaTypeRaw`, `product_configurator_setting.media`.`meta_data` as `product_configurator_setting.media.metaData`, `product_configurator_setting.media`.`config` as `product_configurator_setting.media.config`, `product_configurator_setting.media`.`path` as `product_configurator_setting.media.path`, `product_configurator_setting.media`.`private` as `product_configurator_setting.media.private`, `product_configurator_setting.media`.`thumbnails_ro` as `product_configurator_setting.media.thumbnailsRo`, `product_configurator_setting.media`.`created_at` as `product_configurator_setting.media.createdAt`, `product_configurator_setting.media`.`updated_at` as `product_configurator_setting.media.updatedAt`, `product_configurator_setting.media.translation.override_1.title`, `product_configurator_setting.media.translation.title`, COALESCE(`product_configurator_setting.media.translation.override_1.title`,`product_configurator_setting.media.translation.title`) as `product_configurator_setting.media.title`, `product_configurator_setting.media.translation.override_1.alt`, `product_configurator_setting.media.translation.alt`, COALESCE(`product_configurator_setting.media.translation.override_1.alt`,`product_configurator_setting.media.translation.alt`) as `product_configurator_setting.media.alt`, `product_configurator_setting.media.translation.override_1.customFields`, `product_configurator_setting.media.translation.customFields`, COALESCE(`product_configurator_setting.media.translation.override_1.customFields`,`product_configurator_setting.media.translation.customFields`) as `product_configurator_setting.media.customFields` FROM `product_configurator_setting` LEFT JOIN `property_group_option` `product_configurator_setting.option` ON `product_configurator_setting`.`property_group_option_id` = `product_configurator_setting.option`.`id` LEFT JOIN `media` `product_configurator_setting.media` ON `product_configurator_setting`.`media_id` = `product_configurator_setting.media`.`id` LEFT JOIN `property_group` `product_configurator_setting.option.group` ON `product_configurator_setting.option`.`property_group_id` = `product_configurator_setting.option.group`.`id` LEFT JOIN `media` `product_configurator_setting.option.media` ON `product_configurator_setting.option`.`media_id` = `product_configurator_setting.option.media`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.translation`.`property_group_option_id`, `product_configurator_setting.option.translation`.`name` as `product_configurator_setting.option.translation.name`, `product_configurator_setting.option.translation.override_1`.`name` as `product_configurator_setting.option.translation.override_1.name`, `product_configurator_setting.option.translation`.`position` as `product_configurator_setting.option.translation.position`, `product_configurator_setting.option.translation.override_1`.`position` as `product_configurator_setting.option.translation.override_1.position`, `product_configurator_setting.option.translation`.`custom_fields` as `product_configurator_setting.option.translation.customFields`, `product_configurator_setting.option.translation.override_1`.`custom_fields` as `product_configurator_setting.option.translation.override_1.customFields` FROM `property_group_option_translation` `product_configurator_setting.option.translation` LEFT JOIN `property_group_option_translation` `product_configurator_setting.option.translation.override_1` ON `product_configurator_setting.option.translation`.`property_group_option_id` = `product_configurator_setting.option.translation.override_1`.`property_group_option_id` AND `product_configurator_setting.option.translation.override_1`.`language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `product_configurator_setting.option.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.option.property_group_option_translation` ON `product_configurator_setting.option.property_group_option_translation`.`property_group_option_id` = `product_configurator_setting.option`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.group.translation`.`property_group_id`, `product_configurator_setting.option.group.translation`.`name` as `product_configurator_setting.option.group.translation.name`, `product_configurator_setting.option.group.translation.override_1`.`name` as `product_configurator_setting.option.group.translation.override_1.name`, `product_configurator_setting.option.group.translation`.`description` as `product_configurator_setting.option.group.translation.description`, `product_configurator_setting.option.group.translation.override_1`.`description` as `product_configurator_setting.option.group.translation.override_1.description`, `product_configurator_setting.option.group.translation`.`position` as `product_configurator_setting.option.group.translation.position`, `product_configurator_setting.option.group.translation.override_1`.`position` as `product_configurator_setting.option.group.translation.override_1.position`, `product_configurator_setting.option.group.translation`.`custom_fields` as `product_configurator_setting.option.group.translation.customFields`, `product_configurator_setting.option.group.translation.override_1`.`custom_fields` as `product_configurator_setting.option.group.translation.override_1.customFields` FROM `property_group_translation` `product_configurator_setting.option.group.translation` LEFT JOIN `property_group_translation` `product_configurator_setting.option.group.translation.override_1` ON `product_configurator_setting.option.group.translation`.`property_group_id` = `product_configurator_setting.option.group.translation.override_1`.`property_group_id` AND `product_configurator_setting.option.group.translation.override_1`.`language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `product_configurator_setting.option.group.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.option.group.property_group_translation` ON `product_configurator_setting.option.group.property_group_translation`.`property_group_id` = `product_configurator_setting.option.group`.`id` LEFT JOIN (SELECT `product_configurator_setting.option.media.translation`.`media_id`, `product_configurator_setting.option.media.translation`.`alt` as `product_configurator_setting.option.media.translation.alt`, `product_configurator_setting.option.media.translation.override_1`.`alt` as `product_configurator_setting.option.media.translation.override_1.alt`, `product_configurator_setting.option.media.translation`.`title` as `product_configurator_setting.option.media.translation.title`, `product_configurator_setting.option.media.translation.override_1`.`title` as `product_configurator_setting.option.media.translation.override_1.title`, `product_configurator_setting.option.media.translation`.`custom_fields` as `product_configurator_setting.option.media.translation.customFields`, `product_configurator_setting.option.media.translation.override_1`.`custom_fields` as `product_configurator_setting.option.media.translation.override_1.customFields` FROM `media_translation` `product_configurator_setting.option.media.translation` LEFT JOIN `media_translation` `product_configurator_setting.option.media.translation.override_1` ON `product_configurator_setting.option.media.translation`.`media_id` = `product_configurator_setting.option.media.translation.override_1`.`media_id` AND `product_configurator_setting.option.media.translation.override_1`.`language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `product_configurator_setting.option.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.option.media.media_translation` ON `product_configurator_setting.option.media.media_translation`.`media_id` = `product_configurator_setting.option.media`.`id` LEFT JOIN (SELECT `product_configurator_setting.media.translation`.`media_id`, `product_configurator_setting.media.translation`.`alt` as `product_configurator_setting.media.translation.alt`, `product_configurator_setting.media.translation.override_1`.`alt` as `product_configurator_setting.media.translation.override_1.alt`, `product_configurator_setting.media.translation`.`title` as `product_configurator_setting.media.translation.title`, `product_configurator_setting.media.translation.override_1`.`title` as `product_configurator_setting.media.translation.override_1.title`, `product_configurator_setting.media.translation`.`custom_fields` as `product_configurator_setting.media.translation.customFields`, `product_configurator_setting.media.translation.override_1`.`custom_fields` as `product_configurator_setting.media.translation.override_1.customFields` FROM `media_translation` `product_configurator_setting.media.translation` LEFT JOIN `media_translation` `product_configurator_setting.media.translation.override_1` ON `product_configurator_setting.media.translation`.`media_id` = `product_configurator_setting.media.translation.override_1`.`media_id` AND `product_configurator_setting.media.translation.override_1`.`language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `product_configurator_setting.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_configurator_setting.media.media_translation` ON `product_configurator_setting.media.media_translation`.`media_id` = `product_configurator_setting.media`.`id` WHERE (`product_configurator_setting`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_configurator_setting`.`product_id` = 0x79FD180CFC7946328C9B9A47EF722FDE));

SELECT
  `product_review`.`id` as `product_review.id`,
  `product_review`.`product_id` as `product_review.productId`,
  `product_review`.`product_version_id` as `product_review.productVersionId`,
  `product_review`.`customer_id` as `product_review.customerId`,
  `product_review`.`sales_channel_id` as `product_review.salesChannelId`,
  `product_review`.`language_id` as `product_review.languageId`,
  `product_review`.`external_user` as `product_review.externalUser`,
  `product_review`.`external_email` as `product_review.externalEmail`,
  `product_review`.`title` as `product_review.title`,
  `product_review`.`content` as `product_review.content`,
  `product_review`.`points` as `product_review.points`,
  `product_review`.`status` as `product_review.status`,
  `product_review`.`comment` as `product_review.comment`,
  `product_review`.`custom_fields` as `product_review.customFields`,
  `product_review`.`created_at` as `product_review.createdAt`,
  `product_review`.`updated_at` as `product_review.updatedAt`,
  `product_review.reviewExtension`.`id` as `product_review.reviewExtension.id`,
  `product_review.reviewExtension`.`review_id` as `product_review.reviewExtension.reviewId`,
  `product_review.reviewExtension`.`order_id` as `product_review.reviewExtension.orderId`,
  `product_review.reviewExtension`.`media_id` as `product_review.reviewExtension.mediaId`,
  `product_review.reviewExtension.order`.`id` as `product_review.reviewExtension.order.id`,
  `product_review.reviewExtension.order`.`version_id` as `product_review.reviewExtension.order.versionId`,
  `product_review.reviewExtension.order`.`auto_increment` as `product_review.reviewExtension.order.autoIncrement`,
  `product_review.reviewExtension.order`.`order_number` as `product_review.reviewExtension.order.orderNumber`,
  `product_review.reviewExtension.order`.`billing_address_id` as `product_review.reviewExtension.order.billingAddressId`,
  `product_review.reviewExtension.order`.`billing_address_version_id` as `product_review.reviewExtension.order.billingAddressVersionId`,
  `product_review.reviewExtension.order`.`currency_id` as `product_review.reviewExtension.order.currencyId`,
  `product_review.reviewExtension.order`.`language_id` as `product_review.reviewExtension.order.languageId`,
  `product_review.reviewExtension.order`.`sales_channel_id` as `product_review.reviewExtension.order.salesChannelId`,
  `product_review.reviewExtension.order`.`order_date_time` as `product_review.reviewExtension.order.orderDateTime`,
  `product_review.reviewExtension.order`.`order_date` as `product_review.reviewExtension.order.orderDate`,
  `product_review.reviewExtension.order`.`price` as `product_review.reviewExtension.order.price`,
  `product_review.reviewExtension.order`.`amount_total` as `product_review.reviewExtension.order.amountTotal`,
  `product_review.reviewExtension.order`.`amount_net` as `product_review.reviewExtension.order.amountNet`,
  `product_review.reviewExtension.order`.`position_price` as `product_review.reviewExtension.order.positionPrice`,
  `product_review.reviewExtension.order`.`tax_status` as `product_review.reviewExtension.order.taxStatus`,
  `product_review.reviewExtension.order`.`shipping_costs` as `product_review.reviewExtension.order.shippingCosts`,
  `product_review.reviewExtension.order`.`shipping_total` as `product_review.reviewExtension.order.shippingTotal`,
  `product_review.reviewExtension.order`.`currency_factor` as `product_review.reviewExtension.order.currencyFactor`,
  `product_review.reviewExtension.order`.`deep_link_code` as `product_review.reviewExtension.order.deepLinkCode`,
  `product_review.reviewExtension.order`.`affiliate_code` as `product_review.reviewExtension.order.affiliateCode`,
  `product_review.reviewExtension.order`.`campaign_code` as `product_review.reviewExtension.order.campaignCode`,
  `product_review.reviewExtension.order`.`customer_comment` as `product_review.reviewExtension.order.customerComment`,
  `product_review.reviewExtension.order`.`source` as `product_review.reviewExtension.order.source`,
  `product_review.reviewExtension.order`.`state_id` as `product_review.reviewExtension.order.stateId`,
  `product_review.reviewExtension.order`.`rule_ids` as `product_review.reviewExtension.order.ruleIds`,
  `product_review.reviewExtension.order`.`custom_fields` as `product_review.reviewExtension.order.customFields`,
  `product_review.reviewExtension.order`.`created_by_id` as `product_review.reviewExtension.order.createdById`,
  `product_review.reviewExtension.order`.`updated_by_id` as `product_review.reviewExtension.order.updatedById`,
  `product_review.reviewExtension.order.orderCustomer`.`id` as `product_review.reviewExtension.order.orderCustomer.id`,
  `product_review.reviewExtension.order.orderCustomer`.`version_id` as `product_review.reviewExtension.order.orderCustomer.versionId`,
  `product_review.reviewExtension.order.orderCustomer`.`customer_id` as `product_review.reviewExtension.order.orderCustomer.customerId`,
  `product_review.reviewExtension.order.orderCustomer`.`order_id` as `product_review.reviewExtension.order.orderCustomer.orderId`,
  `product_review.reviewExtension.order.orderCustomer`.`order_version_id` as `product_review.reviewExtension.order.orderCustomer.orderVersionId`,
  `product_review.reviewExtension.order.orderCustomer`.`email` as `product_review.reviewExtension.order.orderCustomer.email`,
  `product_review.reviewExtension.order.orderCustomer`.`salutation_id` as `product_review.reviewExtension.order.orderCustomer.salutationId`,
  `product_review.reviewExtension.order.orderCustomer`.`first_name` as `product_review.reviewExtension.order.orderCustomer.firstName`,
  `product_review.reviewExtension.order.orderCustomer`.`last_name` as `product_review.reviewExtension.order.orderCustomer.lastName`,
  `product_review.reviewExtension.order.orderCustomer`.`company` as `product_review.reviewExtension.order.orderCustomer.company`,
  `product_review.reviewExtension.order.orderCustomer`.`title` as `product_review.reviewExtension.order.orderCustomer.title`,
  `product_review.reviewExtension.order.orderCustomer`.`vat_ids` as `product_review.reviewExtension.order.orderCustomer.vatIds`,
  `product_review.reviewExtension.order.orderCustomer`.`customer_number` as `product_review.reviewExtension.order.orderCustomer.customerNumber`,
  `product_review.reviewExtension.order.orderCustomer`.`custom_fields` as `product_review.reviewExtension.order.orderCustomer.customFields`,
  `product_review.reviewExtension.order.orderCustomer`.`remote_address` as `product_review.reviewExtension.order.orderCustomer.remoteAddress`,
  `product_review.reviewExtension.order.orderCustomer`.`created_at` as `product_review.reviewExtension.order.orderCustomer.createdAt`,
  `product_review.reviewExtension.order.orderCustomer`.`updated_at` as `product_review.reviewExtension.order.orderCustomer.updatedAt`,
  `product_review.reviewExtension.order`.`item_rounding` as `product_review.reviewExtension.order.itemRounding`,
  `product_review.reviewExtension.order`.`total_rounding` as `product_review.reviewExtension.order.totalRounding`,
  `product_review.reviewExtension.order`.`created_at` as `product_review.reviewExtension.order.createdAt`,
  `product_review.reviewExtension.order`.`updated_at` as `product_review.reviewExtension.order.updatedAt`,
  `product_review.reviewExtension.media`.`id` as `product_review.reviewExtension.media.id`,
  `product_review.reviewExtension.media`.`user_id` as `product_review.reviewExtension.media.userId`,
  `product_review.reviewExtension.media`.`media_folder_id` as `product_review.reviewExtension.media.mediaFolderId`,
  `product_review.reviewExtension.media`.`mime_type` as `product_review.reviewExtension.media.mimeType`,
  `product_review.reviewExtension.media`.`file_extension` as `product_review.reviewExtension.media.fileExtension`,
  `product_review.reviewExtension.media`.`uploaded_at` as `product_review.reviewExtension.media.uploadedAt`,
  `product_review.reviewExtension.media`.`file_name` as `product_review.reviewExtension.media.fileName`,
  `product_review.reviewExtension.media`.`file_size` as `product_review.reviewExtension.media.fileSize`,
  `product_review.reviewExtension.media`.`media_type` as `product_review.reviewExtension.media.mediaTypeRaw`,
  `product_review.reviewExtension.media`.`meta_data` as `product_review.reviewExtension.media.metaData`,
  `product_review.reviewExtension.media`.`config` as `product_review.reviewExtension.media.config`,
  `product_review.reviewExtension.media`.`path` as `product_review.reviewExtension.media.path`,
  `product_review.reviewExtension.media`.`private` as `product_review.reviewExtension.media.private`,
  `product_review.reviewExtension.media`.`thumbnails_ro` as `product_review.reviewExtension.media.thumbnailsRo`,
  `product_review.reviewExtension.media`.`created_at` as `product_review.reviewExtension.media.createdAt`,
  `product_review.reviewExtension.media`.`updated_at` as `product_review.reviewExtension.media.updatedAt`,
  `product_review.reviewExtension.media.translation.override_1.title`,
  `product_review.reviewExtension.media.translation.title`,
  COALESCE(
    `product_review.reviewExtension.media.translation.override_1.title`,
    `product_review.reviewExtension.media.translation.title`
  ) as `product_review.reviewExtension.media.title`,
  `product_review.reviewExtension.media.translation.override_1.alt`,
  `product_review.reviewExtension.media.translation.alt`,
  COALESCE(
    `product_review.reviewExtension.media.translation.override_1.alt`,
    `product_review.reviewExtension.media.translation.alt`
  ) as `product_review.reviewExtension.media.alt`,
  `product_review.reviewExtension.media.translation.override_1.customFields`,
  `product_review.reviewExtension.media.translation.customFields`,
  COALESCE(
    `product_review.reviewExtension.media.translation.override_1.customFields`,
    `product_review.reviewExtension.media.translation.customFields`
  ) as `product_review.reviewExtension.media.customFields`,
  `product_review.reviewExtension`.`created_at` as `product_review.reviewExtension.createdAt`,
  `product_review.reviewExtension`.`updated_at` as `product_review.reviewExtension.updatedAt`
FROM
  `product_review`
  LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id`
  AND `product_review`.`product_version_id` = `product_review.product`.`version_id`
  LEFT JOIN `fourtwosix_review_extension` `product_review.reviewExtension` ON `product_review`.`id` = `product_review.reviewExtension`.`review_id`
  LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id`
  AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id`
  LEFT JOIN `order` `product_review.reviewExtension.order` ON `product_review.reviewExtension`.`order_id` = `product_review.reviewExtension.order`.`id`
  AND `product_review.reviewExtension.order`.`version_id` = UNHEX(
    "0fa91ce3e96a4bc2be4bd9ce752c3425"
  )
  LEFT JOIN `media` `product_review.reviewExtension.media` ON `product_review.reviewExtension`.`media_id` = `product_review.reviewExtension.media`.`id`
  LEFT JOIN `order_customer` `product_review.reviewExtension.order.orderCustomer` ON `product_review.reviewExtension.order`.`id` = `product_review.reviewExtension.order.orderCustomer`.`order_id`
  AND `product_review.reviewExtension.order`.`version_id` = `product_review.reviewExtension.order.orderCustomer`.`order_version_id`
  LEFT JOIN (
    SELECT
      `product_review.reviewExtension.media.translation`.`media_id`,
      `product_review.reviewExtension.media.translation`.`alt` as `product_review.reviewExtension.media.translation.alt`,
      `product_review.reviewExtension.media.translation.override_1`.`alt` as `product_review.reviewExtension.media.translation.override_1.alt`,
      `product_review.reviewExtension.media.translation`.`title` as `product_review.reviewExtension.media.translation.title`,
      `product_review.reviewExtension.media.translation.override_1`.`title` as `product_review.reviewExtension.media.translation.override_1.title`,
      `product_review.reviewExtension.media.translation`.`custom_fields` as `product_review.reviewExtension.media.translation.customFields`,
      `product_review.reviewExtension.media.translation.override_1`.`custom_fields` as `product_review.reviewExtension.media.translation.override_1.customFields`
    FROM
      `media_translation` `product_review.reviewExtension.media.translation`
      LEFT JOIN `media_translation` `product_review.reviewExtension.media.translation.override_1` ON `product_review.reviewExtension.media.translation`.`media_id` = `product_review.reviewExtension.media.translation.override_1`.`media_id`
      AND `product_review.reviewExtension.media.translation.override_1`.`language_id` = ?
    WHERE
      `product_review.reviewExtension.media.translation`.`language_id` = ?
  ) `product_review.reviewExtension.media.media_translation` ON `product_review.reviewExtension.media.media_translation`.`media_id` = `product_review.reviewExtension.media`.`id`
WHERE
  (
    (
      (`product_review`.`status` = ?)
      AND (
        `product_review.product`.`id` = ?
        OR `product_review.product`.`parent_id` = ?
      )
    )
  )

SELECT `product_review`.`id` as `product_review.id`, `product_review`.`product_id` as `product_review.productId`, `product_review`.`product_version_id` as `product_review.productVersionId`, `product_review`.`customer_id` as `product_review.customerId`, `product_review`.`sales_channel_id` as `product_review.salesChannelId`, `product_review`.`language_id` as `product_review.languageId`, `product_review`.`external_user` as `product_review.externalUser`, `product_review`.`external_email` as `product_review.externalEmail`, `product_review`.`title` as `product_review.title`, `product_review`.`content` as `product_review.content`, `product_review`.`points` as `product_review.points`, `product_review`.`status` as `product_review.status`, `product_review`.`comment` as `product_review.comment`, `product_review`.`custom_fields` as `product_review.customFields`, `product_review`.`created_at` as `product_review.createdAt`, `product_review`.`updated_at` as `product_review.updatedAt`, `product_review.reviewExtension`.`id` as `product_review.reviewExtension.id`, `product_review.reviewExtension`.`review_id` as `product_review.reviewExtension.reviewId`, `product_review.reviewExtension`.`order_id` as `product_review.reviewExtension.orderId`, `product_review.reviewExtension`.`media_id` as `product_review.reviewExtension.mediaId`, `product_review.reviewExtension.order`.`id` as `product_review.reviewExtension.order.id`, `product_review.reviewExtension.order`.`version_id` as `product_review.reviewExtension.order.versionId`, `product_review.reviewExtension.order`.`auto_increment` as `product_review.reviewExtension.order.autoIncrement`, `product_review.reviewExtension.order`.`order_number` as `product_review.reviewExtension.order.orderNumber`, `product_review.reviewExtension.order`.`billing_address_id` as `product_review.reviewExtension.order.billingAddressId`, `product_review.reviewExtension.order`.`billing_address_version_id` as `product_review.reviewExtension.order.billingAddressVersionId`, `product_review.reviewExtension.order`.`currency_id` as `product_review.reviewExtension.order.currencyId`, `product_review.reviewExtension.order`.`language_id` as `product_review.reviewExtension.order.languageId`, `product_review.reviewExtension.order`.`sales_channel_id` as `product_review.reviewExtension.order.salesChannelId`, `product_review.reviewExtension.order`.`order_date_time` as `product_review.reviewExtension.order.orderDateTime`, `product_review.reviewExtension.order`.`order_date` as `product_review.reviewExtension.order.orderDate`, `product_review.reviewExtension.order`.`price` as `product_review.reviewExtension.order.price`, `product_review.reviewExtension.order`.`amount_total` as `product_review.reviewExtension.order.amountTotal`, `product_review.reviewExtension.order`.`amount_net` as `product_review.reviewExtension.order.amountNet`, `product_review.reviewExtension.order`.`position_price` as `product_review.reviewExtension.order.positionPrice`, `product_review.reviewExtension.order`.`tax_status` as `product_review.reviewExtension.order.taxStatus`, `product_review.reviewExtension.order`.`shipping_costs` as `product_review.reviewExtension.order.shippingCosts`, `product_review.reviewExtension.order`.`shipping_total` as `product_review.reviewExtension.order.shippingTotal`, `product_review.reviewExtension.order`.`currency_factor` as `product_review.reviewExtension.order.currencyFactor`, `product_review.reviewExtension.order`.`deep_link_code` as `product_review.reviewExtension.order.deepLinkCode`, `product_review.reviewExtension.order`.`affiliate_code` as `product_review.reviewExtension.order.affiliateCode`, `product_review.reviewExtension.order`.`campaign_code` as `product_review.reviewExtension.order.campaignCode`, `product_review.reviewExtension.order`.`customer_comment` as `product_review.reviewExtension.order.customerComment`, `product_review.reviewExtension.order`.`source` as `product_review.reviewExtension.order.source`, `product_review.reviewExtension.order`.`state_id` as `product_review.reviewExtension.order.stateId`, `product_review.reviewExtension.order`.`rule_ids` as `product_review.reviewExtension.order.ruleIds`, `product_review.reviewExtension.order`.`custom_fields` as `product_review.reviewExtension.order.customFields`, `product_review.reviewExtension.order`.`created_by_id` as `product_review.reviewExtension.order.createdById`, `product_review.reviewExtension.order`.`updated_by_id` as `product_review.reviewExtension.order.updatedById`, `product_review.reviewExtension.order.orderCustomer`.`id` as `product_review.reviewExtension.order.orderCustomer.id`, `product_review.reviewExtension.order.orderCustomer`.`version_id` as `product_review.reviewExtension.order.orderCustomer.versionId`, `product_review.reviewExtension.order.orderCustomer`.`customer_id` as `product_review.reviewExtension.order.orderCustomer.customerId`, `product_review.reviewExtension.order.orderCustomer`.`order_id` as `product_review.reviewExtension.order.orderCustomer.orderId`, `product_review.reviewExtension.order.orderCustomer`.`order_version_id` as `product_review.reviewExtension.order.orderCustomer.orderVersionId`, `product_review.reviewExtension.order.orderCustomer`.`email` as `product_review.reviewExtension.order.orderCustomer.email`, `product_review.reviewExtension.order.orderCustomer`.`salutation_id` as `product_review.reviewExtension.order.orderCustomer.salutationId`, `product_review.reviewExtension.order.orderCustomer`.`first_name` as `product_review.reviewExtension.order.orderCustomer.firstName`, `product_review.reviewExtension.order.orderCustomer`.`last_name` as `product_review.reviewExtension.order.orderCustomer.lastName`, `product_review.reviewExtension.order.orderCustomer`.`company` as `product_review.reviewExtension.order.orderCustomer.company`, `product_review.reviewExtension.order.orderCustomer`.`title` as `product_review.reviewExtension.order.orderCustomer.title`, `product_review.reviewExtension.order.orderCustomer`.`vat_ids` as `product_review.reviewExtension.order.orderCustomer.vatIds`, `product_review.reviewExtension.order.orderCustomer`.`customer_number` as `product_review.reviewExtension.order.orderCustomer.customerNumber`, `product_review.reviewExtension.order.orderCustomer`.`custom_fields` as `product_review.reviewExtension.order.orderCustomer.customFields`, `product_review.reviewExtension.order.orderCustomer`.`remote_address` as `product_review.reviewExtension.order.orderCustomer.remoteAddress`, `product_review.reviewExtension.order.orderCustomer`.`created_at` as `product_review.reviewExtension.order.orderCustomer.createdAt`, `product_review.reviewExtension.order.orderCustomer`.`updated_at` as `product_review.reviewExtension.order.orderCustomer.updatedAt`, `product_review.reviewExtension.order`.`item_rounding` as `product_review.reviewExtension.order.itemRounding`, `product_review.reviewExtension.order`.`total_rounding` as `product_review.reviewExtension.order.totalRounding`, `product_review.reviewExtension.order`.`created_at` as `product_review.reviewExtension.order.createdAt`, `product_review.reviewExtension.order`.`updated_at` as `product_review.reviewExtension.order.updatedAt`, `product_review.reviewExtension.media`.`id` as `product_review.reviewExtension.media.id`, `product_review.reviewExtension.media`.`user_id` as `product_review.reviewExtension.media.userId`, `product_review.reviewExtension.media`.`media_folder_id` as `product_review.reviewExtension.media.mediaFolderId`, `product_review.reviewExtension.media`.`mime_type` as `product_review.reviewExtension.media.mimeType`, `product_review.reviewExtension.media`.`file_extension` as `product_review.reviewExtension.media.fileExtension`, `product_review.reviewExtension.media`.`uploaded_at` as `product_review.reviewExtension.media.uploadedAt`, `product_review.reviewExtension.media`.`file_name` as `product_review.reviewExtension.media.fileName`, `product_review.reviewExtension.media`.`file_size` as `product_review.reviewExtension.media.fileSize`, `product_review.reviewExtension.media`.`media_type` as `product_review.reviewExtension.media.mediaTypeRaw`, `product_review.reviewExtension.media`.`meta_data` as `product_review.reviewExtension.media.metaData`, `product_review.reviewExtension.media`.`config` as `product_review.reviewExtension.media.config`, `product_review.reviewExtension.media`.`path` as `product_review.reviewExtension.media.path`, `product_review.reviewExtension.media`.`private` as `product_review.reviewExtension.media.private`, `product_review.reviewExtension.media`.`thumbnails_ro` as `product_review.reviewExtension.media.thumbnailsRo`, `product_review.reviewExtension.media`.`created_at` as `product_review.reviewExtension.media.createdAt`, `product_review.reviewExtension.media`.`updated_at` as `product_review.reviewExtension.media.updatedAt`, `product_review.reviewExtension.media.translation.override_1.title`, `product_review.reviewExtension.media.translation.title`, COALESCE(`product_review.reviewExtension.media.translation.override_1.title`,`product_review.reviewExtension.media.translation.title`) as `product_review.reviewExtension.media.title`, `product_review.reviewExtension.media.translation.override_1.alt`, `product_review.reviewExtension.media.translation.alt`, COALESCE(`product_review.reviewExtension.media.translation.override_1.alt`,`product_review.reviewExtension.media.translation.alt`) as `product_review.reviewExtension.media.alt`, `product_review.reviewExtension.media.translation.override_1.customFields`, `product_review.reviewExtension.media.translation.customFields`, COALESCE(`product_review.reviewExtension.media.translation.override_1.customFields`,`product_review.reviewExtension.media.translation.customFields`) as `product_review.reviewExtension.media.customFields`, `product_review.reviewExtension`.`created_at` as `product_review.reviewExtension.createdAt`, `product_review.reviewExtension`.`updated_at` as `product_review.reviewExtension.updatedAt` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `fourtwosix_review_extension` `product_review.reviewExtension` ON `product_review`.`id` = `product_review.reviewExtension`.`review_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` LEFT JOIN `order` `product_review.reviewExtension.order` ON `product_review.reviewExtension`.`order_id` = `product_review.reviewExtension.order`.`id` AND `product_review.reviewExtension.order`.`version_id` = UNHEX("0fa91ce3e96a4bc2be4bd9ce752c3425") LEFT JOIN `media` `product_review.reviewExtension.media` ON `product_review.reviewExtension`.`media_id` = `product_review.reviewExtension.media`.`id` LEFT JOIN `order_customer` `product_review.reviewExtension.order.orderCustomer` ON `product_review.reviewExtension.order`.`id` = `product_review.reviewExtension.order.orderCustomer`.`order_id` AND `product_review.reviewExtension.order`.`version_id` = `product_review.reviewExtension.order.orderCustomer`.`order_version_id` LEFT JOIN (SELECT `product_review.reviewExtension.media.translation`.`media_id`, `product_review.reviewExtension.media.translation`.`alt` as `product_review.reviewExtension.media.translation.alt`, `product_review.reviewExtension.media.translation.override_1`.`alt` as `product_review.reviewExtension.media.translation.override_1.alt`, `product_review.reviewExtension.media.translation`.`title` as `product_review.reviewExtension.media.translation.title`, `product_review.reviewExtension.media.translation.override_1`.`title` as `product_review.reviewExtension.media.translation.override_1.title`, `product_review.reviewExtension.media.translation`.`custom_fields` as `product_review.reviewExtension.media.translation.customFields`, `product_review.reviewExtension.media.translation.override_1`.`custom_fields` as `product_review.reviewExtension.media.translation.override_1.customFields` FROM `media_translation` `product_review.reviewExtension.media.translation` LEFT JOIN `media_translation` `product_review.reviewExtension.media.translation.override_1` ON `product_review.reviewExtension.media.translation`.`media_id` = `product_review.reviewExtension.media.translation.override_1`.`media_id` AND `product_review.reviewExtension.media.translation.override_1`.`language_id` = 0xDE44571DDC4E4D0095C01AF6EE299351 WHERE `product_review.reviewExtension.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_review.reviewExtension.media.media_translation` ON `product_review.reviewExtension.media.media_translation`.`media_id` = `product_review.reviewExtension.media`.`id` WHERE (((`product_review`.`status` = 1) AND (`product_review.product`.`id` = 0x79FD180CFC7946328C9B9A47EF722FDE OR `product_review.product`.`parent_id` = 0x79FD180CFC7946328C9B9A47EF722FDE)));

# 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)