extra filter handling improved
paths fix - use explicit outer joins