Unknown column 'kits->kitsorderitems->orderitem.id' in 'field list' Unknown column when enable required true

[diyathw]

SELECT`` Animal.*,
`animalShares`.`id` AS
`animalShares.id`,
`animalShares`.`animal_id` AS
`animalShares.animalId`,
`animalShares`.`user_id` AS
`animalShares.userId`,
`animalShares`.`share_level` AS
`animalShares.shareLevel`,
`animalShares`.`share_details` AS
`animalShares.shareDetails`,
`animalShares`.`invitee_email` AS
`animalShares.inviteeEmail`,
`animalShares`.`updated_at` AS
`animalShares.updatedAt`,
`animalShares`.`created_at` AS
`animalShares.createdAt`,
`animalShares`.`animal_id` AS
`animalShares.AnimalId`,
`animalShares`.`user_id` AS
`animalShares.UserId`,
`species`.`id` AS `species.id`,
`species`.`name` AS `species.name`
,
`vet`.`id` AS
`vet.id`,
`vet`.`first_name` AS
`vet.firstName`,
`vet`.`last_name` AS `vet.lastName`
,
`breed`.`id` AS
`breed.id`,
`breed`.`name` AS `breed.name`,
`breed->images`.`id` AS
`breed.images.id`,
`petCharacter`.`id` AS
`petCharacter.id`,
`petCharacter`.`type` AS
`petCharacter.type`,
`images`.`id` AS `images.id`,
`kits`.`id` AS `kits.id`,
`kits`.`barcode` AS `kits.barcode`
,
`kits`.`animal_id` AS
`kits.animalId`,
`kits->kitsOrderItems`.`oder_item_id` AS
`kits.kitsOrderItems.orderItemId`,
`kits->kitsOrderItems`.`kit_id` AS
`kits.kitsOrderItems.kitId`,
`kits->kitsOrderItems`.`test` AS
`kits.kitsOrderItems.test`,
`kits->kitsOrderItems->orderItem->product->images`.`id` AS
`kits.kitsOrderItems.orderItem.product.images.id`
FROM (SELECT `Animal`.`id`,
`Animal`.`pet_name` AS `petName`,
`Animal`.`user_id` AS `userId`,
`Animal`.`registration_name` AS
`registrationName`,
`Animal`.`registration_number` AS
`registrationNumber`,
`Animal`.`chip_number` AS `chipNumber`
,
`Animal`.`gender`,
`Animal`.`weight`,
`Animal`.`weight_type` AS `weightType`
,
`Animal`.`colour`,
`Animal`.`breed_id` AS `breedId`,
`Animal`.`species_id` AS `speciesId`,
`Animal`.`dob_day` AS `dobDay`,
`Animal`.`dob_month` AS `dobMonth`,
`Animal`.`dob_year` AS `dobYear`,
`Animal`.`sire`,
`Animal`.`dam`,
`Animal`.`active`,
`Animal`.`clinic_address_id` AS
`clinicAddressId`,
`Animal`.`body_condition` AS
`bodyCondition`,
`Animal`.`identification_types` AS
`identificationTypes`,
`Animal`.`insurance`,
`Animal`.`vet_id` AS `vetId`,
`Animal`.`insurance` AS `breedDef`,
`Animal`.`company_id` AS `companyId`,
`Animal`.`smart_tag` AS `smartTag`,
`Animal`.`is_lost` AS `isLost`,
`Animal`.`is_archive` AS `isArchive`,
`Animal`.`is_tag_disabled` AS
`isTagDisabled`,
`Animal`.`pet_character_id` AS
`petCharacterId`,
`Animal`.`updated_at` AS `updatedAt`,
`Animal`.`created_at` AS `createdAt`,
`kits->kitsorderitems->orderitem`.`id` AS
`kits.kitsOrderItems.orderItem.id`,
`kits->kitsorderitems->orderitem`.`product_id` AS
`kits.kitsOrderItems.orderItem.product_id`,
`kits->kitsorderitems->orderitem->product`.`id` AS
`kits.kitsOrderItems.orderItem.product.id`,
`kits->kitsorderitems->orderitem->product`.`name` AS
`kits.kitsOrderItems.orderItem.product.name`
FROM `animals` AS `Animal`
WHERE ( `Animal`.`user_id` = 155 )
AND (SELECT `kits`.`animal_id`
FROM `kits` AS `kits`
INNER JOIN `kits_order_items` AS `kitsOrderItems`
ON `kits`.`id` = `kitsOrderItems`.`kit_id`
INNER JOIN `order_has_items` AS
`kitsOrderItems->orderItem`
ON `kitsOrderItems`.`oder_item_id` =
`kitsOrderItems->orderItem`.`id`
INNER JOIN `store_products` AS
`kitsOrderItems->orderItem->product`
ON `kitsOrderItems->orderItem`.`product_id` =
`kitsOrderItems->orderItem->product`.`id`
AND `kitsOrderItems->orderItem->product`.`id` = 510
WHERE ( `kits`.`animal_id` = `Animal`.`id` )
LIMIT 1) IS NOT NULL
ORDER BY `Animal`.`created_at` ASC
LIMIT 20) AS `Animal`
LEFT OUTER JOIN `users` AS `owner`
ON `Animal`.`userid` = `owner`.`id`
LEFT OUTER JOIN `animal_shares` AS `animalShares`
ON `Animal`.`id` = `animalShares`.`animal_id`
LEFT OUTER JOIN `species` AS `species`
ON `Animal`.`speciesid` = `species`.`id`
LEFT OUTER JOIN `users` AS `vet`
ON `Animal`.`userid` = `vet`.`id`
LEFT OUTER JOIN `breeds` AS `breed`
ON `Animal`.`breedid` = `breed`.`id`
LEFT OUTER JOIN `files` AS `breed->images`
ON `breed`.`id` = `breed->images`.`model_id`
AND `breed->images`.`model_type` = 'breed'
LEFT OUTER JOIN `pet_characters` AS `petCharacter`
ON `Animal`.`petcharacterid` = `petCharacter`.`id`
LEFT OUTER JOIN `files` AS `images`
ON `Animal`.`id` = `images`.`model_id`
AND `images`.`model_type` = 'animal'
INNER JOIN `kits` AS `kits`
ON `Animal`.`id` = `kits`.`animal_id`
INNER JOIN `kits_order_items` AS `kits->kitsOrderItems`
ON `kits`.`id` = `kits->kitsOrderItems`.`kit_id`
LEFT OUTER JOIN
`files` AS `kits->kitsOrderItems->orderItem->product->images`
ON `kits.kitsorderitems.orderitem.product.id` =
`kits->kitsOrderItems->orderItem->product->images`.`model_id`
AND
`kits->kitsOrderItems->orderItem->product->images`.`model_type` = 'product'
ORDER BY `createdat` ASC;

