Notice: Error: Table 'baltwerkcom.oc_product' doesn't exist
Error No: 1146
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_product_to_complect pptc ON p.product_id = pptc.product_id LEFT JOIN oc_product_product_to_group pptg ON p.product_id = pptg.product_id LEFT JOIN oc_product_group_to_product pgtp ON p.product_id = pgtp.product_id LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (pptc.product_id IS NOT NULL OR pptg.product_id IS NOT NULL OR pgtp.product_id IS NOT NULL) AND p2c.category_id = '457' in /var/www/vhosts/baltwerk.com/httpdocs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/vhosts/baltwerk.com/httpdocs/system/storage/modification/catalog/model/catalog/product.php on line 764Notice: Error: Table 'baltwerkcom.oc_product' doesn't exist
Error No: 1146
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_product_to_complect pptc ON p.product_id = pptc.product_id LEFT JOIN oc_product_product_to_group pptg ON p.product_id = pptg.product_id LEFT JOIN oc_product_group_to_product pgtp ON p.product_id = pgtp.product_id LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (pptc.product_id IS NOT NULL OR pptg.product_id IS NOT NULL OR pgtp.product_id IS NOT NULL) AND cp.path_id = '457' in /var/www/vhosts/baltwerk.com/httpdocs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/vhosts/baltwerk.com/httpdocs/system/storage/modification/catalog/model/catalog/product.php on line 764Notice: Error: Table 'baltwerkcom.oc_product' doesn't exist
Error No: 1146
SELECT p.product_id, pgtp.product_group_id as product_group_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_product_to_complect pptc ON p.product_id = pptc.product_id LEFT JOIN oc_product_product_to_group pptg ON p.product_id = pptg.product_id LEFT JOIN oc_product_group_to_product pgtp ON p.product_id = pgtp.product_id LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (pptc.product_id IS NOT NULL OR pptg.product_id IS NOT NULL OR pgtp.product_id IS NOT NULL) AND cp.path_id = '457' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,24 in /var/www/vhosts/baltwerk.com/httpdocs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/vhosts/baltwerk.com/httpdocs/system/storage/modification/catalog/model/catalog/product.php on line 279Warning: Invalid argument supplied for foreach() in /var/www/vhosts/baltwerk.com/httpdocs/system/storage/modification/catalog/model/catalog/product.php on line 279Notice: Error: Table 'baltwerkcom.oc_product' doesn't exist
Error No: 1146
SELECT `a`.`attribute_id`, REPLACE(REPLACE(TRIM(pa.text), ' ', ''), ' ', '') AS `txt`, `ad`.`name`, `ad`.`mf_tooltip` AS `tooltip`, `agd`.`name` AS `gname`, `agd`.`attribute_group_id` FROM `oc_product` AS `p` INNER JOIN `oc_product_to_store` AS `pts` ON `p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0 INNER JOIN `oc_product_attribute` AS `pa` ON `p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 3 INNER JOIN `oc_attribute` AS `a` ON `a`.`attribute_id` = `pa`.`attribute_id` INNER JOIN `oc_attribute_description` AS `ad` ON `ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 3 INNER JOIN `oc_attribute_group` AS `ag` ON `ag`.`attribute_group_id` = `a`.`attribute_group_id` INNER JOIN `oc_attribute_group_description` AS `agd` ON `agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 3 INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `oc_category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` IN(457) GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != '' ORDER BY `txt` in /var/www/vhosts/baltwerk.com/httpdocs/system/library/db/mysqli.php on line 41Notice: Error: Table 'baltwerkcom.oc_product' doesn't exist
Error No: 1146
SELECT `o`.`option_id`, `ov`.`option_value_id`, `od`.`name` AS `gname`, `od`.`mf_tooltip` AS `tooltip`, `ovd`.`image`, `ovd`.`name` FROM `oc_product` AS `p` INNER JOIN `oc_product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `oc_product_option_value` AS `pov` ON `p`.`product_id` = `pov`.`product_id` INNER JOIN `oc_option_value` AS `ov` ON `ov`.`option_value_id` = `pov`.`option_value_id` INNER JOIN `oc_option_value_description` AS `ovd` ON `ov`.`option_value_id` = `ovd`.`option_value_id` AND `ovd`.`language_id` = 3 INNER JOIN `oc_option` AS `o` ON `o`.`option_id` = `pov`.`option_id` INNER JOIN `oc_option_description` AS `od` ON `od`.`option_id` = `o`.`option_id` AND `od`.`language_id` = 3 INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `oc_category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` IN(457) AND `o`.`type` IN('radio','checkbox','select','image','image_radio') GROUP BY `o`.`option_id`, `ov`.`option_value_id` ORDER BY `ov`.`sort_order`, `ovd`.`name` in /var/www/vhosts/baltwerk.com/httpdocs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/vhosts/baltwerk.com/httpdocs/system/storage/modification/catalog/model/module/mega_filter.php on line 442Warning: Invalid argument supplied for foreach() in /var/www/vhosts/baltwerk.com/httpdocs/system/storage/modification/catalog/model/module/mega_filter.php on line 442Notice: Error: Table 'baltwerkcom.oc_product' doesn't exist
Error No: 1146
SELECT `fgd`.`name` AS `gname`, `fgd`.`mf_tooltip` AS `tooltip`, `f`.`filter_group_id`, `f`.`filter_id`, `fd`.`name` FROM `oc_product` AS `p` INNER JOIN `oc_product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `oc_product_filter` AS `pf` ON `p`.`product_id` = `pf`.`product_id` INNER JOIN `oc_filter` AS `f` ON `pf`.`filter_id` = `f`.`filter_id` INNER JOIN `oc_filter_description` AS `fd` ON `pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 3 INNER JOIN `oc_filter_group_description` AS `fgd` ON `f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 3 INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `oc_category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` IN(457) GROUP BY `f`.`filter_group_id`, `f`.`filter_id` ORDER BY `f`.`sort_order`, `fd`.`name` in /var/www/vhosts/baltwerk.com/httpdocs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/vhosts/baltwerk.com/httpdocs/system/storage/modification/catalog/model/module/mega_filter.php on line 320Warning: Invalid argument supplied for foreach() in /var/www/vhosts/baltwerk.com/httpdocs/system/storage/modification/catalog/model/module/mega_filter.php on line 320Notice: Error: Table 'baltwerkcom.oc_product' doesn't exist
Error No: 1146
SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT ( `price_tmp` * ( 1 + IFNULL(`p_tax`, 0) / 100 ) + IFNULL(`f_tax`, 0) ) AS `price` FROM( SELECT IFNULL( (SELECT `price` FROM `oc_product_special` AS `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1), IFNULL( (SELECT `price` FROM `oc_product_discount` AS `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` = '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1), `p`.`price` ) ) AS `price_tmp` , ( SELECT `tr2`.`rate` FROM `oc_tax_rule` AS `tr1` LEFT JOIN `oc_tax_rate` AS `tr2` ON `tr1`.`tax_rate_id` = `tr2`.`tax_rate_id` INNER JOIN `oc_tax_rate_to_customer_group` AS `tr2cg` ON `tr2`.`tax_rate_id` = `tr2cg`.`tax_rate_id` LEFT JOIN `oc_zone_to_geo_zone` AS `z2gz` ON `tr2`.`geo_zone_id` = `z2gz`.`geo_zone_id` WHERE `tr1`.`tax_class_id` = `p`.`tax_class_id` AND `tr2`.`type` = 'F' AND ( ( `tr1`.`based` = 'store' AND `z2gz`.`country_id` = 117 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '4163' ) ) OR ( `tr1`.`based` = 'payment' AND `z2gz`.`country_id` = 117 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '4163' ) ) OR ( `tr1`.`based` = 'shipping' AND `z2gz`.`country_id` = 117 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '4163' ) ) ) AND `tr2cg`.`customer_group_id` = 1 LIMIT 1 ) AS f_tax , ( SELECT `tr2`.`rate` FROM `oc_tax_rule` AS `tr1` LEFT JOIN `oc_tax_rate` AS `tr2` ON `tr1`.`tax_rate_id` = `tr2`.`tax_rate_id` INNER JOIN `oc_tax_rate_to_customer_group` AS `tr2cg` ON `tr2`.`tax_rate_id` = `tr2cg`.`tax_rate_id` LEFT JOIN `oc_zone_to_geo_zone` AS `z2gz` ON `tr2`.`geo_zone_id` = `z2gz`.`geo_zone_id` WHERE `tr1`.`tax_class_id` = `p`.`tax_class_id` AND `tr2`.`type` = 'P' AND ( ( `tr1`.`based` = 'store' AND `z2gz`.`country_id` = 117 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '4163' ) ) OR ( `tr1`.`based` = 'payment' AND `z2gz`.`country_id` = 117 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '4163' ) ) OR ( `tr1`.`based` = 'shipping' AND `z2gz`.`country_id` = 117 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '4163' ) ) ) AND `tr2cg`.`customer_group_id` = 1 LIMIT 1 ) AS p_tax FROM `oc_product` AS `p` INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 3 INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `oc_category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `cp`.`path_id` IN(457) ) AS `tmp` ) AS `tmp` in /var/www/vhosts/baltwerk.com/httpdocs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/vhosts/baltwerk.com/httpdocs/system/library/mfilter_core.php on line 1355Notice: Error: Table 'baltwerkcom.oc_product' doesn't exist
Error No: 1146
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_product_to_complect pptc ON p.product_id = pptc.product_id LEFT JOIN oc_product_product_to_group pptg ON p.product_id = pptg.product_id LEFT JOIN oc_product_group_to_product pgtp ON p.product_id = pgtp.product_id LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (pptc.product_id IS NOT NULL OR pptg.product_id IS NOT NULL OR pgtp.product_id IS NOT NULL) AND p2c.category_id = '457' in /var/www/vhosts/baltwerk.com/httpdocs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/vhosts/baltwerk.com/httpdocs/system/storage/modification/catalog/model/catalog/product.php on line 764 turētāji

turētāji

turētāji


Šajā preču grupā nav nevienas preces.

Atcelt pasūtījumu

Nosaukums

*

Zvaniet man atpakaļ
Lūdzu, gaidiet
Pieprasījums tika veiksmīgi nosūtīts.