Skip to content

Instantly share code, notes, and snippets.

@aiiddqd

aiiddqd/wordpress-mysql-comments-1-year-ago.sql

Created October 29, 2018 10:46
Show Gist options
  • Save aiiddqd/de70ad807346d16aa87b6e0388244154 to your computer and use it in GitHub Desktop.
Save aiiddqd/de70ad807346d16aa87b6e0388244154 to your computer and use it in GitHub Desktop.
Download ZIP
WordPress - Комменты более года
Raw
wordpress-mysql-comments-1-year-ago.sql
-- WordPress - Comments 1 year ago
SELECT *
FROM wp_comments as c
WHERE c.comment_date_gmt < DATE_SUB(NOW(),INTERVAL 1 YEAR)
ORDER BY c.comment_date_gmt DESC
LIMIT 50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment