# Bug OP-3828 - Invalid SQL statement produced by watchers filter

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-3828

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 7.0.2 |
| Observed in versions |  |
| Sprint | 7.0.2 |
| Backlog bucket |  |
| Bug found in version (deprecated) |  |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

Recorded in the log:

    ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error at or near "ORDER"LINE 13: )) ORDER BY work_packages.id DESC, work_packages.root_id, wo... ^: SELECT "work_packages"."id" FROM "work_packages" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "work_packages"."status_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "work_packages"."project_id" LEFT OUTER JOIN "types" ON "types"."id" = "work_packages"."type_id" LEFT OUTER JOIN "users" ON "users"."id" = "work_packages"."assigned_to_id" LEFT OUTER JOIN "users" "responsibles_work_packages" ON "responsibles_work_packages"."id" = "work_packages"."responsible_id" LEFT OUTER JOIN "versions" ON "versions"."id" = "work_packages"."fixed_version_id" LEFT OUTER JOIN "work_packages" "parents_work_packages" ON "parents_work_packages"."id" = "work_packages"."parent_id" WHERE "work_packages"."project_id" IN (SELECT DISTINCT "projects"."id" FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_packages') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL)) AND ((projects.id IN (2)) AND (statuses.is_closed='f') AND ( work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6') OR work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6')) AND projects.id IN (SELECT DISTINCT projects.id FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_package_watchers') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL)))) ORDER BY work_packages.id DESC, work_packages.root_id, work_packages.lft LIMIT $1 OFFSET $2

    ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error at or near "ORDER"LINE 13: ...ND (work_packages.assigned_to_id IN ('74','24'))) ORDER BY w... ^: SELECT "work_packages"."id" FROM "work_packages" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "work_packages"."status_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "work_packages"."project_id" LEFT OUTER JOIN "types" ON "types"."id" = "work_packages"."type_id" LEFT OUTER JOIN "users" ON "users"."id" = "work_packages"."assigned_to_id" LEFT OUTER JOIN "users" "responsibles_work_packages" ON "responsibles_work_packages"."id" = "work_packages"."responsible_id" LEFT OUTER JOIN "versions" ON "versions"."id" = "work_packages"."fixed_version_id" LEFT OUTER JOIN "work_packages" "parents_work_packages" ON "parents_work_packages"."id" = "work_packages"."parent_id" WHERE "work_packages"."project_id" IN (SELECT DISTINCT "projects"."id" FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_packages') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL)) AND ((projects.id IN (2)) AND (statuses.is_closed='f') AND ( work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6') OR work_packages.id IN (SELECT watchers.watchable_id FROM watchers WHERE watchers.watchable_type='WorkPackage' AND watchers.user_id IN ('6')) AND projects.id IN (SELECT DISTINCT projects.id FROM "projects" LEFT OUTER JOIN "members" ON "projects"."id" = "members"."project_id" AND "members"."user_id" = 6 AND "projects"."status" = 1 INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."status" = 1 INNER JOIN "role_permissions" ON "role_permissions"."permission" IN ('view_work_package_watchers') INNER JOIN "roles" "permission_roles" ON "permission_roles"."id" = "role_permissions"."role_id" LEFT OUTER JOIN "member_roles" ON "members"."id" = "member_roles"."member_id" LEFT OUTER JOIN "roles" "assigned_roles" ON "assigned_roles"."id" = "permission_roles"."id" AND "projects"."status" = 1 AND ("assigned_roles"."id" = "member_roles"."role_id" OR "projects"."is_public" = 't' AND "assigned_roles"."builtin" = 1 AND "member_roles"."id" IS NULL) WHERE ("assigned_roles"."id" IS NOT NULL))) AND (work_packages.assigned_to_id IN ('74','24'))) ORDER BY work_packages.id DESC, work_packages.root_id, work_packages.lft LIMIT $1 OFFSET $2

**Steps**

  - Be non admin
  - Go to my page
  - Have watched work packages block configured
  - Follow “View all watched work packages”  
    OR
  - Be non admin
  - Go to wp list
  - Add “watchers” filter and select “me” value
