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 764turētāji