SELECT
   posts_post.ID AS post_ID,
   CONCAT('<a href="', posts_post.guid, '">', posts_post.post_title, '</a>') AS post_title_with_link_to_post,
   GROUP_CONCAT(DISTINCT post_meta_authors_tbl.meta_value) AS post_meta_authors,
   GROUP_CONCAT( DISTINCT post_taxonomy_category_tbl.name SEPARATOR ', ' ) AS post_taxonomy_category,
   posts_post.post_date as post_post_date
FROM
   wp_posts AS posts_post 
   INNER JOIN
      wp_users AS posts_post_author 
      ON posts_post_author.ID = posts_post.post_author 
   INNER JOIN
      (
         SELECT
            post_meta_authors_tbl_posts.ID AS id,
            meta_value,
            meta_key 
         FROM
            wp_postmeta AS post_meta_authors_tbl_postmeta 
            INNER JOIN
               wp_posts AS post_meta_authors_tbl_posts 
               ON post_meta_authors_tbl_postmeta.post_id = post_meta_authors_tbl_posts.ID 
               AND post_meta_authors_tbl_posts.post_type = 'post' 
      )
      AS post_meta_authors_tbl 
      ON post_meta_authors_tbl.meta_key = 'organization' 
      AND post_meta_authors_tbl.id = posts_post.ID 
   INNER JOIN
      (
         SELECT
            NAME,
            object_id AS id 
         FROM
            wp_terms AS post_taxonomy_category_tbl_terms 
            INNER JOIN
               wp_term_taxonomy AS post_taxonomy_category_tbl_termtaxonomy 
               ON post_taxonomy_category_tbl_termtaxonomy.term_id = post_taxonomy_category_tbl_terms.term_id 
               AND post_taxonomy_category_tbl_termtaxonomy.taxonomy = 'category' 
            INNER JOIN
               wp_term_relationships AS rel_post_taxonomy_category_tbl 
               ON post_taxonomy_category_tbl_termtaxonomy.term_taxonomy_id = rel_post_taxonomy_category_tbl.term_taxonomy_id 
      )
      AS post_taxonomy_category_tbl 
      ON post_taxonomy_category_tbl.ID = posts_post.id 
      AND post_taxonomy_category_tbl.name IN 
      (
        "Fact Check",
        "Corona",
        "EU",
        "Geschichte",
        "Gesellschaft",
        "Gesundheit",
        "Israel-Hamas-Konflikt",
        "Katastrophen",
        "Klimawandel",
        "LGBTQ+",
        "Migration",
        "Politik",
        "Russland",
        "Sport",
        "Technologie",
        "Ukraine",
        "Umwelt",
        "USA",
        "Verbraucher",
        "Wahlen",
        "Wirtschaft",
        "Wissenschaft"
      )
   LEFT JOIN
      wp_icl_translations AS wpml 
      ON wpml.element_id = posts_post.ID 
      AND wpml.language_code = 'de' 
WHERE
   1 = 1 
   AND posts_post.post_status = 'publish' 
   AND posts_post.post_type = 'post' 
   AND wpml.language_code IS NOT NULL 
GROUP BY
   post_ID