/web/en/cart?backuri=%2Fweb%2Fen%2Fcontents%2Fadvice-tips%2Fuseful-tools
Table 'vagnerpool_micro.sys_1_webproductkatalog_eur' doesn't exist
dotaz: SELECT
vagnerpool_shared.sys_webproduct.*,
vagnerpool_micro.sys_1_webproductseason.*,
vagnerpool_micro.sys_1_cart.count,
vagnerpool_micro.sys_1_cart.cart_id,
vagnerpool_micro.sys_1_webproductkatalog_eur.cena as cena,
vagnerpool_micro.sys_1_webproductkatalog_eur.dph,
vagnerpool_micro.sys_1_webproductkatalog_eur.mena,
vagnerpool_micro.sys_1_webproductkatalog_eur.cena*vagnerpool_micro.sys_1_cart.count as vasecenacelkem,
(vagnerpool_micro.sys_1_webproductkatalog_eur.cena+vagnerpool_micro.sys_1_webproductkatalog_eur.cena*vagnerpool_micro.sys_1_webproductkatalog_eur.dph/100) as vasecenasdph,
vagnerpool_micro.sys_1_webproductkatalog_eur.cena as vasecena
,K.cena as katalog_cena,K.dph as katalog_dph,K.mena as katalog_mena
FROM vagnerpool_micro.sys_1_cart
JOIN vagnerpool_shared.sys_webproduct ON vagnerpool_shared.sys_webproduct.webproduct_id=vagnerpool_micro.sys_1_cart.webproduct_id
JOIN vagnerpool_micro.sys_1_webproductseason ON vagnerpool_micro.sys_1_webproductseason.webproduct_id=vagnerpool_shared.sys_webproduct.webproduct_id
JOIN vagnerpool_micro.sys_1_webproductkatalog_eur ON vagnerpool_micro.sys_1_webproductkatalog_eur.webproduct_id=vagnerpool_shared.sys_webproduct.webproduct_id
LEFT JOIN vagnerpool_micro.sys_1_webproductkatalog_eur K ON K.webproduct_id=vagnerpool_shared.sys_webproduct.webproduct_id
WHERE vagnerpool_micro.sys_1_cart.customer_id="" AND vagnerpool_micro.sys_1_cart.hash="d8e0c8a21e4358c9a70af2861db25ec0"
ORDER BY
vagnerpool_micro.sys_1_cart.cart_id