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 (587, 556, 555, 502, 503, 512, 501, 481, 477, 459, 458, 453, 433, 421, 377, 376, 375, 350, 318, 274, 273, 148, 140, 118, 110, 95, 6, 32, 31, 3, 33, 36, 37, 38, 39, 40, 41, 42, 44, 46, 47, 48, 49, 45, 1262, 1232, 1034, 1029, 981, 983, 944, 893, 892, 784, 786, 785, 806, 782, 773, 756, 645, 693, 647, 646, 656, 619, 618, 608, 609, 1339, 1278, 1349, 1363, 1379, 1380, 1381, 1415, 1453, 1473, 1522, 1580, 1631, 1691, 1692, 1693, 1694, 1735, 1813, 1857, 1873, 1931, 1988, 1994, 2054, 2130, 2132, 2152, 2213, 2252, 2327, 2364, 2370, 2383, 2385, 2386, 2392, 2419, 2467, 2468, 2495, 2496, 2532, 2542, 685, 3086, 3115) 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:41:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 24