SELECT * FROM XXXX_wallets_txs WHERE category='trade' AND account=2 AND symbol='NHN' INSERT INTO `XXXX_wallets_txs` (`id`, `blog_id`, `category`, `tags`, `account`, `other_account`, `address`, `extra`, `txid`, `symbol`, `amount`, `fee`, `comment`, `created_time`, `updated_time`, `confirmations`, `status`, `retries`, `admin_confirm`, `user_confirm`, `nonce`) VALUES (188, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b483d0ddaef2-O5b483eac66a1e-1', 'NHN', '5.0000000000', '0.7500000000', 'New order O5b483eac66a1e matched with market order O5b483d0ddaef2 at rate 1.0000000000', '2018-07-13 05:54:52', '2018-07-13 05:54:52', 0, 'done', 1, 0, 0, NULL), (193, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b483f1e9c9d8-O5b48422dc24be-2', 'NHN', '-1.0000000000', '0.0000000000', 'New order O5b483f1e9c9d8 matched with market order O5b48422dc24be at rate 0.0100000000', '2018-07-13 06:09:49', '2018-07-13 06:09:49', 0, 'done', 1, 0, 0, NULL), (195, 1, 'trade', 'limit order NHN-EDBT', 2, 1, '', '', 'T-NHN-EDBT-O5b4841f453e76-O5b484330e9a45-2', 'NHN', '-10.0000000000', '0.0000000000', 'New order O5b4841f453e76 matched with market order O5b484330e9a45 at rate 10.0000000000', '2018-07-13 06:14:08', '2018-07-13 06:14:08', 0, 'done', 1, 0, 0, NULL), (198, 1, 'trade', 'limit order NHN-EDBT', 2, 1, '', '', 'T-NHN-EDBT-O5b484330e9a45-O5b48449ad11ac-1', 'NHN', '10.0000000000', '2.5000000000', 'New order O5b48449ad11ac matched with market order O5b484330e9a45 at rate 10.0000000000', '2018-07-13 06:20:10', '2018-07-13 06:20:10', 0, 'done', 1, 0, 0, NULL), (205, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b48434a1efe0-O5b4844c0c4852-2', 'NHN', '-1.0000000000', '0.0000000000', 'New order O5b48434a1efe0 matched with market order O5b4844c0c4852 at rate 8.0000000000', '2018-07-13 06:20:48', '2018-07-13 06:20:48', 0, 'done', 1, 0, 0, NULL), (209, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b4844110a749-O5b4847a95fbb7-2', 'NHN', '-5.0000000000', '0.0000000000', 'New order O5b4844110a749 matched with market order O5b4847a95fbb7 at rate 1.0000000000', '2018-07-13 06:33:13', '2018-07-13 06:33:13', 0, 'done', 1, 0, 0, NULL), (213, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b4848ad63537-O5b48494ed52af-2', 'NHN', '-100.0000000000', '0.0000000000', 'New order O5b4848ad63537 matched with market order O5b48494ed52af at rate 7.0000000000', '2018-07-13 06:40:14', '2018-07-13 06:40:14', 0, 'done', 1, 0, 0, NULL), (216, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b48494ed52af-O5b484a4904781-1', 'NHN', '400.0000000000', '8.0000000000', 'New order O5b484a4904781 matched with market order O5b48494ed52af at rate 7.0000000000', '2018-07-13 06:44:25', '2018-07-13 06:44:25', 0, 'done', 1, 0, 0, NULL), (218, 1, 'trade', 'limit order NHN-EDBT', 2, 1, '', '', 'T-NHN-EDBT-O5b484cce46958-O5b484d84b2ac1-1', 'NHN', '1000.0000000000', '5.0000000000', 'New order O5b484d84b2ac1 matched with market order O5b484cce46958 at rate 1000.0000000000', '2018-07-13 06:58:12', '2018-07-13 06:58:12', 0, 'done', 1, 0, 0, NULL), (223, 1, 'trade', 'limit order NHN-EDBT', 2, 1, '', '', 'T-NHN-EDBT-O5b484df2805d8-O5b484eb03ca05-2', 'NHN', '-1000.0000000000', '0.0000000000', 'New order O5b484df2805d8 matched with market order O5b484eb03ca05 at rate 1000.0000000000', '2018-07-13 07:03:12', '2018-07-13 07:03:12', 0, 'done', 1, 0, 0, NULL), (227, 1, 'trade', 'limit order NHN-EDBT', 2, 1, '', '', 'T-NHN-EDBT-O5b484df2805d8-O5b484ec18e428-2', 'NHN', '-4000.0000000000', '0.0000000000', 'New order O5b484df2805d8 matched with market order O5b484ec18e428 at rate 1000.0000000000', '2018-07-13 07:03:29', '2018-07-13 07:03:29', 0, 'done', 1, 0, 0, NULL), (233, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b484a4904781-O5b4850e72557a-2', 'NHN', '-600.0000000000', '0.0000000000', 'New order O5b484a4904781 matched with market order O5b4850e72557a at rate 7.0000000000', '2018-07-13 07:12:39', '2018-07-13 07:12:39', 0, 'done', 1, 0, 0, NULL), (237, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b4844110a749-O5b4850e72557a-2', 'NHN', '-15.0000000000', '0.0000000000', 'New order O5b4844110a749 matched with market order O5b4850e72557a at rate 1.0000000000', '2018-07-13 07:12:39', '2018-07-13 07:12:39', 0, 'done', 1, 0, 0, NULL), (241, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b484c909d73a-O5b4850e72557a-2', 'NHN', '-200.0000000000', '0.0000000000', 'New order O5b484c909d73a matched with market order O5b4850e72557a at rate 0.1000000000', '2018-07-13 07:12:39', '2018-07-13 07:12:39', 0, 'done', 1, 0, 0, NULL), (245, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b484fa18a0a7-O5b4850e72557a-2', 'NHN', '-4185.0000000000', '0.0000000000', 'New order O5b484fa18a0a7 matched with market order O5b4850e72557a at rate 0.1000000000', '2018-07-13 07:12:39', '2018-07-13 07:12:39', 0, 'done', 1, 0, 0, NULL); SELECT * FROM XXXX_wallets_orders WHERE account=2 AND quote_symbol='NHN' AND status != 'cancelled' INSERT INTO `XXXX_wallets_orders` (`id`, `order_id`, `blog_id`, `direction`, `amount`, `base_symbol`, `quote_symbol`, `filled`, `rate`, `account`, `created_time`, `updated_time`, `status`) VALUES (3, 'O5b483eac66a1e', 1, 'ask', '5.0000000000', 'EDBT', 'NHN', '5.0000000000', '1.0000000000', 2, '2018-07-13 05:54:52', '2018-07-13 05:54:52', 'filled'), (4, 'O5b483f1e9c9d8', 1, 'bid', '1.0000000000', 'EDBT', 'NHN', '1.0000000000', '0.0100000000', 2, '2018-07-13 05:56:46', '2018-07-13 06:12:16', 'filled'), (9, 'O5b48430a92c24', 1, 'bid', '1.0000000000', 'EDBT', 'NHN', '0.0000000000', '0.0100000000', 2, '2018-07-13 06:13:30', '2018-07-13 06:13:30', 'open'), (11, 'O5b48434a1efe0', 1, 'bid', '1.0000000000', 'EDBT', 'NHN', '1.0000000000', '8.0000000000', 2, '2018-07-13 06:14:34', '2018-07-13 06:20:48', 'filled'), (12, 'O5b4844110a749', 1, 'bid', '20.0000000000', 'EDBT', 'NHN', '20.0000000000', '1.0000000000', 2, '2018-07-13 06:17:53', '2018-07-13 07:12:39', 'filled'), (17, 'O5b4848ad63537', 1, 'bid', '100.0000000000', 'EDBT', 'NHN', '100.0000000000', '7.0000000000', 2, '2018-07-13 06:37:33', '2018-07-13 06:40:14', 'filled'), (19, 'O5b484a4904781', 1, 'bid', '1000.0000000000', 'EDBT', 'NHN', '1000.0000000000', '7.0000000000', 2, '2018-07-13 06:44:25', '2018-07-13 07:12:39', 'filled'), (22, 'O5b484c909d73a', 1, 'bid', '200.0000000000', 'EDBT', 'NHN', '200.0000000000', '0.1000000000', 2, '2018-07-13 06:54:08', '2018-07-13 07:12:39', 'filled'), (28, 'O5b484fa18a0a7', 1, 'bid', '5000.0000000000', 'EDBT', 'NHN', '4185.0000000000', '0.1000000000', 2, '2018-07-13 07:07:13', '2018-07-13 07:12:39', 'open'); SELECT * FROM XXXX_wallets_txs WHERE category='trade' AND account=2 AND symbol='EDBT' INSERT INTO `XXXX_wallets_txs` (`id`, `blog_id`, `category`, `tags`, `account`, `other_account`, `address`, `extra`, `txid`, `symbol`, `amount`, `fee`, `comment`, `created_time`, `updated_time`, `confirmations`, `status`, `retries`, `admin_confirm`, `user_confirm`, `nonce`) VALUES (187, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b483d0ddaef2-O5b483eac66a1e-2', 'EDBT', '-5.0000000000', '0.0000000000', 'New order O5b483d0ddaef2 matched with market order O5b483eac66a1e at rate 1.0000000000', '2018-07-13 05:54:52', '2018-07-13 05:54:52', 0, 'done', 1, 0, 0, NULL), (190, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b483f1e9c9d8-O5b48422dc24be-1', 'EDBT', '0.0100000000', '0.0025000000', 'New order O5b48422dc24be matched with market order O5b483f1e9c9d8 at rate 0.0100000000', '2018-07-13 06:09:49', '2018-07-13 06:09:49', 0, 'done', 1, 0, 0, NULL), (196, 1, 'trade', 'limit order NHN-EDBT', 2, 1, '', '', 'T-NHN-EDBT-O5b4841f453e76-O5b484330e9a45-1', 'EDBT', '1.0000000000', '0.1500000000', 'New order O5b484330e9a45 matched with market order O5b4841f453e76 at rate 10.0000000000', '2018-07-13 06:14:08', '2018-07-13 06:14:08', 0, 'done', 1, 0, 0, NULL), (201, 1, 'trade', 'limit order NHN-EDBT', 2, 1, '', '', 'T-NHN-EDBT-O5b484330e9a45-O5b48449ad11ac-2', 'EDBT', '-1.0000000000', '0.0000000000', 'New order O5b484330e9a45 matched with market order O5b48449ad11ac at rate 10.0000000000', '2018-07-13 06:20:10', '2018-07-13 06:20:10', 0, 'done', 1, 0, 0, NULL), (202, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b48434a1efe0-O5b4844c0c4852-1', 'EDBT', '8.0000000000', '2.0000000000', 'New order O5b4844c0c4852 matched with market order O5b48434a1efe0 at rate 8.0000000000', '2018-07-13 06:20:48', '2018-07-13 06:20:48', 0, 'done', 1, 0, 0, NULL), (206, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b4844110a749-O5b4847a95fbb7-1', 'EDBT', '5.0000000000', '0.2500000000', 'New order O5b4847a95fbb7 matched with market order O5b4844110a749 at rate 1.0000000000', '2018-07-13 06:33:13', '2018-07-13 06:33:13', 0, 'done', 1, 0, 0, NULL), (210, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b4848ad63537-O5b48494ed52af-1', 'EDBT', '700.0000000000', '35.0000000000', 'New order O5b48494ed52af matched with market order O5b4848ad63537 at rate 7.0000000000', '2018-07-13 06:40:14', '2018-07-13 06:40:14', 0, 'done', 1, 0, 0, NULL), (215, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b48494ed52af-O5b484a4904781-2', 'EDBT', '-2800.0000000000', '0.0000000000', 'New order O5b48494ed52af matched with market order O5b484a4904781 at rate 7.0000000000', '2018-07-13 06:44:25', '2018-07-13 06:44:25', 0, 'done', 1, 0, 0, NULL), (221, 1, 'trade', 'limit order NHN-EDBT', 2, 1, '', '', 'T-NHN-EDBT-O5b484cce46958-O5b484d84b2ac1-2', 'EDBT', '-1.0000000000', '0.0000000000', 'New order O5b484cce46958 matched with market order O5b484d84b2ac1 at rate 1000.0000000000', '2018-07-13 06:58:12', '2018-07-13 06:58:12', 0, 'done', 1, 0, 0, NULL), (224, 1, 'trade', 'limit order NHN-EDBT', 2, 1, '', '', 'T-NHN-EDBT-O5b484df2805d8-O5b484eb03ca05-1', 'EDBT', '1.0000000000', '0.0010000000', 'New order O5b484eb03ca05 matched with market order O5b484df2805d8 at rate 1000.0000000000', '2018-07-13 07:03:12', '2018-07-13 07:03:12', 0, 'done', 1, 0, 0, NULL), (228, 1, 'trade', 'limit order NHN-EDBT', 2, 1, '', '', 'T-NHN-EDBT-O5b484df2805d8-O5b484ec18e428-1', 'EDBT', '4.0000000000', '0.0040000000', 'New order O5b484ec18e428 matched with market order O5b484df2805d8 at rate 1000.0000000000', '2018-07-13 07:03:29', '2018-07-13 07:03:29', 0, 'done', 1, 0, 0, NULL), (230, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b484a4904781-O5b4850e72557a-1', 'EDBT', '4200.0000000000', '21.0000000000', 'New order O5b4850e72557a matched with market order O5b484a4904781 at rate 7.0000000000', '2018-07-13 07:12:39', '2018-07-13 07:12:39', 0, 'done', 1, 0, 0, NULL), (234, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b4844110a749-O5b4850e72557a-1', 'EDBT', '15.0000000000', '0.0750000000', 'New order O5b4850e72557a matched with market order O5b4844110a749 at rate 1.0000000000', '2018-07-13 07:12:39', '2018-07-13 07:12:39', 0, 'done', 1, 0, 0, NULL), (238, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b484c909d73a-O5b4850e72557a-1', 'EDBT', '20.0000000000', '0.1000000000', 'New order O5b4850e72557a matched with market order O5b484c909d73a at rate 0.1000000000', '2018-07-13 07:12:39', '2018-07-13 07:12:39', 0, 'done', 1, 0, 0, NULL), (242, 1, 'trade', 'limit order EDBT-NHN', 2, 1, '', '', 'T-EDBT-NHN-O5b484fa18a0a7-O5b4850e72557a-1', 'EDBT', '418.5000000000', '2.0925000000', 'New order O5b4850e72557a matched with market order O5b484fa18a0a7 at rate 0.1000000000', '2018-07-13 07:12:39', '2018-07-13 07:12:39', 0, 'done', 1, 0, 0, NULL); SELECT * FROM XXXX_wallets_orders WHERE account=2 AND quote_symbol='NHN' AND status != 'cancelled' INSERT INTO `XXXX_wallets_orders` (`id`, `order_id`, `blog_id`, `direction`, `amount`, `base_symbol`, `quote_symbol`, `filled`, `rate`, `account`, `created_time`, `updated_time`, `status`) VALUES (10, 'O5b484330e9a45', 1, 'ask', '2.0000000000', 'NHN', 'EDBT', '2.0000000000', '10.0000000000', 2, '2018-07-13 06:14:08', '2018-07-13 06:20:10', 'filled'), (20, 'O5b484aecf2fab', 1, 'bid', '10.0000000000', 'NHN', 'EDBT', '0.0000000000', '8.0000000000', 2, '2018-07-13 06:47:08', '2018-07-13 06:47:08', 'open'), (23, 'O5b484cce46958', 1, 'ask', '1.0000000000', 'NHN', 'EDBT', '1.0000000000', '1000.0000000000', 2, '2018-07-13 06:55:10', '2018-07-13 06:58:12', 'filled'), (26, 'O5b484eb03ca05', 1, 'ask', '1.0000000000', 'NHN', 'EDBT', '1.0000000000', '1000.0000000000', 2, '2018-07-13 07:03:12', '2018-07-13 07:03:12', 'filled'), (27, 'O5b484ec18e428', 1, 'ask', '4.0000000000', 'NHN', 'EDBT', '4.0000000000', '1000.0000000000', 2, '2018-07-13 07:03:29', '2018-07-13 07:03:29', 'filled');