[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:234:{i:0;s:4:\"5206\";i:1;s:4:\"7795\";i:2;s:4:\"6082\";i:3;s:5:\"15758\";i:4;s:5:\"10447\";i:5;s:4:\"8031\";i:6;s:4:\"4649\";i:7;s:5:\"14857\";i:8;s:5:\"14919\";i:9;s:5:\"13218\";i:10;s:4:\"9951\";i:11;s:4:\"8839\";i:12;s:4:\"7721\";i:13;s:4:\"6081\";i:14;s:4:\"6789\";i:15;s:4:\"2582\";i:16;s:4:\"3505\";i:17;s:5:\"10310\";i:18;s:4:\"6378\";i:19;s:4:\"6379\";i:20;s:4:\"7330\";i:21;s:4:\"3258\";i:22;s:4:\"9008\";i:23;s:5:\"12213\";i:24;s:4:\"7629\";i:25;s:4:\"9279\";i:26;s:4:\"3970\";i:27;s:5:\"10719\";i:28;s:5:\"10059\";i:29;s:4:\"9886\";i:30;s:4:\"2804\";i:31;s:4:\"1349\";i:32;s:4:\"8138\";i:33;s:5:\"12790\";i:34;s:5:\"11223\";i:35;s:4:\"1825\";i:36;s:4:\"2712\";i:37;s:4:\"7320\";i:38;s:4:\"7334\";i:39;s:4:\"8292\";i:40;s:4:\"2214\";i:41;s:4:\"7770\";i:42;s:4:\"4164\";i:43;s:4:\"6464\";i:44;s:4:\"4153\";i:45;s:5:\"15458\";i:46;s:5:\"15459\";i:47;s:5:\"15073\";i:48;s:4:\"8795\";i:49;s:5:\"15894\";i:50;s:4:\"3361\";i:51;s:5:\"11896\";i:52;s:4:\"8972\";i:53;s:5:\"14705\";i:54;s:4:\"8851\";i:55;s:4:\"4874\";i:56;s:5:\"13004\";i:57;s:5:\"10351\";i:58;s:5:\"10249\";i:59;s:5:\"12970\";i:60;s:4:\"8699\";i:61;s:4:\"3585\";i:62;s:4:\"6125\";i:63;s:4:\"6119\";i:64;s:4:\"6124\";i:65;s:5:\"13334\";i:66;s:5:\"15896\";i:67;s:5:\"15035\";i:68;s:5:\"11848\";i:69;s:4:\"1681\";i:70;s:5:\"15456\";i:71;s:4:\"4480\";i:72;s:5:\"11999\";i:73;s:5:\"11244\";i:74;s:4:\"6563\";i:75;s:5:\"14642\";i:76;s:4:\"5898\";i:77;s:4:\"6204\";i:78;s:5:\"15691\";i:79;s:5:\"14022\";i:80;s:5:\"14481\";i:81;s:5:\"11131\";i:82;s:4:\"5395\";i:83;s:4:\"9493\";i:84;s:4:\"2189\";i:85;s:5:\"13130\";i:86;s:4:\"4149\";i:87;s:4:\"7335\";i:88;s:4:\"7329\";i:89;s:4:\"8189\";i:90;s:5:\"12663\";i:91;s:5:\"10311\";i:92;s:5:\"13908\";i:93;s:5:\"12603\";i:94;s:4:\"4720\";i:95;s:4:\"3908\";i:96;s:4:\"3814\";i:97;s:5:\"10265\";i:98;s:4:\"4439\";i:99;s:4:\"2229\";i:100;s:4:\"4309\";i:101;s:4:\"2908\";i:102;s:4:\"3519\";i:103;s:4:\"3074\";i:104;s:4:\"1402\";i:105;s:4:\"3549\";i:106;s:4:\"5032\";i:107;s:4:\"6528\";i:108;s:4:\"9315\";i:109;s:5:\"14342\";i:110;s:4:\"9011\";i:111;s:4:\"3449\";i:112;s:5:\"10285\";i:113;s:4:\"9173\";i:114;s:4:\"7012\";i:115;s:5:\"10270\";i:116;s:4:\"8017\";i:117;s:5:\"16079\";i:118;s:4:\"5689\";i:119;s:4:\"7665\";i:120;s:5:\"10840\";i:121;s:5:\"13561\";i:122;s:4:\"8445\";i:123;s:5:\"10173\";i:124;s:4:\"4997\";i:125;s:4:\"8034\";i:126;s:5:\"14872\";i:127;s:4:\"7373\";i:128;s:5:\"10422\";i:129;s:4:\"2344\";i:130;s:5:\"11176\";i:131;s:4:\"1873\";i:132;s:4:\"1709\";i:133;s:5:\"10989\";i:134;s:5:\"16229\";i:135;s:4:\"6143\";i:136;s:4:\"6695\";i:137;s:5:\"10801\";i:138;s:5:\"11994\";i:139;s:4:\"9899\";i:140;s:4:\"5887\";i:141;s:4:\"3889\";i:142;s:4:\"1760\";i:143;s:5:\"15692\";i:144;s:4:\"8368\";i:145;s:4:\"5586\";i:146;s:4:\"8843\";i:147;s:5:\"10999\";i:148;s:4:\"4314\";i:149;s:5:\"15368\";i:150;s:4:\"2838\";i:151;s:4:\"9888\";i:152;s:5:\"10525\";i:153;s:4:\"5314\";i:154;s:4:\"6051\";i:155;s:4:\"7332\";i:156;s:4:\"4379\";i:157;s:4:\"6727\";i:158;s:4:\"3790\";i:159;s:4:\"7473\";i:160;s:4:\"9476\";i:161;s:4:\"4705\";i:162;s:4:\"9551\";i:163;s:4:\"9312\";i:164;s:5:\"12966\";i:165;s:4:\"4981\";i:166;s:4:\"6416\";i:167;s:4:\"3190\";i:168;s:5:\"11754\";i:169;s:5:\"12999\";i:170;s:5:\"11535\";i:171;s:5:\"15774\";i:172;s:4:\"9326\";i:173;s:4:\"7331\";i:174;s:5:\"11330\";i:175;s:4:\"1712\";i:176;s:4:\"9314\";i:177;s:4:\"4751\";i:178;s:4:\"2193\";i:179;s:4:\"1623\";i:180;s:4:\"1622\";i:181;s:5:\"12785\";i:182;s:5:\"14993\";i:183;s:4:\"6145\";i:184;s:4:\"1940\";i:185;s:4:\"4093\";i:186;s:4:\"2943\";i:187;s:4:\"8842\";i:188;s:4:\"6726\";i:189;s:5:\"12276\";i:190;s:5:\"12275\";i:191;s:4:\"6714\";i:192;s:4:\"5375\";i:193;s:4:\"9446\";i:194;s:4:\"6646\";i:195;s:4:\"4380\";i:196;s:5:\"11943\";i:197;s:4:\"8068\";i:198;s:4:\"4422\";i:199;s:4:\"6596\";i:200;s:4:\"9460\";i:201;s:5:\"14424\";i:202;s:4:\"6044\";i:203;s:5:\"10362\";i:204;s:4:\"7800\";i:205;s:4:\"7333\";i:206;s:5:\"10147\";i:207;s:5:\"11969\";i:208;s:4:\"2839\";i:209;s:5:\"11867\";i:210;s:4:\"9541\";i:211;s:5:\"10010\";i:212;s:4:\"3617\";i:213;s:5:\"15274\";i:214;s:4:\"1626\";i:215;s:4:\"7666\";i:216;s:4:\"5706\";i:217;s:4:\"9474\";i:218;s:5:\"14065\";i:219;s:4:\"7061\";i:220;s:4:\"7653\";i:221;s:4:\"4265\";i:222;s:4:\"4266\";i:223;s:4:\"1675\";i:224;s:4:\"4223\";i:225;s:5:\"14664\";i:226;s:5:\"10006\";i:227;s:5:\"14019\";i:228;s:4:\"8824\";i:229;s:4:\"2460\";i:230;s:4:\"9116\";i:231;s:4:\"3240\";i:232;s:4:\"9835\";i:233;s:4:\"2950\";}s:12:\"sql_ListStmt\";s:5269:\"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 (1349, 1622, 1623, 1626, 1760, 1825, 1873, 2193, 2214, 2229, 2712, 2908, 2943, 3074, 3190, 3240, 3258, 3361, 3505, 3519, 3549, 3585, 3617, 3790, 3814, 3889, 3908, 3970, 4149, 4164, 4223, 4265, 4266, 4309, 4379, 4380, 4422, 4439, 4480, 4705, 4720, 4751, 4874, 4981, 4997, 5032, 5206, 5375, 5395, 5586, 5689, 5706, 5887, 5898, 6044, 6051, 6081, 6082, 6119, 6124, 6125, 6145, 6204, 6379, 6416, 6464, 6528, 6563, 6596, 6646, 6695, 6726, 6727, 6789, 7012, 7320, 7329, 7330, 7331, 7332, 7333, 7334, 7335, 7473, 7629, 7653, 7665, 7666, 7770, 7795, 7800, 8017, 8031, 8034, 8068, 8138, 8189, 5314, 8292, 8368, 1712, 8445, 1681, 1709, 1940, 7721, 8699, 1675, 6143, 2344, 2460, 8824, 8842, 8839, 8843, 8851, 8972, 8795, 9008, 9116, 9173, 2839, 9312, 9314, 9315, 9326, 9446, 9460, 9279, 9011, 9474, 9476, 9493, 2950, 9551, 4314, 9541, 2804, 9835, 9888, 9886, 9899, 9951, 10006, 10010, 10059, 10173, 2838, 10249, 10265, 10270, 10285, 10351, 10362, 4153, 10311, 10719, 10840, 10989, 10999, 11131, 10447, 11176, 2582, 11223, 11244, 10310, 10801, 11535, 10525, 11848, 11867, 11969, 11994, 11999, 12213, 12275, 12276, 1402, 12663, 12785, 12790, 11896, 12966, 12970, 12999, 13130, 13218, 13334, 6714, 13561, 3449, 14019, 14022, 7061, 11330, 14065, 14342, 13004, 11754, 14424, 14664, 14481, 14705, 11943, 14857, 14872, 14919, 14993, 15035, 15073, 15274, 6378, 12603, 4093, 15368, 15456, 15458, 15459, 4649, 10147, 15691, 15692, 15758, 15774, 15894, 15896, 13908, 16079, 14642, 2189, 7373, 10422, 16229)) 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:\"5206\";i:1;s:4:\"7795\";i:2;s:4:\"6082\";i:3;s:5:\"15758\";i:4;s:5:\"10447\";i:5;s:4:\"8031\";i:6;s:4:\"4649\";i:7;s:5:\"14857\";i:8;s:5:\"14919\";i:9;s:5:\"13218\";i:10;s:4:\"9951\";i:11;s:4:\"8839\";i:12;s:4:\"7721\";i:13;s:4:\"6081\";i:14;s:4:\"6789\";i:15;s:4:\"2582\";i:16;s:4:\"3505\";i:17;s:5:\"10310\";i:18;s:4:\"6378\";i:19;s:4:\"6379\";i:20;s:4:\"7330\";i:21;s:4:\"3258\";i:22;s:4:\"9008\";i:23;s:5:\"12213\";i:24;s:4:\"7629\";i:25;s:4:\"9279\";i:26;s:4:\"3970\";i:27;s:5:\"10719\";i:28;s:5:\"10059\";i:29;s:4:\"9886\";i:30;s:4:\"2804\";i:31;s:4:\"1349\";i:32;s:4:\"8138\";i:33;s:5:\"12790\";i:34;s:5:\"11223\";i:35;s:4:\"1825\";i:36;s:4:\"2712\";i:37;s:4:\"7320\";i:38;s:4:\"7334\";i:39;s:4:\"8292\";i:40;s:4:\"2214\";i:41;s:4:\"7770\";i:42;s:4:\"4164\";i:43;s:4:\"6464\";i:44;s:4:\"4153\";i:45;s:5:\"15458\";i:46;s:5:\"15459\";i:47;s:5:\"15073\";i:48;s:4:\"8795\";i:49;s:5:\"15894\";i:50;s:4:\"3361\";i:51;s:5:\"11896\";i:52;s:4:\"8972\";i:53;s:5:\"14705\";i:54;s:4:\"8851\";i:55;s:4:\"4874\";i:56;s:5:\"13004\";i:57;s:5:\"10351\";i:58;s:5:\"10249\";i:59;s:5:\"12970\";i:60;s:4:\"8699\";i:61;s:4:\"3585\";i:62;s:4:\"6125\";i:63;s:4:\"6119\";i:64;s:4:\"6124\";i:65;s:5:\"13334\";i:66;s:5:\"15896\";i:67;s:5:\"15035\";i:68;s:5:\"11848\";i:69;s:4:\"1681\";i:70;s:5:\"15456\";i:71;s:4:\"4480\";i:72;s:5:\"11999\";i:73;s:5:\"11244\";i:74;s:4:\"6563\";i:75;s:5:\"14642\";i:76;s:4:\"5898\";i:77;s:4:\"6204\";i:78;s:5:\"15691\";i:79;s:5:\"14022\";i:80;s:5:\"14481\";i:81;s:5:\"11131\";i:82;s:4:\"5395\";i:83;s:4:\"9493\";i:84;s:4:\"2189\";i:85;s:5:\"13130\";i:86;s:4:\"4149\";i:87;s:4:\"7335\";i:88;s:4:\"7329\";i:89;s:4:\"8189\";i:90;s:5:\"12663\";i:91;s:5:\"10311\";i:92;s:5:\"13908\";i:93;s:5:\"12603\";i:94;s:4:\"4720\";i:95;s:4:\"3908\";i:96;s:4:\"3814\";i:97;s:5:\"10265\";i:98;s:4:\"4439\";i:99;s:4:\"2229\";}s:13:\"sql_LastMulti\";s:63:\"action=list_LISTSOMERESOURCES_CORE&method=keywordProcess&id=626\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:24:\"Keyword:  Film\";}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:\"626\";s:18:\"browse_PagingTotal\";i:234;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');