问理解Cypher查询

EN

start n=node:node_auto_index(name="root_node")
match n-[:SC]->c, b<-[:CB]-c-[:CB]->b1
where (b.days_in_number - b1.days_in_number <= 7) AND (b.days_in_number > b1.days_in_number)
and c.name = "C16659"
with  distinct n,c, b, b1
match  n-[:SC]->c-[:CB]->b-[:CT]->i1, n-[:SC]->c-[:CB]->b1-[:CT]->i2 
with b.name as bname,b1.name as b1name,i1.name as i1name,i2.name as i2name
return  bname,b1name,i1name,i2name
order by bname,b1name,i1name,i2name;

start n=node:node_auto_index(name="root_node") 
match n-[:SC]->c, b<-[:CB]-c-[:CB]->b1
where (b.days_in_number - b1.days_in_number <= 7) AND (b.days_in_number > b1.days_in_number)
and c.name = "C16659"
with  distinct n,c, b, b1
match  b-[:CT]->i1, b1-[:CT]->i2 
with b.name as bname,b1.name as b1name,i1.name as i1name,i2.name as i2name
return  bname,b1name,i1name,i2name
order by bname,b1name,i1name,i2name;

start n=node:node_auto_index(name="root_node") 
match n-[:SC]->c, b<-[:CB]-c-[:CB]->b1
where (b.days_in_number - b1.days_in_number <= 7) AND (b.days_in_number > b1.days_in_number)
and c.name = "C16659"
with  distinct n,c, b, b1
match  c-[:CB]->b-[:CT]->i1, c-[:CB]->b1-[:CT]->i2 
with n.name as nname,c.name as cname, b.name as bname,b1.name as b1name,i1.name as i1name,i2.name as i2name
return  nname,cname,bname,b1name,i1name,i2name
order by nname,cname,bname,b1name,i1name,i2name;