Fix resolving app url nodes for translations.

Situation:
- `/` is translated
- `/news/` is untranslated.

both are level 0.

Now, the query is limited to the UrlNode types which actually host app
pages.
Fix honoring `hide_untranslated` setting in sitemaps.