Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $caty = 'Cat';
- $catymeta = get_post_meta($post->ID, $caty, TRUE);
- global $wpdb;
- global $post;
- $querystr = "
- SELECT distinct wposts.*
- FROM $wpdb->posts wposts
- LEFT JOIN $wpdb->postmeta wpostmeta ON wposts.ID = wpostmeta.post_id
- LEFT JOIN $wpdb->term_relationships ON (wposts.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 IN($catymeta)
- ";
- $pageposts = $wpdb->get_results($querystr, OBJECT);
- ?>
- <?php if ($pageposts): ?>
- <?php global $post; ?>
- <strong>Season 1</strong>
- <ol>
- <?php foreach ($pageposts as $post): ?>
- <?php ob_start(); the_title(); $showtitle = ob_get_clean(); if (strpos($showtitle,'Season 1') !== false) { ?>
- <?php setup_postdata($post); ?>
- <li><a href="<?php echo $recurl; ?>"><?php echo $showtitle; ?></a></li>
- <?php } ?>
- <?php endforeach; ?>
- </ol>
- <?php endif; ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement