[SQL Error] INSERT INTO temp_storage (`tempstorageId`, `tempstorageData`) VALUES ('040ecdc6-281c-426e-9686-81dfce55738d', 'a:18:{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:185:{i:0;s:4:\"2103\";i:1;s:5:\"12941\";i:2;s:4:\"4826\";i:3;s:4:\"6702\";i:4;s:4:\"7730\";i:5;s:5:\"12032\";i:6;s:4:\"6557\";i:7;s:5:\"12940\";i:8;s:4:\"5577\";i:9;s:4:\"5579\";i:10;s:4:\"7140\";i:11;s:4:\"2727\";i:12;s:4:\"4565\";i:13;s:4:\"7815\";i:14;s:5:\"11530\";i:15;s:5:\"14508\";i:16;s:4:\"5581\";i:17;s:5:\"12031\";i:18;s:4:\"5592\";i:19;s:5:\"12760\";i:20;s:4:\"5384\";i:21;s:5:\"10607\";i:22;s:5:\"12358\";i:23;s:4:\"4515\";i:24;s:4:\"5589\";i:25;s:4:\"9406\";i:26;s:4:\"5590\";i:27;s:4:\"9376\";i:28;s:5:\"13091\";i:29;s:5:\"10398\";i:30;s:4:\"7818\";i:31;s:5:\"14236\";i:32;s:4:\"2277\";i:33;s:4:\"8061\";i:34;s:4:\"2095\";i:35;s:4:\"2626\";i:36;s:5:\"10613\";i:37;s:4:\"2094\";i:38;s:4:\"2091\";i:39;s:4:\"6856\";i:40;s:4:\"9959\";i:41;s:5:\"10250\";i:42;s:4:\"6240\";i:43;s:4:\"1365\";i:44;s:5:\"12943\";i:45;s:4:\"2575\";i:46;s:5:\"14558\";i:47;s:4:\"1540\";i:48;s:4:\"7141\";i:49;s:4:\"9184\";i:50;s:5:\"14337\";i:51;s:4:\"7456\";i:52;s:5:\"10106\";i:53;s:4:\"2504\";i:54;s:5:\"10313\";i:55;s:5:\"16190\";i:56;s:5:\"16245\";i:57;s:5:\"16280\";i:58;s:5:\"12716\";i:59;s:5:\"15230\";i:60;s:4:\"7494\";i:61;s:5:\"13136\";i:62;s:5:\"12942\";i:63;s:4:\"5431\";i:64;s:4:\"2085\";i:65;s:4:\"9420\";i:66;s:5:\"10354\";i:67;s:5:\"10897\";i:68;s:4:\"6707\";i:69;s:4:\"5580\";i:70;s:4:\"2729\";i:71;s:4:\"8312\";i:72;s:5:\"14623\";i:73;s:4:\"1662\";i:74;s:5:\"12585\";i:75;s:4:\"2077\";i:76;s:5:\"10599\";i:77;s:4:\"6645\";i:78;s:4:\"5593\";i:79;s:4:\"9387\";i:80;s:4:\"6474\";i:81;s:5:\"12923\";i:82;s:4:\"2663\";i:83;s:4:\"2073\";i:84;s:5:\"11421\";i:85;s:4:\"9489\";i:86;s:4:\"2612\";i:87;s:5:\"11963\";i:88;s:5:\"13874\";i:89;s:4:\"8675\";i:90;s:4:\"5588\";i:91;s:4:\"6239\";i:92;s:5:\"10617\";i:93;s:5:\"14994\";i:94;s:4:\"7852\";i:95;s:4:\"8239\";i:96;s:5:\"15033\";i:97;s:5:\"14237\";i:98;s:4:\"7100\";i:99;s:4:\"5345\";i:100;s:4:\"5594\";i:101;s:4:\"2067\";i:102;s:4:\"9359\";i:103;s:5:\"11520\";i:104;s:5:\"15986\";i:105;s:5:\"10795\";i:106;s:4:\"8032\";i:107;s:4:\"9386\";i:108;s:4:\"6278\";i:109;s:5:\"14946\";i:110;s:5:\"15631\";i:111;s:5:\"10239\";i:112;s:5:\"14613\";i:113;s:4:\"5582\";i:114;s:4:\"1973\";i:115;s:5:\"10274\";i:116;s:4:\"9324\";i:117;s:4:\"5044\";i:118;s:4:\"5634\";i:119;s:4:\"7812\";i:120;s:4:\"8240\";i:121;s:5:\"11067\";i:122;s:4:\"5584\";i:123;s:5:\"12309\";i:124;s:5:\"12553\";i:125;s:5:\"13957\";i:126;s:4:\"6420\";i:127;s:5:\"12424\";i:128;s:5:\"12076\";i:129;s:5:\"11870\";i:130;s:5:\"11949\";i:131;s:5:\"15359\";i:132;s:4:\"2647\";i:133;s:4:\"9927\";i:134;s:5:\"15783\";i:135;s:4:\"5583\";i:136;s:5:\"14309\";i:137;s:4:\"9668\";i:138;s:4:\"1932\";i:139;s:5:\"12043\";i:140;s:4:\"7774\";i:141;s:5:\"11900\";i:142;s:4:\"8146\";i:143;s:4:\"4629\";i:144;s:4:\"5591\";i:145;s:4:\"1499\";i:146;s:4:\"9270\";i:147;s:5:\"14927\";i:148;s:4:\"9990\";i:149;s:4:\"9923\";i:150;s:4:\"9928\";i:151;s:4:\"1929\";i:152;s:4:\"9283\";i:153;s:5:\"11790\";i:154;s:5:\"10097\";i:155;s:4:\"1924\";i:156;s:4:\"9187\";i:157;s:4:\"9185\";i:158;s:4:\"6234\";i:159;s:4:\"3388\";i:160;s:4:\"3816\";i:161;s:5:\"11737\";i:162;s:5:\"14093\";i:163;s:5:\"15555\";i:164;s:5:\"14436\";i:165;s:4:\"1912\";i:166;s:4:\"2726\";i:167;s:5:\"11106\";i:168;s:4:\"3607\";i:169;s:5:\"11018\";i:170;s:5:\"11965\";i:171;s:5:\"12060\";i:172;s:4:\"6643\";i:173;s:4:\"1908\";i:174;s:4:\"4353\";i:175;s:4:\"1905\";i:176;s:5:\"11581\";i:177;s:4:\"4282\";i:178;s:4:\"1369\";i:179;s:5:\"11948\";i:180;s:4:\"8687\";i:181;s:5:\"13138\";i:182;s:5:\"14350\";i:183;s:5:\"15987\";i:184;s:5:\"12450\";}s:12:\"sql_ListStmt\";s:4973:\"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 (1365, 1499, 1905, 1908, 1912, 1924, 1929, 1932, 1973, 2067, 2073, 2077, 2085, 2091, 2094, 2095, 2575, 2626, 2663, 2726, 2727, 3388, 3816, 4565, 4629, 5345, 5384, 5431, 5577, 5579, 5580, 5581, 5583, 5584, 5588, 5589, 5590, 5591, 5592, 5593, 5594, 5634, 6234, 6239, 6240, 6278, 6420, 6557, 6643, 6645, 6702, 6707, 6856, 7100, 7141, 7456, 7494, 7812, 7815, 7818, 8032, 8061, 8240, 8239, 4826, 4353, 1369, 4515, 8146, 8675, 9184, 9185, 9187, 9270, 9324, 7140, 9359, 9376, 9387, 9406, 9420, 9489, 6474, 2612, 5044, 9668, 9923, 9927, 9928, 7774, 9959, 2647, 10274, 10313, 10398, 10106, 7852, 10599, 10607, 10613, 10795, 10897, 9283, 8687, 11018, 11106, 1540, 5582, 10617, 11421, 11520, 2103, 11067, 11737, 11790, 11870, 11900, 11948, 11949, 11965, 10250, 12031, 12032, 12043, 12060, 12076, 12309, 8312, 12358, 12424, 12450, 12553, 12585, 12716, 12760, 10354, 2504, 9386, 12940, 12941, 12942, 12943, 1662, 11963, 3607, 4282, 13091, 13138, 2277, 13874, 11581, 13957, 13136, 14093, 12923, 14237, 14236, 14309, 14337, 14350, 7730, 14436, 14508, 14558, 14613, 14623, 2729, 14927, 14946, 14994, 15033, 15230, 9990, 15359, 15555, 15631, 10239, 15783, 10097, 15986, 15987, 16190, 16245, 11530, 16280)) 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:4:\"2103\";i:1;s:5:\"12941\";i:2;s:4:\"4826\";i:3;s:4:\"6702\";i:4;s:4:\"7730\";i:5;s:5:\"12032\";i:6;s:4:\"6557\";i:7;s:5:\"12940\";i:8;s:4:\"5577\";i:9;s:4:\"5579\";i:10;s:4:\"7140\";i:11;s:4:\"2727\";i:12;s:4:\"4565\";i:13;s:4:\"7815\";i:14;s:5:\"11530\";i:15;s:5:\"14508\";i:16;s:4:\"5581\";i:17;s:5:\"12031\";i:18;s:4:\"5592\";i:19;s:5:\"12760\";i:20;s:4:\"5384\";i:21;s:5:\"10607\";i:22;s:5:\"12358\";i:23;s:4:\"4515\";i:24;s:4:\"5589\";i:25;s:4:\"9406\";i:26;s:4:\"5590\";i:27;s:4:\"9376\";i:28;s:5:\"13091\";i:29;s:5:\"10398\";i:30;s:4:\"7818\";i:31;s:5:\"14236\";i:32;s:4:\"2277\";i:33;s:4:\"8061\";i:34;s:4:\"2095\";i:35;s:4:\"2626\";i:36;s:5:\"10613\";i:37;s:4:\"2094\";i:38;s:4:\"2091\";i:39;s:4:\"6856\";i:40;s:4:\"9959\";i:41;s:5:\"10250\";i:42;s:4:\"6240\";i:43;s:4:\"1365\";i:44;s:5:\"12943\";i:45;s:4:\"2575\";i:46;s:5:\"14558\";i:47;s:4:\"1540\";i:48;s:4:\"7141\";i:49;s:4:\"9184\";i:50;s:5:\"14337\";i:51;s:4:\"7456\";i:52;s:5:\"10106\";i:53;s:4:\"2504\";i:54;s:5:\"10313\";i:55;s:5:\"16190\";i:56;s:5:\"16245\";i:57;s:5:\"16280\";i:58;s:5:\"12716\";i:59;s:5:\"15230\";i:60;s:4:\"7494\";i:61;s:5:\"13136\";i:62;s:5:\"12942\";i:63;s:4:\"5431\";i:64;s:4:\"2085\";i:65;s:4:\"9420\";i:66;s:5:\"10354\";i:67;s:5:\"10897\";i:68;s:4:\"6707\";i:69;s:4:\"5580\";i:70;s:4:\"2729\";i:71;s:4:\"8312\";i:72;s:5:\"14623\";i:73;s:4:\"1662\";i:74;s:5:\"12585\";i:75;s:4:\"2077\";i:76;s:5:\"10599\";i:77;s:4:\"6645\";i:78;s:4:\"5593\";i:79;s:4:\"9387\";i:80;s:4:\"6474\";i:81;s:5:\"12923\";i:82;s:4:\"2663\";i:83;s:4:\"2073\";i:84;s:5:\"11421\";i:85;s:4:\"9489\";i:86;s:4:\"2612\";i:87;s:5:\"11963\";i:88;s:5:\"13874\";i:89;s:4:\"8675\";i:90;s:4:\"5588\";i:91;s:4:\"6239\";i:92;s:5:\"10617\";i:93;s:5:\"14994\";i:94;s:4:\"7852\";i:95;s:4:\"8239\";i:96;s:5:\"15033\";i:97;s:5:\"14237\";i:98;s:4:\"7100\";i:99;s:4:\"5345\";}s:13:\"sql_LastMulti\";s:63:\"action=list_LISTSOMERESOURCES_CORE&method=keywordProcess&id=658\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:33:\"Keyword:  Gibbons. Dave\";}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:\"658\";s:18:\"browse_PagingTotal\";i:185;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');