Changeset 5459

Show
Ignore:
Timestamp:
05/12/07 19:47:47 (1 year ago)
Author:
rob1n
Message:

Seeing double. Good spot momo360modena. fixes #4251 for 2.1, 2.2 and 2.3

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • branches/2.1/wp-includes/post.php

    r5092 r5459  
    225225    if (!empty($exclusions)) 
    226226        $exclusions .= ')'; 
    227  
    228     $query ="SELECT DISTINCT * FROM $wpdb->posts " ; 
    229     $query .= ( empty( $category ) ? "" : ", $wpdb->post2cat " ); 
    230     $query .= ( empty( $meta_key ) ? "" : ", $wpdb->postmeta " ); 
    231     $query .= " WHERE (post_type = 'post' AND post_status = 'publish') $exclusions $inclusions "; 
    232     $query .= ( empty( $category ) ? "" : "AND ($wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.category_id = " . $category. ") " ); 
    233     $query .= ( empty( $meta_key ) | empty($meta_value)  ? "" : " AND ($wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = '$meta_key' AND $wpdb->postmeta.meta_value = '$meta_value' )" ); 
    234     $query .= " GROUP BY $wpdb->posts.ID ORDER BY " . $orderby . " " . $order . " LIMIT " . $offset . ',' . $numberposts; 
    235227 
    236228    $query  = "SELECT DISTINCT * FROM $wpdb->posts "; 

  • branches/2.2/wp-includes/post.php

    r5289 r5459  
    225225    if (!empty($exclusions)) 
    226226        $exclusions .= ')'; 
    227  
    228     $query ="SELECT DISTINCT * FROM $wpdb->posts " ; 
    229     $query .= ( empty( $category ) ? "" : ", $wpdb->post2cat " ); 
    230     $query .= ( empty( $meta_key ) ? "" : ", $wpdb->postmeta " ); 
    231     $query .= " WHERE (post_type = 'post' AND post_status = 'publish') $exclusions $inclusions "; 
    232     $query .= ( empty( $category ) ? "" : "AND ($wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.category_id = " . $category. ") " ); 
    233     $query .= ( empty( $meta_key ) | empty($meta_value)  ? "" : " AND ($wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = '$meta_key' AND $wpdb->postmeta.meta_value = '$meta_value' )" ); 
    234     $query .= " GROUP BY $wpdb->posts.ID ORDER BY " . $orderby . " " . $order . " LIMIT " . $offset . ',' . $numberposts; 
    235227 
    236228    $query  = "SELECT DISTINCT * FROM $wpdb->posts "; 

  • trunk/wp-includes/post.php

    r5444 r5459  
    229229    if (!empty($exclusions)) 
    230230        $exclusions .= ')'; 
    231  
    232     $query ="SELECT DISTINCT * FROM $wpdb->posts " ; 
    233     $query .= ( empty( $category ) ? "" : ", $wpdb->post2cat " ); 
    234     $query .= ( empty( $meta_key ) ? "" : ", $wpdb->postmeta " ); 
    235     $query .= " WHERE (post_type = 'post' AND post_status = 'publish') $exclusions $inclusions "; 
    236     $query .= ( empty( $category ) ? "" : "AND ($wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.category_id = " . $category. ") " ); 
    237     $query .= ( empty( $meta_key ) | empty($meta_value)  ? "" : " AND ($wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = '$meta_key' AND $wpdb->postmeta.meta_value = '$meta_value' )" ); 
    238     $query .= " GROUP BY $wpdb->posts.ID ORDER BY " . $orderby . " " . $order . " LIMIT " . $offset . ',' . $numberposts; 
    239231 
    240232    $query  = "SELECT DISTINCT * FROM $wpdb->posts ";