Symfony Profiler

-- magazine-article-listing::aggregation::tag
SELECT
  LOWER(
    HEX(
      `moorl_magazine_article.tags`.`id`
    )
  ) as `tag`
FROM
  `moorl_magazine_article`
  LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`
  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`
  INNER JOIN (
    SELECT
      SUM(
        IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '500',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '250',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '166.66666666667',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '83.333333333333',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '300',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '150',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '250',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '125',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '83.333333333333',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '41.666666666667',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '150',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '75',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '250',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '125',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '83.333333333333',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '41.666666666667',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '150',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '75',
          0
        )
      ) / COUNT(moorl_magazine_article.id) as _score,
      `moorl_magazine_article`.`id`
    FROM
      `moorl_magazine_article`
      LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`
      LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`
      LEFT JOIN (
        SELECT
          `moorl_magazine_article.translation`.`moorl_magazine_article_id`,
          `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`,
          `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`,
          `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription`
        FROM
          `moorl_magazine_article_translation` `moorl_magazine_article.translation`
        WHERE
          `moorl_magazine_article.translation`.`language_id` = ?
      ) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id`
      LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`
      LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`
    WHERE
      (
        (
          (
            `moorl_magazine_article`.`active` = ?
            AND (
              (
                `moorl_magazine_article`.`show_from` <=> ?
                OR (
                  `moorl_magazine_article`.`show_from` <= ?
                )
              )
              AND (
                `moorl_magazine_article`.`show_until` <=> ?
                OR (
                  `moorl_magazine_article`.`show_until` >= ?
                )
              )
            )
            AND (
              `moorl_magazine_article.salesChannels`.`id` <=> ?
              OR `moorl_magazine_article.salesChannels`.`id` = ?
            )
            AND (
              `moorl_magazine_article.customerGroups`.`id` <=> ?
              OR `moorl_magazine_article.customerGroups`.`id` = ?
            )
            AND `moorl_magazine_article`.`invisible` = ?
          )
          AND `moorl_magazine_article`.`invisible` = ?
        )
      )
      AND (
        COALESCE(
          `moorl_magazine_article.translation.name`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) LIKE ?
      )
    GROUP BY
      id
    HAVING
      _score >= ?
    ORDER BY
      _score DESC
  ) score_table ON score_table.`id` = `moorl_magazine_article`.`id`
  LEFT JOIN `moorl_magazine_article_tag` `moorl_magazine_article.tags.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.tags.mapping`.`article_id`
  LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`
  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`
  LEFT JOIN `tag` `moorl_magazine_article.tags` ON `moorl_magazine_article.tags.mapping`.`tag_id` = `moorl_magazine_article.tags`.`id`
WHERE
  (
    (
      `moorl_magazine_article`.`active` = ?
      AND (
        (
          `moorl_magazine_article`.`show_from` <=> ?
          OR (
            `moorl_magazine_article`.`show_from` <= ?
          )
        )
        AND (
          `moorl_magazine_article`.`show_until` <=> ?
          OR (
            `moorl_magazine_article`.`show_until` >= ?
          )
        )
      )
      AND (
        `moorl_magazine_article.salesChannels`.`id` <=> ?
        OR `moorl_magazine_article.salesChannels`.`id` = ?
      )
      AND (
        `moorl_magazine_article.customerGroups`.`id` <=> ?
        OR `moorl_magazine_article.customerGroups`.`id` = ?
      )
      AND `moorl_magazine_article`.`invisible` = ?
    )
    AND `moorl_magazine_article`.`invisible` = ?
  )
GROUP BY
  `moorl_magazine_article.tags`.`id`

-- magazine-article-listing::aggregation::tag
SELECT LOWER(HEX(`moorl_magazine_article.tags`.`id`)) as `tag` FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  INNER JOIN (SELECT SUM(IF(COALESCE(`moorl_magazine_article.translation.name`) = 'flora helvetica' , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora helvetica%' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'flora' , '166.66666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora%' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'helvetica' , '300', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%helvetica%' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'flora helvetica' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora helvetica%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'flora' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora%' , '41.666666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'helvetica' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%helvetica%' , '75', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora helvetica' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora helvetica%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora%' , '41.666666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'helvetica' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%helvetica%' , '75', 0)) / COUNT(moorl_magazine_article.id) as _score, `moorl_magazine_article`.`id` FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  LEFT JOIN (SELECT `moorl_magazine_article.translation`.`moorl_magazine_article_id`, `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription` FROM `moorl_magazine_article_translation` `moorl_magazine_article.translation` WHERE `moorl_magazine_article.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id` LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  WHERE (((`moorl_magazine_article`.`active` = 1 AND ((`moorl_magazine_article`.`show_from` <=> NULL OR (`moorl_magazine_article`.`show_from` <= '2026-06-04 02:14:44')) AND (`moorl_magazine_article`.`show_until` <=> NULL OR (`moorl_magazine_article`.`show_until` >= '2026-06-04 02:14:44'))) AND (`moorl_magazine_article.salesChannels`.`id` <=> NULL OR `moorl_magazine_article.salesChannels`.`id` = 0x0190A64A9C267095B2C78AFFDE939AE0) AND (`moorl_magazine_article.customerGroups`.`id` <=> NULL OR `moorl_magazine_article.customerGroups`.`id` = 0xCFBD5018D38D41D8ADCA10D94FC8BDD6) AND `moorl_magazine_article`.`invisible` = 0) AND `moorl_magazine_article`.`invisible` = 0)) AND (COALESCE(`moorl_magazine_article.translation.name`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%helvetica%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%helvetica%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%helvetica%') GROUP BY id HAVING _score >= 41.666666666667 ORDER BY _score DESC) score_table ON score_table.`id` = `moorl_magazine_article`.`id`  LEFT JOIN `moorl_magazine_article_tag` `moorl_magazine_article.tags.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.tags.mapping`.`article_id`  LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  LEFT JOIN `tag` `moorl_magazine_article.tags` ON `moorl_magazine_article.tags.mapping`.`tag_id` = `moorl_magazine_article.tags`.`id`  WHERE ((`moorl_magazine_article`.`active` = 1 AND ((`moorl_magazine_article`.`show_from` <=> NULL OR (`moorl_magazine_article`.`show_from` <= '2026-06-04 02:14:44')) AND (`moorl_magazine_article`.`show_until` <=> NULL OR (`moorl_magazine_article`.`show_until` >= '2026-06-04 02:14:44'))) AND (`moorl_magazine_article.salesChannels`.`id` <=> NULL OR `moorl_magazine_article.salesChannels`.`id` = 0x0190A64A9C267095B2C78AFFDE939AE0) AND (`moorl_magazine_article.customerGroups`.`id` <=> NULL OR `moorl_magazine_article.customerGroups`.`id` = 0xCFBD5018D38D41D8ADCA10D94FC8BDD6) AND `moorl_magazine_article`.`invisible` = 0) AND `moorl_magazine_article`.`invisible` = 0) GROUP BY `moorl_magazine_article.tags`.`id`;

-- magazine-article-listing::search-ids
SELECT
  `moorl_magazine_article`.`id`,
  SUM(
    IF(
      COALESCE(
        `moorl_magazine_article.translation.name`
      ) = ?,
      '500',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.name`
      ) LIKE ?,
      '250',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.name`
      ) = ?,
      '166.66666666667',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.name`
      ) LIKE ?,
      '83.333333333333',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.name`
      ) = ?,
      '300',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.name`
      ) LIKE ?,
      '150',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.content`
      ) = ?,
      '250',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.content`
      ) LIKE ?,
      '125',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.content`
      ) = ?,
      '83.333333333333',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.content`
      ) LIKE ?,
      '41.666666666667',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.content`
      ) = ?,
      '150',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.content`
      ) LIKE ?,
      '75',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.metaDescription`
      ) = ?,
      '250',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.metaDescription`
      ) LIKE ?,
      '125',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.metaDescription`
      ) = ?,
      '83.333333333333',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.metaDescription`
      ) LIKE ?,
      '41.666666666667',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.metaDescription`
      ) = ?,
      '150',
      0
    ) + IF(
      COALESCE(
        `moorl_magazine_article.translation.metaDescription`
      ) LIKE ?,
      '75',
      0
    )
  ) / COUNT(moorl_magazine_article.id) as _score
FROM
  `moorl_magazine_article`
  LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`
  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`
  LEFT JOIN (
    SELECT
      `moorl_magazine_article.translation`.`moorl_magazine_article_id`,
      `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`,
      `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`,
      `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription`
    FROM
      `moorl_magazine_article_translation` `moorl_magazine_article.translation`
    WHERE
      `moorl_magazine_article.translation`.`language_id` = ?
  ) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id`
  LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`
  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`
