SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' GROUP BY p.product_id ORDER BY available DESC, p.sort_order ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) AND `p`.`quantity` > 0 GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' GROUP BY p.product_id ORDER BY available DESC, p.sort_order ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) AND `p`.`quantity` > 0 GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) GROUP BY p.product_id ORDER BY available DESC, realprice_m2 ASC ,p.price ASC , p.product_id LIMIT 0,42
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' GROUP BY p.product_id ORDER BY available DESC, p.sort_order ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) AND `p`.`quantity` > 0 GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product p LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product p LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_id ORDER BY `realprice_m2` DESC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' GROUP BY p.product_id ORDER BY available DESC, p.sort_order ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) AND `p`.`quantity` > 0 GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' GROUP BY p.product_id ORDER BY available DESC, p.sort_order ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) AND `p`.`quantity` > 0 GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) GROUP BY p.product_id ORDER BY `realprice_m2` ASC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area AND p.quantity > 0, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value AND p.quantity > 0, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) AND `p`.`quantity` > 0 GROUP BY p.product_id ORDER BY `realprice_m2` DESC LIMIT 0,1
SELECT SQL_CALC_FOUND_ROWS p.product_id, (p.quantity > 0) AS available, p.price_m2, IF ( psp.price IS NOT NULL, psp.price/p.bundle_area, ps.price/p.bundle_area ) AS special_m2, CEILING ( IF ( psp.price IS NOT NULL, IF ( p.price_m2/pcur.value > psp.price/p.bundle_area, IF ( psp.price/p.bundle_area, psp.price/p.bundle_area, p.price_m2/pcur.value ), p.price_m2/pcur.value ), IF ( p.price_m2/pcur.value > ps.price/p.bundle_area/pcur.value, IF ( ps.price/p.bundle_area/pcur.value, ps.price/p.bundle_area/pcur.value, p.price_m2/pcur.value ), p.price_m2/pcur.value ) ) ) AS realprice_m2,count(pr.review_id) as reviewcount, p.bundle_area FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_currency pcur ON (p.currency_id = pcur.currency_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-31 16:08:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-31 16:08:00'))) LEFT JOIN oc_review pr ON (p.product_id = pr.product_id) LEFT JOIN `oc_product_scheduled_price` `psp` ON ( `p`.`product_id` = `psp`.`product_id` AND `psp`.`customer_group_id` = '1' AND `psp`.`date_start` < '2025-07-31 16:08:00' AND `psp`.`date_end` > '2025-07-31 16:08:00' ) 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '20' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '6' AND LCASE(pa.`text`) = LCASE('Германия'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '8' AND LCASE(pa.`text`) = LCASE('орех'))) AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '12' AND LCASE(pa.`text`) = LCASE('33 класс'))) GROUP BY p.product_id ORDER BY `realprice_m2` DESC LIMIT 0,1
Купить ламинат Германия орех 33 класс - недорого в СПб с доставкой

Назад
  • Доставка по России
    Доставка в любой город
  • Наличие на складе
    Официальные поставки и наличие на складе в Спб
  • Образцы в шоу-руме
    Наличие образцов уточняйте пр.2-й Муринский д.34 к.1 и пр.Гагарина 2 к.3

Ламинат Германия орех 33 класс

Сортировка:
На странице:
Выбрано 6 товаров
  • Ламинат Kronotex Super Solid 3070 / 3070 Грецкий орех Тоскана
    Ламинат Kronotex Super Solid 3070 / 3070 Грецкий орех Тоскана
    Цена: 1668руб/м2
    Нет в наличии
    • Страна производства: Германия
    • Порода дерева: орех
    • Класс нагрузки: 33 класс
    • Толщина: 12 мм
    • Наличие фаски: с фаской
    • Размер: 1375х188х12 мм
    Button Cart Img Noactive
  • Ламинат Kronotex Super Solid D 2778 Орех Грецкий
    Ламинат Kronotex Super Solid D 2778 Орех Грецкий
    Цена: 1668руб/м2
    Нет в наличии
    • Страна производства: Германия
    • Порода дерева: орех
    • Класс нагрузки: 33 класс
    • Толщина: 12 мм
    • Наличие фаски: с фаской
    • Размер: 1375 х 188 х 12 мм
    Button Cart Img Noactive
  • Ламинат Kronospan Titan Prestige 5944 Сильвертон Гикори
    Ламинат Kronospan Titan Prestige 5944 Сильвертон Гикори
    Цена: 2300руб/м2
    Нет в наличии
    • Страна производства: Германия
    • Порода дерева: орех
    • Класс нагрузки: 33 класс
    • Толщина: 14 мм
    • Наличие фаски: с фаской
    • Размер: 1285 x 157 x 14 мм
    Button Cart Img Noactive
  •  
     

    Нужна помощь в выборе?

    Наши эксперты на связи и готовы помочь
    +7 (812) 777-12-43
    +7 (911) 914-19-65 WhatsApp, Viber
     
     
  • Ламинат Kronotex Robusto D725 / D 725 Орех
    Ламинат Kronotex Robusto D725 / D 725 Орех
    Цена: 3300руб/м2
    Нет в наличии
    • Страна производства: Германия
    • Порода дерева: орех
    • Класс нагрузки: 33 класс
    • Толщина: 12 мм
    • Размер: 1375х188х12 мм
    • Тип: Ламинат
    Button Cart Img Noactive
  • Ламинат Kronotex Robusto D2778 / D 2778 Орех Грецкий
    Ламинат Kronotex Robusto D2778 / D 2778 Орех Грецкий
    Цена: 3300руб/м2
    Нет в наличии
    • Страна производства: Германия
    • Порода дерева: орех
    • Класс нагрузки: 33 класс
    • Толщина: 12 мм
    • Размер: 1375х188х12 мм
    • Тип: Ламинат
    Button Cart Img Noactive
  • Ламинат Kronotex Aqua Robusto P1212 Хикори Классический
    Ламинат Kronotex Aqua Robusto P1212 Хикори Классический
    Цена: 3600руб/м2
    Нет в наличии
    • Страна производства: Германия
    • Порода дерева: орех
    • Класс нагрузки: 33 класс
    • Толщина: 12 мм
    • Наличие фаски: с фаской
    • Размер: 1380 х 191 х 12 мм
    Button Cart Img Noactive

Контакты

Адрес:
г. Санкт-Петербург, пр.2-й Муринский д.34 к.1, Дом академика Д.С.Лихачёва
Время работы шоу рума:
время работыПн-Пт: 10:00 - 19:00, Сб,Вс: 11:00 - 17:00
Связаться с нами:
Адрес:
г. Санкт-Петербург, пр.Гагарина д.2 к.3, ТЦ &quot;Благодатный&quot;
Время работы шоу рума:
время работыПн-Пт: 10:00 - 19:00, Сб,Вс: 11:00 - 17:00
Связаться с нами:
Адрес:
г. Санкт-Петербург, Железноводская д. 24
Время работы шоу рума:
время работыПн-Пт: 10:00 - 19:00, Сб,Вс: 11:00 - 17:00
Связаться с нами:

Часто задаваемые вопросы и ответы.

Ламинат Kronospan Expert Choice 8575 Дуб Светлый, Ламинат Quick-Step Impressive Ultra IMU1848 дуб Классический натур, Ламинат Kronospan Forte Classic 5552 Дуб Белый масляный, Ламинат Kronospan Forte Classic К001 Дуб Белый Крафт
Цены варьируются от 1668 руб/кв.м до 3600 руб/кв.м
В нашем магазине представлено более 36 проверенных брендов ламината Германия орех 33 класс.
  • ✅ Купить ламинат Германия орех 33 класс по цене от 1668 руб/кв.м
  • ✅ Ламинат Германия орех 33 класс недорого в интернет-магазине
  • ✅ ламинат Германия орех 33 класс купить в Санкт-Петербурге
Parket.Guru