[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:291:{i:0;s:5:\"13910\";i:1;s:5:\"14849\";i:2;s:5:\"14760\";i:3;s:5:\"15296\";i:4;s:5:\"14602\";i:5;s:5:\"14958\";i:6;s:5:\"14595\";i:7;s:5:\"14597\";i:8;s:5:\"14957\";i:9;s:5:\"14429\";i:10;s:5:\"14827\";i:11;s:5:\"14885\";i:12;s:5:\"14248\";i:13;s:5:\"16132\";i:14;s:5:\"15973\";i:15;s:5:\"15452\";i:16;s:5:\"14601\";i:17;s:5:\"14679\";i:18;s:5:\"15514\";i:19;s:5:\"14886\";i:20;s:5:\"14242\";i:21;s:5:\"14372\";i:22;s:5:\"14939\";i:23;s:5:\"15796\";i:24;s:5:\"14540\";i:25;s:5:\"16318\";i:26;s:5:\"14863\";i:27;s:5:\"16152\";i:28;s:5:\"14830\";i:29;s:5:\"14761\";i:30;s:5:\"14631\";i:31;s:5:\"14759\";i:32;s:5:\"15075\";i:33;s:5:\"14987\";i:34;s:5:\"14525\";i:35;s:5:\"15495\";i:36;s:5:\"16103\";i:37;s:5:\"14764\";i:38;s:5:\"14850\";i:39;s:5:\"14230\";i:40;s:5:\"15034\";i:41;s:5:\"13909\";i:42;s:5:\"14673\";i:43;s:5:\"14762\";i:44;s:5:\"15547\";i:45;s:5:\"14409\";i:46;s:5:\"14831\";i:47;s:5:\"14783\";i:48;s:5:\"14680\";i:49;s:5:\"15618\";i:50;s:5:\"15858\";i:51;s:5:\"14758\";i:52;s:5:\"15420\";i:53;s:5:\"14752\";i:54;s:5:\"15619\";i:55;s:5:\"14399\";i:56;s:5:\"14838\";i:57;s:5:\"14575\";i:58;s:5:\"14789\";i:59;s:5:\"14635\";i:60;s:5:\"14681\";i:61;s:5:\"14421\";i:62;s:5:\"14753\";i:63;s:5:\"14430\";i:64;s:5:\"14685\";i:65;s:5:\"14649\";i:66;s:5:\"15611\";i:67;s:5:\"15803\";i:68;s:5:\"15427\";i:69;s:5:\"15428\";i:70;s:5:\"14539\";i:71;s:5:\"16140\";i:72;s:5:\"14766\";i:73;s:5:\"14722\";i:74;s:5:\"15620\";i:75;s:5:\"14969\";i:76;s:5:\"15429\";i:77;s:5:\"14647\";i:78;s:5:\"16305\";i:79;s:5:\"14410\";i:80;s:5:\"15503\";i:81;s:5:\"15275\";i:82;s:5:\"14626\";i:83;s:5:\"15059\";i:84;s:5:\"15520\";i:85;s:5:\"14666\";i:86;s:5:\"14826\";i:87;s:5:\"14754\";i:88;s:5:\"15678\";i:89;s:5:\"14605\";i:90;s:5:\"15621\";i:91;s:5:\"14806\";i:92;s:5:\"14600\";i:93;s:5:\"15175\";i:94;s:5:\"14943\";i:95;s:5:\"15161\";i:96;s:5:\"14121\";i:97;s:5:\"14086\";i:98;s:5:\"14767\";i:99;s:5:\"14606\";i:100;s:5:\"15087\";i:101;s:5:\"15992\";i:102;s:5:\"14608\";i:103;s:5:\"14581\";i:104;s:5:\"14974\";i:105;s:5:\"16335\";i:106;s:5:\"14822\";i:107;s:5:\"14426\";i:108;s:5:\"15519\";i:109;s:5:\"14156\";i:110;s:5:\"14891\";i:111;s:5:\"14239\";i:112;s:5:\"14851\";i:113;s:5:\"14977\";i:114;s:5:\"14643\";i:115;s:5:\"16299\";i:116;s:5:\"14832\";i:117;s:5:\"15307\";i:118;s:5:\"14683\";i:119;s:5:\"14744\";i:120;s:5:\"14954\";i:121;s:5:\"14604\";i:122;s:5:\"14607\";i:123;s:5:\"14634\";i:124;s:5:\"14787\";i:125;s:5:\"14579\";i:126;s:5:\"15160\";i:127;s:5:\"14978\";i:128;s:5:\"14862\";i:129;s:5:\"15026\";i:130;s:5:\"14894\";i:131;s:5:\"14425\";i:132;s:5:\"14828\";i:133;s:5:\"14396\";i:134;s:5:\"14586\";i:135;s:5:\"14582\";i:136;s:5:\"14585\";i:137;s:5:\"14775\";i:138;s:5:\"14860\";i:139;s:5:\"15123\";i:140;s:5:\"15956\";i:141;s:5:\"14596\";i:142;s:5:\"14590\";i:143;s:5:\"15527\";i:144;s:5:\"14305\";i:145;s:5:\"14382\";i:146;s:5:\"14765\";i:147;s:5:\"14825\";i:148;s:5:\"16157\";i:149;s:5:\"14355\";i:150;s:5:\"14541\";i:151;s:5:\"14734\";i:152;s:5:\"15330\";i:153;s:5:\"15327\";i:154;s:5:\"14843\";i:155;s:5:\"15216\";i:156;s:5:\"14641\";i:157;s:5:\"16236\";i:158;s:5:\"15358\";i:159;s:5:\"14593\";i:160;s:5:\"15163\";i:161;s:5:\"14773\";i:162;s:5:\"15522\";i:163;s:5:\"15524\";i:164;s:5:\"14940\";i:165;s:5:\"14591\";i:166;s:5:\"14687\";i:167;s:5:\"14929\";i:168;s:5:\"14630\";i:169;s:5:\"16243\";i:170;s:5:\"15440\";i:171;s:5:\"15115\";i:172;s:5:\"14854\";i:173;s:5:\"14975\";i:174;s:5:\"15599\";i:175;s:5:\"14603\";i:176;s:5:\"14682\";i:177;s:5:\"14684\";i:178;s:5:\"14087\";i:179;s:5:\"14335\";i:180;s:5:\"15451\";i:181;s:5:\"14332\";i:182;s:5:\"14489\";i:183;s:5:\"14110\";i:184;s:5:\"14688\";i:185;s:5:\"14677\";i:186;s:5:\"14676\";i:187;s:5:\"14505\";i:188;s:5:\"15636\";i:189;s:5:\"16124\";i:190;s:5:\"15732\";i:191;s:5:\"16306\";i:192;s:5:\"14592\";i:193;s:5:\"15444\";i:194;s:5:\"14633\";i:195;s:5:\"16313\";i:196;s:5:\"15311\";i:197;s:5:\"15312\";i:198;s:5:\"15183\";i:199;s:5:\"15944\";i:200;s:5:\"14892\";i:201;s:5:\"16107\";i:202;s:5:\"15491\";i:203;s:5:\"14241\";i:204;s:5:\"14243\";i:205;s:5:\"15322\";i:206;s:5:\"14703\";i:207;s:5:\"14632\";i:208;s:5:\"15017\";i:209;s:5:\"15277\";i:210;s:5:\"15362\";i:211;s:5:\"14142\";i:212;s:5:\"14166\";i:213;s:5:\"14979\";i:214;s:5:\"15204\";i:215;s:5:\"15577\";i:216;s:5:\"15576\";i:217;s:5:\"16120\";i:218;s:5:\"14403\";i:219;s:5:\"14321\";i:220;s:5:\"14993\";i:221;s:5:\"15510\";i:222;s:5:\"15363\";i:223;s:5:\"15206\";i:224;s:5:\"14815\";i:225;s:5:\"14824\";i:226;s:5:\"15015\";i:227;s:5:\"15333\";i:228;s:5:\"14686\";i:229;s:5:\"14352\";i:230;s:5:\"15109\";i:231;s:5:\"14580\";i:232;s:5:\"16334\";i:233;s:5:\"15170\";i:234;s:5:\"15486\";i:235;s:5:\"16158\";i:236;s:5:\"14568\";i:237;s:5:\"15797\";i:238;s:5:\"15364\";i:239;s:5:\"14424\";i:240;s:5:\"15652\";i:241;s:5:\"14594\";i:242;s:5:\"14714\";i:243;s:5:\"14785\";i:244;s:5:\"14713\";i:245;s:5:\"14503\";i:246;s:5:\"14646\";i:247;s:5:\"14842\";i:248;s:5:\"14650\";i:249;s:5:\"14648\";i:250;s:5:\"15530\";i:251;s:5:\"15331\";i:252;s:5:\"14820\";i:253;s:5:\"14310\";i:254;s:5:\"14774\";i:255;s:5:\"14924\";i:256;s:5:\"14240\";i:257;s:5:\"14672\";i:258;s:5:\"15332\";i:259;s:5:\"14942\";i:260;s:5:\"14625\";i:261;s:5:\"14101\";i:262;s:5:\"15317\";i:263;s:5:\"15280\";i:264;s:5:\"14696\";i:265;s:5:\"15932\";i:266;s:5:\"14616\";i:267;s:5:\"14617\";i:268;s:5:\"14393\";i:269;s:5:\"14788\";i:270;s:5:\"14755\";i:271;s:5:\"14839\";i:272;s:5:\"14106\";i:273;s:5:\"14336\";i:274;s:5:\"16106\";i:275;s:5:\"14746\";i:276;s:5:\"14756\";i:277;s:5:\"14691\";i:278;s:5:\"15706\";i:279;s:5:\"15874\";i:280;s:5:\"14664\";i:281;s:5:\"14689\";i:282;s:5:\"13906\";i:283;s:5:\"14678\";i:284;s:5:\"14829\";i:285;s:5:\"15211\";i:286;s:5:\"14692\";i:287;s:5:\"14547\";i:288;s:5:\"14578\";i:289;s:5:\"14772\";i:290;s:5:\"14937\";}s:12:\"sql_ListStmt\";s:5823:\"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 (13906, 13909, 13910, 14086, 14087, 14101, 14106, 14110, 14121, 14142, 14156, 14166, 14230, 14239, 14240, 14241, 14242, 14243, 14248, 14305, 14310, 14321, 14332, 14335, 14336, 14352, 14355, 14372, 14382, 14393, 14396, 14399, 14403, 14409, 14410, 14421, 14424, 14425, 14426, 14429, 14430, 14489, 14503, 14505, 14525, 14539, 14540, 14541, 14547, 14568, 14575, 14578, 14579, 14580, 14581, 14582, 14585, 14586, 14590, 14591, 14592, 14593, 14594, 14595, 14596, 14597, 14600, 14601, 14602, 14603, 14604, 14605, 14606, 14607, 14608, 14616, 14617, 14625, 14626, 14630, 14631, 14632, 14633, 14634, 14635, 14641, 14643, 14646, 14647, 14648, 14649, 14650, 14664, 14666, 14672, 14673, 14676, 14677, 14678, 14679, 14680, 14681, 14682, 14683, 14684, 14685, 14686, 14687, 14688, 14689, 14691, 14692, 14696, 14703, 14713, 14714, 14722, 14734, 14744, 14746, 14752, 14753, 14754, 14755, 14756, 14758, 14759, 14760, 14761, 14762, 14764, 14765, 14766, 14767, 14772, 14773, 14774, 14775, 14783, 14785, 14787, 14788, 14789, 14806, 14815, 14820, 14822, 14824, 14825, 14826, 14827, 14828, 14829, 14830, 14831, 14832, 14838, 14839, 14842, 14843, 14849, 14850, 14851, 14854, 14860, 14862, 14863, 14885, 14886, 14891, 14892, 14894, 14924, 14929, 14937, 14939, 14940, 14942, 14943, 14954, 14957, 14958, 14969, 14974, 14975, 14977, 14978, 14979, 14987, 14993, 15015, 15017, 15026, 15034, 15059, 15075, 15087, 15109, 15115, 15123, 15160, 15161, 15163, 15170, 15175, 15183, 15204, 15206, 15211, 15216, 15275, 15277, 15280, 15296, 15307, 15311, 15312, 15317, 15322, 15327, 15330, 15331, 15332, 15333, 15358, 15362, 15363, 15364, 15420, 15427, 15428, 15429, 15440, 15444, 15451, 15452, 15486, 15491, 15495, 15503, 15510, 15514, 15519, 15520, 15522, 15524, 15527, 15530, 15547, 15576, 15577, 15599, 15611, 15618, 15619, 15620, 15621, 15636, 15652, 15678, 15706, 15732, 15796, 15797, 15803, 15858, 15874, 15932, 15944, 15956, 15973, 15992, 16103, 16106, 16107, 16120, 16124, 16132, 16140, 16152, 16157, 16158, 16236, 16243, 16299, 16305, 16306, 16313, 16318, 16334, 16335)) 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:\"13910\";i:1;s:5:\"14849\";i:2;s:5:\"14760\";i:3;s:5:\"15296\";i:4;s:5:\"14602\";i:5;s:5:\"14958\";i:6;s:5:\"14595\";i:7;s:5:\"14597\";i:8;s:5:\"14957\";i:9;s:5:\"14429\";i:10;s:5:\"14827\";i:11;s:5:\"14885\";i:12;s:5:\"14248\";i:13;s:5:\"16132\";i:14;s:5:\"15973\";i:15;s:5:\"15452\";i:16;s:5:\"14601\";i:17;s:5:\"14679\";i:18;s:5:\"15514\";i:19;s:5:\"14886\";i:20;s:5:\"14242\";i:21;s:5:\"14372\";i:22;s:5:\"14939\";i:23;s:5:\"15796\";i:24;s:5:\"14540\";i:25;s:5:\"16318\";i:26;s:5:\"14863\";i:27;s:5:\"16152\";i:28;s:5:\"14830\";i:29;s:5:\"14761\";i:30;s:5:\"14631\";i:31;s:5:\"14759\";i:32;s:5:\"15075\";i:33;s:5:\"14987\";i:34;s:5:\"14525\";i:35;s:5:\"15495\";i:36;s:5:\"16103\";i:37;s:5:\"14764\";i:38;s:5:\"14850\";i:39;s:5:\"14230\";i:40;s:5:\"15034\";i:41;s:5:\"13909\";i:42;s:5:\"14673\";i:43;s:5:\"14762\";i:44;s:5:\"15547\";i:45;s:5:\"14409\";i:46;s:5:\"14831\";i:47;s:5:\"14783\";i:48;s:5:\"14680\";i:49;s:5:\"15618\";i:50;s:5:\"15858\";i:51;s:5:\"14758\";i:52;s:5:\"15420\";i:53;s:5:\"14752\";i:54;s:5:\"15619\";i:55;s:5:\"14399\";i:56;s:5:\"14838\";i:57;s:5:\"14575\";i:58;s:5:\"14789\";i:59;s:5:\"14635\";i:60;s:5:\"14681\";i:61;s:5:\"14421\";i:62;s:5:\"14753\";i:63;s:5:\"14430\";i:64;s:5:\"14685\";i:65;s:5:\"14649\";i:66;s:5:\"15611\";i:67;s:5:\"15803\";i:68;s:5:\"15427\";i:69;s:5:\"15428\";i:70;s:5:\"14539\";i:71;s:5:\"16140\";i:72;s:5:\"14766\";i:73;s:5:\"14722\";i:74;s:5:\"15620\";i:75;s:5:\"14969\";i:76;s:5:\"15429\";i:77;s:5:\"14647\";i:78;s:5:\"16305\";i:79;s:5:\"14410\";i:80;s:5:\"15503\";i:81;s:5:\"15275\";i:82;s:5:\"14626\";i:83;s:5:\"15059\";i:84;s:5:\"15520\";i:85;s:5:\"14666\";i:86;s:5:\"14826\";i:87;s:5:\"14754\";i:88;s:5:\"15678\";i:89;s:5:\"14605\";i:90;s:5:\"15621\";i:91;s:5:\"14806\";i:92;s:5:\"14600\";i:93;s:5:\"15175\";i:94;s:5:\"14943\";i:95;s:5:\"15161\";i:96;s:5:\"14121\";i:97;s:5:\"14086\";i:98;s:5:\"14767\";i:99;s:5:\"14606\";}s:13:\"sql_LastMulti\";s:65:\"action=list_LISTSOMERESOURCES_CORE&method=yearProcess&id=MjAyMA==\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:21:\"Year:  2020\";}s:16:\"browse_LastOrder\";s:7:\"creator\";s:18:\"browse_LastAscDesc\";s:4:\" ASC\";s:13:\"browse_Method\";s:11:\"yearProcess\";s:9:\"browse_Id\";s:8:\"MjAyMA==\";s:18:\"browse_PagingTotal\";i:291;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');