SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM p4_blog_index idx JOIN p4_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN p4_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' AND idx.itemID IN (597, 579, 580, 577, 533, 553, 541, 532, 513, 480, 498, 490, 478, 460, 456, 438, 416, 342, 379, 340, 311, 310, 309, 94, 14, 15, 1324, 1323, 1316, 1301, 1281, 1265, 1254, 1256, 1249, 1240, 1224, 1210, 1201, 1200, 1185, 1180, 1179, 1177, 1178, 1176, 1171, 1156, 1157, 1136, 1126, 1116, 1114, 1085, 1108, 749, 1089, 1074, 1050, 1057, 1045, 1007, 988, 968, 956, 964, 954, 965, 967, 953, 952, 943, 923, 904, 884, 856, 854, 824, 845, 831, 844, 796, 795, 805, 816, 799, 797, 775, 750, 732, 710, 681, 668, 667, 627, 660, 658, 657, 620, 648, 616, 635, 1134, 1331, 1340, 1341, 1351, 1352, 1353, 1354, 1356, 1362, 1372, 343, 378, 447, 468, 479, 617, 636, 644, 783, 876, 1399, 1406, 1422, 1430, 1109, 1441, 1446, 1460, 1466, 1474, 1481, 1488, 1509, 1524, 1547, 1558, 1563, 1594, 1595, 1603, 1605, 1615, 1626, 1645, 1647, 1653, 1654, 1158, 1661, 1673, 1703, 1707, 1720, 1727, 1738, 1744, 1751, 1763, 1801, 1802, 1788, 1773, 1782, 1795, 1804, 1805, 1806, 1807, 1808, 1826, 1827, 1828, 1829, 1838, 1841, 1861, 1876, 1901, 1903, 1910, 1911, 1912, 1920, 1921, 1922, 1923, 1924, 1925, 1960, 1961, 1967, 1973, 1981, 1987, 1989, 2001, 2003, 2004, 2006, 1304, 2009, 2011, 936, 2040, 2063, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2080, 2081, 2082, 2083, 2085, 2087, 2088, 2089, 2090, 2091, 2092, 2093, 2094, 2095, 2096, 2098, 2100, 2101, 2102, 2104, 2112, 2133, 2134, 2141, 2144, 2157, 2151, 2172, 2173, 2180, 2192, 2194, 2202, 2206, 2212, 1261, 2220, 2234, 2235, 2242, 2253, 2262, 2263, 2278, 2291, 2292, 2324, 2325, 2331, 2334, 2349, 2373, 2395, 2417, 2418, 2429, 2438, 2439, 2446, 2447, 2475, 2477, 2488, 2492, 2493, 2515, 2529, 2553, 2571, 2590, 2599, 2601, 2614, 2623, 2626, 2628, 2631, 2632, 2635, 2641, 2642, 2644, 2646, 2648, 2650, 2651, 2652, 2654, 2655, 2658, 2664, 2667, 2668, 2671, 2676, 2678, 2681, 2683, 2689, 2690, 2691, 2694, 2695, 2698, 2703, 2704, 2716, 2720, 2722, 2723, 2725, 2727, 2732, 2734, 2736, 2742, 2743, 2746, 2751, 2754, 2756, 2757, 2759, 2769, 2770, 2773, 2774, 2777, 2779, 2783, 2788, 2789, 2791, 2793, 2794, 2795, 2797, 2799, 2803, 2809, 2813, 2814, 2818, 2822, 2824, 2829, 2832, 2835, 2837, 2845, 2851, 2853, 2856, 2857, 2858, 2860, 2867, 2871, 2880, 2885, 2886, 2887, 2908, 2909, 2910, 2915, 2919, 2922, 2923, 2929, 2933, 2937, 2944, 2945, 2947, 2949, 2953, 2954, 2957, 2958, 2964, 2966, 2967, 2971, 2975, 2976, 2983, 2984, 2985, 2986, 2987, 2988, 2990, 2991, 2992, 2995, 3005, 3012, 3013, 3016, 3017, 3018, 3019, 3020, 3021, 3022, 3023, 3024, 3025, 3026, 3028, 3029, 3030, 3032, 3035, 3039, 3042, 3043, 3044, 3053, 3058, 3060, 3062, 3064, 3067, 3069, 994, 3070, 3072, 3074, 3075, 3076, 3077, 3080, 3082, 3084, 3085, 3088, 3092, 3093, 3096, 3097, 3098, 3100, 3104, 3107, 3108, 3112, 3113, 3114, 3120, 3121, 3123, 3126, 3130, 3132, 3133, 3134, 3143, 3144, 3147, 3148, 3149, 3150, 3152, 3153, 3154, 3155, 3156, 3157, 3158, 3159, 3160, 3164, 3165, 3166, 3167, 3168, 3169, 3170, 3172, 3174, 3175, 3177, 3179, 3180, 3181, 3183, 3186, 3187, 3189, 3191, 3193, 3195, 3196, 3198, 3199, 3205, 3208, 3209, 3212, 3216, 3219, 3220, 3221, 3223, 3225, 3229, 3230, 3231, 3233, 3237, 3238, 3239, 3241, 3242, 3244, 3245, 3246, 3253, 3255, 3257, 3260, 3263, 3268, 3272, 3274, 3275, 3277, 3278, 3279, 3281, 3282) WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2026-11-02 21:04:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 24