[JavaScript Error: "[Exception... "Could not convert JavaScript argument arg 0 [nsIObserver.observe]"  nsresult: "0x80570009 (NS_ERROR_XPC_BAD_CONVERT_JS)"  location: "JS frame :: file:///opt/zotero/extensions/zoteroOpenOfficeIntegration@zotero.org/components/zoteroOpenOfficeIntegration.js :: <TOP_LEVEL> :: line 441"  data: no]" {file: "file:///opt/zotero/extensions/zoteroOpenOfficeIntegration@zotero.org/components/zoteroOpenOfficeIntegration.js" line: 441}]

version => 4.0.17, platform => Linux x86_64, oscpu => Linux x86_64, locale => en-US, appName => Zotero, appVersion => 4.0.17

=========================================================

(3)(+0000000): ZoteroOpenOfficeIntegration: Connection received

(3)(+0000000): ZoteroOpenOfficeIntegration: 21 bytes available

(3)(+0000001): ZoteroOpenOfficeIntegration: Read 0 "addCitation"

(3)(+0000002): Integration: Instantiating @zotero.org/Zotero/integration/application?agent=OpenOffice;1 for command addCitation

(3)(+0000001): ZoteroOpenOfficeIntegration: Sending 1 ["Application_getActiveDocument",[3]]

(3)(+0000003): ZoteroOpenOfficeIntegration: 13 bytes available

(3)(+0000000): ZoteroOpenOfficeIntegration: Read 1 [3,4]

(3)(+0000001): ZoteroOpenOfficeIntegration: Sending 2 ["Document_getDocumentData",[4]]

(3)(+0000040): ZoteroOpenOfficeIntegration: 408 bytes available

(3)(+0000000): ZoteroOpenOfficeIntegration: Read 2 "<data data-version=\"3\" zotero-version=\"4.0.17\"><session id=\"kmW3POdb\"/><style id=\"http://www.zotero.org/styles/apa\" hasBibliography=\"1\" bibliographyStyleHasBeenSet=\"0\"/><prefs><pref name=\"fieldType\" value=\"ReferenceMark\"/><pref name=\"storeReferences\" value=\"true\"/><pref name=\"automaticJournalAbbreviations\" value=\"true\"/><pref name=\"noteType\" value=\"0\"/></prefs></data>"

(3)(+0000037): Cached 12 styles in 35 ms

(3)(+0000002): CSL: Using collation sort: en-US

(3)(+0000011): CSL: Using collation sort: en-US

(3)(+0000010): CSL: Using collation sort: en-US

(3)(+0000032): ZoteroOpenOfficeIntegration: Sending 3 ["Document_setDocumentData",[4,"<data data-version=\"3\" zotero-version=\"4.0.17\"><session id=\"aZcs1dzF\"/><style id=\"http://www.zotero.org/styles/apa\" hasBibliography=\"1\" bibliographyStyleHasBeenSet=\"0\"/><prefs><pref name=\"fieldType\" value=\"ReferenceMark\"/><pref name=\"storeReferences\" value=\"true\"/><pref name=\"automaticJournalAbbreviations\" value=\"true\"/><pref name=\"noteType\" value=\"0\"/></prefs></data>"]]

(3)(+0000012): ZoteroOpenOfficeIntegration: 12 bytes available

(3)(+0000000): ZoteroOpenOfficeIntegration: Read 3 null

(3)(+0000001): ZoteroOpenOfficeIntegration: Sending 4 ["Document_canInsertField",[4,"ReferenceMark"]]

(3)(+0000002): ZoteroOpenOfficeIntegration: 12 bytes available

(3)(+0000000): ZoteroOpenOfficeIntegration: Read 4 true

(3)(+0000001): ZoteroOpenOfficeIntegration: Sending 5 ["Document_cursorInField",[4,"ReferenceMark"]]

(3)(+0000005): ZoteroOpenOfficeIntegration: 12 bytes available

(3)(+0000001): ZoteroOpenOfficeIntegration: Read 5 null

(3)(+0000000): ZoteroOpenOfficeIntegration: Sending 6 ["Document_insertField",[4,"ReferenceMark",0]]

(3)(+0000052): ZoteroOpenOfficeIntegration: 16 bytes available

(3)(+0000000): ZoteroOpenOfficeIntegration: Read 6 [0,"",0]

(3)(+0000001): ZoteroOpenOfficeIntegration: Sending 7 ["Field_setCode",[4,0,"TEMP"]]

(3)(+0000012): ZoteroOpenOfficeIntegration: 12 bytes available

(3)(+0000001): ZoteroOpenOfficeIntegration: Read 7 null

(3)(+0000001): ZoteroOpenOfficeIntegration: Sending 8 ["Document_getFields",[4,"ReferenceMark"]]

(3)(+0000031): Setting mode to integration

(3)(+0000002): ZoteroOpenOfficeIntegration: 919 bytes available

(3)(+0000000): ZoteroOpenOfficeIntegration: Read 8 ERR:An error occurred communicating with Zotero:
java.lang.NullPointerException
	at org.zotero.integration.ooo.comp.TextTableManager.<init>(TextTableManager.java:40)
	at org.zotero.integration.ooo.comp.ReferenceMark.getDocumentRange(ReferenceMark.java:316)
	at org.zotero.integration.ooo.comp.ReferenceMark.compareTo(ReferenceMark.java:325)
	at org.zotero.integration.ooo.comp.ReferenceMark.compareTo(ReferenceMark.java:1)
	at java.util.Arrays.mergeSort(Arrays.java:1157)
	at java.util.Arrays.sort(Arrays.java:1092)
	at java.util.Collections.sort(Collections.java:134)
	at org.zotero.integration.ooo.comp.Document.getFields(Document.java:351)
	at org.zotero.integration.ooo.comp.CommMessage.execute(CommMessage.java:90)
	at org.zotero.integration.ooo.comp.CommMessage.getBytes(CommMessage.java:40)
	at org.zotero.integration.ooo.comp.CommServer.run(CommServer.java:60)
	at java.lang.Thread.run(Thread.java:701)


(4)(+0000027): Registering observer for [collection,search,share,group,trash,bucket] in notifier with hash iN'

(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID IS NULL AND libraryID IS NULL

(5)(+0000001): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =7

(5)(+0000000): No child collections of collection 7

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =12

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =55

(5)(+0000000): No child collections of collection 55

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =20

(5)(+0000000): No child collections of collection 20

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =44

(5)(+0000000): No child collections of collection 44

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =41

(5)(+0000001): No child collections of collection 41

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =29

(5)(+0000000): No child collections of collection 29

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =30

(5)(+0000000): No child collections of collection 30

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =15

(5)(+0000000): No child collections of collection 15

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =45

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =47

(5)(+0000001): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =51

(5)(+0000000): No child collections of collection 51

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =52

(5)(+0000000): No child collections of collection 52

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =53

(5)(+0000000): No child collections of collection 53

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =54

(5)(+0000001): No child collections of collection 54

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =46

(5)(+0000000): No child collections of collection 46

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =9

(5)(+0000000): No child collections of collection 9

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =10

(5)(+0000001): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =11

(5)(+0000000): No child collections of collection 11

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =26

(5)(+0000000): No child collections of collection 26

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =16

(5)(+0000000): No child collections of collection 16

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =17

(5)(+0000000): No child collections of collection 17

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =6

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =8

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =21

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =36

(5)(+0000000): No child collections of collection 36

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =35

(5)(+0000000): No child collections of collection 35

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =13

(5)(+0000000): No child collections of collection 13

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =42

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =50

(5)(+0000000): No child collections of collection 50

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =49

(5)(+0000000): No child collections of collection 49

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =43

(5)(+0000000): No child collections of collection 43

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =23

(5)(+0000000): No child collections of collection 23

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =24

(5)(+0000000): No child collections of collection 24

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =38

(5)(+0000001): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =37

(5)(+0000000): No child collections of collection 37

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =48

(5)(+0000000): No child collections of collection 48

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =39

(5)(+0000000): No child collections of collection 39

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =40

(5)(+0000000): No child collections of collection 40

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =1

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =19

(5)(+0000000): No child collections of collection 19

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =5

(5)(+0000000): No child collections of collection 5

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =18

(5)(+0000000): No child collections of collection 18

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000001): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =22

(5)(+0000000): No child collections of collection 22

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =3

(5)(+0000000): No child collections of collection 3

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =4

(5)(+0000000): No child collections of collection 4

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =2

(5)(+0000000): No child collections of collection 2

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000000): SELECT collectionID AS id, collectionName AS name FROM collections C WHERE parentCollectionID =14

