odbtools/odbctest/mql/0/1.mql

-- MATCH (ptr:/project_1000119_harness_draft/paper_trade_record)
-- -[:project_1000119_harness_draft_trades_on*1..1]->
-- (ti:/project_1000119_harness_draft/trade_instrument 
-- WHERE instrument_id in ('INSTRUMENT_000000001', 'INSTRUMENT_000000002', 'INSTRUMENT_000000003', 'INSTRUMENT_000000004', 'INSTRUMENT_000000005', 'INSTRUMENT_000000006', 'INSTRUMENT_000000007', 'INSTRUMENT_000000008', 'INSTRUMENT_000000009', 'INSTRUMENT_000000010')) 
-- WITH TIMEOUT = 60m
-- /**
-- match('graph.nodes.len', 284873, 'graph.edges.len', 284863)
-- **/
-- ;

MATCH (ptr:/project_1000119_harness_draft/paper_trade_record)
-[:project_1000119_harness_draft_trades_on*1..1]->
(ti:/project_1000119_harness_draft/trade_instrument 
WHERE instrument_id in ('INSTRUMENT_000000001', 'INSTRUMENT_000000002', 'INSTRUMENT_000000003', 'INSTRUMENT_000000004', 'INSTRUMENT_000000005', 'INSTRUMENT_000000006', 'INSTRUMENT_000000007', 'INSTRUMENT_000000008', 'INSTRUMENT_000000009', 'INSTRUMENT_000000010')) 
RETURN ti.instrument_id AS "instrument_id", ptr.trade_record_id AS "trade_record_id"
WITH TIMEOUT = 6000m
/**
count(284863)
**/
;


SELECT temp.instrument_id AS "instrument_id", count(temp.trade_record_id) AS "trade_count" FROM 
(MATCH (ptr:/project_1000119_harness_draft/paper_trade_record)
-[:project_1000119_harness_draft_trades_on*1..1]->
(ti:/project_1000119_harness_draft/trade_instrument 
WHERE instrument_id in ('INSTRUMENT_000000001', 'INSTRUMENT_000000002', 'INSTRUMENT_000000003', 'INSTRUMENT_000000004', 'INSTRUMENT_000000005', 'INSTRUMENT_000000006', 'INSTRUMENT_000000007', 'INSTRUMENT_000000008', 'INSTRUMENT_000000009', 'INSTRUMENT_000000010')) 
RETURN ti.instrument_id AS "instrument_id", ptr.trade_record_id AS "trade_record_id") 
temp GROUP BY temp."instrument_id" ORDER BY temp."trade_record_id" DESC WITH TIMEOUT = 6000m
/**
output()
**/
;