Symfony Profiler

# 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`
          ) = ?,
          '106.06060606061',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '53.030303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '22.727272727273',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '60.606060606061',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '60.606060606061',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '22.727272727273',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '37.878787878788',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '18.939393939394',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '22.727272727273',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '75.757575757576',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '37.878787878788',
          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`
          ) = ?,
          '53.030303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '26.515151515152',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '7.5757575757576',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '18.939393939394',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '9.469696969697',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '37.878787878788',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '18.939393939394',
          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`
          ) = ?,
          '53.030303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '26.515151515152',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '7.5757575757576',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '18.939393939394',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '9.469696969697',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '37.878787878788',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '18.939393939394',
          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.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.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.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.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.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.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 ?
        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 ?
        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 ?
        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`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'schriftenreihe' , '106.06060606061', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%schriftenreihe%' , '53.030303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'der' , '22.727272727273', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%der%' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'paul' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%paul%' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'schiller' , '60.606060606061', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%schiller%' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'stiftung' , '60.606060606061', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%stiftung%' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'für' , '22.727272727273', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%für%' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'natur' , '37.878787878788', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%natur%' , '18.939393939394', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'und' , '22.727272727273', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%und%' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'landschaft' , '75.757575757576', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%landschaft%' , '37.878787878788', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'schriftenreihe' , '53.030303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%schriftenreihe%' , '26.515151515152', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'der' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%der%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'paul' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%paul%' , '7.5757575757576', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'schiller' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%schiller%' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'stiftung' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%stiftung%' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'für' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%für%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'natur' , '18.939393939394', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%natur%' , '9.469696969697', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'und' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%und%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'landschaft' , '37.878787878788', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%landschaft%' , '18.939393939394', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'schriftenreihe' , '53.030303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%schriftenreihe%' , '26.515151515152', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'der' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%der%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'paul' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%paul%' , '7.5757575757576', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'schiller' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%schiller%' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'stiftung' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%stiftung%' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'für' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%für%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'natur' , '18.939393939394', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%natur%' , '9.469696969697', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'und' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%und%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'landschaft' , '37.878787878788', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%landschaft%' , '18.939393939394', 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-02-04 02:02:52')) AND (`moorl_magazine_article`.`show_until` <=> NULL OR (`moorl_magazine_article`.`show_until` >= '2026-02-04 02:02:52'))) AND (`moorl_magazine_article.salesChannels`.`id` <=> NULL OR `moorl_magazine_article.salesChannels`.`id` = 0x01914A3133A37822896D0C70B2FD3B67) 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`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'schriftenreihe' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%schriftenreihe%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'der' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%der%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'paul' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%paul%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'schiller' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%schiller%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'stiftung' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%stiftung%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'für' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%für%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'natur' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%natur%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'und' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%und%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'landschaft' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%landschaft%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'schriftenreihe' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%schriftenreihe%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'der' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%der%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'paul' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%paul%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'schiller' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%schiller%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'stiftung' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%stiftung%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'für' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%für%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'natur' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%natur%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'und' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%und%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'landschaft' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%landschaft%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'schriftenreihe' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%schriftenreihe%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'der' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%der%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'paul' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%paul%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'schiller' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%schiller%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'stiftung' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%stiftung%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'für' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%für%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'natur' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%natur%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'und' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%und%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'landschaft' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%landschaft%') GROUP BY id HAVING _score >= 5.6818181818182 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-02-04 02:02:52')) AND (`moorl_magazine_article`.`show_until` <=> NULL OR (`moorl_magazine_article`.`show_until` >= '2026-02-04 02:02:52'))) AND (`moorl_magazine_article.salesChannels`.`id` <=> NULL OR `moorl_magazine_article.salesChannels`.`id` = 0x01914A3133A37822896D0C70B2FD3B67) 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`;

# magazine-article-listing::aggregation::child-category
SELECT
  LOWER(
    HEX(
      `moorl_magazine_article.swCategories`.`id`
    )
  ) as `child-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`
          ) = ?,
          '106.06060606061',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '53.030303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '22.727272727273',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '60.606060606061',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '60.606060606061',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '22.727272727273',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '37.878787878788',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '18.939393939394',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '22.727272727273',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) = ?,
          '75.757575757576',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.name`
          ) LIKE ?,
          '37.878787878788',
          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`
          ) = ?,
          '53.030303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '26.515151515152',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '7.5757575757576',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '18.939393939394',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '9.469696969697',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) = ?,
          '37.878787878788',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.content`
          ) LIKE ?,
          '18.939393939394',
          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`
          ) = ?,
          '53.030303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '26.515151515152',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '7.5757575757576',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '30.30303030303',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '15.151515151515',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '18.939393939394',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '9.469696969697',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '11.363636363636',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '5.6818181818182',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) = ?,
          '37.878787878788',
          0
        ) + IF(
          COALESCE(
            `moorl_magazine_article.translation.metaDescription`
          ) LIKE ?,
          '18.939393939394',
          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.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.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.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.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.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.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 ?
        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 ?
        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 ?
        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_sw_category` `moorl_magazine_article.swCategories.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.swCategories.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 `category` `moorl_magazine_article.swCategories` ON `moorl_magazine_article.swCategories.mapping`.`category_id` = `moorl_magazine_article.swCategories`.`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 (
    (
      `moorl_magazine_article.swCategories`.`path` LIKE ?
    )
  )
