First, the author parameter is parsed and appended to the author__in and author__not_in query parameters. Then author__in or author__not_in array is processed. These can be arrays created from author parameter or arrays passed as query parameteres author__in / author__not_in or created from a mergion author parameter with author__in / author__not_in parameters. Parameters author__in and author__not_in … Read more
I strongly suspect the reason you want SQL that you haven’t mentioned/shared, is because you can’t use the WP functions to fetch the posts and do it manually in a single request due to the PHP time execution limit, or you don’t know how to. Sadly, doing it via SQL is no guarantee this will … Read more
Try this. The code has comments where modified. <?php // args $args = array( ‘showposts’ => 5, ‘post_type’ => ‘post’, ‘orderby’ => ‘date’, // ‘order’ => ‘ASC’, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘type_id’, ‘value’ => ‘News’, ‘compare’ => ‘LIKE’ ), ) ); // query $the_query = new WP_Query( $args ); ?> … Read more
You can do this using the WP APIs like this: $args = [ ‘post_type’ => ‘post’, ‘tax_query’ => [ ‘relation’ => ‘AND’, [ ‘taxonomy’ => ‘your_taxonomy_name’, ‘field’ => ‘slug’, ‘terms’ => array( ‘arizona’, ‘speech-language-pathology’ ), ] ], ]; $query = new WP_Query( $args ); Then you can use $query as you would any standard post … Read more
(Revised answer) So after discussing via the comments, what you really need is a custom ORDER BY clause, which in WordPress post queries (WP_Query), you can set the clause via the posts_orderby filter just like you can set custom GROUP BY clause via the posts_groupby filter. The order that I need is June – 2019 … Read more
Try to add the following lines of code at the end of your theme’s functions.php file: function custom_pre_get_posts_query( $q ) { $tax_query = (array) $q->get( ‘tax_query’ ); $tax_query[] = array( ‘taxonomy’ => ‘product_cat’, ‘field’ => ‘slug’, ‘terms’ => array( ‘uncategorized’ ), ‘operator’ => ‘NOT IN’ ); $q->set( ‘tax_query’, $tax_query ); } add_action( ‘woocommerce_product_query’, ‘custom_pre_get_posts_query’ ); … Read more
What about just querying for both terms and increasing the posts_per_page count. $category_query = new WP_Query([ ‘posts_per_page’ => 36, ‘post_type’ => ‘product’, ‘tax_query’ => [ [ ‘taxonomy’ => ‘product_cat’, ‘terms’ => [ 120, 121 ], ‘field’ => ‘id’, ‘include_children’ => false ] ] ]); EDIT: Running a query with more that one term and guarantees … Read more
You will have to pass the year in the args for example: $args = array( ‘year’ => ‘2012’, );
If you look at the wp_query documentation you will see that it is possible to pass multiple arguments as post_type. Like this: ‘post_type’ => array( ‘module’, ‘lessons’ )
It doesn’t make any sense to try and pass a query result to get_page_by_path(). The point of WP_Query is to query for a selection of posts based on given criteria, while get_page_by_path() is for retrieving a single specific post based on its path. There’s no reason you’d need to use them together. If you want … Read more