fixes #9773 - correctly render template URL

(cherry picked from commit f7174439285708c3010605230fec16797f3a0763)

fixes #10269 - host template preview now opens in a new tab

(cherry picked from commit 77340df814adbae9ea0d66f718b8731872e33631)

fixes #8817 - look up reports with all joins from host scoped_search

This changes the optimisation in d50c799 which caused errors for users with
host filters referencing tables other than hosts.

When retrieving all reports joined with authorised hosts, the nested joins need...

Fixes #9391 - Added validation code to NIC, so it validates that host's location/org is compatible with the one set on NIC's subnet

(cherry picked from commit 8f695d94a2f32fea3363cc017fc59baf6ca15b17)

fixes #9617 - rescue from empty vmware clusters

(cherry picked from commit d76ca3043ca1bac1229667e342da149e3cd6f304)

Fixes #9884 - refresh deleted external usergroups

(cherry picked from commit e780381933a7838af4be9a550942ef0f22608fd4)

Fixes #9878 - refresh external usergroup on API manipulation

(cherry picked from commit 22d2b02fefc54228631008181c3d0db0b2360d28)

Fixes #4787 - prevent unneeded AJAX requests on popover clicks

(cherry picked from commit 71b46a7296d01553a471833d34e3b55d0413545d)

fixes #5909 - return r/w resources from authorized scope

(cherry picked from commit 0d80512c3293895750ffda82489b719c38ec5612)

Fixes #8593 - remove N+1 queries on puppetclass index page

(cherry picked from commit 0e5fefb087492c926e32417039528d0a105d51a0)