GROUP BY
  `moorl_magazine_article.swCategories`.`id`

# magazine-article-listing::aggregation::child-category
SELECT LOWER(HEX(`moorl_magazine_article.swCategories`.`id`)) as `child-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`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' , '500', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'schriftenreihe' , '106.06060606061', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%schriftenreihe%' , '53.030303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'der' , '22.727272727273', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%der%' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'paul' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%paul%' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'schiller' , '60.606060606061', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%schiller%' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'stiftung' , '60.606060606061', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%stiftung%' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'für' , '22.727272727273', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%für%' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'natur' , '37.878787878788', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%natur%' , '18.939393939394', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'und' , '22.727272727273', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%und%' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) = 'landschaft' , '75.757575757576', 0) + IF(COALESCE(`moorl_magazine_article.translation.name`) LIKE '%landschaft%' , '37.878787878788', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'schriftenreihe' , '53.030303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%schriftenreihe%' , '26.515151515152', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'der' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%der%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'paul' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%paul%' , '7.5757575757576', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'schiller' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%schiller%' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'stiftung' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%stiftung%' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'für' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%für%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'natur' , '18.939393939394', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%natur%' , '9.469696969697', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'und' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%und%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) = 'landschaft' , '37.878787878788', 0) + IF(COALESCE(`moorl_magazine_article.translation.content`) LIKE '%landschaft%' , '18.939393939394', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' , '250', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' , '125', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'schriftenreihe' , '53.030303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%schriftenreihe%' , '26.515151515152', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'der' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%der%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'paul' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%paul%' , '7.5757575757576', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'schiller' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%schiller%' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'stiftung' , '30.30303030303', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%stiftung%' , '15.151515151515', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'für' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%für%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'natur' , '18.939393939394', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%natur%' , '9.469696969697', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'und' , '11.363636363636', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%und%' , '5.6818181818182', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'landschaft' , '37.878787878788', 0) + IF(COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%landschaft%' , '18.939393939394', 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-02-04 02:02:52')) AND (`moorl_magazine_article`.`show_until` <=> NULL OR (`moorl_magazine_article`.`show_until` >= '2026-02-04 02:02:52'))) AND (`moorl_magazine_article.salesChannels`.`id` <=> NULL OR `moorl_magazine_article.salesChannels`.`id` = 0x01914A3133A37822896D0C70B2FD3B67) 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`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'schriftenreihe' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%schriftenreihe%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'der' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%der%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'paul' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%paul%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'schiller' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%schiller%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'stiftung' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%stiftung%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'für' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%für%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'natur' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%natur%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'und' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%und%' OR COALESCE(`moorl_magazine_article.translation.name`) = 'landschaft' OR COALESCE(`moorl_magazine_article.translation.name`) LIKE '%landschaft%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'schriftenreihe' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%schriftenreihe%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'der' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%der%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'paul' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%paul%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'schiller' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%schiller%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'stiftung' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%stiftung%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'für' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%für%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'natur' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%natur%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'und' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%und%' OR COALESCE(`moorl_magazine_article.translation.content`) = 'landschaft' OR COALESCE(`moorl_magazine_article.translation.content`) LIKE '%landschaft%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%Schriftenreihe der Paul Schiller Stiftung für Natur und Landschaft%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'schriftenreihe' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%schriftenreihe%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'der' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%der%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'paul' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%paul%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'schiller' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%schiller%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'stiftung' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%stiftung%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'für' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%für%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'natur' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%natur%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'und' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%und%' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) = 'landschaft' OR COALESCE(`moorl_magazine_article.translation.metaDescription`) LIKE '%landschaft%') GROUP BY id HAVING _score >= 5.6818181818182 ORDER BY _score DESC) score_table ON score_table.`id` = `moorl_magazine_article`.`id`  LEFT JOIN `moorl_magazine_article_sw_category` `moorl_magazine_article.swCategories.mapping` ON `moorl_magazine_article`.`id` = `moorl_magazine_article.swCategories.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 `category` `moorl_magazine_article.swCategories` ON `moorl_magazine_article.swCategories.mapping`.`category_id` = `moorl_magazine_article.swCategories`.`id`  WHERE (((`moorl_magazine_article`.`active` = 1 AND ((`moorl_magazine_article`.`show_from` <=> NULL OR (`moorl_magazine_article`.`show_from` <= '2026-02-04 02:02:52')) AND (`moorl_magazine_article`.`show_until` <=> NULL OR (`moorl_magazine_article`.`show_until` >= '2026-02-04 02:02:52'))) AND (`moorl_magazine_article.salesChannels`.`id` <=> NULL OR `moorl_magazine_article.salesChannels`.`id` = 0x01914A3133A37822896D0C70B2FD3B67) 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 ((`moorl_magazine_article.swCategories`.`path` LIKE '%01918e435cac74ae90d65f9cea64ce79%')) GROUP BY `moorl_magazine_article.swCategories`.`id`;