mysql - 删除 0 次浏览的 WordPress 帖子 [wp_postviews 插件]

Question

我认为这个选择非常完美......有什么建议吗？

SELECT * 
FROM  `wp_posts` ,  `wp_postmeta` 
WHERE  `post_type` =  'post'
AND post_id = ID
AND DATEDIFF( NOW( ) ,  `post_date` ) >400
AND meta_key =  "views"
AND meta_value =0;

问题是我不知道如何删除所有这些帖子!有什么帮助吗？谢谢

Answer 1

[编辑，评论后 - 未经测试，因此可能不是 100% 正确]

create table post_ids_to_remove (postid bigint);

insert into post_ids_to_remove (postid) values (
  SELECT post_id
      FROM  `wp_posts` ,  `wp_postmeta` 
      WHERE  `post_type` =  'post'
      AND post_id = ID
      AND DATEDIFF( NOW( ) ,  `post_date` ) >400
      AND meta_key =  "views"
      AND meta_value =0
)

delete from `wp_postmeta` where post_id in(
      SELECT postid
      FROM  `post_ids_to_remove`
);

delete from `wp_posts` where id in(
      SELECT postid
      FROM  `post_ids_to_remove`
);

drop table post_ids_to_remove;