• 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.