(5)(+0000000): No child collections of collection 14

(5)(+0000000): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches WHERE libraryID IS NULL ORDER BY name COLLATE NOCASE

(5)(+0000001): SELECT groupID FROM groups ORDER BY name COLLATE locale

(5)(+0000000): DROP TABLE tmpSearchResults_YojObZtw

(4)(+0000000): Registering observer for [item,collection-item,item-tag,share-items,bucket] in notifier with hash V4'

(3)(+0000001): Refreshing items list

(5)(+0000000): Beginning DB transaction

(3)(+0000000): Beginning Notifier event queue

(3)(+0000000): Caching fields [title,date,firstCreator]

(5)(+0000000): Transaction in progress -- increasing level to 1

(5)(+0000001): CREATE TEMPORARY TABLE tmpSearchResults_DwTwkGGH AS SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) ) AND (itemID NOT IN (SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL)) AND itemID IN (SELECT itemID FROM items WHERE (libraryID IS NULL))

(5)(+0000002): CREATE INDEX tmpSearchResults_DwTwkGGH_itemID ON tmpSearchResults_DwTwkGGH(itemID)

(5)(+0000001): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) )) AND (itemID IN (SELECT itemID FROM tmpSearchResults_DwTwkGGH) OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_DwTwkGGH)) OR itemID IN (SELECT itemID FROM itemNotes WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_DwTwkGGH)))

