You have to use the posts_orderby filter to do this at the mo, eg function wpse159469_posts_orderby( $orderby, $query ) { return implode( ‘ DESC,’, explode( ‘,’, str_replace( array(‘ ASC’, ‘ DESC’ ), ”, $orderby ) ) ) . ‘ DESC’; } then around your query: add_filter( ‘posts_orderby’, ‘wpse159469_posts_orderby’, 10, 2 ); $query = new WP_Query( … Read more
You can try: ‘date_query’ => array( array( ‘year’ => date( ‘Y’ ), ‘week’ => strftime( ‘%U’ ), ), ), where %U is: Week number of the given year, starting with the first Sunday as the first week or ‘date_query’ => array( array( ‘after’ => strtotime( ‘last Sunday’ ), ), ),
WP_Query is an object not an array. Needed to use $query->posts For anyone interested I found a better way to attack this problem. Performing the second query with the OR statements and outputting to an array of post ID’s allowed me to filter the original query based off that list.
Perhaps using SQL statement? Direct SQL queries are very dangerous, especially when updating the DB. At the very least you will get any object cache out of sync and you might miss execution of import action and filters. If this update is something that is rarely done it is better that it will take one … Read more
SELECT * FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id) LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id) LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) LEFT JOIN $wpdb->terms ON($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id) WHERE $wpdb->posts.post_type=”post” AND $wpdb->term_taxonomy.taxonomy = ‘post_tag’ AND $wpdb->posts.ID > 160 ORDER BY $wpdb->posts.ID ASC LIMIT 5 $pageposts = $wpdb->get_results($querystr); if ($pageposts): ?> <?php global $post; ?> <?php … Read more
Stupid typo I’m afraid. This: array ( ‘key’ => ‘ys_product_start’, ‘value’ => date(‘Ymd’), ‘compare’ => ‘>=’ ), array ( ‘key’ => ‘ys_product_end’, ‘value’ => date(‘Ymd’), ‘compare’ => ‘<=’ ) Should be like this: array ( ‘key’ => ‘ys_product_start’, ‘value’ => date(‘Ymd’), ‘compare’ => ‘<=’ ), array ( ‘key’ => ‘ys_product_end’, ‘value’ => date(‘Ymd’), ‘compare’ => … Read more
EXPLANATION As mentioned in my update above, to retrieve the ID of a thumbnail the get_post_meta function can be used without any additional DB overhead. The ‘normal’ way to get the url to a thumbnail id is with wp_get_attachment_image_src or similar functions, but those do not accept an array of IDs. What i noticed using … Read more
As per wordpress codex, the_post() “Iterate the post index in The Loop. Retrieves the next post, sets up the post, sets the ‘in the loop’ property to true.” This all occurs within the post object itself. If you only have 1 post, and run the_post twice, you’ll reach the end of the post count. In … Read more
A modified version of the suggestion from @birgire works. Note that this applies to the core/post-template block, not the core/query block. add_filter(‘block_type_metadata_settings’, function ($settings, $metadata) { if ($metadata[‘name’] !== ‘core/post-template’) { return $settings; } if ($settings[‘render_callback’] !== ‘render_block_core_post_template’) { return $settings; } $settings[‘render_callback’] = ‘wpse_render_block_core_post_template’; return $settings; }, 10, 2); function wpse_render_block_core_post_template($attributes, $content, $block) { … Read more
For multiple post IDs, in WP_Query arguments, we can use: ‘post__in’ => [ 272, 282, 292 ], but for a single post ID it’s: ‘p’ => 123, Note that the default post type is post. Checking out the SQL query It’s informative to checkout the generated SQL query of WP_Query. Try e.g. in the wp-cli … Read more