Beitäge + Metadaten in einer Tabelle auflisten!

<?php
/*
Template Name: Tagesfahrten
*/
?>


<?php get_header(); ?>


<div id="main">
  <div class="post">
    <div class="entrybody">


      <h2>Tagesfahrten 2008</h2>


      <table id="tagesfahrten" cellpadding="0" cellspacing="0" border="0" class="sortable-onload-1-reverse rowstyle-alt no-arrow">
        <caption>Unsere Tagesfahrten 2008.</caption>


        <thead>
          <tr>
            <th class="sortable-keep">Nr.</th>
            <th class="sortable-date-dmy">Datum</th>
            <th class="sortable">Fahrt</th>
            <th class="sortable">Status</th>
          </tr>
        </thead>


<?php if (is_category('3')) {
$pageposts = $wpdb->get_results("SELECT *
FROM $wpdb->posts, $wpdb->postmeta
WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id
AND $wpdb->postmeta.meta_key = 'Tagesfahrtnummer'
ORDER BY meta_key DESC", OBJECT); ?>


        <tbody>
<?php if ($pageposts) : foreach ($pageposts as $post): setup_postdata($post); ?>
          <tr>
            <td><?php $key="Tagesfahrtnummer"; echo get_post_meta($post->ID, $key, true); ?></td>
            <td><?php $key="Reisedatum"; echo get_post_meta($post->ID, $key, true); ?></td>
            <td><a href="<?php the_permalink() ?>" rel="bookmark" title=" '<?php the_title(); ?>'"><?php the_title(); ?></td>
            <td><?php $key="Reisestatus"; echo get_post_meta($post->ID, $key, true); ?></td>
          </tr>


<?php endforeach;?>
        </tbody>


<?php endif; } ?>


      </table>


      <p>Weiterer Text</p>


    </div>
  </div>
</div>


<?php get_sidebar(); ?>
<?php get_footer(); ?>