[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:340:{i:0;s:4:\"9262\";i:1;s:4:\"9524\";i:2;s:5:\"16064\";i:3;s:4:\"8994\";i:4;s:5:\"12983\";i:5;s:5:\"11343\";i:6;s:4:\"2502\";i:7;s:4:\"8626\";i:8;s:4:\"8627\";i:9;s:4:\"3890\";i:10;s:4:\"9060\";i:11;s:4:\"9061\";i:12;s:4:\"6472\";i:13;s:5:\"12945\";i:14;s:4:\"5651\";i:15;s:4:\"5800\";i:16;s:4:\"7877\";i:17;s:4:\"3168\";i:18;s:5:\"11521\";i:19;s:4:\"1816\";i:20;s:4:\"2325\";i:21;s:4:\"8324\";i:22;s:4:\"8839\";i:23;s:4:\"3565\";i:24;s:5:\"12460\";i:25;s:4:\"6333\";i:26;s:5:\"12194\";i:27;s:4:\"4942\";i:28;s:5:\"10498\";i:29;s:4:\"6693\";i:30;s:4:\"1512\";i:31;s:4:\"9582\";i:32;s:5:\"13803\";i:33;s:5:\"10566\";i:34;s:4:\"4056\";i:35;s:5:\"11123\";i:36;s:5:\"15876\";i:37;s:4:\"9434\";i:38;s:5:\"14010\";i:39;s:4:\"6437\";i:40;s:5:\"14224\";i:41;s:4:\"1657\";i:42;s:4:\"6947\";i:43;s:5:\"15241\";i:44;s:5:\"16156\";i:45;s:4:\"7512\";i:46;s:4:\"5330\";i:47;s:4:\"7084\";i:48;s:4:\"3849\";i:49;s:5:\"12677\";i:50;s:4:\"2493\";i:51;s:4:\"8203\";i:52;s:4:\"4374\";i:53;s:5:\"13843\";i:54;s:5:\"10535\";i:55;s:4:\"9594\";i:56;s:5:\"14094\";i:57;s:4:\"9637\";i:58;s:4:\"5053\";i:59;s:4:\"8879\";i:60;s:5:\"15316\";i:61;s:4:\"8667\";i:62;s:4:\"4153\";i:63;s:5:\"14056\";i:64;s:4:\"2548\";i:65;s:5:\"14575\";i:66;s:5:\"11162\";i:67;s:4:\"7053\";i:68;s:4:\"9206\";i:69;s:4:\"7262\";i:70;s:5:\"11202\";i:71;s:5:\"14722\";i:72;s:5:\"14054\";i:73;s:5:\"15570\";i:74;s:4:\"2445\";i:75;s:4:\"1674\";i:76;s:5:\"15295\";i:77;s:4:\"2477\";i:78;s:4:\"1501\";i:79;s:4:\"3067\";i:80;s:4:\"3077\";i:81;s:4:\"5539\";i:82;s:4:\"6275\";i:83;s:4:\"2307\";i:84;s:5:\"14165\";i:85;s:4:\"2532\";i:86;s:4:\"9703\";i:87;s:4:\"2480\";i:88;s:4:\"9720\";i:89;s:5:\"15132\";i:90;s:5:\"11664\";i:91;s:4:\"6951\";i:92;s:4:\"8322\";i:93;s:4:\"9182\";i:94;s:4:\"4818\";i:95;s:4:\"1542\";i:96;s:4:\"3951\";i:97;s:4:\"1673\";i:98;s:4:\"2506\";i:99;s:5:\"10127\";i:100;s:4:\"2466\";i:101;s:4:\"1750\";i:102;s:5:\"11331\";i:103;s:5:\"13214\";i:104;s:4:\"4294\";i:105;s:4:\"2533\";i:106;s:5:\"12707\";i:107;s:4:\"9719\";i:108;s:4:\"8189\";i:109;s:4:\"9709\";i:110;s:4:\"9715\";i:111;s:4:\"7924\";i:112;s:5:\"12740\";i:113;s:5:\"16209\";i:114;s:5:\"15878\";i:115;s:4:\"2536\";i:116;s:4:\"2043\";i:117;s:4:\"4486\";i:118;s:4:\"4026\";i:119;s:4:\"8939\";i:120;s:5:\"15688\";i:121;s:4:\"7234\";i:122;s:4:\"9053\";i:123;s:5:\"14057\";i:124;s:5:\"14060\";i:125;s:4:\"1725\";i:126;s:4:\"2273\";i:127;s:4:\"1772\";i:128;s:5:\"10122\";i:129;s:5:\"13811\";i:130;s:4:\"1641\";i:131;s:4:\"9149\";i:132;s:4:\"4373\";i:133;s:5:\"10734\";i:134;s:4:\"2322\";i:135;s:5:\"10080\";i:136;s:5:\"10079\";i:137;s:5:\"10078\";i:138;s:4:\"6382\";i:139;s:5:\"10578\";i:140;s:5:\"13808\";i:141;s:4:\"3155\";i:142;s:5:\"10314\";i:143;s:5:\"14425\";i:144;s:4:\"1722\";i:145;s:4:\"7939\";i:146;s:4:\"6103\";i:147;s:4:\"6102\";i:148;s:4:\"9339\";i:149;s:4:\"9759\";i:150;s:5:\"10833\";i:151;s:4:\"5822\";i:152;s:4:\"4250\";i:153;s:4:\"4254\";i:154;s:4:\"4255\";i:155;s:4:\"8363\";i:156;s:5:\"15463\";i:157;s:4:\"6817\";i:158;s:5:\"12963\";i:159;s:4:\"2239\";i:160;s:4:\"5629\";i:161;s:4:\"5099\";i:162;s:5:\"15805\";i:163;s:5:\"10656\";i:164;s:5:\"11916\";i:165;s:5:\"11915\";i:166;s:5:\"10337\";i:167;s:4:\"6332\";i:168;s:4:\"4964\";i:169;s:5:\"10851\";i:170;s:5:\"14028\";i:171;s:4:\"1770\";i:172;s:5:\"10248\";i:173;s:4:\"2440\";i:174;s:4:\"9761\";i:175;s:5:\"14630\";i:176;s:4:\"9350\";i:177;s:4:\"2531\";i:178;s:4:\"4005\";i:179;s:4:\"8833\";i:180;s:5:\"16274\";i:181;s:4:\"3892\";i:182;s:4:\"3829\";i:183;s:4:\"8691\";i:184;s:5:\"10312\";i:185;s:4:\"5476\";i:186;s:4:\"2528\";i:187;s:4:\"8857\";i:188;s:4:\"8858\";i:189;s:4:\"8859\";i:190;s:5:\"11917\";i:191;s:4:\"9550\";i:192;s:5:\"11627\";i:193;s:4:\"6709\";i:194;s:5:\"13905\";i:195;s:5:\"10261\";i:196;s:4:\"5609\";i:197;s:4:\"7290\";i:198;s:5:\"14354\";i:199;s:5:\"11918\";i:200;s:4:\"8413\";i:201;s:4:\"9995\";i:202;s:5:\"13413\";i:203;s:4:\"7469\";i:204;s:4:\"7468\";i:205;s:4:\"3194\";i:206;s:4:\"7473\";i:207;s:4:\"3605\";i:208;s:4:\"2530\";i:209;s:4:\"2276\";i:210;s:4:\"7669\";i:211;s:4:\"7670\";i:212;s:4:\"7671\";i:213;s:4:\"9435\";i:214;s:4:\"9545\";i:215;s:4:\"7661\";i:216;s:4:\"6945\";i:217;s:4:\"6777\";i:218;s:4:\"1672\";i:219;s:4:\"6454\";i:220;s:4:\"7355\";i:221;s:4:\"7201\";i:222;s:4:\"9935\";i:223;s:4:\"9822\";i:224;s:4:\"2476\";i:225;s:4:\"9707\";i:226;s:4:\"9646\";i:227;s:4:\"2527\";i:228;s:5:\"14166\";i:229;s:4:\"2492\";i:230;s:4:\"1696\";i:231;s:4:\"9436\";i:232;s:4:\"1780\";i:233;s:4:\"1786\";i:234;s:4:\"8517\";i:235;s:4:\"9427\";i:236;s:4:\"3606\";i:237;s:5:\"10388\";i:238;s:5:\"15112\";i:239;s:4:\"1604\";i:240;s:5:\"11344\";i:241;s:4:\"7592\";i:242;s:4:\"5826\";i:243;s:4:\"1511\";i:244;s:5:\"14059\";i:245;s:4:\"2465\";i:246;s:4:\"6574\";i:247;s:5:\"12887\";i:248;s:4:\"8611\";i:249;s:5:\"13243\";i:250;s:4:\"4915\";i:251;s:5:\"10889\";i:252;s:5:\"13994\";i:253;s:4:\"5329\";i:254;s:5:\"10011\";i:255;s:5:\"11418\";i:256;s:5:\"14931\";i:257;s:4:\"4233\";i:258;s:4:\"4245\";i:259;s:4:\"4236\";i:260;s:4:\"4238\";i:261;s:4:\"4246\";i:262;s:4:\"4237\";i:263;s:4:\"4263\";i:264;s:4:\"4259\";i:265;s:4:\"4256\";i:266;s:4:\"4257\";i:267;s:4:\"4247\";i:268;s:4:\"9913\";i:269;s:5:\"13289\";i:270;s:4:\"3759\";i:271;s:4:\"9538\";i:272;s:4:\"2491\";i:273;s:5:\"13135\";i:274;s:5:\"16300\";i:275;s:4:\"7736\";i:276;s:4:\"2534\";i:277;s:4:\"8882\";i:278;s:5:\"10564\";i:279;s:5:\"11506\";i:280;s:5:\"12282\";i:281;s:5:\"13159\";i:282;s:4:\"6123\";i:283;s:4:\"3901\";i:284;s:5:\"10496\";i:285;s:4:\"3687\";i:286;s:4:\"3689\";i:287;s:4:\"9834\";i:288;s:4:\"5608\";i:289;s:4:\"8201\";i:290;s:5:\"12168\";i:291;s:4:\"3677\";i:292;s:4:\"6750\";i:293;s:5:\"11206\";i:294;s:4:\"1629\";i:295;s:4:\"4174\";i:296;s:4:\"4994\";i:297;s:4:\"8920\";i:298;s:4:\"9197\";i:299;s:5:\"14024\";i:300;s:4:\"2538\";i:301;s:4:\"5403\";i:302;s:4:\"6791\";i:303;s:4:\"2499\";i:304;s:4:\"1509\";i:305;s:5:\"16071\";i:306;s:4:\"7345\";i:307;s:5:\"12771\";i:308;s:5:\"12772\";i:309;s:4:\"9171\";i:310;s:5:\"12938\";i:311;s:4:\"2535\";i:312;s:5:\"10454\";i:313;s:5:\"14875\";i:314;s:4:\"4992\";i:315;s:4:\"9714\";i:316;s:4:\"6448\";i:317;s:4:\"8168\";i:318;s:4:\"6560\";i:319;s:4:\"5000\";i:320;s:5:\"16065\";i:321;s:4:\"9431\";i:322;s:4:\"9695\";i:323;s:4:\"9696\";i:324;s:4:\"1782\";i:325;s:4:\"5404\";i:326;s:4:\"9993\";i:327;s:4:\"7954\";i:328;s:4:\"7402\";i:329;s:4:\"9236\";i:330;s:5:\"12000\";i:331;s:5:\"10082\";i:332;s:5:\"10081\";i:333;s:5:\"14046\";i:334;s:5:\"13995\";i:335;s:5:\"10495\";i:336;s:5:\"10055\";i:337;s:4:\"7404\";i:338;s:5:\"13752\";i:339;s:4:\"5063\";}s:12:\"sql_ListStmt\";s:5937:\"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 (1511, 1641, 1672, 1722, 1725, 1816, 2043, 2276, 2307, 2325, 2465, 2491, 2493, 2502, 2506, 2531, 2533, 2535, 3077, 3565, 3605, 3606, 3677, 3687, 3689, 3759, 3829, 3849, 3892, 3901, 3951, 4005, 4026, 4056, 4174, 4233, 4236, 4237, 4238, 4245, 4246, 4247, 4250, 4254, 4255, 4256, 4257, 4259, 4263, 4294, 4373, 4374, 4486, 4818, 4915, 4942, 4964, 4992, 5000, 5053, 5099, 5329, 5539, 5629, 5651, 5800, 5822, 5826, 6103, 6275, 6332, 6333, 6382, 6448, 6454, 6472, 6560, 6574, 6693, 6709, 6750, 6777, 6791, 6817, 6945, 6947, 6951, 7053, 7084, 7201, 7234, 7262, 7290, 7345, 7355, 7402, 7404, 7468, 7469, 7473, 7512, 7592, 7669, 7670, 7671, 7736, 7877, 7924, 7954, 8168, 8189, 8201, 8203, 8322, 8324, 2239, 8363, 5403, 5063, 1512, 1509, 1629, 1657, 1674, 1673, 1696, 4994, 1750, 1772, 1780, 1786, 8517, 1770, 5609, 2273, 2322, 2527, 2440, 2499, 2528, 2536, 5330, 8611, 8626, 8627, 8667, 2466, 2445, 2534, 8691, 8833, 8839, 8857, 8858, 8859, 6123, 8879, 8882, 8920, 8939, 8994, 5608, 9053, 9061, 9060, 2492, 9149, 9182, 2530, 9197, 9236, 7939, 9262, 9339, 9350, 2532, 9427, 9431, 9434, 9435, 9436, 9524, 9545, 2538, 9637, 9695, 9703, 2480, 9171, 2476, 2477, 2548, 9707, 9709, 9714, 9715, 9720, 9761, 9759, 9696, 9646, 9582, 9834, 9913, 9935, 9993, 9995, 5404, 10079, 10080, 10081, 10082, 10122, 10127, 10248, 10261, 6437, 10312, 10314, 3155, 10337, 10388, 9822, 4153, 9206, 10454, 10495, 10496, 10498, 10564, 10566, 5476, 10656, 9594, 10535, 1501, 10578, 11123, 11162, 10851, 1542, 11202, 10889, 11343, 11344, 10011, 11418, 11506, 11627, 11664, 8413, 10078, 11915, 11916, 11917, 9550, 11918, 12000, 12168, 12194, 11521, 7661, 3067, 12460, 10734, 12677, 12707, 12740, 12282, 12771, 12772, 12887, 12938, 12945, 12963, 12983, 13135, 13159, 13243, 13289, 9538, 3194, 1782, 13413, 13214, 13803, 13808, 13811, 13843, 13994, 13995, 14010, 14024, 14028, 1604, 14046, 11331, 3890, 14054, 14056, 14057, 14059, 14060, 10833, 14165, 14166, 14224, 14354, 14425, 9719, 14630, 10055, 14875, 14931, 14722, 15112, 13752, 15132, 15241, 15295, 15316, 15570, 15688, 13905, 15805, 15876, 15878, 3168, 6102, 15463, 14575, 16065, 16071, 11206, 16064, 16156, 16209, 16274, 16300, 14094)) 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:\"8413\";i:1;s:4:\"9995\";i:2;s:5:\"13413\";i:3;s:4:\"7469\";i:4;s:4:\"7468\";i:5;s:4:\"3194\";i:6;s:4:\"7473\";i:7;s:4:\"3605\";i:8;s:4:\"2530\";i:9;s:4:\"2276\";i:10;s:4:\"7669\";i:11;s:4:\"7670\";i:12;s:4:\"7671\";i:13;s:4:\"9435\";i:14;s:4:\"9545\";i:15;s:4:\"7661\";i:16;s:4:\"6945\";i:17;s:4:\"6777\";i:18;s:4:\"1672\";i:19;s:4:\"6454\";i:20;s:4:\"7355\";i:21;s:4:\"7201\";i:22;s:4:\"9935\";i:23;s:4:\"9822\";i:24;s:4:\"2476\";i:25;s:4:\"9707\";i:26;s:4:\"9646\";i:27;s:4:\"2527\";i:28;s:5:\"14166\";i:29;s:4:\"2492\";i:30;s:4:\"1696\";i:31;s:4:\"9436\";i:32;s:4:\"1780\";i:33;s:4:\"1786\";i:34;s:4:\"8517\";i:35;s:4:\"9427\";i:36;s:4:\"3606\";i:37;s:5:\"10388\";i:38;s:5:\"15112\";i:39;s:4:\"1604\";i:40;s:5:\"11344\";i:41;s:4:\"7592\";i:42;s:4:\"5826\";i:43;s:4:\"1511\";i:44;s:5:\"14059\";i:45;s:4:\"2465\";i:46;s:4:\"6574\";i:47;s:5:\"12887\";i:48;s:4:\"8611\";i:49;s:5:\"13243\";i:50;s:4:\"4915\";i:51;s:5:\"10889\";i:52;s:5:\"13994\";i:53;s:4:\"5329\";i:54;s:5:\"10011\";i:55;s:5:\"11418\";i:56;s:5:\"14931\";i:57;s:4:\"4233\";i:58;s:4:\"4245\";i:59;s:4:\"4236\";i:60;s:4:\"4238\";i:61;s:4:\"4246\";i:62;s:4:\"4237\";i:63;s:4:\"4263\";i:64;s:4:\"4259\";i:65;s:4:\"4256\";i:66;s:4:\"4257\";i:67;s:4:\"4247\";i:68;s:4:\"9913\";i:69;s:5:\"13289\";i:70;s:4:\"3759\";i:71;s:4:\"9538\";i:72;s:4:\"2491\";i:73;s:5:\"13135\";i:74;s:5:\"16300\";i:75;s:4:\"7736\";i:76;s:4:\"2534\";i:77;s:4:\"8882\";i:78;s:5:\"10564\";i:79;s:5:\"11506\";i:80;s:5:\"12282\";i:81;s:5:\"13159\";i:82;s:4:\"6123\";i:83;s:4:\"3901\";i:84;s:5:\"10496\";i:85;s:4:\"3687\";i:86;s:4:\"3689\";i:87;s:4:\"9834\";i:88;s:4:\"5608\";i:89;s:4:\"8201\";i:90;s:5:\"12168\";i:91;s:4:\"3677\";i:92;s:4:\"6750\";i:93;s:5:\"11206\";i:94;s:4:\"1629\";i:95;s:4:\"4174\";i:96;s:4:\"4994\";i:97;s:4:\"8920\";i:98;s:4:\"9197\";i:99;s:5:\"14024\";}s:13:\"sql_LastMulti\";s:63:\"action=list_LISTSOMERESOURCES_CORE&method=keywordProcess&id=826\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:29:\"Keyword:  Biography\";}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:\"826\";s:18:\"browse_PagingTotal\";i:340;s:18:\"browse_PagingStart\";i:200;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');