Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1353749
Description of problem:
when using filters for Dashboard in Satellite 6.2 an sql error occurs.

Version-Release number of selected component (if applicable):

How reproducible:

Always
Steps to Reproduce:
1.Create filters for users.
2.login as user and press dashboard.
3.

Actual results:
Oops, we're sorry but something went wrong PG::Error: ERROR: missing FROM-clause entry for table "katello_host_collections" LINE 1: ...id" IN (1) AND "hosts"."location_id" IN (2) AND (("katello_h... ^ : SELECT COUNT FROM (SELECT DISTINCT "katello_errata"."id" AS count_column FROM "katello_errata" INNER JOIN "katello_content_facet_errata" ON "katello_content_facet_errata"."erratum_id" = "katello_errata"."id" INNER JOIN "katello_content_facet_errata" "content_facet_errata_katello_errata_join" ON "content_facet_errata_katello_errata_join"."erratum_id" = "katello_errata"."id" INNER JOIN "katello_content_facets" ON "katello_content_facets"."id" = "content_facet_errata_katello_errata_join"."content_facet_id" WHERE "katello_content_facets"."host_id" IN (SELECT "hosts"."id" FROM "hosts" WHERE "hosts"."type" IN ('Host::Managed') AND "hosts"."organization_id" IN (1) AND "hosts"."location_id" IN (2) AND (("katello_host_collections"."name" ILIKE 'oss%'))) LIMIT 6) subquery_for_count

Expected results:
Seeing the dashboard.

Additional info: