diff options
| author | Gábor Hojtsy <gabor@hojtsy.hu> | 2007-09-06 13:03:18 +0000 |
|---|---|---|
| committer | Gábor Hojtsy <gabor@hojtsy.hu> | 2007-09-06 13:03:18 +0000 |
| commit | f2448fe718225ca23aa1fcb5f3785a55bf404680 (patch) | |
| tree | 506c2d80c3e6f7829200c6c1e7334ea5f837e77d | |
| parent | 21d005c7543d3d5a13069a1889a9549afca73d57 (diff) | |
| download | brdo-f2448fe718225ca23aa1fcb5f3785a55bf404680.tar.gz brdo-f2448fe718225ca23aa1fcb5f3785a55bf404680.tar.bz2 | |
#166780 by makara and blakehall: fix incorrect table name alias in taxonomy_select_nodes()
| -rw-r--r-- | modules/taxonomy/taxonomy.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/taxonomy/taxonomy.module b/modules/taxonomy/taxonomy.module index b557a810a..5a212e4db 100644 --- a/modules/taxonomy/taxonomy.module +++ b/modules/taxonomy/taxonomy.module @@ -951,7 +951,7 @@ function taxonomy_select_nodes($tids = array(), $operator = 'or', $depth = 0, $p if ($operator == 'or') { $str_tids = implode(',', call_user_func_array('array_merge', $descendant_tids)); - $sql = 'SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM {node} n INNER JOIN {term_node} tn ON n.vid = t.vid WHERE tn.tid IN ('. $str_tids .') AND n.status = 1 ORDER BY '. $order; + $sql = 'SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM {node} n INNER JOIN {term_node} tn ON n.vid = tn.vid WHERE tn.tid IN ('. $str_tids .') AND n.status = 1 ORDER BY '. $order; $sql_count = 'SELECT COUNT(DISTINCT(n.nid)) FROM {node} n INNER JOIN {term_node} tn ON n.vid = tn.vid WHERE tn.tid IN ('. $str_tids .') AND n.status = 1'; } else { |