LOAD CSV WITH HEADERS FROM "file:////publications_test.csv" AS csvLine FIELDTERMINATOR '#' CREATE (p:PublicationTest {id: csvLine.pmid, pmid:csvLine.pmid, name: csvLine.title}) LOAD CSV WITH HEADERS FROM "file:////authors_test.csv" AS csvLine FIELDTERMINATOR '#' CREATE (p:AuthorTest {id: csvLine.author_id, author_id:csvLine.author_id, name: csvLine.name}) LOAD CSV WITH HEADERS FROM "file:////published_in_test.csv" AS csvLine FIELDTERMINATOR '#' MATCH (author:AuthorTest{author_id:csvLine.author_id}),(pub:PublicationTest {pmid:csvLine.pmid}) CREATE (author)-[:TEST_PUBLISHED_IN]->(pub) MATCH (p1:AuthorTest{author_id:"A"})-[:TEST_PUBLISHED_IN]->(m:PublicationTest)<-[:TEST_PUBLISHED_IN]-(p2:AuthorTest) RETURN p1.name, p2.name, size(collect(m)) as cP order by cP desc limit 4 QUERIES TO INCLUDE (MISSING) MATCH (p1:AuthorTest{author_id:"B"})-[:TEST_PUBLISHED_IN]->(m:PublicationTest)<-[:TEST_PUBLISHED_IN]-(p2:AuthorTest{author_id:"C"}) RETURN p1.name, p2.name, size(collect(m)) as cP order by cP desc