[SQL Error] INSERT INTO temp_storage (`tempstorageId`, `tempstorageData`) VALUES ('8e7df945-8971-4290-bc2e-045af56961e1', 'a:19:{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:260:{i:0;s:5:\"14102\";i:1;s:4:\"4598\";i:2;s:4:\"6221\";i:3;s:4:\"3420\";i:4;s:5:\"10585\";i:5;s:5:\"13385\";i:6;s:4:\"4664\";i:7;s:5:\"10397\";i:8;s:5:\"16020\";i:9;s:5:\"10037\";i:10;s:5:\"12071\";i:11;s:5:\"11212\";i:12;s:4:\"5557\";i:13;s:4:\"4494\";i:14;s:5:\"15374\";i:15;s:4:\"8967\";i:16;s:5:\"11829\";i:17;s:4:\"4190\";i:18;s:4:\"3272\";i:19;s:4:\"3571\";i:20;s:5:\"16013\";i:21;s:5:\"11706\";i:22;s:5:\"10256\";i:23;s:4:\"3414\";i:24;s:4:\"4060\";i:25;s:5:\"12662\";i:26;s:4:\"1415\";i:27;s:4:\"5773\";i:28;s:5:\"13383\";i:29;s:4:\"9098\";i:30;s:5:\"14266\";i:31;s:4:\"5435\";i:32;s:4:\"2627\";i:33;s:4:\"2836\";i:34;s:4:\"9089\";i:35;s:5:\"10990\";i:36;s:4:\"9094\";i:37;s:5:\"13653\";i:38;s:4:\"8984\";i:39;s:4:\"9090\";i:40;s:4:\"4599\";i:41;s:5:\"15144\";i:42;s:4:\"9556\";i:43;s:5:\"14373\";i:44;s:5:\"11692\";i:45;s:4:\"3495\";i:46;s:4:\"7644\";i:47;s:5:\"12017\";i:48;s:4:\"4605\";i:49;s:4:\"2942\";i:50;s:4:\"9640\";i:51;s:4:\"4602\";i:52;s:4:\"4519\";i:53;s:4:\"9088\";i:54;s:5:\"12126\";i:55;s:5:\"14834\";i:56;s:4:\"8749\";i:57;s:5:\"13991\";i:58;s:4:\"9470\";i:59;s:5:\"10565\";i:60;s:5:\"14193\";i:61;s:5:\"14026\";i:62;s:4:\"1566\";i:63;s:4:\"4492\";i:64;s:5:\"14103\";i:65;s:4:\"4543\";i:66;s:4:\"8160\";i:67;s:4:\"9152\";i:68;s:5:\"15132\";i:69;s:4:\"6204\";i:70;s:5:\"15756\";i:71;s:5:\"10501\";i:72;s:4:\"3133\";i:73;s:5:\"11822\";i:74;s:4:\"4930\";i:75;s:4:\"2925\";i:76;s:4:\"8514\";i:77;s:4:\"3949\";i:78;s:5:\"11650\";i:79;s:5:\"14767\";i:80;s:5:\"15134\";i:81;s:4:\"7394\";i:82;s:4:\"8946\";i:83;s:4:\"6770\";i:84;s:5:\"15135\";i:85;s:4:\"9091\";i:86;s:4:\"4479\";i:87;s:4:\"9104\";i:88;s:5:\"15141\";i:89;s:4:\"7632\";i:90;s:4:\"8777\";i:91;s:5:\"16289\";i:92;s:4:\"8243\";i:93;s:4:\"7489\";i:94;s:4:\"8510\";i:95;s:4:\"6532\";i:96;s:5:\"13770\";i:97;s:5:\"12802\";i:98;s:5:\"10491\";i:99;s:4:\"9760\";i:100;s:5:\"15142\";i:101;s:5:\"11913\";i:102;s:4:\"8221\";i:103;s:5:\"13808\";i:104;s:4:\"3408\";i:105;s:4:\"4624\";i:106;s:5:\"13381\";i:107;s:4:\"6618\";i:108;s:4:\"2441\";i:109;s:4:\"9103\";i:110;s:5:\"14343\";i:111;s:5:\"11705\";i:112;s:4:\"2131\";i:113;s:4:\"9654\";i:114;s:4:\"8269\";i:115;s:5:\"15289\";i:116;s:5:\"11508\";i:117;s:5:\"13000\";i:118;s:4:\"4534\";i:119;s:4:\"5662\";i:120;s:5:\"13384\";i:121;s:4:\"7395\";i:122;s:4:\"1450\";i:123;s:4:\"3101\";i:124;s:4:\"3180\";i:125;s:4:\"4121\";i:126;s:5:\"13774\";i:127;s:5:\"16022\";i:128;s:4:\"4188\";i:129;s:4:\"3488\";i:130;s:4:\"2245\";i:131;s:4:\"6376\";i:132;s:5:\"14487\";i:133;s:4:\"9092\";i:134;s:4:\"8161\";i:135;s:5:\"10506\";i:136;s:4:\"9634\";i:137;s:4:\"3246\";i:138;s:5:\"15136\";i:139;s:4:\"5445\";i:140;s:4:\"6619\";i:141;s:4:\"9105\";i:142;s:4:\"5807\";i:143;s:5:\"10537\";i:144;s:4:\"9503\";i:145;s:5:\"15692\";i:146;s:5:\"11693\";i:147;s:4:\"4909\";i:148;s:4:\"7859\";i:149;s:4:\"8262\";i:150;s:4:\"5890\";i:151;s:5:\"11498\";i:152;s:5:\"14394\";i:153;s:5:\"11553\";i:154;s:5:\"11929\";i:155;s:4:\"4138\";i:156;s:5:\"11621\";i:157;s:5:\"14151\";i:158;s:4:\"7983\";i:159;s:5:\"11694\";i:160;s:5:\"13905\";i:161;s:5:\"13382\";i:162;s:4:\"2257\";i:163;s:5:\"11912\";i:164;s:4:\"8778\";i:165;s:4:\"6752\";i:166;s:4:\"9093\";i:167;s:5:\"10953\";i:168;s:4:\"9502\";i:169;s:5:\"12519\";i:170;s:4:\"9821\";i:171;s:5:\"12210\";i:172;s:4:\"9097\";i:173;s:5:\"10533\";i:174;s:4:\"3179\";i:175;s:4:\"2416\";i:176;s:5:\"12078\";i:177;s:5:\"10959\";i:178;s:4:\"9096\";i:179;s:4:\"4498\";i:180;s:4:\"4531\";i:181;s:4:\"9195\";i:182;s:4:\"4137\";i:183;s:4:\"3256\";i:184;s:4:\"3181\";i:185;s:5:\"15634\";i:186;s:5:\"10210\";i:187;s:4:\"9659\";i:188;s:4:\"9095\";i:189;s:4:\"9212\";i:190;s:4:\"4139\";i:191;s:4:\"8989\";i:192;s:5:\"14446\";i:193;s:4:\"4238\";i:194;s:4:\"6241\";i:195;s:5:\"12964\";i:196;s:4:\"4938\";i:197;s:4:\"8948\";i:198;s:5:\"13899\";i:199;s:5:\"11082\";i:200;s:5:\"15143\";i:201;s:5:\"11925\";i:202;s:4:\"6998\";i:203;s:4:\"7305\";i:204;s:5:\"11064\";i:205;s:5:\"10208\";i:206;s:5:\"11065\";i:207;s:5:\"13762\";i:208;s:4:\"1985\";i:209;s:4:\"4597\";i:210;s:4:\"4600\";i:211;s:4:\"4129\";i:212;s:5:\"13758\";i:213;s:4:\"6871\";i:214;s:4:\"4601\";i:215;s:5:\"10779\";i:216;s:4:\"3247\";i:217;s:4:\"3490\";i:218;s:4:\"7518\";i:219;s:4:\"8898\";i:220;s:5:\"16021\";i:221;s:5:\"14646\";i:222;s:5:\"11841\";i:223;s:5:\"11117\";i:224;s:4:\"9051\";i:225;s:4:\"6260\";i:226;s:4:\"3236\";i:227;s:4:\"4143\";i:228;s:4:\"9102\";i:229;s:5:\"13898\";i:230;s:4:\"9491\";i:231;s:4:\"8078\";i:232;s:4:\"7994\";i:233;s:5:\"12153\";i:234;s:5:\"15887\";i:235;s:4:\"7206\";i:236;s:4:\"4141\";i:237;s:4:\"2843\";i:238;s:5:\"14192\";i:239;s:5:\"13652\";i:240;s:5:\"13768\";i:241;s:5:\"14106\";i:242;s:4:\"4475\";i:243;s:4:\"4142\";i:244;s:4:\"3390\";i:245;s:5:\"11462\";i:246;s:4:\"9255\";i:247;s:4:\"4604\";i:248;s:5:\"12154\";i:249;s:5:\"11099\";i:250;s:4:\"6013\";i:251;s:4:\"6120\";i:252;s:4:\"3530\";i:253;s:5:\"13234\";i:254;s:5:\"11585\";i:255;s:4:\"3580\";i:256;s:4:\"5935\";i:257;s:4:\"5967\";i:258;s:5:\"12768\";i:259;s:5:\"12767\";}s:12:\"sql_ListStmt\";s:5454:\"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 (1450, 1985, 2131, 2416, 2441, 2627, 2925, 2942, 3133, 3179, 3180, 3181, 3256, 3272, 3390, 3420, 3488, 3490, 3495, 3530, 3580, 3949, 4060, 4121, 4129, 4137, 4138, 4139, 4141, 4143, 4188, 4190, 4238, 4475, 4479, 4492, 4494, 4498, 4531, 4534, 4543, 4664, 4930, 4938, 5435, 5445, 5662, 5773, 5807, 5890, 5935, 5967, 6013, 6204, 6221, 6241, 6260, 6376, 6532, 6618, 6619, 6752, 6871, 7206, 7305, 7394, 7395, 7489, 7518, 7632, 7859, 7994, 8078, 8160, 8161, 1566, 8221, 8243, 8262, 8269, 2245, 2257, 2843, 4519, 3571, 3414, 8510, 8514, 8778, 8946, 8948, 8984, 9051, 9088, 9090, 9089, 8777, 9091, 9092, 9093, 9094, 9095, 9096, 9097, 9098, 9102, 9103, 9104, 9105, 9152, 9195, 7983, 9255, 9470, 4605, 4602, 4599, 4600, 4597, 4601, 4604, 2836, 9491, 9502, 8967, 9556, 9503, 9634, 9640, 6120, 9654, 9659, 9760, 9821, 10037, 10256, 10397, 6998, 10208, 10210, 10491, 8898, 10501, 4142, 10506, 10533, 8989, 10537, 10565, 10585, 3236, 10779, 10990, 11064, 11065, 11099, 11117, 11212, 7644, 10959, 10953, 11508, 11553, 11585, 11650, 11692, 11693, 11694, 11705, 11706, 11822, 11829, 11841, 4909, 11912, 11925, 11929, 12017, 12071, 12078, 11462, 12126, 11082, 12154, 12210, 3246, 3247, 12519, 3101, 12662, 12767, 12768, 12802, 12964, 13000, 13234, 13383, 13382, 13381, 13384, 13385, 13652, 13808, 13898, 8749, 13899, 14026, 13991, 5557, 14103, 12153, 14151, 11621, 14266, 14343, 14373, 14394, 14446, 14106, 14646, 14767, 14834, 13774, 13758, 13770, 15132, 15134, 15136, 15135, 13653, 15141, 15142, 15143, 15144, 14487, 13768, 15289, 15374, 13762, 9212, 15692, 15756, 13905, 11913, 15887, 14192, 14193, 11498, 14102, 16013, 6770, 3408, 4624, 16020, 16022, 16021, 4598, 16289, 1415, 15634)) 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:\"14102\";i:1;s:4:\"4598\";i:2;s:4:\"6221\";i:3;s:4:\"3420\";i:4;s:5:\"10585\";i:5;s:5:\"13385\";i:6;s:4:\"4664\";i:7;s:5:\"10397\";i:8;s:5:\"16020\";i:9;s:5:\"10037\";i:10;s:5:\"12071\";i:11;s:5:\"11212\";i:12;s:4:\"5557\";i:13;s:4:\"4494\";i:14;s:5:\"15374\";i:15;s:4:\"8967\";i:16;s:5:\"11829\";i:17;s:4:\"4190\";i:18;s:4:\"3272\";i:19;s:4:\"3571\";i:20;s:5:\"16013\";i:21;s:5:\"11706\";i:22;s:5:\"10256\";i:23;s:4:\"3414\";i:24;s:4:\"4060\";i:25;s:5:\"12662\";i:26;s:4:\"1415\";i:27;s:4:\"5773\";i:28;s:5:\"13383\";i:29;s:4:\"9098\";i:30;s:5:\"14266\";i:31;s:4:\"5435\";i:32;s:4:\"2627\";i:33;s:4:\"2836\";i:34;s:4:\"9089\";i:35;s:5:\"10990\";i:36;s:4:\"9094\";i:37;s:5:\"13653\";i:38;s:4:\"8984\";i:39;s:4:\"9090\";i:40;s:4:\"4599\";i:41;s:5:\"15144\";i:42;s:4:\"9556\";i:43;s:5:\"14373\";i:44;s:5:\"11692\";i:45;s:4:\"3495\";i:46;s:4:\"7644\";i:47;s:5:\"12017\";i:48;s:4:\"4605\";i:49;s:4:\"2942\";i:50;s:4:\"9640\";i:51;s:4:\"4602\";i:52;s:4:\"4519\";i:53;s:4:\"9088\";i:54;s:5:\"12126\";i:55;s:5:\"14834\";i:56;s:4:\"8749\";i:57;s:5:\"13991\";i:58;s:4:\"9470\";i:59;s:5:\"10565\";i:60;s:5:\"14193\";i:61;s:5:\"14026\";i:62;s:4:\"1566\";i:63;s:4:\"4492\";i:64;s:5:\"14103\";i:65;s:4:\"4543\";i:66;s:4:\"8160\";i:67;s:4:\"9152\";i:68;s:5:\"15132\";i:69;s:4:\"6204\";i:70;s:5:\"15756\";i:71;s:5:\"10501\";i:72;s:4:\"3133\";i:73;s:5:\"11822\";i:74;s:4:\"4930\";i:75;s:4:\"2925\";i:76;s:4:\"8514\";i:77;s:4:\"3949\";i:78;s:5:\"11650\";i:79;s:5:\"14767\";i:80;s:5:\"15134\";i:81;s:4:\"7394\";i:82;s:4:\"8946\";i:83;s:4:\"6770\";i:84;s:5:\"15135\";i:85;s:4:\"9091\";i:86;s:4:\"4479\";i:87;s:4:\"9104\";i:88;s:5:\"15141\";i:89;s:4:\"7632\";i:90;s:4:\"8777\";i:91;s:5:\"16289\";i:92;s:4:\"8243\";i:93;s:4:\"7489\";i:94;s:4:\"8510\";i:95;s:4:\"6532\";i:96;s:5:\"13770\";i:97;s:5:\"12802\";i:98;s:5:\"10491\";i:99;s:4:\"9760\";}s:13:\"sql_LastMulti\";s:71:\"action=list_LISTSOMERESOURCES_CORE&method=keywordProcess&id=729&catId=1\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:30:\"Keyword:  Caricature\";}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:\"729\";s:12:\"browse_CatId\";s:1:\"1\";s:18:\"browse_PagingTotal\";i:260;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');