Symfony Profiler

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

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

SELECT
  `blur_elysium_slides`.`id` as `blur_elysium_slides.id`,
  `blur_elysium_slides`.`product_id` as `blur_elysium_slides.productId`,
  `blur_elysium_slides.product`.`id` as `blur_elysium_slides.product.id`,
  `blur_elysium_slides.product`.`version_id` as `blur_elysium_slides.product.versionId`,
  `blur_elysium_slides.product`.`parent_id` as `blur_elysium_slides.product.parentId`,
  `blur_elysium_slides.product`.`parent_version_id` as `blur_elysium_slides.product.parentVersionId`,
  COALESCE(
    `blur_elysium_slides.product`.`product_manufacturer_id`,
    `blur_elysium_slides.product.parent`.`product_manufacturer_id`
  ) as `blur_elysium_slides.product.manufacturerId`,
  COALESCE(
    `blur_elysium_slides.product`.`product_manufacturer_version_id`,
    `blur_elysium_slides.product.parent`.`product_manufacturer_version_id`
  ) as `blur_elysium_slides.product.productManufacturerVersionId`,
  COALESCE(
    `blur_elysium_slides.product`.`unit_id`,
    `blur_elysium_slides.product.parent`.`unit_id`
  ) as `blur_elysium_slides.product.unitId`,
  COALESCE(
    `blur_elysium_slides.product`.`tax_id`,
    `blur_elysium_slides.product.parent`.`tax_id`
  ) as `blur_elysium_slides.product.taxId`,
  COALESCE(
    `blur_elysium_slides.product`.`product_media_id`,
    `blur_elysium_slides.product.parent`.`product_media_id`
  ) as `blur_elysium_slides.product.coverId`,
  COALESCE(
    `blur_elysium_slides.product`.`product_media_version_id`,
    `blur_elysium_slides.product.parent`.`product_media_version_id`
  ) as `blur_elysium_slides.product.productMediaVersionId`,
  COALESCE(
    `blur_elysium_slides.product`.`delivery_time_id`,
    `blur_elysium_slides.product.parent`.`delivery_time_id`
  ) as `blur_elysium_slides.product.deliveryTimeId`,
  COALESCE(
    `blur_elysium_slides.product`.`product_feature_set_id`,
    `blur_elysium_slides.product.parent`.`product_feature_set_id`
  ) as `blur_elysium_slides.product.featureSetId`,
  COALESCE(
    `blur_elysium_slides.product`.`canonical_product_id`,
    `blur_elysium_slides.product.parent`.`canonical_product_id`
  ) as `blur_elysium_slides.product.canonicalProductId`,
  COALESCE(
    `blur_elysium_slides.product`.`canonical_product_version_id`,
    `blur_elysium_slides.product.parent`.`canonical_product_version_id`
  ) as `blur_elysium_slides.product.canonicalProductVersionId`,
  COALESCE(
    `blur_elysium_slides.product`.`cms_page_id`,
    `blur_elysium_slides.product.parent`.`cms_page_id`
  ) as `blur_elysium_slides.product.cmsPageId`,
  COALESCE(
    `blur_elysium_slides.product`.`cms_page_version_id`,
    `blur_elysium_slides.product.parent`.`cms_page_version_id`
  ) as `blur_elysium_slides.product.cmsPageVersionId`,
  `blur_elysium_slides.product.parent`.`price` as `blur_elysium_slides.product.price.inherited`,
  COALESCE(
    `blur_elysium_slides.product`.`price`,
    `blur_elysium_slides.product.parent`.`price`
  ) as `blur_elysium_slides.product.price`,
  `blur_elysium_slides.product`.`product_number` as `blur_elysium_slides.product.productNumber`,
  COALESCE(
    `blur_elysium_slides.product`.`restock_time`,
    `blur_elysium_slides.product.parent`.`restock_time`
  ) as `blur_elysium_slides.product.restockTime`,
  `blur_elysium_slides.product`.`auto_increment` as `blur_elysium_slides.product.autoIncrement`,
  COALESCE(
    `blur_elysium_slides.product`.`active`,
    `blur_elysium_slides.product.parent`.`active`
  ) as `blur_elysium_slides.product.active`,
  `blur_elysium_slides.product`.`available` as `blur_elysium_slides.product.available`,
  COALESCE(
    `blur_elysium_slides.product`.`is_closeout`,
    `blur_elysium_slides.product.parent`.`is_closeout`
  ) as `blur_elysium_slides.product.isCloseout`,
  `blur_elysium_slides.product`.`available_stock` as `blur_elysium_slides.product.availableStock`,
  `blur_elysium_slides.product`.`stock` as `blur_elysium_slides.product.stock`,
  `blur_elysium_slides.product`.`display_group` as `blur_elysium_slides.product.displayGroup`,
  `blur_elysium_slides.product.parent`.`variant_listing_config` as `blur_elysium_slides.product.variantListingConfig.inherited`,
  COALESCE(
    `blur_elysium_slides.product`.`variant_listing_config`,
    `blur_elysium_slides.product.parent`.`variant_listing_config`
  ) as `blur_elysium_slides.product.variantListingConfig`,
  `blur_elysium_slides.product`.`variant_restrictions` as `blur_elysium_slides.product.variantRestrictions`,
  COALESCE(
    `blur_elysium_slides.product`.`manufacturer_number`,
    `blur_elysium_slides.product.parent`.`manufacturer_number`
  ) as `blur_elysium_slides.product.manufacturerNumber`,
  COALESCE(
    `blur_elysium_slides.product`.`ean`,
    `blur_elysium_slides.product.parent`.`ean`
  ) as `blur_elysium_slides.product.ean`,
  COALESCE(
    `blur_elysium_slides.product`.`purchase_steps`,
    `blur_elysium_slides.product.parent`.`purchase_steps`
  ) as `blur_elysium_slides.product.purchaseSteps`,
  COALESCE(
    `blur_elysium_slides.product`.`max_purchase`,
    `blur_elysium_slides.product.parent`.`max_purchase`
  ) as `blur_elysium_slides.product.maxPurchase`,
  COALESCE(
    `blur_elysium_slides.product`.`min_purchase`,
    `blur_elysium_slides.product.parent`.`min_purchase`
  ) as `blur_elysium_slides.product.minPurchase`,
  COALESCE(
    `blur_elysium_slides.product`.`purchase_unit`,
    `blur_elysium_slides.product.parent`.`purchase_unit`
  ) as `blur_elysium_slides.product.purchaseUnit`,
  COALESCE(
    `blur_elysium_slides.product`.`reference_unit`,
    `blur_elysium_slides.product.parent`.`reference_unit`
  ) as `blur_elysium_slides.product.referenceUnit`,
  COALESCE(
    `blur_elysium_slides.product`.`shipping_free`,
    `blur_elysium_slides.product.parent`.`shipping_free`
  ) as `blur_elysium_slides.product.shippingFree`,
  `blur_elysium_slides.product.parent`.`purchase_prices` as `blur_elysium_slides.product.purchasePrices.inherited`,
  COALESCE(
    `blur_elysium_slides.product`.`purchase_prices`,
    `blur_elysium_slides.product.parent`.`purchase_prices`
  ) as `blur_elysium_slides.product.purchasePrices`,
  COALESCE(
    `blur_elysium_slides.product`.`mark_as_topseller`,
    `blur_elysium_slides.product.parent`.`mark_as_topseller`
  ) as `blur_elysium_slides.product.markAsTopseller`,
  COALESCE(
    `blur_elysium_slides.product`.`weight`,
    `blur_elysium_slides.product.parent`.`weight`
  ) as `blur_elysium_slides.product.weight`,
  COALESCE(
    `blur_elysium_slides.product`.`width`,
    `blur_elysium_slides.product.parent`.`width`
  ) as `blur_elysium_slides.product.width`,
  COALESCE(
    `blur_elysium_slides.product`.`height`,
    `blur_elysium_slides.product.parent`.`height`
  ) as `blur_elysium_slides.product.height`,
  COALESCE(
    `blur_elysium_slides.product`.`length`,
    `blur_elysium_slides.product.parent`.`length`
  ) as `blur_elysium_slides.product.length`,
  COALESCE(
    `blur_elysium_slides.product`.`release_date`,
    `blur_elysium_slides.product.parent`.`release_date`
  ) as `blur_elysium_slides.product.releaseDate`,
  COALESCE(
    `blur_elysium_slides.product`.`rating_average`,
    `blur_elysium_slides.product.parent`.`rating_average`
  ) as `blur_elysium_slides.product.ratingAverage`,
  `blur_elysium_slides.product.parent`.`category_tree` as `blur_elysium_slides.product.categoryTree.inherited`,
  COALESCE(
    `blur_elysium_slides.product`.`category_tree`,
    `blur_elysium_slides.product.parent`.`category_tree`
  ) as `blur_elysium_slides.product.categoryTree`,
  `blur_elysium_slides.product.parent`.`property_ids` as `blur_elysium_slides.product.propertyIds.inherited`,
  COALESCE(
    `blur_elysium_slides.product`.`property_ids`,
    `blur_elysium_slides.product.parent`.`property_ids`
  ) as `blur_elysium_slides.product.propertyIds`,
  `blur_elysium_slides.product.parent`.`option_ids` as `blur_elysium_slides.product.optionIds.inherited`,
  COALESCE(
    `blur_elysium_slides.product`.`option_ids`,
    `blur_elysium_slides.product.parent`.`option_ids`
  ) as `blur_elysium_slides.product.optionIds`,
  `blur_elysium_slides.product.parent`.`stream_ids` as `blur_elysium_slides.product.streamIds.inherited`,
  COALESCE(
    `blur_elysium_slides.product`.`stream_ids`,
    `blur_elysium_slides.product.parent`.`stream_ids`
  ) as `blur_elysium_slides.product.streamIds`,
  `blur_elysium_slides.product.parent`.`tag_ids` as `blur_elysium_slides.product.tagIds.inherited`,
  COALESCE(
    `blur_elysium_slides.product`.`tag_ids`,
    `blur_elysium_slides.product.parent`.`tag_ids`
  ) as `blur_elysium_slides.product.tagIds`,
  `blur_elysium_slides.product.parent`.`category_ids` as `blur_elysium_slides.product.categoryIds.inherited`,
  COALESCE(
    `blur_elysium_slides.product`.`category_ids`,
    `blur_elysium_slides.product.parent`.`category_ids`
  ) as `blur_elysium_slides.product.categoryIds`,
  `blur_elysium_slides.product`.`child_count` as `blur_elysium_slides.product.childCount`,
  COALESCE(
    `blur_elysium_slides.product`.`custom_field_set_selection_active`,
    `blur_elysium_slides.product.parent`.`custom_field_set_selection_active`
  ) as `blur_elysium_slides.product.customFieldSetSelectionActive`,
  `blur_elysium_slides.product`.`sales` as `blur_elysium_slides.product.sales`,
  `blur_elysium_slides.product`.`states` as `blur_elysium_slides.product.states`,
  `blur_elysium_slides.product.tax`.`id` as `blur_elysium_slides.product.tax.id`,
  `blur_elysium_slides.product.tax`.`tax_rate` as `blur_elysium_slides.product.tax.taxRate`,
  `blur_elysium_slides.product.tax`.`name` as `blur_elysium_slides.product.tax.name`,
  `blur_elysium_slides.product.tax`.`position` as `blur_elysium_slides.product.tax.position`,
  `blur_elysium_slides.product.tax`.`custom_fields` as `blur_elysium_slides.product.tax.customFields`,
  `blur_elysium_slides.product.tax`.`created_at` as `blur_elysium_slides.product.tax.createdAt`,
  `blur_elysium_slides.product.tax`.`updated_at` as `blur_elysium_slides.product.tax.updatedAt`,
  `blur_elysium_slides.product`.`created_at` as `blur_elysium_slides.product.createdAt`,
  `blur_elysium_slides.product`.`updated_at` as `blur_elysium_slides.product.updatedAt`,
  `blur_elysium_slides.product.cover`.`id` as `blur_elysium_slides.product.cover.id`,
  `blur_elysium_slides.product.cover`.`version_id` as `blur_elysium_slides.product.cover.versionId`,
  `blur_elysium_slides.product.cover`.`product_id` as `blur_elysium_slides.product.cover.productId`,
  `blur_elysium_slides.product.cover`.`product_version_id` as `blur_elysium_slides.product.cover.productVersionId`,
  `blur_elysium_slides.product.cover`.`media_id` as `blur_elysium_slides.product.cover.mediaId`,
  `blur_elysium_slides.product.cover`.`position` as `blur_elysium_slides.product.cover.position`,
  `blur_elysium_slides.product.cover.media`.`id` as `blur_elysium_slides.product.cover.media.id`,
  `blur_elysium_slides.product.cover.media`.`user_id` as `blur_elysium_slides.product.cover.media.userId`,
  `blur_elysium_slides.product.cover.media`.`media_folder_id` as `blur_elysium_slides.product.cover.media.mediaFolderId`,
  `blur_elysium_slides.product.cover.media`.`mime_type` as `blur_elysium_slides.product.cover.media.mimeType`,
  `blur_elysium_slides.product.cover.media`.`file_extension` as `blur_elysium_slides.product.cover.media.fileExtension`,
  `blur_elysium_slides.product.cover.media`.`uploaded_at` as `blur_elysium_slides.product.cover.media.uploadedAt`,
  `blur_elysium_slides.product.cover.media`.`file_name` as `blur_elysium_slides.product.cover.media.fileName`,
  `blur_elysium_slides.product.cover.media`.`file_size` as `blur_elysium_slides.product.cover.media.fileSize`,
  `blur_elysium_slides.product.cover.media`.`media_type` as `blur_elysium_slides.product.cover.media.mediaTypeRaw`,
  `blur_elysium_slides.product.cover.media`.`meta_data` as `blur_elysium_slides.product.cover.media.metaData`,
  `blur_elysium_slides.product.cover.media`.`config` as `blur_elysium_slides.product.cover.media.config`,
  `blur_elysium_slides.product.cover.media`.`path` as `blur_elysium_slides.product.cover.media.path`,
  `blur_elysium_slides.product.cover.media`.`private` as `blur_elysium_slides.product.cover.media.private`,
  `blur_elysium_slides.product.cover.media`.`thumbnails_ro` as `blur_elysium_slides.product.cover.media.thumbnailsRo`,
  `blur_elysium_slides.product.cover.media`.`file_hash` as `blur_elysium_slides.product.cover.media.fileHash`,
  `blur_elysium_slides.product.cover.media`.`created_at` as `blur_elysium_slides.product.cover.media.createdAt`,
  `blur_elysium_slides.product.cover.media`.`updated_at` as `blur_elysium_slides.product.cover.media.updatedAt`,
  `blur_elysium_slides.product.cover.media.translation.title`,
  `blur_elysium_slides.product.cover.media.translation.title` as `blur_elysium_slides.product.cover.media.title`,
  `blur_elysium_slides.product.cover.media.translation.alt`,
  `blur_elysium_slides.product.cover.media.translation.alt` as `blur_elysium_slides.product.cover.media.alt`,
  `blur_elysium_slides.product.cover.media.translation.customFields`,
  `blur_elysium_slides.product.cover.media.translation.customFields` as `blur_elysium_slides.product.cover.media.customFields`,
  `blur_elysium_slides.product.cover`.`custom_fields` as `blur_elysium_slides.product.cover.customFields`,
  `blur_elysium_slides.product.cover`.`created_at` as `blur_elysium_slides.product.cover.createdAt`,
  `blur_elysium_slides.product.cover`.`updated_at` as `blur_elysium_slides.product.cover.updatedAt`,
  `blur_elysium_slides.product.translation.metaDescription`,
  `blur_elysium_slides.product.parent.translation.metaDescription`,
  COALESCE(
    `blur_elysium_slides.product.translation.metaDescription`,
    `blur_elysium_slides.product.parent.translation.metaDescription`
  ) as `blur_elysium_slides.product.metaDescription`,
  `blur_elysium_slides.product.translation.name`,
  `blur_elysium_slides.product.parent.translation.name`,
  COALESCE(
    `blur_elysium_slides.product.translation.name`,
    `blur_elysium_slides.product.parent.translation.name`
  ) as `blur_elysium_slides.product.name`,
  `blur_elysium_slides.product.translation.keywords`,
  `blur_elysium_slides.product.parent.translation.keywords`,
  COALESCE(
    `blur_elysium_slides.product.translation.keywords`,
    `blur_elysium_slides.product.parent.translation.keywords`
  ) as `blur_elysium_slides.product.keywords`,
  `blur_elysium_slides.product.translation.description`,
  `blur_elysium_slides.product.parent.translation.description`,
  COALESCE(
    `blur_elysium_slides.product.translation.description`,
    `blur_elysium_slides.product.parent.translation.description`
  ) as `blur_elysium_slides.product.description`,
  `blur_elysium_slides.product.translation.metaTitle`,
  `blur_elysium_slides.product.parent.translation.metaTitle`,
  COALESCE(
    `blur_elysium_slides.product.translation.metaTitle`,
    `blur_elysium_slides.product.parent.translation.metaTitle`
  ) as `blur_elysium_slides.product.metaTitle`,
  `blur_elysium_slides.product.translation.packUnit`,
  `blur_elysium_slides.product.parent.translation.packUnit`,
  COALESCE(
    `blur_elysium_slides.product.translation.packUnit`,
    `blur_elysium_slides.product.parent.translation.packUnit`
  ) as `blur_elysium_slides.product.packUnit`,
  `blur_elysium_slides.product.translation.packUnitPlural`,
  `blur_elysium_slides.product.parent.translation.packUnitPlural`,
  COALESCE(
    `blur_elysium_slides.product.translation.packUnitPlural`,
    `blur_elysium_slides.product.parent.translation.packUnitPlural`
  ) as `blur_elysium_slides.product.packUnitPlural`,
  `blur_elysium_slides.product.translation.customSearchKeywords`,
  `blur_elysium_slides.product.parent.translation.customSearchKeywords`,
  COALESCE(
    `blur_elysium_slides.product.translation.customSearchKeywords`,
    `blur_elysium_slides.product.parent.translation.customSearchKeywords`
  ) as `blur_elysium_slides.product.customSearchKeywords`,
  `blur_elysium_slides.product.translation.slotConfig`,
  `blur_elysium_slides.product.parent.translation.slotConfig`,
  COALESCE(
    `blur_elysium_slides.product.translation.slotConfig`,
    `blur_elysium_slides.product.parent.translation.slotConfig`
  ) as `blur_elysium_slides.product.slotConfig`,
  `blur_elysium_slides.product.translation.customFields`,
  `blur_elysium_slides.product.parent.translation.customFields`,
  COALESCE(
    `blur_elysium_slides.product.translation.customFields`,
    `blur_elysium_slides.product.parent.translation.customFields`
  ) as `blur_elysium_slides.product.customFields`,
  `blur_elysium_slides`.`slide_cover_id` as `blur_elysium_slides.slideCoverId`,
  `blur_elysium_slides.slideCover`.`id` as `blur_elysium_slides.slideCover.id`,
  `blur_elysium_slides.slideCover`.`user_id` as `blur_elysium_slides.slideCover.userId`,
  `blur_elysium_slides.slideCover`.`media_folder_id` as `blur_elysium_slides.slideCover.mediaFolderId`,
  `blur_elysium_slides.slideCover`.`mime_type` as `blur_elysium_slides.slideCover.mimeType`,
  `blur_elysium_slides.slideCover`.`file_extension` as `blur_elysium_slides.slideCover.fileExtension`,
  `blur_elysium_slides.slideCover`.`uploaded_at` as `blur_elysium_slides.slideCover.uploadedAt`,
  `blur_elysium_slides.slideCover`.`file_name` as `blur_elysium_slides.slideCover.fileName`,
  `blur_elysium_slides.slideCover`.`file_size` as `blur_elysium_slides.slideCover.fileSize`,
  `blur_elysium_slides.slideCover`.`media_type` as `blur_elysium_slides.slideCover.mediaTypeRaw`,
  `blur_elysium_slides.slideCover`.`meta_data` as `blur_elysium_slides.slideCover.metaData`,
  `blur_elysium_slides.slideCover`.`config` as `blur_elysium_slides.slideCover.config`,
  `blur_elysium_slides.slideCover`.`path` as `blur_elysium_slides.slideCover.path`,
  `blur_elysium_slides.slideCover`.`private` as `blur_elysium_slides.slideCover.private`,
  `blur_elysium_slides.slideCover`.`thumbnails_ro` as `blur_elysium_slides.slideCover.thumbnailsRo`,
  `blur_elysium_slides.slideCover`.`file_hash` as `blur_elysium_slides.slideCover.fileHash`,
  `blur_elysium_slides.slideCover`.`created_at` as `blur_elysium_slides.slideCover.createdAt`,
  `blur_elysium_slides.slideCover`.`updated_at` as `blur_elysium_slides.slideCover.updatedAt`,
  `blur_elysium_slides.slideCover.translation.title`,
  `blur_elysium_slides.slideCover.translation.title` as `blur_elysium_slides.slideCover.title`,
  `blur_elysium_slides.slideCover.translation.alt`,
  `blur_elysium_slides.slideCover.translation.alt` as `blur_elysium_slides.slideCover.alt`,
  `blur_elysium_slides.slideCover.translation.customFields`,
  `blur_elysium_slides.slideCover.translation.customFields` as `blur_elysium_slides.slideCover.customFields`,
  `blur_elysium_slides`.`slide_cover_mobile_id` as `blur_elysium_slides.slideCoverMobileId`,
  `blur_elysium_slides.slideCoverMobile`.`id` as `blur_elysium_slides.slideCoverMobile.id`,
  `blur_elysium_slides.slideCoverMobile`.`user_id` as `blur_elysium_slides.slideCoverMobile.userId`,
  `blur_elysium_slides.slideCoverMobile`.`media_folder_id` as `blur_elysium_slides.slideCoverMobile.mediaFolderId`,
  `blur_elysium_slides.slideCoverMobile`.`mime_type` as `blur_elysium_slides.slideCoverMobile.mimeType`,
  `blur_elysium_slides.slideCoverMobile`.`file_extension` as `blur_elysium_slides.slideCoverMobile.fileExtension`,
  `blur_elysium_slides.slideCoverMobile`.`uploaded_at` as `blur_elysium_slides.slideCoverMobile.uploadedAt`,
  `blur_elysium_slides.slideCoverMobile`.`file_name` as `blur_elysium_slides.slideCoverMobile.fileName`,
  `blur_elysium_slides.slideCoverMobile`.`file_size` as `blur_elysium_slides.slideCoverMobile.fileSize`,
  `blur_elysium_slides.slideCoverMobile`.`media_type` as `blur_elysium_slides.slideCoverMobile.mediaTypeRaw`,
  `blur_elysium_slides.slideCoverMobile`.`meta_data` as `blur_elysium_slides.slideCoverMobile.metaData`,
  `blur_elysium_slides.slideCoverMobile`.`config` as `blur_elysium_slides.slideCoverMobile.config`,
  `blur_elysium_slides.slideCoverMobile`.`path` as `blur_elysium_slides.slideCoverMobile.path`,
  `blur_elysium_slides.slideCoverMobile`.`private` as `blur_elysium_slides.slideCoverMobile.private`,
  `blur_elysium_slides.slideCoverMobile`.`thumbnails_ro` as `blur_elysium_slides.slideCoverMobile.thumbnailsRo`,
  `blur_elysium_slides.slideCoverMobile`.`file_hash` as `blur_elysium_slides.slideCoverMobile.fileHash`,
  `blur_elysium_slides.slideCoverMobile`.`created_at` as `blur_elysium_slides.slideCoverMobile.createdAt`,
  `blur_elysium_slides.slideCoverMobile`.`updated_at` as `blur_elysium_slides.slideCoverMobile.updatedAt`,
  `blur_elysium_slides.slideCoverMobile.translation.title`,
  `blur_elysium_slides.slideCoverMobile.translation.title` as `blur_elysium_slides.slideCoverMobile.title`,
  `blur_elysium_slides.slideCoverMobile.translation.alt`,
  `blur_elysium_slides.slideCoverMobile.translation.alt` as `blur_elysium_slides.slideCoverMobile.alt`,
  `blur_elysium_slides.slideCoverMobile.translation.customFields`,
  `blur_elysium_slides.slideCoverMobile.translation.customFields` as `blur_elysium_slides.slideCoverMobile.customFields`,
  `blur_elysium_slides`.`slide_cover_tablet_id` as `blur_elysium_slides.slideCoverTabletId`,
  `blur_elysium_slides.slideCoverTablet`.`id` as `blur_elysium_slides.slideCoverTablet.id`,
  `blur_elysium_slides.slideCoverTablet`.`user_id` as `blur_elysium_slides.slideCoverTablet.userId`,
  `blur_elysium_slides.slideCoverTablet`.`media_folder_id` as `blur_elysium_slides.slideCoverTablet.mediaFolderId`,
  `blur_elysium_slides.slideCoverTablet`.`mime_type` as `blur_elysium_slides.slideCoverTablet.mimeType`,
  `blur_elysium_slides.slideCoverTablet`.`file_extension` as `blur_elysium_slides.slideCoverTablet.fileExtension`,
  `blur_elysium_slides.slideCoverTablet`.`uploaded_at` as `blur_elysium_slides.slideCoverTablet.uploadedAt`,
  `blur_elysium_slides.slideCoverTablet`.`file_name` as `blur_elysium_slides.slideCoverTablet.fileName`,
  `blur_elysium_slides.slideCoverTablet`.`file_size` as `blur_elysium_slides.slideCoverTablet.fileSize`,
  `blur_elysium_slides.slideCoverTablet`.`media_type` as `blur_elysium_slides.slideCoverTablet.mediaTypeRaw`,
  `blur_elysium_slides.slideCoverTablet`.`meta_data` as `blur_elysium_slides.slideCoverTablet.metaData`,
  `blur_elysium_slides.slideCoverTablet`.`config` as `blur_elysium_slides.slideCoverTablet.config`,
  `blur_elysium_slides.slideCoverTablet`.`path` as `blur_elysium_slides.slideCoverTablet.path`,
  `blur_elysium_slides.slideCoverTablet`.`private` as `blur_elysium_slides.slideCoverTablet.private`,
  `blur_elysium_slides.slideCoverTablet`.`thumbnails_ro` as `blur_elysium_slides.slideCoverTablet.thumbnailsRo`,
  `blur_elysium_slides.slideCoverTablet`.`file_hash` as `blur_elysium_slides.slideCoverTablet.fileHash`,
  `blur_elysium_slides.slideCoverTablet`.`created_at` as `blur_elysium_slides.slideCoverTablet.createdAt`,
  `blur_elysium_slides.slideCoverTablet`.`updated_at` as `blur_elysium_slides.slideCoverTablet.updatedAt`,
  `blur_elysium_slides.slideCoverTablet.translation.title`,
  `blur_elysium_slides.slideCoverTablet.translation.title` as `blur_elysium_slides.slideCoverTablet.title`,
  `blur_elysium_slides.slideCoverTablet.translation.alt`,
  `blur_elysium_slides.slideCoverTablet.translation.alt` as `blur_elysium_slides.slideCoverTablet.alt`,
  `blur_elysium_slides.slideCoverTablet.translation.customFields`,
  `blur_elysium_slides.slideCoverTablet.translation.customFields` as `blur_elysium_slides.slideCoverTablet.customFields`,
  `blur_elysium_slides`.`slide_cover_video_id` as `blur_elysium_slides.slideCoverVideoId`,
  `blur_elysium_slides.slideCoverVideo`.`id` as `blur_elysium_slides.slideCoverVideo.id`,
  `blur_elysium_slides.slideCoverVideo`.`user_id` as `blur_elysium_slides.slideCoverVideo.userId`,
  `blur_elysium_slides.slideCoverVideo`.`media_folder_id` as `blur_elysium_slides.slideCoverVideo.mediaFolderId`,
  `blur_elysium_slides.slideCoverVideo`.`mime_type` as `blur_elysium_slides.slideCoverVideo.mimeType`,
  `blur_elysium_slides.slideCoverVideo`.`file_extension` as `blur_elysium_slides.slideCoverVideo.fileExtension`,
  `blur_elysium_slides.slideCoverVideo`.`uploaded_at` as `blur_elysium_slides.slideCoverVideo.uploadedAt`,
  `blur_elysium_slides.slideCoverVideo`.`file_name` as `blur_elysium_slides.slideCoverVideo.fileName`,
  `blur_elysium_slides.slideCoverVideo`.`file_size` as `blur_elysium_slides.slideCoverVideo.fileSize`,
  `blur_elysium_slides.slideCoverVideo`.`media_type` as `blur_elysium_slides.slideCoverVideo.mediaTypeRaw`,
  `blur_elysium_slides.slideCoverVideo`.`meta_data` as `blur_elysium_slides.slideCoverVideo.metaData`,
  `blur_elysium_slides.slideCoverVideo`.`config` as `blur_elysium_slides.slideCoverVideo.config`,
  `blur_elysium_slides.slideCoverVideo`.`path` as `blur_elysium_slides.slideCoverVideo.path`,
  `blur_elysium_slides.slideCoverVideo`.`private` as `blur_elysium_slides.slideCoverVideo.private`,
  `blur_elysium_slides.slideCoverVideo`.`thumbnails_ro` as `blur_elysium_slides.slideCoverVideo.thumbnailsRo`,
  `blur_elysium_slides.slideCoverVideo`.`file_hash` as `blur_elysium_slides.slideCoverVideo.fileHash`,
  `blur_elysium_slides.slideCoverVideo`.`created_at` as `blur_elysium_slides.slideCoverVideo.createdAt`,
  `blur_elysium_slides.slideCoverVideo`.`updated_at` as `blur_elysium_slides.slideCoverVideo.updatedAt`,
  `blur_elysium_slides.slideCoverVideo.translation.title`,
  `blur_elysium_slides.slideCoverVideo.translation.title` as `blur_elysium_slides.slideCoverVideo.title`,
  `blur_elysium_slides.slideCoverVideo.translation.alt`,
  `blur_elysium_slides.slideCoverVideo.translation.alt` as `blur_elysium_slides.slideCoverVideo.alt`,
  `blur_elysium_slides.slideCoverVideo.translation.customFields`,
  `blur_elysium_slides.slideCoverVideo.translation.customFields` as `blur_elysium_slides.slideCoverVideo.customFields`,
  `blur_elysium_slides`.`presentation_media_id` as `blur_elysium_slides.presentationMediaId`,
  `blur_elysium_slides.presentationMedia`.`id` as `blur_elysium_slides.presentationMedia.id`,
  `blur_elysium_slides.presentationMedia`.`user_id` as `blur_elysium_slides.presentationMedia.userId`,
  `blur_elysium_slides.presentationMedia`.`media_folder_id` as `blur_elysium_slides.presentationMedia.mediaFolderId`,
  `blur_elysium_slides.presentationMedia`.`mime_type` as `blur_elysium_slides.presentationMedia.mimeType`,
  `blur_elysium_slides.presentationMedia`.`file_extension` as `blur_elysium_slides.presentationMedia.fileExtension`,
  `blur_elysium_slides.presentationMedia`.`uploaded_at` as `blur_elysium_slides.presentationMedia.uploadedAt`,
  `blur_elysium_slides.presentationMedia`.`file_name` as `blur_elysium_slides.presentationMedia.fileName`,
  `blur_elysium_slides.presentationMedia`.`file_size` as `blur_elysium_slides.presentationMedia.fileSize`,
  `blur_elysium_slides.presentationMedia`.`media_type` as `blur_elysium_slides.presentationMedia.mediaTypeRaw`,
  `blur_elysium_slides.presentationMedia`.`meta_data` as `blur_elysium_slides.presentationMedia.metaData`,
  `blur_elysium_slides.presentationMedia`.`config` as `blur_elysium_slides.presentationMedia.config`,
  `blur_elysium_slides.presentationMedia`.`path` as `blur_elysium_slides.presentationMedia.path`,
  `blur_elysium_slides.presentationMedia`.`private` as `blur_elysium_slides.presentationMedia.private`,
  `blur_elysium_slides.presentationMedia`.`thumbnails_ro` as `blur_elysium_slides.presentationMedia.thumbnailsRo`,
  `blur_elysium_slides.presentationMedia`.`file_hash` as `blur_elysium_slides.presentationMedia.fileHash`,
  `blur_elysium_slides.presentationMedia`.`created_at` as `blur_elysium_slides.presentationMedia.createdAt`,
  `blur_elysium_slides.presentationMedia`.`updated_at` as `blur_elysium_slides.presentationMedia.updatedAt`,
  `blur_elysium_slides.presentationMedia.translation.title`,
  `blur_elysium_slides.presentationMedia.translation.title` as `blur_elysium_slides.presentationMedia.title`,
  `blur_elysium_slides.presentationMedia.translation.alt`,
  `blur_elysium_slides.presentationMedia.translation.alt` as `blur_elysium_slides.presentationMedia.alt`,
  `blur_elysium_slides.presentationMedia.translation.customFields`,
  `blur_elysium_slides.presentationMedia.translation.customFields` as `blur_elysium_slides.presentationMedia.customFields`,
  `blur_elysium_slides`.`slide_settings` as `blur_elysium_slides.slideSettings`,
  `blur_elysium_slides`.`start_date` as `blur_elysium_slides.startDate`,
  `blur_elysium_slides`.`end_date` as `blur_elysium_slides.endDate`,
  `blur_elysium_slides`.`created_at` as `blur_elysium_slides.createdAt`,
  `blur_elysium_slides`.`updated_at` as `blur_elysium_slides.updatedAt`,
  `blur_elysium_slides.translation.name`,
  `blur_elysium_slides.translation.name` as `blur_elysium_slides.name`,
  `blur_elysium_slides.translation.title`,
  `blur_elysium_slides.translation.title` as `blur_elysium_slides.title`,
  `blur_elysium_slides.translation.description`,
  `blur_elysium_slides.translation.description` as `blur_elysium_slides.description`,
  `blur_elysium_slides.translation.buttonLabel`,
  `blur_elysium_slides.translation.buttonLabel` as `blur_elysium_slides.buttonLabel`,
  `blur_elysium_slides.translation.url`,
  `blur_elysium_slides.translation.url` as `blur_elysium_slides.url`,
  `blur_elysium_slides.translation.customFields`,
  `blur_elysium_slides.translation.customFields` as `blur_elysium_slides.customFields`
