Symfony Profiler

SELECT
  `app`.`id` as `app.id`,
  `app`.`name` as `app.name`,
  `app`.`path` as `app.path`,
  `app`.`author` as `app.author`,
  `app`.`copyright` as `app.copyright`,
  `app`.`license` as `app.license`,
  `app`.`active` as `app.active`,
  `app`.`configurable` as `app.configurable`,
  `app`.`privacy` as `app.privacy`,
  `app`.`version` as `app.version`,
  `app`.`icon` as `app.iconRaw`,
  `app`.`app_secret` as `app.appSecret`,
  `app`.`modules` as `app.modules`,
  `app`.`main_module` as `app.mainModule`,
  `app`.`cookies` as `app.cookies`,
  `app`.`allow_disable` as `app.allowDisable`,
  `app`.`base_app_url` as `app.baseAppUrl`,
  `app`.`allowed_hosts` as `app.allowedHosts`,
  `app`.`template_load_priority` as `app.templateLoadPriority`,
  `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`,
  `app`.`integration_id` as `app.integrationId`,
  `app.integration`.`id` as `app.integration.id`,
  `app.integration`.`label` as `app.integration.label`,
  `app.integration`.`access_key` as `app.integration.accessKey`,
  `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
  `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
  `app.integration`.`admin` as `app.integration.admin`,
  `app.integration`.`custom_fields` as `app.integration.customFields`,
  `app.integration`.`deleted_at` as `app.integration.deletedAt`,
  `app.integration`.`created_at` as `app.integration.createdAt`,
  `app.integration`.`updated_at` as `app.integration.updatedAt`,
  `app`.`acl_role_id` as `app.aclRoleId`,
  `app.aclRole`.`id` as `app.aclRole.id`,
  `app.aclRole`.`name` as `app.aclRole.name`,
  `app.aclRole`.`description` as `app.aclRole.description`,
  `app.aclRole`.`privileges` as `app.aclRole.privileges`,
  `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`,
  `app.aclRole`.`created_at` as `app.aclRole.createdAt`,
  `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`,
  `app`.`created_at` as `app.createdAt`,
  `app`.`updated_at` as `app.updatedAt`,
  `app.translation.label`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) as `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) as `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  LEFT JOIN (
    SELECT
      `app.translation`.app_id,
      `app.translation`.label as `app.translation.label`,
      `app.translation`.description as `app.translation.description`,
      `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`,
      `app.translation`.custom_fields as `app.translation.customFields`,
      `app.translation`.created_at as `app.translation.createdAt`,
      `app.translation`.updated_at as `app.translation.updatedAt`,
      `app.translation`.app_id as `app.translation.appId`,
      `app.translation`.language_id as `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
  LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
  `app`.`id` IN (?)

SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE `app`.`id` IN (0x018D8883C723711F8DEDEF47EBAF9019);

SELECT
  `s_plugin_netzp_blog`.`id` as `s_plugin_netzp_blog.id`,
  `s_plugin_netzp_blog`.`postdate` as `s_plugin_netzp_blog.postdate`,
  `s_plugin_netzp_blog`.`showfrom` as `s_plugin_netzp_blog.showfrom`,
  `s_plugin_netzp_blog`.`showuntil` as `s_plugin_netzp_blog.showuntil`,
  `s_plugin_netzp_blog`.`noindex` as `s_plugin_netzp_blog.noindex`,
  `s_plugin_netzp_blog`.`canonicalUrl` as `s_plugin_netzp_blog.canonicalUrl`,
  `s_plugin_netzp_blog`.`sticky` as `s_plugin_netzp_blog.sticky`,
  `s_plugin_netzp_blog`.`isproductstream` as `s_plugin_netzp_blog.isproductstream`,
  `s_plugin_netzp_blog`.`imageid` as `s_plugin_netzp_blog.imageid`,
  `s_plugin_netzp_blog`.`imagepreviewid` as `s_plugin_netzp_blog.imagepreviewid`,
  `s_plugin_netzp_blog`.`categoryid` as `s_plugin_netzp_blog.categoryid`,
  `s_plugin_netzp_blog`.`authorid` as `s_plugin_netzp_blog.authorid`,
  `s_plugin_netzp_blog`.`productstreamid` as `s_plugin_netzp_blog.productstreamid`,
  `s_plugin_netzp_blog.category`.`id` as `s_plugin_netzp_blog.category.id`,
  `s_plugin_netzp_blog.category`.`saleschannel_id` as `s_plugin_netzp_blog.category.saleschannelid`,
  `s_plugin_netzp_blog.category`.`customergroup_id` as `s_plugin_netzp_blog.category.customergroupid`,
  `s_plugin_netzp_blog.category`.`navigationcategoryid` as `s_plugin_netzp_blog.category.navigationcategoryid`,
  `s_plugin_netzp_blog.category`.`cmspageid` as `s_plugin_netzp_blog.category.cmspageid`,
  `s_plugin_netzp_blog.category`.`onlyloggedin` as `s_plugin_netzp_blog.category.onlyloggedin`,
  `s_plugin_netzp_blog.category`.`includeinrss` as `s_plugin_netzp_blog.category.includeinrss`,
  `s_plugin_netzp_blog.category.saleschannel`.`id` as `s_plugin_netzp_blog.category.saleschannel.id`,
  `s_plugin_netzp_blog.category.saleschannel`.`type_id` as `s_plugin_netzp_blog.category.saleschannel.typeId`,
  `s_plugin_netzp_blog.category.saleschannel`.`language_id` as `s_plugin_netzp_blog.category.saleschannel.languageId`,
  `s_plugin_netzp_blog.category.saleschannel`.`customer_group_id` as `s_plugin_netzp_blog.category.saleschannel.customerGroupId`,
  `s_plugin_netzp_blog.category.saleschannel`.`currency_id` as `s_plugin_netzp_blog.category.saleschannel.currencyId`,
  `s_plugin_netzp_blog.category.saleschannel`.`payment_method_id` as `s_plugin_netzp_blog.category.saleschannel.paymentMethodId`,
  `s_plugin_netzp_blog.category.saleschannel`.`shipping_method_id` as `s_plugin_netzp_blog.category.saleschannel.shippingMethodId`,
  `s_plugin_netzp_blog.category.saleschannel`.`country_id` as `s_plugin_netzp_blog.category.saleschannel.countryId`,
  `s_plugin_netzp_blog.category.saleschannel`.`analytics_id` as `s_plugin_netzp_blog.category.saleschannel.analyticsId`,
  `s_plugin_netzp_blog.category.saleschannel`.`navigation_category_id` as `s_plugin_netzp_blog.category.saleschannel.navigationCategoryId`,
  `s_plugin_netzp_blog.category.saleschannel`.`navigation_category_version_id` as `s_plugin_netzp_blog.category.saleschannel.navigationCategoryVersionId`,
  `s_plugin_netzp_blog.category.saleschannel`.`navigation_category_depth` as `s_plugin_netzp_blog.category.saleschannel.navigationCategoryDepth`,
  `s_plugin_netzp_blog.category.saleschannel`.`footer_category_id` as `s_plugin_netzp_blog.category.saleschannel.footerCategoryId`,
  `s_plugin_netzp_blog.category.saleschannel`.`footer_category_version_id` as `s_plugin_netzp_blog.category.saleschannel.footerCategoryVersionId`,
  `s_plugin_netzp_blog.category.saleschannel`.`service_category_id` as `s_plugin_netzp_blog.category.saleschannel.serviceCategoryId`,
  `s_plugin_netzp_blog.category.saleschannel`.`service_category_version_id` as `s_plugin_netzp_blog.category.saleschannel.serviceCategoryVersionId`,
  `s_plugin_netzp_blog.category.saleschannel`.`mail_header_footer_id` as `s_plugin_netzp_blog.category.saleschannel.mailHeaderFooterId`,
  `s_plugin_netzp_blog.category.saleschannel`.`hreflang_default_domain_id` as `s_plugin_netzp_blog.category.saleschannel.hreflangDefaultDomainId`,
  `s_plugin_netzp_blog.category.saleschannel`.`short_name` as `s_plugin_netzp_blog.category.saleschannel.shortName`,
  `s_plugin_netzp_blog.category.saleschannel`.`tax_calculation_type` as `s_plugin_netzp_blog.category.saleschannel.taxCalculationType`,
  `s_plugin_netzp_blog.category.saleschannel`.`access_key` as `s_plugin_netzp_blog.category.saleschannel.accessKey`,
  `s_plugin_netzp_blog.category.saleschannel`.`configuration` as `s_plugin_netzp_blog.category.saleschannel.configuration`,
  `s_plugin_netzp_blog.category.saleschannel`.`active` as `s_plugin_netzp_blog.category.saleschannel.active`,
  `s_plugin_netzp_blog.category.saleschannel`.`hreflang_active` as `s_plugin_netzp_blog.category.saleschannel.hreflangActive`,
  `s_plugin_netzp_blog.category.saleschannel`.`maintenance` as `s_plugin_netzp_blog.category.saleschannel.maintenance`,
  `s_plugin_netzp_blog.category.saleschannel`.`maintenance_ip_whitelist` as `s_plugin_netzp_blog.category.saleschannel.maintenanceIpWhitelist`,
  `s_plugin_netzp_blog.category.saleschannel`.`payment_method_ids` as `s_plugin_netzp_blog.category.saleschannel.paymentMethodIds`,
  `s_plugin_netzp_blog.category.saleschannel`.`home_cms_page_id` as `s_plugin_netzp_blog.category.saleschannel.homeCmsPageId`,
  `s_plugin_netzp_blog.category.saleschannel`.`home_cms_page_version_id` as `s_plugin_netzp_blog.category.saleschannel.homeCmsPageVersionId`,
  `s_plugin_netzp_blog.category.saleschannel`.`created_at` as `s_plugin_netzp_blog.category.saleschannel.createdAt`,
  `s_plugin_netzp_blog.category.saleschannel`.`updated_at` as `s_plugin_netzp_blog.category.saleschannel.updatedAt`,
  `s_plugin_netzp_blog.category.saleschannel.translation.name`,
  COALESCE(
    `s_plugin_netzp_blog.category.saleschannel.translation.name`,
    `s_plugin_netzp_blog.category.saleschannel.translation.name`
  ) as `s_plugin_netzp_blog.category.saleschannel.name`,
  `s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`,
  COALESCE(
    `s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`,
    `s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`
  ) as `s_plugin_netzp_blog.category.saleschannel.homeSlotConfig`,
  `s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`,
  COALESCE(
    `s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`,
    `s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`
  ) as `s_plugin_netzp_blog.category.saleschannel.homeEnabled`,
  `s_plugin_netzp_blog.category.saleschannel.translation.homeName`,
  COALESCE(
    `s_plugin_netzp_blog.category.saleschannel.translation.homeName`,
    `s_plugin_netzp_blog.category.saleschannel.translation.homeName`
  ) as `s_plugin_netzp_blog.category.saleschannel.homeName`,
  `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`,
  COALESCE(
    `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`,
    `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`
  ) as `s_plugin_netzp_blog.category.saleschannel.homeMetaTitle`,
  `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`,
  COALESCE(
    `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`,
    `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`
  ) as `s_plugin_netzp_blog.category.saleschannel.homeMetaDescription`,
  `s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`,
  COALESCE(
    `s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`,
    `s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`
  ) as `s_plugin_netzp_blog.category.saleschannel.homeKeywords`,
  `s_plugin_netzp_blog.category.saleschannel.translation.customFields`,
  COALESCE(
    `s_plugin_netzp_blog.category.saleschannel.translation.customFields`,
    `s_plugin_netzp_blog.category.saleschannel.translation.customFields`
  ) as `s_plugin_netzp_blog.category.saleschannel.customFields`,
  `s_plugin_netzp_blog.category.saleschannel.translation.createdAt`,
  `s_plugin_netzp_blog.category.saleschannel.translation.updatedAt`,
  `s_plugin_netzp_blog.category.saleschannel.translation.salesChannelId`,
  `s_plugin_netzp_blog.category.saleschannel.translation.languageId`,
  `s_plugin_netzp_blog.category.customergroup`.`id` as `s_plugin_netzp_blog.category.customergroup.id`,
  `s_plugin_netzp_blog.category.customergroup`.`display_gross` as `s_plugin_netzp_blog.category.customergroup.displayGross`,
  `s_plugin_netzp_blog.category.customergroup`.`registration_active` as `s_plugin_netzp_blog.category.customergroup.registrationActive`,
  `s_plugin_netzp_blog.category.customergroup`.`created_at` as `s_plugin_netzp_blog.category.customergroup.createdAt`,
  `s_plugin_netzp_blog.category.customergroup`.`updated_at` as `s_plugin_netzp_blog.category.customergroup.updatedAt`,
  `s_plugin_netzp_blog.category.customergroup.translation.name`,
  COALESCE(
    `s_plugin_netzp_blog.category.customergroup.translation.name`,
    `s_plugin_netzp_blog.category.customergroup.translation.name`
  ) as `s_plugin_netzp_blog.category.customergroup.name`,
  `s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`,
  COALESCE(
    `s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`,
    `s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`
  ) as `s_plugin_netzp_blog.category.customergroup.registrationTitle`,
  `s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`,
  COALESCE(
    `s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`,
    `s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`
  ) as `s_plugin_netzp_blog.category.customergroup.registrationIntroduction`,
  `s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`,
  COALESCE(
    `s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`,
    `s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`
  ) as `s_plugin_netzp_blog.category.customergroup.registrationOnlyCompanyRegistration`,
  `s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`,
  COALESCE(
    `s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`,
    `s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`
  ) as `s_plugin_netzp_blog.category.customergroup.registrationSeoMetaDescription`,
  `s_plugin_netzp_blog.category.customergroup.translation.customFields`,
  COALESCE(
    `s_plugin_netzp_blog.category.customergroup.translation.customFields`,
    `s_plugin_netzp_blog.category.customergroup.translation.customFields`
  ) as `s_plugin_netzp_blog.category.customergroup.customFields`,
  `s_plugin_netzp_blog.category.customergroup.translation.createdAt`,
  `s_plugin_netzp_blog.category.customergroup.translation.updatedAt`,
  `s_plugin_netzp_blog.category.customergroup.translation.customerGroupId`,
  `s_plugin_netzp_blog.category.customergroup.translation.languageId`,
  `s_plugin_netzp_blog.category`.`created_at` as `s_plugin_netzp_blog.category.createdAt`,
  `s_plugin_netzp_blog.category`.`updated_at` as `s_plugin_netzp_blog.category.updatedAt`,
  `s_plugin_netzp_blog.category.translation.title`,
  COALESCE(
    `s_plugin_netzp_blog.category.translation.title`,
    `s_plugin_netzp_blog.category.translation.title`
  ) as `s_plugin_netzp_blog.category.title`,
  `s_plugin_netzp_blog.category.translation.teaser`,
  COALESCE(
    `s_plugin_netzp_blog.category.translation.teaser`,
    `s_plugin_netzp_blog.category.translation.teaser`
  ) as `s_plugin_netzp_blog.category.teaser`,
  `s_plugin_netzp_blog.category.translation.customFields`,
  COALESCE(
    `s_plugin_netzp_blog.category.translation.customFields`,
    `s_plugin_netzp_blog.category.translation.customFields`
  ) as `s_plugin_netzp_blog.category.customFields`,
  `s_plugin_netzp_blog.category.translation.createdAt`,
  `s_plugin_netzp_blog.category.translation.updatedAt`,
  `s_plugin_netzp_blog.category.translation.sPluginNetzpBlogCategoryId`,
  `s_plugin_netzp_blog.category.translation.languageId`,
  `s_plugin_netzp_blog.author`.`id` as `s_plugin_netzp_blog.author.id`,
  `s_plugin_netzp_blog.author`.`imageid` as `s_plugin_netzp_blog.author.imageid`,
  `s_plugin_netzp_blog.author`.`link` as `s_plugin_netzp_blog.author.link`,
  `s_plugin_netzp_blog.author.image`.`id` as `s_plugin_netzp_blog.author.image.id`,
  `s_plugin_netzp_blog.author.image`.`user_id` as `s_plugin_netzp_blog.author.image.userId`,
  `s_plugin_netzp_blog.author.image`.`media_folder_id` as `s_plugin_netzp_blog.author.image.mediaFolderId`,
  `s_plugin_netzp_blog.author.image`.`mime_type` as `s_plugin_netzp_blog.author.image.mimeType`,
  `s_plugin_netzp_blog.author.image`.`file_extension` as `s_plugin_netzp_blog.author.image.fileExtension`,
  `s_plugin_netzp_blog.author.image`.`uploaded_at` as `s_plugin_netzp_blog.author.image.uploadedAt`,
  `s_plugin_netzp_blog.author.image`.`file_name` as `s_plugin_netzp_blog.author.image.fileName`,
  `s_plugin_netzp_blog.author.image`.`file_size` as `s_plugin_netzp_blog.author.image.fileSize`,
  `s_plugin_netzp_blog.author.image`.`media_type` as `s_plugin_netzp_blog.author.image.mediaTypeRaw`,
  `s_plugin_netzp_blog.author.image`.`meta_data` as `s_plugin_netzp_blog.author.image.metaData`,
  `s_plugin_netzp_blog.author.image`.`config` as `s_plugin_netzp_blog.author.image.config`,
  `s_plugin_netzp_blog.author.image`.`path` as `s_plugin_netzp_blog.author.image.path`,
  `s_plugin_netzp_blog.author.image`.`private` as `s_plugin_netzp_blog.author.image.private`,
  `s_plugin_netzp_blog.author.image`.`thumbnails_ro` as `s_plugin_netzp_blog.author.image.thumbnailsRo`,
  `s_plugin_netzp_blog.author.image`.`created_at` as `s_plugin_netzp_blog.author.image.createdAt`,
  `s_plugin_netzp_blog.author.image`.`updated_at` as `s_plugin_netzp_blog.author.image.updatedAt`,
  `s_plugin_netzp_blog.author.image.translation.title`,
  COALESCE(
    `s_plugin_netzp_blog.author.image.translation.title`,
    `s_plugin_netzp_blog.author.image.translation.title`
  ) as `s_plugin_netzp_blog.author.image.title`,
  `s_plugin_netzp_blog.author.image.translation.alt`,
  COALESCE(
    `s_plugin_netzp_blog.author.image.translation.alt`,
    `s_plugin_netzp_blog.author.image.translation.alt`
  ) as `s_plugin_netzp_blog.author.image.alt`,
  `s_plugin_netzp_blog.author.image.translation.customFields`,
  COALESCE(
    `s_plugin_netzp_blog.author.image.translation.customFields`,
    `s_plugin_netzp_blog.author.image.translation.customFields`
  ) as `s_plugin_netzp_blog.author.image.customFields`,
  `s_plugin_netzp_blog.author.image.translation.createdAt`,
  `s_plugin_netzp_blog.author.image.translation.updatedAt`,
  `s_plugin_netzp_blog.author.image.translation.mediaId`,
  `s_plugin_netzp_blog.author.image.translation.languageId`,
  `s_plugin_netzp_blog.author`.`created_at` as `s_plugin_netzp_blog.author.createdAt`,
  `s_plugin_netzp_blog.author`.`updated_at` as `s_plugin_netzp_blog.author.updatedAt`,
  `s_plugin_netzp_blog.author.translation.name`,
  COALESCE(
    `s_plugin_netzp_blog.author.translation.name`,
    `s_plugin_netzp_blog.author.translation.name`
  ) as `s_plugin_netzp_blog.author.name`,
  `s_plugin_netzp_blog.author.translation.bio`,
  COALESCE(
    `s_plugin_netzp_blog.author.translation.bio`,
    `s_plugin_netzp_blog.author.translation.bio`
  ) as `s_plugin_netzp_blog.author.bio`,
  `s_plugin_netzp_blog.author.translation.customFields`,
  COALESCE(
    `s_plugin_netzp_blog.author.translation.customFields`,
    `s_plugin_netzp_blog.author.translation.customFields`
  ) as `s_plugin_netzp_blog.author.customFields`,
  `s_plugin_netzp_blog.author.translation.createdAt`,
  `s_plugin_netzp_blog.author.translation.updatedAt`,
  `s_plugin_netzp_blog.author.translation.sPluginNetzpBlogAuthorId`,
  `s_plugin_netzp_blog.author.translation.languageId`,
  `s_plugin_netzp_blog.image`.`id` as `s_plugin_netzp_blog.image.id`,
  `s_plugin_netzp_blog.image`.`user_id` as `s_plugin_netzp_blog.image.userId`,
  `s_plugin_netzp_blog.image`.`media_folder_id` as `s_plugin_netzp_blog.image.mediaFolderId`,
  `s_plugin_netzp_blog.image`.`mime_type` as `s_plugin_netzp_blog.image.mimeType`,
  `s_plugin_netzp_blog.image`.`file_extension` as `s_plugin_netzp_blog.image.fileExtension`,
  `s_plugin_netzp_blog.image`.`uploaded_at` as `s_plugin_netzp_blog.image.uploadedAt`,
  `s_plugin_netzp_blog.image`.`file_name` as `s_plugin_netzp_blog.image.fileName`,
  `s_plugin_netzp_blog.image`.`file_size` as `s_plugin_netzp_blog.image.fileSize`,
  `s_plugin_netzp_blog.image`.`media_type` as `s_plugin_netzp_blog.image.mediaTypeRaw`,
  `s_plugin_netzp_blog.image`.`meta_data` as `s_plugin_netzp_blog.image.metaData`,
  `s_plugin_netzp_blog.image`.`config` as `s_plugin_netzp_blog.image.config`,
  `s_plugin_netzp_blog.image`.`path` as `s_plugin_netzp_blog.image.path`,
  `s_plugin_netzp_blog.image`.`private` as `s_plugin_netzp_blog.image.private`,
  `s_plugin_netzp_blog.image`.`thumbnails_ro` as `s_plugin_netzp_blog.image.thumbnailsRo`,
  `s_plugin_netzp_blog.image`.`created_at` as `s_plugin_netzp_blog.image.createdAt`,
  `s_plugin_netzp_blog.image`.`updated_at` as `s_plugin_netzp_blog.image.updatedAt`,
  `s_plugin_netzp_blog.image.translation.title`,
  COALESCE(
    `s_plugin_netzp_blog.image.translation.title`,
    `s_plugin_netzp_blog.image.translation.title`
  ) as `s_plugin_netzp_blog.image.title`,
  `s_plugin_netzp_blog.image.translation.alt`,
  COALESCE(
    `s_plugin_netzp_blog.image.translation.alt`,
    `s_plugin_netzp_blog.image.translation.alt`
  ) as `s_plugin_netzp_blog.image.alt`,
  `s_plugin_netzp_blog.image.translation.customFields`,
  COALESCE(
    `s_plugin_netzp_blog.image.translation.customFields`,
    `s_plugin_netzp_blog.image.translation.customFields`
  ) as `s_plugin_netzp_blog.image.customFields`,
  `s_plugin_netzp_blog.image.translation.createdAt`,
  `s_plugin_netzp_blog.image.translation.updatedAt`,
  `s_plugin_netzp_blog.image.translation.mediaId`,
  `s_plugin_netzp_blog.image.translation.languageId`,
  `s_plugin_netzp_blog.imagepreview`.`id` as `s_plugin_netzp_blog.imagepreview.id`,
  `s_plugin_netzp_blog.imagepreview`.`user_id` as `s_plugin_netzp_blog.imagepreview.userId`,
  `s_plugin_netzp_blog.imagepreview`.`media_folder_id` as `s_plugin_netzp_blog.imagepreview.mediaFolderId`,
  `s_plugin_netzp_blog.imagepreview`.`mime_type` as `s_plugin_netzp_blog.imagepreview.mimeType`,
  `s_plugin_netzp_blog.imagepreview`.`file_extension` as `s_plugin_netzp_blog.imagepreview.fileExtension`,
  `s_plugin_netzp_blog.imagepreview`.`uploaded_at` as `s_plugin_netzp_blog.imagepreview.uploadedAt`,
  `s_plugin_netzp_blog.imagepreview`.`file_name` as `s_plugin_netzp_blog.imagepreview.fileName`,
  `s_plugin_netzp_blog.imagepreview`.`file_size` as `s_plugin_netzp_blog.imagepreview.fileSize`,
  `s_plugin_netzp_blog.imagepreview`.`media_type` as `s_plugin_netzp_blog.imagepreview.mediaTypeRaw`,
  `s_plugin_netzp_blog.imagepreview`.`meta_data` as `s_plugin_netzp_blog.imagepreview.metaData`,
  `s_plugin_netzp_blog.imagepreview`.`config` as `s_plugin_netzp_blog.imagepreview.config`,
  `s_plugin_netzp_blog.imagepreview`.`path` as `s_plugin_netzp_blog.imagepreview.path`,
  `s_plugin_netzp_blog.imagepreview`.`private` as `s_plugin_netzp_blog.imagepreview.private`,
  `s_plugin_netzp_blog.imagepreview`.`thumbnails_ro` as `s_plugin_netzp_blog.imagepreview.thumbnailsRo`,
  `s_plugin_netzp_blog.imagepreview`.`created_at` as `s_plugin_netzp_blog.imagepreview.createdAt`,
  `s_plugin_netzp_blog.imagepreview`.`updated_at` as `s_plugin_netzp_blog.imagepreview.updatedAt`,
  `s_plugin_netzp_blog.imagepreview.translation.title`,
  COALESCE(
    `s_plugin_netzp_blog.imagepreview.translation.title`,
    `s_plugin_netzp_blog.imagepreview.translation.title`
  ) as `s_plugin_netzp_blog.imagepreview.title`,
  `s_plugin_netzp_blog.imagepreview.translation.alt`,
  COALESCE(
    `s_plugin_netzp_blog.imagepreview.translation.alt`,
    `s_plugin_netzp_blog.imagepreview.translation.alt`
  ) as `s_plugin_netzp_blog.imagepreview.alt`,
  `s_plugin_netzp_blog.imagepreview.translation.customFields`,
  COALESCE(
    `s_plugin_netzp_blog.imagepreview.translation.customFields`,
    `s_plugin_netzp_blog.imagepreview.translation.customFields`
  ) as `s_plugin_netzp_blog.imagepreview.customFields`,
  `s_plugin_netzp_blog.imagepreview.translation.createdAt`,
  `s_plugin_netzp_blog.imagepreview.translation.updatedAt`,
  `s_plugin_netzp_blog.imagepreview.translation.mediaId`,
  `s_plugin_netzp_blog.imagepreview.translation.languageId`,
  `s_plugin_netzp_blog.productstream`.`id` as `s_plugin_netzp_blog.productstream.id`,
  `s_plugin_netzp_blog.productstream`.`api_filter` as `s_plugin_netzp_blog.productstream.apiFilter`,
  `s_plugin_netzp_blog.productstream`.`invalid` as `s_plugin_netzp_blog.productstream.invalid`,
  `s_plugin_netzp_blog.productstream`.`created_at` as `s_plugin_netzp_blog.productstream.createdAt`,
  `s_plugin_netzp_blog.productstream`.`updated_at` as `s_plugin_netzp_blog.productstream.updatedAt`,
  `s_plugin_netzp_blog.productstream.translation.name`,
  COALESCE(
    `s_plugin_netzp_blog.productstream.translation.name`,
    `s_plugin_netzp_blog.productstream.translation.name`
  ) as `s_plugin_netzp_blog.productstream.name`,
  `s_plugin_netzp_blog.productstream.translation.description`,
  COALESCE(
    `s_plugin_netzp_blog.productstream.translation.description`,
    `s_plugin_netzp_blog.productstream.translation.description`
  ) as `s_plugin_netzp_blog.productstream.description`,
  `s_plugin_netzp_blog.productstream.translation.customFields`,
  COALESCE(
    `s_plugin_netzp_blog.productstream.translation.customFields`,
    `s_plugin_netzp_blog.productstream.translation.customFields`
  ) as `s_plugin_netzp_blog.productstream.customFields`,
  `s_plugin_netzp_blog.productstream.translation.createdAt`,
  `s_plugin_netzp_blog.productstream.translation.updatedAt`,
  `s_plugin_netzp_blog.productstream.translation.productStreamId`,
  `s_plugin_netzp_blog.productstream.translation.languageId`,
  `s_plugin_netzp_blog`.`created_at` as `s_plugin_netzp_blog.createdAt`,
  `s_plugin_netzp_blog`.`updated_at` as `s_plugin_netzp_blog.updatedAt`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(
          `s_plugin_netzp_blog.products.mapping`.`product_id`
        ) SEPARATOR '||'
      )
    FROM
      `s_plugin_netzp_blog_product` `s_plugin_netzp_blog.products.mapping`
    WHERE
      `s_plugin_netzp_blog.products.mapping`.`blog_id` = `s_plugin_netzp_blog`.`id`
  ) as `s_plugin_netzp_blog.products.id_mapping`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(
          `s_plugin_netzp_blog.categories.mapping`.`category_id`
        ) SEPARATOR '||'
      )
    FROM
      `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping`
    WHERE
      `s_plugin_netzp_blog.categories.mapping`.`blog_id` = `s_plugin_netzp_blog`.`id`
  ) as `s_plugin_netzp_blog.categories.id_mapping`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(
          `s_plugin_netzp_blog.tags.mapping`.`tag_id`
        ) SEPARATOR '||'
      )
    FROM
      `s_plugin_netzp_blog_tag` `s_plugin_netzp_blog.tags.mapping`
    WHERE
      `s_plugin_netzp_blog.tags.mapping`.`blog_id` = `s_plugin_netzp_blog`.`id`
  ) as `s_plugin_netzp_blog.tags.id_mapping`,
  `s_plugin_netzp_blog.translation.title`,
  COALESCE(
    `s_plugin_netzp_blog.translation.title`,
    `s_plugin_netzp_blog.translation.title`
  ) as `s_plugin_netzp_blog.title`,
  `s_plugin_netzp_blog.translation.teaser`,
  COALESCE(
    `s_plugin_netzp_blog.translation.teaser`,
    `s_plugin_netzp_blog.translation.teaser`
  ) as `s_plugin_netzp_blog.teaser`,
  `s_plugin_netzp_blog.translation.slug`,
  COALESCE(
    `s_plugin_netzp_blog.translation.slug`,
    `s_plugin_netzp_blog.translation.slug`
  ) as `s_plugin_netzp_blog.slug`,
  `s_plugin_netzp_blog.translation.contents`,
  COALESCE(
    `s_plugin_netzp_blog.translation.contents`,
    `s_plugin_netzp_blog.translation.contents`
  ) as `s_plugin_netzp_blog.contents`,
  `s_plugin_netzp_blog.translation.custom`,
  COALESCE(
    `s_plugin_netzp_blog.translation.custom`,
    `s_plugin_netzp_blog.translation.custom`
  ) as `s_plugin_netzp_blog.custom`,
  `s_plugin_netzp_blog.translation.metatitle`,
  COALESCE(
    `s_plugin_netzp_blog.translation.metatitle`,
    `s_plugin_netzp_blog.translation.metatitle`
  ) as `s_plugin_netzp_blog.metatitle`,
  `s_plugin_netzp_blog.translation.metadescription`,
  COALESCE(
    `s_plugin_netzp_blog.translation.metadescription`,
    `s_plugin_netzp_blog.translation.metadescription`
  ) as `s_plugin_netzp_blog.metadescription`,
  `s_plugin_netzp_blog.translation.customFields`,
  COALESCE(
    `s_plugin_netzp_blog.translation.customFields`,
    `s_plugin_netzp_blog.translation.customFields`
  ) as `s_plugin_netzp_blog.customFields`,
  `s_plugin_netzp_blog.translation.createdAt`,
  `s_plugin_netzp_blog.translation.updatedAt`,
  `s_plugin_netzp_blog.translation.sPluginNetzpBlogId`,
  `s_plugin_netzp_blog.translation.languageId`
FROM
  `s_plugin_netzp_blog`
  LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.category` ON `s_plugin_netzp_blog`.`categoryid` = `s_plugin_netzp_blog.category`.`id`
  LEFT JOIN (
    SELECT
      `s_plugin_netzp_blog.translation`.s_plugin_netzp_blog_id,
      `s_plugin_netzp_blog.translation`.title as `s_plugin_netzp_blog.translation.title`,
      `s_plugin_netzp_blog.translation`.teaser as `s_plugin_netzp_blog.translation.teaser`,
      `s_plugin_netzp_blog.translation`.slug as `s_plugin_netzp_blog.translation.slug`,
      `s_plugin_netzp_blog.translation`.contents as `s_plugin_netzp_blog.translation.contents`,
      `s_plugin_netzp_blog.translation`.custom as `s_plugin_netzp_blog.translation.custom`,
      `s_plugin_netzp_blog.translation`.metatitle as `s_plugin_netzp_blog.translation.metatitle`,
      `s_plugin_netzp_blog.translation`.metadescription as `s_plugin_netzp_blog.translation.metadescription`,
      `s_plugin_netzp_blog.translation`.custom_fields as `s_plugin_netzp_blog.translation.customFields`,
      `s_plugin_netzp_blog.translation`.created_at as `s_plugin_netzp_blog.translation.createdAt`,
      `s_plugin_netzp_blog.translation`.updated_at as `s_plugin_netzp_blog.translation.updatedAt`,
      `s_plugin_netzp_blog.translation`.s_plugin_netzp_blog_id as `s_plugin_netzp_blog.translation.sPluginNetzpBlogId`,
      `s_plugin_netzp_blog.translation`.language_id as `s_plugin_netzp_blog.translation.languageId`
    FROM
      `s_plugin_netzp_blog_translation` `s_plugin_netzp_blog.translation`
    WHERE
      `s_plugin_netzp_blog.translation`.language_id = ?
  ) `s_plugin_netzp_blog.s_plugin_netzp_blog_translation` ON `s_plugin_netzp_blog.s_plugin_netzp_blog_translation`.`s_plugin_netzp_blog_id` = `s_plugin_netzp_blog`.`id`
  LEFT JOIN `s_plugin_netzp_blog_author` `s_plugin_netzp_blog.author` ON `s_plugin_netzp_blog`.`authorid` = `s_plugin_netzp_blog.author`.`id`
  LEFT JOIN `media` `s_plugin_netzp_blog.image` ON `s_plugin_netzp_blog`.`imageid` = `s_plugin_netzp_blog.image`.`id`
  LEFT JOIN `media` `s_plugin_netzp_blog.imagepreview` ON `s_plugin_netzp_blog`.`imagepreviewid` = `s_plugin_netzp_blog.imagepreview`.`id`
  LEFT JOIN `product_stream` `s_plugin_netzp_blog.productstream` ON `s_plugin_netzp_blog`.`productstreamid` = `s_plugin_netzp_blog.productstream`.`id`
  LEFT JOIN (
    SELECT
      `s_plugin_netzp_blog.category.translation`.s_plugin_netzp_blog_category_id,
      `s_plugin_netzp_blog.category.translation`.title as `s_plugin_netzp_blog.category.translation.title`,
      `s_plugin_netzp_blog.category.translation`.teaser as `s_plugin_netzp_blog.category.translation.teaser`,
      `s_plugin_netzp_blog.category.translation`.custom_fields as `s_plugin_netzp_blog.category.translation.customFields`,
      `s_plugin_netzp_blog.category.translation`.created_at as `s_plugin_netzp_blog.category.translation.createdAt`,
      `s_plugin_netzp_blog.category.translation`.updated_at as `s_plugin_netzp_blog.category.translation.updatedAt`,
      `s_plugin_netzp_blog.category.translation`.s_plugin_netzp_blog_category_id as `s_plugin_netzp_blog.category.translation.sPluginNetzpBlogCategoryId`,
      `s_plugin_netzp_blog.category.translation`.language_id as `s_plugin_netzp_blog.category.translation.languageId`
    FROM
      `s_plugin_netzp_blog_category_translation` `s_plugin_netzp_blog.category.translation`
    WHERE
      `s_plugin_netzp_blog.category.translation`.language_id = ?
  ) `s_plugin_netzp_blog.category.s_plugin_netzp_blog_category_translation` ON `s_plugin_netzp_blog.category.s_plugin_netzp_blog_category_translation`.`s_plugin_netzp_blog_category_id` = `s_plugin_netzp_blog.category`.`id`
  LEFT JOIN `sales_channel` `s_plugin_netzp_blog.category.saleschannel` ON `s_plugin_netzp_blog.category`.`saleschannel_id` = `s_plugin_netzp_blog.category.saleschannel`.`id`
  LEFT JOIN `customer_group` `s_plugin_netzp_blog.category.customergroup` ON `s_plugin_netzp_blog.category`.`customergroup_id` = `s_plugin_netzp_blog.category.customergroup`.`id`
  LEFT JOIN (
    SELECT
      `s_plugin_netzp_blog.category.saleschannel.translation`.sales_channel_id,
      `s_plugin_netzp_blog.category.saleschannel.translation`.name as `s_plugin_netzp_blog.category.saleschannel.translation.name`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.home_slot_config as `s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.home_enabled as `s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.home_name as `s_plugin_netzp_blog.category.saleschannel.translation.homeName`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.home_meta_title as `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.home_meta_description as `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.home_keywords as `s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.custom_fields as `s_plugin_netzp_blog.category.saleschannel.translation.customFields`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.created_at as `s_plugin_netzp_blog.category.saleschannel.translation.createdAt`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.updated_at as `s_plugin_netzp_blog.category.saleschannel.translation.updatedAt`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.sales_channel_id as `s_plugin_netzp_blog.category.saleschannel.translation.salesChannelId`,
      `s_plugin_netzp_blog.category.saleschannel.translation`.language_id as `s_plugin_netzp_blog.category.saleschannel.translation.languageId`
    FROM
      `sales_channel_translation` `s_plugin_netzp_blog.category.saleschannel.translation`
    WHERE
      `s_plugin_netzp_blog.category.saleschannel.translation`.language_id = ?
  ) `s_plugin_netzp_blog.category.saleschannel.sales_channel_translation` ON `s_plugin_netzp_blog.category.saleschannel.sales_channel_translation`.`sales_channel_id` = `s_plugin_netzp_blog.category.saleschannel`.`id`
  LEFT JOIN (
    SELECT
      `s_plugin_netzp_blog.category.customergroup.translation`.customer_group_id,
      `s_plugin_netzp_blog.category.customergroup.translation`.name as `s_plugin_netzp_blog.category.customergroup.translation.name`,
      `s_plugin_netzp_blog.category.customergroup.translation`.registration_title as `s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`,
      `s_plugin_netzp_blog.category.customergroup.translation`.registration_introduction as `s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`,
      `s_plugin_netzp_blog.category.customergroup.translation`.registration_only_company_registration as `s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`,
      `s_plugin_netzp_blog.category.customergroup.translation`.registration_seo_meta_description as `s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`,
      `s_plugin_netzp_blog.category.customergroup.translation`.custom_fields as `s_plugin_netzp_blog.category.customergroup.translation.customFields`,
      `s_plugin_netzp_blog.category.customergroup.translation`.created_at as `s_plugin_netzp_blog.category.customergroup.translation.createdAt`,
      `s_plugin_netzp_blog.category.customergroup.translation`.updated_at as `s_plugin_netzp_blog.category.customergroup.translation.updatedAt`,
      `s_plugin_netzp_blog.category.customergroup.translation`.customer_group_id as `s_plugin_netzp_blog.category.customergroup.translation.customerGroupId`,
      `s_plugin_netzp_blog.category.customergroup.translation`.language_id as `s_plugin_netzp_blog.category.customergroup.translation.languageId`
    FROM
      `customer_group_translation` `s_plugin_netzp_blog.category.customergroup.translation`
    WHERE
      `s_plugin_netzp_blog.category.customergroup.translation`.language_id = ?
  ) `s_plugin_netzp_blog.category.customergroup.customer_group_translation` ON `s_plugin_netzp_blog.category.customergroup.customer_group_translation`.`customer_group_id` = `s_plugin_netzp_blog.category.customergroup`.`id`
  LEFT JOIN (
    SELECT
      `s_plugin_netzp_blog.author.translation`.s_plugin_netzp_blog_author_id,
      `s_plugin_netzp_blog.author.translation`.name as `s_plugin_netzp_blog.author.translation.name`,
      `s_plugin_netzp_blog.author.translation`.bio as `s_plugin_netzp_blog.author.translation.bio`,
      `s_plugin_netzp_blog.author.translation`.custom_fields as `s_plugin_netzp_blog.author.translation.customFields`,
      `s_plugin_netzp_blog.author.translation`.created_at as `s_plugin_netzp_blog.author.translation.createdAt`,
      `s_plugin_netzp_blog.author.translation`.updated_at as `s_plugin_netzp_blog.author.translation.updatedAt`,
      `s_plugin_netzp_blog.author.translation`.s_plugin_netzp_blog_author_id as `s_plugin_netzp_blog.author.translation.sPluginNetzpBlogAuthorId`,
      `s_plugin_netzp_blog.author.translation`.language_id as `s_plugin_netzp_blog.author.translation.languageId`
    FROM
      `s_plugin_netzp_blog_author_translation` `s_plugin_netzp_blog.author.translation`
    WHERE
      `s_plugin_netzp_blog.author.translation`.language_id = ?
  ) `s_plugin_netzp_blog.author.s_plugin_netzp_blog_author_translation` ON `s_plugin_netzp_blog.author.s_plugin_netzp_blog_author_translation`.`s_plugin_netzp_blog_author_id` = `s_plugin_netzp_blog.author`.`id`
  LEFT JOIN `media` `s_plugin_netzp_blog.author.image` ON `s_plugin_netzp_blog.author`.`imageid` = `s_plugin_netzp_blog.author.image`.`id`
  LEFT JOIN (
    SELECT
      `s_plugin_netzp_blog.author.image.translation`.media_id,
      `s_plugin_netzp_blog.author.image.translation`.title as `s_plugin_netzp_blog.author.image.translation.title`,
      `s_plugin_netzp_blog.author.image.translation`.alt as `s_plugin_netzp_blog.author.image.translation.alt`,
      `s_plugin_netzp_blog.author.image.translation`.custom_fields as `s_plugin_netzp_blog.author.image.translation.customFields`,
      `s_plugin_netzp_blog.author.image.translation`.created_at as `s_plugin_netzp_blog.author.image.translation.createdAt`,
      `s_plugin_netzp_blog.author.image.translation`.updated_at as `s_plugin_netzp_blog.author.image.translation.updatedAt`,
      `s_plugin_netzp_blog.author.image.translation`.media_id as `s_plugin_netzp_blog.author.image.translation.mediaId`,
      `s_plugin_netzp_blog.author.image.translation`.language_id as `s_plugin_netzp_blog.author.image.translation.languageId`
    FROM
      `media_translation` `s_plugin_netzp_blog.author.image.translation`
    WHERE
      `s_plugin_netzp_blog.author.image.translation`.language_id = ?
  ) `s_plugin_netzp_blog.author.image.media_translation` ON `s_plugin_netzp_blog.author.image.media_translation`.`media_id` = `s_plugin_netzp_blog.author.image`.`id`
  LEFT JOIN (
    SELECT
      `s_plugin_netzp_blog.image.translation`.media_id,
      `s_plugin_netzp_blog.image.translation`.title as `s_plugin_netzp_blog.image.translation.title`,
      `s_plugin_netzp_blog.image.translation`.alt as `s_plugin_netzp_blog.image.translation.alt`,
      `s_plugin_netzp_blog.image.translation`.custom_fields as `s_plugin_netzp_blog.image.translation.customFields`,
      `s_plugin_netzp_blog.image.translation`.created_at as `s_plugin_netzp_blog.image.translation.createdAt`,
      `s_plugin_netzp_blog.image.translation`.updated_at as `s_plugin_netzp_blog.image.translation.updatedAt`,
      `s_plugin_netzp_blog.image.translation`.media_id as `s_plugin_netzp_blog.image.translation.mediaId`,
      `s_plugin_netzp_blog.image.translation`.language_id as `s_plugin_netzp_blog.image.translation.languageId`
    FROM
      `media_translation` `s_plugin_netzp_blog.image.translation`
    WHERE
      `s_plugin_netzp_blog.image.translation`.language_id = ?
  ) `s_plugin_netzp_blog.image.media_translation` ON `s_plugin_netzp_blog.image.media_translation`.`media_id` = `s_plugin_netzp_blog.image`.`id`
  LEFT JOIN (
    SELECT
      `s_plugin_netzp_blog.imagepreview.translation`.media_id,
      `s_plugin_netzp_blog.imagepreview.translation`.title as `s_plugin_netzp_blog.imagepreview.translation.title`,
      `s_plugin_netzp_blog.imagepreview.translation`.alt as `s_plugin_netzp_blog.imagepreview.translation.alt`,
      `s_plugin_netzp_blog.imagepreview.translation`.custom_fields as `s_plugin_netzp_blog.imagepreview.translation.customFields`,
      `s_plugin_netzp_blog.imagepreview.translation`.created_at as `s_plugin_netzp_blog.imagepreview.translation.createdAt`,
      `s_plugin_netzp_blog.imagepreview.translation`.updated_at as `s_plugin_netzp_blog.imagepreview.translation.updatedAt`,
      `s_plugin_netzp_blog.imagepreview.translation`.media_id as `s_plugin_netzp_blog.imagepreview.translation.mediaId`,
      `s_plugin_netzp_blog.imagepreview.translation`.language_id as `s_plugin_netzp_blog.imagepreview.translation.languageId`
    FROM
      `media_translation` `s_plugin_netzp_blog.imagepreview.translation`
    WHERE
      `s_plugin_netzp_blog.imagepreview.translation`.language_id = ?
  ) `s_plugin_netzp_blog.imagepreview.media_translation` ON `s_plugin_netzp_blog.imagepreview.media_translation`.`media_id` = `s_plugin_netzp_blog.imagepreview`.`id`
  LEFT JOIN (
    SELECT
      `s_plugin_netzp_blog.productstream.translation`.product_stream_id,
      `s_plugin_netzp_blog.productstream.translation`.name as `s_plugin_netzp_blog.productstream.translation.name`,
      `s_plugin_netzp_blog.productstream.translation`.description as `s_plugin_netzp_blog.productstream.translation.description`,
      `s_plugin_netzp_blog.productstream.translation`.custom_fields as `s_plugin_netzp_blog.productstream.translation.customFields`,
      `s_plugin_netzp_blog.productstream.translation`.created_at as `s_plugin_netzp_blog.productstream.translation.createdAt`,
      `s_plugin_netzp_blog.productstream.translation`.updated_at as `s_plugin_netzp_blog.productstream.translation.updatedAt`,
      `s_plugin_netzp_blog.productstream.translation`.product_stream_id as `s_plugin_netzp_blog.productstream.translation.productStreamId`,
      `s_plugin_netzp_blog.productstream.translation`.language_id as `s_plugin_netzp_blog.productstream.translation.languageId`
    FROM
      `product_stream_translation` `s_plugin_netzp_blog.productstream.translation`
    WHERE
      `s_plugin_netzp_blog.productstream.translation`.language_id = ?
  ) `s_plugin_netzp_blog.productstream.product_stream_translation` ON `s_plugin_netzp_blog.productstream.product_stream_translation`.`product_stream_id` = `s_plugin_netzp_blog.productstream`.`id`
WHERE
  (
    `s_plugin_netzp_blog`.`id` = ?
    AND (
      `s_plugin_netzp_blog.category`.`saleschannel_id` <=> ?
      OR `s_plugin_netzp_blog.category`.`saleschannel_id` = ?
      OR `s_plugin_netzp_blog.category`.`saleschannel_id` = ?
    )
    AND (
      `s_plugin_netzp_blog`.`categoryid` = ?
      OR `s_plugin_netzp_blog.category`.`onlyloggedin` = ?
      OR (
        `s_plugin_netzp_blog.category`.`onlyloggedin` = ?
        AND `s_plugin_netzp_blog.category`.`onlyloggedin` = ?
      )
    )
    AND (
      `s_plugin_netzp_blog.category`.`customergroup_id` <=> ?
      OR `s_plugin_netzp_blog.category`.`customergroup_id` = ?
      OR (
        NOT (
          `s_plugin_netzp_blog.category`.`customergroup_id` <=> ?
        )
        AND `s_plugin_netzp_blog.category`.`customergroup_id` = ?
      )
    )
    AND (
      (
        `s_plugin_netzp_blog`.`showfrom` <= ?
      )
      OR `s_plugin_netzp_blog`.`showfrom` <=> ?
    )
    AND (
      (
        `s_plugin_netzp_blog`.`showuntil` >= ?
      )
      OR `s_plugin_netzp_blog`.`showuntil` <=> ?
    )
  )

SELECT `s_plugin_netzp_blog`.`id` as `s_plugin_netzp_blog.id`, `s_plugin_netzp_blog`.`postdate` as `s_plugin_netzp_blog.postdate`, `s_plugin_netzp_blog`.`showfrom` as `s_plugin_netzp_blog.showfrom`, `s_plugin_netzp_blog`.`showuntil` as `s_plugin_netzp_blog.showuntil`, `s_plugin_netzp_blog`.`noindex` as `s_plugin_netzp_blog.noindex`, `s_plugin_netzp_blog`.`canonicalUrl` as `s_plugin_netzp_blog.canonicalUrl`, `s_plugin_netzp_blog`.`sticky` as `s_plugin_netzp_blog.sticky`, `s_plugin_netzp_blog`.`isproductstream` as `s_plugin_netzp_blog.isproductstream`, `s_plugin_netzp_blog`.`imageid` as `s_plugin_netzp_blog.imageid`, `s_plugin_netzp_blog`.`imagepreviewid` as `s_plugin_netzp_blog.imagepreviewid`, `s_plugin_netzp_blog`.`categoryid` as `s_plugin_netzp_blog.categoryid`, `s_plugin_netzp_blog`.`authorid` as `s_plugin_netzp_blog.authorid`, `s_plugin_netzp_blog`.`productstreamid` as `s_plugin_netzp_blog.productstreamid`, `s_plugin_netzp_blog.category`.`id` as `s_plugin_netzp_blog.category.id`, `s_plugin_netzp_blog.category`.`saleschannel_id` as `s_plugin_netzp_blog.category.saleschannelid`, `s_plugin_netzp_blog.category`.`customergroup_id` as `s_plugin_netzp_blog.category.customergroupid`, `s_plugin_netzp_blog.category`.`navigationcategoryid` as `s_plugin_netzp_blog.category.navigationcategoryid`, `s_plugin_netzp_blog.category`.`cmspageid` as `s_plugin_netzp_blog.category.cmspageid`, `s_plugin_netzp_blog.category`.`onlyloggedin` as `s_plugin_netzp_blog.category.onlyloggedin`, `s_plugin_netzp_blog.category`.`includeinrss` as `s_plugin_netzp_blog.category.includeinrss`, `s_plugin_netzp_blog.category.saleschannel`.`id` as `s_plugin_netzp_blog.category.saleschannel.id`, `s_plugin_netzp_blog.category.saleschannel`.`type_id` as `s_plugin_netzp_blog.category.saleschannel.typeId`, `s_plugin_netzp_blog.category.saleschannel`.`language_id` as `s_plugin_netzp_blog.category.saleschannel.languageId`, `s_plugin_netzp_blog.category.saleschannel`.`customer_group_id` as `s_plugin_netzp_blog.category.saleschannel.customerGroupId`, `s_plugin_netzp_blog.category.saleschannel`.`currency_id` as `s_plugin_netzp_blog.category.saleschannel.currencyId`, `s_plugin_netzp_blog.category.saleschannel`.`payment_method_id` as `s_plugin_netzp_blog.category.saleschannel.paymentMethodId`, `s_plugin_netzp_blog.category.saleschannel`.`shipping_method_id` as `s_plugin_netzp_blog.category.saleschannel.shippingMethodId`, `s_plugin_netzp_blog.category.saleschannel`.`country_id` as `s_plugin_netzp_blog.category.saleschannel.countryId`, `s_plugin_netzp_blog.category.saleschannel`.`analytics_id` as `s_plugin_netzp_blog.category.saleschannel.analyticsId`, `s_plugin_netzp_blog.category.saleschannel`.`navigation_category_id` as `s_plugin_netzp_blog.category.saleschannel.navigationCategoryId`, `s_plugin_netzp_blog.category.saleschannel`.`navigation_category_version_id` as `s_plugin_netzp_blog.category.saleschannel.navigationCategoryVersionId`, `s_plugin_netzp_blog.category.saleschannel`.`navigation_category_depth` as `s_plugin_netzp_blog.category.saleschannel.navigationCategoryDepth`, `s_plugin_netzp_blog.category.saleschannel`.`footer_category_id` as `s_plugin_netzp_blog.category.saleschannel.footerCategoryId`, `s_plugin_netzp_blog.category.saleschannel`.`footer_category_version_id` as `s_plugin_netzp_blog.category.saleschannel.footerCategoryVersionId`, `s_plugin_netzp_blog.category.saleschannel`.`service_category_id` as `s_plugin_netzp_blog.category.saleschannel.serviceCategoryId`, `s_plugin_netzp_blog.category.saleschannel`.`service_category_version_id` as `s_plugin_netzp_blog.category.saleschannel.serviceCategoryVersionId`, `s_plugin_netzp_blog.category.saleschannel`.`mail_header_footer_id` as `s_plugin_netzp_blog.category.saleschannel.mailHeaderFooterId`, `s_plugin_netzp_blog.category.saleschannel`.`hreflang_default_domain_id` as `s_plugin_netzp_blog.category.saleschannel.hreflangDefaultDomainId`, `s_plugin_netzp_blog.category.saleschannel`.`short_name` as `s_plugin_netzp_blog.category.saleschannel.shortName`, `s_plugin_netzp_blog.category.saleschannel`.`tax_calculation_type` as `s_plugin_netzp_blog.category.saleschannel.taxCalculationType`, `s_plugin_netzp_blog.category.saleschannel`.`access_key` as `s_plugin_netzp_blog.category.saleschannel.accessKey`, `s_plugin_netzp_blog.category.saleschannel`.`configuration` as `s_plugin_netzp_blog.category.saleschannel.configuration`, `s_plugin_netzp_blog.category.saleschannel`.`active` as `s_plugin_netzp_blog.category.saleschannel.active`, `s_plugin_netzp_blog.category.saleschannel`.`hreflang_active` as `s_plugin_netzp_blog.category.saleschannel.hreflangActive`, `s_plugin_netzp_blog.category.saleschannel`.`maintenance` as `s_plugin_netzp_blog.category.saleschannel.maintenance`, `s_plugin_netzp_blog.category.saleschannel`.`maintenance_ip_whitelist` as `s_plugin_netzp_blog.category.saleschannel.maintenanceIpWhitelist`, `s_plugin_netzp_blog.category.saleschannel`.`payment_method_ids` as `s_plugin_netzp_blog.category.saleschannel.paymentMethodIds`, `s_plugin_netzp_blog.category.saleschannel`.`home_cms_page_id` as `s_plugin_netzp_blog.category.saleschannel.homeCmsPageId`, `s_plugin_netzp_blog.category.saleschannel`.`home_cms_page_version_id` as `s_plugin_netzp_blog.category.saleschannel.homeCmsPageVersionId`, `s_plugin_netzp_blog.category.saleschannel`.`created_at` as `s_plugin_netzp_blog.category.saleschannel.createdAt`, `s_plugin_netzp_blog.category.saleschannel`.`updated_at` as `s_plugin_netzp_blog.category.saleschannel.updatedAt`, `s_plugin_netzp_blog.category.saleschannel.translation.name`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.name`,`s_plugin_netzp_blog.category.saleschannel.translation.name`) as `s_plugin_netzp_blog.category.saleschannel.name`, `s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`,`s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`) as `s_plugin_netzp_blog.category.saleschannel.homeSlotConfig`, `s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`,`s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`) as `s_plugin_netzp_blog.category.saleschannel.homeEnabled`, `s_plugin_netzp_blog.category.saleschannel.translation.homeName`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeName`,`s_plugin_netzp_blog.category.saleschannel.translation.homeName`) as `s_plugin_netzp_blog.category.saleschannel.homeName`, `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`,`s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`) as `s_plugin_netzp_blog.category.saleschannel.homeMetaTitle`, `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`,`s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`) as `s_plugin_netzp_blog.category.saleschannel.homeMetaDescription`, `s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`,`s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`) as `s_plugin_netzp_blog.category.saleschannel.homeKeywords`, `s_plugin_netzp_blog.category.saleschannel.translation.customFields`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.customFields`,`s_plugin_netzp_blog.category.saleschannel.translation.customFields`) as `s_plugin_netzp_blog.category.saleschannel.customFields`, `s_plugin_netzp_blog.category.saleschannel.translation.createdAt`, `s_plugin_netzp_blog.category.saleschannel.translation.updatedAt`, `s_plugin_netzp_blog.category.saleschannel.translation.salesChannelId`, `s_plugin_netzp_blog.category.saleschannel.translation.languageId`, `s_plugin_netzp_blog.category.customergroup`.`id` as `s_plugin_netzp_blog.category.customergroup.id`, `s_plugin_netzp_blog.category.customergroup`.`display_gross` as `s_plugin_netzp_blog.category.customergroup.displayGross`, `s_plugin_netzp_blog.category.customergroup`.`registration_active` as `s_plugin_netzp_blog.category.customergroup.registrationActive`, `s_plugin_netzp_blog.category.customergroup`.`created_at` as `s_plugin_netzp_blog.category.customergroup.createdAt`, `s_plugin_netzp_blog.category.customergroup`.`updated_at` as `s_plugin_netzp_blog.category.customergroup.updatedAt`, `s_plugin_netzp_blog.category.customergroup.translation.name`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.name`,`s_plugin_netzp_blog.category.customergroup.translation.name`) as `s_plugin_netzp_blog.category.customergroup.name`, `s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`,`s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`) as `s_plugin_netzp_blog.category.customergroup.registrationTitle`, `s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`,`s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`) as `s_plugin_netzp_blog.category.customergroup.registrationIntroduction`, `s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`,`s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`) as `s_plugin_netzp_blog.category.customergroup.registrationOnlyCompanyRegistration`, `s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`,`s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`) as `s_plugin_netzp_blog.category.customergroup.registrationSeoMetaDescription`, `s_plugin_netzp_blog.category.customergroup.translation.customFields`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.customFields`,`s_plugin_netzp_blog.category.customergroup.translation.customFields`) as `s_plugin_netzp_blog.category.customergroup.customFields`, `s_plugin_netzp_blog.category.customergroup.translation.createdAt`, `s_plugin_netzp_blog.category.customergroup.translation.updatedAt`, `s_plugin_netzp_blog.category.customergroup.translation.customerGroupId`, `s_plugin_netzp_blog.category.customergroup.translation.languageId`, `s_plugin_netzp_blog.category`.`created_at` as `s_plugin_netzp_blog.category.createdAt`, `s_plugin_netzp_blog.category`.`updated_at` as `s_plugin_netzp_blog.category.updatedAt`, `s_plugin_netzp_blog.category.translation.title`, COALESCE(`s_plugin_netzp_blog.category.translation.title`,`s_plugin_netzp_blog.category.translation.title`) as `s_plugin_netzp_blog.category.title`, `s_plugin_netzp_blog.category.translation.teaser`, COALESCE(`s_plugin_netzp_blog.category.translation.teaser`,`s_plugin_netzp_blog.category.translation.teaser`) as `s_plugin_netzp_blog.category.teaser`, `s_plugin_netzp_blog.category.translation.customFields`, COALESCE(`s_plugin_netzp_blog.category.translation.customFields`,`s_plugin_netzp_blog.category.translation.customFields`) as `s_plugin_netzp_blog.category.customFields`, `s_plugin_netzp_blog.category.translation.createdAt`, `s_plugin_netzp_blog.category.translation.updatedAt`, `s_plugin_netzp_blog.category.translation.sPluginNetzpBlogCategoryId`, `s_plugin_netzp_blog.category.translation.languageId`, `s_plugin_netzp_blog.author`.`id` as `s_plugin_netzp_blog.author.id`, `s_plugin_netzp_blog.author`.`imageid` as `s_plugin_netzp_blog.author.imageid`, `s_plugin_netzp_blog.author`.`link` as `s_plugin_netzp_blog.author.link`, `s_plugin_netzp_blog.author.image`.`id` as `s_plugin_netzp_blog.author.image.id`, `s_plugin_netzp_blog.author.image`.`user_id` as `s_plugin_netzp_blog.author.image.userId`, `s_plugin_netzp_blog.author.image`.`media_folder_id` as `s_plugin_netzp_blog.author.image.mediaFolderId`, `s_plugin_netzp_blog.author.image`.`mime_type` as `s_plugin_netzp_blog.author.image.mimeType`, `s_plugin_netzp_blog.author.image`.`file_extension` as `s_plugin_netzp_blog.author.image.fileExtension`, `s_plugin_netzp_blog.author.image`.`uploaded_at` as `s_plugin_netzp_blog.author.image.uploadedAt`, `s_plugin_netzp_blog.author.image`.`file_name` as `s_plugin_netzp_blog.author.image.fileName`, `s_plugin_netzp_blog.author.image`.`file_size` as `s_plugin_netzp_blog.author.image.fileSize`, `s_plugin_netzp_blog.author.image`.`media_type` as `s_plugin_netzp_blog.author.image.mediaTypeRaw`, `s_plugin_netzp_blog.author.image`.`meta_data` as `s_plugin_netzp_blog.author.image.metaData`, `s_plugin_netzp_blog.author.image`.`config` as `s_plugin_netzp_blog.author.image.config`, `s_plugin_netzp_blog.author.image`.`path` as `s_plugin_netzp_blog.author.image.path`, `s_plugin_netzp_blog.author.image`.`private` as `s_plugin_netzp_blog.author.image.private`, `s_plugin_netzp_blog.author.image`.`thumbnails_ro` as `s_plugin_netzp_blog.author.image.thumbnailsRo`, `s_plugin_netzp_blog.author.image`.`created_at` as `s_plugin_netzp_blog.author.image.createdAt`, `s_plugin_netzp_blog.author.image`.`updated_at` as `s_plugin_netzp_blog.author.image.updatedAt`, `s_plugin_netzp_blog.author.image.translation.title`, COALESCE(`s_plugin_netzp_blog.author.image.translation.title`,`s_plugin_netzp_blog.author.image.translation.title`) as `s_plugin_netzp_blog.author.image.title`, `s_plugin_netzp_blog.author.image.translation.alt`, COALESCE(`s_plugin_netzp_blog.author.image.translation.alt`,`s_plugin_netzp_blog.author.image.translation.alt`) as `s_plugin_netzp_blog.author.image.alt`, `s_plugin_netzp_blog.author.image.translation.customFields`, COALESCE(`s_plugin_netzp_blog.author.image.translation.customFields`,`s_plugin_netzp_blog.author.image.translation.customFields`) as `s_plugin_netzp_blog.author.image.customFields`, `s_plugin_netzp_blog.author.image.translation.createdAt`, `s_plugin_netzp_blog.author.image.translation.updatedAt`, `s_plugin_netzp_blog.author.image.translation.mediaId`, `s_plugin_netzp_blog.author.image.translation.languageId`, `s_plugin_netzp_blog.author`.`created_at` as `s_plugin_netzp_blog.author.createdAt`, `s_plugin_netzp_blog.author`.`updated_at` as `s_plugin_netzp_blog.author.updatedAt`, `s_plugin_netzp_blog.author.translation.name`, COALESCE(`s_plugin_netzp_blog.author.translation.name`,`s_plugin_netzp_blog.author.translation.name`) as `s_plugin_netzp_blog.author.name`, `s_plugin_netzp_blog.author.translation.bio`, COALESCE(`s_plugin_netzp_blog.author.translation.bio`,`s_plugin_netzp_blog.author.translation.bio`) as `s_plugin_netzp_blog.author.bio`, `s_plugin_netzp_blog.author.translation.customFields`, COALESCE(`s_plugin_netzp_blog.author.translation.customFields`,`s_plugin_netzp_blog.author.translation.customFields`) as `s_plugin_netzp_blog.author.customFields`, `s_plugin_netzp_blog.author.translation.createdAt`, `s_plugin_netzp_blog.author.translation.updatedAt`, `s_plugin_netzp_blog.author.translation.sPluginNetzpBlogAuthorId`, `s_plugin_netzp_blog.author.translation.languageId`, `s_plugin_netzp_blog.image`.`id` as `s_plugin_netzp_blog.image.id`, `s_plugin_netzp_blog.image`.`user_id` as `s_plugin_netzp_blog.image.userId`, `s_plugin_netzp_blog.image`.`media_folder_id` as `s_plugin_netzp_blog.image.mediaFolderId`, `s_plugin_netzp_blog.image`.`mime_type` as `s_plugin_netzp_blog.image.mimeType`, `s_plugin_netzp_blog.image`.`file_extension` as `s_plugin_netzp_blog.image.fileExtension`, `s_plugin_netzp_blog.image`.`uploaded_at` as `s_plugin_netzp_blog.image.uploadedAt`, `s_plugin_netzp_blog.image`.`file_name` as `s_plugin_netzp_blog.image.fileName`, `s_plugin_netzp_blog.image`.`file_size` as `s_plugin_netzp_blog.image.fileSize`, `s_plugin_netzp_blog.image`.`media_type` as `s_plugin_netzp_blog.image.mediaTypeRaw`, `s_plugin_netzp_blog.image`.`meta_data` as `s_plugin_netzp_blog.image.metaData`, `s_plugin_netzp_blog.image`.`config` as `s_plugin_netzp_blog.image.config`, `s_plugin_netzp_blog.image`.`path` as `s_plugin_netzp_blog.image.path`, `s_plugin_netzp_blog.image`.`private` as `s_plugin_netzp_blog.image.private`, `s_plugin_netzp_blog.image`.`thumbnails_ro` as `s_plugin_netzp_blog.image.thumbnailsRo`, `s_plugin_netzp_blog.image`.`created_at` as `s_plugin_netzp_blog.image.createdAt`, `s_plugin_netzp_blog.image`.`updated_at` as `s_plugin_netzp_blog.image.updatedAt`, `s_plugin_netzp_blog.image.translation.title`, COALESCE(`s_plugin_netzp_blog.image.translation.title`,`s_plugin_netzp_blog.image.translation.title`) as `s_plugin_netzp_blog.image.title`, `s_plugin_netzp_blog.image.translation.alt`, COALESCE(`s_plugin_netzp_blog.image.translation.alt`,`s_plugin_netzp_blog.image.translation.alt`) as `s_plugin_netzp_blog.image.alt`, `s_plugin_netzp_blog.image.translation.customFields`, COALESCE(`s_plugin_netzp_blog.image.translation.customFields`,`s_plugin_netzp_blog.image.translation.customFields`) as `s_plugin_netzp_blog.image.customFields`, `s_plugin_netzp_blog.image.translation.createdAt`, `s_plugin_netzp_blog.image.translation.updatedAt`, `s_plugin_netzp_blog.image.translation.mediaId`, `s_plugin_netzp_blog.image.translation.languageId`, `s_plugin_netzp_blog.imagepreview`.`id` as `s_plugin_netzp_blog.imagepreview.id`, `s_plugin_netzp_blog.imagepreview`.`user_id` as `s_plugin_netzp_blog.imagepreview.userId`, `s_plugin_netzp_blog.imagepreview`.`media_folder_id` as `s_plugin_netzp_blog.imagepreview.mediaFolderId`, `s_plugin_netzp_blog.imagepreview`.`mime_type` as `s_plugin_netzp_blog.imagepreview.mimeType`, `s_plugin_netzp_blog.imagepreview`.`file_extension` as `s_plugin_netzp_blog.imagepreview.fileExtension`, `s_plugin_netzp_blog.imagepreview`.`uploaded_at` as `s_plugin_netzp_blog.imagepreview.uploadedAt`, `s_plugin_netzp_blog.imagepreview`.`file_name` as `s_plugin_netzp_blog.imagepreview.fileName`, `s_plugin_netzp_blog.imagepreview`.`file_size` as `s_plugin_netzp_blog.imagepreview.fileSize`, `s_plugin_netzp_blog.imagepreview`.`media_type` as `s_plugin_netzp_blog.imagepreview.mediaTypeRaw`, `s_plugin_netzp_blog.imagepreview`.`meta_data` as `s_plugin_netzp_blog.imagepreview.metaData`, `s_plugin_netzp_blog.imagepreview`.`config` as `s_plugin_netzp_blog.imagepreview.config`, `s_plugin_netzp_blog.imagepreview`.`path` as `s_plugin_netzp_blog.imagepreview.path`, `s_plugin_netzp_blog.imagepreview`.`private` as `s_plugin_netzp_blog.imagepreview.private`, `s_plugin_netzp_blog.imagepreview`.`thumbnails_ro` as `s_plugin_netzp_blog.imagepreview.thumbnailsRo`, `s_plugin_netzp_blog.imagepreview`.`created_at` as `s_plugin_netzp_blog.imagepreview.createdAt`, `s_plugin_netzp_blog.imagepreview`.`updated_at` as `s_plugin_netzp_blog.imagepreview.updatedAt`, `s_plugin_netzp_blog.imagepreview.translation.title`, COALESCE(`s_plugin_netzp_blog.imagepreview.translation.title`,`s_plugin_netzp_blog.imagepreview.translation.title`) as `s_plugin_netzp_blog.imagepreview.title`, `s_plugin_netzp_blog.imagepreview.translation.alt`, COALESCE(`s_plugin_netzp_blog.imagepreview.translation.alt`,`s_plugin_netzp_blog.imagepreview.translation.alt`) as `s_plugin_netzp_blog.imagepreview.alt`, `s_plugin_netzp_blog.imagepreview.translation.customFields`, COALESCE(`s_plugin_netzp_blog.imagepreview.translation.customFields`,`s_plugin_netzp_blog.imagepreview.translation.customFields`) as `s_plugin_netzp_blog.imagepreview.customFields`, `s_plugin_netzp_blog.imagepreview.translation.createdAt`, `s_plugin_netzp_blog.imagepreview.translation.updatedAt`, `s_plugin_netzp_blog.imagepreview.translation.mediaId`, `s_plugin_netzp_blog.imagepreview.translation.languageId`, `s_plugin_netzp_blog.productstream`.`id` as `s_plugin_netzp_blog.productstream.id`, `s_plugin_netzp_blog.productstream`.`api_filter` as `s_plugin_netzp_blog.productstream.apiFilter`, `s_plugin_netzp_blog.productstream`.`invalid` as `s_plugin_netzp_blog.productstream.invalid`, `s_plugin_netzp_blog.productstream`.`created_at` as `s_plugin_netzp_blog.productstream.createdAt`, `s_plugin_netzp_blog.productstream`.`updated_at` as `s_plugin_netzp_blog.productstream.updatedAt`, `s_plugin_netzp_blog.productstream.translation.name`, COALESCE(`s_plugin_netzp_blog.productstream.translation.name`,`s_plugin_netzp_blog.productstream.translation.name`) as `s_plugin_netzp_blog.productstream.name`, `s_plugin_netzp_blog.productstream.translation.description`, COALESCE(`s_plugin_netzp_blog.productstream.translation.description`,`s_plugin_netzp_blog.productstream.translation.description`) as `s_plugin_netzp_blog.productstream.description`, `s_plugin_netzp_blog.productstream.translation.customFields`, COALESCE(`s_plugin_netzp_blog.productstream.translation.customFields`,`s_plugin_netzp_blog.productstream.translation.customFields`) as `s_plugin_netzp_blog.productstream.customFields`, `s_plugin_netzp_blog.productstream.translation.createdAt`, `s_plugin_netzp_blog.productstream.translation.updatedAt`, `s_plugin_netzp_blog.productstream.translation.productStreamId`, `s_plugin_netzp_blog.productstream.translation.languageId`, `s_plugin_netzp_blog`.`created_at` as `s_plugin_netzp_blog.createdAt`, `s_plugin_netzp_blog`.`updated_at` as `s_plugin_netzp_blog.updatedAt`, (SELECT GROUP_CONCAT(HEX(`s_plugin_netzp_blog.products.mapping`.`product_id`) SEPARATOR '||')
                  FROM `s_plugin_netzp_blog_product` `s_plugin_netzp_blog.products.mapping`
                  WHERE `s_plugin_netzp_blog.products.mapping`.`blog_id` = `s_plugin_netzp_blog`.`id` ) as `s_plugin_netzp_blog.products.id_mapping`, (SELECT GROUP_CONCAT(HEX(`s_plugin_netzp_blog.categories.mapping`.`category_id`) SEPARATOR '||')
                  FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping`
                  WHERE `s_plugin_netzp_blog.categories.mapping`.`blog_id` = `s_plugin_netzp_blog`.`id` ) as `s_plugin_netzp_blog.categories.id_mapping`, (SELECT GROUP_CONCAT(HEX(`s_plugin_netzp_blog.tags.mapping`.`tag_id`) SEPARATOR '||')
                  FROM `s_plugin_netzp_blog_tag` `s_plugin_netzp_blog.tags.mapping`
                  WHERE `s_plugin_netzp_blog.tags.mapping`.`blog_id` = `s_plugin_netzp_blog`.`id` ) as `s_plugin_netzp_blog.tags.id_mapping`, `s_plugin_netzp_blog.translation.title`, COALESCE(`s_plugin_netzp_blog.translation.title`,`s_plugin_netzp_blog.translation.title`) as `s_plugin_netzp_blog.title`, `s_plugin_netzp_blog.translation.teaser`, COALESCE(`s_plugin_netzp_blog.translation.teaser`,`s_plugin_netzp_blog.translation.teaser`) as `s_plugin_netzp_blog.teaser`, `s_plugin_netzp_blog.translation.slug`, COALESCE(`s_plugin_netzp_blog.translation.slug`,`s_plugin_netzp_blog.translation.slug`) as `s_plugin_netzp_blog.slug`, `s_plugin_netzp_blog.translation.contents`, COALESCE(`s_plugin_netzp_blog.translation.contents`,`s_plugin_netzp_blog.translation.contents`) as `s_plugin_netzp_blog.contents`, `s_plugin_netzp_blog.translation.custom`, COALESCE(`s_plugin_netzp_blog.translation.custom`,`s_plugin_netzp_blog.translation.custom`) as `s_plugin_netzp_blog.custom`, `s_plugin_netzp_blog.translation.metatitle`, COALESCE(`s_plugin_netzp_blog.translation.metatitle`,`s_plugin_netzp_blog.translation.metatitle`) as `s_plugin_netzp_blog.metatitle`, `s_plugin_netzp_blog.translation.metadescription`, COALESCE(`s_plugin_netzp_blog.translation.metadescription`,`s_plugin_netzp_blog.translation.metadescription`) as `s_plugin_netzp_blog.metadescription`, `s_plugin_netzp_blog.translation.customFields`, COALESCE(`s_plugin_netzp_blog.translation.customFields`,`s_plugin_netzp_blog.translation.customFields`) as `s_plugin_netzp_blog.customFields`, `s_plugin_netzp_blog.translation.createdAt`, `s_plugin_netzp_blog.translation.updatedAt`, `s_plugin_netzp_blog.translation.sPluginNetzpBlogId`, `s_plugin_netzp_blog.translation.languageId` FROM `s_plugin_netzp_blog` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.category` ON `s_plugin_netzp_blog`.`categoryid` = `s_plugin_netzp_blog.category`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.translation`.s_plugin_netzp_blog_id, `s_plugin_netzp_blog.translation`.title as `s_plugin_netzp_blog.translation.title`, `s_plugin_netzp_blog.translation`.teaser as `s_plugin_netzp_blog.translation.teaser`, `s_plugin_netzp_blog.translation`.slug as `s_plugin_netzp_blog.translation.slug`, `s_plugin_netzp_blog.translation`.contents as `s_plugin_netzp_blog.translation.contents`, `s_plugin_netzp_blog.translation`.custom as `s_plugin_netzp_blog.translation.custom`, `s_plugin_netzp_blog.translation`.metatitle as `s_plugin_netzp_blog.translation.metatitle`, `s_plugin_netzp_blog.translation`.metadescription as `s_plugin_netzp_blog.translation.metadescription`, `s_plugin_netzp_blog.translation`.custom_fields as `s_plugin_netzp_blog.translation.customFields`, `s_plugin_netzp_blog.translation`.created_at as `s_plugin_netzp_blog.translation.createdAt`, `s_plugin_netzp_blog.translation`.updated_at as `s_plugin_netzp_blog.translation.updatedAt`, `s_plugin_netzp_blog.translation`.s_plugin_netzp_blog_id as `s_plugin_netzp_blog.translation.sPluginNetzpBlogId`, `s_plugin_netzp_blog.translation`.language_id as `s_plugin_netzp_blog.translation.languageId` FROM `s_plugin_netzp_blog_translation` `s_plugin_netzp_blog.translation` WHERE `s_plugin_netzp_blog.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `s_plugin_netzp_blog.s_plugin_netzp_blog_translation` ON `s_plugin_netzp_blog.s_plugin_netzp_blog_translation`.`s_plugin_netzp_blog_id` = `s_plugin_netzp_blog`.`id` LEFT JOIN `s_plugin_netzp_blog_author` `s_plugin_netzp_blog.author` ON `s_plugin_netzp_blog`.`authorid` = `s_plugin_netzp_blog.author`.`id` LEFT JOIN `media` `s_plugin_netzp_blog.image` ON `s_plugin_netzp_blog`.`imageid` = `s_plugin_netzp_blog.image`.`id` LEFT JOIN `media` `s_plugin_netzp_blog.imagepreview` ON `s_plugin_netzp_blog`.`imagepreviewid` = `s_plugin_netzp_blog.imagepreview`.`id` LEFT JOIN `product_stream` `s_plugin_netzp_blog.productstream` ON `s_plugin_netzp_blog`.`productstreamid` = `s_plugin_netzp_blog.productstream`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.category.translation`.s_plugin_netzp_blog_category_id, `s_plugin_netzp_blog.category.translation`.title as `s_plugin_netzp_blog.category.translation.title`, `s_plugin_netzp_blog.category.translation`.teaser as `s_plugin_netzp_blog.category.translation.teaser`, `s_plugin_netzp_blog.category.translation`.custom_fields as `s_plugin_netzp_blog.category.translation.customFields`, `s_plugin_netzp_blog.category.translation`.created_at as `s_plugin_netzp_blog.category.translation.createdAt`, `s_plugin_netzp_blog.category.translation`.updated_at as `s_plugin_netzp_blog.category.translation.updatedAt`, `s_plugin_netzp_blog.category.translation`.s_plugin_netzp_blog_category_id as `s_plugin_netzp_blog.category.translation.sPluginNetzpBlogCategoryId`, `s_plugin_netzp_blog.category.translation`.language_id as `s_plugin_netzp_blog.category.translation.languageId` FROM `s_plugin_netzp_blog_category_translation` `s_plugin_netzp_blog.category.translation` WHERE `s_plugin_netzp_blog.category.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `s_plugin_netzp_blog.category.s_plugin_netzp_blog_category_translation` ON `s_plugin_netzp_blog.category.s_plugin_netzp_blog_category_translation`.`s_plugin_netzp_blog_category_id` = `s_plugin_netzp_blog.category`.`id` LEFT JOIN `sales_channel` `s_plugin_netzp_blog.category.saleschannel` ON `s_plugin_netzp_blog.category`.`saleschannel_id` = `s_plugin_netzp_blog.category.saleschannel`.`id` LEFT JOIN `customer_group` `s_plugin_netzp_blog.category.customergroup` ON `s_plugin_netzp_blog.category`.`customergroup_id` = `s_plugin_netzp_blog.category.customergroup`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.category.saleschannel.translation`.sales_channel_id, `s_plugin_netzp_blog.category.saleschannel.translation`.name as `s_plugin_netzp_blog.category.saleschannel.translation.name`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_slot_config as `s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_enabled as `s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_name as `s_plugin_netzp_blog.category.saleschannel.translation.homeName`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_meta_title as `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_meta_description as `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_keywords as `s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`, `s_plugin_netzp_blog.category.saleschannel.translation`.custom_fields as `s_plugin_netzp_blog.category.saleschannel.translation.customFields`, `s_plugin_netzp_blog.category.saleschannel.translation`.created_at as `s_plugin_netzp_blog.category.saleschannel.translation.createdAt`, `s_plugin_netzp_blog.category.saleschannel.translation`.updated_at as `s_plugin_netzp_blog.category.saleschannel.translation.updatedAt`, `s_plugin_netzp_blog.category.saleschannel.translation`.sales_channel_id as `s_plugin_netzp_blog.category.saleschannel.translation.salesChannelId`, `s_plugin_netzp_blog.category.saleschannel.translation`.language_id as `s_plugin_netzp_blog.category.saleschannel.translation.languageId` FROM `sales_channel_translation` `s_plugin_netzp_blog.category.saleschannel.translation` WHERE `s_plugin_netzp_blog.category.saleschannel.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `s_plugin_netzp_blog.category.saleschannel.sales_channel_translation` ON `s_plugin_netzp_blog.category.saleschannel.sales_channel_translation`.`sales_channel_id` = `s_plugin_netzp_blog.category.saleschannel`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.category.customergroup.translation`.customer_group_id, `s_plugin_netzp_blog.category.customergroup.translation`.name as `s_plugin_netzp_blog.category.customergroup.translation.name`, `s_plugin_netzp_blog.category.customergroup.translation`.registration_title as `s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`, `s_plugin_netzp_blog.category.customergroup.translation`.registration_introduction as `s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`, `s_plugin_netzp_blog.category.customergroup.translation`.registration_only_company_registration as `s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`, `s_plugin_netzp_blog.category.customergroup.translation`.registration_seo_meta_description as `s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`, `s_plugin_netzp_blog.category.customergroup.translation`.custom_fields as `s_plugin_netzp_blog.category.customergroup.translation.customFields`, `s_plugin_netzp_blog.category.customergroup.translation`.created_at as `s_plugin_netzp_blog.category.customergroup.translation.createdAt`, `s_plugin_netzp_blog.category.customergroup.translation`.updated_at as `s_plugin_netzp_blog.category.customergroup.translation.updatedAt`, `s_plugin_netzp_blog.category.customergroup.translation`.customer_group_id as `s_plugin_netzp_blog.category.customergroup.translation.customerGroupId`, `s_plugin_netzp_blog.category.customergroup.translation`.language_id as `s_plugin_netzp_blog.category.customergroup.translation.languageId` FROM `customer_group_translation` `s_plugin_netzp_blog.category.customergroup.translation` WHERE `s_plugin_netzp_blog.category.customergroup.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `s_plugin_netzp_blog.category.customergroup.customer_group_translation` ON `s_plugin_netzp_blog.category.customergroup.customer_group_translation`.`customer_group_id` = `s_plugin_netzp_blog.category.customergroup`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.author.translation`.s_plugin_netzp_blog_author_id, `s_plugin_netzp_blog.author.translation`.name as `s_plugin_netzp_blog.author.translation.name`, `s_plugin_netzp_blog.author.translation`.bio as `s_plugin_netzp_blog.author.translation.bio`, `s_plugin_netzp_blog.author.translation`.custom_fields as `s_plugin_netzp_blog.author.translation.customFields`, `s_plugin_netzp_blog.author.translation`.created_at as `s_plugin_netzp_blog.author.translation.createdAt`, `s_plugin_netzp_blog.author.translation`.updated_at as `s_plugin_netzp_blog.author.translation.updatedAt`, `s_plugin_netzp_blog.author.translation`.s_plugin_netzp_blog_author_id as `s_plugin_netzp_blog.author.translation.sPluginNetzpBlogAuthorId`, `s_plugin_netzp_blog.author.translation`.language_id as `s_plugin_netzp_blog.author.translation.languageId` FROM `s_plugin_netzp_blog_author_translation` `s_plugin_netzp_blog.author.translation` WHERE `s_plugin_netzp_blog.author.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `s_plugin_netzp_blog.author.s_plugin_netzp_blog_author_translation` ON `s_plugin_netzp_blog.author.s_plugin_netzp_blog_author_translation`.`s_plugin_netzp_blog_author_id` = `s_plugin_netzp_blog.author`.`id` LEFT JOIN `media` `s_plugin_netzp_blog.author.image` ON `s_plugin_netzp_blog.author`.`imageid` = `s_plugin_netzp_blog.author.image`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.author.image.translation`.media_id, `s_plugin_netzp_blog.author.image.translation`.title as `s_plugin_netzp_blog.author.image.translation.title`, `s_plugin_netzp_blog.author.image.translation`.alt as `s_plugin_netzp_blog.author.image.translation.alt`, `s_plugin_netzp_blog.author.image.translation`.custom_fields as `s_plugin_netzp_blog.author.image.translation.customFields`, `s_plugin_netzp_blog.author.image.translation`.created_at as `s_plugin_netzp_blog.author.image.translation.createdAt`, `s_plugin_netzp_blog.author.image.translation`.updated_at as `s_plugin_netzp_blog.author.image.translation.updatedAt`, `s_plugin_netzp_blog.author.image.translation`.media_id as `s_plugin_netzp_blog.author.image.translation.mediaId`, `s_plugin_netzp_blog.author.image.translation`.language_id as `s_plugin_netzp_blog.author.image.translation.languageId` FROM `media_translation` `s_plugin_netzp_blog.author.image.translation` WHERE `s_plugin_netzp_blog.author.image.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `s_plugin_netzp_blog.author.image.media_translation` ON `s_plugin_netzp_blog.author.image.media_translation`.`media_id` = `s_plugin_netzp_blog.author.image`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.image.translation`.media_id, `s_plugin_netzp_blog.image.translation`.title as `s_plugin_netzp_blog.image.translation.title`, `s_plugin_netzp_blog.image.translation`.alt as `s_plugin_netzp_blog.image.translation.alt`, `s_plugin_netzp_blog.image.translation`.custom_fields as `s_plugin_netzp_blog.image.translation.customFields`, `s_plugin_netzp_blog.image.translation`.created_at as `s_plugin_netzp_blog.image.translation.createdAt`, `s_plugin_netzp_blog.image.translation`.updated_at as `s_plugin_netzp_blog.image.translation.updatedAt`, `s_plugin_netzp_blog.image.translation`.media_id as `s_plugin_netzp_blog.image.translation.mediaId`, `s_plugin_netzp_blog.image.translation`.language_id as `s_plugin_netzp_blog.image.translation.languageId` FROM `media_translation` `s_plugin_netzp_blog.image.translation` WHERE `s_plugin_netzp_blog.image.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `s_plugin_netzp_blog.image.media_translation` ON `s_plugin_netzp_blog.image.media_translation`.`media_id` = `s_plugin_netzp_blog.image`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.imagepreview.translation`.media_id, `s_plugin_netzp_blog.imagepreview.translation`.title as `s_plugin_netzp_blog.imagepreview.translation.title`, `s_plugin_netzp_blog.imagepreview.translation`.alt as `s_plugin_netzp_blog.imagepreview.translation.alt`, `s_plugin_netzp_blog.imagepreview.translation`.custom_fields as `s_plugin_netzp_blog.imagepreview.translation.customFields`, `s_plugin_netzp_blog.imagepreview.translation`.created_at as `s_plugin_netzp_blog.imagepreview.translation.createdAt`, `s_plugin_netzp_blog.imagepreview.translation`.updated_at as `s_plugin_netzp_blog.imagepreview.translation.updatedAt`, `s_plugin_netzp_blog.imagepreview.translation`.media_id as `s_plugin_netzp_blog.imagepreview.translation.mediaId`, `s_plugin_netzp_blog.imagepreview.translation`.language_id as `s_plugin_netzp_blog.imagepreview.translation.languageId` FROM `media_translation` `s_plugin_netzp_blog.imagepreview.translation` WHERE `s_plugin_netzp_blog.imagepreview.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `s_plugin_netzp_blog.imagepreview.media_translation` ON `s_plugin_netzp_blog.imagepreview.media_translation`.`media_id` = `s_plugin_netzp_blog.imagepreview`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.productstream.translation`.product_stream_id, `s_plugin_netzp_blog.productstream.translation`.name as `s_plugin_netzp_blog.productstream.translation.name`, `s_plugin_netzp_blog.productstream.translation`.description as `s_plugin_netzp_blog.productstream.translation.description`, `s_plugin_netzp_blog.productstream.translation`.custom_fields as `s_plugin_netzp_blog.productstream.translation.customFields`, `s_plugin_netzp_blog.productstream.translation`.created_at as `s_plugin_netzp_blog.productstream.translation.createdAt`, `s_plugin_netzp_blog.productstream.translation`.updated_at as `s_plugin_netzp_blog.productstream.translation.updatedAt`, `s_plugin_netzp_blog.productstream.translation`.product_stream_id as `s_plugin_netzp_blog.productstream.translation.productStreamId`, `s_plugin_netzp_blog.productstream.translation`.language_id as `s_plugin_netzp_blog.productstream.translation.languageId` FROM `product_stream_translation` `s_plugin_netzp_blog.productstream.translation` WHERE `s_plugin_netzp_blog.productstream.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `s_plugin_netzp_blog.productstream.product_stream_translation` ON `s_plugin_netzp_blog.productstream.product_stream_translation`.`product_stream_id` = `s_plugin_netzp_blog.productstream`.`id` WHERE (`s_plugin_netzp_blog`.`id` = 0xC7EF5D2DDD9649FEA6D01231A6878299 AND (`s_plugin_netzp_blog.category`.`saleschannel_id` <=> NULL OR `s_plugin_netzp_blog.category`.`saleschannel_id` = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0' OR `s_plugin_netzp_blog.category`.`saleschannel_id` = 0x23C98BBE2A9749CB9001245287EDCC2E) AND (`s_plugin_netzp_blog`.`categoryid` = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0' OR `s_plugin_netzp_blog.category`.`onlyloggedin` = 0 OR (`s_plugin_netzp_blog.category`.`onlyloggedin` = 1 AND `s_plugin_netzp_blog.category`.`onlyloggedin` = 0)) AND (`s_plugin_netzp_blog.category`.`customergroup_id` <=> NULL OR `s_plugin_netzp_blog.category`.`customergroup_id` = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0' OR (NOT (`s_plugin_netzp_blog.category`.`customergroup_id` <=> '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0') AND `s_plugin_netzp_blog.category`.`customergroup_id` = 0x70528091A831446D81912AA257383B0E)) AND ((`s_plugin_netzp_blog`.`showfrom` <= '2025-01-19') OR `s_plugin_netzp_blog`.`showfrom` <=> NULL) AND ((`s_plugin_netzp_blog`.`showuntil` >= '2025-01-19') OR `s_plugin_netzp_blog`.`showuntil` <=> NULL));