I am looking for a query that shows me all projects with or without subprojects but EXCLUDING the subprojects.
So e.g. I have the following projects
x = project without subproject
y = project with subproject
z = subproject
then the query should only show x,y
any idea which query to use?