SQL Errors

[lperepol]

Ext Js 7.3.xxx Windows 10

parent: [Error: SQLITE_ERROR: ambiguous column name: organization_id] {
errno: 1,
code: 'SQLITE_ERROR',
sql: "SELECT count() AS count FROM people AS Person LEFT OUTER JOIN offices AS office ON Person.office_id = office.id LEFT OUTER JOIN
organizations AS organization ON Person.organization_id = organization.id LEFT OUTER JOIN people AS organization->manager ON organization
.manager_id = organization->manager.id LEFT OUTER JOIN offices AS organization->manager->office ON organization->manager.office_id = organiza tion->manager->office.id WHERE organization_id = 'f8379d72-0a57-4c25-86c8-e9761e4b8086';"
},
original: [Error: SQLITE_ERROR: ambiguous column name: organization_id] {
errno: 1,
code: 'SQLITE_ERROR',
sql: "SELECT count() AS count FROM people AS Person LEFT OUTER JOIN offices AS office ON Person.office_id = office.id LEFT OUTER JOIN
organizations AS organization ON Person.organization_id = organization.id LEFT OUTER JOIN people AS organization->manager ON organization
.manager_id = organization->manager.id LEFT OUTER JOIN offices AS organization->manager->office ON organization->manager.office_id = organiza tion->manager->office.id WHERE organization_id = 'f8379d72-0a57-4c25-86c8-e9761e4b8086';"
},
sql: "SELECT count(*) AS count FROM people AS Person LEFT OUTER JOIN offices AS office ON Person.office_id = office.id LEFT OUTER JOIN organizations AS organization ON Person.organization_id = organization.id LEFT OUTER JOIN people AS organization->manager ON organization. manager_id = organization->manager.id LEFT OUTER JOIN offices AS organization->manager->office ON organization->manager.office_id = organizati on->manager->office.id WHERE organization_id = 'f8379d72-0a57-4c25-86c8-e9761e4b8086';",
parameters: undefined
}