[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:185:{i:0;s:5:\"13152\";i:1;s:5:\"13173\";i:2;s:5:\"15911\";i:3;s:5:\"15584\";i:4;s:5:\"10037\";i:5;s:5:\"14333\";i:6;s:5:\"15779\";i:7;s:5:\"15796\";i:8;s:5:\"16096\";i:9;s:5:\"11072\";i:10;s:4:\"7211\";i:11;s:4:\"7207\";i:12;s:5:\"14830\";i:13;s:5:\"15778\";i:14;s:4:\"7194\";i:15;s:4:\"7209\";i:16;s:4:\"7210\";i:17;s:5:\"11701\";i:18;s:5:\"12031\";i:19;s:4:\"6058\";i:20;s:4:\"6057\";i:21;s:4:\"5294\";i:22;s:5:\"16001\";i:23;s:5:\"13792\";i:24;s:5:\"13791\";i:25;s:5:\"15754\";i:26;s:5:\"14158\";i:27;s:5:\"15581\";i:28;s:5:\"13157\";i:29;s:5:\"10035\";i:30;s:5:\"14718\";i:31;s:5:\"13172\";i:32;s:5:\"12850\";i:33;s:5:\"10834\";i:34;s:5:\"14157\";i:35;s:5:\"14721\";i:36;s:4:\"7205\";i:37;s:4:\"9807\";i:38;s:5:\"15539\";i:39;s:5:\"13168\";i:40;s:5:\"15265\";i:41;s:5:\"13170\";i:42;s:5:\"14139\";i:43;s:5:\"14421\";i:44;s:5:\"16269\";i:45;s:5:\"12736\";i:46;s:4:\"7572\";i:47;s:5:\"14835\";i:48;s:5:\"13161\";i:49;s:5:\"14834\";i:50;s:5:\"14647\";i:51;s:5:\"14162\";i:52;s:4:\"9282\";i:53;s:5:\"10038\";i:54;s:5:\"11286\";i:55;s:5:\"14552\";i:56;s:5:\"15503\";i:57;s:5:\"16095\";i:58;s:4:\"9808\";i:59;s:5:\"14143\";i:60;s:5:\"11899\";i:61;s:5:\"13053\";i:62;s:5:\"15795\";i:63;s:5:\"12927\";i:64;s:5:\"14833\";i:65;s:5:\"12165\";i:66;s:5:\"13169\";i:67;s:4:\"5295\";i:68;s:5:\"14099\";i:69;s:5:\"14943\";i:70;s:5:\"11360\";i:71;s:4:\"7204\";i:72;s:5:\"15782\";i:73;s:5:\"12603\";i:74;s:5:\"11246\";i:75;s:5:\"14156\";i:76;s:5:\"11149\";i:77;s:5:\"16307\";i:78;s:5:\"15785\";i:79;s:5:\"14832\";i:80;s:5:\"13398\";i:81;s:5:\"14397\";i:82;s:5:\"10033\";i:83;s:4:\"6165\";i:84;s:5:\"11700\";i:85;s:5:\"10034\";i:86;s:4:\"6027\";i:87;s:5:\"15673\";i:88;s:5:\"15585\";i:89;s:4:\"4318\";i:90;s:5:\"11486\";i:91;s:5:\"11494\";i:92;s:5:\"15367\";i:93;s:5:\"11356\";i:94;s:5:\"11248\";i:95;s:5:\"13171\";i:96;s:5:\"15457\";i:97;s:5:\"14382\";i:98;s:4:\"6049\";i:99;s:5:\"12928\";i:100;s:5:\"15930\";i:101;s:5:\"14843\";i:102;s:4:\"6031\";i:103;s:5:\"10174\";i:104;s:5:\"11534\";i:105;s:5:\"14161\";i:106;s:5:\"11361\";i:107;s:5:\"15587\";i:108;s:5:\"15586\";i:109;s:5:\"13167\";i:110;s:5:\"14836\";i:111;s:5:\"16285\";i:112;s:5:\"16283\";i:113;s:5:\"14854\";i:114;s:4:\"7208\";i:115;s:5:\"13166\";i:116;s:4:\"9281\";i:117;s:5:\"10835\";i:118;s:5:\"13163\";i:119;s:5:\"14936\";i:120;s:4:\"6051\";i:121;s:5:\"13162\";i:122;s:5:\"16239\";i:123;s:5:\"10027\";i:124;s:5:\"11400\";i:125;s:4:\"5128\";i:126;s:4:\"4730\";i:127;s:4:\"6042\";i:128;s:5:\"16240\";i:129;s:5:\"14720\";i:130;s:5:\"14840\";i:131;s:4:\"6030\";i:132;s:5:\"11454\";i:133;s:5:\"15781\";i:134;s:5:\"15786\";i:135;s:5:\"14160\";i:136;s:5:\"13153\";i:137;s:5:\"15362\";i:138;s:4:\"7202\";i:139;s:5:\"15784\";i:140;s:5:\"14142\";i:141;s:5:\"14415\";i:142;s:4:\"3917\";i:143;s:5:\"15366\";i:144;s:5:\"11493\";i:145;s:5:\"13165\";i:146;s:5:\"14719\";i:147;s:5:\"15783\";i:148;s:5:\"14309\";i:149;s:5:\"15510\";i:150;s:5:\"15363\";i:151;s:4:\"6145\";i:152;s:4:\"6048\";i:153;s:5:\"14972\";i:154;s:5:\"15877\";i:155;s:5:\"11943\";i:156;s:5:\"11064\";i:157;s:5:\"15797\";i:158;s:5:\"15364\";i:159;s:4:\"6044\";i:160;s:5:\"14934\";i:161;s:5:\"14842\";i:162;s:4:\"7611\";i:163;s:5:\"15530\";i:164;s:4:\"8178\";i:165;s:4:\"6043\";i:166;s:5:\"15583\";i:167;s:5:\"11358\";i:168;s:5:\"15582\";i:169;s:5:\"15780\";i:170;s:4:\"7203\";i:171;s:5:\"14942\";i:172;s:5:\"13164\";i:173;s:4:\"7206\";i:174;s:5:\"12817\";i:175;s:5:\"13390\";i:176;s:4:\"6357\";i:177;s:4:\"7212\";i:178;s:5:\"12456\";i:179;s:4:\"6216\";i:180;s:5:\"14951\";i:181;s:5:\"14100\";i:182;s:4:\"9116\";i:183;s:5:\"11359\";i:184;s:5:\"14937\";}s:12:\"sql_ListStmt\";s:5040:\"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 (3917, 4318, 4730, 5128, 5294, 5295, 6027, 6030, 6031, 6042, 6043, 6044, 6048, 6049, 6051, 6057, 6058, 6145, 6165, 6216, 6357, 7194, 7202, 7203, 7204, 7205, 7206, 7207, 7208, 7209, 7210, 7211, 7212, 7572, 7611, 8178, 9116, 9281, 9282, 9807, 9808, 10027, 10033, 10034, 10035, 10037, 10038, 10174, 10834, 10835, 11064, 11072, 11149, 11246, 11248, 11286, 11356, 11358, 11359, 11360, 11361, 11400, 11454, 11486, 11493, 11494, 11534, 11700, 11701, 11899, 11943, 12031, 12165, 12456, 12603, 12736, 12817, 12850, 12927, 12928, 13053, 13152, 13153, 13157, 13161, 13162, 13163, 13164, 13165, 13166, 13167, 13168, 13169, 13170, 13171, 13172, 13173, 13390, 13398, 13791, 13792, 14099, 14100, 14139, 14142, 14143, 14156, 14157, 14158, 14160, 14161, 14162, 14309, 14333, 14382, 14397, 14415, 14421, 14552, 14647, 14718, 14719, 14720, 14721, 14830, 14832, 14833, 14834, 14835, 14836, 14840, 14842, 14843, 14854, 14934, 14936, 14937, 14942, 14943, 14951, 14972, 15265, 15362, 15363, 15364, 15366, 15367, 15457, 15503, 15510, 15530, 15539, 15581, 15582, 15583, 15584, 15585, 15586, 15587, 15673, 15754, 15778, 15779, 15780, 15781, 15782, 15783, 15784, 15785, 15786, 15795, 15796, 15797, 15877, 15911, 15930, 16001, 16095, 16096, 16239, 16240, 16269, 16283, 16285, 16307)) 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:\"13152\";i:1;s:5:\"13173\";i:2;s:5:\"15911\";i:3;s:5:\"15584\";i:4;s:5:\"10037\";i:5;s:5:\"14333\";i:6;s:5:\"15779\";i:7;s:5:\"15796\";i:8;s:5:\"16096\";i:9;s:5:\"11072\";i:10;s:4:\"7211\";i:11;s:4:\"7207\";i:12;s:5:\"14830\";i:13;s:5:\"15778\";i:14;s:4:\"7194\";i:15;s:4:\"7209\";i:16;s:4:\"7210\";i:17;s:5:\"11701\";i:18;s:5:\"12031\";i:19;s:4:\"6058\";i:20;s:4:\"6057\";i:21;s:4:\"5294\";i:22;s:5:\"16001\";i:23;s:5:\"13792\";i:24;s:5:\"13791\";i:25;s:5:\"15754\";i:26;s:5:\"14158\";i:27;s:5:\"15581\";i:28;s:5:\"13157\";i:29;s:5:\"10035\";i:30;s:5:\"14718\";i:31;s:5:\"13172\";i:32;s:5:\"12850\";i:33;s:5:\"10834\";i:34;s:5:\"14157\";i:35;s:5:\"14721\";i:36;s:4:\"7205\";i:37;s:4:\"9807\";i:38;s:5:\"15539\";i:39;s:5:\"13168\";i:40;s:5:\"15265\";i:41;s:5:\"13170\";i:42;s:5:\"14139\";i:43;s:5:\"14421\";i:44;s:5:\"16269\";i:45;s:5:\"12736\";i:46;s:4:\"7572\";i:47;s:5:\"14835\";i:48;s:5:\"13161\";i:49;s:5:\"14834\";i:50;s:5:\"14647\";i:51;s:5:\"14162\";i:52;s:4:\"9282\";i:53;s:5:\"10038\";i:54;s:5:\"11286\";i:55;s:5:\"14552\";i:56;s:5:\"15503\";i:57;s:5:\"16095\";i:58;s:4:\"9808\";i:59;s:5:\"14143\";i:60;s:5:\"11899\";i:61;s:5:\"13053\";i:62;s:5:\"15795\";i:63;s:5:\"12927\";i:64;s:5:\"14833\";i:65;s:5:\"12165\";i:66;s:5:\"13169\";i:67;s:4:\"5295\";i:68;s:5:\"14099\";i:69;s:5:\"14943\";i:70;s:5:\"11360\";i:71;s:4:\"7204\";i:72;s:5:\"15782\";i:73;s:5:\"12603\";i:74;s:5:\"11246\";i:75;s:5:\"14156\";i:76;s:5:\"11149\";i:77;s:5:\"16307\";i:78;s:5:\"15785\";i:79;s:5:\"14832\";i:80;s:5:\"13398\";i:81;s:5:\"14397\";i:82;s:5:\"10033\";i:83;s:4:\"6165\";i:84;s:5:\"11700\";i:85;s:5:\"10034\";i:86;s:4:\"6027\";i:87;s:5:\"15673\";i:88;s:5:\"15585\";i:89;s:4:\"4318\";i:90;s:5:\"11486\";i:91;s:5:\"11494\";i:92;s:5:\"15367\";i:93;s:5:\"11356\";i:94;s:5:\"11248\";i:95;s:5:\"13171\";i:96;s:5:\"15457\";i:97;s:5:\"14382\";i:98;s:4:\"6049\";i:99;s:5:\"12928\";}s:13:\"sql_LastMulti\";s:65:\"action=list_LISTSOMERESOURCES_CORE&method=publisherProcess&id=477\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:57:\"Publisher:  Palgrave Macmillan(New York [etc.])\";}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:\"477\";s:18:\"browse_PagingTotal\";i:185;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');