[SQL Error] INSERT INTO temp_storage (`tempstorageId`, `tempstorageData`) VALUES ('040ecdc6-281c-426e-9686-81dfce55738d', 'a:18:{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:190:{i:0;s:5:\"13910\";i:1;s:5:\"11259\";i:2;s:4:\"3358\";i:3;s:5:\"14147\";i:4;s:5:\"15415\";i:5;s:5:\"15416\";i:6;s:4:\"3073\";i:7;s:5:\"14314\";i:8;s:4:\"3645\";i:9;s:4:\"3076\";i:10;s:4:\"7479\";i:11;s:5:\"14194\";i:12;s:4:\"8550\";i:13;s:5:\"10061\";i:14;s:5:\"10238\";i:15;s:4:\"6203\";i:16;s:5:\"14761\";i:17;s:5:\"15375\";i:18;s:5:\"14759\";i:19;s:4:\"4565\";i:20;s:4:\"1487\";i:21;s:4:\"3070\";i:22;s:4:\"7147\";i:23;s:5:\"11832\";i:24;s:5:\"13769\";i:25;s:4:\"2210\";i:26;s:4:\"7851\";i:27;s:4:\"3068\";i:28;s:5:\"12004\";i:29;s:5:\"12850\";i:30;s:4:\"7777\";i:31;s:5:\"12018\";i:32;s:4:\"2639\";i:33;s:4:\"7918\";i:34;s:5:\"12095\";i:35;s:4:\"1530\";i:36;s:4:\"8775\";i:37;s:5:\"11507\";i:38;s:4:\"2638\";i:39;s:5:\"14421\";i:40;s:4:\"9487\";i:41;s:4:\"8614\";i:42;s:5:\"14685\";i:43;s:5:\"10240\";i:44;s:5:\"13440\";i:45;s:4:\"5681\";i:46;s:4:\"4059\";i:47;s:5:\"11559\";i:48;s:5:\"11469\";i:49;s:4:\"9836\";i:50;s:4:\"9838\";i:51;s:5:\"10317\";i:52;s:5:\"10667\";i:53;s:5:\"12277\";i:54;s:5:\"15679\";i:55;s:4:\"6107\";i:56;s:4:\"2143\";i:57;s:4:\"1573\";i:58;s:4:\"1535\";i:59;s:5:\"10519\";i:60;s:4:\"1528\";i:61;s:5:\"10155\";i:62;s:4:\"8981\";i:63;s:4:\"4947\";i:64;s:4:\"4277\";i:65;s:4:\"1532\";i:66;s:5:\"11463\";i:67;s:4:\"4407\";i:68;s:4:\"9068\";i:69;s:5:\"14042\";i:70;s:5:\"10967\";i:71;s:5:\"10966\";i:72;s:4:\"8831\";i:73;s:4:\"8974\";i:74;s:4:\"4503\";i:75;s:4:\"6842\";i:76;s:4:\"8959\";i:77;s:4:\"1529\";i:78;s:4:\"3081\";i:79;s:5:\"14099\";i:80;s:5:\"16066\";i:81;s:5:\"10668\";i:82;s:4:\"4720\";i:83;s:4:\"9066\";i:84;s:5:\"13557\";i:85;s:5:\"10500\";i:86;s:5:\"13123\";i:87;s:5:\"13208\";i:88;s:4:\"1531\";i:89;s:4:\"3968\";i:90;s:4:\"5953\";i:91;s:5:\"15373\";i:92;s:4:\"7192\";i:93;s:4:\"3349\";i:94;s:5:\"13071\";i:95;s:5:\"14516\";i:96;s:4:\"3776\";i:97;s:5:\"15086\";i:98;s:5:\"11494\";i:99;s:5:\"12096\";i:100;s:4:\"8913\";i:101;s:5:\"16311\";i:102;s:4:\"6873\";i:103;s:5:\"13377\";i:104;s:4:\"4013\";i:105;s:4:\"2746\";i:106;s:4:\"8754\";i:107;s:4:\"9069\";i:108;s:4:\"4977\";i:109;s:4:\"7617\";i:110;s:4:\"2637\";i:111;s:4:\"5001\";i:112;s:4:\"8829\";i:113;s:5:\"14584\";i:114;s:5:\"15216\";i:115;s:4:\"2034\";i:116;s:4:\"9412\";i:117;s:5:\"13986\";i:118;s:5:\"12389\";i:119;s:5:\"12601\";i:120;s:4:\"6167\";i:121;s:5:\"12170\";i:122;s:4:\"2438\";i:123;s:5:\"12621\";i:124;s:4:\"3798\";i:125;s:5:\"15948\";i:126;s:4:\"8244\";i:127;s:5:\"15627\";i:128;s:5:\"11877\";i:129;s:4:\"7166\";i:130;s:5:\"12117\";i:131;s:5:\"15636\";i:132;s:4:\"4989\";i:133;s:5:\"13472\";i:134;s:5:\"14911\";i:135;s:5:\"12655\";i:136;s:4:\"9480\";i:137;s:4:\"2141\";i:138;s:4:\"1534\";i:139;s:4:\"1864\";i:140;s:5:\"10062\";i:141;s:5:\"10443\";i:142;s:4:\"3066\";i:143;s:4:\"6306\";i:144;s:5:\"11879\";i:145;s:5:\"12937\";i:146;s:5:\"12263\";i:147;s:5:\"13871\";i:148;s:4:\"8694\";i:149;s:5:\"11900\";i:150;s:4:\"8146\";i:151;s:4:\"8695\";i:152;s:4:\"6961\";i:153;s:4:\"5002\";i:154;s:4:\"6148\";i:155;s:4:\"1891\";i:156;s:5:\"11881\";i:157;s:5:\"14686\";i:158;s:5:\"10049\";i:159;s:5:\"13146\";i:160;s:4:\"8337\";i:161;s:5:\"15156\";i:162;s:5:\"11037\";i:163;s:4:\"9839\";i:164;s:5:\"11946\";i:165;s:5:\"11423\";i:166;s:4:\"9214\";i:167;s:5:\"10528\";i:168;s:5:\"16231\";i:169;s:4:\"7984\";i:170;s:5:\"12485\";i:171;s:5:\"12807\";i:172;s:5:\"15317\";i:173;s:5:\"13684\";i:174;s:5:\"14798\";i:175;s:5:\"15708\";i:176;s:5:\"14393\";i:177;s:5:\"12112\";i:178;s:4:\"2737\";i:179;s:5:\"10358\";i:180;s:5:\"14404\";i:181;s:4:\"9479\";i:182;s:4:\"8059\";i:183;s:4:\"4502\";i:184;s:5:\"10008\";i:185;s:4:\"9462\";i:186;s:5:\"11368\";i:187;s:4:\"9855\";i:188;s:5:\"10359\";i:189;s:5:\"12556\";}s:12:\"sql_ListStmt\";s:5022:\"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 (1487, 1529, 1530, 1531, 1532, 1534, 1535, 1891, 2034, 2141, 2210, 2438, 2637, 2746, 3066, 3068, 3070, 3073, 3076, 3081, 3358, 3776, 3798, 3968, 4013, 4407, 4502, 4503, 4565, 4720, 4947, 4989, 5001, 5002, 5681, 5953, 6107, 6167, 6203, 6306, 6842, 6873, 6961, 7147, 7166, 7192, 7617, 7851, 7918, 7984, 8244, 2639, 8337, 8146, 8550, 8754, 8775, 8695, 8829, 4277, 8913, 8959, 8981, 9066, 9068, 8694, 3349, 9462, 8059, 9479, 9487, 2638, 9214, 9836, 9838, 9855, 10008, 10049, 10061, 10062, 10155, 10238, 10240, 10358, 10443, 10500, 10519, 10528, 2143, 8614, 9480, 10667, 10668, 10966, 10967, 2737, 1573, 4977, 11259, 11368, 6148, 11423, 11494, 11507, 1528, 11832, 11877, 11879, 11881, 11900, 12018, 3645, 12096, 11469, 12095, 11463, 12112, 12117, 12170, 4059, 7777, 12389, 10317, 12485, 1864, 12556, 12601, 12621, 12655, 12807, 12850, 13123, 13146, 13377, 12277, 13440, 9069, 8831, 8974, 13557, 12004, 13871, 12937, 13071, 9839, 13986, 14042, 11946, 14099, 13208, 14314, 14147, 11559, 14393, 13472, 14421, 11037, 10359, 14584, 14685, 14686, 14759, 14761, 14798, 14911, 13910, 13769, 15086, 15156, 14404, 9412, 15216, 13684, 15317, 14516, 12263, 15373, 15375, 15415, 15416, 15627, 15636, 15679, 15708, 14194, 15948, 16066, 7479, 16231, 16311)) 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:\"13910\";i:1;s:5:\"11259\";i:2;s:4:\"3358\";i:3;s:5:\"14147\";i:4;s:5:\"15415\";i:5;s:5:\"15416\";i:6;s:4:\"3073\";i:7;s:5:\"14314\";i:8;s:4:\"3645\";i:9;s:4:\"3076\";i:10;s:4:\"7479\";i:11;s:5:\"14194\";i:12;s:4:\"8550\";i:13;s:5:\"10061\";i:14;s:5:\"10238\";i:15;s:4:\"6203\";i:16;s:5:\"14761\";i:17;s:5:\"15375\";i:18;s:5:\"14759\";i:19;s:4:\"4565\";i:20;s:4:\"1487\";i:21;s:4:\"3070\";i:22;s:4:\"7147\";i:23;s:5:\"11832\";i:24;s:5:\"13769\";i:25;s:4:\"2210\";i:26;s:4:\"7851\";i:27;s:4:\"3068\";i:28;s:5:\"12004\";i:29;s:5:\"12850\";i:30;s:4:\"7777\";i:31;s:5:\"12018\";i:32;s:4:\"2639\";i:33;s:4:\"7918\";i:34;s:5:\"12095\";i:35;s:4:\"1530\";i:36;s:4:\"8775\";i:37;s:5:\"11507\";i:38;s:4:\"2638\";i:39;s:5:\"14421\";i:40;s:4:\"9487\";i:41;s:4:\"8614\";i:42;s:5:\"14685\";i:43;s:5:\"10240\";i:44;s:5:\"13440\";i:45;s:4:\"5681\";i:46;s:4:\"4059\";i:47;s:5:\"11559\";i:48;s:5:\"11469\";i:49;s:4:\"9836\";i:50;s:4:\"9838\";i:51;s:5:\"10317\";i:52;s:5:\"10667\";i:53;s:5:\"12277\";i:54;s:5:\"15679\";i:55;s:4:\"6107\";i:56;s:4:\"2143\";i:57;s:4:\"1573\";i:58;s:4:\"1535\";i:59;s:5:\"10519\";i:60;s:4:\"1528\";i:61;s:5:\"10155\";i:62;s:4:\"8981\";i:63;s:4:\"4947\";i:64;s:4:\"4277\";i:65;s:4:\"1532\";i:66;s:5:\"11463\";i:67;s:4:\"4407\";i:68;s:4:\"9068\";i:69;s:5:\"14042\";i:70;s:5:\"10967\";i:71;s:5:\"10966\";i:72;s:4:\"8831\";i:73;s:4:\"8974\";i:74;s:4:\"4503\";i:75;s:4:\"6842\";i:76;s:4:\"8959\";i:77;s:4:\"1529\";i:78;s:4:\"3081\";i:79;s:5:\"14099\";i:80;s:5:\"16066\";i:81;s:5:\"10668\";i:82;s:4:\"4720\";i:83;s:4:\"9066\";i:84;s:5:\"13557\";i:85;s:5:\"10500\";i:86;s:5:\"13123\";i:87;s:5:\"13208\";i:88;s:4:\"1531\";i:89;s:4:\"3968\";i:90;s:4:\"5953\";i:91;s:5:\"15373\";i:92;s:4:\"7192\";i:93;s:4:\"3349\";i:94;s:5:\"13071\";i:95;s:5:\"14516\";i:96;s:4:\"3776\";i:97;s:5:\"15086\";i:98;s:5:\"11494\";i:99;s:5:\"12096\";}s:13:\"sql_LastMulti\";s:63:\"action=list_LISTSOMERESOURCES_CORE&method=keywordProcess&id=801\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:26:\"Keyword:  Trauma\";}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:\"801\";s:18:\"browse_PagingTotal\";i:190;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');