I guess you want it to know in which article you need to edit and add featured image. You can create some file in the worpdress root folder and just use WP_Query to get all the posts and to check if there is no feature image you can use the has_post_thumbnail(). Change the post_type if … Read more
You can use ORDER BY rand(), but it’s a very heavy query as a temporary table is created for it. A WC_Product_Query or a WP_Query could be a good alternative to WPDB custom query. Both support ‘orderby’ => ‘rand’,…
There’s indeed a WordPress function for counting posts: wp_count_posts(). So you can do something like: $memo_count = wp_count_posts( ‘memo’ )->pending;
With the help of @toscho pointing out get_post();, I was able to spit out a .csv with a blank template. At first, I had memory limit issues b/c of the amount of data, so I moved the site locally and was able to get everything I need with the get_post(); This is the gist of … Read more
I’ll guess that $wpdb->specials isn’t giving you what you expect. custom tables have to referenced like $wpdb->prefix . ‘specials’
You need to join the post_meta table twice to the posts table, once for each meta value: SELECT p.ID id, p.post_title title, country.meta_value country, region.meta_value region FROM {$wpdb->posts} p JOIN {$wpdb->postmeta} country ON p.ID = country.post_id AND country.meta_key = ‘search_country’ JOIN {$wpdb->postmeta} region ON p.ID = region.post_id AND region.meta_key = ‘search_region’ WHERE p.post_status=”publish” AND p.post_type=”films” … Read more
I think your first partial code be this partial code: $wpdb->prepare( “SELECT * … from … WHERE ( post_title LIKE ‘%%%s%%’ or post_content LIKE ‘%%%s%%’ )…, $string, $string ); You have to have to pass the same number of arguments into the query as you specify (with %s) in it.
“My SQL doesn’t work” questions are difficult because they are nearly untestable without having the OP’s dataset, but… I think you may be making this too complicated. SELECT DISTINCT (p.ID), p.post_title FROM wp_posts p JOIN wp_postmeta pm1 ON p.ID = pm1.post_id JOIN wp_postmeta pm2 ON p.ID = pm2.post_id WHERE 1 = 1 AND p.post_type=”game” AND … Read more
The problem is that you can’t use the value for the LIKE comparison as you’ve mentioned. The generated SQL will look something along the lines of: AND CAST(wp_usermeta.meta_value AS CHAR) LIKE ‘%B%’ which means that the query is set to look for every occurrence of letter B in our case. Of course this is not … Read more
You don’t need SQL, and shouldn’t use it when Core functions will do the job. Part of the reason why is the complexity of the tables (and the fact they might change). Query your users, loop through pulling metadata, and update Proof of concept: $u = new WP_User_Query( array( ‘role’ => ‘customer’ ) ); foreach … Read more