下面是我要做的:
按如下方式运行SQL查询:
SELECT * FROM `wp_posts` WHERE `post_status` = \'publish\' AND `post_type` = \'post\' GROUP BY `post_author` ORDER BY `post_date` ASC LIMIT 100
以上内容将为您提供发布帖子的前100位作者。或:
SELECT * FROM `wp_posts` WHERE `post_status` = \'publish\' AND `post_type` = \'post\' ORDER BY `post_date` ASC LIMIT 100
这将为您提供前100篇已发布的帖子