DATE: 2025.12.03 04:32:20
ID: gnt6-kcc0-ndvt-6k
EXCEPTION: SQL error "Unknown column 'A.Priority' in 'ORDER BY'" in query:
SELECT
H.*,
(
SELECT
`HA`.`Category_Name` AS `Category_Category_Name`
FROM (
SELECT
`HA`.`_Rid`,
`HA`.`Enabled`,
`HA`.`Category`,
`CategoryMain`.`Name` AS `Category_Name`
FROM `psb_common_product`.`InfoverCategory` AS `HA`
LEFT JOIN `psb_common_product`.`CategoryMain` AS `CategoryMain` ON (`HA`.`Category`=`CategoryMain`.`_Rid`)AND((`CategoryMain`.`Enabled`=1) AND (ISNULL((`CategoryMain`.`_Deleted`))))
WHERE (`HA`.`Enabled`=1)
) AS `HA`
WHERE (`H`.`Category`=`HA`.`_Rid`)
LIMIT 0,1
) AS `Category_Category_Name`,
(
SELECT
`HA`.`Producer_Name` AS `Producer_Producer_Name`
FROM (
SELECT
`HA`.`_Rid`,
`HA`.`_Deleted`,
`HA`.`Enabled`,
`HA`.`Producer`,
`Producer`.`Name` AS `Producer_Name`
FROM `psb_common_product`.`InfoverProducer` AS `HA`
LEFT JOIN `psb_common_producer`.`Producer` AS `Producer` ON (`HA`.`Producer`=`Producer`.`_Rid`)AND(ISNULL((`Producer`.`_Deleted`)))
WHERE (((`HA`.`Enabled`=1)) AND ((ISNULL(((`HA`.`_Deleted`))))))
) AS `HA`
WHERE (`H`.`Producer`=`HA`.`_Rid`)
LIMIT 0,1
) AS `Producer_Producer_Name`,
(
SELECT
`HA`.`Producer_RewritePL` AS `Producer_Producer_RewritePL`
FROM (
SELECT
`HA`.`_Rid`,
`HA`.`_Deleted`,
`HA`.`Enabled`,
`HA`.`Producer`,
`Producer`.`RewritePL` AS `Producer_RewritePL`
FROM `psb_common_product`.`InfoverProducer` AS `HA`
LEFT JOIN `psb_common_producer`.`Producer` AS `Producer` ON (`HA`.`Producer`=`Producer`.`_Rid`)AND(ISNULL((`Producer`.`_Deleted`)))
WHERE (((`HA`.`Enabled`=1)) AND ((ISNULL(((`HA`.`_Deleted`))))))
) AS `HA`
WHERE (`H`.`Producer`=`HA`.`_Rid`)
LIMIT 0,1
) AS `Producer_Producer_RewritePL`
FROM (
SELECT
`A`.`_Rid`,
`A`.`_Deleted`,
`A`.`Enabled`,
`A`.`Site`,
`A`.`Id`,
`A`.`Name`,
`A`.`ProductId`,
`A`.`Unit`,
`A`.`UnitSi`,
`A`.`ModifierSi`,
`A`.`UnitShop`,
`A`.`ModifierShop`,
`A`.`Photos`,
`A`.`RewritePL`,
`A`.`Body`,
`A`.`ProductIndex`,
`A`.`DateCreated`,
`A`.`Category`,
`A`.`Producer`,
`InfoverCategory`.`Category` AS `Category_Category`,
`InfoverProduct_ProducerImpact`.`ProducerImpact`,
`InfoverProduct_InfoverProductBadge`.`Priority` AS `InfoverProductBadge_Priority`,
`InfoverProduct_InfoverProductBadge`.`Name` AS `InfoverProductBadge_Name`,
`InfoverProduct_InfoverProductBadge`.`Color` AS `InfoverProductBadge_Color`
FROM `psb_common_product`.`InfoverProduct` AS `A`
LEFT JOIN `psb_common_product`.`InfoverCategory` AS `InfoverCategory` ON (`A`.`Category`=`InfoverCategory`.`_Rid`)AND(`InfoverCategory`.`Enabled`=1)
LEFT JOIN `psb_common_product`.`InfoverProduct_ProducerImpact` ON `InfoverProduct_ProducerImpact`.`_Rid`=`A`.`_Rid`
LEFT JOIN `psb_common_product`.`InfoverProduct_InfoverProductBadge` ON `InfoverProduct_InfoverProductBadge`.`_Rid`=`A`.`_Rid`
WHERE (((`A`._Rid IN(SELECT L0._Rid FROM `psb_common_product`.`InfoverProduct_CategoryImpact` AS L0 WHERE (`L0`.`CategoryImpact`='d2f9j6m0fse0fi') ))) AND (((`InfoverProduct_ProducerImpact`.`ProducerImpact` IN ('m69cmet0bgocle')))) AND ((`A`.`Enabled`=1)) AND ((ISNULL(((`A`.`_Deleted`))))))
ORDER BY (1000*(IF(NOT COALESCE(ISNULL((`A`.`Priority`)),FALSE),1,0))) DESC,`A`.`DateCreated` DESC
LIMIT 0,100
) AS `H`
ORDER BY (1000*(IF(NOT COALESCE(ISNULL((`H`.`InfoverProductBadge_Priority`)),FALSE),1,0))) DESC,`H`.`DateCreated` DESC
LINE: 8674 of file /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php
GET: http://www.grupapsb.com.pl/produkty/wyposazenie-swieczniki-lampiony?ProducerImpact=dajar
HOST: 216.73.216.116
AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
PID: 954281
USER:
SESSION: 7bhxHTmjEJjuOt4tAFLtats3UXomWs1b
REQUEST: but70530ndvt6k
CALL STACK:
line 4498 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function CollectionLoad()
line 366 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function CollectionLoad()
line 6208 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function iCollectionLoad()
line 6231 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function RecordsLoad()
line 6950 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function Process()
line 10 in /home/hosting/www/psb_web/www/vendor/psb/web/application/classes/UrlBackFilterList.php function Process()
line 200 in /home/hosting/www/psb_web/www/vendor/psb/web/application/classes/ProductList.php function Process()
line 1414 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore1.php function Process()
line 1426 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore1.php function boxProcess()
line 4220 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore1.php function boxProcess()
line 4184 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore1.php function ApplicationRequest()
line 664 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore1.php function ApplicationRun()
line 16 in /home/hosting/www/psb_web/www/vendor/impact/engine/index.php function iApplicationRun()