Changes between Version 8 and Version 9 of WikiStart/Analytics

Timestamp:

03/30/25 21:31:10 (2 months ago)

Author:

203206

Comment:

db

WikiStart/Analytics

@@ -182 +182 @@
 LIMIT 3; 
 }}}
+
+
+== Најактивните корисници во последните 30 дена
+{{{
+WITH recent_activity AS (
+    SELECT account_id, COUNT(*) AS activity_count
+    FROM "transaction"
+    WHERE timestamp >= NOW() - INTERVAL '30 days'
+    GROUP BY account_id
+)
+
+SELECT a.id AS account_id,
+       a.username,
+       a.email,
+       COALESCE(ra.activity_count, 0) AS recent_transactions
+FROM account a
+LEFT JOIN recent_activity ra ON a.id = ra.account_id
+ORDER BY recent_transactions DESC
+LIMIT :top_n;
+
+
+
+}}}