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…

This doesn’t seem right. What’s the intention? Count posts from the last week, grouped by email domain, but exclude system users? Does it need to count deleted posts or posts from deleted topics, exclude small action posts, or those in PMs?

This was a quick and dirty test of the SQL Helper bot to find the count of posts by domain. The use-case might be for associations or membership forums who want to track which subgroups within the forum are most engaged. It could certainly use refinement, such as removing deleted or small actions p…

הודעות משתמש לפי דומיין דואר אלקטרוני ב-7 הימים האחרונים

קהילה נתונים ודיווח

נושא		תגובות	צפיות
User stats plus email Data & reporting sql-query	3	82	24 ביולי,‏ 2024
User participation Data & reporting sql-query	0	186	17 בנובמבר,‏ 2017
Who has been sending the most messages in the last week? Data & reporting sql-query	0	155	5 ביוני,‏ 2017
Replies via email in reports Feature	1	469	17 באוקטובר,‏ 2024
Replies via email not counted as posts? Support users , badges , email	0	110	30 באוגוסט,‏ 2025

הודעות משתמש לפי דומיין דואר אלקטרוני ב-7 הימים האחרונים

נושאים קשורים