EXPLAIN not possible on query: SELECT i.*, c.alias as categoryalias FROM u2tdi_k2_items as i
LEFT JOIN u2tdi_k2_categories c ON c.id = i.catid
WHERE i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-09-29 03:10:10' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-29 03:10:10' ) AND i.access IN(1,1) AND i.language IN('en-GB', '*') AND i.trash = 0
AND c.published = 1 AND c.access IN(1,1) AND c.language IN('en-GB', '*') AND c.trash = 0
AND (i.id) IN (264,256,267,282,288,294,296,301,310,323,329,332,345,346,350,353,371,379,392,414,434,440,443,452,502,514,515,521,526,532,533,538,561,569,573,581,587,608,613,642,647,654,681,686,701,705,709,720,725,736,739,756,788,801,802,803,806,819,823,837,856,861,887,891,908,913,935,937,941,947,950,953,959,964,969,972,1012,1087,1137,1195,1198,1282,1301,1367,1549,1558,1593,1606,1688,1697,1698,1728,1742,1752,1755,1766,1829,1837,1842,1849,1860,1875,1892,1898,1903,1904,1905,1943,1956,1958,1964,1975,1992,1993,2011,2019,2058,2078,2091,2092,2095,2116,2129,2140,2160,2319,2456,2634,2680,2693,2873,2898,2915,2940,2952,2969,2974,2988,3013,3030,3040,3042,3053,3066,3074,3123,3136,3148,3181,3215,3235,3250,3284,3298,3313,3328,3341,3350,3360,3378,3456,3457,3474,3492,3504,3525,3536,3541,3554,3571,3594,3612,3688,3720,3754,3760,3775,3841,3894,3997,4102,4138,4168,4221,4234,4247,4261,4284,4316,4326,4344,4358,4376,4381,4398,4428,4438,4455,4465,4503,4514,4525,4538,4610,4620,4621,4630,4677,4692,4694,4712,4718,4730,4742,4783,4801,4813,4829,4842,4855,4873,4904,4905,5033,5099,5102,5152,5258,5306,5317,5321,5332,5344,5353,5367,5369,5377,5378,5383,5423,5532,5534,5542,5555,5557,5566,5567,5570,5571,5576,5600,5618,5629,5650,5663,5673,5685,5698,5710,5784,5820,5910,5952,5953,6059,6117,6257,6275,6279,6339,6354,6364,6387,6407,6422,6439,6440,6451,6471,6483,6503,6509,6511,6526,6531,6538,6549,6586,6591,6603,6632,6645,6655,6669,6680,6693,6720,6726,6752,6762,6778,6847,6862,6875,6885,6932,7039,7056,7099,7122,7130,7141,7158,7178,7185,7211,7225,7252,7257,7294,7309,7311,7316,7346,7362,7433,7436,7454,7555,7587,7602,260,280,290,330,336,341,376,442,455,490,503,513,527,540,546,560,586,616,621,653,679,707,712,716,730,743,754,826,828,840,844,892,903,904,907,911,938,949,1065,1232,1284,1610,1624,1627,1639,1647,1669,1699,1702,1721,1733,1740,1758,1791,1843,1864,1873,1880,1897,1913,1922,1945,1959,1979,1996,2061,2077,2113,2133,2146,2152,2153,2173,2181,2197,2199,2212,2220,2238,2251,2445,2526,2564,2744,2745,2802,2843,2906,2921,2932,2935,2946,2973,2992,3011,3037,3065,3125,3155,3169,3182,3216,3226,3231,3246,3263,3280,3295,3323,3358,3368,3460,3473,3489,3501,3600,3616,3622,3624,3626,3644,3645,3653,3655,3674,3675,3748,3845,3896,3990,4297,4313,4353,4373,4375,4380,4385,4403,4432,4442,4461,4492,4508,4524,4536,4547,4560,4627,4641,4654,4671,4682,4691,4708,4743,4759,4789,4810,4826,4837,4851,4900,5039,5191,5222,5242,5261,5298,5318,5320,5331,5347,5351,5384,5402,5479,5496,5563,5615,5623,5639,5649,5660,5671,5683,5695,5738,5747,5840,5844,5852,5861,5868,5873,5876,5960,5972,6026,6053,6127,6142,6216,6261,6273,6288,6316,6361,6365,6374,6385,6393,6404,6424,6446,6457,6478,6479,6487,6507,6519,6523,6556,6564,6574,6589,6596,6616,6620,6633,6643,6664,6677,6687,6696,6788,6793,6836,6951,7019,7052,7127,7146,7155,7159,7177,7192,7200,7204,7215,7217,7228,7233,7249,7261,7269,7270,7283,7310)
ORDER BY i.created DESC LIMIT 0, 3