This command lists all purchased items for a 30-day period.
SELECT is_log.account_id,item_proto.locale_name, is_log.preis FROM `account`.`is_log` INNER JOIN `player`.`item_proto` ON `is_log`.`vnum` = `item_proto`.`vnum` WHERE TIMESTAMPDIFF(DAY, `zeitpunkt`,NOW()) <= 30;
Example result:
+------------+--------------+-------+
| account_id | locale_name | preis |
+------------+--------------+-------+
| 2408 | Knuud | 2000 |
+------------+--------------+-------+
SELECT is_log.account_id,item_proto.locale_name, is_log.preis FROM `account`.`is_log` INNER JOIN `player`.`item_proto` ON `is_log`.`vnum` = `item_proto`.`vnum` WHERE TIMESTAMPDIFF(DAY, `zeitpunkt`,NOW()) <= 30;
Example result:
+------------+--------------+-------+
| account_id | locale_name | preis |
+------------+--------------+-------+
| 2408 | Knuud | 2000 |
+------------+--------------+-------+