$ SELECT comment_approved, COUNT( * ) AS total FROM wp_comments WHERE comment_post_ID = 467 GROUP BY comment_approved; +------------------+--------+ | comment_approved | total | +------------------+--------+ | 0 | 122969 | | 1 | 3 | +------------------+--------+ 2 rows in set (25.414 sec)
Description
Description
Status | Assigned | Task | ||
---|---|---|---|---|
Resolved | valerio.bozzolan | T771 Incident report for gargantua.reyboz.it | ||
Resolved | valerio.bozzolan | T778 Fix 122969 spam comments in 3tolo.com |
Event Timeline
Comment Actions
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%carcinoma%'; Query OK, 18118 rows affected (32.907 sec)
Comment Actions
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%medical%' OR comment_content LIKE '%vascular%' OR comment_content LIKE '%syndrome%'; Query OK, 71295 rows affected (1 min 20.884 sec)
Comment Actions
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%medical%' OR comment_content LIKE '%vascular%' OR comment_content LIKE '%syndrome%'; Query OK, 71295 rows affected (1 min 20.884 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%BITCOIN%' OR comment_content LIKE '%blood%' OR comment_content LIKE '%sexy%'; Query OK, 8337 rows affected (21.832 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%cialis%' OR comment_content LIKE '%timeblock%' OR comment_content LIKE '%thesis%'; Query OK, 3118 rows affected (17.915 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%dating%' OR comment_content LIKE '%vagina%' OR comment_content LIKE '%adult%' OR comment_content LIKE '%girl%' OR comment_content LIKE '%ф%'; Query OK, 3683 rows affected (16.170 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%zithromax%' OR comment_content LIKE '%б%' OR comment_content LIKE '%.ru%' OR comment_content LIKE '%porno%' OR comment_content LIKE '%bit.ly%'; Query OK, 3036 rows affected (13.854 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_content LIKE '%и%' OR comment_content LIKE '%neurontin%' OR comment_content LIKE '%viagra%' OR comment_content LIKE '%ロ%' OR comment_content LIKE '%cancerous%'; Query OK, 1804 rows affected (19.326 sec)
$ DELETE wp_comments, wp_commentmeta FROM wp_comments LEFT JOIN wp_commentmeta ON (wp_comments.comment_ID = wp_commentmeta.comment_id) WHERE comment_approved != 1 AND (comment_content LIKE '%https://%' OR comment_content LIKE '%http://%'); Query OK, 6139 rows affected, 19 warnings (16.839 sec)