[SQL Error] INSERT INTO temp_storage (`tempstorageId`, `tempstorageData`) VALUES ('8e7df945-8971-4290-bc2e-045af56961e1', 'a:19:{s:19:\"bookmark_DisplayAdd\";b:1;s:12:\"browse_Order\";s:7:\"creator\";s:14:\"browse_AscDesc\";s:4:\" ASC\";s:12:\"sql_ListType\";s:6:\"browse\";s:10:\"sql_AllIds\";a:147:{i:0;s:5:\"14804\";i:1;s:5:\"11709\";i:2;s:5:\"13777\";i:3;s:5:\"15779\";i:4;s:5:\"11685\";i:5;s:5:\"12200\";i:6;s:4:\"9829\";i:7;s:5:\"12704\";i:8;s:5:\"12036\";i:9;s:5:\"12869\";i:10;s:5:\"10231\";i:11;s:5:\"15796\";i:12;s:5:\"15601\";i:13;s:5:\"10307\";i:14;s:4:\"1478\";i:15;s:4:\"5635\";i:16;s:4:\"6553\";i:17;s:4:\"4883\";i:18;s:4:\"6263\";i:19;s:4:\"3212\";i:20;s:4:\"3932\";i:21;s:5:\"14197\";i:22;s:5:\"13307\";i:23;s:4:\"7381\";i:24;s:4:\"6720\";i:25;s:4:\"6724\";i:26;s:4:\"9424\";i:27;s:4:\"8151\";i:28;s:5:\"11058\";i:29;s:5:\"13823\";i:30;s:4:\"8996\";i:31;s:4:\"4979\";i:32;s:5:\"12671\";i:33;s:4:\"8985\";i:34;s:4:\"3410\";i:35;s:4:\"4090\";i:36;s:4:\"4371\";i:37;s:5:\"10822\";i:38;s:5:\"12669\";i:39;s:5:\"12936\";i:40;s:4:\"9468\";i:41;s:5:\"12672\";i:42;s:5:\"11119\";i:43;s:5:\"14983\";i:44;s:4:\"6141\";i:45;s:4:\"5180\";i:46;s:4:\"3733\";i:47;s:5:\"14486\";i:48;s:5:\"13224\";i:49;s:5:\"10859\";i:50;s:5:\"10736\";i:51;s:5:\"10737\";i:52;s:5:\"12202\";i:53;s:4:\"7264\";i:54;s:5:\"11296\";i:55;s:5:\"12751\";i:56;s:4:\"7292\";i:57;s:4:\"1868\";i:58;s:5:\"14711\";i:59;s:4:\"7094\";i:60;s:5:\"11639\";i:61;s:4:\"9567\";i:62;s:5:\"10341\";i:63;s:4:\"8303\";i:64;s:4:\"8302\";i:65;s:4:\"9467\";i:66;s:5:\"13836\";i:67;s:5:\"10024\";i:68;s:4:\"4978\";i:69;s:5:\"15212\";i:70;s:4:\"2670\";i:71;s:4:\"2645\";i:72;s:4:\"3940\";i:73;s:4:\"5788\";i:74;s:4:\"8190\";i:75;s:4:\"5477\";i:76;s:4:\"5827\";i:77;s:4:\"7663\";i:78;s:5:\"12967\";i:79;s:4:\"5787\";i:80;s:4:\"3652\";i:81;s:4:\"9239\";i:82;s:4:\"6248\";i:83;s:5:\"12754\";i:84;s:4:\"2668\";i:85;s:5:\"11892\";i:86;s:4:\"1990\";i:87;s:5:\"13256\";i:88;s:4:\"8891\";i:89;s:4:\"8892\";i:90;s:5:\"13675\";i:91;s:4:\"6915\";i:92;s:5:\"12203\";i:93;s:5:\"10886\";i:94;s:4:\"4975\";i:95;s:4:\"4976\";i:96;s:4:\"7385\";i:97;s:5:\"14803\";i:98;s:5:\"10295\";i:99;s:5:\"15382\";i:100;s:5:\"10511\";i:101;s:5:\"13019\";i:102;s:5:\"11769\";i:103;s:5:\"13677\";i:104;s:4:\"8936\";i:105;s:5:\"11014\";i:106;s:5:\"15491\";i:107;s:4:\"4083\";i:108;s:4:\"4082\";i:109;s:5:\"12216\";i:110;s:4:\"3214\";i:111;s:5:\"14619\";i:112;s:5:\"15443\";i:113;s:4:\"7991\";i:114;s:5:\"15940\";i:115;s:4:\"1618\";i:116;s:5:\"10439\";i:117;s:4:\"9095\";i:118;s:5:\"12968\";i:119;s:5:\"13985\";i:120;s:5:\"15797\";i:121;s:5:\"10938\";i:122;s:5:\"12201\";i:123;s:5:\"10259\";i:124;s:4:\"8084\";i:125;s:5:\"10862\";i:126;s:4:\"7542\";i:127;s:4:\"5199\";i:128;s:4:\"2568\";i:129;s:4:\"5786\";i:130;s:4:\"2566\";i:131;s:5:\"10384\";i:132;s:4:\"4370\";i:133;s:5:\"14802\";i:134;s:5:\"11249\";i:135;s:5:\"12753\";i:136;s:5:\"16123\";i:137;s:4:\"2454\";i:138;s:5:\"10232\";i:139;s:5:\"15788\";i:140;s:5:\"14548\";i:141;s:5:\"10233\";i:142;s:5:\"10461\";i:143;s:4:\"4658\";i:144;s:5:\"16258\";i:145;s:4:\"4372\";i:146;s:5:\"13311\";}s:12:\"sql_ListStmt\";s:4746:\"SELECT `creatorSurname`, `resourcecreatorResourceId`, `resourceId`, `resourceType`, `resourceTitle`, `resourceSubtitle`, `resourceShortTitle`, `resourceTitleSort`, `resourceTransTitle`, `resourceTransSubtitle`, `resourceTransShortTitle`, `resourceField1`, `resourceField2`, `resourceField3`, `resourceField4`, `resourceField5`, `resourceField6`, `resourceField7`, `resourceField8`, `resourceField9`, `resourceNoSort`, `resourceTransNoSort`, `resourceIsbn`, `resourceDoi`, `resourceLanguage`, `resourceyearId`, `resourceyearYear1`, `resourceyearYear2`, `resourceyearYear3`, `resourceyearYear4`, `resourcepageId`, `resourcepagePageStart`, `resourcepagePageEnd`, `resourcemiscId`, `resourcemiscCollection`, `resourcemiscPublisher`, `resourcemiscField1`, `resourcemiscField2`, `resourcemiscField3`, `resourcemiscField4`, `resourcemiscField5`, `resourcemiscField6`, `resourcemiscAddUserIdResource`, `resourcemiscEditUserIdResource`, `resourcemiscMaturityIndex`, `resourcemiscPeerReviewed`, `resourcetimestampTimestampAdd`, `resourcetimestampTimestamp`, `resourcemiscQuarantine`, `resourceBibtexKey`, `resourcetextAbstract`, `resourcetextAddUserIdAbstract`, `resourcetextEditUserIdAbstract`, `resourcetextNote`, `resourcetextAddUserIdNote`, `resourcetextEditUserIdNote`, `resourcemiscMetadata`, `publisherName`, `usersFullname`, `usersUsername` FROM (SELECT GROUP_CONCAT(`creatorSurname` ORDER BY `resourcecreatorRole`, `resourcecreatorOrder` ASC SEPARATOR \' \') AS \'creatorSurname\', `creatorPrefix`, `resourcecreatorResourceId` FROM resource_creator LEFT JOIN resource ON `resourcecreatorResourceId` = `resourceId` LEFT JOIN creator ON `resourcecreatorCreatorId` = `creatorId` LEFT JOIN resource_misc ON `resourcemiscId` = `resourceId` WHERE (IF(`resourceType` = \'book\' OR `resourceType` = \'book_chapter\' OR `resourceType` = \'book_article\' OR `resourceType` = \'web_encyclopedia\' OR `resourceType` = \'web_encyclopedia_article\', CASE WHEN (`resourcecreatorRole` = 1) THEN `resourcecreatorRole` = 1 WHEN (`resourcecreatorRole` = 2) THEN `resourcecreatorRole` = 2 WHEN (`resourcecreatorRole` = 3) THEN `resourcecreatorRole` = 3 WHEN (`resourcecreatorRole` = 4) THEN `resourcecreatorRole` = 4 WHEN (`resourcecreatorRole` = 5) THEN `resourcecreatorRole` = 5 ELSE (`resourcecreatorRole` IS NULL) END, 1)) AND (`resourcecreatorResourceId` IN (1478, 1618, 1868, 1990, 2454, 2645, 2670, 3214, 3410, 3652, 3733, 3932, 3940, 4083, 4370, 4090, 4371, 4372, 4658, 4883, 4975, 4979, 5180, 5477, 5635, 5786, 5787, 5788, 5827, 6141, 6248, 6263, 6553, 6720, 6724, 6915, 7381, 7542, 7991, 8151, 7663, 8190, 4082, 8302, 8303, 2568, 2566, 8084, 7292, 8936, 8985, 9095, 9424, 9239, 10259, 10295, 10307, 10439, 10461, 10233, 10232, 10231, 10511, 9467, 10024, 10736, 10737, 10822, 10886, 10938, 11014, 11058, 11119, 4978, 4976, 11249, 9468, 11639, 11685, 9829, 11892, 12036, 12201, 12200, 12202, 12203, 12216, 7385, 10859, 12669, 12672, 10384, 12671, 12704, 12751, 12753, 12754, 3212, 11296, 11769, 12869, 12936, 12967, 12968, 7094, 13224, 13256, 13311, 8996, 7264, 9567, 8892, 8891, 13019, 5199, 10862, 10341, 13675, 13677, 13307, 13823, 13836, 13985, 14197, 14486, 11709, 14548, 14619, 14711, 14802, 14803, 14804, 14983, 13777, 15212, 15382, 15443, 15491, 15601, 15788, 15779, 15940, 2668, 16123, 16258, 15796, 15797)) AND (`resourcemiscQuarantine` = \'N\') GROUP BY `resourcecreatorResourceId` ORDER BY `resourcecreatorOrder` ASC) AS t1 LEFT JOIN resource ON `resourceId` = `resourcecreatorResourceId` LEFT JOIN resource_year ON `resourceId` = `resourceyearId` LEFT JOIN resource_page ON `resourceId` = `resourcepageId` LEFT JOIN resource_misc ON `resourceId` = `resourcemiscId` LEFT JOIN resource_timestamp ON `resourceId` = `resourcetimestampId` LEFT JOIN resource_text ON `resourceId` = `resourcetextId` LEFT JOIN publisher ON `resourcemiscPublisher` = `publisherId` LEFT JOIN users ON CASE WHEN (`resourcemiscEditUserIdResource` IS NULL) THEN (`resourcemiscAddUserIdResource`) ELSE (`resourcemiscEditUserIdResource`) END = `usersId` ORDER BY REPLACE( REPLACE(IF(`creatorSurname` IS NOT NULL, `creatorSurname`, `resourceTitleSort`), \'{\', \'\'), \'}\', \'\') ASC, CASE WHEN ((`resourceType` = \'book\' OR `resourceType` = \'book_chapter\' OR `resourceType` = \'book_article\' OR `resourceType` = \'web_encyclopedia\' OR `resourceType` = \'web_encyclopedia_article\') AND CAST(`resourceyearYear2` AS UNSIGNED) IS NOT NULL) OR ((`resourceType` = \'proceedings_article\' OR `resourceType` = \'conference_paper\' OR `resourceType` = \'conference_poster\') AND CAST(`resourceyearYear1` AS UNSIGNED) IS NULL) THEN CAST(`resourceyearYear2` AS UNSIGNED) ELSE CAST(`resourceyearYear1` AS UNSIGNED) END ASC, REPLACE( REPLACE(`resourceTitleSort`, \'{\', \'\'), \'}\', \'\') ASC, `resourceId` ASC\";s:14:\"display_AllIds\";a:100:{i:0;s:5:\"14804\";i:1;s:5:\"11709\";i:2;s:5:\"13777\";i:3;s:5:\"15779\";i:4;s:5:\"11685\";i:5;s:5:\"12200\";i:6;s:4:\"9829\";i:7;s:5:\"12704\";i:8;s:5:\"12036\";i:9;s:5:\"12869\";i:10;s:5:\"10231\";i:11;s:5:\"15796\";i:12;s:5:\"15601\";i:13;s:5:\"10307\";i:14;s:4:\"1478\";i:15;s:4:\"5635\";i:16;s:4:\"6553\";i:17;s:4:\"4883\";i:18;s:4:\"6263\";i:19;s:4:\"3212\";i:20;s:4:\"3932\";i:21;s:5:\"14197\";i:22;s:5:\"13307\";i:23;s:4:\"7381\";i:24;s:4:\"6720\";i:25;s:4:\"6724\";i:26;s:4:\"9424\";i:27;s:4:\"8151\";i:28;s:5:\"11058\";i:29;s:5:\"13823\";i:30;s:4:\"8996\";i:31;s:4:\"4979\";i:32;s:5:\"12671\";i:33;s:4:\"8985\";i:34;s:4:\"3410\";i:35;s:4:\"4090\";i:36;s:4:\"4371\";i:37;s:5:\"10822\";i:38;s:5:\"12669\";i:39;s:5:\"12936\";i:40;s:4:\"9468\";i:41;s:5:\"12672\";i:42;s:5:\"11119\";i:43;s:5:\"14983\";i:44;s:4:\"6141\";i:45;s:4:\"5180\";i:46;s:4:\"3733\";i:47;s:5:\"14486\";i:48;s:5:\"13224\";i:49;s:5:\"10859\";i:50;s:5:\"10736\";i:51;s:5:\"10737\";i:52;s:5:\"12202\";i:53;s:4:\"7264\";i:54;s:5:\"11296\";i:55;s:5:\"12751\";i:56;s:4:\"7292\";i:57;s:4:\"1868\";i:58;s:5:\"14711\";i:59;s:4:\"7094\";i:60;s:5:\"11639\";i:61;s:4:\"9567\";i:62;s:5:\"10341\";i:63;s:4:\"8303\";i:64;s:4:\"8302\";i:65;s:4:\"9467\";i:66;s:5:\"13836\";i:67;s:5:\"10024\";i:68;s:4:\"4978\";i:69;s:5:\"15212\";i:70;s:4:\"2670\";i:71;s:4:\"2645\";i:72;s:4:\"3940\";i:73;s:4:\"5788\";i:74;s:4:\"8190\";i:75;s:4:\"5477\";i:76;s:4:\"5827\";i:77;s:4:\"7663\";i:78;s:5:\"12967\";i:79;s:4:\"5787\";i:80;s:4:\"3652\";i:81;s:4:\"9239\";i:82;s:4:\"6248\";i:83;s:5:\"12754\";i:84;s:4:\"2668\";i:85;s:5:\"11892\";i:86;s:4:\"1990\";i:87;s:5:\"13256\";i:88;s:4:\"8891\";i:89;s:4:\"8892\";i:90;s:5:\"13675\";i:91;s:4:\"6915\";i:92;s:5:\"12203\";i:93;s:5:\"10886\";i:94;s:4:\"4975\";i:95;s:4:\"4976\";i:96;s:4:\"7385\";i:97;s:5:\"14803\";i:98;s:5:\"10295\";i:99;s:5:\"15382\";}s:13:\"sql_LastMulti\";s:71:\"action=list_LISTSOMERESOURCES_CORE&method=keywordProcess&id=903&catId=1\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:30:\"Keyword:  Nonfiction\";}s:16:\"browse_LastOrder\";s:7:\"creator\";s:18:\"browse_LastAscDesc\";s:4:\" ASC\";s:13:\"browse_Method\";s:14:\"keywordProcess\";s:9:\"browse_Id\";s:3:\"903\";s:12:\"browse_CatId\";s:1:\"1\";s:18:\"browse_PagingTotal\";i:147;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');