SQLite Forum

Using windows function
Login
Chronological Hierarchical 
I think you need a "partition by" in there
... over (partition by t1.accit order by...
...but I'm not the most familiar with window functions