You can run 2 wp_query, get the ids and pass those as the post__in parameter to a 3rd wp_query. Not efficient but will do the job. Or you can use a subquery and do it all with just one wp_query. Something like the following: add_filter( ‘posts_where’, ‘myprefix_posts_where’, 10, 2 ); new WP_Query([ ‘post_status’ => ‘publish’, … Read more
Recursion using year loop in sql
Theme Check is a tool published by the WP.org Themes team to scan your theme against the wp.org security standards. There’s also one for plugins. Any default functionality like comment forms will already be escaped/sanitized.
It doesn’t. WordPress doesn’t use foreign keys to link tables together that way. There are also lots and lots of other reasons to declare keys and primary keys in a table that have nothing to do with this type of linkage/referencing. For example telling MySQL/MariaDB the ID column is a primary key give critical clues … Read more
WordPress can only use the tables with the same prefix as listed in the wp-config.php file. Many times when a database has been used for sometime it will hold several version of the site in the same database by adding different table prefixes to the site versions. This is likely what you are seeing. It … Read more
Publishing failed error due to “CAST()” in post
How to properly prepare a column name if passed to a stored procedure?
This is what I wanted to achieve, I hope it helps somebody DELETE wp_posts FROM wp_posts INNER JOIN wp_users ON wp_posts.post_author = wp_users.ID WHERE post_author = 1 AND post_date BETWEEN ‘2024-01-01 00:00:00’ AND ‘2024-03-28 23:59:59’;
There are 2 main issues in your code: Your $wpdb->get_row($prepare) will return either an object or a null, so you can’t do if(count($users) > 0) because $users is not an array. To fix that, just use if ( $users ). There’s a typo here: SET fnmme=%s — the field name should be fname. So you … Read more
finally I find right code with helping by ChatGPT DELETE p FROM wp_posts p INNER JOIN wp_term_relationships tr1 ON (p.ID = tr1.object_id AND tr1.term_taxonomy_id = 2) LEFT JOIN wp_term_relationships tr2 ON (p.ID = tr2.object_id AND tr2.term_taxonomy_id = 20) WHERE p.post_type=”post” AND p.post_status=”publish” AND DATEDIFF(NOW(), p.post_date) > 180 AND tr2.term_taxonomy_id IS NULL; Lets try another way … Read more