select

Select posts using @wordpress/data with query based on custom field always returns all records

It appears that REST API doesn’t support all the meta_query parameters that WP_Query does. Only the basic meta queries with some comparison operators are supported. Therefore we need to make one of workarounds to get what we want: Add some REST API Filter to our theme/plugin add_filter(‘rest_{post_type}_query’, function($args, $request) { $params = $request->get_params(); if(isset($params[‘meta_compare’])) { … Read more

Combining two select posts from mysql – to get least viewed posts

This should be the SQL you’re looking for (off the top of my head, so may need some tweaking). “SELECT * FROM wp_posts LEFT JOIN wp_popularpostsdata ON (wp_posts.ID = wp_popularpostsdata.postid) LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE posts.post_type=”post” AND wp_term_taxonomy.term_id NOT IN (73) GROUP BY wp_posts.ID ORDER … Read more

Fetch Post Category

If you want to display and fetch all post categories that have posts associated with them and display them in a dropdown list in the WP admin panel, try below the code add in code to your themes functions.php file or in a custom plugin. function get_categories_with_posts() { // Get all categories that have posts … Read more

+ More
File not found.