error ocurred [Unknown column 'ext.archived' in 'where clause'] [SELECT
`item`.`id`
,`item`.`timestamp`
,`item`.`label`
,`item`.`description`
,`item`.`expirationDateTime`
,`item`.`releaseDateTime`
,`ext`.`stock`
,`ext`.`location`
,REPLACE(FORMAT(ROUND(`price`.`price` * (100/(100+`price`.`tax`)),2),2),',',' ') AS `priceWithTax`,ROUND(`price`.`price`,2) AS priceWithoutTax
,REPLACE(FORMAT(ROUND(`price`.`priceAlternative` * (100/(100+`price`.`tax`)),2),2),',',' ') AS `priceAlternativeWithTax`,ROUND(`price`.`priceAlternative`,2) AS priceAlternativeWithoutTax
,REPLACE(FORMAT(ROUND(`price`.`price` * (1+(`price`.`tax`/100)) * (`price`.`tax`/100)),0),',',' ') AS `priceTax`
,REPLACE(FORMAT(ROUND( `price`.`priceAlternative` * (1+(`price`.`tax`/100)) * (`price`.`tax`/100)),0),',',' ') AS `alternativePriceTax`
,`price`.`tax`
,`stru`.`wiseUrl`
FROM
`udssDataItem` `item`
LEFT JOIN `udssItemProductExtension` `ext` ON `item`.`id`=`ext`.`itemId`
LEFT JOIN `udssItemProductPrice` `price` ON `price`.`itemId`=`item`.`id` AND `price`.`currency`='CZK'
LEFT JOIN `udssDataItemRel` `rel` ON `item`.`id`=`rel`.`itemId`
LEFT JOIN (`udssItemRelStructure` `relStru`, `udssStructure` `stru`,`udssStructureGroup` `struGr`) ON (`item`.`id`=`relStru`.`itemId` AND `item`.`timestamp`=`relStru`.`itemTimestamp` AND `relStru`.`structureId`=`stru`.`id` AND `stru`.`structureGroupId`=`struGr`.`id`)
WHERE
`item`.`dataTypeId` = 46
AND (`item`.`releaseDateTime`<'2023-06-08 13:55:38' OR `item`.`releaseDateTime` IS NULL OR `item`.`releaseDateTime`='')
AND (`item`.`expirationDateTime`>'2023-06-08 13:55:38' OR `item`.`expirationDateTime` IS NULL OR `item`.`expirationDateTime`='')
AND (item.id, item.timestamp) IN(select
`item`.`id` AS `id`,
`item`.`timestamp` AS `timestamp`
FROM
`udssDataItem` `item`
LEFT JOIN `aclGroupDataItem` `aclGroup` ON `item`.`id` = `aclGroup`.`itemId` AND `item`.`timestamp` = `aclGroup`.`itemTimestamp`
WHERE
`aclGroup`.`permission` IN('read','write')
AND `aclGroup`.`groupHash` = '4c9184f37cff01bcdc32dc486ec36961')
# archivovane jsou skryte
AND `ext`.`archived` = '0'
GROUP BY
`item`.`id`] [at:%DOC_ROOT%/_contentGenerator/feeds/zbozicz-xmlFeed.php:76]
