[SQL Error] INSERT INTO temp_storage (`tempstorageId`, `tempstorageData`) VALUES ('040ecdc6-281c-426e-9686-81dfce55738d', '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:277:{i:0;s:5:\"10478\";i:1;s:4:\"4632\";i:2;s:5:\"15559\";i:3;s:4:\"9302\";i:4;s:4:\"8994\";i:5;s:5:\"12983\";i:6;s:4:\"7734\";i:7;s:4:\"8954\";i:8;s:4:\"5052\";i:9;s:5:\"10397\";i:10;s:5:\"14104\";i:11;s:5:\"14362\";i:12;s:4:\"6428\";i:13;s:4:\"2010\";i:14;s:5:\"12701\";i:15;s:5:\"12193\";i:16;s:4:\"8263\";i:17;s:4:\"8527\";i:18;s:4:\"8773\";i:19;s:4:\"8145\";i:20;s:4:\"9582\";i:21;s:5:\"12464\";i:22;s:4:\"5566\";i:23;s:5:\"10566\";i:24;s:5:\"11503\";i:25;s:4:\"5652\";i:26;s:5:\"13965\";i:27;s:5:\"14010\";i:28;s:4:\"8938\";i:29;s:4:\"8167\";i:30;s:4:\"6947\";i:31;s:5:\"11054\";i:32;s:5:\"15241\";i:33;s:5:\"15926\";i:34;s:5:\"16156\";i:35;s:5:\"11532\";i:36;s:5:\"12958\";i:37;s:5:\"11004\";i:38;s:4:\"8995\";i:39;s:5:\"10605\";i:40;s:5:\"12939\";i:41;s:4:\"7084\";i:42;s:4:\"7346\";i:43;s:5:\"12677\";i:44;s:4:\"4727\";i:45;s:4:\"9123\";i:46;s:4:\"9124\";i:47;s:5:\"13843\";i:48;s:4:\"7475\";i:49;s:4:\"9708\";i:50;s:5:\"14094\";i:51;s:4:\"8879\";i:52;s:5:\"15316\";i:53;s:5:\"10468\";i:54;s:4:\"5339\";i:55;s:4:\"5870\";i:56;s:5:\"11645\";i:57;s:5:\"10469\";i:58;s:5:\"13807\";i:59;s:4:\"9131\";i:60;s:4:\"9130\";i:61;s:4:\"9132\";i:62;s:4:\"9295\";i:63;s:4:\"4990\";i:64;s:5:\"14390\";i:65;s:4:\"6830\";i:66;s:5:\"15144\";i:67;s:5:\"14697\";i:68;s:5:\"10694\";i:69;s:4:\"5327\";i:70;s:5:\"16369\";i:71;s:4:\"7199\";i:72;s:5:\"10874\";i:73;s:5:\"14054\";i:74;s:5:\"12164\";i:75;s:5:\"13436\";i:76;s:5:\"10852\";i:77;s:5:\"15295\";i:78;s:5:\"10120\";i:79;s:4:\"5539\";i:80;s:4:\"6275\";i:81;s:4:\"9263\";i:82;s:5:\"15456\";i:83;s:4:\"6141\";i:84;s:4:\"9157\";i:85;s:4:\"9720\";i:86;s:4:\"5653\";i:87;s:5:\"13925\";i:88;s:5:\"14666\";i:89;s:4:\"2504\";i:90;s:5:\"10313\";i:91;s:5:\"10127\";i:92;s:4:\"1756\";i:93;s:5:\"11331\";i:94;s:5:\"12475\";i:95;s:5:\"10019\";i:96;s:4:\"9341\";i:97;s:5:\"12707\";i:98;s:5:\"10958\";i:99;s:4:\"9144\";i:100;s:5:\"10271\";i:101;s:5:\"14767\";i:102;s:5:\"11850\";i:103;s:5:\"11549\";i:104;s:4:\"6617\";i:105;s:5:\"15878\";i:106;s:5:\"12452\";i:107;s:4:\"4776\";i:108;s:4:\"4332\";i:109;s:4:\"5201\";i:110;s:4:\"8609\";i:111;s:4:\"5698\";i:112;s:5:\"12313\";i:113;s:4:\"7099\";i:114;s:5:\"10122\";i:115;s:5:\"15146\";i:116;s:4:\"7189\";i:117;s:4:\"5325\";i:118;s:5:\"10386\";i:119;s:4:\"9653\";i:120;s:4:\"9340\";i:121;s:5:\"10734\";i:122;s:5:\"15142\";i:123;s:5:\"13808\";i:124;s:5:\"10922\";i:125;s:5:\"11845\";i:126;s:5:\"15908\";i:127;s:4:\"2046\";i:128;s:5:\"10644\";i:129;s:4:\"8883\";i:130;s:5:\"15289\";i:131;s:5:\"11508\";i:132;s:5:\"12455\";i:133;s:4:\"9630\";i:134;s:5:\"12297\";i:135;s:4:\"7568\";i:136;s:5:\"10656\";i:137;s:4:\"5524\";i:138;s:4:\"8885\";i:139;s:4:\"8884\";i:140;s:4:\"8886\";i:141;s:4:\"8887\";i:142;s:4:\"8888\";i:143;s:4:\"7073\";i:144;s:5:\"10675\";i:145;s:5:\"10248\";i:146;s:4:\"2440\";i:147;s:5:\"11023\";i:148;s:5:\"15804\";i:149;s:5:\"12691\";i:150;s:4:\"5226\";i:151;s:4:\"9380\";i:152;s:5:\"12070\";i:153;s:4:\"9192\";i:154;s:4:\"5476\";i:155;s:5:\"12215\";i:156;s:5:\"10999\";i:157;s:5:\"14394\";i:158;s:4:\"5646\";i:159;s:4:\"6458\";i:160;s:5:\"10608\";i:161;s:4:\"5547\";i:162;s:5:\"16261\";i:163;s:5:\"13970\";i:164;s:5:\"13969\";i:165;s:5:\"13968\";i:166;s:4:\"7148\";i:167;s:4:\"5609\";i:168;s:4:\"7290\";i:169;s:4:\"6023\";i:170;s:5:\"13967\";i:171;s:5:\"13828\";i:172;s:5:\"14633\";i:173;s:4:\"5410\";i:174;s:4:\"5411\";i:175;s:4:\"5453\";i:176;s:4:\"5454\";i:177;s:4:\"5455\";i:178;s:4:\"5342\";i:179;s:4:\"5305\";i:180;s:4:\"5324\";i:181;s:4:\"5344\";i:182;s:4:\"5340\";i:183;s:4:\"5458\";i:184;s:4:\"5459\";i:185;s:4:\"5460\";i:186;s:4:\"5457\";i:187;s:4:\"5328\";i:188;s:4:\"5407\";i:189;s:4:\"5409\";i:190;s:4:\"5408\";i:191;s:4:\"5456\";i:192;s:4:\"5326\";i:193;s:4:\"5380\";i:194;s:4:\"5343\";i:195;s:4:\"9644\";i:196;s:4:\"9403\";i:197;s:5:\"12334\";i:198;s:5:\"14034\";i:199;s:5:\"11485\";i:200;s:4:\"6945\";i:201;s:4:\"9400\";i:202;s:4:\"8077\";i:203;s:4:\"8491\";i:204;s:4:\"8490\";i:205;s:4:\"8488\";i:206;s:4:\"8489\";i:207;s:4:\"8492\";i:208;s:4:\"1723\";i:209;s:4:\"1724\";i:210;s:4:\"2757\";i:211;s:5:\"10864\";i:212;s:4:\"9496\";i:213;s:4:\"2527\";i:214;s:5:\"14166\";i:215;s:4:\"2492\";i:216;s:4:\"9436\";i:217;s:4:\"8991\";i:218;s:5:\"16310\";i:219;s:4:\"4777\";i:220;s:4:\"3899\";i:221;s:5:\"16031\";i:222;s:4:\"1630\";i:223;s:4:\"2285\";i:224;s:4:\"5406\";i:225;s:5:\"13961\";i:226;s:5:\"14341\";i:227;s:5:\"10011\";i:228;s:5:\"11418\";i:229;s:5:\"14931\";i:230;s:5:\"11684\";i:231;s:5:\"13999\";i:232;s:4:\"9914\";i:233;s:4:\"9913\";i:234;s:4:\"2491\";i:235;s:5:\"14407\";i:236;s:5:\"10751\";i:237;s:4:\"8882\";i:238;s:4:\"9176\";i:239;s:5:\"12282\";i:240;s:5:\"12986\";i:241;s:5:\"14580\";i:242;s:4:\"1612\";i:243;s:5:\"12168\";i:244;s:5:\"14186\";i:245;s:5:\"14424\";i:246;s:4:\"4994\";i:247;s:5:\"16043\";i:248;s:5:\"16328\";i:249;s:5:\"11986\";i:250;s:4:\"8185\";i:251;s:4:\"9291\";i:252;s:4:\"9292\";i:253;s:4:\"7345\";i:254;s:5:\"12771\";i:255;s:5:\"12772\";i:256;s:4:\"1781\";i:257;s:4:\"5683\";i:258;s:4:\"7257\";i:259;s:4:\"7258\";i:260;s:5:\"16155\";i:261;s:5:\"10454\";i:262;s:4:\"6156\";i:263;s:4:\"6157\";i:264;s:4:\"5733\";i:265;s:4:\"9272\";i:266;s:4:\"6024\";i:267;s:4:\"7954\";i:268;s:5:\"14701\";i:269;s:5:\"10470\";i:270;s:5:\"14046\";i:271;s:5:\"16366\";i:272;s:5:\"11484\";i:273;s:4:\"9294\";i:274;s:4:\"9293\";i:275;s:4:\"6460\";i:276;s:4:\"6632\";}s:12:\"sql_ListStmt\";s:5573:\"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 (1630, 2491, 5201, 5226, 5305, 5324, 5325, 5326, 5327, 5328, 5339, 5340, 5342, 5343, 5344, 5380, 5407, 5408, 5409, 5411, 5453, 5454, 5455, 5456, 5457, 5458, 5459, 5460, 5539, 5547, 5646, 5653, 5683, 5698, 6023, 6024, 6141, 6156, 6157, 6275, 6458, 6460, 6617, 6632, 6830, 6945, 6947, 7073, 7084, 7099, 7189, 7199, 7257, 7258, 7290, 7345, 7346, 7568, 7734, 7954, 8077, 5524, 8167, 8185, 4994, 8490, 8491, 8489, 8488, 1724, 1723, 8492, 5609, 1781, 2046, 8527, 2527, 2285, 2440, 4776, 2757, 8879, 8882, 8883, 8885, 8884, 8886, 8888, 8887, 8938, 8954, 8991, 8994, 8995, 2492, 9124, 9123, 9131, 9132, 9130, 9144, 9157, 9176, 1612, 9263, 9272, 1756, 9292, 9291, 9293, 9294, 9295, 9302, 9341, 8773, 5652, 9380, 4332, 9400, 9403, 9436, 9496, 9630, 9653, 5406, 9708, 9720, 5052, 9582, 9644, 9914, 9913, 10120, 10122, 10127, 10019, 5410, 10248, 10271, 10313, 10397, 10454, 10468, 10469, 10470, 10566, 5476, 10605, 10608, 10644, 10656, 10675, 10694, 10751, 10852, 10874, 10922, 10958, 4727, 10999, 11004, 11023, 11054, 8145, 10011, 11418, 4777, 3899, 11484, 11485, 11503, 11508, 11549, 5566, 11645, 11684, 11845, 11850, 11986, 12070, 12164, 12168, 12193, 12215, 12297, 12313, 12334, 2010, 12452, 12464, 10734, 10386, 12677, 12691, 12701, 12707, 6428, 12282, 12771, 12772, 8263, 10478, 12475, 2504, 12939, 12958, 12983, 5870, 7475, 11532, 13436, 12986, 13808, 13828, 10864, 13843, 13925, 8609, 13961, 13965, 13968, 13969, 13970, 13967, 13999, 14010, 14034, 14046, 11331, 14054, 14104, 14166, 14186, 7148, 14362, 14390, 14394, 14407, 12455, 14424, 13807, 14580, 9340, 14633, 14666, 14697, 14701, 14767, 9192, 14931, 14341, 15142, 15144, 15146, 15241, 5733, 15289, 15295, 15316, 4632, 15456, 15559, 15804, 15878, 15908, 15926, 16031, 16043, 16156, 16155, 4990, 16261, 14094, 16310, 16328, 16369, 16366)) 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:\"10478\";i:1;s:4:\"4632\";i:2;s:5:\"15559\";i:3;s:4:\"9302\";i:4;s:4:\"8994\";i:5;s:5:\"12983\";i:6;s:4:\"7734\";i:7;s:4:\"8954\";i:8;s:4:\"5052\";i:9;s:5:\"10397\";i:10;s:5:\"14104\";i:11;s:5:\"14362\";i:12;s:4:\"6428\";i:13;s:4:\"2010\";i:14;s:5:\"12701\";i:15;s:5:\"12193\";i:16;s:4:\"8263\";i:17;s:4:\"8527\";i:18;s:4:\"8773\";i:19;s:4:\"8145\";i:20;s:4:\"9582\";i:21;s:5:\"12464\";i:22;s:4:\"5566\";i:23;s:5:\"10566\";i:24;s:5:\"11503\";i:25;s:4:\"5652\";i:26;s:5:\"13965\";i:27;s:5:\"14010\";i:28;s:4:\"8938\";i:29;s:4:\"8167\";i:30;s:4:\"6947\";i:31;s:5:\"11054\";i:32;s:5:\"15241\";i:33;s:5:\"15926\";i:34;s:5:\"16156\";i:35;s:5:\"11532\";i:36;s:5:\"12958\";i:37;s:5:\"11004\";i:38;s:4:\"8995\";i:39;s:5:\"10605\";i:40;s:5:\"12939\";i:41;s:4:\"7084\";i:42;s:4:\"7346\";i:43;s:5:\"12677\";i:44;s:4:\"4727\";i:45;s:4:\"9123\";i:46;s:4:\"9124\";i:47;s:5:\"13843\";i:48;s:4:\"7475\";i:49;s:4:\"9708\";i:50;s:5:\"14094\";i:51;s:4:\"8879\";i:52;s:5:\"15316\";i:53;s:5:\"10468\";i:54;s:4:\"5339\";i:55;s:4:\"5870\";i:56;s:5:\"11645\";i:57;s:5:\"10469\";i:58;s:5:\"13807\";i:59;s:4:\"9131\";i:60;s:4:\"9130\";i:61;s:4:\"9132\";i:62;s:4:\"9295\";i:63;s:4:\"4990\";i:64;s:5:\"14390\";i:65;s:4:\"6830\";i:66;s:5:\"15144\";i:67;s:5:\"14697\";i:68;s:5:\"10694\";i:69;s:4:\"5327\";i:70;s:5:\"16369\";i:71;s:4:\"7199\";i:72;s:5:\"10874\";i:73;s:5:\"14054\";i:74;s:5:\"12164\";i:75;s:5:\"13436\";i:76;s:5:\"10852\";i:77;s:5:\"15295\";i:78;s:5:\"10120\";i:79;s:4:\"5539\";i:80;s:4:\"6275\";i:81;s:4:\"9263\";i:82;s:5:\"15456\";i:83;s:4:\"6141\";i:84;s:4:\"9157\";i:85;s:4:\"9720\";i:86;s:4:\"5653\";i:87;s:5:\"13925\";i:88;s:5:\"14666\";i:89;s:4:\"2504\";i:90;s:5:\"10313\";i:91;s:5:\"10127\";i:92;s:4:\"1756\";i:93;s:5:\"11331\";i:94;s:5:\"12475\";i:95;s:5:\"10019\";i:96;s:4:\"9341\";i:97;s:5:\"12707\";i:98;s:5:\"10958\";i:99;s:4:\"9144\";}s:13:\"sql_LastMulti\";s:72:\"action=list_LISTSOMERESOURCES_CORE&method=keywordProcess&id=2356&catId=1\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:36:\"Keyword:  Illustrated text\";}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:4:\"2356\";s:12:\"browse_CatId\";s:1:\"1\";s:18:\"browse_PagingTotal\";i:277;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');