(5)(+0000002): DROP TABLE tmpSearchResults_DwTwkGGH

(5)(+0000000): Decreasing transaction level to 0

(5)(+0000002): Committing transaction

(3)(+0000000): Resetting Notifier event queue

(5)(+0000006): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 84

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 97

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 62

(3)(+0000001): Loading data for creator 2 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 2

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 173

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 292

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 504

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 321

(5)(+0000003): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 293

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 345

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 143

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 567

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 346

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 568

(5)(+0000000): SELECT creatorTypeID FROM itemTypeCreatorTypes WHERE itemTypeID=? AND primaryField=1

(5)(+0000001): Binding parameter 1 of type int: 33

(3)(+0000000): Loading data for creator 143 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 143

(3)(+0000000): Loading data for creator 567 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 567

(3)(+0000000): Loading data for creator 568 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 568

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000001): Binding parameter 1 of type int: 356

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 369

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 591

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 380

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 524

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 213

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 132

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 228

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 450

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 560

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 275

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 563

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 564

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 453

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 588

(3)(+0000000): Loading data for creator 560 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 560

(5)(+0000002): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 250

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 245

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 43

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 260

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 321

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 558

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 212

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 80

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 215

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 336

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 189

(3)(+0000000): Loading data for creator 80 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 80

(3)(+0000000): Loading data for creator 215 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 215

(3)(+0000000): Loading data for creator 189 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 189

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 104

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 124

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 165

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 545

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 211

(3)(+0000000): Loading data for creator 199 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 199

(3)(+0000001): Loading data for creator 332 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 332

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 295

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 8

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 268

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 475

(3)(+0000000): Loading data for creator 8 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 8

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 326

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 312

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 316

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 333

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 343

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 348

(3)(+0000000): Loading data for creator 312 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 312

(3)(+0000000): Loading data for creator 348 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 348

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 30

(3)(+0000001): Loading data for creator 287 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 287

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 207

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 427

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 286

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 34

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 168

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 174

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 181

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 217

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 359

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 337

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 119

(3)(+0000000): Loading data for creator 34 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 34

(3)(+0000000): Loading data for creator 168 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 168

(3)(+0000000): Loading data for creator 359 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 359

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 309

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 386

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 478

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 148

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 344

(3)(+0000000): Loading data for creator 386 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 386

(3)(+0000000): Loading data for creator 572 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 572

(3)(+0000000): Loading data for creator 591 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 591

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 28

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 414

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 62

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 47

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 322

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 259

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 411

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 99

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 351

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 506

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 370

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 531

(3)(+0000001): Loading data for creator 47 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 47

(3)(+0000000): Loading data for creator 322 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 322

(3)(+0000000): Loading data for creator 370 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 370

(5)(+0000002): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 211

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 546

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 245

(3)(+0000000): Loading data for creator 546 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 546

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 263

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 303

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 104

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 358

(3)(+0000000): Loading data for creator 104 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 104

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 8

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 515

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 536

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 102

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 96