FROM
  `blur_elysium_slides`
  LEFT JOIN `product` `blur_elysium_slides.product` ON `blur_elysium_slides`.`product_id` = `blur_elysium_slides.product`.`id`
  AND `blur_elysium_slides.product`.`version_id` = UNHEX(
    "0fa91ce3e96a4bc2be4bd9ce752c3425"
  )
  LEFT JOIN `media` `blur_elysium_slides.slideCover` ON `blur_elysium_slides`.`slide_cover_id` = `blur_elysium_slides.slideCover`.`id`
  LEFT JOIN `media` `blur_elysium_slides.slideCoverMobile` ON `blur_elysium_slides`.`slide_cover_mobile_id` = `blur_elysium_slides.slideCoverMobile`.`id`
  LEFT JOIN `media` `blur_elysium_slides.slideCoverTablet` ON `blur_elysium_slides`.`slide_cover_tablet_id` = `blur_elysium_slides.slideCoverTablet`.`id`
  LEFT JOIN `media` `blur_elysium_slides.slideCoverVideo` ON `blur_elysium_slides`.`slide_cover_video_id` = `blur_elysium_slides.slideCoverVideo`.`id`
  LEFT JOIN `media` `blur_elysium_slides.presentationMedia` ON `blur_elysium_slides`.`presentation_media_id` = `blur_elysium_slides.presentationMedia`.`id`
  LEFT JOIN (
    SELECT
      `blur_elysium_slides.translation`.`blur_elysium_slides_id`,
      `blur_elysium_slides.translation`.`name` as `blur_elysium_slides.translation.name`,
      `blur_elysium_slides.translation`.`title` as `blur_elysium_slides.translation.title`,
      `blur_elysium_slides.translation`.`description` as `blur_elysium_slides.translation.description`,
      `blur_elysium_slides.translation`.`button_label` as `blur_elysium_slides.translation.buttonLabel`,
      `blur_elysium_slides.translation`.`url` as `blur_elysium_slides.translation.url`,
      `blur_elysium_slides.translation`.`custom_fields` as `blur_elysium_slides.translation.customFields`
    FROM
      `blur_elysium_slides_translation` `blur_elysium_slides.translation`
    WHERE
      `blur_elysium_slides.translation`.`language_id` = ?
  ) `blur_elysium_slides.blur_elysium_slides_translation` ON `blur_elysium_slides.blur_elysium_slides_translation`.`blur_elysium_slides_id` = `blur_elysium_slides`.`id`
  LEFT JOIN `product` `blur_elysium_slides.product.parent` ON `blur_elysium_slides.product`.`parent_id` = `blur_elysium_slides.product.parent`.`id`
  AND `blur_elysium_slides.product`.`parent_version_id` = `blur_elysium_slides.product.parent`.`version_id`
  LEFT JOIN `tax` `blur_elysium_slides.product.tax` ON `blur_elysium_slides.product`.`tax` = `blur_elysium_slides.product.tax`.`id`
  LEFT JOIN `product_media` `blur_elysium_slides.product.cover` ON `blur_elysium_slides.product`.`cover` = `blur_elysium_slides.product.cover`.`id`
  AND IFNULL(
    `blur_elysium_slides.product`.`product_media_version_id`,
    `blur_elysium_slides.product.parent`.`product_media_version_id`
  ) = `blur_elysium_slides.product.cover`.`version_id`
  LEFT JOIN (
    SELECT
      `blur_elysium_slides.product.translation`.`product_id`,
      `blur_elysium_slides.product.translation`.`product_version_id`,
      `blur_elysium_slides.product.translation`.`meta_description` as `blur_elysium_slides.product.translation.metaDescription`,
      `blur_elysium_slides.product.translation`.`name` as `blur_elysium_slides.product.translation.name`,
      `blur_elysium_slides.product.translation`.`keywords` as `blur_elysium_slides.product.translation.keywords`,
      `blur_elysium_slides.product.translation`.`description` as `blur_elysium_slides.product.translation.description`,
      `blur_elysium_slides.product.translation`.`meta_title` as `blur_elysium_slides.product.translation.metaTitle`,
      `blur_elysium_slides.product.translation`.`pack_unit` as `blur_elysium_slides.product.translation.packUnit`,
      `blur_elysium_slides.product.translation`.`pack_unit_plural` as `blur_elysium_slides.product.translation.packUnitPlural`,
      `blur_elysium_slides.product.translation`.`custom_fields` as `blur_elysium_slides.product.translation.customFields`,
      `blur_elysium_slides.product.translation`.`slot_config` as `blur_elysium_slides.product.translation.slotConfig`,
      `blur_elysium_slides.product.translation`.`custom_search_keywords` as `blur_elysium_slides.product.translation.customSearchKeywords`
    FROM
      `product_translation` `blur_elysium_slides.product.translation`
    WHERE
      `blur_elysium_slides.product.translation`.`language_id` = ?
  ) `blur_elysium_slides.product.product_translation` ON `blur_elysium_slides.product.product_translation`.`product_id` = `blur_elysium_slides.product`.`id`
  AND `blur_elysium_slides.product.product_translation`.`product_version_id` = `blur_elysium_slides.product`.`version_id`
  LEFT JOIN (
    SELECT
      `blur_elysium_slides.product.parent.translation`.`product_id`,
      `blur_elysium_slides.product.parent.translation`.`product_version_id`,
      `blur_elysium_slides.product.parent.translation`.`meta_description` as `blur_elysium_slides.product.parent.translation.metaDescription`,
      `blur_elysium_slides.product.parent.translation`.`name` as `blur_elysium_slides.product.parent.translation.name`,
      `blur_elysium_slides.product.parent.translation`.`keywords` as `blur_elysium_slides.product.parent.translation.keywords`,
      `blur_elysium_slides.product.parent.translation`.`description` as `blur_elysium_slides.product.parent.translation.description`,
      `blur_elysium_slides.product.parent.translation`.`meta_title` as `blur_elysium_slides.product.parent.translation.metaTitle`,
      `blur_elysium_slides.product.parent.translation`.`pack_unit` as `blur_elysium_slides.product.parent.translation.packUnit`,
      `blur_elysium_slides.product.parent.translation`.`pack_unit_plural` as `blur_elysium_slides.product.parent.translation.packUnitPlural`,
      `blur_elysium_slides.product.parent.translation`.`custom_fields` as `blur_elysium_slides.product.parent.translation.customFields`,
      `blur_elysium_slides.product.parent.translation`.`slot_config` as `blur_elysium_slides.product.parent.translation.slotConfig`,
      `blur_elysium_slides.product.parent.translation`.`custom_search_keywords` as `blur_elysium_slides.product.parent.translation.customSearchKeywords`
    FROM
      `product_translation` `blur_elysium_slides.product.parent.translation`
    WHERE
      `blur_elysium_slides.product.parent.translation`.`language_id` = ?
  ) `blur_elysium_slides.product.parent.product_translation` ON `blur_elysium_slides.product.parent.product_translation`.`product_id` = `blur_elysium_slides.product.parent`.`id`
  AND `blur_elysium_slides.product.parent.product_translation`.`product_version_id` = `blur_elysium_slides.product.parent`.`version_id`
  LEFT JOIN `media` `blur_elysium_slides.product.cover.media` ON `blur_elysium_slides.product.cover`.`media_id` = `blur_elysium_slides.product.cover.media`.`id`
  LEFT JOIN (
    SELECT
      `blur_elysium_slides.product.cover.media.translation`.`media_id`,
      `blur_elysium_slides.product.cover.media.translation`.`alt` as `blur_elysium_slides.product.cover.media.translation.alt`,
      `blur_elysium_slides.product.cover.media.translation`.`title` as `blur_elysium_slides.product.cover.media.translation.title`,
      `blur_elysium_slides.product.cover.media.translation`.`custom_fields` as `blur_elysium_slides.product.cover.media.translation.customFields`
    FROM
      `media_translation` `blur_elysium_slides.product.cover.media.translation`
    WHERE
      `blur_elysium_slides.product.cover.media.translation`.`language_id` = ?
  ) `blur_elysium_slides.product.cover.media.media_translation` ON `blur_elysium_slides.product.cover.media.media_translation`.`media_id` = `blur_elysium_slides.product.cover.media`.`id`
  LEFT JOIN (
    SELECT
      `blur_elysium_slides.slideCover.translation`.`media_id`,
      `blur_elysium_slides.slideCover.translation`.`alt` as `blur_elysium_slides.slideCover.translation.alt`,
      `blur_elysium_slides.slideCover.translation`.`title` as `blur_elysium_slides.slideCover.translation.title`,
      `blur_elysium_slides.slideCover.translation`.`custom_fields` as `blur_elysium_slides.slideCover.translation.customFields`
    FROM
      `media_translation` `blur_elysium_slides.slideCover.translation`
    WHERE
      `blur_elysium_slides.slideCover.translation`.`language_id` = ?
  ) `blur_elysium_slides.slideCover.media_translation` ON `blur_elysium_slides.slideCover.media_translation`.`media_id` = `blur_elysium_slides.slideCover`.`id`
  LEFT JOIN (
    SELECT
      `blur_elysium_slides.slideCoverMobile.translation`.`media_id`,
      `blur_elysium_slides.slideCoverMobile.translation`.`alt` as `blur_elysium_slides.slideCoverMobile.translation.alt`,
      `blur_elysium_slides.slideCoverMobile.translation`.`title` as `blur_elysium_slides.slideCoverMobile.translation.title`,
      `blur_elysium_slides.slideCoverMobile.translation`.`custom_fields` as `blur_elysium_slides.slideCoverMobile.translation.customFields`
    FROM
      `media_translation` `blur_elysium_slides.slideCoverMobile.translation`
    WHERE
      `blur_elysium_slides.slideCoverMobile.translation`.`language_id` = ?
  ) `blur_elysium_slides.slideCoverMobile.media_translation` ON `blur_elysium_slides.slideCoverMobile.media_translation`.`media_id` = `blur_elysium_slides.slideCoverMobile`.`id`
  LEFT JOIN (
    SELECT
      `blur_elysium_slides.slideCoverTablet.translation`.`media_id`,
      `blur_elysium_slides.slideCoverTablet.translation`.`alt` as `blur_elysium_slides.slideCoverTablet.translation.alt`,
      `blur_elysium_slides.slideCoverTablet.translation`.`title` as `blur_elysium_slides.slideCoverTablet.translation.title`,
      `blur_elysium_slides.slideCoverTablet.translation`.`custom_fields` as `blur_elysium_slides.slideCoverTablet.translation.customFields`
    FROM
      `media_translation` `blur_elysium_slides.slideCoverTablet.translation`
    WHERE
      `blur_elysium_slides.slideCoverTablet.translation`.`language_id` = ?
  ) `blur_elysium_slides.slideCoverTablet.media_translation` ON `blur_elysium_slides.slideCoverTablet.media_translation`.`media_id` = `blur_elysium_slides.slideCoverTablet`.`id`
  LEFT JOIN (
    SELECT
      `blur_elysium_slides.slideCoverVideo.translation`.`media_id`,
      `blur_elysium_slides.slideCoverVideo.translation`.`alt` as `blur_elysium_slides.slideCoverVideo.translation.alt`,
      `blur_elysium_slides.slideCoverVideo.translation`.`title` as `blur_elysium_slides.slideCoverVideo.translation.title`,
      `blur_elysium_slides.slideCoverVideo.translation`.`custom_fields` as `blur_elysium_slides.slideCoverVideo.translation.customFields`
    FROM
      `media_translation` `blur_elysium_slides.slideCoverVideo.translation`
    WHERE
      `blur_elysium_slides.slideCoverVideo.translation`.`language_id` = ?
  ) `blur_elysium_slides.slideCoverVideo.media_translation` ON `blur_elysium_slides.slideCoverVideo.media_translation`.`media_id` = `blur_elysium_slides.slideCoverVideo`.`id`
  LEFT JOIN (
    SELECT
      `blur_elysium_slides.presentationMedia.translation`.`media_id`,
      `blur_elysium_slides.presentationMedia.translation`.`alt` as `blur_elysium_slides.presentationMedia.translation.alt`,
      `blur_elysium_slides.presentationMedia.translation`.`title` as `blur_elysium_slides.presentationMedia.translation.title`,
      `blur_elysium_slides.presentationMedia.translation`.`custom_fields` as `blur_elysium_slides.presentationMedia.translation.customFields`
    FROM
      `media_translation` `blur_elysium_slides.presentationMedia.translation`
    WHERE
      `blur_elysium_slides.presentationMedia.translation`.`language_id` = ?
  ) `blur_elysium_slides.presentationMedia.media_translation` ON `blur_elysium_slides.presentationMedia.media_translation`.`media_id` = `blur_elysium_slides.presentationMedia`.`id`
