[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:236:{i:0;s:4:\"3019\";i:1;s:4:\"3006\";i:2;s:4:\"1394\";i:3;s:4:\"9827\";i:4;s:4:\"3954\";i:5;s:4:\"9385\";i:6;s:4:\"2707\";i:7;s:4:\"2020\";i:8;s:4:\"9178\";i:9;s:4:\"2696\";i:10;s:4:\"3033\";i:11;s:4:\"9606\";i:12;s:4:\"8650\";i:13;s:4:\"1779\";i:14;s:5:\"11829\";i:15;s:4:\"6693\";i:16;s:4:\"7170\";i:17;s:4:\"1477\";i:18;s:4:\"9845\";i:19;s:4:\"3614\";i:20;s:4:\"4126\";i:21;s:4:\"3011\";i:22;s:4:\"5778\";i:23;s:4:\"5566\";i:24;s:4:\"2655\";i:25;s:4:\"6374\";i:26;s:4:\"1841\";i:27;s:4:\"8765\";i:28;s:5:\"11828\";i:29;s:4:\"7851\";i:30;s:5:\"12996\";i:31;s:4:\"1825\";i:32;s:4:\"2627\";i:33;s:4:\"1829\";i:34;s:5:\"11703\";i:35;s:4:\"1397\";i:36;s:4:\"3616\";i:37;s:4:\"8441\";i:38;s:4:\"3232\";i:39;s:4:\"7435\";i:40;s:4:\"1391\";i:41;s:4:\"6089\";i:42;s:4:\"4414\";i:43;s:4:\"4651\";i:44;s:4:\"2501\";i:45;s:4:\"4920\";i:46;s:4:\"4921\";i:47;s:4:\"6373\";i:48;s:4:\"6441\";i:49;s:4:\"3015\";i:50;s:4:\"4780\";i:51;s:4:\"3345\";i:52;s:4:\"2356\";i:53;s:4:\"1393\";i:54;s:5:\"15132\";i:55;s:4:\"3014\";i:56;s:4:\"7020\";i:57;s:4:\"5752\";i:58;s:5:\"10093\";i:59;s:4:\"3035\";i:60;s:4:\"3347\";i:61;s:4:\"5876\";i:62;s:4:\"5734\";i:63;s:4:\"3008\";i:64;s:4:\"4930\";i:65;s:4:\"2925\";i:66;s:4:\"1743\";i:67;s:4:\"2928\";i:68;s:4:\"9510\";i:69;s:5:\"12716\";i:70;s:4:\"6637\";i:71;s:4:\"1768\";i:72;s:4:\"3146\";i:73;s:4:\"1503\";i:74;s:4:\"2467\";i:75;s:4:\"1839\";i:76;s:4:\"4462\";i:77;s:4:\"3618\";i:78;s:4:\"6491\";i:79;s:4:\"7234\";i:80;s:4:\"2733\";i:81;s:5:\"14057\";i:82;s:4:\"3009\";i:83;s:4:\"4613\";i:84;s:4:\"6003\";i:85;s:4:\"6375\";i:86;s:5:\"15093\";i:87;s:4:\"3036\";i:88;s:4:\"3016\";i:89;s:4:\"5362\";i:90;s:4:\"3349\";i:91;s:4:\"5756\";i:92;s:4:\"2322\";i:93;s:4:\"3346\";i:94;s:4:\"2747\";i:95;s:4:\"2744\";i:96;s:5:\"11436\";i:97;s:4:\"1809\";i:98;s:5:\"10922\";i:99;s:4:\"9473\";i:100;s:4:\"1502\";i:101;s:4:\"3208\";i:102;s:5:\"10142\";i:103;s:4:\"3211\";i:104;s:4:\"5263\";i:105;s:4:\"6904\";i:106;s:4:\"3615\";i:107;s:4:\"3137\";i:108;s:4:\"4451\";i:109;s:4:\"4626\";i:110;s:4:\"3013\";i:111;s:4:\"5941\";i:112;s:4:\"7173\";i:113;s:4:\"2612\";i:114;s:4:\"1770\";i:115;s:4:\"6376\";i:116;s:4:\"8231\";i:117;s:4:\"3012\";i:118;s:4:\"6857\";i:119;s:4:\"1738\";i:120;s:4:\"3028\";i:121;s:4:\"1506\";i:122;s:4:\"1395\";i:123;s:4:\"4117\";i:124;s:4:\"1400\";i:125;s:4:\"2758\";i:126;s:4:\"8530\";i:127;s:4:\"8532\";i:128;s:4:\"2424\";i:129;s:5:\"14035\";i:130;s:4:\"4571\";i:131;s:4:\"3304\";i:132;s:4:\"1958\";i:133;s:5:\"10018\";i:134;s:4:\"3023\";i:135;s:4:\"3021\";i:136;s:4:\"5121\";i:137;s:4:\"2423\";i:138;s:4:\"7379\";i:139;s:5:\"11629\";i:140;s:5:\"11636\";i:141;s:4:\"3024\";i:142;s:4:\"7434\";i:143;s:4:\"5128\";i:144;s:4:\"3099\";i:145;s:4:\"9821\";i:146;s:4:\"3030\";i:147;s:4:\"2959\";i:148;s:4:\"3029\";i:149;s:4:\"4177\";i:150;s:4:\"7179\";i:151;s:4:\"6769\";i:152;s:5:\"11788\";i:153;s:5:\"14232\";i:154;s:4:\"2275\";i:155;s:4:\"6636\";i:156;s:4:\"8762\";i:157;s:4:\"5437\";i:158;s:4:\"3619\";i:159;s:4:\"4812\";i:160;s:4:\"4792\";i:161;s:4:\"4790\";i:162;s:4:\"4814\";i:163;s:4:\"4794\";i:164;s:4:\"4802\";i:165;s:4:\"4813\";i:166;s:4:\"4799\";i:167;s:4:\"2611\";i:168;s:4:\"4791\";i:169;s:4:\"4801\";i:170;s:4:\"3209\";i:171;s:4:\"9646\";i:172;s:4:\"3955\";i:173;s:4:\"6041\";i:174;s:4:\"3005\";i:175;s:4:\"6438\";i:176;s:5:\"11437\";i:177;s:4:\"7178\";i:178;s:4:\"3026\";i:179;s:4:\"7171\";i:180;s:4:\"3915\";i:181;s:4:\"3343\";i:182;s:4:\"1780\";i:183;s:4:\"3018\";i:184;s:4:\"2625\";i:185;s:4:\"1511\";i:186;s:4:\"3010\";i:187;s:4:\"8763\";i:188;s:4:\"3357\";i:189;s:4:\"3682\";i:190;s:4:\"3348\";i:191;s:4:\"2699\";i:192;s:5:\"11883\";i:193;s:4:\"3213\";i:194;s:5:\"10693\";i:195;s:4:\"3079\";i:196;s:4:\"3297\";i:197;s:4:\"3686\";i:198;s:4:\"1392\";i:199;s:4:\"7174\";i:200;s:4:\"7176\";i:201;s:4:\"7129\";i:202;s:4:\"1396\";i:203;s:5:\"12715\";i:204;s:4:\"3031\";i:205;s:4:\"3032\";i:206;s:4:\"8764\";i:207;s:5:\"11986\";i:208;s:4:\"6070\";i:209;s:4:\"1781\";i:210;s:4:\"3342\";i:211;s:4:\"3617\";i:212;s:4:\"6761\";i:213;s:4:\"3350\";i:214;s:4:\"3007\";i:215;s:4:\"5998\";i:216;s:4:\"9159\";i:217;s:4:\"2768\";i:218;s:4:\"3022\";i:219;s:4:\"3853\";i:220;s:4:\"3344\";i:221;s:4:\"4795\";i:222;s:4:\"8192\";i:223;s:4:\"1726\";i:224;s:4:\"1727\";i:225;s:5:\"13065\";i:226;s:4:\"3034\";i:227;s:4:\"7177\";i:228;s:4:\"7172\";i:229;s:4:\"3856\";i:230;s:5:\"11649\";i:231;s:4:\"8766\";i:232;s:4:\"3020\";i:233;s:4:\"1807\";i:234;s:4:\"3641\";i:235;s:4:\"7175\";}s:12:\"sql_ListStmt\";s:5227:\"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 (1391, 1392, 1393, 1394, 1395, 1396, 1397, 1400, 1477, 1502, 1503, 1506, 1511, 1726, 1727, 1738, 1743, 1768, 1770, 1779, 1780, 1781, 1807, 1809, 1825, 1829, 1839, 1841, 1958, 2020, 2275, 2322, 2356, 2423, 2424, 2467, 2501, 2611, 2612, 2625, 2627, 2655, 2696, 2699, 2707, 2733, 2744, 2747, 2758, 2768, 2925, 2928, 2959, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016, 3018, 3019, 3020, 3021, 3022, 3023, 3024, 3026, 3028, 3029, 3030, 3031, 3032, 3033, 3034, 3035, 3036, 3079, 3099, 3137, 3146, 3208, 3209, 3211, 3213, 3232, 3297, 3304, 3342, 3343, 3344, 3345, 3346, 3347, 3348, 3349, 3350, 3357, 3614, 3615, 3616, 3617, 3618, 3619, 3641, 3682, 3686, 3853, 3856, 3915, 3954, 3955, 4117, 4126, 4177, 4414, 4451, 4462, 4571, 4613, 4626, 4651, 4780, 4790, 4791, 4792, 4794, 4795, 4799, 4801, 4802, 4812, 4813, 4814, 4920, 4921, 4930, 5121, 5128, 5263, 5362, 5437, 5566, 5734, 5752, 5756, 5778, 5876, 5941, 5998, 6003, 6041, 6070, 6089, 6373, 6374, 6375, 6376, 6438, 6441, 6491, 6636, 6637, 6693, 6761, 6769, 6857, 6904, 7020, 7129, 7170, 7171, 7172, 7173, 7174, 7175, 7176, 7177, 7178, 7179, 7234, 7379, 7434, 7435, 7851, 8192, 8231, 8441, 8530, 8532, 8650, 8762, 8763, 8764, 8765, 8766, 9159, 9178, 9385, 9473, 9510, 9606, 9646, 9821, 9827, 9845, 10018, 10093, 10142, 10693, 10922, 11436, 11437, 11629, 11636, 11649, 11703, 11788, 11828, 11829, 11883, 11986, 12715, 12716, 12996, 13065, 14035, 14057, 14232, 15093, 15132)) 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:\"3019\";i:1;s:4:\"3006\";i:2;s:4:\"1394\";i:3;s:4:\"9827\";i:4;s:4:\"3954\";i:5;s:4:\"9385\";i:6;s:4:\"2707\";i:7;s:4:\"2020\";i:8;s:4:\"9178\";i:9;s:4:\"2696\";i:10;s:4:\"3033\";i:11;s:4:\"9606\";i:12;s:4:\"8650\";i:13;s:4:\"1779\";i:14;s:5:\"11829\";i:15;s:4:\"6693\";i:16;s:4:\"7170\";i:17;s:4:\"1477\";i:18;s:4:\"9845\";i:19;s:4:\"3614\";i:20;s:4:\"4126\";i:21;s:4:\"3011\";i:22;s:4:\"5778\";i:23;s:4:\"5566\";i:24;s:4:\"2655\";i:25;s:4:\"6374\";i:26;s:4:\"1841\";i:27;s:4:\"8765\";i:28;s:5:\"11828\";i:29;s:4:\"7851\";i:30;s:5:\"12996\";i:31;s:4:\"1825\";i:32;s:4:\"2627\";i:33;s:4:\"1829\";i:34;s:5:\"11703\";i:35;s:4:\"1397\";i:36;s:4:\"3616\";i:37;s:4:\"8441\";i:38;s:4:\"3232\";i:39;s:4:\"7435\";i:40;s:4:\"1391\";i:41;s:4:\"6089\";i:42;s:4:\"4414\";i:43;s:4:\"4651\";i:44;s:4:\"2501\";i:45;s:4:\"4920\";i:46;s:4:\"4921\";i:47;s:4:\"6373\";i:48;s:4:\"6441\";i:49;s:4:\"3015\";i:50;s:4:\"4780\";i:51;s:4:\"3345\";i:52;s:4:\"2356\";i:53;s:4:\"1393\";i:54;s:5:\"15132\";i:55;s:4:\"3014\";i:56;s:4:\"7020\";i:57;s:4:\"5752\";i:58;s:5:\"10093\";i:59;s:4:\"3035\";i:60;s:4:\"3347\";i:61;s:4:\"5876\";i:62;s:4:\"5734\";i:63;s:4:\"3008\";i:64;s:4:\"4930\";i:65;s:4:\"2925\";i:66;s:4:\"1743\";i:67;s:4:\"2928\";i:68;s:4:\"9510\";i:69;s:5:\"12716\";i:70;s:4:\"6637\";i:71;s:4:\"1768\";i:72;s:4:\"3146\";i:73;s:4:\"1503\";i:74;s:4:\"2467\";i:75;s:4:\"1839\";i:76;s:4:\"4462\";i:77;s:4:\"3618\";i:78;s:4:\"6491\";i:79;s:4:\"7234\";i:80;s:4:\"2733\";i:81;s:5:\"14057\";i:82;s:4:\"3009\";i:83;s:4:\"4613\";i:84;s:4:\"6003\";i:85;s:4:\"6375\";i:86;s:5:\"15093\";i:87;s:4:\"3036\";i:88;s:4:\"3016\";i:89;s:4:\"5362\";i:90;s:4:\"3349\";i:91;s:4:\"5756\";i:92;s:4:\"2322\";i:93;s:4:\"3346\";i:94;s:4:\"2747\";i:95;s:4:\"2744\";i:96;s:5:\"11436\";i:97;s:4:\"1809\";i:98;s:5:\"10922\";i:99;s:4:\"9473\";}s:13:\"sql_LastMulti\";s:65:\"action=list_LISTSOMERESOURCES_CORE&method=yearProcess&id=MjAwMQ==\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:21:\"Year:  2001\";}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:\"MjAwMQ==\";s:18:\"browse_PagingTotal\";i:236;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');