(3)(+0000000): Loading data for creator 337 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 337

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 22

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 238

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 443

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 345

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 68

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 86

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 31

(3)(+0000000): Loading data for creator 238 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 238

(3)(+0000000): Loading data for creator 443 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 443

(3)(+0000000): Loading data for creator 86 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 86

(3)(+0000001): Loading data for creator 527 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 527

(3)(+0000000): Loading data for creator 97 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 97

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 79

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 138

(3)(+0000000): Loading data for creator 292 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 292

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 132

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 159

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 191

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 152

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 161

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 439

(3)(+0000000): Loading data for creator 159 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 159

(3)(+0000000): Loading data for creator 152 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 152

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 134

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000001): Binding parameter 1 of type int: 160

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 197

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 203

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 247

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 269

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 277

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 284

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 296

(3)(+0000000): Loading data for creator 269 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 269

(3)(+0000000): Loading data for creator 277 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 277

(3)(+0000001): Loading data for creator 296 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 296

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 373

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 593

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 375

(3)(+0000000): Loading data for creator 593 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 593

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 302

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 146

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 24

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 371

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 448

(3)(+0000000): Loading data for creator 146 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 146

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 365

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 605

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 353

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 419

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 390

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 406

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 407

(3)(+0000000): Loading data for creator 605 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 605

(3)(+0000000): Loading data for creator 353 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 353

(3)(+0000000): Loading data for creator 390 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 390

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 43

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 203

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 105

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 467

(5)(+0000000): SELECT creatorTypeID FROM itemTypeCreatorTypes WHERE itemTypeID=? AND primaryField=1

(5)(+0000000): Binding parameter 1 of type int: 7

(3)(+0000001): Loading data for creator 203 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 203

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 11

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 458

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 168

(3)(+0000000): Loading data for creator 458 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 458

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 4

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 153

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 157

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 35

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 78

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 235

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 489

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 205

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 162

(3)(+0000000): Loading data for creator 235 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 235

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 74

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 37

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 174

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 420

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 314

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 81

(3)(+0000000): Loading data for creator 205 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 205

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 18

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 513

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 502

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 120

(3)(+0000000): Loading data for creator 513 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 513

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 298

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 552

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 118

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 88

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 344

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 347

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 569

(3)(+0000000): Loading data for creator 552 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 552

(3)(+0000000): Loading data for creator 569 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 569

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 224

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 219

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 222

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 227

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 327

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 340

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 343

(3)(+0000000): Loading data for creator 219 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 219

(3)(+0000000): Loading data for creator 222 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 222

(3)(+0000000): Loading data for creator 340 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 340

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 289

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 287

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 240

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 230

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 383

(3)(+0000000): Loading data for creator 148 in Zotero.Creator.load()

(5)(+0000001): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 148

(3)(+0000000): Loading data for creator 478 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 478

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 271

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 163

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 224

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 388

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 606

(3)(+0000000): Loading data for creator 163 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 163

(3)(+0000000): Loading data for creator 606 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 606

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000001): Binding parameter 1 of type int: 234

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 306

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 523

(3)(+0000000): Loading data for creator 523 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 523

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 299

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 24

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 249

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 406

(3)(+0000000): Loading data for creator 249 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 249

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 184

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 305

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 108

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 89

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 122

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 158

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 227

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 481

(3)(+0000000): Loading data for creator 305 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 305

(3)(+0000000): Loading data for creator 108 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 108

(3)(+0000001): Loading data for creator 481 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 481

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 111

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 396

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 385

(3)(+0000000): Loading data for creator 396 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 396

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 273

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 7

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 225

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 423

(3)(+0000000): Loading data for creator 225 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 225

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000001): Binding parameter 1 of type int: 216

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 405

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 641

(3)(+0000000): Loading data for creator 641 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 641

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 142

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 479

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 516

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 171

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 304

(3)(+0000000): Loading data for creator 479 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 479

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 185

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 236

(3)(+0000001): Loading data for creator 317 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 317

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000001): Binding parameter 1 of type int: 140

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 342

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 134

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 473

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 94

(3)(+0000000): Loading data for creator 342 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 342

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 73

(5)(+0000001): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 176

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 234

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 355

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 583

(3)(+0000000): Loading data for creator 132 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 132

(3)(+0000000): Loading data for creator 583 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 583

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 38

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 400

(3)(+0000000): Loading data for creator 240 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 240

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 186

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 391

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 520

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000001): Binding parameter 1 of type int: 244

