Changeset 1542 for trunk/gregarius/admin/items.php

Timestamp:

08/23/06 22:39:49 (2 years ago)

Author:

cfriesen

Message:

Some SQL modifications. Hope this doesn't mess anything up..

Files:

• trunk/gregarius/admin/items.php (modified) (3 diffs)

trunk/gregarius/admin/items.php

@@ -96 +96 @@
                 break;
             }
-            $sql = " from ".getTable('item') ." i INNER JOIN " .getTable('channels') . " c ON c.id=i.cid "
+            $sql = " from ".getTable('item') ." i inner join " .getTable('channels') . " c on c.id=i.cid "
                    ." where 1=1 ";
 
@@ -131 +131 @@
                     }
 
-                    $tsql = " select distinct fid from ". getTable('metatag') . " m, "
-                            . getTable('tag') . " t"
-                            ." where m.tid=t.id and t.tag in ('"
+                    $tsql = " select distinct fid from ". getTable('metatag') . " m "
+                            . " inner join " . getTable('tag') . " t"
+                            . "   on t.id = m.tid "
+                            . " where t.tag in ('"
                             . implode("', '", $trimmed_exclude_tags) ."')";
                 }
@@ -151 +152 @@
                 //delete the tags for these items
                 $sqlids = "select distinct i.id,i.cid " . $sql
-                          . " and i.cid=c.id order by i.cid, i.id desc";
+                          . " order by i.cid, i.id desc";