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' 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-03 00:19:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 144, 24