this is the sequlize include
{
"limit": 20,
"order": [
[
"created_at",
"ASC"
]
],
"subQuery": false,
"include": [
{
"as": "owner",
"attributes": [],
"required": false
},
{
"as": "animalShares",
"required": false
},
{
"as": "species",
"attributes": [
"id",
"name"
],
"required": false
},
{
"as": "vet",
"attributes": [
"id",
"name",
"firstName",
"lastName"
],
"required": false
},
{
"as": "breed",
"attributes": [
"id",
"name"
],
"required": false,
"include": [
{
"as": "images",
"attributes": [
"id"
],
"required": false,
"where": {
"modelType": "breed"
}
}
]
},
{
"as": "petCharacter",
"attributes": [
"id",
"type"
],
"required": false
},
{
"as": "images",
"attributes": [
"id"
],
"required": false,
"where": {
"modelType": "animal"
}
},
{
"as": "kits",
"include": [
{
"as": "kitsOrderItems",
"required": true,
"include": [
{
"attributes": [
"product_id"
],
"as": "orderItem",
"required": true,
"include": [
{
"attributes": [
"id",
"name"
],
"as": "product",
"required": true,
"where": {
"id": 510
},
"include": [
{
"attributes": [
"id"
],
"as": "images",
"required": false,
"where": {
"modelType": "product"
}
}
]
}
]
}
]
}
],
"attributes": [
"barcode",
"animalId"
],
"required": true
}
],
"where": {}
}

[ephys]

Please follow the issue template, as well as use markdown code blocks, when opening an issue