Cat: 56
SELECT DISTINCT wposts.* FROM wpForschung1_posts wposts LEFT JOIN wpForschung1_postmeta wpostmeta ON wposts.ID = wpostmeta.post_id LEFT JOIN wpForschung1_term_relationships ON (wposts.ID = wpForschung1_term_relationships.object_id) LEFT JOIN wpForschung1_term_taxonomy ON (wpForschung1_term_relationships.term_taxonomy_id = wpForschung1_term_taxonomy.term_taxonomy_id) WHERE wposts.post_status = 'publish' AND wposts.post_type = 'post' AND wpForschung1_term_taxonomy.taxonomy = 'category' AND wpForschung1_term_taxonomy.term_id IN(56) ORDER BY wposts.post_sortiernummer DESC, post_date DESC LIMIT 0, 25

(Deutsch) Archiv für die Kategorie ‘_noindex_’