Query to count posts by email domain for the past 7 days, excluding automatic groups (bots, system) SELECT split_part(ue.email, '@', 2) AS email_domain, -- Extracts the domain part of the email COUNT(p.id) AS post_count FROM posts p JOIN users u ON p.user_id = u.id JOIN user_emails ue ON …

I think it actually gives inflated numbers due to the group joins (also, everyone is part of an automatic group for their trust level, so there’s a bit of inconsistency there). I think we can strip out those and maybe add a couple of tweaks to zone in topics, posts, and PMs. Let me have a bash. M…

User posts by email domain over last 7 days

data & reporting

JammyDodger Split this topic July 23, 2024, 9:49am 5

2 posts were split to a new topic: User Stats plus email

Topic		Replies	Views
User stats plus email data & reporting sql-query	3	36	July 24, 2024
How can I count posts in last month by a specific group of users? data & reporting sql-query	7	1811	August 14, 2023
User participation data & reporting sql-query	0	136	November 17, 2017
Auto-approve user accounts by email domain support	5	893	July 17, 2020
SQL query for users who have posted on a date (or date range) data & reporting sql-query	8	1414	July 11, 2021

User posts by email domain over last 7 days

Related Topics