SELECT DISTINCT ON ("monitoringengine_ui_objectpermission"."object_id")
    "monitoringengine_ui_resource"."id" AS "resource_id",
    "monitoringengine_ui_resource"."account_id",
    "monitoringengine_ui_account"."name",
    COUNT("yandex_accounts_subscriptions"."id")
FROM "monitoringengine_ui_objectpermission"
INNER JOIN "auth_permission"
    ON ("monitoringengine_ui_objectpermission"."permission_id" = "auth_permission"."id")
INNER JOIN "auth_user_user_permissions"
    ON ("auth_permission"."id" = "auth_user_user_permissions"."permission_id")
INNER JOIN "monitoringengine_ui_resource"
    ON ("monitoringengine_ui_objectpermission"."object_id" = "monitoringengine_ui_resource"."id")
INNER JOIN "monitoringengine_ui_account"
    ON ("monitoringengine_ui_resource"."account_id" = "monitoringengine_ui_account"."id")
INNER JOIN "yandex_accounts_subscriptions"
    ON ("monitoringengine_ui_resource"."id" = "yandex_accounts_subscriptions"."resource_id")
WHERE (
    "auth_user_user_permissions"."user_id" = 28
    AND "monitoringengine_ui_objectpermission"."content_type_id" = 19 )
GROUP BY
    "monitoringengine_ui_resource"."id",
    "monitoringengine_ui_resource"."account_id",
    "monitoringengine_ui_account"."name",
    "monitoringengine_ui_objectpermission"."object_id";