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
Change comments ordering by custom value
This may not be the best solution. I am not an expert. But the following helped solve my problem and I can add columns using the PhpMyAdmin without getting any errors. I went over to the SQL tab and then I ran the following query show variables like ‘sql_mode’; Then in order to remove i … Read more
How to correctly cleaning wordpress options table
I have resolved it eventually. I suspect this was an injection attack on the system by a bot that managed to create a user account for itself. One lesson learned is to govern user creation more strictly. But it’s still not fully clear what/how the intruder acted, so if somebody has a clue, share in … Read more
Here’s a sample SQL query that demonstrates this approach: SELECT MONTH(p.post_date) AS month, pm.meta_value AS shipping_method, COUNT(*) AS order_count FROM wp_posts p JOIN wp_postmeta pm ON p.ID = pm.post_id JOIN wp_woocommerce_order_items oi ON p.ID = oi.order_id WHERE p.post_type=”shop_order” AND pm.meta_key = ‘_shipping_method’ AND p.post_date >= ‘2021-01-01’ AND p.post_date < ‘2022-01-01’ GROUP BY month, shipping_method Replace … Read more
SQL query based on two different custom field values
How to speed up WP_Posts_List_Table __construct() Query on a wordpress website with over 1 million posts?
How to short circuit a wordpress query that is not related to posts?
Help writing out comments and replies