[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:18:\"list_SomeResources\";s:9:\"publisher\";s:12:\"sql_ListType\";s:6:\"browse\";s:10:\"sql_AllIds\";a:328:{i:0;s:4:\"9351\";i:1;s:4:\"4756\";i:2;s:4:\"4762\";i:3;s:4:\"8294\";i:4;s:5:\"13499\";i:5;s:5:\"11130\";i:6;s:4:\"4166\";i:7;s:4:\"7504\";i:8;s:4:\"4163\";i:9;s:4:\"9040\";i:10;s:5:\"12340\";i:11;s:5:\"10898\";i:12;s:4:\"4155\";i:13;s:5:\"12338\";i:14;s:4:\"4749\";i:15;s:4:\"4750\";i:16;s:4:\"1521\";i:17;s:4:\"7615\";i:18;s:5:\"11541\";i:19;s:5:\"11123\";i:20;s:4:\"4760\";i:21;s:4:\"9546\";i:22;s:4:\"1522\";i:23;s:4:\"7102\";i:24;s:4:\"7245\";i:25;s:5:\"12244\";i:26;s:4:\"8295\";i:27;s:5:\"11226\";i:28;s:4:\"8866\";i:29;s:4:\"9352\";i:30;s:4:\"7079\";i:31;s:4:\"8870\";i:32;s:5:\"13507\";i:33;s:5:\"11237\";i:34;s:4:\"7622\";i:35;s:4:\"7501\";i:36;s:4:\"6035\";i:37;s:4:\"8594\";i:38;s:4:\"8596\";i:39;s:4:\"8592\";i:40;s:4:\"6470\";i:41;s:4:\"8593\";i:42;s:4:\"8591\";i:43;s:4:\"8597\";i:44;s:4:\"8595\";i:45;s:4:\"8599\";i:46;s:4:\"7077\";i:47;s:4:\"8600\";i:48;s:4:\"8598\";i:49;s:5:\"13502\";i:50;s:5:\"10868\";i:51;s:4:\"7104\";i:52;s:4:\"7046\";i:53;s:5:\"11240\";i:54;s:5:\"11128\";i:55;s:5:\"13504\";i:56;s:5:\"10466\";i:57;s:4:\"6874\";i:58;s:4:\"4165\";i:59;s:4:\"4164\";i:60;s:4:\"4171\";i:61;s:4:\"7497\";i:62;s:4:\"4510\";i:63;s:4:\"8871\";i:64;s:5:\"10997\";i:65;s:4:\"7010\";i:66;s:4:\"8832\";i:67;s:5:\"10367\";i:68;s:4:\"9686\";i:69;s:5:\"11129\";i:70;s:5:\"11127\";i:71;s:4:\"8297\";i:72;s:4:\"8281\";i:73;s:5:\"10398\";i:74;s:4:\"4167\";i:75;s:4:\"7113\";i:76;s:4:\"4160\";i:77;s:4:\"6938\";i:78;s:4:\"4170\";i:79;s:4:\"4154\";i:80;s:4:\"4168\";i:81;s:4:\"4507\";i:82;s:4:\"4513\";i:83;s:4:\"8286\";i:84;s:4:\"7344\";i:85;s:4:\"4754\";i:86;s:5:\"11287\";i:87;s:4:\"5681\";i:88;s:4:\"4118\";i:89;s:4:\"7584\";i:90;s:4:\"8869\";i:91;s:4:\"4512\";i:92;s:4:\"9353\";i:93;s:4:\"8298\";i:94;s:5:\"11241\";i:95;s:5:\"11227\";i:96;s:5:\"10148\";i:97;s:5:\"11236\";i:98;s:4:\"9042\";i:99;s:4:\"9039\";i:100;s:4:\"4718\";i:101;s:4:\"7619\";i:102;s:5:\"10071\";i:103;s:4:\"4721\";i:104;s:5:\"12647\";i:105;s:4:\"4722\";i:106;s:4:\"7499\";i:107;s:4:\"7082\";i:108;s:4:\"5639\";i:109;s:5:\"11244\";i:110;s:5:\"12103\";i:111;s:5:\"10884\";i:112;s:4:\"6459\";i:113;s:5:\"11239\";i:114;s:4:\"9809\";i:115;s:4:\"9179\";i:116;s:5:\"10836\";i:117;s:4:\"4503\";i:118;s:4:\"5636\";i:119;s:4:\"5147\";i:120;s:4:\"5645\";i:121;s:4:\"4740\";i:122;s:4:\"2680\";i:123;s:4:\"7246\";i:124;s:4:\"9043\";i:125;s:4:\"4172\";i:126;s:5:\"10686\";i:127;s:4:\"4501\";i:128;s:4:\"4765\";i:129;s:4:\"4724\";i:130;s:5:\"12339\";i:131;s:4:\"4720\";i:132;s:5:\"14021\";i:133;s:4:\"5643\";i:134;s:4:\"4175\";i:135;s:4:\"9041\";i:136;s:4:\"7616\";i:137;s:4:\"7969\";i:138;s:4:\"7242\";i:139;s:4:\"7500\";i:140;s:4:\"9300\";i:141;s:4:\"4739\";i:142;s:4:\"7614\";i:143;s:4:\"4758\";i:144;s:4:\"7056\";i:145;s:5:\"11124\";i:146;s:4:\"7248\";i:147;s:4:\"7078\";i:148;s:4:\"8296\";i:149;s:4:\"2679\";i:150;s:4:\"1947\";i:151;s:4:\"9301\";i:152;s:4:\"4761\";i:153;s:4:\"2681\";i:154;s:4:\"7117\";i:155;s:5:\"10833\";i:156;s:5:\"11229\";i:157;s:4:\"8287\";i:158;s:4:\"7115\";i:159;s:4:\"6873\";i:160;s:5:\"12342\";i:161;s:4:\"5678\";i:162;s:4:\"4748\";i:163;s:4:\"4742\";i:164;s:5:\"12344\";i:165;s:4:\"6344\";i:166;s:4:\"7114\";i:167;s:4:\"8288\";i:168;s:4:\"7617\";i:169;s:4:\"8284\";i:170;s:5:\"13501\";i:171;s:4:\"7498\";i:172;s:5:\"11235\";i:173;s:4:\"9045\";i:174;s:5:\"13496\";i:175;s:4:\"4753\";i:176;s:5:\"10675\";i:177;s:4:\"4741\";i:178;s:4:\"4173\";i:179;s:5:\"10072\";i:180;s:4:\"9354\";i:181;s:4:\"9044\";i:182;s:4:\"8283\";i:183;s:4:\"1444\";i:184;s:4:\"4755\";i:185;s:4:\"9689\";i:186;s:4:\"7100\";i:187;s:4:\"8864\";i:188;s:4:\"4746\";i:189;s:4:\"4156\";i:190;s:4:\"7623\";i:191;s:4:\"4508\";i:192;s:4:\"4199\";i:193;s:5:\"10998\";i:194;s:4:\"7612\";i:195;s:4:\"4763\";i:196;s:4:\"4161\";i:197;s:4:\"7620\";i:198;s:4:\"4500\";i:199;s:4:\"8867\";i:200;s:5:\"11125\";i:201;s:4:\"4768\";i:202;s:4:\"7103\";i:203;s:4:\"5640\";i:204;s:5:\"10819\";i:205;s:5:\"10295\";i:206;s:4:\"4504\";i:207;s:4:\"4198\";i:208;s:4:\"3604\";i:209;s:4:\"9046\";i:210;s:4:\"8282\";i:211;s:4:\"9997\";i:212;s:4:\"1436\";i:213;s:4:\"3605\";i:214;s:4:\"7624\";i:215;s:4:\"8289\";i:216;s:4:\"4158\";i:217;s:4:\"4745\";i:218;s:4:\"6875\";i:219;s:4:\"4757\";i:220;s:4:\"4162\";i:221;s:5:\"11126\";i:222;s:4:\"7621\";i:223;s:4:\"7247\";i:224;s:4:\"9692\";i:225;s:4:\"5682\";i:226;s:4:\"7116\";i:227;s:4:\"7243\";i:228;s:4:\"9631\";i:229;s:4:\"8868\";i:230;s:5:\"12341\";i:231;s:4:\"4719\";i:232;s:4:\"4751\";i:233;s:4:\"5644\";i:234;s:4:\"9688\";i:235;s:4:\"3606\";i:236;s:5:\"10073\";i:237;s:5:\"15074\";i:238;s:4:\"4159\";i:239;s:4:\"1511\";i:240;s:4:\"1390\";i:241;s:4:\"9047\";i:242;s:4:\"4844\";i:243;s:4:\"5146\";i:244;s:4:\"9121\";i:245;s:4:\"7582\";i:246;s:5:\"10714\";i:247;s:4:\"7244\";i:248;s:5:\"13503\";i:249;s:4:\"4752\";i:250;s:5:\"11238\";i:251;s:4:\"5148\";i:252;s:5:\"10657\";i:253;s:4:\"4725\";i:254;s:4:\"3612\";i:255;s:4:\"4397\";i:256;s:4:\"2377\";i:257;s:5:\"11540\";i:258;s:4:\"7613\";i:259;s:4:\"4506\";i:260;s:4:\"4514\";i:261;s:4:\"9693\";i:262;s:4:\"9303\";i:263;s:4:\"5149\";i:264;s:4:\"2840\";i:265;s:4:\"4174\";i:266;s:5:\"12646\";i:267;s:4:\"9287\";i:268;s:4:\"8291\";i:269;s:4:\"8293\";i:270;s:5:\"11243\";i:271;s:4:\"7590\";i:272;s:4:\"7080\";i:273;s:5:\"10097\";i:274;s:5:\"13508\";i:275;s:4:\"7972\";i:276;s:4:\"4759\";i:277;s:4:\"9309\";i:278;s:5:\"13800\";i:279;s:4:\"4511\";i:280;s:4:\"4505\";i:281;s:5:\"13500\";i:282;s:4:\"9038\";i:283;s:4:\"5641\";i:284;s:5:\"10685\";i:285;s:5:\"11669\";i:286;s:4:\"8290\";i:287;s:4:\"4169\";i:288;s:4:\"6566\";i:289;s:4:\"2333\";i:290;s:5:\"12361\";i:291;s:4:\"7106\";i:292;s:4:\"8285\";i:293;s:4:\"3607\";i:294;s:4:\"4723\";i:295;s:4:\"5642\";i:296;s:5:\"14799\";i:297;s:4:\"7118\";i:298;s:4:\"4764\";i:299;s:4:\"9687\";i:300;s:4:\"7502\";i:301;s:4:\"4509\";i:302;s:4:\"4157\";i:303;s:4:\"2775\";i:304;s:4:\"7449\";i:305;s:4:\"4054\";i:306;s:4:\"3370\";i:307;s:4:\"4660\";i:308;s:4:\"7249\";i:309;s:4:\"7618\";i:310;s:4:\"4502\";i:311;s:5:\"10098\";i:312;s:5:\"11230\";i:313;s:4:\"4766\";i:314;s:5:\"11242\";i:315;s:4:\"5680\";i:316;s:5:\"14692\";i:317;s:4:\"5638\";i:318;s:4:\"4499\";i:319;s:4:\"7251\";i:320;s:4:\"7250\";i:321;s:4:\"5637\";i:322;s:4:\"7448\";i:323;s:5:\"11180\";i:324;s:4:\"9180\";i:325;s:5:\"11181\";i:326;s:4:\"4747\";i:327;s:4:\"7985\";}s:12:\"sql_ListStmt\";s:5830:\"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 (1390, 1436, 1444, 1511, 1521, 1522, 1947, 2333, 2377, 2679, 2680, 2681, 2775, 2840, 3370, 3604, 3605, 3606, 3607, 3612, 4054, 4118, 4154, 4155, 4156, 4157, 4158, 4159, 4160, 4161, 4162, 4163, 4164, 4165, 4166, 4167, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4198, 4199, 4397, 4499, 4500, 4501, 4502, 4503, 4504, 4505, 4506, 4507, 4508, 4509, 4510, 4511, 4512, 4513, 4514, 4660, 4718, 4719, 4720, 4721, 4722, 4723, 4724, 4725, 4739, 4740, 4741, 4742, 4745, 4746, 4747, 4748, 4749, 4750, 4751, 4752, 4753, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4762, 4763, 4764, 4765, 4766, 4768, 4844, 5146, 5147, 5148, 5149, 5636, 5637, 5638, 5639, 5640, 5641, 5642, 5643, 5644, 5645, 5678, 5680, 5681, 5682, 6035, 6344, 6459, 6470, 6566, 6873, 6874, 6875, 6938, 7010, 7046, 7056, 7077, 7078, 7079, 7080, 7082, 7100, 7102, 7103, 7104, 7106, 7113, 7114, 7115, 7116, 7117, 7118, 7242, 7243, 7244, 7245, 7246, 7247, 7248, 7249, 7250, 7251, 7344, 7448, 7449, 7497, 7498, 7499, 7500, 7501, 7502, 7504, 7582, 7584, 7590, 7612, 7613, 7614, 7615, 7616, 7617, 7618, 7619, 7620, 7621, 7622, 7623, 7624, 7969, 7972, 7985, 8281, 8282, 8283, 8284, 8285, 8286, 8287, 8288, 8289, 8290, 8291, 8293, 8294, 8295, 8296, 8297, 8298, 8591, 8592, 8593, 8594, 8595, 8596, 8597, 8598, 8599, 8600, 8832, 8864, 8866, 8867, 8868, 8869, 8870, 8871, 9038, 9039, 9040, 9041, 9042, 9043, 9044, 9045, 9046, 9047, 9121, 9179, 9180, 9287, 9300, 9301, 9303, 9309, 9351, 9352, 9353, 9354, 9546, 9631, 9686, 9687, 9688, 9689, 9692, 9693, 9809, 9997, 10071, 10072, 10073, 10097, 10098, 10148, 10295, 10367, 10398, 10466, 10657, 10675, 10685, 10686, 10714, 10819, 10833, 10836, 10868, 10884, 10898, 10997, 10998, 11123, 11124, 11125, 11126, 11127, 11128, 11129, 11130, 11180, 11181, 11226, 11227, 11229, 11230, 11235, 11236, 11237, 11238, 11239, 11240, 11241, 11242, 11243, 11244, 11287, 11540, 11541, 11669, 12103, 12244, 12338, 12339, 12340, 12341, 12342, 12344, 12361, 12646, 12647, 13496, 13499, 13500, 13501, 13502, 13503, 13504, 13507, 13508, 13800, 14021, 14692, 14799, 15074)) 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:\"9351\";i:1;s:4:\"4756\";i:2;s:4:\"4762\";i:3;s:4:\"8294\";i:4;s:5:\"13499\";i:5;s:5:\"11130\";i:6;s:4:\"4166\";i:7;s:4:\"7504\";i:8;s:4:\"4163\";i:9;s:4:\"9040\";i:10;s:5:\"12340\";i:11;s:5:\"10898\";i:12;s:4:\"4155\";i:13;s:5:\"12338\";i:14;s:4:\"4749\";i:15;s:4:\"4750\";i:16;s:4:\"1521\";i:17;s:4:\"7615\";i:18;s:5:\"11541\";i:19;s:5:\"11123\";i:20;s:4:\"4760\";i:21;s:4:\"9546\";i:22;s:4:\"1522\";i:23;s:4:\"7102\";i:24;s:4:\"7245\";i:25;s:5:\"12244\";i:26;s:4:\"8295\";i:27;s:5:\"11226\";i:28;s:4:\"8866\";i:29;s:4:\"9352\";i:30;s:4:\"7079\";i:31;s:4:\"8870\";i:32;s:5:\"13507\";i:33;s:5:\"11237\";i:34;s:4:\"7622\";i:35;s:4:\"7501\";i:36;s:4:\"6035\";i:37;s:4:\"8594\";i:38;s:4:\"8596\";i:39;s:4:\"8592\";i:40;s:4:\"6470\";i:41;s:4:\"8593\";i:42;s:4:\"8591\";i:43;s:4:\"8597\";i:44;s:4:\"8595\";i:45;s:4:\"8599\";i:46;s:4:\"7077\";i:47;s:4:\"8600\";i:48;s:4:\"8598\";i:49;s:5:\"13502\";i:50;s:5:\"10868\";i:51;s:4:\"7104\";i:52;s:4:\"7046\";i:53;s:5:\"11240\";i:54;s:5:\"11128\";i:55;s:5:\"13504\";i:56;s:5:\"10466\";i:57;s:4:\"6874\";i:58;s:4:\"4165\";i:59;s:4:\"4164\";i:60;s:4:\"4171\";i:61;s:4:\"7497\";i:62;s:4:\"4510\";i:63;s:4:\"8871\";i:64;s:5:\"10997\";i:65;s:4:\"7010\";i:66;s:4:\"8832\";i:67;s:5:\"10367\";i:68;s:4:\"9686\";i:69;s:5:\"11129\";i:70;s:5:\"11127\";i:71;s:4:\"8297\";i:72;s:4:\"8281\";i:73;s:5:\"10398\";i:74;s:4:\"4167\";i:75;s:4:\"7113\";i:76;s:4:\"4160\";i:77;s:4:\"6938\";i:78;s:4:\"4170\";i:79;s:4:\"4154\";i:80;s:4:\"4168\";i:81;s:4:\"4507\";i:82;s:4:\"4513\";i:83;s:4:\"8286\";i:84;s:4:\"7344\";i:85;s:4:\"4754\";i:86;s:5:\"11287\";i:87;s:4:\"5681\";i:88;s:4:\"4118\";i:89;s:4:\"7584\";i:90;s:4:\"8869\";i:91;s:4:\"4512\";i:92;s:4:\"9353\";i:93;s:4:\"8298\";i:94;s:5:\"11241\";i:95;s:5:\"11227\";i:96;s:5:\"10148\";i:97;s:5:\"11236\";i:98;s:4:\"9042\";i:99;s:4:\"9039\";}s:13:\"sql_LastMulti\";s:65:\"action=list_LISTSOMERESOURCES_CORE&method=publisherProcess&id=376\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:50:\"Publisher:  McFarland(Jefferson, London)\";}s:16:\"browse_LastOrder\";s:7:\"creator\";s:18:\"browse_LastAscDesc\";s:4:\" ASC\";s:13:\"browse_Method\";s:16:\"publisherProcess\";s:9:\"browse_Id\";s:3:\"376\";s:18:\"browse_PagingTotal\";i:328;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');