(3)(+0000000): Loading data for creator 391 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 391

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 112

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 530

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 70

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 212

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 197

(3)(+0000000): Loading data for creator 530 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 530

(3)(+0000000): Loading data for creator 197 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 197

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 188

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 302

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 297

(3)(+0000000): Loading data for creator 302 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000001): Binding parameter 1 of type int: 302

(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 85

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 101

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 107

(3)(+0000000): Loading data for creator 101 in Zotero.Creator.load()

(5)(+0000000): SELECT C.*, CD.* FROM creators C NATURAL JOIN creatorData CD WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 101

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 82

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 525

(5)(+0000001): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex

(5)(+0000000): Binding parameter 1 of type int: 460

(5)(+0000000): SELECT COUNT(*) FROM creators WHERE creatorID=?

(5)(+0000000): Binding parameter 1 of type int: 651

(3)(+0000001): Set tree in 94 ms

(3)(+0000012): Moving window to 1440, 200

(3)(+0000004): Integration: Activated successfully

(5)(+0000017): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 243

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 262

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 270

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 393

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 361

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 148

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 122

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 89

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 109

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 144

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000001): Binding parameter 1 of type int: 60

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 291

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 82

(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 358

(5)(+0000002): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 299

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 303

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 192

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 234

(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000001): Binding parameter 1 of type int: 306

(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 107

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 143

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 104

(3)(+0001682): Refreshing items list

(5)(+0000003): Beginning DB transaction

(3)(+0000000): Beginning Notifier event queue

(3)(+0000000): Caching fields [title,date,firstCreator]

(5)(+0000002): Transaction in progress -- increasing level to 1

(5)(+0000001): CREATE TEMPORARY TABLE tmpSearchResults_DHKLdbBH AS SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) ) AND (itemID NOT IN (SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL)) AND itemID IN (SELECT itemID FROM items WHERE (libraryID IS NULL))

(5)(+0000004): CREATE INDEX tmpSearchResults_DHKLdbBH_itemID ON tmpSearchResults_DHKLdbBH(itemID)

(5)(+0000001): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) )) AND ((itemID IN (SELECT itemID FROM itemData WHERE (valueID IN (SELECT valueID FROM itemDataValues WHERE value LIKE ?))) OR itemID IN (SELECT itemID FROM itemTags WHERE (tagID IN (SELECT tagID FROM tags WHERE name LIKE ?))) OR itemID IN (SELECT itemID FROM itemNotes WHERE (note LIKE ?)) OR itemID IN (SELECT itemID FROM itemCreators WHERE (creatorID IN (SELECT creatorID FROM creators NATURAL JOIN creatorData WHERE TRIM(firstName || ' ' || lastName) LIKE ?))) OR itemID IN (SELECT itemID FROM annotations WHERE (text LIKE ?)) OR itemID IN (SELECT itemID FROM fulltextItemWords WHERE (wordID IN (SELECT wordID FROM fulltextWords WHERE word LIKE ?)))))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_DHKLdbBH) OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_DHKLdbBH)) OR itemID IN (SELECT itemID FROM itemNotes WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_DHKLdbBH)))

(5)(+0000001): Binding parameter 1 of type string: "%d%"

(5)(+0000000): Binding parameter 2 of type string: "%d%"

(5)(+0000000): Binding parameter 3 of type string: "%d%"

(5)(+0000000): Binding parameter 4 of type string: "%d%"

(5)(+0000000): Binding parameter 5 of type string: "%d%"

(5)(+0000000): Binding parameter 6 of type string: "d%"

(5)(+0000128): DROP TABLE tmpSearchResults_DHKLdbBH

(5)(+0000000): Decreasing transaction level to 0

(5)(+0000004): Committing transaction

(3)(+0000000): Resetting Notifier event queue

