The query took about 90 to 100% cpu-time for 30 minutes, before I lost my patience... killed it and tweaked the query, it returned the 927 rows of data in less than 2 seconds.
Gonna visit my parents tonight, to arrange for grandma's funeral and such.