Backtraces
#FunctionFileLine
1SQL->internalQuery/var/www/wikindx/core/libs/SQL.php117
2SQL->query/var/www/wikindx/core/libs/SQL.php130
3SQL->queryNoResult/var/www/wikindx/core/libs/SQL.php1335
4SQL->insert/var/www/wikindx/core/libs/TEMPSTORAGE.php53
5TEMPSTORAGE\store/var/www/wikindx/core/libs/CLOSE.php315
6CLOSE->tidySession/var/www/wikindx/core/libs/CLOSE.php133
7CLOSE->__construct/var/www/wikindx/core/startup/FACTORY.php538
8FACTORY_CLOSE::getInstance/var/www/wikindx/index.php223


[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:464:{i:0;s:5:\"11854\";i:1;s:4:\"3309\";i:2;s:4:\"3271\";i:3;s:4:\"4289\";i:4;s:4:\"2755\";i:5;s:4:\"5463\";i:6;s:4:\"3073\";i:7;s:4:\"2502\";i:8;s:4:\"4166\";i:9;s:4:\"3751\";i:10;s:4:\"3376\";i:11;s:4:\"4548\";i:12;s:4:\"2619\";i:13;s:4:\"8332\";i:14;s:4:\"3161\";i:15;s:4:\"2021\";i:16;s:4:\"3076\";i:17;s:4:\"2569\";i:18;s:4:\"2176\";i:19;s:4:\"9499\";i:20;s:5:\"12931\";i:21;s:4:\"3063\";i:22;s:4:\"3326\";i:23;s:4:\"6333\";i:24;s:4:\"2808\";i:25;s:4:\"3017\";i:26;s:4:\"8188\";i:27;s:4:\"2570\";i:28;s:5:\"12698\";i:29;s:5:\"14556\";i:30;s:4:\"2727\";i:31;s:4:\"2053\";i:32;s:4:\"2583\";i:33;s:4:\"2175\";i:34;s:4:\"4104\";i:35;s:4:\"1744\";i:36;s:4:\"9299\";i:37;s:4:\"3272\";i:38;s:4:\"3384\";i:39;s:4:\"6334\";i:40;s:4:\"3325\";i:41;s:4:\"3120\";i:42;s:4:\"3070\";i:43;s:4:\"3273\";i:44;s:5:\"11200\";i:45;s:4:\"2101\";i:46;s:4:\"4337\";i:47;s:4:\"7436\";i:48;s:4:\"1592\";i:49;s:4:\"3068\";i:50;s:4:\"1463\";i:51;s:4:\"3409\";i:52;s:4:\"1363\";i:53;s:4:\"2724\";i:54;s:4:\"6717\";i:55;s:4:\"6719\";i:56;s:4:\"4374\";i:57;s:4:\"1859\";i:58;s:4:\"3057\";i:59;s:5:\"10152\";i:60;s:4:\"1593\";i:61;s:4:\"9708\";i:62;s:4:\"9205\";i:63;s:4:\"3267\";i:64;s:5:\"12951\";i:65;s:4:\"2705\";i:66;s:4:\"3404\";i:67;s:4:\"5347\";i:68;s:4:\"3071\";i:69;s:4:\"5750\";i:70;s:5:\"11645\";i:71;s:4:\"7128\";i:72;s:4:\"3714\";i:73;s:4:\"7832\";i:74;s:4:\"4575\";i:75;s:4:\"8796\";i:76;s:5:\"11488\";i:77;s:4:\"3382\";i:78;s:4:\"3410\";i:79;s:4:\"6866\";i:80;s:4:\"3383\";i:81;s:4:\"2177\";i:82;s:4:\"2764\";i:83;s:4:\"6093\";i:84;s:4:\"2671\";i:85;s:4:\"4007\";i:86;s:4:\"3756\";i:87;s:4:\"3884\";i:88;s:4:\"7199\";i:89;s:4:\"1710\";i:90;s:4:\"7667\";i:91;s:4:\"4788\";i:92;s:4:\"4579\";i:93;s:5:\"15191\";i:94;s:4:\"3922\";i:95;s:4:\"3859\";i:96;s:4:\"2014\";i:97;s:4:\"4201\";i:98;s:4:\"3266\";i:99;s:4:\"2089\";i:100;s:5:\"10107\";i:101;s:4:\"3331\";i:102;s:4:\"1501\";i:103;s:4:\"3077\";i:104;s:4:\"4293\";i:105;s:4:\"3375\";i:106;s:4:\"3378\";i:107;s:4:\"4793\";i:108;s:4:\"6275\";i:109;s:4:\"5500\";i:110;s:4:\"2348\";i:111;s:4:\"2532\";i:112;s:4:\"4333\";i:113;s:4:\"2703\";i:114;s:4:\"7651\";i:115;s:5:\"14204\";i:116;s:5:\"14202\";i:117;s:4:\"2169\";i:118;s:4:\"2750\";i:119;s:4:\"7827\";i:120;s:4:\"8112\";i:121;s:4:\"6182\";i:122;s:4:\"5097\";i:123;s:5:\"11274\";i:124;s:4:\"1700\";i:125;s:4:\"5898\";i:126;s:4:\"3951\";i:127;s:5:\"14434\";i:128;s:4:\"2172\";i:129;s:4:\"3332\";i:130;s:4:\"7131\";i:131;s:4:\"3133\";i:132;s:4:\"4028\";i:133;s:4:\"4294\";i:134;s:4:\"2795\";i:135;s:4:\"3081\";i:136;s:4:\"2533\";i:137;s:5:\"12841\";i:138;s:4:\"7339\";i:139;s:4:\"5713\";i:140;s:4:\"8184\";i:141;s:4:\"8189\";i:142;s:4:\"2797\";i:143;s:4:\"1962\";i:144;s:4:\"8349\";i:145;s:4:\"3786\";i:146;s:4:\"4010\";i:147;s:4:\"5735\";i:148;s:5:\"11601\";i:149;s:4:\"8270\";i:150;s:4:\"2087\";i:151;s:4:\"3392\";i:152;s:4:\"3061\";i:153;s:4:\"2794\";i:154;s:4:\"4486\";i:155;s:4:\"1581\";i:156;s:4:\"4449\";i:157;s:4:\"4008\";i:158;s:4:\"2273\";i:159;s:4:\"3373\";i:160;s:4:\"3406\";i:161;s:4:\"3412\";i:162;s:4:\"3074\";i:163;s:4:\"2083\";i:164;s:4:\"4290\";i:165;s:4:\"4242\";i:166;s:4:\"2339\";i:167;s:4:\"8186\";i:168;s:4:\"6027\";i:169;s:4:\"3381\";i:170;s:4:\"2670\";i:171;s:4:\"3096\";i:172;s:4:\"4330\";i:173;s:4:\"9055\";i:174;s:4:\"9054\";i:175;s:4:\"8024\";i:176;s:4:\"8020\";i:177;s:4:\"6006\";i:178;s:4:\"3399\";i:179;s:4:\"9018\";i:180;s:4:\"7703\";i:181;s:4:\"3408\";i:182;s:5:\"11545\";i:183;s:4:\"2075\";i:184;s:5:\"11845\";i:185;s:4:\"9448\";i:186;s:4:\"2174\";i:187;s:4:\"3087\";i:188;s:4:\"2052\";i:189;s:4:\"2690\";i:190;s:4:\"4244\";i:191;s:5:\"12521\";i:192;s:4:\"9017\";i:193;s:4:\"4224\";i:194;s:4:\"8023\";i:195;s:4:\"3318\";i:196;s:4:\"3327\";i:197;s:4:\"3317\";i:198;s:4:\"3301\";i:199;s:4:\"6008\";i:200;s:4:\"3396\";i:201;s:4:\"3094\";i:202;s:4:\"3398\";i:203;s:4:\"2072\";i:204;s:4:\"3144\";i:205;s:4:\"4656\";i:206;s:4:\"8333\";i:207;s:4:\"9498\";i:208;s:4:\"2173\";i:209;s:4:\"7568\";i:210;s:5:\"10656\";i:211;s:5:\"10436\";i:212;s:4:\"2140\";i:213;s:4:\"3377\";i:214;s:4:\"1741\";i:215;s:4:\"3393\";i:216;s:4:\"2114\";i:217;s:4:\"3379\";i:218;s:4:\"2112\";i:219;s:4:\"3329\";i:220;s:4:\"2300\";i:221;s:4:\"3397\";i:222;s:4:\"5994\";i:223;s:4:\"4873\";i:224;s:4:\"4111\";i:225;s:4:\"4234\";i:226;s:4:\"2313\";i:227;s:4:\"5723\";i:228;s:4:\"5725\";i:229;s:4:\"2314\";i:230;s:4:\"5727\";i:231;s:4:\"5413\";i:232;s:4:\"2318\";i:233;s:4:\"2312\";i:234;s:4:\"5412\";i:235;s:4:\"2315\";i:236;s:4:\"6332\";i:237;s:4:\"5444\";i:238;s:4:\"5728\";i:239;s:4:\"2311\";i:240;s:4:\"5726\";i:241;s:4:\"2317\";i:242;s:4:\"2310\";i:243;s:4:\"2316\";i:244;s:4:\"4973\";i:245;s:4:\"4636\";i:246;s:4:\"3809\";i:247;s:4:\"2071\";i:248;s:4:\"6387\";i:249;s:4:\"3328\";i:250;s:4:\"6329\";i:251;s:4:\"1788\";i:252;s:4:\"8825\";i:253;s:4:\"6327\";i:254;s:4:\"4334\";i:255;s:5:\"12070\";i:256;s:4:\"2531\";i:257;s:4:\"7831\";i:258;s:4:\"7562\";i:259;s:4:\"6176\";i:260;s:4:\"3380\";i:261;s:5:\"12170\";i:262;s:4:\"7083\";i:263;s:4:\"4570\";i:264;s:4:\"2760\";i:265;s:4:\"3060\";i:266;s:4:\"7233\";i:267;s:4:\"4662\";i:268;s:4:\"4663\";i:269;s:5:\"11190\";i:270;s:4:\"3434\";i:271;s:4:\"3312\";i:272;s:4:\"3311\";i:273;s:4:\"7829\";i:274;s:4:\"4336\";i:275;s:4:\"8588\";i:276;s:4:\"2921\";i:277;s:5:\"11917\";i:278;s:4:\"2701\";i:279;s:4:\"3270\";i:280;s:4:\"3324\";i:281;s:4:\"6298\";i:282;s:4:\"3319\";i:283;s:4:\"4011\";i:284;s:4:\"3269\";i:285;s:5:\"13905\";i:286;s:4:\"1903\";i:287;s:4:\"2066\";i:288;s:4:\"2064\";i:289;s:4:\"2065\";i:290;s:4:\"9500\";i:291;s:4:\"6752\";i:292;s:4:\"7830\";i:293;s:4:\"3407\";i:294;s:4:\"5749\";i:295;s:4:\"2740\";i:296;s:4:\"8929\";i:297;s:4:\"1580\";i:298;s:4:\"8113\";i:299;s:4:\"5455\";i:300;s:4:\"4291\";i:301;s:4:\"6005\";i:302;s:4:\"3062\";i:303;s:4:\"6007\";i:304;s:4:\"1939\";i:305;s:4:\"1953\";i:306;s:4:\"3394\";i:307;s:4:\"2530\";i:308;s:4:\"6326\";i:309;s:4:\"5674\";i:310;s:4:\"2572\";i:311;s:4:\"4578\";i:312;s:4:\"4586\";i:313;s:4:\"4581\";i:314;s:5:\"10366\";i:315;s:4:\"3839\";i:316;s:4:\"3711\";i:317;s:4:\"2656\";i:318;s:4:\"1767\";i:319;s:5:\"14433\";i:320;s:4:\"4583\";i:321;s:4:\"1777\";i:322;s:4:\"4585\";i:323;s:4:\"7828\";i:324;s:4:\"4325\";i:325;s:4:\"4326\";i:326;s:4:\"6692\";i:327;s:4:\"4582\";i:328;s:4:\"5732\";i:329;s:4:\"1491\";i:330;s:4:\"5912\";i:331;s:4:\"6325\";i:332;s:4:\"3610\";i:333;s:4:\"2178\";i:334;s:4:\"4348\";i:335;s:4:\"6040\";i:336;s:4:\"3066\";i:337;s:4:\"4338\";i:338;s:4:\"7702\";i:339;s:4:\"3330\";i:340;s:4:\"2171\";i:341;s:4:\"3320\";i:342;s:4:\"5990\";i:343;s:4:\"6331\";i:344;s:4:\"3753\";i:345;s:4:\"3093\";i:346;s:4:\"1786\";i:347;s:4:\"9688\";i:348;s:4:\"9019\";i:349;s:5:\"14719\";i:350;s:4:\"5598\";i:351;s:5:\"14203\";i:352;s:4:\"5406\";i:353;s:4:\"4574\";i:354;s:4:\"1935\";i:355;s:4:\"3403\";i:356;s:4:\"3795\";i:357;s:4:\"3078\";i:358;s:4:\"5677\";i:359;s:4:\"4577\";i:360;s:4:\"4915\";i:361;s:4:\"3411\";i:362;s:4:\"1691\";i:363;s:4:\"3413\";i:364;s:4:\"1931\";i:365;s:4:\"8187\";i:366;s:4:\"2168\";i:367;s:4:\"4655\";i:368;s:4:\"4233\";i:369;s:4:\"3713\";i:370;s:4:\"4245\";i:371;s:4:\"4307\";i:372;s:4:\"4211\";i:373;s:4:\"4228\";i:374;s:4:\"3754\";i:375;s:4:\"5003\";i:376;s:4:\"7138\";i:377;s:4:\"3402\";i:378;s:4:\"3750\";i:379;s:4:\"4202\";i:380;s:4:\"4573\";i:381;s:4:\"3075\";i:382;s:4:\"2137\";i:383;s:4:\"2129\";i:384;s:4:\"3687\";i:385;s:4:\"4006\";i:386;s:4:\"3395\";i:387;s:4:\"2595\";i:388;s:4:\"2578\";i:389;s:4:\"4422\";i:390;s:4:\"3268\";i:391;s:4:\"6680\";i:392;s:4:\"5428\";i:393;s:4:\"5149\";i:394;s:4:\"5298\";i:395;s:4:\"4588\";i:396;s:5:\"12826\";i:397;s:4:\"5098\";i:398;s:4:\"3314\";i:399;s:4:\"3095\";i:400;s:4:\"1929\";i:401;s:4:\"3405\";i:402;s:4:\"3401\";i:403;s:4:\"4562\";i:404;s:5:\"16102\";i:405;s:4:\"2538\";i:406;s:4:\"1928\";i:407;s:4:\"6184\";i:408;s:4:\"3145\";i:409;s:4:\"8185\";i:410;s:4:\"3752\";i:411;s:4:\"4339\";i:412;s:4:\"3064\";i:413;s:4:\"3069\";i:414;s:4:\"6328\";i:415;s:4:\"1783\";i:416;s:4:\"2571\";i:417;s:4:\"2568\";i:418;s:4:\"1915\";i:419;s:4:\"1914\";i:420;s:4:\"6283\";i:421;s:4:\"6335\";i:422;s:4:\"4009\";i:423;s:4:\"1910\";i:424;s:4:\"5374\";i:425;s:4:\"8114\";i:426;s:4:\"3707\";i:427;s:4:\"2726\";i:428;s:4:\"6718\";i:429;s:4:\"9714\";i:430;s:4:\"3072\";i:431;s:4:\"4789\";i:432;s:4:\"6181\";i:433;s:4:\"6183\";i:434;s:5:\"12153\";i:435;s:4:\"8115\";i:436;s:4:\"8323\";i:437;s:4:\"5269\";i:438;s:4:\"7531\";i:439;s:4:\"7532\";i:440;s:4:\"3316\";i:441;s:4:\"3315\";i:442;s:4:\"3313\";i:443;s:4:\"2170\";i:444;s:4:\"4210\";i:445;s:4:\"6330\";i:446;s:4:\"1909\";i:447;s:4:\"5130\";i:448;s:4:\"3791\";i:449;s:4:\"4130\";i:450;s:4:\"9934\";i:451;s:4:\"4576\";i:452;s:4:\"5397\";i:453;s:4:\"5714\";i:454;s:4:\"5697\";i:455;s:4:\"1972\";i:456;s:4:\"3310\";i:457;s:4:\"2953\";i:458;s:4:\"4292\";i:459;s:4:\"4898\";i:460;s:4:\"6169\";i:461;s:4:\"5304\";i:462;s:4:\"1591\";i:463;s:4:\"4147\";}s:12:\"sql_ListStmt\";s:6604:\"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 (1363, 1463, 1491, 1501, 1580, 1581, 1591, 1592, 1593, 1691, 1700, 1710, 1741, 1744, 1767, 1777, 1783, 1786, 1788, 1859, 1903, 1909, 1910, 1914, 1915, 1928, 1929, 1931, 1935, 1939, 1953, 1962, 1972, 2014, 2021, 2052, 2053, 2064, 2065, 2066, 2071, 2072, 2075, 2083, 2087, 2089, 2101, 2112, 2114, 2129, 2137, 2140, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2273, 2300, 2310, 2311, 2312, 2313, 2314, 2315, 2316, 2317, 2318, 2339, 2348, 2502, 2530, 2531, 2532, 2533, 2538, 2568, 2569, 2570, 2571, 2572, 2578, 2583, 2595, 2619, 2656, 2670, 2671, 2690, 2701, 2703, 2705, 2724, 2726, 2727, 2740, 2750, 2755, 2760, 2764, 2794, 2795, 2797, 2808, 2921, 2953, 3017, 3057, 3060, 3061, 3062, 3063, 3064, 3066, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3081, 3087, 3093, 3094, 3095, 3096, 3120, 3133, 3144, 3145, 3161, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3301, 3309, 3310, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3318, 3319, 3320, 3324, 3325, 3326, 3327, 3328, 3329, 3330, 3331, 3332, 3373, 3375, 3376, 3377, 3378, 3379, 3380, 3381, 3382, 3383, 3384, 3392, 3393, 3394, 3395, 3396, 3397, 3398, 3399, 3401, 3402, 3403, 3404, 3405, 3406, 3407, 3408, 3409, 3410, 3411, 3412, 3413, 3434, 3610, 3687, 3707, 3711, 3713, 3714, 3750, 3751, 3752, 3753, 3754, 3756, 3786, 3791, 3795, 3809, 3839, 3859, 3884, 3922, 3951, 4006, 4007, 4008, 4009, 4010, 4011, 4028, 4104, 4111, 4130, 4147, 4166, 4201, 4202, 4210, 4211, 4224, 4228, 4233, 4234, 4242, 4244, 4245, 4289, 4290, 4291, 4292, 4293, 4294, 4307, 4325, 4326, 4330, 4333, 4334, 4336, 4337, 4338, 4339, 4348, 4374, 4422, 4449, 4486, 4548, 4562, 4570, 4573, 4574, 4575, 4576, 4577, 4578, 4579, 4581, 4582, 4583, 4585, 4586, 4588, 4636, 4655, 4656, 4662, 4663, 4788, 4789, 4793, 4873, 4898, 4915, 4973, 5003, 5097, 5098, 5130, 5149, 5269, 5298, 5304, 5347, 5374, 5397, 5406, 5412, 5413, 5428, 5444, 5455, 5463, 5500, 5598, 5674, 5677, 5697, 5713, 5714, 5723, 5725, 5726, 5727, 5728, 5732, 5735, 5749, 5750, 5898, 5912, 5990, 5994, 6005, 6006, 6007, 6008, 6027, 6040, 6093, 6169, 6176, 6181, 6182, 6183, 6184, 6275, 6283, 6298, 6325, 6326, 6327, 6328, 6329, 6330, 6331, 6332, 6333, 6334, 6335, 6387, 6680, 6692, 6717, 6718, 6719, 6752, 6866, 7083, 7128, 7131, 7138, 7199, 7233, 7339, 7436, 7531, 7532, 7562, 7568, 7651, 7667, 7702, 7703, 7827, 7828, 7829, 7830, 7831, 7832, 8020, 8023, 8024, 8112, 8113, 8114, 8115, 8184, 8185, 8186, 8187, 8188, 8189, 8270, 8323, 8332, 8333, 8349, 8588, 8796, 8825, 8929, 9017, 9018, 9019, 9054, 9055, 9205, 9299, 9448, 9498, 9499, 9500, 9688, 9708, 9714, 9934, 10107, 10152, 10366, 10436, 10656, 11190, 11200, 11274, 11488, 11545, 11601, 11645, 11845, 11854, 11917, 12070, 12153, 12170, 12521, 12698, 12826, 12841, 12931, 12951, 13905, 14202, 14203, 14204, 14433, 14434, 14556, 14719, 15191, 16102)) 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:\"11854\";i:1;s:4:\"3309\";i:2;s:4:\"3271\";i:3;s:4:\"4289\";i:4;s:4:\"2755\";i:5;s:4:\"5463\";i:6;s:4:\"3073\";i:7;s:4:\"2502\";i:8;s:4:\"4166\";i:9;s:4:\"3751\";i:10;s:4:\"3376\";i:11;s:4:\"4548\";i:12;s:4:\"2619\";i:13;s:4:\"8332\";i:14;s:4:\"3161\";i:15;s:4:\"2021\";i:16;s:4:\"3076\";i:17;s:4:\"2569\";i:18;s:4:\"2176\";i:19;s:4:\"9499\";i:20;s:5:\"12931\";i:21;s:4:\"3063\";i:22;s:4:\"3326\";i:23;s:4:\"6333\";i:24;s:4:\"2808\";i:25;s:4:\"3017\";i:26;s:4:\"8188\";i:27;s:4:\"2570\";i:28;s:5:\"12698\";i:29;s:5:\"14556\";i:30;s:4:\"2727\";i:31;s:4:\"2053\";i:32;s:4:\"2583\";i:33;s:4:\"2175\";i:34;s:4:\"4104\";i:35;s:4:\"1744\";i:36;s:4:\"9299\";i:37;s:4:\"3272\";i:38;s:4:\"3384\";i:39;s:4:\"6334\";i:40;s:4:\"3325\";i:41;s:4:\"3120\";i:42;s:4:\"3070\";i:43;s:4:\"3273\";i:44;s:5:\"11200\";i:45;s:4:\"2101\";i:46;s:4:\"4337\";i:47;s:4:\"7436\";i:48;s:4:\"1592\";i:49;s:4:\"3068\";i:50;s:4:\"1463\";i:51;s:4:\"3409\";i:52;s:4:\"1363\";i:53;s:4:\"2724\";i:54;s:4:\"6717\";i:55;s:4:\"6719\";i:56;s:4:\"4374\";i:57;s:4:\"1859\";i:58;s:4:\"3057\";i:59;s:5:\"10152\";i:60;s:4:\"1593\";i:61;s:4:\"9708\";i:62;s:4:\"9205\";i:63;s:4:\"3267\";i:64;s:5:\"12951\";i:65;s:4:\"2705\";i:66;s:4:\"3404\";i:67;s:4:\"5347\";i:68;s:4:\"3071\";i:69;s:4:\"5750\";i:70;s:5:\"11645\";i:71;s:4:\"7128\";i:72;s:4:\"3714\";i:73;s:4:\"7832\";i:74;s:4:\"4575\";i:75;s:4:\"8796\";i:76;s:5:\"11488\";i:77;s:4:\"3382\";i:78;s:4:\"3410\";i:79;s:4:\"6866\";i:80;s:4:\"3383\";i:81;s:4:\"2177\";i:82;s:4:\"2764\";i:83;s:4:\"6093\";i:84;s:4:\"2671\";i:85;s:4:\"4007\";i:86;s:4:\"3756\";i:87;s:4:\"3884\";i:88;s:4:\"7199\";i:89;s:4:\"1710\";i:90;s:4:\"7667\";i:91;s:4:\"4788\";i:92;s:4:\"4579\";i:93;s:5:\"15191\";i:94;s:4:\"3922\";i:95;s:4:\"3859\";i:96;s:4:\"2014\";i:97;s:4:\"4201\";i:98;s:4:\"3266\";i:99;s:4:\"2089\";}s:13:\"sql_LastMulti\";s:65:\"action=list_LISTSOMERESOURCES_CORE&method=yearProcess&id=MjAwNQ==\";s:13:\"bookmark_View\";s:5:\"multi\";s:14:\"sql_ListParams\";a:1:{i:0;s:21:\"Year:  2005\";}s:16:\"browse_LastOrder\";s:7:\"creator\";s:18:\"browse_LastAscDesc\";s:4:\" ASC\";s:13:\"browse_Method\";s:11:\"yearProcess\";s:9:\"browse_Id\";s:8:\"MjAwNQ==\";s:18:\"browse_PagingTotal\";i:464;s:18:\"browse_PagingStart\";i:0;s:13:\"basket_AllIds\";b:0;s:18:\"ideasbasket_AllIds\";a:0:{}}');

Duplicate entry '040ecdc6-281c-426e-9686-81dfce55738d' for key 'PRIMARY'