Here is what I would do:
Run an SQL query like so:
SELECT * FROM `wp_posts` WHERE `post_status` = 'publish' AND `post_type` = 'post' GROUP BY `post_author` ORDER BY `post_date` ASC LIMIT 100
The above will give you the first 100 authors to have a post published. or:
SELECT * FROM `wp_posts` WHERE `post_status` = 'publish' AND `post_type` = 'post' ORDER BY `post_date` ASC LIMIT 100
this will give you the first 100 published posts
Related Posts:
- is there a way to show the the post title after the image?
- wp_query with ajax
- How to get only current images of a post
- Ordering posts alphabetically by meta keys and title
- Keep featured content post in homepage with original order
- How to get posts published between a date and today?
- How to check if post meta key exists or not in wordpress database
- How to show related posts by category
- How to add category to: ‘wp-admin/post-new.php’?
- the_author() returns empty string
- How can I retrieve multiple get_post_meta values efficiently?
- Code to make a post sticky
- How to allow hidden custom fields to be added from wp-admin/post.php?
- Display all posts from specific categories on a page
- Export WordPress Posts and Meta Information in CSV format
- Delete duplicated wp_postmeta record
- How to exclude latest x posts from a paginated query?
- Will a large postmeta table slow a site down?
- Update all posts automatically when using post_meta
- Display content from a specific category
- How to display posts by current user/author in a custom page template?
- post_name empty after wp_insert_post
- How to batch update post content with custom post meta value
- Query posts distinct authors
- Change slug with custom field
- How to get previous 10 days post from a specific date – WP Query
- Number of posts per page setting is not working?
- Better post meta efficiency?
- WordPress Posts Out Of Order after 3.1 Update
- Setting post meta data to random value during post status transition / on publish
- Query only Posts from Both of Two Category?
- Insert custom div between posts
- Edit meta data does’t work with custom sql
- Can’t show comments count per post outside loop
- Only display posts with comments
- Human Time Diff, change mins to minutes
- Order post by year DESC and month ASC
- Change post format using custom field
- WordPress get posts by date without query_posts
- How to Display Post View Count
- Does WP get all post_meta on POST page?
- Different amount of posts on homepage than paged pages
- Sanitizing `wp_editor();` Values for Database, Edit, and Display
- Exporting Data from WordPress into a flat table
- Adding Multiple Values to a Post Meta Key
- Featured Posts for Category Pages
- Using radio button meta data from a custom meta box
- Cannot Update A Post, 404 Error
- Function to show random posts from a category
- Hiding posts in a list from specified categories
- How would I get 1 latest post from a query for 5 posts?
- PHP Notice error (when on 404 page)
- What Is meta_id In wp_postmeta?
- Filter Posts By Tag
- Can I set and show “important” post in my blog?
- Checking if a post with certain meta value exists
- Exclude posts with empty post_content in wp_query
- How to permanently delete a post meta entry?
- Add custom field automatically (add_post_meta) with value based on number of words of article
- How to generate numbers indistinguishable for the IDs of the posts
- Improving WP_Query for performance when random posts are ordered
- Modify WP_Post before processing
- Save re-arranged draggable post items to wordpress database
- Create dropdown list post
- Change post_date to post_modified date on post template?
- previewing my posts on static page?
- Exclude newest post from category X but show rest
- Reset Popular post query?
- Converting a dynamic piece of code using WordPress Loop into a static one using Post ID
- Inserting custom data to the_post() during loop
- How To Get Posts With A Specific Word
- Why WP_Query(‘showposts=5’) shows only 1 post?
- How can I sort posts by the date and a custom meta field?
- Get Meta Key Value While Saving Post
- Display posts with tag that matches current post title
- Why is querying posts messing up my pages?
- Display all posts that were published before full post on single.php
- Category Foreach keeps looping?
- Blog post per page setting conflicting with custom WP_Query?
- How to exclude latest x posts from a paginated query?
- Two loops, one AJAX loop, exclude posts in first loop from second loop, loops are in different files
- Force the “Choose from the most used tags” meta box section to always be expanded
- Meta value does not save for scheduled posts
- Custom Posts Query and meta_query Sort Order
- Random ajax load only works with posts_per_page set to -1
- How to compare two posts including their meta fields on a scalable base?
- Getting value from get_post_custom
- Display an author’s posts on his own author page
- Calling Different Custom Post Timestamps in a table
- Multi row post list
- Is it possible to paste a link without tags and make it directly a link in a post?
- Cannot retrieve a custom RSS field from posts
- posts_per_page option limits the number of Gallery items
- How to make multiple sections in home pulling posts category wise?
- Saving custom fields to a custom taxonomy
- wp_posts table: safely remove unused columns to save database storage
- Query Posts by Custom Field
- Order posts alphabetically: how to set order=asc in mysql query?
- How to order posts in an arbitrary order?
- How to automate featured posts number? [duplicate]