WHERE
  (
    (
      (
        `moorl_magazine_article`.`active` = ?
        AND (
          (
            `moorl_magazine_article`.`show_from` <=> ?
            OR (
              `moorl_magazine_article`.`show_from` <= ?
            )
          )
          AND (
            `moorl_magazine_article`.`show_until` <=> ?
            OR (
              `moorl_magazine_article`.`show_until` >= ?
            )
          )
        )
        AND (
          `moorl_magazine_article.salesChannels`.`id` <=> ?
          OR `moorl_magazine_article.salesChannels`.`id` = ?
        )
        AND (
          `moorl_magazine_article.customerGroups`.`id` <=> ?
          OR `moorl_magazine_article.customerGroups`.`id` = ?
        )
        AND `moorl_magazine_article`.`invisible` = ?
      )
      AND `moorl_magazine_article`.`invisible` = ?
    )
  )
  AND (
    COALESCE(
      `moorl_magazine_article.translation.name`
    ) = ?
    OR COALESCE(
      `moorl_magazine_article.translation.name`
    ) LIKE ?
    OR COALESCE(
      `moorl_magazine_article.translation.name`
    ) = ?
    OR COALESCE(
      `moorl_magazine_article.translation.name`
    ) LIKE ?
    OR COALESCE(
      `moorl_magazine_article.translation.name`
    ) = ?
    OR COALESCE(
      `moorl_magazine_article.translation.name`
    ) LIKE ?
    OR COALESCE(
      `moorl_magazine_article.translation.content`
    ) = ?
    OR COALESCE(
      `moorl_magazine_article.translation.content`
    ) LIKE ?
    OR COALESCE(
      `moorl_magazine_article.translation.content`
    ) = ?
    OR COALESCE(
      `moorl_magazine_article.translation.content`
    ) LIKE ?
    OR COALESCE(
      `moorl_magazine_article.translation.content`
    ) = ?
    OR COALESCE(
      `moorl_magazine_article.translation.content`
    ) LIKE ?
    OR COALESCE(
      `moorl_magazine_article.translation.metaDescription`
    ) = ?
    OR COALESCE(
      `moorl_magazine_article.translation.metaDescription`
    ) LIKE ?
    OR COALESCE(
      `moorl_magazine_article.translation.metaDescription`
    ) = ?
    OR COALESCE(
      `moorl_magazine_article.translation.metaDescription`
    ) LIKE ?
    OR COALESCE(
      `moorl_magazine_article.translation.metaDescription`
    ) = ?
    OR COALESCE(
      `moorl_magazine_article.translation.metaDescription`
    ) LIKE ?
  )
