Yes it is, and to also sort by the post title, you would just need to add , {$wpdb->posts}.post_title <ASC or DESC> after the FIELD(), like so which results in a clause that looks like ORDER BY FIELD(wp_posts.post_type, <types>), wp_posts.post_title ASC: // Replace this: return $orderby = “FIELD( {$wpdb->posts}.post_type,” . $post_type__in_string . ‘ )’; // … Read more
The problem is that you’re trying to do your work in a stand alone PHP, this will always be fragile, and it poses a security risk! Use a Cron Job Instead This will trigger your code to run hourly: add_action( ‘init’, function() { // If the cron job hasn’t been scheduled if ( ! wp_next_scheduled … Read more
I have finally found a solution and for anyone interested, here is the working code : <?php // The Query if (is_tax() || is_category() || is_tag() ){ $qobj = $wp_query->get_queried_object(); // concatenate the query $args = array( ‘post_type’ => ‘houses’, ‘posts_per_page’ => -1, ‘orderby’ => ‘title’, ‘order’ => ‘ASC’, ‘tax_query’ => array( array( ‘taxonomy’ => … Read more
The documentation for WP_Query indicates that ordering by meta value is limited to one meta key and requires the meta_key parameter (untested): $results = new WP_Query( array( ‘meta_key’ => ‘wpcf_catalogue_number’, ‘orderby’ => array( ‘meta_value_num’ => ‘ASC’, ), ) ); If you want additional sorting, you’ll need to sort the result ($results->posts) using PHP (untested): $sort__formats … Read more
If the date query doesn’t work because of modified post dates (e.g. if the posts’ timeline is no longer linear), here’s a posts_where filter’s suggestion (untested): add_filter( ‘posts_where’, function( $where, $query ) use ( &$wbdb ) { $id = $query->get( ‘_id__gt’ ); if( is_int( $id ) && $id > 0 ) { $where .= $wpdb->prepare( … Read more
I believe you could use NOT IN for the operator to achieve this along with switching some of the relations from ORs to ANDs. array ( ‘taxonomy’ => ‘plant_category’, ‘field’ => ‘name’, ‘terms’ => ‘Popular (home)’, ‘operator’ => ‘NOT IN’, ),
Ok, I think your iterations were off… You start the count at 0, so while you have the posts from 1 o 7 in the picture, you’re actually working with 0 to 6. So I re-wrote it with greater than and less than comparisons in the if and elseif conditions. <?php function three_column_sc($atts){ ob_start(); ?> … Read more
The simplest solution is to get all the existing rewrite rules, match the requested URl to one of them, and then convert it into a query. Like so: // Get all the rewrite rules global $wp_rewrite; $url_path = “2020/04/test-post”; // Or “tag/whatever” or “feed/atom” etc // Match the URL against WordPress rewrite rules $rewrite_rules = … Read more
They are all convoluted ways of saying the same thing. Syntax 1 is the least efficient method, purely because it takes longer to type and uses unnecessary IN clauses when a single clause will do. All 3 syntaxes are asking WP for posts that have been assigned to both category 76 and 78 Note that … Read more
Here’s a suggestion using posts_orderby filter and CASE, UNIX_TIMESTAMP and DATEDIFF (that outputs number of days) from MySQL for conditional SQL ordering: add_filter( ‘posts_orderby’, function( $orderby, $q ) use (&$wpdb) { if( ! $q->is_main_query() ) { return $orderby; } return $wpdb->prepare( ‘CASE WHEN DATEDIFF( %i.post_date, NOW() ) <= 14 THEN -UNIX_TIMESTAMP( %i.post_date ) ELSE %i.post_title … Read more