You can use WP_Query to create your custom loop, and then use the offset parameter to skip the posts in the previous loop. You are going to run 3 loops from one query, so all you need to do to rerun the query is to use rewind_posts() after each loop to reset the loop Here … Read more
Filter wp_unique_post_slug. Make sure to add the callback with 6 as last argument to get the original slug. Then create a new unique slug as you need it, you get a lot of context information. add_filter( ‘wp_unique_post_slug’, function ( $slug, $post_ID, $post_status, $post_type, $post_parent, $original_slug ) { // create a new unique slug based on … Read more
You can gather the post id(s) from the first loop in an array and then use post__not_in arg in the second loop. $exclude = array(); if ( have_posts() ) : while ( have_posts() ) : the_post(); //first loop $exclude[] = get_the_ID(); … //second loop $second_loop_args = array( ‘showposts’ => 3, ‘post_type’ => ‘post’, ‘category_name’ => … Read more
I’m not entirely sure you can do this with a single query in MySQL as you can’t delete from tables which you reference in a sub-query. I would actually recommend doing this using wp-cli and using the WordPress API to delete the duplicate posts (which will also delete any post meta and associated term references): … Read more