



MATCH 
(contract:/mingdao1/contract WHERE attr15 > 34500 and attr15 < 35500)
-[:is_contract_of_project*1..1]->
(project:/mingdao1/project WHERE attr3 is not null), 
(sales:/mingdao1/staff)
-[:is_duty_sales_of_contract*1..1]->
(contract:/mingdao1/contract WHERE attr15 > 34500 and attr15 < 35500), 
(pm:/mingdao1/staff)
-[:is_admin_of_project*1..1]->
(project:/mingdao1/project WHERE attr3 is not null) 
RETURN project.attr3 AS "项目名称", sales.attr1 AS "责任销售", pm.attr1 AS "项目经理名称"
with timeout = 3m
/**
output()
count(43)
**/
;


MATCH 
(company:/dsq_stock/public_company)-[:public_company_belongs_to_industry_stock_industry_category_lv3*1..1]->(category:/dsq_stock/stock_industry_category_lv3), 
(company:/dsq_stock/public_company)-[:public_company_to_a_stock_price*1..1]->(stock_price:/dsq_stock/a_stock_price WHERE trade_date = '20250718'), 
(company:/dsq_stock/public_company)-[:public_company_to_a_stock_financial_indicator*1..1]->
(financial_indicator:/dsq_stock/a_stock_financial_indicator WHERE report_period = '20241231') 
/**
timeout(10m)
output()
match("graph.edges.len",16245,"graph.nodes.len",16582)
**/
;

MATCH 
(company:/dsq_stock/public_company)-[:public_company_belongs_to_industry_stock_industry_category_lv3*1..1]->
(category:/dsq_stock/stock_industry_category_lv3), 
(company:/dsq_stock/public_company)-[:public_company_to_a_stock_price*1..1]->
(stock_price:/dsq_stock/a_stock_price WHERE trade_date = '20250718'), 
(company:/dsq_stock/public_company)-[:public_company_to_a_stock_financial_indicator*1..1]->
(financial_indicator:/dsq_stock/a_stock_financial_indicator WHERE report_period = '20241231') 
RETURN company.symbol AS "symbol", stock_price.total_mv AS "total_mv", stock_price.dividend_yield AS "dividend_yield", financial_indicator.net_profit AS "net_profit"
 WITH TIMEOUT = 60m
/**
output()
count(5415)
**/
;


SELECT room.room_number AS "room_number", 
room.usable_area AS "usable_area", 
room.office_staff_count AS "office_staff_count" 
INTO /temp_room_area_e2f601d7-ae1e-4576-bca9-289ab32024aa 
FROM /hxyy/room room 
WHERE room.allocated_area > 0 AND room.excess_area > 0 AND room.office_staff_count > 0 
LIMIT 0, 500000 
WITH TIMEOUT = 6m
;

select * from /temp_room_area_e2f601d7-ae1e-4576-bca9-289ab32024aa 
/**
output()
**/
;

MATCH (player_attr:'Player_Attributes:00013795','Player_Attributes:00013796','Player_Attributes:00013797')-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:'Player:*') 
RETURN player_attr.long_shots AS "long_shots", player_attr.id, player.id, player.player_name
with inline
/**
timeout(5m)
output()
metainfo()
sleep(10s)
**/;



MATCH (player_attr:'Player_Attributes:*379?')-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots", player_attr.id
/**
timeout(5m)
output()
metainfo()
sleep(10s)
**/;



MATCH (player_attr:Player_Attributes)-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots", player_attr.id
with timeout=10s
/**
onerror(continue,"timeout 10s","context canceled")
output()
metainfo()
**/;

MATCH (player_attr:'*')-[]->(player:"*") 
RETURN player_attr.long_shots AS "long_shots", player_attr.id
/**
onerror(continue,"need more search conditions", "unsure namespace")
output()
metainfo()
**/;

MATCH (player_attr:'*')-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:"*") 
RETURN player_attr.long_shots AS "long_shots", player_attr.id
/**
onerror(continue,"not exist","too more")
output()
metainfo()
**/;

MATCH (player_attr:'*')-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots", player_attr.id
with timeout=5m
/**
timeout(5m)
onerror(continue,"too more")
output()
metainfo()
**/;

MATCH (player_attr:'*379*')-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots", player_attr.id
/**
timeout(5m)
output()
metainfo()
**/;


MATCH (player_attr:'*butes:*379*')-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots", player_attr.id
/**
timeout(5m)
output()
metainfo()
**/;

MATCH (player_attr:'Player_Attributes:*379?')-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots", player_attr.id
/**
timeout(5m)
output()
metainfo()
**/;


MATCH (player_attr:Player_Attributes)-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots", player_attr.id
/**
timeout(5m)
output()
metainfo()
**/;

MATCH (player_attr:/birddata/player_attributes)-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots"
/**
timeout(5m)
output()
metainfo()
**/;

MATCH (player_attr:/birddata/player_attributes)-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots" INTO /qqq0
/**
timeout(5m)
output()
metainfo()
**/;

select * from /qqq0
/**
output()
**/;

SELECT avg(t0.long_shots) AS "average_long_shots" FROM /qqq0 t0 LIMIT 0, 20000
/**
output()
**/;
