Trung Tu’s Blog
Statistics
WordPress database error: [Table 'trungtu_nguyen.wp_comments' doesn't exist]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = '1'
WordPress database error: [Table 'trungtu_nguyen.wp_comments' doesn't exist]
SELECT COUNT(DISTINCT comment_author) FROM wp_comments WHERE comment_approved = '1'
WordPress database error: [Table 'trungtu_nguyen.wp_comments' doesn't exist]
SELECT wp_posts.ID, post_title, post_name, post_status, comment_author, post_date, comment_date FROM wp_posts INNER JOIN wp_comments ON wp_posts.ID = wp_comments.comment_post_ID WHERE comment_approved = '1' AND post_date < '2024-05-07 05:34:24' AND (post_status = 'publish' OR post_status = 'static') AND post_password = '' ORDER BY comment_date DESC LIMIT 10
WordPress database error: [Table 'trungtu_nguyen.wp_comments' doesn't exist]
SELECT wp_posts.ID, post_title, post_name, post_status, post_date, COUNT(wp_comments.comment_post_ID) AS 'comment_total' FROM wp_posts LEFT JOIN wp_comments ON wp_posts.ID = wp_comments.comment_post_ID WHERE comment_approved = '1' AND post_date < '2024-05-07 05:34:24' AND (post_status = 'publish' OR post_status = 'static') AND post_password = '' GROUP BY wp_comments.comment_post_ID ORDER BY comment_total DESC LIMIT 10
WordPress database error: [Table 'trungtu_nguyen.wp_comments' doesn't exist]
SELECT comment_author, COUNT(comment_ID) AS 'comment_total' FROM wp_comments WHERE comment_approved = '1' GROUP BY comment_author ORDER BY comment_total DESC
Total Stats WP-EMail WP-PostViews 10 Recent Posts 10 Recent Comments 10 Most Commented Post 10 Most Emailed Post 10 Most Viewed Post Authors Comment Members Post Categories Link Categories
General Stats
Plugins Stats
Top 10 Stats
Authors Stats
Comments’ Members Stats
Misc Stats
WordPress database error: [Table 'trungtu_nguyen.wp_comments' doesn't exist]
SELECT * FROM wp_comments WHERE comment_post_ID = '52' AND comment_approved = '1' ORDER BY comment_date
Leave a Comment
You must be logged in to post a comment.