• 表收藏夹为空。

将文件拖动至此

SQL 上传 ( 0 ) x -

服务器: localhost »数据库: NorenDB »表: TradeBook
页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 用时
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 5555 行, 查询花费 0.0123 秒。) [orgtimestamp: 1779165421... - 1779179294...]
SELECT * FROM `TradeBook` ORDER BY `orgtimestamp` ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 noren_ord_numnoren_time_stampnoren_nsecserefnoren_kid_idord_statusreport_typeacct_iduser_idtrading_symbolexch_segtokentrans_typeprice_typeproductord_durationcust_firmpartic_idpan_numqty_to_fillprice_to_fillrej_reasoncancelled_qtyfill_qtytotal_fill_qtyexch_time_stampexch_nsecsfill_pricefill_avg_pricetrigger_pricedisc_qtyexch_ord_numfill_idord_remarksfill_timetrading_symbol_leg_2trans_type_leg_2trading_symbol_leg_3trans_type_leg_3trading_symbol_leg_4trans_type_leg_4token_leg_2token_leg_3token_leg_4qty_to_fill_leg_2price_to_fill_leg_2qty_to_fill_leg_3price_to_fill_leg_3qty_to_fill_leg_4price_to_fill_leg_4fill_legtotal_fill_qty_leg_2total_fill_qty_leg_3total_fill_qty_leg_4fill_avg_price_leg_2fill_avg_price_leg_3fill_avg_price_leg_4lot_sizeprice_precisionqty_precisionmultipliersymbol_namecompany_nameexchangesegmentexpiry_dateexpiry_date_leg_2expiry_date_leg_3expiry_date_leg_4instrument_nameoption_typeisinstrike_pricetick_sizeprice_numeratorprice_denominatorgen_numeratorgen_denominatorui_dev_codebroker_idregionfamily_idord_srcip_addressorder_statusreport_statusexchseg_acct_idctcl_idchanneluser_agentapp_install_idorgtimestamp 递增 递减 1modified_byfix_rmksrej_bysnofillIdexchusrinfoalgoidalgocategoryalgonameguiidorgguiidstreamIdgiveupIndstoppriceprofitpricetrailingpricesnoordtypeorderstateauctionnumbermktprotectionexectypebasketidprice_multiplier
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000006 AND `TradeBook`.`fill_id` = \'100000008\'
26051900000006 1779167453 402867173 12 1 50 49 DEEKSHAINV DEEKSHAMST RELIANCE-EQ NSE 2885 B LMT I DAY C 1 _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 1 130000 0 1 1 1779167453 415520848 130000 130000 0 0 4 100000008 LTP_B_O: : Ltp 1245.00 is below 1250.00: 19-05-2026 10:40:53 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 RELIANCE NULL NSE EQT NULL NULL NULL NULL EQ NULL NULL 0 10 0 0 0 0 NULL KSPL MANGLORE KSPL TO 117.230.93.169 COMPLETE Fill NULL 11111 NULL NULL NULL 1779165421 NULL NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 50 0 0.0000 0 26051900000004 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000007 AND `TradeBook`.`fill_id` = \'100000044\'
26051900000007 1779191795 653991488 17 2 48 49 DHANUSHINVES DHANUSHINVES ACCELYA-EQ NSE 7053 B LMT M DAY C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 10 100000 0 3 4 1779191795 821029186 100000 100000 0 0 5 100000044 NULL 19-05-2026 17:26:35 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACCELYA NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NOREN_WEB KSPL KARKALA KSPL WEB 115.246.215.139 OPEN Fill NULL 11111 Windows BrowserAgent.Chrome 700efba0-fbbb-419e-a83f-0fe7500b046d 1779166003 DHANUSHINVES NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 48 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000007 AND `TradeBook`.`fill_id` = \'100000046\'
26051900000007 1779192214 441265364 17 2 48 49 DHANUSHINVES DHANUSHINVES ACCELYA-EQ NSE 7053 B LMT M DAY C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 10 100000 0 5 9 1779192214 821029186 100000 100000 0 0 5 100000046 NULL 19-05-2026 17:33:34 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACCELYA NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NOREN_WEB KSPL KARKALA KSPL WEB 115.246.215.139 OPEN Fill NULL 11111 Windows BrowserAgent.Chrome 700efba0-fbbb-419e-a83f-0fe7500b046d 1779166003 DHANUSHINVES NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 48 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000007 AND `TradeBook`.`fill_id` = \'100000048\'
26051900000007 1779192353 610593060 17 2 50 49 DHANUSHINVES DHANUSHINVES ACCELYA-EQ NSE 7053 B LMT M DAY C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 10 100000 0 1 10 1779192353 821029186 100000 100000 0 0 5 100000048 NULL 19-05-2026 17:35:53 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACCELYA NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NOREN_WEB KSPL KARKALA KSPL WEB 115.246.215.139 COMPLETE Fill NULL 11111 Windows BrowserAgent.Chrome 700efba0-fbbb-419e-a83f-0fe7500b046d 1779166003 DHANUSHINVES NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000011 AND `TradeBook`.`fill_id` = \'100000007\'
26051900000011 1779167453 402836527 24 1 50 49 KKSINV DEEKSHAMST RELIANCE-EQ NSE 2885 S LMT I DAY C _i2dxJdOKLgtfB9SjKUNNKeb/lGlaZUrqm4k= 1 130000 0 1 1 1779167453 402394762 130000 130000 0 0 9 100000007 19-05-2026 10:40:53 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 RELIANCE NULL NSE EQT NULL NULL NULL NULL EQ NULL NULL 0 10 0 0 0 0 NULL KSPL KSPL KSPL TT 49.43.240.22 COMPLETE Fill NULL 11111 DESKTOP TT/1.0.8(Dell_Inc. Latitude_3540; Windows NT 10.0.... 97947c0b-57c2-45c9-95f1-a12cabd8a06c 1779167453 NULL NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000012 AND `TradeBook`.`fill_id` = \'100000022\'
26051900000012 1779178676 459923482 26 1 48 49 KRITHIINV KRITHIINV ABB-EQ NSE 13 S LMT C DAY C _8RINRKn4WX4mDTn1rqsgET+gDDN8J6FCX8M= 10 641350 0 1 1 1779178676 459520905 641350 641350 0 0 10 100000022 ATP_B_O: : Atp 6358.31 is below 6413.50: 19-05-2026 13:47:56 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ABB NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 50 0 0 0 0 NULL KSPL MANGAL MANGLORE TO 122.166.121.7 OPEN Fill NULL 11111 NULL NULL NULL 1779167814 NULL NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 48 0 0.0000 0 26051900000009 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000012 AND `TradeBook`.`fill_id` = \'100000024\'
26051900000012 1779178705 406405234 26 1 48 49 KRITHIINV KRITHIINV ABB-EQ NSE 13 S LMT C DAY C _8RINRKn4WX4mDTn1rqsgET+gDDN8J6FCX8M= 10 641350 0 1 2 1779178705 459520905 641350 641350 0 0 10 100000024 ATP_B_O: : Atp 6358.31 is below 6413.50: 19-05-2026 13:48:25 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ABB NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 50 0 0 0 0 NULL KSPL MANGAL MANGLORE TO 122.166.121.7 OPEN Fill NULL 11111 NULL NULL NULL 1779167814 NULL NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 48 0 0.0000 0 26051900000009 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000012 AND `TradeBook`.`fill_id` = \'100000026\'
26051900000012 1779179294 902969141 26 1 50 49 KRITHIINV KRITHIINV ABB-EQ NSE 13 S LMT C DAY C _8RINRKn4WX4mDTn1rqsgET+gDDN8J6FCX8M= 10 641350 0 8 10 1779179294 901956178 641350 641350 0 0 10 100000026 ATP_B_O: : Atp 6358.31 is below 6413.50: 19-05-2026 13:58:14 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ABB NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 50 0 0 0 0 NULL KSPL MANGAL MANGLORE TO 122.166.121.7 COMPLETE Fill NULL 11111 NULL NULL NULL 1779167814 NULL NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 50 0 0.0000 0 26051900000009 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000023 AND `TradeBook`.`fill_id` = \'100000039\'
26051900000023 1779183014 29398851 43 1 50 49 ANANYARAMA3 ANANYARAMA3 RELIANCE-EQ NSE 2885 B LMT C DAY C _gWJ9NNn4WX4mDcBgjbAMUSPheCuTiXpmwk0= 1 140000 0 1 1 1779183014 200882857 140000 140000 0 0 14 100000039 LTP_A_52HIGH_O: : Ltp 1300.00 is above 52 week hig... 19-05-2026 15:00:14 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 RELIANCE NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NULL KSPL Mangaluru KSPL TO 115.246.215.139 COMPLETE Fill NULL 11111 NULL NULL NULL 1779171200 NULL NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 50 0 0.0000 0 26051900000014 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000024 AND `TradeBook`.`fill_id` = \'100000010\'
26051900000024 1779171605 985438868 45 1 48 49 KRITHIINV ANANYARAMA ABDL-EQ NSE 24308 B LMT M DAY C _8RINRKn4WX4mDTn1rqsgET+gDDN8J6FCX8M= 10 55000 0 5 5 1779171605 984633635 55000 55000 0 0 15 100000010 19-05-2026 11:50:05 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ABDL NULL NSE EQT NULL NULL NULL NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL MANGAL MANGLORE TT 115.246.215.139 OPEN Fill NULL 11111 DESKTOP TT/1.0.8(Dell_Inc. Dell_Pro_16_PC16250; Windows NT... 377cde9f-92c2-4dee-b987-7329db0d0a5a 1779171588 NULL NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 48 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000025 AND `TradeBook`.`fill_id` = \'100000009\'
26051900000025 1779171605 985401228 47 1 50 49 ANANYARAMA ANANYARAMA ABDL-EQ NSE 24308 S LMT M DAY C _gWJ9NNn4WX4mDcBgjbAMUSPheCuTiXpmwk0= 5 55000 0 5 5 1779171605 984585292 55000 55000 0 0 16 100000009 19-05-2026 11:50:05 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ABDL NULL NSE EQT NULL NULL NULL NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL Mangaluru ANANYARAMA TT 115.246.215.139 COMPLETE Fill NULL 11111 DESKTOP TT/1.0.8(Dell_Inc. Dell_Pro_16_PC16250; Windows NT... 377cde9f-92c2-4dee-b987-7329db0d0a5a 1779171605 NULL NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000031 AND `TradeBook`.`fill_id` = \'100000012\'
26051900000031 1779174357 749366107 58 1 50 49 JYOTHI JYOTHI ACC-EQ NSE 22 B LMT I DAY C _8RINRKmIKQ5WfeqoZxYxdKqDFx88O+A2Ryw= 1 160000 0 1 1 1779174357 748104752 160000 160000 0 1 17 100000012 Testing DS order from API 19-05-2026 12:35:57 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACC NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NULL KSPL BOMBAY ONLINE CPPAPI NULL COMPLETE Fill NULL 11111 NULL NULL NULL 1779173959 NULL L4L4L5L5 NULL NULL 111111111111100 NULL NULL L3LELEL33 K3KEKKK4 K3KEKKK4 0 0 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000033 AND `TradeBook`.`fill_id` = \'100000011\'
26051900000033 1779174357 749328641 60 1 50 49 JYO JYO ACC-EQ NSE 22 S LMT H DAY C _gWJ9NNmIKQ5WfRM9RA0dNLbCYwfTlTsS2qI= 1 160000 0 1 1 1779174357 748039845 160000 160000 0 1 18 100000011 Testing DS order from API 19-05-2026 12:35:57 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACC NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NULL KSPL MANGALORE MANGLORE CPPAPI NULL COMPLETE Fill NULL 11111 NULL NULL NULL 1779174357 NULL 2LWLO2 NULL NULL 111111111111100 NULL NULL ALGO3J44J I2O3J4E I2O3J4E 0 100 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000035 AND `TradeBook`.`fill_id` = \'100000014\'
26051900000035 1779174621 114178276 64 1 48 49 JYOTHI JYOTHI ACC-EQ NSE 22 B LMT M DAY C _8RINRKmIKQ5WfeqoZxYxdKqDFx88O+A2Ryw= 10 160000 0 5 5 1779174621 262091480 160000 160000 0 10 20 100000014 Testing DS order from API 19-05-2026 12:40:21 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACC NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NULL KSPL BOMBAY ONLINE CPPAPI NULL OPEN Fill NULL 11111 NULL NULL NULL 1779174590 NULL KK4KK5K5 NULL NULL 111111111111100 NULL NULL K4EKEK3 K3KEK4 K3KEK4 0 0 0 0 0 48 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000035 AND `TradeBook`.`fill_id` = \'100000016\'
26051900000035 1779174760 461640281 64 1 48 49 JYOTHI JYOTHI ACC-EQ NSE 22 B LMT M DAY C _8RINRKmIKQ5WfeqoZxYxdKqDFx88O+A2Ryw= 10 160000 0 3 8 1779174760 460277060 160000 160000 0 10 20 100000016 Testing DS order from API 19-05-2026 12:42:40 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACC NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NULL KSPL BOMBAY ONLINE CPPAPI NULL OPEN Fill NULL 11111 NULL NULL NULL 1779174590 NULL KK4KK5K5 NULL NULL 111111111111100 NULL NULL K4EKEK3 K3KEK4 K3KEK4 0 0 0 0 0 48 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000035 AND `TradeBook`.`fill_id` = \'100000028\'
26051900000035 1779180469 462045924 64 1 50 49 JYOTHI JYOTHI ACC-EQ NSE 22 B LMT M DAY C _8RINRKmIKQ5WfeqoZxYxdKqDFx88O+A2Ryw= 10 160000 0 2 10 1779180469 461543606 160000 160000 0 10 20 100000028 Testing DS order from API 19-05-2026 14:17:49 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACC NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NULL KSPL BOMBAY ONLINE CPPAPI NULL COMPLETE Fill NULL 11111 NULL NULL NULL 1779174590 NULL KK4KK5K5 NULL NULL 111111111111100 NULL NULL K4EKEK3 K3KEK4 K3KEK4 0 0 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000036 AND `TradeBook`.`fill_id` = \'100000013\'
26051900000036 1779174621 114129933 66 1 50 49 JYO JYO ACC-EQ NSE 22 S LMT H DAY C _gWJ9NNmIKQ5WfRM9RA0dNLbCYwfTlTsS2qI= 5 160000 0 5 5 1779174621 113585539 160000 160000 0 5 21 100000013 Testing DS order from API 19-05-2026 12:40:21 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACC NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NULL KSPL MANGALORE MANGLORE CPPAPI NULL COMPLETE Fill NULL 11111 NULL NULL NULL 1779174621 NULL KK4K4K NULL NULL 111111111111100 NULL NULL AKEK3K3 KWK3KK KWK3KK 0 100 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000041 AND `TradeBook`.`fill_id` = \'100000015\'
26051900000041 1779174760 461588985 71 1 50 49 JYO JYO ACC-EQ NSE 22 S LMT H DAY C _gWJ9NNmIKQ5WfRM9RA0dNLbCYwfTlTsS2qI= 3 160000 0 3 3 1779174760 460230372 160000 160000 0 3 23 100000015 Testing DS order from API 19-05-2026 12:42:40 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACC NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 10 0 0 0 0 NULL KSPL MANGALORE MANGLORE CPPAPI NULL COMPLETE Fill NULL 11111 NULL NULL NULL 1779174760 NULL KDKEKEK3K NULL NULL 111111111111100 NULL NULL O2O34O4 K2K3K3K3K K2K3K3K3K 0 100 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000046 AND `TradeBook`.`fill_id` = \'100000018\'
26051900000046 1779175233 296571311 77 1 48 49 JYO JYO FSL-EQ NSE 14304 S LMT H DAY C _gWJ9NNmIKQ5WfRM9RA0dNLbCYwfTlTsS2qI= 3 20000 0 1 1 1779175233 296209425 20000 20000 0 3 25 100000018 Testing DS order from API 19-05-2026 12:50:33 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 FSL NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 1 0 0 0 0 NULL KSPL MANGALORE MANGLORE CPPAPI NULL OPEN Fill NULL 11111 NULL NULL NULL 1779175192 NULL 3L3LL3L NULL NULL 111111111111100 NULL NULL ALGOO3K33 MKKEKK3 MKKEKK3 0 100 0 0 0 48 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000047 AND `TradeBook`.`fill_id` = \'100000017\'
26051900000047 1779175233 296530630 79 1 50 49 JYOTHI JYOTHI FSL-EQ NSE 14304 B LMT M DAY C _8RINRKmIKQ5WfeqoZxYxdKqDFx88O+A2Ryw= 1 20000 0 1 1 1779175233 296175282 20000 20000 0 1 26 100000017 Testing DS order from API 19-05-2026 12:50:33 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 FSL NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 1 0 0 0 0 NULL KSPL BOMBAY ONLINE CPPAPI NULL COMPLETE Fill NULL 11111 NULL NULL NULL 1779175233 NULL L3LLWL22 NULL NULL 111111111111100 NULL NULL O3O4O4O KKWMM2M2 KKWMM2M2 0 0 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000049 AND `TradeBook`.`fill_id` = \'100000020\'
26051900000049 1779175807 123808003 85 1 50 49 ANANYARAMA3 ANANYARAMA3 LODHA-EQ NSE 3220 B LMT H DAY C _gWJ9NNn4WX4mDcBgjbAMUSPheCuTiXpmwk0= 1 85160 0 1 1 1779175807 629580199 85160 85160 0 0 28 100000020 NULL 19-05-2026 13:00:07 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 LODHA NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 5 0 0 0 0 NOREN_WEB KSPL Mangaluru KSPL WEB 115.246.215.139 COMPLETE Fill NULL 11111 WEB Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWeb... 4f247265-1ab9-416c-a478-19430a117dba 1779175674 NULL Depth NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 100 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000050 AND `TradeBook`.`fill_id` = \'100000019\'
26051900000050 1779175807 123768729 87 1 50 49 ANANYARAMA ANANYARAMA LODHA-EQ NSE 3220 S LMT M DAY C _gWJ9NNn4WX4mDcBgjbAMUSPheCuTiXpmwk0= 1 85160 0 1 1 1779175807 122489352 85160 85160 0 0 29 100000019 19-05-2026 13:00:07 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 LODHA NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL Mangaluru ANANYARAMA TT 115.246.215.139 COMPLETE Fill NULL 11111 DESKTOP TT/1.0.8(Dell_Inc. Dell_Pro_16_PC16250; Windows NT... 377cde9f-92c2-4dee-b987-7329db0d0a5a 1779175807 NULL NULL NULL NULL 111111111111100 NULL NULL NULL NULL NULL 0 0 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000055 AND `TradeBook`.`fill_id` = \'100000021\'
26051900000055 1779178676 459815869 99 1 50 49 DHANUINV DHANUINV ABB-EQ NSE 13 B LMT M DAY C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 1 641350 0 1 1 1779178676 459487363 641350 641350 0 0 33 100000021 NULL 19-05-2026 13:47:56 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ABB NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 50 0 0 0 0 NOREN_MOB KSPL mangalore KSPL MOB 115.246.215.139 COMPLETE Fill NULL 11111 ANDROID Mozilla/5.0 (Linux; Android 11; 220233L2I Build/RP... 9b6dcbf1-f964-4f25-9244-4a44fca7d08b 1779178676 NULL BasketOrder NULL NULL 333333333333100 NULL NULL NULL NULL NULL 0 0 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000059 AND `TradeBook`.`fill_id` = \'100000023\'
26051900000059 1779178705 406371783 107 1 50 49 DHANUINV DHANUINV ABB-EQ NSE 13 B LMT M DAY C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 1 641350 0 1 1 1779178705 405698425 641350 641350 0 0 37 100000023 NULL 19-05-2026 13:48:25 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ABB NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 50 0 0 0 0 NOREN_MOB KSPL mangalore KSPL MOB 115.246.215.139 COMPLETE Fill NULL 11111 ANDROID Mozilla/5.0 (Linux; Android 11; 220233L2I Build/RP... 9b6dcbf1-f964-4f25-9244-4a44fca7d08b 1779178705 NULL BasketOrder NULL NULL 333333333333100 NULL NULL NULL NULL NULL 0 0 0 0 0 50 0 0.0000 0 0 0.00
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 26051900000063 AND `TradeBook`.`fill_id` = \'100000025\'
26051900000063 1779179294 902923293 117 1 48 49 DHANUINV DHANUINV ABB-EQ NSE 13 B LMT M DAY C _gWJ9NNmIKQ5WDU08d8jFRiOFCqtRtkRMGnw= 10 641350 0 8 8 1779179294 901919948 641350 641350 0 0 40 100000025 NULL 19-05-2026 13:58:14 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ABB NULL NSE EQT NULL 0-JUN-2026 NULL NULL EQ NULL NULL 0 50 0 0 0 0 NOREN_MOB KSPL mangalore KSPL MOB 115.246.215.139 OPEN Fill NULL 11111 ANDROID Mozilla/5.0 (Linux; Android 11; 220233L2I Build/RP... 9b6dcbf1-f964-4f25-9244-4a44fca7d08b 1779179294 NULL placeorder NULL NULL 333333333333100 NULL NULL NULL NULL NULL 0 0 0 0 0 48 0 0.0000 0 0 0.00
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

将此 SQL 查询加为书签 将此 SQL 查询加为书签