Und da ist er schon:
PHP
<?php get_header(); ?>
<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
<h2><?php the_title(); ?></h2>
<?php /* Hier wird Loop 1 unterbrochen */ ?>
<?php
$querystr = "
SELECT * FROM $wpdb->posts
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 = 67
AND $wpdb->term_taxonomy.taxonomy = 'category'
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->postmeta.meta_key = 'veranstaltungsdatum'
AND STR_TO_DATE($wpdb->postmeta.meta_value, '%Y-%m-%d') >= NOW()
ORDER BY $wpdb->postmeta.meta_value ASC
";
$myposts = $wpdb->get_results($querystr, OBJECT);
if($myposts) :
/* Hier geht Loop 2 los! */
foreach ($myposts as $post) :
setup_postdata($post);
?>
<li><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></li>
<?php /* Loop 2 zu Ende */ endforeach; endif; ?>
<?php /* ...ab hier soll wieder Loop 1 weitergehen */ ?>
<?php the_content(''); ?>
<?php edit_post_link('Beitrag bearbeiten.', '<p><small>', '</small></p>'); ?>
<?php endwhile; endif; ?>
<?php include ('sidebar.php'); ?>
<?php get_footer(); ?>Danke,
M.