GROUP BY
  `moorl_magazine_article`.`id`
HAVING
  _score >= ?
ORDER BY
  MAX(
    `moorl_magazine_article`.`date`
  ) DESC,
  MIN(`moorl_magazine_article`.`id`) ASC,
  MIN(`moorl_magazine_article`.`id`) ASC,
  _score DESC
LIMIT
  12

-- magazine-article-listing::search-ids
SELECT `moorl_magazine_article`.`id`, SUM(IF(COALESCE(`moorl_magazine_article.translation.name`) = 'flora helvetica' , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora helvetica%' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'flora' , '166.66666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora%' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'helvetica' , '300', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%helvetica%' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'flora helvetica' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora helvetica%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'flora' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora%' , '41.666666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'helvetica' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%helvetica%' , '75', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora helvetica' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora helvetica%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora%' , '41.666666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'helvetica' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%helvetica%' , '75', 0)) / COUNT(moorl_magazine_article.id) as _score FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  LEFT JOIN (SELECT `moorl_magazine_article.translation`.`moorl_magazine_article_id`, `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription` FROM `moorl_magazine_article_translation` `moorl_magazine_article.translation` WHERE `moorl_magazine_article.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id` LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  WHERE (((`moorl_magazine_article`.`active` = 1 AND ((`moorl_magazine_article`.`show_from` <=> NULL OR (`moorl_magazine_article`.`show_from` <= '2026-06-04 02:14:44')) AND (`moorl_magazine_article`.`show_until` <=> NULL OR (`moorl_magazine_article`.`show_until` >= '2026-06-04 02:14:44'))) AND (`moorl_magazine_article.salesChannels`.`id` <=> NULL OR `moorl_magazine_article.salesChannels`.`id` = 0x0190A64A9C267095B2C78AFFDE939AE0) AND (`moorl_magazine_article.customerGroups`.`id` <=> NULL OR `moorl_magazine_article.customerGroups`.`id` = 0xCFBD5018D38D41D8ADCA10D94FC8BDD6) AND `moorl_magazine_article`.`invisible` = 0) AND `moorl_magazine_article`.`invisible` = 0)) AND (COALESCE(`moorl_magazine_article.translation.name`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%helvetica%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%helvetica%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%helvetica%') GROUP BY `moorl_magazine_article`.`id` HAVING _score >= 41.666666666667 ORDER BY MAX(`moorl_magazine_article`.`date`) DESC, MIN(`moorl_magazine_article`.`id`) ASC, MIN(`moorl_magazine_article`.`id`) ASC, _score DESC LIMIT 12;

SELECT
  COUNT(*)
FROM
  (
    -- magazine-article-listing::search-ids
    SELECT
      `moorl_magazine_article`.`id`,
      SUM(
        IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '500',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '250',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '166.66666666667',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '83.333333333333',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '300',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '150',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '250',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '125',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '83.333333333333',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '41.666666666667',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '150',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '75',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '250',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '125',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '83.333333333333',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '41.666666666667',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '150',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '75',
          0
        )
      ) / COUNT(moorl_magazine_article.id) as _score
    FROM
      `moorl_magazine_article`
      LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`
      LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`
      LEFT JOIN (
        SELECT
          `moorl_magazine_article.translation`.`moorl_magazine_article_id`,
          `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`,
          `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`,
          `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription`
        FROM
          `moorl_magazine_article_translation` `moorl_magazine_article.translation`
        WHERE
          `moorl_magazine_article.translation`.`language_id` = ?
      ) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id`
      LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`
      LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`
    WHERE
      (
        (
          (
            `moorl_magazine_article`.`active` = ?
            AND (
              (
                `moorl_magazine_article`.`show_from` <=> ?
                OR (
                  `moorl_magazine_article`.`show_from` <= ?
                )
              )
              AND (
                `moorl_magazine_article`.`show_until` <=> ?
                OR (
                  `moorl_magazine_article`.`show_until` >= ?
                )
              )
            )
            AND (
              `moorl_magazine_article.salesChannels`.`id` <=> ?
              OR `moorl_magazine_article.salesChannels`.`id` = ?
            )
            AND (
              `moorl_magazine_article.customerGroups`.`id` <=> ?
              OR `moorl_magazine_article.customerGroups`.`id` = ?
            )
            AND `moorl_magazine_article`.`invisible` = ?
          )
          AND `moorl_magazine_article`.`invisible` = ?
        )
      )
      AND (
        COALESCE(
          `moorl_magazine_article.translation.name`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) LIKE ?
      )
    GROUP BY
      `moorl_magazine_article`.`id`
    HAVING
      _score >= ?
  ) total

SELECT COUNT(*) FROM (-- magazine-article-listing::search-ids
SELECT `moorl_magazine_article`.`id`, SUM(IF(COALESCE(`moorl_magazine_article.translation.name`) = 'flora helvetica' , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora helvetica%' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'flora' , '166.66666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora%' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'helvetica' , '300', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%helvetica%' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'flora helvetica' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora helvetica%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'flora' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora%' , '41.666666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'helvetica' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%helvetica%' , '75', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora helvetica' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora helvetica%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora%' , '41.666666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'helvetica' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%helvetica%' , '75', 0)) / COUNT(moorl_magazine_article.id) as _score FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  LEFT JOIN (SELECT `moorl_magazine_article.translation`.`moorl_magazine_article_id`, `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription` FROM `moorl_magazine_article_translation` `moorl_magazine_article.translation` WHERE `moorl_magazine_article.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id` LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  WHERE (((`moorl_magazine_article`.`active` = 1 AND ((`moorl_magazine_article`.`show_from` <=> NULL OR (`moorl_magazine_article`.`show_from` <= '2026-06-04 02:14:44')) AND (`moorl_magazine_article`.`show_until` <=> NULL OR (`moorl_magazine_article`.`show_until` >= '2026-06-04 02:14:44'))) AND (`moorl_magazine_article.salesChannels`.`id` <=> NULL OR `moorl_magazine_article.salesChannels`.`id` = 0x0190A64A9C267095B2C78AFFDE939AE0) AND (`moorl_magazine_article.customerGroups`.`id` <=> NULL OR `moorl_magazine_article.customerGroups`.`id` = 0xCFBD5018D38D41D8ADCA10D94FC8BDD6) AND `moorl_magazine_article`.`invisible` = 0) AND `moorl_magazine_article`.`invisible` = 0)) AND (COALESCE(`moorl_magazine_article.translation.name`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%helvetica%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%helvetica%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%helvetica%') GROUP BY `moorl_magazine_article`.`id` HAVING _score >= 41.666666666667) total;

-- magazine-article-listing::aggregation::magazine-article-category
SELECT
  LOWER(
    HEX(
      `moorl_magazine_article.categories`.`id`
    )
  ) as `magazine-article-category`
FROM
  `moorl_magazine_article`
  LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`
  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`
  INNER JOIN (
    SELECT
      SUM(
        IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '500',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '250',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '166.66666666667',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '83.333333333333',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '300',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '150',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '250',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '125',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '83.333333333333',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '41.666666666667',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '150',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '75',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '250',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '125',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '83.333333333333',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '41.666666666667',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '150',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '75',
          0
        )
      ) / COUNT(moorl_magazine_article.id) as _score,
      `moorl_magazine_article`.`id`
    FROM
      `moorl_magazine_article`
      LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`
      LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`
      LEFT JOIN (
        SELECT
          `moorl_magazine_article.translation`.`moorl_magazine_article_id`,
          `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`,
          `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`,
          `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription`
        FROM
          `moorl_magazine_article_translation` `moorl_magazine_article.translation`
        WHERE
          `moorl_magazine_article.translation`.`language_id` = ?
      ) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id`
      LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`
      LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`
    WHERE
      (
        (
          (
            `moorl_magazine_article`.`active` = ?
            AND (
              (
                `moorl_magazine_article`.`show_from` <=> ?
                OR (
                  `moorl_magazine_article`.`show_from` <= ?
                )
              )
              AND (
                `moorl_magazine_article`.`show_until` <=> ?
                OR (
                  `moorl_magazine_article`.`show_until` >= ?
                )
              )
            )
            AND (
              `moorl_magazine_article.salesChannels`.`id` <=> ?
              OR `moorl_magazine_article.salesChannels`.`id` = ?
            )
            AND (
              `moorl_magazine_article.customerGroups`.`id` <=> ?
              OR `moorl_magazine_article.customerGroups`.`id` = ?
            )
            AND `moorl_magazine_article`.`invisible` = ?
          )
          AND `moorl_magazine_article`.`invisible` = ?
        )
      )
      AND (
        COALESCE(
          `moorl_magazine_article.translation.name`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.name`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.content`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) LIKE ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) = ?
        OR COALESCE(
          `moorl_magazine_article.translation.metaDescription`
        ) LIKE ?
      )
    GROUP BY
      id
    HAVING
      _score >= ?
    ORDER BY
      _score DESC
  ) score_table ON score_table.`id` = `moorl_magazine_article`.`id`
  LEFT JOIN `moorl_magazine_article_category` `moorl_magazine_article.categories.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.categories.mapping`.`article_id`
  LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`
  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`
  LEFT JOIN `moorl_magazine_category` `moorl_magazine_article.categories` ON `moorl_magazine_article.categories.mapping`.`category_id` = `moorl_magazine_article.categories`.`id`
