artikel ging verloren -- Abfrage liefert nichts

<?php 


global $wpdb;


$category_id = intval(get_query_var('cat'));
$pageposts = $wpdb->get_results("SELECT *
FROM $wpdb->posts, $wpdb->postmeta
LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
WHERE $wpdb->term_taxonomy.term_id = $category_id
AND $wpdb->term_taxonomy.taxonomy = 'category'
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->postmeta.meta_key = 'kategorie-oben' ", OBJECT);
if ($pageposts): foreach ($pageposts as $post): setup_postdata($post); ?>


..ausgabe des Artikels