www

commit 07c450acbf216bee15f141309c19d0bb435c45fb
parent 2f7bf480c074764582ce198dbbd24eba3681758c
Author: Dan Stillman <dstillman@zotero.org>
Date:   Mon, 13 Dec 2010 22:10:06 +0000

Remove unnecessary joins


Diffstat:
M
chrome/content/zotero/xpcom/data/items.js
 | 
6
++----

1 file changed, 2 insertions(+), 4 deletions(-)
diff --git a/chrome/content/zotero/xpcom/data/items.js b/chrome/content/zotero/xpcom/data/items.js
@@ -522,8 +522,7 @@ Zotero.Items = new function() {
 			
 			// Then try editors
 			"CASE (" +
-				"SELECT COUNT(*) FROM itemCreators " +
-				"NATURAL JOIN creatorTypes WHERE itemID=I.itemID AND creatorTypeID IN (3)" +
+				"SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (3)" +
 			") " +
 			"WHEN 0 THEN NULL " +
 			"WHEN 1 THEN (" +
@@ -549,8 +548,7 @@ Zotero.Items = new function() {
 			
 			// Then try contributors
 			"CASE (" +
-				"SELECT COUNT(*) FROM itemCreators " +
-				"NATURAL JOIN creatorTypes WHERE itemID=I.itemID AND creatorTypeID IN (2)" +
+				"SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)" +
 			") " +
 			"WHEN 0 THEN NULL " +
 			"WHEN 1 THEN (" +