WHERE
  (
    (
      (
        (
          `blur_elysium_slides`.`start_date` <=> ?
          AND `blur_elysium_slides`.`end_date` <=> ?
        )
        OR (
          (
            `blur_elysium_slides`.`start_date` <=> ?
            OR (
              `blur_elysium_slides`.`start_date` <= ?
            )
          )
          AND (
            `blur_elysium_slides`.`end_date` <=> ?
            OR (
              `blur_elysium_slides`.`end_date` >= ?
            )
          )
        )
      )
    )
  )
  AND (
    `blur_elysium_slides`.`id` IN (?, ?, ?, ?, ?, ?)
  )

SELECT `blur_elysium_slides`.`id` as `blur_elysium_slides.id`, `blur_elysium_slides`.`product_id` as `blur_elysium_slides.productId`, `blur_elysium_slides.product`.`id` as `blur_elysium_slides.product.id`, `blur_elysium_slides.product`.`version_id` as `blur_elysium_slides.product.versionId`, `blur_elysium_slides.product`.`parent_id` as `blur_elysium_slides.product.parentId`, `blur_elysium_slides.product`.`parent_version_id` as `blur_elysium_slides.product.parentVersionId`, COALESCE(`blur_elysium_slides.product`.`product_manufacturer_id`, `blur_elysium_slides.product.parent`.`product_manufacturer_id`) as `blur_elysium_slides.product.manufacturerId`, COALESCE(`blur_elysium_slides.product`.`product_manufacturer_version_id`, `blur_elysium_slides.product.parent`.`product_manufacturer_version_id`) as `blur_elysium_slides.product.productManufacturerVersionId`, COALESCE(`blur_elysium_slides.product`.`unit_id`, `blur_elysium_slides.product.parent`.`unit_id`) as `blur_elysium_slides.product.unitId`, COALESCE(`blur_elysium_slides.product`.`tax_id`, `blur_elysium_slides.product.parent`.`tax_id`) as `blur_elysium_slides.product.taxId`, COALESCE(`blur_elysium_slides.product`.`product_media_id`, `blur_elysium_slides.product.parent`.`product_media_id`) as `blur_elysium_slides.product.coverId`, COALESCE(`blur_elysium_slides.product`.`product_media_version_id`, `blur_elysium_slides.product.parent`.`product_media_version_id`) as `blur_elysium_slides.product.productMediaVersionId`, COALESCE(`blur_elysium_slides.product`.`delivery_time_id`, `blur_elysium_slides.product.parent`.`delivery_time_id`) as `blur_elysium_slides.product.deliveryTimeId`, COALESCE(`blur_elysium_slides.product`.`product_feature_set_id`, `blur_elysium_slides.product.parent`.`product_feature_set_id`) as `blur_elysium_slides.product.featureSetId`, COALESCE(`blur_elysium_slides.product`.`canonical_product_id`, `blur_elysium_slides.product.parent`.`canonical_product_id`) as `blur_elysium_slides.product.canonicalProductId`, COALESCE(`blur_elysium_slides.product`.`canonical_product_version_id`, `blur_elysium_slides.product.parent`.`canonical_product_version_id`) as `blur_elysium_slides.product.canonicalProductVersionId`, COALESCE(`blur_elysium_slides.product`.`cms_page_id`, `blur_elysium_slides.product.parent`.`cms_page_id`) as `blur_elysium_slides.product.cmsPageId`, COALESCE(`blur_elysium_slides.product`.`cms_page_version_id`, `blur_elysium_slides.product.parent`.`cms_page_version_id`) as `blur_elysium_slides.product.cmsPageVersionId`, `blur_elysium_slides.product.parent`.`price` as `blur_elysium_slides.product.price.inherited`, COALESCE(`blur_elysium_slides.product`.`price`, `blur_elysium_slides.product.parent`.`price`) as `blur_elysium_slides.product.price`, `blur_elysium_slides.product`.`product_number` as `blur_elysium_slides.product.productNumber`, COALESCE(`blur_elysium_slides.product`.`restock_time`, `blur_elysium_slides.product.parent`.`restock_time`) as `blur_elysium_slides.product.restockTime`, `blur_elysium_slides.product`.`auto_increment` as `blur_elysium_slides.product.autoIncrement`, COALESCE(`blur_elysium_slides.product`.`active`, `blur_elysium_slides.product.parent`.`active`) as `blur_elysium_slides.product.active`, `blur_elysium_slides.product`.`available` as `blur_elysium_slides.product.available`, COALESCE(`blur_elysium_slides.product`.`is_closeout`, `blur_elysium_slides.product.parent`.`is_closeout`) as `blur_elysium_slides.product.isCloseout`, `blur_elysium_slides.product`.`available_stock` as `blur_elysium_slides.product.availableStock`, `blur_elysium_slides.product`.`stock` as `blur_elysium_slides.product.stock`, `blur_elysium_slides.product`.`display_group` as `blur_elysium_slides.product.displayGroup`, `blur_elysium_slides.product.parent`.`variant_listing_config` as `blur_elysium_slides.product.variantListingConfig.inherited`, COALESCE(`blur_elysium_slides.product`.`variant_listing_config`, `blur_elysium_slides.product.parent`.`variant_listing_config`) as `blur_elysium_slides.product.variantListingConfig`, `blur_elysium_slides.product`.`variant_restrictions` as `blur_elysium_slides.product.variantRestrictions`, COALESCE(`blur_elysium_slides.product`.`manufacturer_number`, `blur_elysium_slides.product.parent`.`manufacturer_number`) as `blur_elysium_slides.product.manufacturerNumber`, COALESCE(`blur_elysium_slides.product`.`ean`, `blur_elysium_slides.product.parent`.`ean`) as `blur_elysium_slides.product.ean`, COALESCE(`blur_elysium_slides.product`.`purchase_steps`, `blur_elysium_slides.product.parent`.`purchase_steps`) as `blur_elysium_slides.product.purchaseSteps`, COALESCE(`blur_elysium_slides.product`.`max_purchase`, `blur_elysium_slides.product.parent`.`max_purchase`) as `blur_elysium_slides.product.maxPurchase`, COALESCE(`blur_elysium_slides.product`.`min_purchase`, `blur_elysium_slides.product.parent`.`min_purchase`) as `blur_elysium_slides.product.minPurchase`, COALESCE(`blur_elysium_slides.product`.`purchase_unit`, `blur_elysium_slides.product.parent`.`purchase_unit`) as `blur_elysium_slides.product.purchaseUnit`, COALESCE(`blur_elysium_slides.product`.`reference_unit`, `blur_elysium_slides.product.parent`.`reference_unit`) as `blur_elysium_slides.product.referenceUnit`, COALESCE(`blur_elysium_slides.product`.`shipping_free`, `blur_elysium_slides.product.parent`.`shipping_free`) as `blur_elysium_slides.product.shippingFree`, `blur_elysium_slides.product.parent`.`purchase_prices` as `blur_elysium_slides.product.purchasePrices.inherited`, COALESCE(`blur_elysium_slides.product`.`purchase_prices`, `blur_elysium_slides.product.parent`.`purchase_prices`) as `blur_elysium_slides.product.purchasePrices`, COALESCE(`blur_elysium_slides.product`.`mark_as_topseller`, `blur_elysium_slides.product.parent`.`mark_as_topseller`) as `blur_elysium_slides.product.markAsTopseller`, COALESCE(`blur_elysium_slides.product`.`weight`, `blur_elysium_slides.product.parent`.`weight`) as `blur_elysium_slides.product.weight`, COALESCE(`blur_elysium_slides.product`.`width`, `blur_elysium_slides.product.parent`.`width`) as `blur_elysium_slides.product.width`, COALESCE(`blur_elysium_slides.product`.`height`, `blur_elysium_slides.product.parent`.`height`) as `blur_elysium_slides.product.height`, COALESCE(`blur_elysium_slides.product`.`length`, `blur_elysium_slides.product.parent`.`length`) as `blur_elysium_slides.product.length`, COALESCE(`blur_elysium_slides.product`.`release_date`, `blur_elysium_slides.product.parent`.`release_date`) as `blur_elysium_slides.product.releaseDate`, COALESCE(`blur_elysium_slides.product`.`rating_average`, `blur_elysium_slides.product.parent`.`rating_average`) as `blur_elysium_slides.product.ratingAverage`, `blur_elysium_slides.product.parent`.`category_tree` as `blur_elysium_slides.product.categoryTree.inherited`, COALESCE(`blur_elysium_slides.product`.`category_tree`, `blur_elysium_slides.product.parent`.`category_tree`) as `blur_elysium_slides.product.categoryTree`, `blur_elysium_slides.product.parent`.`property_ids` as `blur_elysium_slides.product.propertyIds.inherited`, COALESCE(`blur_elysium_slides.product`.`property_ids`, `blur_elysium_slides.product.parent`.`property_ids`) as `blur_elysium_slides.product.propertyIds`, `blur_elysium_slides.product.parent`.`option_ids` as `blur_elysium_slides.product.optionIds.inherited`, COALESCE(`blur_elysium_slides.product`.`option_ids`, `blur_elysium_slides.product.parent`.`option_ids`) as `blur_elysium_slides.product.optionIds`, `blur_elysium_slides.product.parent`.`stream_ids` as `blur_elysium_slides.product.streamIds.inherited`, COALESCE(`blur_elysium_slides.product`.`stream_ids`, `blur_elysium_slides.product.parent`.`stream_ids`) as `blur_elysium_slides.product.streamIds`, `blur_elysium_slides.product.parent`.`tag_ids` as `blur_elysium_slides.product.tagIds.inherited`, COALESCE(`blur_elysium_slides.product`.`tag_ids`, `blur_elysium_slides.product.parent`.`tag_ids`) as `blur_elysium_slides.product.tagIds`, `blur_elysium_slides.product.parent`.`category_ids` as `blur_elysium_slides.product.categoryIds.inherited`, COALESCE(`blur_elysium_slides.product`.`category_ids`, `blur_elysium_slides.product.parent`.`category_ids`) as `blur_elysium_slides.product.categoryIds`, `blur_elysium_slides.product`.`child_count` as `blur_elysium_slides.product.childCount`, COALESCE(`blur_elysium_slides.product`.`custom_field_set_selection_active`, `blur_elysium_slides.product.parent`.`custom_field_set_selection_active`) as `blur_elysium_slides.product.customFieldSetSelectionActive`, `blur_elysium_slides.product`.`sales` as `blur_elysium_slides.product.sales`, `blur_elysium_slides.product`.`states` as `blur_elysium_slides.product.states`, `blur_elysium_slides.product.tax`.`id` as `blur_elysium_slides.product.tax.id`, `blur_elysium_slides.product.tax`.`tax_rate` as `blur_elysium_slides.product.tax.taxRate`, `blur_elysium_slides.product.tax`.`name` as `blur_elysium_slides.product.tax.name`, `blur_elysium_slides.product.tax`.`position` as `blur_elysium_slides.product.tax.position`, `blur_elysium_slides.product.tax`.`custom_fields` as `blur_elysium_slides.product.tax.customFields`, `blur_elysium_slides.product.tax`.`created_at` as `blur_elysium_slides.product.tax.createdAt`, `blur_elysium_slides.product.tax`.`updated_at` as `blur_elysium_slides.product.tax.updatedAt`, `blur_elysium_slides.product`.`created_at` as `blur_elysium_slides.product.createdAt`, `blur_elysium_slides.product`.`updated_at` as `blur_elysium_slides.product.updatedAt`, `blur_elysium_slides.product.cover`.`id` as `blur_elysium_slides.product.cover.id`, `blur_elysium_slides.product.cover`.`version_id` as `blur_elysium_slides.product.cover.versionId`, `blur_elysium_slides.product.cover`.`product_id` as `blur_elysium_slides.product.cover.productId`, `blur_elysium_slides.product.cover`.`product_version_id` as `blur_elysium_slides.product.cover.productVersionId`, `blur_elysium_slides.product.cover`.`media_id` as `blur_elysium_slides.product.cover.mediaId`, `blur_elysium_slides.product.cover`.`position` as `blur_elysium_slides.product.cover.position`, `blur_elysium_slides.product.cover.media`.`id` as `blur_elysium_slides.product.cover.media.id`, `blur_elysium_slides.product.cover.media`.`user_id` as `blur_elysium_slides.product.cover.media.userId`, `blur_elysium_slides.product.cover.media`.`media_folder_id` as `blur_elysium_slides.product.cover.media.mediaFolderId`, `blur_elysium_slides.product.cover.media`.`mime_type` as `blur_elysium_slides.product.cover.media.mimeType`, `blur_elysium_slides.product.cover.media`.`file_extension` as `blur_elysium_slides.product.cover.media.fileExtension`, `blur_elysium_slides.product.cover.media`.`uploaded_at` as `blur_elysium_slides.product.cover.media.uploadedAt`, `blur_elysium_slides.product.cover.media`.`file_name` as `blur_elysium_slides.product.cover.media.fileName`, `blur_elysium_slides.product.cover.media`.`file_size` as `blur_elysium_slides.product.cover.media.fileSize`, `blur_elysium_slides.product.cover.media`.`media_type` as `blur_elysium_slides.product.cover.media.mediaTypeRaw`, `blur_elysium_slides.product.cover.media`.`meta_data` as `blur_elysium_slides.product.cover.media.metaData`, `blur_elysium_slides.product.cover.media`.`config` as `blur_elysium_slides.product.cover.media.config`, `blur_elysium_slides.product.cover.media`.`path` as `blur_elysium_slides.product.cover.media.path`, `blur_elysium_slides.product.cover.media`.`private` as `blur_elysium_slides.product.cover.media.private`, `blur_elysium_slides.product.cover.media`.`thumbnails_ro` as `blur_elysium_slides.product.cover.media.thumbnailsRo`, `blur_elysium_slides.product.cover.media`.`file_hash` as `blur_elysium_slides.product.cover.media.fileHash`, `blur_elysium_slides.product.cover.media`.`created_at` as `blur_elysium_slides.product.cover.media.createdAt`, `blur_elysium_slides.product.cover.media`.`updated_at` as `blur_elysium_slides.product.cover.media.updatedAt`, `blur_elysium_slides.product.cover.media.translation.title`, `blur_elysium_slides.product.cover.media.translation.title` as `blur_elysium_slides.product.cover.media.title`, `blur_elysium_slides.product.cover.media.translation.alt`, `blur_elysium_slides.product.cover.media.translation.alt` as `blur_elysium_slides.product.cover.media.alt`, `blur_elysium_slides.product.cover.media.translation.customFields`, `blur_elysium_slides.product.cover.media.translation.customFields` as `blur_elysium_slides.product.cover.media.customFields`, `blur_elysium_slides.product.cover`.`custom_fields` as `blur_elysium_slides.product.cover.customFields`, `blur_elysium_slides.product.cover`.`created_at` as `blur_elysium_slides.product.cover.createdAt`, `blur_elysium_slides.product.cover`.`updated_at` as `blur_elysium_slides.product.cover.updatedAt`, `blur_elysium_slides.product.translation.metaDescription`, `blur_elysium_slides.product.parent.translation.metaDescription`, COALESCE(`blur_elysium_slides.product.translation.metaDescription`,`blur_elysium_slides.product.parent.translation.metaDescription`) as `blur_elysium_slides.product.metaDescription`, `blur_elysium_slides.product.translation.name`, `blur_elysium_slides.product.parent.translation.name`, COALESCE(`blur_elysium_slides.product.translation.name`,`blur_elysium_slides.product.parent.translation.name`) as `blur_elysium_slides.product.name`, `blur_elysium_slides.product.translation.keywords`, `blur_elysium_slides.product.parent.translation.keywords`, COALESCE(`blur_elysium_slides.product.translation.keywords`,`blur_elysium_slides.product.parent.translation.keywords`) as `blur_elysium_slides.product.keywords`, `blur_elysium_slides.product.translation.description`, `blur_elysium_slides.product.parent.translation.description`, COALESCE(`blur_elysium_slides.product.translation.description`,`blur_elysium_slides.product.parent.translation.description`) as `blur_elysium_slides.product.description`, `blur_elysium_slides.product.translation.metaTitle`, `blur_elysium_slides.product.parent.translation.metaTitle`, COALESCE(`blur_elysium_slides.product.translation.metaTitle`,`blur_elysium_slides.product.parent.translation.metaTitle`) as `blur_elysium_slides.product.metaTitle`, `blur_elysium_slides.product.translation.packUnit`, `blur_elysium_slides.product.parent.translation.packUnit`, COALESCE(`blur_elysium_slides.product.translation.packUnit`,`blur_elysium_slides.product.parent.translation.packUnit`) as `blur_elysium_slides.product.packUnit`, `blur_elysium_slides.product.translation.packUnitPlural`, `blur_elysium_slides.product.parent.translation.packUnitPlural`, COALESCE(`blur_elysium_slides.product.translation.packUnitPlural`,`blur_elysium_slides.product.parent.translation.packUnitPlural`) as `blur_elysium_slides.product.packUnitPlural`, `blur_elysium_slides.product.translation.customSearchKeywords`, `blur_elysium_slides.product.parent.translation.customSearchKeywords`, COALESCE(`blur_elysium_slides.product.translation.customSearchKeywords`,`blur_elysium_slides.product.parent.translation.customSearchKeywords`) as `blur_elysium_slides.product.customSearchKeywords`, `blur_elysium_slides.product.translation.slotConfig`, `blur_elysium_slides.product.parent.translation.slotConfig`, COALESCE(`blur_elysium_slides.product.translation.slotConfig`,`blur_elysium_slides.product.parent.translation.slotConfig`) as `blur_elysium_slides.product.slotConfig`, `blur_elysium_slides.product.translation.customFields`, `blur_elysium_slides.product.parent.translation.customFields`, COALESCE(`blur_elysium_slides.product.translation.customFields`,`blur_elysium_slides.product.parent.translation.customFields`) as `blur_elysium_slides.product.customFields`, `blur_elysium_slides`.`slide_cover_id` as `blur_elysium_slides.slideCoverId`, `blur_elysium_slides.slideCover`.`id` as `blur_elysium_slides.slideCover.id`, `blur_elysium_slides.slideCover`.`user_id` as `blur_elysium_slides.slideCover.userId`, `blur_elysium_slides.slideCover`.`media_folder_id` as `blur_elysium_slides.slideCover.mediaFolderId`, `blur_elysium_slides.slideCover`.`mime_type` as `blur_elysium_slides.slideCover.mimeType`, `blur_elysium_slides.slideCover`.`file_extension` as `blur_elysium_slides.slideCover.fileExtension`, `blur_elysium_slides.slideCover`.`uploaded_at` as `blur_elysium_slides.slideCover.uploadedAt`, `blur_elysium_slides.slideCover`.`file_name` as `blur_elysium_slides.slideCover.fileName`, `blur_elysium_slides.slideCover`.`file_size` as `blur_elysium_slides.slideCover.fileSize`, `blur_elysium_slides.slideCover`.`media_type` as `blur_elysium_slides.slideCover.mediaTypeRaw`, `blur_elysium_slides.slideCover`.`meta_data` as `blur_elysium_slides.slideCover.metaData`, `blur_elysium_slides.slideCover`.`config` as `blur_elysium_slides.slideCover.config`, `blur_elysium_slides.slideCover`.`path` as `blur_elysium_slides.slideCover.path`, `blur_elysium_slides.slideCover`.`private` as `blur_elysium_slides.slideCover.private`, `blur_elysium_slides.slideCover`.`thumbnails_ro` as `blur_elysium_slides.slideCover.thumbnailsRo`, `blur_elysium_slides.slideCover`.`file_hash` as `blur_elysium_slides.slideCover.fileHash`, `blur_elysium_slides.slideCover`.`created_at` as `blur_elysium_slides.slideCover.createdAt`, `blur_elysium_slides.slideCover`.`updated_at` as `blur_elysium_slides.slideCover.updatedAt`, `blur_elysium_slides.slideCover.translation.title`, `blur_elysium_slides.slideCover.translation.title` as `blur_elysium_slides.slideCover.title`, `blur_elysium_slides.slideCover.translation.alt`, `blur_elysium_slides.slideCover.translation.alt` as `blur_elysium_slides.slideCover.alt`, `blur_elysium_slides.slideCover.translation.customFields`, `blur_elysium_slides.slideCover.translation.customFields` as `blur_elysium_slides.slideCover.customFields`, `blur_elysium_slides`.`slide_cover_mobile_id` as `blur_elysium_slides.slideCoverMobileId`, `blur_elysium_slides.slideCoverMobile`.`id` as `blur_elysium_slides.slideCoverMobile.id`, `blur_elysium_slides.slideCoverMobile`.`user_id` as `blur_elysium_slides.slideCoverMobile.userId`, `blur_elysium_slides.slideCoverMobile`.`media_folder_id` as `blur_elysium_slides.slideCoverMobile.mediaFolderId`, `blur_elysium_slides.slideCoverMobile`.`mime_type` as `blur_elysium_slides.slideCoverMobile.mimeType`, `blur_elysium_slides.slideCoverMobile`.`file_extension` as `blur_elysium_slides.slideCoverMobile.fileExtension`, `blur_elysium_slides.slideCoverMobile`.`uploaded_at` as `blur_elysium_slides.slideCoverMobile.uploadedAt`, `blur_elysium_slides.slideCoverMobile`.`file_name` as `blur_elysium_slides.slideCoverMobile.fileName`, `blur_elysium_slides.slideCoverMobile`.`file_size` as `blur_elysium_slides.slideCoverMobile.fileSize`, `blur_elysium_slides.slideCoverMobile`.`media_type` as `blur_elysium_slides.slideCoverMobile.mediaTypeRaw`, `blur_elysium_slides.slideCoverMobile`.`meta_data` as `blur_elysium_slides.slideCoverMobile.metaData`, `blur_elysium_slides.slideCoverMobile`.`config` as `blur_elysium_slides.slideCoverMobile.config`, `blur_elysium_slides.slideCoverMobile`.`path` as `blur_elysium_slides.slideCoverMobile.path`, `blur_elysium_slides.slideCoverMobile`.`private` as `blur_elysium_slides.slideCoverMobile.private`, `blur_elysium_slides.slideCoverMobile`.`thumbnails_ro` as `blur_elysium_slides.slideCoverMobile.thumbnailsRo`, `blur_elysium_slides.slideCoverMobile`.`file_hash` as `blur_elysium_slides.slideCoverMobile.fileHash`, `blur_elysium_slides.slideCoverMobile`.`created_at` as `blur_elysium_slides.slideCoverMobile.createdAt`, `blur_elysium_slides.slideCoverMobile`.`updated_at` as `blur_elysium_slides.slideCoverMobile.updatedAt`, `blur_elysium_slides.slideCoverMobile.translation.title`, `blur_elysium_slides.slideCoverMobile.translation.title` as `blur_elysium_slides.slideCoverMobile.title`, `blur_elysium_slides.slideCoverMobile.translation.alt`, `blur_elysium_slides.slideCoverMobile.translation.alt` as `blur_elysium_slides.slideCoverMobile.alt`, `blur_elysium_slides.slideCoverMobile.translation.customFields`, `blur_elysium_slides.slideCoverMobile.translation.customFields` as `blur_elysium_slides.slideCoverMobile.customFields`, `blur_elysium_slides`.`slide_cover_tablet_id` as `blur_elysium_slides.slideCoverTabletId`, `blur_elysium_slides.slideCoverTablet`.`id` as `blur_elysium_slides.slideCoverTablet.id`, `blur_elysium_slides.slideCoverTablet`.`user_id` as `blur_elysium_slides.slideCoverTablet.userId`, `blur_elysium_slides.slideCoverTablet`.`media_folder_id` as `blur_elysium_slides.slideCoverTablet.mediaFolderId`, `blur_elysium_slides.slideCoverTablet`.`mime_type` as `blur_elysium_slides.slideCoverTablet.mimeType`, `blur_elysium_slides.slideCoverTablet`.`file_extension` as `blur_elysium_slides.slideCoverTablet.fileExtension`, `blur_elysium_slides.slideCoverTablet`.`uploaded_at` as `blur_elysium_slides.slideCoverTablet.uploadedAt`, `blur_elysium_slides.slideCoverTablet`.`file_name` as `blur_elysium_slides.slideCoverTablet.fileName`, `blur_elysium_slides.slideCoverTablet`.`file_size` as `blur_elysium_slides.slideCoverTablet.fileSize`, `blur_elysium_slides.slideCoverTablet`.`media_type` as `blur_elysium_slides.slideCoverTablet.mediaTypeRaw`, `blur_elysium_slides.slideCoverTablet`.`meta_data` as `blur_elysium_slides.slideCoverTablet.metaData`, `blur_elysium_slides.slideCoverTablet`.`config` as `blur_elysium_slides.slideCoverTablet.config`, `blur_elysium_slides.slideCoverTablet`.`path` as `blur_elysium_slides.slideCoverTablet.path`, `blur_elysium_slides.slideCoverTablet`.`private` as `blur_elysium_slides.slideCoverTablet.private`, `blur_elysium_slides.slideCoverTablet`.`thumbnails_ro` as `blur_elysium_slides.slideCoverTablet.thumbnailsRo`, `blur_elysium_slides.slideCoverTablet`.`file_hash` as `blur_elysium_slides.slideCoverTablet.fileHash`, `blur_elysium_slides.slideCoverTablet`.`created_at` as `blur_elysium_slides.slideCoverTablet.createdAt`, `blur_elysium_slides.slideCoverTablet`.`updated_at` as `blur_elysium_slides.slideCoverTablet.updatedAt`, `blur_elysium_slides.slideCoverTablet.translation.title`, `blur_elysium_slides.slideCoverTablet.translation.title` as `blur_elysium_slides.slideCoverTablet.title`, `blur_elysium_slides.slideCoverTablet.translation.alt`, `blur_elysium_slides.slideCoverTablet.translation.alt` as `blur_elysium_slides.slideCoverTablet.alt`, `blur_elysium_slides.slideCoverTablet.translation.customFields`, `blur_elysium_slides.slideCoverTablet.translation.customFields` as `blur_elysium_slides.slideCoverTablet.customFields`, `blur_elysium_slides`.`slide_cover_video_id` as `blur_elysium_slides.slideCoverVideoId`, `blur_elysium_slides.slideCoverVideo`.`id` as `blur_elysium_slides.slideCoverVideo.id`, `blur_elysium_slides.slideCoverVideo`.`user_id` as `blur_elysium_slides.slideCoverVideo.userId`, `blur_elysium_slides.slideCoverVideo`.`media_folder_id` as `blur_elysium_slides.slideCoverVideo.mediaFolderId`, `blur_elysium_slides.slideCoverVideo`.`mime_type` as `blur_elysium_slides.slideCoverVideo.mimeType`, `blur_elysium_slides.slideCoverVideo`.`file_extension` as `blur_elysium_slides.slideCoverVideo.fileExtension`, `blur_elysium_slides.slideCoverVideo`.`uploaded_at` as `blur_elysium_slides.slideCoverVideo.uploadedAt`, `blur_elysium_slides.slideCoverVideo`.`file_name` as `blur_elysium_slides.slideCoverVideo.fileName`, `blur_elysium_slides.slideCoverVideo`.`file_size` as `blur_elysium_slides.slideCoverVideo.fileSize`, `blur_elysium_slides.slideCoverVideo`.`media_type` as `blur_elysium_slides.slideCoverVideo.mediaTypeRaw`, `blur_elysium_slides.slideCoverVideo`.`meta_data` as `blur_elysium_slides.slideCoverVideo.metaData`, `blur_elysium_slides.slideCoverVideo`.`config` as `blur_elysium_slides.slideCoverVideo.config`, `blur_elysium_slides.slideCoverVideo`.`path` as `blur_elysium_slides.slideCoverVideo.path`, `blur_elysium_slides.slideCoverVideo`.`private` as `blur_elysium_slides.slideCoverVideo.private`, `blur_elysium_slides.slideCoverVideo`.`thumbnails_ro` as `blur_elysium_slides.slideCoverVideo.thumbnailsRo`, `blur_elysium_slides.slideCoverVideo`.`file_hash` as `blur_elysium_slides.slideCoverVideo.fileHash`, `blur_elysium_slides.slideCoverVideo`.`created_at` as `blur_elysium_slides.slideCoverVideo.createdAt`, `blur_elysium_slides.slideCoverVideo`.`updated_at` as `blur_elysium_slides.slideCoverVideo.updatedAt`, `blur_elysium_slides.slideCoverVideo.translation.title`, `blur_elysium_slides.slideCoverVideo.translation.title` as `blur_elysium_slides.slideCoverVideo.title`, `blur_elysium_slides.slideCoverVideo.translation.alt`, `blur_elysium_slides.slideCoverVideo.translation.alt` as `blur_elysium_slides.slideCoverVideo.alt`, `blur_elysium_slides.slideCoverVideo.translation.customFields`, `blur_elysium_slides.slideCoverVideo.translation.customFields` as `blur_elysium_slides.slideCoverVideo.customFields`, `blur_elysium_slides`.`presentation_media_id` as `blur_elysium_slides.presentationMediaId`, `blur_elysium_slides.presentationMedia`.`id` as `blur_elysium_slides.presentationMedia.id`, `blur_elysium_slides.presentationMedia`.`user_id` as `blur_elysium_slides.presentationMedia.userId`, `blur_elysium_slides.presentationMedia`.`media_folder_id` as `blur_elysium_slides.presentationMedia.mediaFolderId`, `blur_elysium_slides.presentationMedia`.`mime_type` as `blur_elysium_slides.presentationMedia.mimeType`, `blur_elysium_slides.presentationMedia`.`file_extension` as `blur_elysium_slides.presentationMedia.fileExtension`, `blur_elysium_slides.presentationMedia`.`uploaded_at` as `blur_elysium_slides.presentationMedia.uploadedAt`, `blur_elysium_slides.presentationMedia`.`file_name` as `blur_elysium_slides.presentationMedia.fileName`, `blur_elysium_slides.presentationMedia`.`file_size` as `blur_elysium_slides.presentationMedia.fileSize`, `blur_elysium_slides.presentationMedia`.`media_type` as `blur_elysium_slides.presentationMedia.mediaTypeRaw`, `blur_elysium_slides.presentationMedia`.`meta_data` as `blur_elysium_slides.presentationMedia.metaData`, `blur_elysium_slides.presentationMedia`.`config` as `blur_elysium_slides.presentationMedia.config`, `blur_elysium_slides.presentationMedia`.`path` as `blur_elysium_slides.presentationMedia.path`, `blur_elysium_slides.presentationMedia`.`private` as `blur_elysium_slides.presentationMedia.private`, `blur_elysium_slides.presentationMedia`.`thumbnails_ro` as `blur_elysium_slides.presentationMedia.thumbnailsRo`, `blur_elysium_slides.presentationMedia`.`file_hash` as `blur_elysium_slides.presentationMedia.fileHash`, `blur_elysium_slides.presentationMedia`.`created_at` as `blur_elysium_slides.presentationMedia.createdAt`, `blur_elysium_slides.presentationMedia`.`updated_at` as `blur_elysium_slides.presentationMedia.updatedAt`, `blur_elysium_slides.presentationMedia.translation.title`, `blur_elysium_slides.presentationMedia.translation.title` as `blur_elysium_slides.presentationMedia.title`, `blur_elysium_slides.presentationMedia.translation.alt`, `blur_elysium_slides.presentationMedia.translation.alt` as `blur_elysium_slides.presentationMedia.alt`, `blur_elysium_slides.presentationMedia.translation.customFields`, `blur_elysium_slides.presentationMedia.translation.customFields` as `blur_elysium_slides.presentationMedia.customFields`, `blur_elysium_slides`.`slide_settings` as `blur_elysium_slides.slideSettings`, `blur_elysium_slides`.`start_date` as `blur_elysium_slides.startDate`, `blur_elysium_slides`.`end_date` as `blur_elysium_slides.endDate`, `blur_elysium_slides`.`created_at` as `blur_elysium_slides.createdAt`, `blur_elysium_slides`.`updated_at` as `blur_elysium_slides.updatedAt`, `blur_elysium_slides.translation.name`, `blur_elysium_slides.translation.name` as `blur_elysium_slides.name`, `blur_elysium_slides.translation.title`, `blur_elysium_slides.translation.title` as `blur_elysium_slides.title`, `blur_elysium_slides.translation.description`, `blur_elysium_slides.translation.description` as `blur_elysium_slides.description`, `blur_elysium_slides.translation.buttonLabel`, `blur_elysium_slides.translation.buttonLabel` as `blur_elysium_slides.buttonLabel`, `blur_elysium_slides.translation.url`, `blur_elysium_slides.translation.url` as `blur_elysium_slides.url`, `blur_elysium_slides.translation.customFields`, `blur_elysium_slides.translation.customFields` as `blur_elysium_slides.customFields` FROM `blur_elysium_slides` LEFT JOIN `product` `blur_elysium_slides.product` ON `blur_elysium_slides`.`product_id` = `blur_elysium_slides.product`.`id` AND `blur_elysium_slides.product`.`version_id` = UNHEX("0fa91ce3e96a4bc2be4bd9ce752c3425") LEFT JOIN `media` `blur_elysium_slides.slideCover` ON `blur_elysium_slides`.`slide_cover_id` = `blur_elysium_slides.slideCover`.`id` LEFT JOIN `media` `blur_elysium_slides.slideCoverMobile` ON `blur_elysium_slides`.`slide_cover_mobile_id` = `blur_elysium_slides.slideCoverMobile`.`id` LEFT JOIN `media` `blur_elysium_slides.slideCoverTablet` ON `blur_elysium_slides`.`slide_cover_tablet_id` = `blur_elysium_slides.slideCoverTablet`.`id` LEFT JOIN `media` `blur_elysium_slides.slideCoverVideo` ON `blur_elysium_slides`.`slide_cover_video_id` = `blur_elysium_slides.slideCoverVideo`.`id` LEFT JOIN `media` `blur_elysium_slides.presentationMedia` ON `blur_elysium_slides`.`presentation_media_id` = `blur_elysium_slides.presentationMedia`.`id` LEFT JOIN (SELECT `blur_elysium_slides.translation`.`blur_elysium_slides_id`, `blur_elysium_slides.translation`.`name` as `blur_elysium_slides.translation.name`, `blur_elysium_slides.translation`.`title` as `blur_elysium_slides.translation.title`, `blur_elysium_slides.translation`.`description` as `blur_elysium_slides.translation.description`, `blur_elysium_slides.translation`.`button_label` as `blur_elysium_slides.translation.buttonLabel`, `blur_elysium_slides.translation`.`url` as `blur_elysium_slides.translation.url`, `blur_elysium_slides.translation`.`custom_fields` as `blur_elysium_slides.translation.customFields` FROM `blur_elysium_slides_translation` `blur_elysium_slides.translation` WHERE `blur_elysium_slides.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `blur_elysium_slides.blur_elysium_slides_translation` ON `blur_elysium_slides.blur_elysium_slides_translation`.`blur_elysium_slides_id` = `blur_elysium_slides`.`id` LEFT JOIN `product` `blur_elysium_slides.product.parent` ON `blur_elysium_slides.product`.`parent_id` = `blur_elysium_slides.product.parent`.`id` AND `blur_elysium_slides.product`.`parent_version_id` = `blur_elysium_slides.product.parent`.`version_id` LEFT JOIN `tax` `blur_elysium_slides.product.tax` ON `blur_elysium_slides.product`.`tax` = `blur_elysium_slides.product.tax`.`id` LEFT JOIN `product_media` `blur_elysium_slides.product.cover` ON `blur_elysium_slides.product`.`cover` = `blur_elysium_slides.product.cover`.`id` AND IFNULL(`blur_elysium_slides.product`.`product_media_version_id`, `blur_elysium_slides.product.parent`.`product_media_version_id`) = `blur_elysium_slides.product.cover`.`version_id` LEFT JOIN (SELECT `blur_elysium_slides.product.translation`.`product_id`, `blur_elysium_slides.product.translation`.`product_version_id`, `blur_elysium_slides.product.translation`.`meta_description` as `blur_elysium_slides.product.translation.metaDescription`, `blur_elysium_slides.product.translation`.`name` as `blur_elysium_slides.product.translation.name`, `blur_elysium_slides.product.translation`.`keywords` as `blur_elysium_slides.product.translation.keywords`, `blur_elysium_slides.product.translation`.`description` as `blur_elysium_slides.product.translation.description`, `blur_elysium_slides.product.translation`.`meta_title` as `blur_elysium_slides.product.translation.metaTitle`, `blur_elysium_slides.product.translation`.`pack_unit` as `blur_elysium_slides.product.translation.packUnit`, `blur_elysium_slides.product.translation`.`pack_unit_plural` as `blur_elysium_slides.product.translation.packUnitPlural`, `blur_elysium_slides.product.translation`.`custom_fields` as `blur_elysium_slides.product.translation.customFields`, `blur_elysium_slides.product.translation`.`slot_config` as `blur_elysium_slides.product.translation.slotConfig`, `blur_elysium_slides.product.translation`.`custom_search_keywords` as `blur_elysium_slides.product.translation.customSearchKeywords` FROM `product_translation` `blur_elysium_slides.product.translation` WHERE `blur_elysium_slides.product.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `blur_elysium_slides.product.product_translation` ON `blur_elysium_slides.product.product_translation`.`product_id` = `blur_elysium_slides.product`.`id` AND `blur_elysium_slides.product.product_translation`.`product_version_id` = `blur_elysium_slides.product`.`version_id` LEFT JOIN (SELECT `blur_elysium_slides.product.parent.translation`.`product_id`, `blur_elysium_slides.product.parent.translation`.`product_version_id`, `blur_elysium_slides.product.parent.translation`.`meta_description` as `blur_elysium_slides.product.parent.translation.metaDescription`, `blur_elysium_slides.product.parent.translation`.`name` as `blur_elysium_slides.product.parent.translation.name`, `blur_elysium_slides.product.parent.translation`.`keywords` as `blur_elysium_slides.product.parent.translation.keywords`, `blur_elysium_slides.product.parent.translation`.`description` as `blur_elysium_slides.product.parent.translation.description`, `blur_elysium_slides.product.parent.translation`.`meta_title` as `blur_elysium_slides.product.parent.translation.metaTitle`, `blur_elysium_slides.product.parent.translation`.`pack_unit` as `blur_elysium_slides.product.parent.translation.packUnit`, `blur_elysium_slides.product.parent.translation`.`pack_unit_plural` as `blur_elysium_slides.product.parent.translation.packUnitPlural`, `blur_elysium_slides.product.parent.translation`.`custom_fields` as `blur_elysium_slides.product.parent.translation.customFields`, `blur_elysium_slides.product.parent.translation`.`slot_config` as `blur_elysium_slides.product.parent.translation.slotConfig`, `blur_elysium_slides.product.parent.translation`.`custom_search_keywords` as `blur_elysium_slides.product.parent.translation.customSearchKeywords` FROM `product_translation` `blur_elysium_slides.product.parent.translation` WHERE `blur_elysium_slides.product.parent.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `blur_elysium_slides.product.parent.product_translation` ON `blur_elysium_slides.product.parent.product_translation`.`product_id` = `blur_elysium_slides.product.parent`.`id` AND `blur_elysium_slides.product.parent.product_translation`.`product_version_id` = `blur_elysium_slides.product.parent`.`version_id` LEFT JOIN `media` `blur_elysium_slides.product.cover.media` ON `blur_elysium_slides.product.cover`.`media_id` = `blur_elysium_slides.product.cover.media`.`id` LEFT JOIN (SELECT `blur_elysium_slides.product.cover.media.translation`.`media_id`, `blur_elysium_slides.product.cover.media.translation`.`alt` as `blur_elysium_slides.product.cover.media.translation.alt`, `blur_elysium_slides.product.cover.media.translation`.`title` as `blur_elysium_slides.product.cover.media.translation.title`, `blur_elysium_slides.product.cover.media.translation`.`custom_fields` as `blur_elysium_slides.product.cover.media.translation.customFields` FROM `media_translation` `blur_elysium_slides.product.cover.media.translation` WHERE `blur_elysium_slides.product.cover.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `blur_elysium_slides.product.cover.media.media_translation` ON `blur_elysium_slides.product.cover.media.media_translation`.`media_id` = `blur_elysium_slides.product.cover.media`.`id` LEFT JOIN (SELECT `blur_elysium_slides.slideCover.translation`.`media_id`, `blur_elysium_slides.slideCover.translation`.`alt` as `blur_elysium_slides.slideCover.translation.alt`, `blur_elysium_slides.slideCover.translation`.`title` as `blur_elysium_slides.slideCover.translation.title`, `blur_elysium_slides.slideCover.translation`.`custom_fields` as `blur_elysium_slides.slideCover.translation.customFields` FROM `media_translation` `blur_elysium_slides.slideCover.translation` WHERE `blur_elysium_slides.slideCover.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `blur_elysium_slides.slideCover.media_translation` ON `blur_elysium_slides.slideCover.media_translation`.`media_id` = `blur_elysium_slides.slideCover`.`id` LEFT JOIN (SELECT `blur_elysium_slides.slideCoverMobile.translation`.`media_id`, `blur_elysium_slides.slideCoverMobile.translation`.`alt` as `blur_elysium_slides.slideCoverMobile.translation.alt`, `blur_elysium_slides.slideCoverMobile.translation`.`title` as `blur_elysium_slides.slideCoverMobile.translation.title`, `blur_elysium_slides.slideCoverMobile.translation`.`custom_fields` as `blur_elysium_slides.slideCoverMobile.translation.customFields` FROM `media_translation` `blur_elysium_slides.slideCoverMobile.translation` WHERE `blur_elysium_slides.slideCoverMobile.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `blur_elysium_slides.slideCoverMobile.media_translation` ON `blur_elysium_slides.slideCoverMobile.media_translation`.`media_id` = `blur_elysium_slides.slideCoverMobile`.`id` LEFT JOIN (SELECT `blur_elysium_slides.slideCoverTablet.translation`.`media_id`, `blur_elysium_slides.slideCoverTablet.translation`.`alt` as `blur_elysium_slides.slideCoverTablet.translation.alt`, `blur_elysium_slides.slideCoverTablet.translation`.`title` as `blur_elysium_slides.slideCoverTablet.translation.title`, `blur_elysium_slides.slideCoverTablet.translation`.`custom_fields` as `blur_elysium_slides.slideCoverTablet.translation.customFields` FROM `media_translation` `blur_elysium_slides.slideCoverTablet.translation` WHERE `blur_elysium_slides.slideCoverTablet.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `blur_elysium_slides.slideCoverTablet.media_translation` ON `blur_elysium_slides.slideCoverTablet.media_translation`.`media_id` = `blur_elysium_slides.slideCoverTablet`.`id` LEFT JOIN (SELECT `blur_elysium_slides.slideCoverVideo.translation`.`media_id`, `blur_elysium_slides.slideCoverVideo.translation`.`alt` as `blur_elysium_slides.slideCoverVideo.translation.alt`, `blur_elysium_slides.slideCoverVideo.translation`.`title` as `blur_elysium_slides.slideCoverVideo.translation.title`, `blur_elysium_slides.slideCoverVideo.translation`.`custom_fields` as `blur_elysium_slides.slideCoverVideo.translation.customFields` FROM `media_translation` `blur_elysium_slides.slideCoverVideo.translation` WHERE `blur_elysium_slides.slideCoverVideo.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `blur_elysium_slides.slideCoverVideo.media_translation` ON `blur_elysium_slides.slideCoverVideo.media_translation`.`media_id` = `blur_elysium_slides.slideCoverVideo`.`id` LEFT JOIN (SELECT `blur_elysium_slides.presentationMedia.translation`.`media_id`, `blur_elysium_slides.presentationMedia.translation`.`alt` as `blur_elysium_slides.presentationMedia.translation.alt`, `blur_elysium_slides.presentationMedia.translation`.`title` as `blur_elysium_slides.presentationMedia.translation.title`, `blur_elysium_slides.presentationMedia.translation`.`custom_fields` as `blur_elysium_slides.presentationMedia.translation.customFields` FROM `media_translation` `blur_elysium_slides.presentationMedia.translation` WHERE `blur_elysium_slides.presentationMedia.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `blur_elysium_slides.presentationMedia.media_translation` ON `blur_elysium_slides.presentationMedia.media_translation`.`media_id` = `blur_elysium_slides.presentationMedia`.`id` WHERE ((((`blur_elysium_slides`.`start_date` <=> NULL AND `blur_elysium_slides`.`end_date` <=> NULL) OR ((`blur_elysium_slides`.`start_date` <=> NULL OR (`blur_elysium_slides`.`start_date` <= '2026-02-03 16:36:31')) AND (`blur_elysium_slides`.`end_date` <=> NULL OR (`blur_elysium_slides`.`end_date` >= '2026-02-03 16:36:31')))))) AND (`blur_elysium_slides`.`id` IN (0x0198F8321AC97259BDE5015B3FEFBE80, 0x019932A71E5671E6B72DE9AEA10D636F, 0x0198B9FAE3DC7169BCE478E9F9D64392, 0x0198B9EC1B8471D5B6BFEAE4D050A11E, 0x01990547156D73388F8702A85480CE92, 0x0199327CC1BC71B3A7D5242051421B23));