Changes between Version 1 and Version 2 of WikiStart/Analytics
- Timestamp:
- 03/23/25 21:47:32 (12 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
WikiStart/Analytics
v1 v2 1 1 = Аналитика и статистика 2 3 4 == Детален преглед на трансакции помеѓу корисниците по датум 5 {{{ 6 SELECT 7 tm.s_account_id AS sender_id, 8 a_s.username AS sender_username, 9 tm.r_account_id AS receiver_id, 10 a_r.username AS receiver_username, 11 tm.t_id, 12 t.timestamp, 13 t.amount 14 15 FROM 16 transferred_money tm 17 JOIN 18 account a_s ON tm.s_account_id = a_s.id 19 JOIN 20 account a_r ON tm.r_account_id = a_r.id 21 JOIN 22 "transaction" t ON tm.t_id = t.id; 23 24 25 }}} 26 27 == 28