DATE: 2026.06.15 01:53:08
ID: raa9-slk0-ntv1-3k
EXCEPTION: SQL error "Unknown column 'Service.ShopStore' in 'WHERE'" in query:
SELECT
H.*,
COALESCE(`H`.`ShopWarehouse_Name`,`H`.`ShopStore_Name`,`H`.`ShopProfi_Name`) AS `Shop_Name`,
COALESCE(`H`.`ShopWarehouse_NameSub2`,`H`.`ShopStore_NameSub2`,`H`.`ShopProfi_NameSub2`) AS `Shop_NameSub2`,
COALESCE(`H`.`ShopWarehouse_AddressCity`,`H`.`ShopStore_AddressCity`,`H`.`ShopProfi_AddressCity`) AS `Shop_AddressCity`,
COALESCE(`H`.`ShopWarehouse_Geo_X`,`H`.`ShopStore_Geo_X`,`H`.`ShopProfi_Geo_X`) AS `Shop_Geo_X`,
COALESCE(`H`.`ShopWarehouse_Geo_Y`,`H`.`ShopStore_Geo_Y`,`H`.`ShopProfi_Geo_Y`) AS `Shop_Geo_Y`,
COALESCE(`H`.`ShopWarehouse_RewritePL`,`H`.`ShopStore_RewritePL`,`H`.`ShopProfi_RewritePL`) AS `Shop_RewritePL`
FROM (
SELECT
`A`.`_Rid`,
`A`.`Enabled`,
`A`.`ShopWarehouse`,
`A`.`ShopStore`,
`A`.`ShopProfi`,
`A`.`ShopInvestor`,
`A`.`Service`,
`A`.`Agreement`,
`A`.`Phone`,
`A`.`Email`,
`A`.`Phone2`,
`A`.`Email2`,
`A`.`Files`,
`Service`.`Flag` AS `Service_Flag`,
`Service`.`Alias` AS `Service_Alias`,
`Service`.`Icon` AS `Service_Icon`,
`Service`.`GoogleMyBusinessType` AS `Service_GoogleMyBusinessType`,
`ShopWarehouse`.`Name` AS `ShopWarehouse_Name`,
`ShopStore`.`Name` AS `ShopStore_Name`,
`ShopProfi`.`Name` AS `ShopProfi_Name`,
`ShopWarehouse`.`NameSub2` AS `ShopWarehouse_NameSub2`,
`ShopStore`.`NameSub2` AS `ShopStore_NameSub2`,
`ShopProfi`.`NameSub2` AS `ShopProfi_NameSub2`,
`ShopWarehouse`.`AddressCity` AS `ShopWarehouse_AddressCity`,
`ShopStore`.`AddressCity` AS `ShopStore_AddressCity`,
`ShopProfi`.`AddressCity` AS `ShopProfi_AddressCity`,
`ShopWarehouse`.`Geo_X` AS `ShopWarehouse_Geo_X`,
`ShopStore`.`Geo_X` AS `ShopStore_Geo_X`,
`ShopProfi`.`Geo_X` AS `ShopProfi_Geo_X`,
`ShopWarehouse`.`Geo_Y` AS `ShopWarehouse_Geo_Y`,
`ShopStore`.`Geo_Y` AS `ShopStore_Geo_Y`,
`ShopProfi`.`Geo_Y` AS `ShopProfi_Geo_Y`,
`ShopWarehouse`.`RewritePL` AS `ShopWarehouse_RewritePL`,
`ShopStore`.`RewritePL` AS `ShopStore_RewritePL`,
`ShopProfi`.`RewritePL` AS `ShopProfi_RewritePL`
FROM `psb_common_shop`.`ShopService` AS `A`
LEFT JOIN `psb_common_shop`.`Service` AS `Service` ON (`A`.`Service`=`Service`.`_Rid`)AND(`Service`.`Enabled`=1)
LEFT JOIN `psb_common_shop`.`ShopWarehouse` AS `ShopWarehouse` ON (`A`.`ShopWarehouse`=`ShopWarehouse`.`_Rid`)AND(ISNULL((`ShopWarehouse`.`_Deleted`)))
LEFT JOIN `psb_common_shop`.`ShopStore` AS `ShopStore` ON (`A`.`ShopStore`=`ShopStore`.`_Rid`)AND(ISNULL((`ShopStore`.`_Deleted`)))
LEFT JOIN `psb_common_shop`.`ShopProfi` AS `ShopProfi` ON (`A`.`ShopProfi`=`ShopProfi`.`_Rid`)AND(ISNULL((`ShopProfi`.`_Deleted`)))
WHERE ((((`Service`.`ShopStore` IN ('shhcf8h0fu2s7d')))) AND ((`Service`.`Enabled`=1)))
) AS `H`
LINE: 8159 of file /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php
GET: http://www.grupapsb.com.pl/sklep-psb-produkty/psb-mrowka-andrychow/produkt/pompa-zanurzeniowa-do-nieczystosci-extrema-300-10-ix-t-i-p-4011458300723.html
HOST: 216.73.216.41
AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
PID: 961885
USER:
SESSION: gu3y6Ir8v1TOE7FMQMGtyqnkSHEujRs6
REQUEST: 4kn4hia0ntv13k
CALL STACK:
line 5387 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function CollectionLoad()
line 449 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function CollectionLoad()
line 5589 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function iCollectionLoad()
line 5548 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function ElementsLoadByLinkRecords()
line 5166 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function ElementsLoad()
line 157 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore2.php function RecordFind()
line 120 in /home/hosting/www/psb_web/www/vendor/psb/web/application/classes/ProductShow.php function iRecordFind()
line 1498 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore1.php function Process()
line 1510 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore1.php function boxProcess()
line 2973 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore1.php function boxProcess()
line 2651 in /home/hosting/www/psb_web/www/vendor/impact/engine/server-build/iCore1.php function ApplicationRequest()
line 668 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()