From Book "Your Code As a Crime Scene" Cypher query for hotspots

codeascrimescene_hotspot.cypher

MATCH
    (l:Linecount), (g:GitFile)
WHERE
    g.relativePath =~ ('.*'+l.name)
WITH
    distinct g, l.linecount as linecount
MATCH
    (g)--(cf:GitCommitFile)
RETURN
    g.relativePath, count(cf) as revisions, linecount
ORDER BY
    revisions desc, linecount desc;