baalam

Hi nzde

Here’s mine
My category number was 5 so I created a new template called category-5.php so you have to call it category-4.php and this is the complete code with your variables

<?php get_header(); ?><?php get_sidebar(); ?>
<div id="wrapper">

	<div class="mission">

	<?php

        if((function_exists('ls_getinfo')) && (ls_getinfo('isref'))) { ?>
<h2><?php ls_getinfo('terms'); ?></h2>

p>You came here from <?php ls_getinfo(‘referrer’); ?> searching for <i><?php ls_getinfo(‘terms’); ?></i>. These posts might be of interest:</p>
<ul>
<?php ls_related(5, 10, '<li>', '</li>', '', '', false, false); ?>
</ul>
  <?php }   else { ?>
<?php } ?></div>
        <div id="content">
<?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 = 4
AND $wpdb->term_taxonomy.taxonomy = 'category'
AND $wpdb->posts.post_status = 'publish'
AND $wpdb->postmeta.meta_key = 'Event_date'
ORDER BY $wpdb->postmeta.meta_value ASC
";

 $pageposts = $wpdb->get_results($querystr, OBJECT);

?>
 <?php if ($pageposts): ?>
  <?php foreach ($pageposts as $post): ?>
    <?php setup_postdata($post); ?>

    <div class="post" id="post-<?php the_ID(); ?>">
      <h2><?php the_title(); ?></h2>
            <div class="entry">
         <?php the_content('Read the rest of this entry »'); ?>
      </div>

    </div><hr />
  <?php endforeach; ?>

  <?php else : ?>
    <h2 class="center">Not Found</h2>
    <p class="center">Sorry, but you are looking for something that isn't here.</p>

 <?php endif; ?>
        </div>
</div>
<?php get_footer(); ?>

Thanks a lot iridiax!

Its working now … the only problem is that its showing the posts from the category 5 under every category!

Seems like is not respecting the taxonomy id and overwrites the other categories

Any suggestions?