DATE: 2024.11.27 05:41:24
ID: bf5q-fal0-mfdq-44
EXCEPTION: SQL error "Unknown column 'InfoverProductShop.Priority' in 'order clause'" 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 `main_psb`.`InfoverCategory` AS `HA`
LEFT JOIN `main_psb`.`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_DisplayPriority` AS `Producer_DisplayPriority`
FROM (
SELECT
`HA`.`_Rid`,
`HA`.`_Deleted`,
`HA`.`Enabled`,
`HA`.`Producer`,
`Producer`.`DisplayPriority` AS `Producer_DisplayPriority`
FROM `main_psb`.`InfoverProducer` AS `HA`
LEFT JOIN `main_psb`.`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_DisplayPriority`,
(
SELECT
`HA`.`Producer_Name` AS `Producer_Producer_Name`
FROM (
SELECT
`HA`.`_Rid`,
`HA`.`_Deleted`,
`HA`.`Enabled`,
`HA`.`Producer`,
`Producer`.`Name` AS `Producer_Name`
FROM `main_psb`.`InfoverProducer` AS `HA`
LEFT JOIN `main_psb`.`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_Keywords` AS `Producer_Producer_Keywords`
FROM (
SELECT
`HA`.`_Rid`,
`HA`.`_Deleted`,
`HA`.`Enabled`,
`HA`.`Producer`,
`Producer`.`Keywords` AS `Producer_Keywords`
FROM `main_psb`.`InfoverProducer` AS `HA`
LEFT JOIN `main_psb`.`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_Keywords`,
(
SELECT
`HA`.`Producer_RewritePL` AS `Producer_Producer_RewritePL`
FROM (
SELECT
`HA`.`_Rid`,
`HA`.`_Deleted`,
`HA`.`Enabled`,
`HA`.`Producer`,
`Producer`.`RewritePL` AS `Producer_RewritePL`
FROM `main_psb`.`InfoverProducer` AS `HA`
LEFT JOIN `main_psb`.`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`,
(
SELECT
`HA`.`Category_RewritePL` AS `Category_Category_RewritePL`
FROM (
SELECT
`HA`.`_Rid`,
`HA`.`Enabled`,
`HA`.`Category`,
`CategoryMain`.`RewritePL` AS `Category_RewritePL`
FROM `main_psb`.`InfoverCategory` AS `HA`
LEFT JOIN `main_psb`.`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_RewritePL`,
(
SELECT
`HA`.`Category_Rewrite_HierarchyPL` AS `Category_Category_Rewrite_HierarchyPL`
FROM (
SELECT
`HA`.`_Rid`,
`HA`.`Enabled`,
`HA`.`Category`,
`CategoryMain`.`Rewrite_HierarchyPL` AS `Category_Rewrite_HierarchyPL`
FROM `main_psb`.`InfoverCategory` AS `HA`
LEFT JOIN `main_psb`.`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_Rewrite_HierarchyPL`
FROM (
SELECT
`A`.`_Rid`,
`A`.`Site`,
`A`.`Id`,
`A`.`Name`,
`A`.`ProductId`,
`A`.`Unit`,
`A`.`UnitSi`,
`A`.`ModifierSi`,
`A`.`UnitShop`,
`A`.`ModifierShop`,
`A`.`Enabled`,
`A`.`ProductIndex`,
`A`.`ProductSymbol`,
`A`.`YoutubeId`,
`A`.`Body`,
`A`.`BodyCount`,
`A`.`BodyPriority`,
`A`.`BodyColor`,
`A`.`Photos`,
`A`.`Files`,
`A`.`Parameters`,
`A`.`Category`,
`InfoverProduct_CategoryMain_View`.`CategoryMain_Name`,
`InfoverProduct_CategoryMain_View`.`CategoryMain_Parent_Name`,
`A`.`Producer`,
`A`.`ProducerBrand`,
`A`.`PriceTax`,
`A`.`DateImport`,
`A`.`HashImport`,
`A`.`Variant`,
`A`.`VariantColor`,
`A`.`VariantVolume`,
`A`.`VariantPhotos`,
`A`.`Weight`,
`A`.`Height`,
`A`.`Width`,
`A`.`Depth`,
`A`.`DeliveryFlag`,
`A`.`DeliveryPackType`,
`A`.`EnergyType`,
`A`.`DateCreated`,
`A`.`DateModified`,
`A`.`DateUpdated`,
`A`.`InfoverProductPrecaution`,
`A`.`Source`,
`InfoverProduct_InfoverParameterProper_Group`.`InfoverParameterProper`,
`A`.`Rewrite`,
`A`.`RewritePL`,
`A`.`SearchFull_0`,
`A`.`SearchFull_1`,
`A`.`SearchFull_2`,
`A`.`Photos` AS `_PhotosUrl`,
`InfoverProduct_InfoverPromotion`.`PriceBrutto` AS `PromotionPriceBrutto`,
`InfoverProduct_InfoverPromotion`.`Title` AS `PromotionTitle`,
`InfoverProduct_InfoverPromotion`.`Image` AS `PromotionImage`,
`InfoverProduct_InfoverPromotion_View`.`InfoverPromotion` AS `PromotionInfoverPromotion`,
`InfoverProduct_InfoverPromotion_View`.`Type` AS `PromotionInfoverType`,
`InfoverProductShop_View`.`DateModified` AS `InfoverProductShop_DateModified_All`,
`InfoverProduct_InfoverProductBadge`.`Name` AS `InfoverProductBadge_Name`,
`InfoverProduct_InfoverProductBadge`.`Color` AS `InfoverProductBadge_Color`,
`InfoverProduct_CategoryPath`.`CategoryPath`,
`InfoverProductShopDisabled`.`BuyBody` AS `BuyBody`,
`InfoverProductShop`.`PriceBrutto`,
`InfoverProductShopDisabled`.`Disabled` AS `Disabled`,
`InfoverProduct_InfoverProductBadge`.`Priority` AS `InfoverProductBadge_Priority`,
`InfoverProduct_QuantityAll`.`PriceBruttoAvg`,
`InfoverProduct_QuantityAll`.`QuantityAll`,
`InfoverProductShop`.`Quantity` AS `QuantityStock`,
`Order_QuantityLock`.`Quantity` AS `QuantityLock`,
`InfoverProducer`.`Producer` AS `Producer_Producer`,
`InfoverCategory`.`Category` AS `Category_Category`,
`InfoverParameter`.`Name` AS `VariantColor_Name`,
`InfoverParameter_1`.`Name` AS `VariantVolume_Name`,
CONCAT(CONCAT('https://mrowka.com.pl/produkt/',`A`.`RewritePL`),'.html') AS `_ProductUrl`,
CONCAT(CONCAT('https://mrowka.com.pl/produkt/',`A`.`RewritePL`),'.html') AS `_ProductUrlText`,
COALESCE(`InfoverProductShop`.`Quantity`,0)-COALESCE(`Order_QuantityLock`.`Quantity`,0) AS `Quantity`
FROM `main_psb`.`InfoverProduct_Read` AS `A`
LEFT JOIN `main_psb`.`InfoverProduct_CategoryMain_View` ON `InfoverProduct_CategoryMain_View`.`_Rid`=`A`.`_Rid`
LEFT JOIN `main_psb`.`InfoverProduct_InfoverParameterProper_Group` ON `InfoverProduct_InfoverParameterProper_Group`.`_Rid`=`A`.`_Rid`
LEFT JOIN `main_psb`.`InfoverProduct_InfoverPromotion` ON (`InfoverProduct_InfoverPromotion`.`_Rid`=`A`.`_Rid`) AND (`InfoverProduct_InfoverPromotion`.`Type` IN ('Central','CentralCustom'))
LEFT JOIN `main_psb`.`InfoverProduct_InfoverPromotion_View` ON IF((`InfoverProduct_InfoverPromotion_View`.`_Rid`=`A`.`_Rid`),IF(NOT COALESCE(COALESCE((NULL),"")="",FALSE),(`InfoverProduct_InfoverPromotion_View`.`Shop_Rid`=NULL AND `InfoverProduct_InfoverPromotion_View`.`Type`='Partner'),(`InfoverProduct_InfoverPromotion_View`.`Type` IN ('Central','CentralCustom'))),NULL)
LEFT JOIN `main_psb`.`InfoverProductShop_View` ON `InfoverProductShop_View`.`Product`=`A`.`_Rid` AND ISNULL((`InfoverProductShop_View`.`Shop_Rid`))
LEFT JOIN `main_psb`.`InfoverProduct_InfoverProductBadge` ON `InfoverProduct_InfoverProductBadge`.`_Rid`=`A`.`_Rid`
LEFT JOIN `main_psb`.`InfoverProduct_CategoryPath` ON `InfoverProduct_CategoryPath`.`_Rid`=`A`.`_Rid`
LEFT JOIN `main_psb`.`InfoverProductShopDisabled` ON `InfoverProductShopDisabled`.`Product`=`A`.`_Rid` AND NOT COALESCE(COALESCE((NULL),"")="",FALSE) AND `InfoverProductShopDisabled`.`Shop_Rid`=NULL
LEFT JOIN `main_psb`.`InfoverProductShop` ON `InfoverProductShop`.`Product`=`A`.`_Rid` AND NOT COALESCE(COALESCE((NULL),"")="",FALSE) AND `InfoverProductShop`.`Shop_Rid`=NULL
LEFT JOIN `main_psb`.`InfoverProduct_QuantityAll` ON `InfoverProduct_QuantityAll`.`_Rid`=`A`.`_Rid`
LEFT JOIN `main_psb`.`Order_QuantityLock` ON `Order_QuantityLock`.`Product`=`A`.`_Rid` AND NOT COALESCE(COALESCE((NULL),"")="",FALSE) AND `Order_QuantityLock`.`Shop_Rid`=NULL
LEFT JOIN `main_psb`.`InfoverProducer` AS `InfoverProducer` ON (`A`.`Producer`=`InfoverProducer`.`_Rid`)AND((`InfoverProducer`.`Enabled`=1) AND (ISNULL((`InfoverProducer`.`_Deleted`))))
LEFT JOIN `main_psb`.`InfoverCategory` AS `InfoverCategory` ON (`A`.`Category`=`InfoverCategory`.`_Rid`)AND(`InfoverCategory`.`Enabled`=1)
LEFT JOIN `main_psb`.`InfoverParameter` AS `InfoverParameter` ON (`A`.`VariantColor`=`InfoverParameter`.`_Rid`)AND(`InfoverParameter`.`Enabled`=1)
LEFT JOIN `main_psb`.`InfoverParameter` AS `InfoverParameter_1` ON (`A`.`VariantVolume`=`InfoverParameter_1`.`_Rid`)AND(`InfoverParameter_1`.`Enabled`=1)
WHERE ((((`A`.`_Rid`='drzwi-zewnetrzne-diuna-zloty-dab-80p-kpl-pantor-5902115545870') OR (`A`.`RewritePL`='drzwi-zewnetrzne-diuna-zloty-dab-80p-kpl-pantor-5902115545870'))) AND ((POSITION(CONCAT("\n",'Ant',"\n") IN CONCAT("\n",COALESCE(`A`.`Site`,""),"\n")))))
ORDER BY (1000*((IF(NOT COALESCE(ISNULL((`InfoverProduct_InfoverPromotion`.`PriceBrutto`)),FALSE),1,0))))+(950*(IF(NOT COALESCE(ISNULL((`InfoverProductShop`.`Priority`)),FALSE),1,0)))+(900*(IF(NOT COALESCE(ISNULL((`InfoverProduct_QuantityAll`.`PriceBruttoAvg`)),FALSE),1,0))) DESC,`InfoverProduct_QuantityAll`.`QuantityAll` DESC
LIMIT 0,1
) AS `H`
ORDER BY (1000*((IF(NOT COALESCE(ISNULL((`H`.`PromotionPriceBrutto`)),FALSE),1,0))))+(950*(IF(NOT COALESCE(ISNULL((`H`.`InfoverProductBadge_Priority`)),FALSE),1,0)))+(900*(IF(NOT COALESCE(ISNULL((`H`.`PriceBruttoAvg`)),FALSE),1,0))) DESC,`H`.`QuantityAll` DESC
LINE: 2177 of file /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore2.php
GET: http://beta.mrowka.com.pl/sklep-psb-mrowka-produkty/psb-mrowka-czechowice-dziedzice-1/produkt/drzwi-zewnetrzne-diuna-zloty-dab-80p-kpl-pantor-5902115545870.html
HOST: 3.138.134.221
AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
PID: 449966
USER:
SESSION:
REQUEST: etat57t0mfdq44
CALL STACK:
line 4252 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore2.php function RecordFind()
line 405 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore2.php function RecordFind()
line 7858 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore2.php function iRecordFind()
line 7862 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore2.php function RecordLoad()
line 68 in /home/hosting/www/main-psb/www-webant-beta/vendor/psb/webant/modules/PsbWebAntProduct/classes/ProductShow.php function Process()
line 65 in /home/hosting/www/main-psb/www-webant-beta/vendor/psb/webant/modules/PsbWebAntProduct/classes/BoxProductShow.php function Process()
line 1356 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore1.php function Process()
line 1368 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore1.php function boxProcess()
line 226 in /home/hosting/www/main-psb/www-webant-beta/vendor/psb/webant/application/classes/WebAnt.php function boxProcess()
line 1356 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore1.php function Process()
line 3250 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore1.php function boxProcess()
line 3499 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore1.php function ApplicationRequest()
line 571 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/server-build/iCore1.php function ApplicationRun()
line 16 in /home/hosting/www/main-psb/www-webant-beta/vendor/impact/engine/index.php function iApplicationRun()