commit d291084af68ed62596aad2230fccec710aa254e2
parent acd6d38a1eadbee377ffe56f3914c290247d550b
Author: Simon Kornblith <simon@simonster.com>
Date: Thu, 7 Mar 2013 19:47:57 -0500
Escape backslash
Diffstat:
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/chrome/content/zotero/xpcom/duplicates.js b/chrome/content/zotero/xpcom/duplicates.js
@@ -202,7 +202,7 @@ Zotero.Duplicates.prototype._findDuplicates = function () {
// DOI
var sql = "SELECT itemID, value FROM items JOIN itemData USING (itemID) "
+ "JOIN itemDataValues USING (valueID) "
- + "WHERE libraryID=? AND fieldID=? AND REGEXP('^10\.', value) "
+ + "WHERE libraryID=? AND fieldID=? AND REGEXP('^10\\.', value) "
+ "AND itemID NOT IN (SELECT itemID FROM deletedItems) "
+ "ORDER BY value";
var rows = Zotero.DB.query(sql, [this._libraryID, Zotero.ItemFields.getID('DOI')]);