- View the source.
- Go to OpenSim/DB/0.9.0/totalsales.
1: 2016-05-21 (Sat) 18:47:11 iseki ![]() |
Cur: 2016-05-21 (Sat) 18:52:08 iseki ![]() |
||
---|---|---|---|
Line 12: | Line 12: | ||
+-------------+--------------+------+-----+---------+-------+ | +-------------+--------------+------+-----+---------+-------+ | ||
7 rows in set (0.00 sec) | 7 rows in set (0.00 sec) | ||
+ | *** Command [#ja0fcc59] | ||
+ | - transactions テーブルから生成 | ||
+ | SELECT receiver,objectUUID,type,COUNT(*),SUM(amount) FROM transactions WHERE sender<>receiver AND status=0 | ||
+ | GROUP BY receiver,objectUUID,type; |
- Backup list of OpenSim/DB/0.9.0/totalsales
- Backup diff of OpenSim/DB/0.9.0/totalsales(No. All)
- 1: 2016-05-21 (Sat) 18:47:11 iseki
- Cur: 2016-05-21 (Sat) 18:52:08 iseki