zotero(3)(+0000000): Using data directory C:\Users\xxxx\Zotero zotero(3)(+0000011): Asynchronously opening database 'zotero' zotero(3)(+0000000): C:\Users\xxxx\Zotero\zotero.sqlite zotero(4)(+0000008): PRAGMA main.locking_mode=EXCLUSIVE zotero(4)(+0000021): PRAGMA page_size zotero(4)(+0000003): PRAGMA cache_size=2000 zotero(4)(+0000001): PRAGMA foreign_keys=true zotero(4)(+0000016): SELECT version FROM version WHERE schema='system' zotero(3)(+0000002): Proxy not required for https://zoteroproxycheck.s3.amazonaws.com/test zotero(4)(+0000002): SELECT version FROM version WHERE schema='userdata' zotero(4)(+0000009): SELECT version FROM version WHERE schema='compatibility' zotero(4)(+0000003): SELECT value FROM settings WHERE setting='db' AND key='integrityCheck' zotero(3)(+0000001): HTTP GET resource://zotero/schema/global/schema.json zotero(3)(+0000003): HTTP GET resource://zotero/schema/global/schema.json succeeded with 200 zotero(4)(+0000003): SELECT version FROM version WHERE schema='globalSchema' zotero(3)(+0000001): Database is up to date with global schema version 15 -- skipping update zotero(3)(+0000000): HTTP GET resource://zotero/schema/userdata.sql zotero(3)(+0000002): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200 zotero(4)(+0000000): PRAGMA foreign_keys = false zotero(4)(+0000001): Beginning DB transaction Qz0Biz7q zotero(3)(+0000002): HTTP GET resource://zotero/schema/system.sql zotero(3)(+0000002): HTTP GET resource://zotero/schema/system.sql succeeded with 200 zotero(3)(+0000001): Updating custom tables zotero(4)(+0000000): PRAGMA foreign_keys zotero(4)(+0000001): SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND tbl_name=? ['customItemTypes'] zotero(4)(+0000001): DELETE FROM itemTypesCombined zotero(4)(+0000001): DELETE FROM fieldsCombined zotero(4)(+0000001): DELETE FROM itemTypeFieldsCombined zotero(4)(+0000000): DELETE FROM baseFieldMappingsCombined zotero(4)(+0000001): INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypes zotero(4)(+0000000): INSERT INTO fieldsCombined SELECT fieldID, fieldName, NULL AS label, fieldFormatID, 0 AS custom FROM fields UNION SELECT customFieldID + 10000 AS fieldID, fieldName, label, NULL, 1 AS custom FROM customFields zotero(4)(+0000000): INSERT INTO itemTypeFieldsCombined SELECT itemTypeID, fieldID, hide, orderIndex FROM itemTypeFields UNION SELECT customItemTypeID + 10000 AS itemTypeID, COALESCE(fieldID, customFieldID + 10000) AS fieldID, hide, orderIndex FROM customItemTypeFields zotero(4)(+0000002): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings zotero(3)(+0000000): HTTP GET resource://zotero/schema/userdata.sql zotero(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200 zotero(4)(+0000000): SELECT 1 FROM itemDataValues WHERE value=0 LIMIT 1 zotero(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql zotero(3)(+0000001): HTTP GET resource://zotero/schema/userdata.sql succeeded with 200 zotero(4)(+0000000): SELECT version FROM version WHERE schema='triggers' zotero(3)(+0000001): HTTP GET resource://zotero/schema/triggers.sql zotero(3)(+0000001): HTTP GET resource://zotero/schema/triggers.sql succeeded with 200 zotero(3)(+0000000): Updating custom tables zotero(4)(+0000000): PRAGMA foreign_keys zotero(4)(+0000001): DELETE FROM itemTypesCombined zotero(4)(+0000000): DELETE FROM fieldsCombined zotero(4)(+0000000): DELETE FROM itemTypeFieldsCombined zotero(4)(+0000000): DELETE FROM baseFieldMappingsCombined zotero(4)(+0000001): INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypesli zotero(4)(+0000000): INSERT INTO fieldsCombined SELECT fieldID, fieldName, NULL AS label, fieldFormatID, 0 AS custom FROM fields UNION SELECT customFieldID + 10000 AS fieldID, fieldName, label, NULL, 1 AS custom FROM customFields zotero(4)(+0000000): INSERT INTO itemTypeFieldsCombined SELECT itemTypeID, fieldID, hide, orderIndex FROM itemTypeFields UNION SELECT customItemTypeID + 10000 AS itemTypeID, COALESCE(fieldID, customFieldID + 10000) AS fieldID, hide, orderIndex FROM customItemTypeFields zotero(4)(+0000002): INSERT INTO baseFieldMappingsCombined SELECT itemTypeID, baseFieldID, fieldID FROM baseFieldMappings UNION SELECT customItemTypeID + 10000 AS itemTypeID, baseFieldID, customFieldID + 10000 AS fieldID FROM customBaseFieldMappings zotero(4)(+0000011): Committed DB transaction Qz0Biz7q zotero(4)(+0000007): PRAGMA foreign_keys = true zotero(4)(+0000001): Beginning DB transaction XGWQ7NMT zotero(4)(+0000001): SELECT value FROM settings WHERE setting='client' AND key='lastVersion' zotero(4)(+0000000): Committed DB transaction XGWQ7NMT zotero(4)(+0000001): SELECT key, value FROM settings WHERE setting='account' zotero(4)(+0000000): SELECT userID, name FROM users zotero(4)(+0000001): SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches FROM libraries L WHERE type NOT IN (?,?) ['feed', 'group'] zotero(4)(+0000002): SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches, F.name AS _feedName, F.url AS _feedUrl, F.lastUpdate AS _feedLastUpdate, F.lastCheck AS _feedLastCheck, F.lastCheckError AS _feedLastCheckError, F.cleanupUnreadAfter AS _feedCleanupUnreadAfter, F.cleanupReadAfter AS _feedCleanupReadAfter, F.refreshInterval AS _feedRefreshInterval, (SELECT COUNT(*) FROM items I JOIN feedItems FI USING (itemID) WHERE I.libraryID=F.libraryID AND FI.readTime IS NULL) AS _feedUnreadCount FROM feeds F JOIN libraries L USING (libraryID) zotero(4)(+0000000): SELECT L.libraryID, L.type AS _libraryType, L.editable AS _libraryEditable, L.filesEditable AS _libraryFilesEditable, L.version AS _libraryVersion, L.storageVersion AS _libraryStorageVersion, L.lastSync AS _libraryLastSync, L.archived AS _libraryArchived, (SELECT COUNT(*)>0 FROM collections C WHERE C.libraryID=L.libraryID) AS hasCollections, (SELECT COUNT(*)>0 FROM savedSearches S WHERE S.libraryID=L.libraryID) AS hasSearches, G.groupID, G.name AS _groupName, G.description AS _groupDescription, G.version AS _groupVersion FROM groups G JOIN libraries L USING (libraryID) zotero(4)(+0000002): SELECT COALESCE(MAX(collectionID) + 1, 1) FROM collections zotero(4)(+0000000): SELECT COALESCE(MAX(creatorID) + 1, 1) FROM creators zotero(4)(+0000000): SELECT COALESCE(MAX(creatorTypeID) + 1, 1) FROM creatorTypes zotero(4)(+0000001): SELECT COALESCE(MAX(customFieldID) + 1, 1) FROM customFields zotero(4)(+0000000): SELECT COALESCE(MAX(customItemTypeID) + 1, 1) FROM customItemTypes zotero(4)(+0000000): SELECT COALESCE(MAX(fieldID) + 1, 1) FROM fields zotero(4)(+0000001): SELECT COALESCE(MAX(valueID) + 1, 1) FROM itemDataValues zotero(4)(+0000000): SELECT COALESCE(MAX(itemTypeID) + 1, 1) FROM itemTypes zotero(4)(+0000000): SELECT COALESCE(MAX(itemID) + 1, 1) FROM items zotero(4)(+0000001): SELECT COALESCE(MAX(libraryID) + 1, 1) FROM libraries zotero(4)(+0000001): SELECT COALESCE(MAX(proxyID) + 1, 1) FROM proxies zotero(4)(+0000000): SELECT COALESCE(MAX(savedSearchID) + 1, 1) FROM savedSearches zotero(4)(+0000000): SELECT COALESCE(MAX(tagID) + 1, 1) FROM tags zotero(4)(+0000001): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined zotero(4)(+0000002): SELECT itemTypeID AS id, typeName AS name, custom FROM itemTypesCombined WHERE typeName IN ('webpage', 'attachment', 'note', 'annotation') zotero(4)(+0000001): SELECT customItemTypeID AS id, label, icon FROM customItemTypes zotero(4)(+0000000): SELECT * FROM fieldFormats zotero(4)(+0000001): SELECT * FROM fieldsCombined zotero(4)(+0000001): SELECT fieldID, itemTypeID FROM itemTypeFieldsCombined zotero(4)(+0000008): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined zotero(4)(+0000005): SELECT IT.itemTypeID, F.fieldID AS baseFieldID, BFM.fieldID FROM itemTypesCombined IT LEFT JOIN fieldsCombined F LEFT JOIN baseFieldMappingsCombined BFM ON (IT.itemTypeID=BFM.itemTypeID AND F.fieldID=BFM.baseFieldID) zotero(4)(+0000018): SELECT DISTINCT baseFieldID FROM baseFieldMappingsCombined zotero(4)(+0000047): SELECT itemTypeID, baseFieldID, fieldID, fieldName FROM baseFieldMappingsCombined JOIN fieldsCombined USING (fieldID) zotero(4)(+0000002): SELECT DISTINCT fieldID FROM baseFieldMappingsCombined zotero(4)(+0000001): SELECT itemTypeID, fieldID FROM itemTypeFieldsCombined ORDER BY orderIndex zotero(4)(+0000007): SELECT creatorTypeID AS id, creatorType AS name FROM creatorTypes zotero(4)(+0000001): SELECT itemTypeID, creatorTypeID AS id, creatorType AS name, primaryField FROM itemTypeCreatorTypes NATURAL JOIN creatorTypes zotero(4)(+0000012): SELECT itemTypeID, creatorTypeID FROM itemTypeCreatorTypes WHERE primaryField=1 zotero(4)(+0000001): SELECT fileTypeID AS id, fileType AS name FROM fileTypes zotero(4)(+0000002): SELECT charsetID AS id, charset AS name FROM charsets zotero(4)(+0000001): SELECT predicateID AS id, predicate AS name FROM relationPredicates zotero(3)(+0000001): Getting contents of C:\Users\xxxx\AppData\Roaming\Zotero\Zotero\Profiles\2smtafvd.default\session.json zotero(3)(+0000001): Running unlock callbacks zotero(3)(+0000001): HTTP server listening on 127.0.0.1:23119 zotero(4)(+0000000): ATTACH ':memory:' AS 'indexing' zotero(4)(+0000001): CREATE TABLE indexing.fulltextWords (word NOT NULL) zotero(4)(+0000001): SELECT version FROM version WHERE schema='lastsync' zotero(4)(+0000001): SELECT name, syncObjectTypeID AS id FROM syncObjectTypes zotero(3)(+0000002): Registering auto-sync idle observer zotero(3)(+0000001): Registering URIContentListener zotero(4)(+0000000): SELECT * FROM proxies zotero(4)(+0000003): SELECT ROWID AS id, libraryID, key FROM collections zotero(4)(+0000001): SELECT ROWID AS id, libraryID, key FROM items zotero(3)(+0000001): Getting contents of C:\Users\xxxx\Zotero\locate\engines.json zotero(4)(+0000020): SELECT ROWID AS id, libraryID, key FROM savedSearches zotero(4)(+0000001): SELECT fieldName FROM fieldsCombined WHERE fieldName NOT IN ('accessDate', 'date', 'pages', 'section','seriesNumber','issue') zotero(1)(+0000002): Unknown item type 'nsfReviewer' zotero(1)(+0000000): Unknown item type 'nsfReviewer' zotero(1)(+0000001): Localized string not available for searchConditions.dateAdded zotero(1)(+0000000): Localized string not available for searchConditions.title zotero(1)(+0000001): Localized string not available for searchConditions.abstractNote zotero(1)(+0000000): Localized string not available for searchConditions.artworkSize zotero(1)(+0000000): Localized string not available for searchConditions.language zotero(1)(+0000000): Localized string not available for searchConditions.shortTitle zotero(1)(+0000000): Localized string not available for searchConditions.archive zotero(1)(+0000000): Localized string not available for searchConditions.archiveLocation zotero(1)(+0000000): Localized string not available for searchConditions.libraryCatalog zotero(1)(+0000000): Localized string not available for searchConditions.callNumber zotero(1)(+0000000): Localized string not available for searchConditions.url zotero(1)(+0000000): Localized string not available for searchConditions.rights zotero(1)(+0000000): Localized string not available for searchConditions.extra zotero(1)(+0000000): Localized string not available for searchConditions.seriesTitle zotero(1)(+0000001): Localized string not available for searchConditions.volume zotero(1)(+0000000): Localized string not available for searchConditions.numberOfVolumes zotero(1)(+0000000): Localized string not available for searchConditions.place zotero(1)(+0000000): Localized string not available for searchConditions.publisher zotero(1)(+0000000): Localized string not available for searchConditions.runningTime zotero(1)(+0000000): Localized string not available for searchConditions.ISBN zotero(1)(+0000000): Localized string not available for searchConditions.number zotero(1)(+0000000): Localized string not available for searchConditions.code zotero(1)(+0000000): Localized string not available for searchConditions.legislativeBody zotero(1)(+0000000): Localized string not available for searchConditions.session zotero(1)(+0000000): Localized string not available for searchConditions.history zotero(1)(+0000000): Localized string not available for searchConditions.publicationTitle zotero(1)(+0000000): Localized string not available for searchConditions.series zotero(1)(+0000000): Localized string not available for searchConditions.edition zotero(1)(+0000000): Localized string not available for searchConditions.numPages zotero(1)(+0000000): Localized string not available for searchConditions.court zotero(1)(+0000001): Localized string not available for searchConditions.reporter zotero(1)(+0000000): Localized string not available for searchConditions.versionNumber zotero(1)(+0000000): Localized string not available for searchConditions.system zotero(1)(+0000000): Localized string not available for searchConditions.conferenceName zotero(1)(+0000000): Localized string not available for searchConditions.DOI zotero(1)(+0000000): Localized string not available for searchConditions.committee zotero(1)(+0000000): Localized string not available for searchConditions.seriesText zotero(1)(+0000000): Localized string not available for searchConditions.journalAbbreviation zotero(1)(+0000000): Localized string not available for searchConditions.ISSN zotero(1)(+0000000): Localized string not available for searchConditions.scale zotero(1)(+0000000): Localized string not available for searchConditions.country zotero(1)(+0000000): Localized string not available for searchConditions.assignee zotero(1)(+0000000): Localized string not available for searchConditions.issuingAuthority zotero(1)(+0000000): Localized string not available for searchConditions.filingDate zotero(1)(+0000000): Localized string not available for searchConditions.applicationNumber zotero(1)(+0000000): Localized string not available for searchConditions.priorityNumbers zotero(1)(+0000000): Localized string not available for searchConditions.references zotero(1)(+0000000): Localized string not available for searchConditions.legalStatus zotero(1)(+0000000): Localized string not available for searchConditions.meetingName zotero(1)(+0000001): Localized string not available for searchConditions.codeNumber zotero(1)(+0000000): Localized string not available for searchConditions.archiveID zotero(1)(+0000000): Localized string not available for searchConditions.citationKey zotero(1)(+0000000): Localized string not available for searchConditions.accessDate zotero(1)(+0000000): Localized string not available for searchConditions.date zotero(1)(+0000000): Localized string not available for searchConditions.pages zotero(1)(+0000000): Localized string not available for searchConditions.section zotero(1)(+0000000): Localized string not available for searchConditions.seriesNumber zotero(1)(+0000000): Localized string not available for searchConditions.issue zotero(4)(+0000002): SELECT tagID, name FROM tags zotero(4)(+0000004): SELECT * FROM creators zotero(3)(+0000010): Loading collection relations zotero(4)(+0000000): SELECT * FROM collectionRelations JOIN relationPredicates USING (predicateID) zotero(3)(+0000001): Loaded collection relations in 1 ms zotero(3)(+0000000): Loading item relations zotero(4)(+0000000): SELECT * FROM itemRelations JOIN relationPredicates USING (predicateID) zotero(3)(+0000000): Loaded item relations in 0 ms zotero(4)(+0000001): SELECT itemID AS id, fieldID, value FROM itemData JOIN itemDataValues USING (valueID) WHERE fieldID IN (?, ?) [58, 16] zotero(3)(+0000020): Getting contents of C:\Users\xxxx\AppData\Roaming\Zotero\Zotero\Profiles\2smtafvd.default\retractions.json zotero(4)(+0000057): SELECT libraryID, itemID, DI.itemID IS NOT NULL AS deleted, RI.flag FROM items JOIN retractedItems RI USING (itemID) LEFT JOIN deletedItems DI USING (itemID) zotero(4)(+0000002): SELECT COUNT(*) FROM settings WHERE setting='globalSchema' AND key='migrateExtra' zotero(3)(+0000002): Loading synced settings for library 1 zotero(4)(+0000000): SELECT setting, value, synced, version FROM syncedSettings WHERE libraryID=? [1] zotero(3)(+0000003): Loading all collections in Meine Bibliothek zotero(3)(+0000000): Loading primaryData for collections in Meine Bibliothek zotero(4)(+0000001): SELECT O.collectionID, O.collectionName AS name, O.libraryID, O.key, O.version, O.synced, DC.collectionID IS NOT NULL AS deleted, O.parentCollectionID AS parentID, CP.key AS parentKey, (SELECT COUNT(*) FROM collections WHERE parentCollectionID=O.collectionID) != 0 AS hasChildCollections, (SELECT COUNT(*) FROM collectionItems WHERE collectionID=O.collectionID) != 0 AS hasChildItems FROM collections O LEFT JOIN deletedCollections DC ON (O.collectionID=DC.collectionID)LEFT JOIN collections CP ON (O.parentCollectionID=CP.collectionID) WHERE 1 AND O.libraryID=? [1] zotero(3)(+0000002): Loaded primaryData in Meine Bibliothek in 3 ms zotero(3)(+0000000): Loading childCollections for collections in Meine Bibliothek zotero(4)(+0000001): SELECT C1.collectionID, C2.collectionID AS childCollectionID FROM collections C1 LEFT JOIN collections C2 ON (C1.collectionID=C2.parentCollectionID) WHERE C1.libraryID=? [1] zotero(3)(+0000000): Loaded childCollections in Meine Bibliothek in 1 ms zotero(3)(+0000001): Loading childItems for collections in Meine Bibliothek zotero(4)(+0000000): SELECT collectionID, itemID FROM collections LEFT JOIN collectionItems USING (collectionID) WHERE libraryID=? [1] zotero(3)(+0000003): Loaded childItems in Meine Bibliothek in 3 ms zotero(3)(+0000000): Loading relations for collections in Meine Bibliothek zotero(4)(+0000001): SELECT collectionID, predicate, object FROM collections LEFT JOIN collectionRelations USING (collectionID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [1] zotero(3)(+0000000): Loaded relations in Meine Bibliothek in 1 ms zotero(3)(+0000001): Loaded collections in Meine Bibliothek in 10 ms zotero(3)(+0000000): Loading all searches in Meine Bibliothek zotero(3)(+0000000): Loading primaryData for searches in Meine Bibliothek zotero(4)(+0000001): SELECT O.savedSearchID, O.savedSearchName AS name, O.libraryID, O.key, O.version, O.synced, DS.savedSearchID IS NOT NULL AS deleted FROM savedSearches O LEFT JOIN deletedSearches DS ON (O.savedSearchID=DS.savedSearchID) WHERE 1 AND O.libraryID=? [1] zotero(3)(+0000001): Loaded primaryData in Meine Bibliothek in 2 ms zotero(3)(+0000000): Loading conditions for searches in Meine Bibliothek zotero(4)(+0000001): SELECT savedSearchID, searchConditionID, condition, operator, value, required FROM savedSearches LEFT JOIN savedSearchConditions USING (savedSearchID) WHERE libraryID=?ORDER BY savedSearchID, searchConditionID [1] zotero(3)(+0000000): Loaded conditions in Meine Bibliothek in 1 ms zotero(3)(+0000001): Loaded searches in Meine Bibliothek in 4 ms zotero(3)(+0000001): Initializing Quick Copy zotero(3)(+0000001): Running initialization callbacks zotero(3)(+0000000): Triggering "zotero-loaded" event zotero(3)(+0000277): monkey-patch: 6.0.6: BBT enabled zotero(3)(+0000162): {better-bibtex} +null on-idle: queue.pause: startup zotero(3)(+0000000): {better-bibtex} +1 scheduler: pausing zotero(3)(+0001432): {better-bibtex} +1432 monkey-patching parseLibraryKeyHash zotero(3)(+0000001): {better-bibtex} +1 monkey-patching parseLibraryKey zotero(3)(+0000644): Initializing Zotero pane zotero(3)(+0000063): Initializing React CollectionTree zotero(3)(+0000015): Refreshing collections pane zotero(4)(+0000001): SELECT savedSearchID FROM savedSearches WHERE libraryID=? [1] zotero(3)(+0000013): Rendering tag selector zotero(3)(+0000003): Rendering tag list zotero(3)(+0000014): React CollectionTree initialized zotero(3)(+0000000): Initializing React ItemTree main zotero(3)(+0000007): itemTree.render(). Displaying Item Pane Message zotero(3)(+0000001): React ItemTree main initialized zotero(3)(+0000001): User interface ready in 4275 ms zotero(3)(+0000018): Connecting to streaming server at wss://stream.zotero.org/ zotero(3)(+0000003): itemTree.render(). Displaying Item Pane Message zotero(3)(+0000015): LibreOfficePlugin: Communication server listening on 127.0.0.1:23116 zotero(3)(+0000001): LibreOfficePlugin: Registering shutdown listener zotero(3)(+0000003): PluginInstaller: fetching addon info zotero(3)(+0000002): PluginInstaller: addon info fetched zotero(3)(+0000000): BBT startup 1 zotero(3)(+0000000): {better-bibtex} +804 Loading Better BibTeX: starting... zotero(3)(+0000000): {better-bibtex} +0 Loading Better BibTeX: start progress meter zotero(3)(+0000001): {better-bibtex} +1 Startup progress: waiting for Zotero locks... zotero(3)(+0000000): {better-bibtex} +0 Startup progress: Warten auf Zotero-Datenbank... zotero(3)(+0000007): BBT: loading ItemPane zotero(3)(+0000000): {better-bibtex} +7 ItemPane load, waiting for BBT... zotero(4)(+0000093): SELECT itemID FROM items JOIN deletedItems USING (itemID) WHERE libraryID=? [1] zotero(4)(+0000011): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, createdByUserID, lastModifiedByUserID, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 2 THEN IAP.itemID WHEN 26 THEN INoP.itemID WHEN 37 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key WHEN 37 THEN IAnP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID)LEFT JOIN groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.itemID IN (935,879,461,725,713,885,485,929,887,919,465,754) zotero(3)(+0000008): Loaded items in 8ms zotero(3)(+0000031): CollectionTree.selectWait(): selectEventsSuppressed. Not waiting to select row 0 zotero(3)(+0000010): Waiting for items to load for library 1 zotero(3)(+0000001): Loading all items in Meine Bibliothek zotero(3)(+0000001): Loading primaryData for items in Meine Bibliothek zotero(4)(+0000000): SELECT O.itemID, O.itemTypeID, O.dateAdded, O.dateModified, O.libraryID, O.key, O.version, O.synced, createdByUserID, lastModifiedByUserID, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' und ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS firstCreator, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators IC NATURAL JOIN creators LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=O.itemTypeID) WHERE itemID=O.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=10 ORDER BY orderIndex LIMIT 2,1)) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2) WHEN 2 THEN (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 1,1) || ' ' || (SELECT lastName || ' ' || firstName FROM itemCreators NATURAL JOIN creators WHERE itemID=O.itemID AND creatorTypeID=2 ORDER BY orderIndex LIMIT 2,1)) END) AS sortCreator, DI.itemID IS NOT NULL AS deleted, PI.itemID IS NOT NULL AS inPublications, (CASE O.itemTypeID WHEN 2 THEN IAP.itemID WHEN 26 THEN INoP.itemID WHEN 37 THEN IAnP.itemID END) AS parentID, (CASE O.itemTypeID WHEN 2 THEN IAP.key WHEN 26 THEN INoP.key WHEN 37 THEN IAnP.key END) AS parentKey, CS.charset AS attachmentCharset, IA.linkMode AS attachmentLinkMode, IA.contentType AS attachmentContentType, IA.path AS attachmentPath, IA.syncState AS attachmentSyncState, IA.storageModTime AS attachmentSyncedModificationTime, IA.storageHash AS attachmentSyncedHash, IA.lastProcessedModificationTime AS attachmentLastProcessedModificationTime, FI.guid AS feedItemGUID, FI.readTime AS feedItemReadTime, FI.translatedTime AS feedItemTranslatedTime FROM items O LEFT JOIN itemAttachments IA USING (itemID) LEFT JOIN items IAP ON (IA.parentItemID=IAP.itemID) LEFT JOIN itemNotes INo ON (O.itemID=INo.itemID) LEFT JOIN items INoP ON (INo.parentItemID=INoP.itemID) LEFT JOIN itemAnnotations IAn ON (O.itemID=IAn.itemID) LEFT JOIN items IAnP ON (IAn.parentItemID=IAnP.itemID) LEFT JOIN deletedItems DI ON (O.itemID=DI.itemID) LEFT JOIN publicationsItems PI ON (O.itemID=PI.itemID) LEFT JOIN charsets CS ON (IA.charsetID=CS.charsetID)LEFT JOIN groupItems GI ON (O.itemID=GI.itemID) LEFT JOIN feedItems FI ON (FI.itemID=O.itemID) WHERE 1 AND O.libraryID=? [1] zotero(3)(+0000178): Loaded primaryData in Meine Bibliothek in 178 ms zotero(3)(+0000001): Loading creators for items in Meine Bibliothek zotero(4)(+0000000): SELECT itemID, creatorID, creatorTypeID, orderIndex FROM items LEFT JOIN itemCreators USING (itemID) WHERE libraryID=? ORDER BY itemID, orderIndex [1] zotero(3)(+0000003): Rendering tag selector zotero(3)(+0000002): Rendering tag list zotero(3)(+0000004): Tag selector updated zotero(3)(+0000003): itemTree.render(). Displaying Item Pane Message zotero(3)(+0000040): Loaded creators in Meine Bibliothek in 53 ms zotero(3)(+0000001): Loading itemData for items in Meine Bibliothek zotero(4)(+0000000): SELECT itemID, fieldID, value FROM items JOIN itemData USING (itemID) JOIN itemDataValues USING (valueID) WHERE libraryID=? AND itemTypeID!=? [1, 26] zotero(4)(+0000129): SELECT itemID FROM items WHERE libraryID=? [1] zotero(4)(+0000091): SELECT itemID, title FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? AND itemID NOT IN (SELECT itemID FROM itemAttachments) [1] zotero(3)(+0000036): Loaded itemData in Meine Bibliothek in 256 ms zotero(3)(+0000001): Loading note for items in Meine Bibliothek zotero(4)(+0000000): SELECT itemID, note FROM items JOIN itemNotes USING (itemID) WHERE libraryID=? [1] zotero(4)(+0000002): SELECT itemID FROM items WHERE libraryID=? AND itemTypeID IN (?, ?) AND itemID NOT IN (SELECT itemID FROM itemNotes) [1, 26, 2] zotero(3)(+0000005): Loaded note in Meine Bibliothek in 7 ms zotero(3)(+0000000): Loading annotation for items in Meine Bibliothek zotero(4)(+0000000): SELECT itemID, IA.parentItemID, IA.type, IA.authorName, IA.text, IA.comment, IA.color, IA.sortIndex, IA.isExternal FROM items JOIN itemAnnotations IA USING (itemID) WHERE libraryID=? [1] zotero(3)(+0000005): Loaded annotation in Meine Bibliothek in 5 ms zotero(3)(+0000001): Loading annotationDeferred for items in Meine Bibliothek zotero(4)(+0000000): SELECT itemID, IA.position, IA.pageLabel FROM items JOIN itemAnnotations IA USING (itemID) WHERE libraryID=? [1] zotero(3)(+0000003): Loaded annotationDeferred in Meine Bibliothek in 3 ms zotero(3)(+0000001): Loading childItems for items in Meine Bibliothek zotero(4)(+0000000): SELECT parentItemID, A.itemID, value AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAttachments A JOIN items I ON (A.parentItemID=I.itemID) LEFT JOIN itemData ID ON (fieldID=1 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV USING (valueID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [1] zotero(4)(+0000004): SELECT parentItemID, N.itemID, title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemNotes N JOIN items I ON (N.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID [1] zotero(4)(+0000001): SELECT parentItemID, IAn.itemID, text || ' - ' || comment AS title, CASE WHEN DI.itemID IS NULL THEN 0 ELSE 1 END AS trashed FROM itemAnnotations IAn JOIN items I ON (IAn.parentItemID=I.itemID) LEFT JOIN deletedItems DI USING (itemID) WHERE libraryID=? ORDER BY parentItemID, sortIndex [1] zotero(4)(+0000006): SELECT itemID FROM items I WHERE libraryID=? [1] zotero(3)(+0000006): Loaded childItems in Meine Bibliothek in 17 ms zotero(3)(+0000001): Loading tags for items in Meine Bibliothek zotero(4)(+0000000): SELECT itemID, name, type FROM items LEFT JOIN itemTags USING (itemID) LEFT JOIN tags USING (tagID) WHERE libraryID=? [1] zotero(3)(+0000012): Loaded tags in Meine Bibliothek in 12 ms zotero(3)(+0000001): Loading collections for items in Meine Bibliothek zotero(4)(+0000000): SELECT itemID, collectionID FROM items LEFT JOIN collectionItems USING (itemID) WHERE libraryID=? [1] zotero(3)(+0000008): Loaded collections in Meine Bibliothek in 8 ms zotero(3)(+0000001): Loading relations for items in Meine Bibliothek zotero(4)(+0000000): SELECT itemID, predicate, object FROM items LEFT JOIN itemRelations USING (itemID) LEFT JOIN relationPredicates USING (predicateID) WHERE libraryID=? [1] zotero(3)(+0000009): Loaded relations in Meine Bibliothek in 9 ms zotero(3)(+0000000): Loaded items in Meine Bibliothek in 556 ms zotero(3)(+0000000): itemTree.changeCollectionTreeRow(): L1 zotero(3)(+0000001): Getting contents of C:\Users\xxxx\AppData\Roaming\Zotero\Zotero\Profiles\2smtafvd.default\treePrefs.json zotero(3)(+0000001): React CollectionTree loaded zotero(3)(+0000000): Writing column prefs of length 2053 to file C:\Users\xxxx\AppData\Roaming\Zotero\Zotero\Profiles\2smtafvd.default\treePrefs.json zotero(3)(+0000020): Getting contents of C:\Users\xxxx\AppData\Roaming\Zotero\Zotero\Profiles\2smtafvd.default\treePrefs.json zotero(3)(+0000003): Refreshing items list for item-tree-main-default zotero(4)(+0000006): CREATE TEMPORARY TABLE tmpSearchResults_3KHT1QY7 AS SELECT itemID FROM items WHERE (itemID NOT IN (SELECT itemID FROM deletedItems) AND itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems))) AND (itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL)) AND itemID IN (SELECT itemID FROM items WHERE (libraryID=?)) [1] zotero(4)(+0000002): CREATE INDEX tmpSearchResults_3KHT1QY7_itemID ON tmpSearchResults_3KHT1QY7(itemID) zotero(4)(+0000001): SELECT GROUP_CONCAT(itemID) FROM items WHERE itemID IN (SELECT itemID FROM items WHERE (itemID NOT IN (SELECT itemID FROM deletedItems) AND itemID NOT IN (SELECT itemID FROM itemNotes WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems)) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE parentItemID IS NOT NULL AND parentItemID IN (SELECT itemID FROM deletedItems))) AND itemID IN (SELECT itemID FROM items WHERE (libraryID=?))) AND (itemID IN (SELECT itemID FROM tmpSearchResults_3KHT1QY7) OR itemID IN (SELECT itemID FROM itemAttachments WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_3KHT1QY7)) OR itemID IN (SELECT itemID FROM itemNotes WHERE parentItemID IN (SELECT itemID FROM tmpSearchResults_3KHT1QY7))) [1] zotero(4)(+0000003): DROP TABLE IF EXISTS tmpSearchResults_3KHT1QY7 zotero(3)(+0000015): Sorting items list by title, firstCreator, date, dateAdded ascending for 277 items zotero(3)(+0000017): Sorted 277 items in 20 ms zotero(3)(+0000003): Refreshed open parents in 2 ms zotero(3)(+0000001): Rendering tag selector zotero(3)(+0000002): Rendering tag list zotero(3)(+0000004): Tag selector updated zotero(3)(+0000000): Updating tag selector from current view zotero(3)(+0000001): Creating tmpSearchResults_DLAgwGrG with 936 items zotero(3)(+0000003): itemTree.render(). Displaying Item Tree zotero(2)(+0000005): Storing itemTree item-tree-main-default column prefs zotero(3)(+0000124): itemTree.render(). Displaying Item Tree zotero(3)(+0000033): itemTree.render(). Displaying Item Tree zotero(4)(+0000006): CREATE UNIQUE INDEX tmpSearchResults_DLAgwGrG_itemID ON tmpSearchResults_DLAgwGrG(itemID) zotero(4)(+0000010): SELECT DISTINCT tagID || ':' || type FROM itemTags JOIN tags USING (tagID) WHERE 1 AND itemID IN (SELECT itemID FROM tmpSearchResults_DLAgwGrG) ORDER BY name COLLATE NOCASE zotero(3)(+0000011): Sorted tags in 5 ms zotero(3)(+0000001): Rendering tag selector zotero(3)(+0000028): Rendering tag list zotero(3)(+0000029): Tag selector updated zotero(4)(+0000029): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [129, 'https://www.mitpressjournals.org/doi/abs/10.1162/comj_a_00429'] zotero(3)(+0000002): PluginInstaller: fetching addon info zotero(3)(+0000001): PluginInstaller: addon info fetched zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [724, 'https://ieeexplore.ieee.org/document/9729696/'] zotero(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [872, 'https://www.isca-speech.org/archive/interspeech_2020/zhang20i_interspeech.html'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [870, 'https://www.isca-speech.org/archive/interspeech_2021/zhang21f_interspeech.html'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [722, 'https://ieeexplore.ieee.org/document/9345164/'] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [202, 'http://ieeexplore.ieee.org/document/403341/'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [175, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [62, ''] zotero(4)(+0000016): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [163, ''] zotero(4)(+0000009): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [124, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [84, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [886, 'https://www.sciencedirect.com/science/article/pii/S0003682X2030921X'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [467, ''] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [106, ''] zotero(4)(+0000018): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [913, 'https://asa.scitation.org/doi/full/10.1121/1.4731227'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [30, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327018307015'] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [71, 'http://www.mdpi.com/1999-4893/1/2/69'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [39, 'https://www.ingentaconnect.com/contentone/ince/incecp/1989/00001989/00000001/art00021'] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [105, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [881, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [113, ''] zotero(4)(+0000015): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [40, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327084710284'] zotero(4)(+0000016): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [68, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [228, ''] zotero(4)(+0000026): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [870, 'https://www.isca-speech.org/archive/interspeech_2021/zhang21f_interspeech.html'] zotero(4)(+0000015): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [722, 'https://ieeexplore.ieee.org/document/9345164/'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [202, 'http://ieeexplore.ieee.org/document/403341/'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [175, ''] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [62, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [163, ''] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [124, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [84, ''] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [886, 'https://www.sciencedirect.com/science/article/pii/S0003682X2030921X'] zotero(4)(+0000010): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [467, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [106, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [913, 'https://asa.scitation.org/doi/full/10.1121/1.4731227'] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [30, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327018307015'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [71, 'http://www.mdpi.com/1999-4893/1/2/69'] zotero(4)(+0000014): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [105, ''] zotero(4)(+0000008): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [881, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [113, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [40, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327084710284'] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [68, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [228, ''] zotero(3)(+0000032): WebSocket connection opened zotero(3)(+0000001): No general proxy or PAC file found -- assuming direct connection zotero(4)(+0000001): Sync not enabled -- skipping auto-sync zotero(3)(+0000014): WebSocket message: {"event":"connected","retry":10000} zotero(3)(+0000002): WebSocket message send: {"action":"createSubscriptions","subscriptions":[{"topics":["styles","translators"]}]} zotero(4)(+0000017): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [62, ''] zotero(4)(+0000004): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [163, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [124, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [84, ''] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [886, 'https://www.sciencedirect.com/science/article/pii/S0003682X2030921X'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [467, ''] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [106, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [913, 'https://asa.scitation.org/doi/full/10.1121/1.4731227'] zotero(4)(+0000019): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [30, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327018307015'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [71, 'http://www.mdpi.com/1999-4893/1/2/69'] zotero(4)(+0000005): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [105, ''] zotero(4)(+0000012): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [881, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [113, ''] zotero(4)(+0000000): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [40, 'https://linkinghub.elsevier.com/retrieve/pii/S0888327084710284'] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [68, ''] zotero(4)(+0000001): SELECT IA.itemID FROM itemAttachments IA NATURAL JOIN items I LEFT JOIN itemData ID ON (IA.itemID=ID.itemID AND fieldID=13) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE parentItemID=? AND linkMode NOT IN (3) AND IA.itemID NOT IN (SELECT itemID FROM deletedItems) ORDER BY contentType='application/pdf' DESC, value=? DESC, dateAdded ASC [228, ''] zotero(3)(+0000133): WebSocket message: {"event":"subscriptionsCreated","subscriptions":[{"topics":["styles","translators"]}],"errors":[]} zotero(3)(+0000787): Updating bundled files zotero(3)(+0000001): Initializing translators zotero(4)(+0000000): SELECT rowid, fileName, metadataJSON, lastModifiedTime FROM translatorCache zotero(3)(+0000195): Cached 686 translators in 195 ms zotero(3)(+0000002): HTTP GET resource://zotero/schema/repotime.txt zotero(3)(+0000001): HTTP GET resource://zotero/schema/repotime.txt succeeded with 200 zotero(4)(+0000001): SELECT version FROM version WHERE schema='delete' zotero(3)(+0000001): Getting contents of input stream zotero(4)(+0000001): SELECT version FROM version WHERE schema=? ['translators'] zotero(3)(+0000001): Installed translators are up-to-date with XPI zotero(3)(+0000000): Initializing styles zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\american-chemical-society.csl zotero(3)(+0000003): Getting contents of C:\Users\xxxx\Zotero\styles\american-medical-association.csl zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\american-political-science-association.csl zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\american-sociological-association.csl zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\apa.csl zotero(3)(+0000006): Getting contents of C:\Users\xxxx\Zotero\styles\chicago-author-date.csl zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\chicago-fullnote-bibliography.csl zotero(3)(+0000005): Getting contents of C:\Users\xxxx\Zotero\styles\chicago-note-bibliography.csl zotero(3)(+0000004): Getting contents of C:\Users\xxxx\Zotero\styles\elsevier-harvard.csl zotero(3)(+0000001): Getting contents of C:\Users\xxxx\Zotero\styles\harvard-cite-them-right.csl zotero(3)(+0000003): Getting contents of C:\Users\xxxx\Zotero\styles\ieee.csl zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\modern-humanities-research-association.csl zotero(3)(+0000003): Getting contents of C:\Users\xxxx\Zotero\styles\modern-language-association.csl zotero(3)(+0000001): Getting contents of C:\Users\xxxx\Zotero\styles\nature.csl zotero(3)(+0000002): Getting contents of C:\Users\xxxx\Zotero\styles\vancouver.csl zotero(3)(+0000003): Cached 15 styles in 43 ms zotero(3)(+0000000): HTTP GET chrome://zotero/content/locale/csl/locales.json zotero(3)(+0000001): HTTP GET chrome://zotero/content/locale/csl/locales.json succeeded with 200 zotero(3)(+0000000): HTTP GET resource://zotero/schema/renamed-styles.json zotero(3)(+0000001): HTTP GET resource://zotero/schema/renamed-styles.json succeeded with 200 zotero(3)(+0000003): HTTP GET resource://zotero/schema/repotime.txt zotero(3)(+0000001): HTTP GET resource://zotero/schema/repotime.txt succeeded with 200 zotero(4)(+0000002): SELECT version FROM version WHERE schema='delete' zotero(3)(+0000000): Getting contents of input stream zotero(4)(+0000001): SELECT version FROM version WHERE schema=? ['styles'] zotero(3)(+0000001): Installed styles are up-to-date with XPI zotero(3)(+0000000): HTTP GET https://api.zotero.org/retractions/list zotero(3)(+0000324): HTTP GET https://api.zotero.org/retractions/list succeeded with 304 zotero(3)(+0000000): Retraction list is up to date zotero(4)(+0000001): SELECT version FROM version WHERE schema='repository' zotero(3)(+0000000): Checking repository for translator and style updates zotero(3)(+0000001): HTTP POST "styles=%5B%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-chemical-society%22%2C%22updated%22%3A1651707865%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-chemical-society%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-medical-association%22%2C%22updated%22%3A1647701879%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-medical-association%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-political-science-association%22%2C%22updated%22%3A1448384762%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-political-science-association%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-sociological-association%22%2C%22updated%22%3A1652046536%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Famerican-sociological-association%22%7D%2C%7B%22id%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fapa%22%2C%22updated%22%3A1643640236%2C%22url%22%3A%22http%3A%2F%2Fwww.zotero.org%2Fstyles%2Fap…" (2966 chars) to https://repo.zotero.org/repo/updated?last=1652274386&version=6.0.6&m=3 zotero(3)(+0000348): HTTP POST https://repo.zotero.org/repo/updated?last=1652274386&version=6.0.6&m=3 succeeded with 200 zotero(4)(+0000001): Beginning DB transaction oHZAu4dC zotero(4)(+0000000): REPLACE INTO version (schema,version) VALUES (?,?) ['repository', 1652274413] zotero(4)(+0000001): REPLACE INTO version (schema,version) VALUES (?,?) ['lastcheck', 1652274413] zotero(4)(+0000004): Committed DB transaction oHZAu4dC zotero(3)(+0000000): All translators and styles are up-to-date zotero(3)(+0000001): Initializing DB backup idle observer zotero(4)(+0000001): Beginning DB transaction iwx1XUJb