Honestly, the time writing this question and waiting for an answer, is longer than just going into screen options, setting the posts to about 200, and just doing bulk move to trash, and emptying the trash – if you speed is high, you can probably do even more than 200.
else there is a nice tutorial on how and which tables you should work with here – but it will probably take longer
http://www.tripwiremagazine.com/how-to-effectively-bulk-delete-many-posts-in-wordpress/
Related Posts:
- modify all posts of a category to “no comments allowed”
- What does this PHP function code mean? [closed]
- Restrict custom post type to only site administrator role
- Linking Two Post Types
- How to force one column layout on custom post type edit page?
- Why is the »_builtin« parameter not advised in »register_post_type()« for custom post types?
- Showing current taxonomy terms
- automatically create taxonomy with same name as post title
- How do I write this SQL statement for Posts written in last 24 hours?
- Assigning a role to a specific custom post type (and ignoring other post types)
- Display posts in random post types
- Custom Post Type by user
- saving custom post type data to different table in wordpress
- Query post types with multiple keys
- [Plugin: Posts 2 Posts] Changing display order of connections
- same archive template for different custom post
- Get all posts WHERE custom_field is LIKE value
- Get the post children count of a post
- How to delete all posts from a custom post type?
- Check Title Unique Or Not and If not error message and dont save
- Remove All, Published and Trashed Post Views in Custom Post Type
- How to post twitter like updates on wordpress
- Show Two custom Post type and their posts on category page
- apply filters only to specific post listing without check the url parameters
- Custom post type and body_class: Remove “blog” class
- Is there a way to have the view link on manage posts page to open in a new window or tab?
- Display only one post each WEEK
- List custom taxonomy specific to one custom post type
- Meta query for custom post type ignored in main query
- Show titles, date of all posts on single category page
- Update postmeta Parent when post_status child change
- Allow users to create posts without logging in?
- How to sort posts in a custom post type by title in ascending order by default?
- Get_the_terms restrict output
- Custom post type menu
- YOAST SEO won’t work on custom post type archive [closed]
- Separate Content from gallery (custom post type)
- WordPress Count posts within a custom post type
- Custom post type tags not showing in search
- $wpdb is queried but results don’t show
- How set template for “custom post type” individual post
- Why doesnt my tag page populate with this custom post type?
- Why is my custom post content only viewable when signed into WordPress?
- Adding specific custom fields (images) to post excerpt
- Limit posts per page depending on the size of a div?
- Delete Post by User
- Post that populates itself (almost) automatically using data from imported excel file
- creating a custom post template
- Problem to get the link of the default ‘post’ post type like the orther custom types
- One Post with different content, depending on a Page
- Custom Post Type
- Display all post types together
- Turn post into simple slideshow
- Query multiple post of which one by taxonomy
- How to make a template for a specific post of a custom post type?
- How to delete unnecessary custom post types in the UI
- How to create a job post by email parsing? [closed]
- show posts under custom post type with same autj
- How to automate the creation of advanced layout article/post
- display posts, pages and custom post types from another wordpress site
- is therer any wordpress function to retrieve a specific html element from post content
- How to develop Knowledge center in WordPress Website
- How to get post content by calling ajax?
- Get category id from post id of a custom post type
- Limit widget to a specific registered sidebar
- WP_List_Table Inside Metabox Not Working on Submit
- Delete all the custom post types when deleting user
- Correct way to use a form to to filter custom posts by taxonomy terms?
- How can I remove categories in menu in custom post type?
- Remove Post Page “View Post” Link
- How does the $post_type global variable work?
- Insert post metadata for all posts in CPT at once if metadata no existent
- Restrict custom post type from appearing with ?post_types=
- Shortcode not working with post counter
- Changing default ‘posts’ parameters with register_post_type_args
- Check post on publish for blank title
- Including link to custom post type in ‘wp_list_pages’ function
- Custom post types and ‘new WP_Query’
- Showing custom post type categories in the menu
- Displaying a custom post type using get_template_part into a specific layout
- WordPress as a frontend website for iOS app [closed]
- How can I make custom static widgets/areas on my homepage?
- How to import database table as custom post type and custom fields?
- custom comment fields on CPT
- Use Gravity Forms and a Shopping Cart for output to Freshbooks for an Estimate [closed]
- Setting Parent Page to Post
- Is it possible to get the specific content on the search page?
- Search for custom field input of a custom post type in ajax live search
- wp_set_object_terms creates taxonomies but does not add custom posts to it
- Custom Post Type and Structure Question
- How to create editable sections in wordpress?
- Instructor can view, edit, delete only theirs courses
- Widget area for individual posts (custom post type)?
- Link two different post using there post_id in post meta
- How to Associate Posts with Pages
- Delete attachment with post
- Get link for feed of specific post type AND taxonomy
- Why are my wp urls showing page not found?
- How do I display the index position of a post from a custom post type?
- Two pagination in one page without AJAX