Changeset 5459
- Timestamp:
- 05/12/2007 07:47:47 PM (18 years ago)
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.1/wp-includes/post.php
r5092 r5459 225 225 if (!empty($exclusions)) 226 226 $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;235 227 236 228 $query = "SELECT DISTINCT * FROM $wpdb->posts "; -
branches/2.2/wp-includes/post.php
r5289 r5459 225 225 if (!empty($exclusions)) 226 226 $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;235 227 236 228 $query = "SELECT DISTINCT * FROM $wpdb->posts "; -
trunk/wp-includes/post.php
r5444 r5459 229 229 if (!empty($exclusions)) 230 230 $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;239 231 240 232 $query = "SELECT DISTINCT * FROM $wpdb->posts ";
Note: See TracChangeset
for help on using the changeset viewer.