Making Milos’s comment into an answer…. The problem you are facing is the result of many wordpress template oriented functions expect some global variables. In WP_Query based loops setting those variable is done by calling the the_post() method of the WP_Query object, but with get_posts you need to call setup_postdata() for that. My personal preference … Read more
The $wpdb object is part of WordPress, so wouldn’t be loaded into a standalone PHP page as it is into a WordPress template. You might want to look into creating your own page templates, then you could run your database query as part of that page template. As a side note: You are currently trusting … Read more
The date format is incorrect. I’m not sure how you have stored the date, but the format you’ve used in the query, date(“MM d yy”) outputs ‘MarMar 07 1212’. It shouldn’t really matter that the input is being done by jQuery datepicker: The input should be in a pre-specified format – so you can interpret … Read more
Zlatev meta_key is the name of the custom post type, and is a VARCHAR(255) meta_value is the value of the key, and is a longtext With your query you are not ordering by values, but by the name of the field. The query works for _thumbnail_id because you are using LEFT JOIN and the CPT … Read more
This should do the trick for you. This shows what template file is stored in post_meta, if one has been selected in the admin panel: $template_name = get_post_meta( $the_query->post->ID, ‘_wp_page_template’, true ); If you want to see if the page is the homepage, use is_home() or is_front_page(). If you want to see what files are … Read more
get_posts() uses the WP_Query class to fetch posts. Usually, it returns an array of post objects. The $fields parameter for WP_Query accepts two valid arguments: ‘ids’ will make it return an array of post IDs and ‘id=>parent’ will make it return an associative array with the post objects properties as key => value pairs. Any … Read more
Try this one with additional join on metadata SELECT u.ID, u.display_name FROM wp_users u LEFT JOIN wp_usermeta um1 ON u.ID = um1.user_id LEFT JOIN wp_usermeta um2 ON u.ID = um2.user_id WHERE um1.meta_value=”value1″ AND um1.meta_key = ‘key1’ AND um2.meta_key = ‘keyA’ AND um2.meta_value=”valueA” GROUP BY u.ID Also use group by
I want to suggest you another approach. You can set a meta when you saving a post if its content is less than 140 chars, so then you can simply runs a simple meta query. add_action( ‘save_post_post’, function( $id, $post ) { if ( $post->post_status !== ‘publish’ ) { return; } if ( strlen( $post->post_content … Read more
Needed to enter correct date format: Ymd or yyyy-mm-dd.
I wouldn’t say it’s not “normal”, but it’s above typical. The common minimum of queries would go like: main query (set of posts) functionality (menus, widgets, etc) data (terms and such) On a WP test data that would make something under 50 queries on home page. With object cache it will fall under 10 on … Read more