SELECT     type_id AS id,     COUNT (issues.id) AS COUNT FROM issues.issues WHERE id IN  (SELECT t0.id FROM issues.issues t0 LEFT OUTER JOIN workgroups.workgroup_members assigned_user_workgroups ON assigned_user_workgroups.user_id = t0.assigned_user_id LEFT OUTER JOIN users.organizations assigned_organizations ON assigned_organizations.id = t0.assigned_organization_id LEFT OUTER JOIN workgroups.workgroup_members user_workgroups ON user_workgroups.user_id = t0.user_id LEFT OUTER JOIN users.organizations ON organizations.id = t0.organization_id WHERE    (t0.archive IS NULL OR t0.archive IS NOT NULL AND t0.archive = FALSE)     AND t0.deleted IS NULL    AND type_id IS NOT NULL AND(((((((text~*'61818')OR(title~*'61818'))OR(t0.id::text LIKE '%61818%'))AND((organizations.workgroup_id IN (168, 291, 100000737))OR(assigned_organizations.workgroup_id IN (168, 291, 100000737))))AND(is_template=FALSE))AND(archive=FALSE))AND((custom_fields->'dispatch'->>'value')='Таганский ОДС № 6'))) GROUP BY type_id

 SELECT DISTINCT t0.id AS id, t0.issue_date, t0.type_id, t0.priority_id, t0.update_date, t0.deadline, t0.title FROM issues.issues t0 LEFT OUTER JOIN workgroups.workgroup_members assigned_user_workgroups ON assigned_user_workgroups.user_id = t0.assigned_user_id LEFT OUTER JOIN users.organizations assigned_organizations ON assigned_organizations.id = t0.assigned_organization_id LEFT OUTER JOIN workgroups.workgroup_members user_workgroups ON user_workgroups.user_id = t0.user_id LEFT OUTER JOIN users.organizations ON organizations.id = t0.organization_id WHERE t0.deleted IS NULL AND ((((((((is_template=FALSE)AND(confirmed=1))AND((assigned_user_id=100001762)OR(t0.user_id=100001762)))AND(NOT((assigned_status_id IN (4,8,9,1)))))AND(confirmed=1))AND(update_date>TIMESTAMP WITH TIME zone '2019-10-18 00:00:00+0300'))AND(archive=FALSE))AND(assigned_user_id=100001762))  ORDER BY t0.id DESC,t0.id DESC LIMIT 12 OFFSET 0

  SELECT DISTINCT t0.id AS id, t0.issue_date, t0.type_id, t0.priority_id, t0.update_date, t0.deadline, t0.title FROM issues.issues t0 LEFT OUTER JOIN workgroups.workgroup_members assigned_user_workgroups ON assigned_user_workgroups.user_id = t0.assigned_user_id LEFT OUTER JOIN users.organizations assigned_organizations ON assigned_organizations.id = t0.assigned_organization_id LEFT OUTER JOIN workgroups.workgroup_members user_workgroups ON user_workgroups.user_id = t0.user_id LEFT OUTER JOIN users.organizations ON organizations.id = t0.organization_id WHERE t0.deleted IS NULL AND (((archive=FALSE)AND(is_template=FALSE))AND(TRUE))  ORDER BY t0.issue_date DESC,t0.id DESC LIMIT 12 OFFSET 0