[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:132:{i:0;s:4:\"7795\";i:1;s:4:\"6082\";i:2;s:4:\"9464\";i:3;s:4:\"9505\";i:4;s:4:\"9905\";i:5;s:4:\"7805\";i:6;s:4:\"7362\";i:7;s:4:\"9506\";i:8;s:4:\"4826\";i:9;s:4:\"7802\";i:10;s:5:\"13668\";i:11;s:4:\"4587\";i:12;s:4:\"2591\";i:13;s:4:\"7626\";i:14;s:4:\"9906\";i:15;s:4:\"7803\";i:16;s:4:\"6059\";i:17;s:4:\"6081\";i:18;s:4:\"6079\";i:19;s:4:\"5042\";i:20;s:5:\"13663\";i:21;s:5:\"10412\";i:22;s:5:\"11105\";i:23;s:4:\"8896\";i:24;s:4:\"5040\";i:25;s:4:\"7263\";i:26;s:4:\"7265\";i:27;s:4:\"7293\";i:28;s:4:\"9453\";i:29;s:5:\"13653\";i:30;s:4:\"9450\";i:31;s:4:\"6078\";i:32;s:4:\"7798\";i:33;s:4:\"6080\";i:34;s:4:\"9454\";i:35;s:4:\"5033\";i:36;s:4:\"9456\";i:37;s:5:\"11202\";i:38;s:5:\"13665\";i:39;s:4:\"8265\";i:40;s:4:\"7804\";i:41;s:4:\"9447\";i:42;s:5:\"10924\";i:43;s:4:\"8893\";i:44;s:5:\"13650\";i:45;s:5:\"13654\";i:46;s:4:\"9484\";i:47;s:4:\"9068\";i:48;s:4:\"9065\";i:49;s:5:\"13658\";i:50;s:4:\"6115\";i:51;s:4:\"9455\";i:52;s:4:\"5037\";i:53;s:4:\"8897\";i:54;s:5:\"11028\";i:55;s:4:\"9063\";i:56;s:5:\"13661\";i:57;s:4:\"4827\";i:58;s:4:\"7264\";i:59;s:4:\"7796\";i:60;s:4:\"5029\";i:61;s:4:\"9565\";i:62;s:4:\"8877\";i:63;s:5:\"13669\";i:64;s:5:\"13651\";i:65;s:4:\"8894\";i:66;s:4:\"9457\";i:67;s:5:\"10335\";i:68;s:5:\"10067\";i:69;s:4:\"8878\";i:70;s:5:\"10691\";i:71;s:4:\"9066\";i:72;s:4:\"9912\";i:73;s:4:\"9907\";i:74;s:4:\"9064\";i:75;s:5:\"13659\";i:76;s:4:\"9566\";i:77;s:4:\"9567\";i:78;s:4:\"9465\";i:79;s:4:\"9466\";i:80;s:4:\"5032\";i:81;s:4:\"9564\";i:82;s:4:\"9568\";i:83;s:4:\"9451\";i:84;s:4:\"5041\";i:85;s:5:\"11027\";i:86;s:4:\"5030\";i:87;s:4:\"9069\";i:88;s:5:\"13662\";i:89;s:4:\"8891\";i:90;s:4:\"8892\";i:91;s:4:\"2590\";i:92;s:4:\"7801\";i:93;s:5:\"13655\";i:94;s:4:\"9449\";i:95;s:5:\"10330\";i:96;s:4:\"9067\";i:97;s:5:\"13667\";i:98;s:5:\"13649\";i:99;s:4:\"5036\";i:100;s:4:\"6974\";i:101;s:4:\"5035\";i:102;s:4:\"9911\";i:103;s:4:\"5034\";i:104;s:4:\"9480\";i:105;s:4:\"9612\";i:106;s:4:\"7705\";i:107;s:4:\"5031\";i:108;s:4:\"5039\";i:109;s:4:\"9445\";i:110;s:4:\"7799\";i:111;s:5:\"10889\";i:112;s:4:\"9909\";i:113;s:4:\"7797\";i:114;s:4:\"9446\";i:115;s:4:\"5038\";i:116;s:4:\"9569\";i:117;s:4:\"9910\";i:118;s:4:\"9444\";i:119;s:4:\"7800\";i:120;s:4:\"6114\";i:121;s:5:\"13537\";i:122;s:5:\"13660\";i:123;s:4:\"9452\";i:124;s:5:\"13652\";i:125;s:5:\"12183\";i:126;s:4:\"6116\";i:127;s:5:\"10193\";i:128;s:4:\"9908\";i:129;s:4:\"8895\";i:130;s:4:\"7579\";i:131;s:5:\"11103\";}s:12:\"sql_ListStmt\";s:4610:\"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 (2590, 2591, 4587, 4826, 4827, 5029, 5030, 5031, 5032, 5033, 5034, 5035, 5036, 5037, 5038, 5039, 5040, 5041, 5042, 6059, 6078, 6079, 6080, 6081, 6082, 6114, 6115, 6116, 6974, 7263, 7264, 7265, 7293, 7362, 7579, 7626, 7705, 7795, 7796, 7797, 7798, 7799, 7800, 7801, 7802, 7803, 7804, 7805, 8265, 8877, 8878, 8891, 8892, 8893, 8894, 8895, 8896, 8897, 9063, 9064, 9065, 9066, 9067, 9068, 9069, 9444, 9445, 9446, 9447, 9449, 9450, 9451, 9452, 9453, 9454, 9455, 9456, 9457, 9464, 9465, 9466, 9480, 9484, 9505, 9506, 9564, 9565, 9566, 9567, 9568, 9569, 9612, 9905, 9906, 9907, 9908, 9909, 9910, 9911, 9912, 10067, 10193, 10330, 10335, 10412, 10691, 10889, 10924, 11027, 11028, 11103, 11105, 11202, 12183, 13537, 13649, 13650, 13651, 13652, 13653, 13654, 13655, 13658, 13659, 13660, 13661, 13662, 13663, 13665, 13667, 13668, 13669)) 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:\"7795\";i:1;s:4:\"6082\";i:2;s:4:\"9464\";i:3;s:4:\"9505\";i:4;s:4:\"9905\";i:5;s:4:\"7805\";i:6;s:4:\"7362\";i:7;s:4:\"9506\";i:8;s:4:\"4826\";i:9;s:4:\"7802\";i:10;s:5:\"13668\";i:11;s:4:\"4587\";i:12;s:4:\"2591\";i:13;s:4:\"7626\";i:14;s:4:\"9906\";i:15;s:4:\"7803\";i:16;s:4:\"6059\";i:17;s:4:\"6081\";i:18;s:4:\"6079\";i:19;s:4:\"5042\";i:20;s:5:\"13663\";i:21;s:5:\"10412\";i:22;s:5:\"11105\";i:23;s:4:\"8896\";i:24;s:4:\"5040\";i:25;s:4:\"7263\";i:26;s:4:\"7265\";i:27;s:4:\"7293\";i:28;s:4:\"9453\";i:29;s:5:\"13653\";i:30;s:4:\"9450\";i:31;s:4:\"6078\";i:32;s:4:\"7798\";i:33;s:4:\"6080\";i:34;s:4:\"9454\";i:35;s:4:\"5033\";i:36;s:4:\"9456\";i:37;s:5:\"11202\";i:38;s:5:\"13665\";i:39;s:4:\"8265\";i:40;s:4:\"7804\";i:41;s:4:\"9447\";i:42;s:5:\"10924\";i:43;s:4:\"8893\";i:44;s:5:\"13650\";i:45;s:5:\"13654\";i:46;s:4:\"9484\";i:47;s:4:\"9068\";i:48;s:4:\"9065\";i:49;s:5:\"13658\";i:50;s:4:\"6115\";i:51;s:4:\"9455\";i:52;s:4:\"5037\";i:53;s:4:\"8897\";i:54;s:5:\"11028\";i:55;s:4:\"9063\";i:56;s:5:\"13661\";i:57;s:4:\"4827\";i:58;s:4:\"7264\";i:59;s:4:\"7796\";i:60;s:4:\"5029\";i:61;s:4:\"9565\";i:62;s:4:\"8877\";i:63;s:5:\"13669\";i:64;s:5:\"13651\";i:65;s:4:\"8894\";i:66;s:4:\"9457\";i:67;s:5:\"10335\";i:68;s:5:\"10067\";i:69;s:4:\"8878\";i:70;s:5:\"10691\";i:71;s:4:\"9066\";i:72;s:4:\"9912\";i:73;s:4:\"9907\";i:74;s:4:\"9064\";i:75;s:5:\"13659\";i:76;s:4:\"9566\";i:77;s:4:\"9567\";i:78;s:4:\"9465\";i:79;s:4:\"9466\";i:80;s:4:\"5032\";i:81;s:4:\"9564\";i:82;s:4:\"9568\";i:83;s:4:\"9451\";i:84;s:4:\"5041\";i:85;s:5:\"11027\";i:86;s:4:\"5030\";i:87;s:4:\"9069\";i:88;s:5:\"13662\";i:89;s:4:\"8891\";i:90;s:4:\"8892\";i:91;s:4:\"2590\";i:92;s:4:\"7801\";i:93;s:5:\"13655\";i:94;s:4:\"9449\";i:95;s:5:\"10330\";i:96;s:4:\"9067\";i:97;s:5:\"13667\";i:98;s:5:\"13649\";i:99;s:4:\"5036\";}s:13:\"sql_LastMulti\";s:65:\"action=list_LISTSOMERESOURCES_CORE&method=publisherProcess&id=710\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:44:\"Publisher:  Ch.A. Bachmann(Bochum)\";}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:\"710\";s:18:\"browse_PagingTotal\";i:132;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');