Query based on custom field and duplicate titles
-
I have the follow problem. I have an old website (before WordPress taxonomy) with some posts (companies). Companies are posts with metakey “field-company-type” and metavalue = “j”.
Each company can exists as distinct posts (same title, but different content) in multiple categories (so I can have a post called Microsoft in software section and again another post called also Microsoft (same title, but different content) in hardware section.
I want to display a list with all companies (but no double entries). So only one Microsoft in my example.
My below code – still display duplicates
<?php if ($companies = $wpdb->get_results("SELECT DISTINCT wposts.* FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_key = 'field-company-type' AND wpostmeta.meta_value = 'j' AND wposts.post_status = 'publish' AND wposts.post_type = 'post' AND wposts.post_date < NOW() ORDER BY wposts.post_title DESC")): ?> <ul> <?php foreach ($companies as $post) { if ($post->post_title == '') $post->post_title = sprintf(__('Post #%s'), $post->ID); echo "<li><a href='".get_permalink($post->ID)."'>"; the_title(); echo '</a></li>'; } ?> </ul> <?php endif; ?>
Can anybody help me with this?
- The topic ‘Query based on custom field and duplicate titles’ is closed to new replies.