[SQL Error] INSERT INTO temp_storage (`tempstorageId`, `tempstorageData`) VALUES ('52485b07-2c54-4f76-8c3c-c13fb5791d8c', '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:234:{i:0;s:4:\"3192\";i:1;s:4:\"3292\";i:2;s:4:\"3291\";i:3;s:4:\"3294\";i:4;s:4:\"3187\";i:5;s:4:\"3191\";i:6;s:4:\"5414\";i:7;s:4:\"3709\";i:8;s:4:\"2187\";i:9;s:4:\"6436\";i:10;s:5:\"15883\";i:11;s:4:\"1590\";i:12;s:4:\"3201\";i:13;s:5:\"12932\";i:14;s:5:\"13050\";i:15;s:4:\"2642\";i:16;s:4:\"5557\";i:17;s:5:\"11496\";i:18;s:4:\"3188\";i:19;s:4:\"4176\";i:20;s:5:\"11872\";i:21;s:4:\"3195\";i:22;s:5:\"15374\";i:23;s:4:\"8760\";i:24;s:4:\"3170\";i:25;s:4:\"7528\";i:26;s:4:\"1454\";i:27;s:4:\"3710\";i:28;s:4:\"9308\";i:29;s:4:\"2151\";i:30;s:4:\"1478\";i:31;s:4:\"3293\";i:32;s:4:\"3198\";i:33;s:4:\"2427\";i:34;s:4:\"2181\";i:35;s:5:\"13958\";i:36;s:4:\"1694\";i:37;s:4:\"1695\";i:38;s:4:\"5803\";i:39;s:4:\"2286\";i:40;s:4:\"3812\";i:41;s:5:\"14612\";i:42;s:4:\"9706\";i:43;s:5:\"11282\";i:44;s:5:\"12980\";i:45;s:4:\"9891\";i:46;s:4:\"3302\";i:47;s:4:\"8209\";i:48;s:4:\"9937\";i:49;s:4:\"2697\";i:50;s:4:\"3206\";i:51;s:4:\"6558\";i:52;s:4:\"3200\";i:53;s:4:\"3184\";i:54;s:4:\"9348\";i:55;s:4:\"7659\";i:56;s:4:\"3172\";i:57;s:4:\"1364\";i:58;s:4:\"9468\";i:59;s:4:\"7794\";i:60;s:4:\"3177\";i:61;s:4:\"3356\";i:62;s:4:\"2958\";i:63;s:4:\"3185\";i:64;s:4:\"2742\";i:65;s:4:\"9154\";i:66;s:4:\"6469\";i:67;s:4:\"2765\";i:68;s:4:\"3183\";i:69;s:4:\"4482\";i:70;s:4:\"3846\";i:71;s:4:\"4438\";i:72;s:5:\"10770\";i:73;s:4:\"7132\";i:74;s:4:\"8731\";i:75;s:4:\"8484\";i:76;s:5:\"11874\";i:77;s:4:\"3649\";i:78;s:4:\"6178\";i:79;s:5:\"14201\";i:80;s:4:\"6489\";i:81;s:4:\"3704\";i:82;s:4:\"3158\";i:83;s:4:\"6343\";i:84;s:4:\"6602\";i:85;s:4:\"2854\";i:86;s:4:\"4309\";i:87;s:5:\"10165\";i:88;s:4:\"5942\";i:89;s:4:\"3968\";i:90;s:4:\"3159\";i:91;s:4:\"3176\";i:92;s:4:\"3219\";i:93;s:4:\"4984\";i:94;s:4:\"9026\";i:95;s:4:\"5825\";i:96;s:4:\"1867\";i:97;s:4:\"8351\";i:98;s:5:\"10400\";i:99;s:4:\"4303\";i:100;s:4:\"4302\";i:101;s:5:\"10270\";i:102;s:4:\"3186\";i:103;s:4:\"3155\";i:104;s:4:\"2050\";i:105;s:4:\"2593\";i:106;s:4:\"2540\";i:107;s:4:\"4983\";i:108;s:4:\"3157\";i:109;s:5:\"12455\";i:110;s:5:\"15805\";i:111;s:4:\"1707\";i:112;s:4:\"3180\";i:113;s:4:\"2110\";i:114;s:4:\"3216\";i:115;s:4:\"8528\";i:116;s:4:\"2183\";i:117;s:4:\"3204\";i:118;s:4:\"4413\";i:119;s:4:\"8279\";i:120;s:4:\"1740\";i:121;s:4:\"1784\";i:122;s:4:\"3182\";i:123;s:4:\"3197\";i:124;s:4:\"2916\";i:125;s:4:\"3290\";i:126;s:4:\"4975\";i:127;s:4:\"2429\";i:128;s:4:\"3699\";i:129;s:4:\"8234\";i:130;s:4:\"2144\";i:131;s:4:\"4517\";i:132;s:4:\"7660\";i:133;s:4:\"3160\";i:134;s:4:\"2180\";i:135;s:4:\"7127\";i:136;s:4:\"2182\";i:137;s:4:\"3163\";i:138;s:4:\"1462\";i:139;s:4:\"1956\";i:140;s:4:\"3295\";i:141;s:5:\"11865\";i:142;s:4:\"6854\";i:143;s:4:\"1453\";i:144;s:4:\"6014\";i:145;s:4:\"4982\";i:146;s:5:\"10009\";i:147;s:4:\"8521\";i:148;s:4:\"3164\";i:149;s:4:\"3196\";i:150;s:4:\"3171\";i:151;s:4:\"5410\";i:152;s:4:\"5411\";i:153;s:4:\"2346\";i:154;s:4:\"3194\";i:155;s:4:\"3179\";i:156;s:4:\"5730\";i:157;s:5:\"11455\";i:158;s:4:\"8280\";i:159;s:4:\"7180\";i:160;s:4:\"3199\";i:161;s:4:\"2416\";i:162;s:4:\"4441\";i:163;s:4:\"3174\";i:164;s:4:\"1441\";i:165;s:4:\"3366\";i:166;s:4:\"3178\";i:167;s:4:\"3190\";i:168;s:4:\"3894\";i:169;s:4:\"6064\";i:170;s:4:\"2757\";i:171;s:4:\"3757\";i:172;s:4:\"1690\";i:173;s:4:\"4985\";i:174;s:4:\"3193\";i:175;s:4:\"3792\";i:176;s:4:\"3205\";i:177;s:4:\"3181\";i:178;s:4:\"1696\";i:179;s:4:\"2382\";i:180;s:5:\"10254\";i:181;s:5:\"10255\";i:182;s:4:\"3606\";i:183;s:4:\"2302\";i:184;s:4:\"7631\";i:185;s:4:\"6820\";i:186;s:4:\"2185\";i:187;s:5:\"12224\";i:188;s:4:\"2186\";i:189;s:5:\"10832\";i:190;s:4:\"8047\";i:191;s:4:\"3813\";i:192;s:4:\"6467\";i:193;s:5:\"11873\";i:194;s:4:\"2807\";i:195;s:4:\"6605\";i:196;s:4:\"2127\";i:197;s:5:\"12168\";i:198;s:5:\"14555\";i:199;s:4:\"8890\";i:200;s:4:\"3173\";i:201;s:4:\"4174\";i:202;s:4:\"4986\";i:203;s:5:\"11114\";i:204;s:4:\"3289\";i:205;s:4:\"6871\";i:206;s:4:\"5398\";i:207;s:4:\"1824\";i:208;s:4:\"5857\";i:209;s:4:\"7345\";i:210;s:5:\"12962\";i:211;s:4:\"3169\";i:212;s:4:\"1787\";i:213;s:4:\"1785\";i:214;s:4:\"7257\";i:215;s:5:\"15881\";i:216;s:5:\"15880\";i:217;s:4:\"4962\";i:218;s:4:\"3218\";i:219;s:4:\"3202\";i:220;s:4:\"3189\";i:221;s:4:\"2685\";i:222;s:4:\"1669\";i:223;s:4:\"5404\";i:224;s:4:\"3217\";i:225;s:4:\"3353\";i:226;s:4:\"9570\";i:227;s:5:\"14992\";i:228;s:4:\"2184\";i:229;s:4:\"4078\";i:230;s:4:\"3203\";i:231;s:4:\"1369\";i:232;s:4:\"1968\";i:233;s:4:\"6977\";}s:12:\"sql_ListStmt\";s:5223:\"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 (1364, 1369, 1441, 1453, 1454, 1462, 1478, 1590, 1669, 1690, 1694, 1695, 1696, 1707, 1740, 1784, 1785, 1787, 1824, 1867, 1956, 1968, 2050, 2110, 2127, 2144, 2151, 2180, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2286, 2302, 2346, 2382, 2416, 2427, 2429, 2540, 2593, 2642, 2685, 2697, 2742, 2757, 2765, 2807, 2854, 2916, 2958, 3155, 3157, 3158, 3159, 3160, 3163, 3164, 3169, 3170, 3171, 3172, 3173, 3174, 3176, 3177, 3178, 3179, 3180, 3181, 3182, 3183, 3184, 3185, 3186, 3187, 3188, 3189, 3190, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3216, 3217, 3218, 3219, 3289, 3290, 3291, 3292, 3293, 3294, 3295, 3302, 3353, 3356, 3366, 3606, 3649, 3699, 3704, 3709, 3710, 3757, 3792, 3812, 3813, 3846, 3894, 3968, 4078, 4174, 4176, 4302, 4303, 4309, 4413, 4438, 4441, 4482, 4517, 4962, 4975, 4982, 4983, 4984, 4985, 4986, 5398, 5404, 5410, 5411, 5414, 5557, 5730, 5803, 5825, 5857, 5942, 6014, 6064, 6178, 6343, 6436, 6467, 6469, 6489, 6558, 6602, 6605, 6820, 6854, 6871, 6977, 7127, 7132, 7180, 7257, 7345, 7528, 7631, 7659, 7660, 7794, 8047, 8209, 8234, 8279, 8280, 8351, 8484, 8521, 8528, 8731, 8760, 8890, 9026, 9154, 9308, 9348, 9468, 9570, 9706, 9891, 9937, 10009, 10165, 10254, 10255, 10270, 10400, 10770, 10832, 11114, 11282, 11455, 11496, 11865, 11872, 11873, 11874, 12168, 12224, 12455, 12932, 12962, 12980, 13050, 13958, 14201, 14555, 14612, 14992, 15374, 15805, 15880, 15881, 15883)) 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:\"3192\";i:1;s:4:\"3292\";i:2;s:4:\"3291\";i:3;s:4:\"3294\";i:4;s:4:\"3187\";i:5;s:4:\"3191\";i:6;s:4:\"5414\";i:7;s:4:\"3709\";i:8;s:4:\"2187\";i:9;s:4:\"6436\";i:10;s:5:\"15883\";i:11;s:4:\"1590\";i:12;s:4:\"3201\";i:13;s:5:\"12932\";i:14;s:5:\"13050\";i:15;s:4:\"2642\";i:16;s:4:\"5557\";i:17;s:5:\"11496\";i:18;s:4:\"3188\";i:19;s:4:\"4176\";i:20;s:5:\"11872\";i:21;s:4:\"3195\";i:22;s:5:\"15374\";i:23;s:4:\"8760\";i:24;s:4:\"3170\";i:25;s:4:\"7528\";i:26;s:4:\"1454\";i:27;s:4:\"3710\";i:28;s:4:\"9308\";i:29;s:4:\"2151\";i:30;s:4:\"1478\";i:31;s:4:\"3293\";i:32;s:4:\"3198\";i:33;s:4:\"2427\";i:34;s:4:\"2181\";i:35;s:5:\"13958\";i:36;s:4:\"1694\";i:37;s:4:\"1695\";i:38;s:4:\"5803\";i:39;s:4:\"2286\";i:40;s:4:\"3812\";i:41;s:5:\"14612\";i:42;s:4:\"9706\";i:43;s:5:\"11282\";i:44;s:5:\"12980\";i:45;s:4:\"9891\";i:46;s:4:\"3302\";i:47;s:4:\"8209\";i:48;s:4:\"9937\";i:49;s:4:\"2697\";i:50;s:4:\"3206\";i:51;s:4:\"6558\";i:52;s:4:\"3200\";i:53;s:4:\"3184\";i:54;s:4:\"9348\";i:55;s:4:\"7659\";i:56;s:4:\"3172\";i:57;s:4:\"1364\";i:58;s:4:\"9468\";i:59;s:4:\"7794\";i:60;s:4:\"3177\";i:61;s:4:\"3356\";i:62;s:4:\"2958\";i:63;s:4:\"3185\";i:64;s:4:\"2742\";i:65;s:4:\"9154\";i:66;s:4:\"6469\";i:67;s:4:\"2765\";i:68;s:4:\"3183\";i:69;s:4:\"4482\";i:70;s:4:\"3846\";i:71;s:4:\"4438\";i:72;s:5:\"10770\";i:73;s:4:\"7132\";i:74;s:4:\"8731\";i:75;s:4:\"8484\";i:76;s:5:\"11874\";i:77;s:4:\"3649\";i:78;s:4:\"6178\";i:79;s:5:\"14201\";i:80;s:4:\"6489\";i:81;s:4:\"3704\";i:82;s:4:\"3158\";i:83;s:4:\"6343\";i:84;s:4:\"6602\";i:85;s:4:\"2854\";i:86;s:4:\"4309\";i:87;s:5:\"10165\";i:88;s:4:\"5942\";i:89;s:4:\"3968\";i:90;s:4:\"3159\";i:91;s:4:\"3176\";i:92;s:4:\"3219\";i:93;s:4:\"4984\";i:94;s:4:\"9026\";i:95;s:4:\"5825\";i:96;s:4:\"1867\";i:97;s:4:\"8351\";i:98;s:5:\"10400\";i:99;s:4:\"4303\";}s:13:\"sql_LastMulti\";s:65:\"action=list_LISTSOMERESOURCES_CORE&method=yearProcess&id=MjAwMw==\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:21:\"Year:  2003\";}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:\"MjAwMw==\";s:18:\"browse_PagingTotal\";i:234;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');