(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 6

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 6

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 8

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 8

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 24

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 24

(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 31

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 31

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 44

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 44

(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 59

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 59

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 85

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 85

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 88

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 88

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 94

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 94

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 96

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 96

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 144

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 144

(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 158

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 158

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 172

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 172

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 173

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 173

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 174

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 174

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 185

(5)(+0000001): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 185

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 192

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 192

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 198

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 198

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 208

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 208

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 217

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 217

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 224

(5)(+0000001): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 224

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 231

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 231

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 247

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 247

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 249

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 249

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 256

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 256

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 284

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 284

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 289

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 289

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 305

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 305

(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 308

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 308

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 310

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 310

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 326

(5)(+0000001): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 326

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 327

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 327

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 343

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 343

(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 345

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 345

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 346

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 346

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 355

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 355

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 361

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 361

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 362

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 362

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 364

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 364

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 365

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 365

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 371

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 371

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 373

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 373

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 385

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 385

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 387

(5)(+0000001): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 387

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 390

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 390

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 407

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 407

(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 409

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 409

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 412

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 412

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000001): Binding parameter 1 of type int: 419

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 419

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 422

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 422

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 423

(5)(+0000001): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 423

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 424

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 424

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 427

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 427

(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 430

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 430

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 440

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 440

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 442

(5)(+0000001): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 442

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 444

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 444

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 450

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 450

(5)(+0000001): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 452

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 452

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 453

(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 453

(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 460

(5)(+0000001): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)

(5)(+0000000): Binding parameter 1 of type int: 460

(5)(+0000045): SELECT linkMode FROM itemAttachments WHERE itemID=?

(5)(+0000001): Binding parameter 1 of type int: 201

(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 201

(5)(+0000004): SELECT linkMode FROM itemAttachments WHERE itemID=?

(5)(+0000000): Binding parameter 1 of type int: 434

(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 434

(5)(+0000004): SELECT linkMode FROM itemAttachments WHERE itemID=?

(5)(+0000000): Binding parameter 1 of type int: 446

(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 446

(3)(+0001114): Refreshing items list

(5)(+0000002): Beginning DB transaction

(3)(+0000000): Beginning Notifier event queue

(3)(+0000001): Caching fields [title,date,firstCreator]

(5)(+0000001): Transaction in progress -- increasing level to 1

(5)(+0000000): CREATE TEMPORARY TABLE tmpSearchResults_oWgwoZYp AS SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) ) AND (itemID NOT IN (SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL)) AND itemID IN (SELECT itemID FROM items WHERE (libraryID IS NULL))

(5)(+0000003): CREATE INDEX tmpSearchResults_oWgwoZYp_itemID ON tmpSearchResults_oWgwoZYp(itemID)

(5)(+0000000): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) )) AND ((itemID IN (SELECT itemID FROM itemData WHERE (valueID IN (SELECT valueID FROM itemDataValues WHERE value LIKE ?))) OR itemID IN (SELECT itemID FROM itemTags WHERE (tagID IN (SELECT tagID FROM tags WHERE name LIKE ?))) OR itemID IN (SELECT itemID FROM itemNotes WHERE (note LIKE ?)) OR itemID IN (SELECT itemID FROM itemCreators WHERE (creatorID IN (SELECT creatorID FROM creators NATURAL JOIN creatorData WHERE TRIM(firstName || ' ' || lastName) LIKE ?))) OR itemID IN (SELECT itemID FROM annotations WHERE (text LIKE ?)) OR itemID IN (SELECT itemID FROM fulltextItemWords WHERE (wordID IN (SELECT wordID FROM fulltextWords WHERE word LIKE ?)))))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_oWgwoZYp) OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_oWgwoZYp)) OR itemID IN (SELECT itemID FROM itemNotes WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_oWgwoZYp)))

(5)(+0000001): Binding parameter 1 of type string: "%schuler%"

(5)(+0000000): Binding parameter 2 of type string: "%schuler%"

(5)(+0000000): Binding parameter 3 of type string: "%schuler%"

(5)(+0000000): Binding parameter 4 of type string: "%schuler%"

(5)(+0000000): Binding parameter 5 of type string: "%schuler%"

(5)(+0000000): Binding parameter 6 of type string: "schuler%"

(5)(+0000020): DROP TABLE tmpSearchResults_oWgwoZYp

(5)(+0000000): Decreasing transaction level to 0

(5)(+0000000): Committing transaction

(3)(+0000000): Resetting Notifier event queue

(5)(+0000004): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 452

(5)(+0000007): SELECT linkMode FROM itemAttachments WHERE itemID=?

(5)(+0000000): Binding parameter 1 of type int: 456

(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 456

(5)(+0000001): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)

(5)(+0000000): Binding parameter 1 of type int: 384

(4)(+0002420): Unregistering observer in notifier with hash 'iN'

(4)(+0000000): Unregistering observer in notifier with hash 'V4'