Changeset 1385 for trunk/bb-includes/class-bb-taxonomy.php

Timestamp:

03/30/2008 10:31:06 AM (18 years ago)

Author:

sambauers

Message:

Various optimisations and typo fixes - Fixes #842 - props momo360modena

File:

• trunk/bb-includes/class-bb-taxonomy.php (modified) (1 diff)

trunk/bb-includes/class-bb-taxonomy.php

@@ -170 +170 @@
             $select_this = 't.*, tt.*, tr.object_id';
 
-        $query = "SELECT $select_this FROM {$this->db->terms} AS t INNER JOIN {$this->db->term_taxonomy} AS tt ON tt.term_id = t.term_id INNER JOIN {$this->db->term_relationships} AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ($taxonomies) AND tr.object_id IN ($object_ids)$usr_sql ORDER BY $orderby $order";
+        $query = "SELECT $select_this FROM {$this->db->terms} AS t INNER JOIN {$this->db->term_taxonomy} AS tt ON tt.term_id = t.term_id INNER JOIN {$this->db->term_relationships} AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ($taxonomies) AND tr.object_id IN ($object_ids)$user_sql ORDER BY $orderby $order";
 
         if ( 'all' == $fields || 'all_with_object_id' == $fields ) {