Limpando Akismet e Spam - Histórico de revisão

Banto Palmarino em 21h48min de 25 de março de 2016

2016-03-25T21:48:38Z

@@ Linha 16: / Linha 16: @@
 DELETE FROM wp_comments WHERE comment_approved = 0;
 </source>
 [[Categoria:Wordpress]]

Banto Palmarino em 21h44min de 25 de março de 2016

2016-03-25T21:44:43Z

@@ Linha 1: / Linha 1: @@
 <source lang="mysql">
 DELETE FROM aps_commentmeta WHERE comment_id NOT IN ( SELECT comment_id FROM aps_comments );
 DELETE FROM aps_commentmeta WHERE meta_key LIKE '%akismet%';
@@ Linha 6: / Linha 5: @@
 OPTIMIZE TABLE aps_comments;
 </source>

Banto Palmarino: Criou página com ' DELETE FROM aps_comments WHERE comment_approved = 'spam'; DELETE FROM aps_commentmeta WHERE comment_id NOT IN ( SELECT comment_id FROM aps_comments ); DE...'

2015-07-28T12:47:07Z

Criou página com '<source lang="mysql"> DELETE FROM aps_comments WHERE comment_approved = 'spam'; DELETE FROM aps_commentmeta WHERE comment_id NOT IN ( SELECT comment_id FROM aps_comments ); DE...'

Página nova

<source lang="mysql">
DELETE FROM aps_comments WHERE comment_approved = 'spam';
DELETE FROM aps_commentmeta WHERE comment_id NOT IN ( SELECT comment_id FROM aps_comments );
DELETE FROM aps_commentmeta WHERE meta_key LIKE '%akismet%';
OPTIMIZE TABLE aps_commentmeta;
OPTIMIZE TABLE aps_comments;
</source>