WHERE
  (
    (
      `moorl_magazine_article`.`active` = ?
      AND (
        (
          `moorl_magazine_article`.`show_from` <=> ?
          OR (
            `moorl_magazine_article`.`show_from` <= ?
          )
        )
        AND (
          `moorl_magazine_article`.`show_until` <=> ?
          OR (
            `moorl_magazine_article`.`show_until` >= ?
          )
        )
      )
      AND (
        `moorl_magazine_article.salesChannels`.`id` <=> ?
        OR `moorl_magazine_article.salesChannels`.`id` = ?
      )
      AND (
        `moorl_magazine_article.customerGroups`.`id` <=> ?
        OR `moorl_magazine_article.customerGroups`.`id` = ?
      )
      AND `moorl_magazine_article`.`invisible` = ?
    )
    AND `moorl_magazine_article`.`invisible` = ?
  )
GROUP BY
  `moorl_magazine_article.categories`.`id`

-- magazine-article-listing::aggregation::magazine-article-category
SELECT LOWER(HEX(`moorl_magazine_article.categories`.`id`)) as `magazine-article-category` FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  INNER JOIN (SELECT SUM(IF(COALESCE(`moorl_magazine_article.translation.name`) = 'flora helvetica' , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora helvetica%' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'flora' , '166.66666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora%' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'helvetica' , '300', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%helvetica%' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'flora helvetica' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora helvetica%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'flora' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora%' , '41.666666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'helvetica' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%helvetica%' , '75', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora helvetica' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora helvetica%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora' , '83.333333333333', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora%' , '41.666666666667', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'helvetica' , '150', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%helvetica%' , '75', 0)) / COUNT(moorl_magazine_article.id) as _score, `moorl_magazine_article`.`id` FROM `moorl_magazine_article` LEFT JOIN `moorl_magazine_article_sales_channel` `moorl_magazine_article.salesChannels.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.salesChannels.mapping`.`article_id`  LEFT JOIN `moorl_magazine_article_customer_group` `moorl_magazine_article.customerGroups.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.customerGroups.mapping`.`article_id`  LEFT JOIN (SELECT `moorl_magazine_article.translation`.`moorl_magazine_article_id`, `moorl_magazine_article.translation`.`name` as `moorl_magazine_article.translation.name`, `moorl_magazine_article.translation`.`content` as `moorl_magazine_article.translation.content`, `moorl_magazine_article.translation`.`meta_description` as `moorl_magazine_article.translation.metaDescription` FROM `moorl_magazine_article_translation` `moorl_magazine_article.translation` WHERE `moorl_magazine_article.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `moorl_magazine_article.moorl_magazine_article_translation` ON `moorl_magazine_article.moorl_magazine_article_translation`.`moorl_magazine_article_id` = `moorl_magazine_article`.`id` LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  WHERE (((`moorl_magazine_article`.`active` = 1 AND ((`moorl_magazine_article`.`show_from` <=> NULL OR (`moorl_magazine_article`.`show_from` <= '2026-06-04 02:14:44')) AND (`moorl_magazine_article`.`show_until` <=> NULL OR (`moorl_magazine_article`.`show_until` >= '2026-06-04 02:14:44'))) AND (`moorl_magazine_article.salesChannels`.`id` <=> NULL OR `moorl_magazine_article.salesChannels`.`id` = 0x0190A64A9C267095B2C78AFFDE939AE0) AND (`moorl_magazine_article.customerGroups`.`id` <=> NULL OR `moorl_magazine_article.customerGroups`.`id` = 0xCFBD5018D38D41D8ADCA10D94FC8BDD6) AND `moorl_magazine_article`.`invisible` = 0) AND `moorl_magazine_article`.`invisible` = 0)) AND (COALESCE(`moorl_magazine_article.translation.name`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%helvetica%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%helvetica%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora helvetica' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora helvetica%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'flora' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%flora%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'helvetica' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%helvetica%') GROUP BY id HAVING _score >= 41.666666666667 ORDER BY _score DESC) score_table ON score_table.`id` = `moorl_magazine_article`.`id`  LEFT JOIN `moorl_magazine_article_category` `moorl_magazine_article.categories.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.categories.mapping`.`article_id`  LEFT JOIN `sales_channel` `moorl_magazine_article.salesChannels` ON `moorl_magazine_article.salesChannels.mapping`.`sales_channel_id` = `moorl_magazine_article.salesChannels`.`id`  LEFT JOIN `customer_group` `moorl_magazine_article.customerGroups` ON `moorl_magazine_article.customerGroups.mapping`.`customer_group_id` = `moorl_magazine_article.customerGroups`.`id`  LEFT JOIN `moorl_magazine_category` `moorl_magazine_article.categories` ON `moorl_magazine_article.categories.mapping`.`category_id` = `moorl_magazine_article.categories`.`id`  WHERE ((`moorl_magazine_article`.`active` = 1 AND ((`moorl_magazine_article`.`show_from` <=> NULL OR (`moorl_magazine_article`.`show_from` <= '2026-06-04 02:14:44')) AND (`moorl_magazine_article`.`show_until` <=> NULL OR (`moorl_magazine_article`.`show_until` >= '2026-06-04 02:14:44'))) AND (`moorl_magazine_article.salesChannels`.`id` <=> NULL OR `moorl_magazine_article.salesChannels`.`id` = 0x0190A64A9C267095B2C78AFFDE939AE0) AND (`moorl_magazine_article.customerGroups`.`id` <=> NULL OR `moorl_magazine_article.customerGroups`.`id` = 0xCFBD5018D38D41D8ADCA10D94FC8BDD6) AND `moorl_magazine_article`.`invisible` = 0) AND `moorl_magazine_article`.`invisible` = 0) GROUP BY `moorl_magazine_article.categories`.`id`;