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 show related posts by category
- How to allow hidden custom fields to be added from wp-admin/post.php?
- Display all posts from specific categories on a page
- How to exclude latest x posts from a paginated query?
- Display content from a specific category
- How to batch update post content with custom post meta value
- Number of posts per page setting is not working?
- WordPress Posts Out Of Order after 3.1 Update
- Order post by year DESC and month ASC
- WordPress get posts by date without query_posts
- Does WP get all post_meta on POST page?
- Sanitizing `wp_editor();` Values for Database, Edit, and Display
- Featured Posts for Category Pages
- Function to show random posts from a category
- Hiding posts in a list from specified categories
- PHP Notice error (when on 404 page)
- How to permanently delete a post meta entry?
- Improving WP_Query for performance when random posts are ordered
- Modify WP_Post before processing
- Create dropdown list post
- 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 can I sort posts by the date and a custom meta field?
- Get Meta Key Value While Saving Post
- Display all posts that were published before full post on single.php
- Blog post per page setting conflicting with custom WP_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
- 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?
- Display an author’s posts on his own author page
- 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
- Order posts alphabetically: how to set order=asc in mysql query?
- How to order posts in an arbitrary order?
- How to get posts from a current post’s month?
- Wrong post title displayed from loop
- WordPress query_posts by tag doesn’t work anymore(?)
- While loop articles – if statement order
- do more action after I publish a post
- Retrieve only posts from a specific user in wp-admin/edit.php
- WordPress website loads more posts than expected
- Get the amount of posts on a current page
- How to calculate the average of a post meta value(Numeric) of a specific author
- query post limits
- Display Posts with template on a Page
- How to get posts published on the latest date?
- wpColorPicker – problem with implementation to post meta
- How to check in functions.php if there is data in a WP_Query?
- Shortcode with ‘year’ parameter
- Post Filtering by GET URL parameters
- On what hook can I get the queried object’s final state?
- Get the most recently modified post date of most recently modified post
- Get post by tag
- All categories displays the same posts
- Add multiple meta keys to a post at once
- Query function not executed between element [closed]
- Echo the number of posts being displayed
- Exclude a category of posts in author template
- Display specific posts on home page
- The loop starting at a certain ID
- Simple Custom Metabox Not Saving
- WP_Query articles order by offset in collumns
- Getting posts from some categories plus some individual posts
- Get posts from current category?
- Move position in post list for a custom checkbox column
- How to merge the content of posts that have the same title?
- How to bulk Update URLs to new values?
- SQL DELETE multiple post_meta on single and multi-sites
- How to retrieve all meta data directly from the $post object? Such as $post->related_topics?
- Automatically select template based on query string for New Posts
- wp_query args with relation
- WP_Query sort by meta_value_num or date
- Querying posts from current category, using a variable as array argument
- Use special template for the first post in the loop
- Repeating post how to solve this
- Creating Ordered Query using Meta_key
- Best Way to detect unique posts in wp rest api
- Add a meta to a post submited from a frontend form
- Need help writing loop to display posts by categories in separate divs
- Query post category & remove any post id
- show latest authors blog post
- Run function after post is updated
- Where should get_post_meta() go to get $post->ID get_post_meta() is empty and $post->ID & get_the_id() are working
- How to limit the number of results for all query_posts on mysite
- wp_query select if have comments
- Creating pages and getting their values from the database table
- How to limit post query to only return a total count of items with certain post statuses?
- Not displaying any articles on a custom made file
- NewsPaper WP Theme – Additional Related Posts Filter by Time (divTag composer)
- What effect can a large wp_post table have on overall site performance?
- Sort Posts Alphabetically Based on Specific Category (Divi)
- How to make internal links creating plugin to respect ACF?
- How to change url of posts?