SELECT
SQL_CALC_FOUND_ROWS p.product_id,
(CASE WHEN p.price_m2>0 THEN p.price_m2 ELSE p.price END) as fprice,
(CASE WHEN psp.price IS NOT NULL THEN psp.price/p.bundle_area ELSE p.price_m2 END) as fprice,
(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,
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 < '2026-03-02 13:26:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2026-03-02 13:26:00')))
LEFT JOIN `oc_product_scheduled_price` `psp` ON (
`p`.`product_id` = `psp`.`product_id` AND
`psp`.`customer_group_id` = '1' AND
`psp`.`date_start` < '2026-03-02 13:26:00' AND
`psp`.`date_end` > '2026-03-02 13:26: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 = '73' AND p.manufacturer_id IN ('11','38','44','57','82','81','83','84','85','86','87','88','89') GROUP BY p.product_id ORDER BY available DESC, p.sort_order ASC LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS p.product_id,
(CASE WHEN p.price_m2>0 THEN p.price_m2 ELSE p.price END) as fprice,
(CASE WHEN psp.price IS NOT NULL THEN psp.price/p.bundle_area ELSE p.price_m2 END) as fprice,
(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,
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 < '2026-03-02 13:26:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2026-03-02 13:26:00')))
LEFT JOIN `oc_product_scheduled_price` `psp` ON (
`p`.`product_id` = `psp`.`product_id` AND
`psp`.`customer_group_id` = '1' AND
`psp`.`date_start` < '2026-03-02 13:26:00' AND
`psp`.`date_end` > '2026-03-02 13:26: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 = '73' AND p.manufacturer_id IN ('11','38','44','57','82','81','83','84','85','86','87','88','89') GROUP BY p.product_id ORDER BY available DESC, p.sort_order ASC LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS p.product_id,
(CASE WHEN p.price_m2>0 THEN p.price_m2 ELSE p.price END) as fprice,
(CASE WHEN psp.price IS NOT NULL THEN psp.price/p.bundle_area ELSE p.price_m2 END) as fprice,
(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,
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 < '2026-03-02 13:26:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2026-03-02 13:26:00')))
LEFT JOIN `oc_product_scheduled_price` `psp` ON (
`p`.`product_id` = `psp`.`product_id` AND
`psp`.`customer_group_id` = '1' AND
`psp`.`date_start` < '2026-03-02 13:26:00' AND
`psp`.`date_end` > '2026-03-02 13:26: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 = '73' AND p.manufacturer_id IN ('11','38','44','57','82','81','83','84','85','86','87','88','89') GROUP BY p.product_id ORDER BY available DESC, p.sort_order ASC LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS p.product_id,
(CASE WHEN p.price_m2>0 THEN p.price_m2 ELSE p.price END) as fprice,
(CASE WHEN psp.price IS NOT NULL THEN psp.price/p.bundle_area ELSE p.price_m2 END) as fprice,
(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,
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 < '2026-03-02 13:26:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2026-03-02 13:26:00')))
LEFT JOIN `oc_product_scheduled_price` `psp` ON (
`p`.`product_id` = `psp`.`product_id` AND
`psp`.`customer_group_id` = '1' AND
`psp`.`date_start` < '2026-03-02 13:26:00' AND
`psp`.`date_end` > '2026-03-02 13:26: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 = '73' AND p.manufacturer_id IN ('11','38','44','57','82','81','83','84','85','86','87','88','89') GROUP BY p.product_id ORDER BY available DESC, p.sort_order ASC LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS p.product_id,
(CASE WHEN p.price_m2>0 THEN p.price_m2 ELSE p.price END) as fprice,
(CASE WHEN psp.price IS NOT NULL THEN psp.price/p.bundle_area ELSE p.price_m2 END) as fprice,
(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,
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 < '2026-03-02 13:26:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2026-03-02 13:26:00')))
LEFT JOIN `oc_product_scheduled_price` `psp` ON (
`p`.`product_id` = `psp`.`product_id` AND
`psp`.`customer_group_id` = '1' AND
`psp`.`date_start` < '2026-03-02 13:26:00' AND
`psp`.`date_end` > '2026-03-02 13:26: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 = '73' AND p.product_id IN (SELECT pa.product_id FROM oc_product_attribute pa WHERE (pa.attribute_id = '57' AND LCASE(pa.`text`) = LCASE('5 мм'))) AND p.manufacturer_id = '57' AND p.manufacturer_id IN ('11','38','44','57','82','81','83','84','85','86','87','88','89') GROUP BY p.product_id ORDER BY available DESC, realprice_m2 ASC, p.product_id LIMIT 32,32
SELECT
SQL_CALC_FOUND_ROWS p.product_id,
(CASE WHEN p.price_m2>0 THEN p.price_m2 ELSE p.price END) as fprice,
(CASE WHEN psp.price IS NOT NULL THEN psp.price/p.bundle_area ELSE p.price_m2 END) as fprice,
(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,
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 < '2026-03-02 13:26:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2026-03-02 13:26:00')))
LEFT JOIN `oc_product_scheduled_price` `psp` ON (
`p`.`product_id` = `psp`.`product_id` AND
`psp`.`customer_group_id` = '1' AND
`psp`.`date_start` < '2026-03-02 13:26:00' AND
`psp`.`date_end` > '2026-03-02 13:26: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 p.manufacturer_id IN ('11','38','44','57','82','81','83','84','85','86','87','88','89') GROUP BY p.product_id ORDER BY `price_m2` ASC LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS p.product_id,
(CASE WHEN p.price_m2>0 THEN p.price_m2 ELSE p.price END) as fprice,
(CASE WHEN psp.price IS NOT NULL THEN psp.price/p.bundle_area ELSE p.price_m2 END) as fprice,
(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,
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 < '2026-03-02 13:26:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2026-03-02 13:26:00')))
LEFT JOIN `oc_product_scheduled_price` `psp` ON (
`p`.`product_id` = `psp`.`product_id` AND
`psp`.`customer_group_id` = '1' AND
`psp`.`date_start` < '2026-03-02 13:26:00' AND
`psp`.`date_end` > '2026-03-02 13:26: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 p.manufacturer_id IN ('11','38','44','57','82','81','83','84','85','86','87','88','89') GROUP BY p.product_id ORDER BY `price_m2` DESC LIMIT 0,1
Купить ПВХ плитку Quick-Step Livyn 5 мм со скидкой по лучшей цене на официальном сайте Квик-Степ в Москве.
от ст. метро пр. Вернадского (выход 6)
2 минуты пешком к проходной в Бизнес центр "Вернадский":
большая квадратная арка с шлагбаумом. Вход во "внутренний" двор за шлагбаум.
Отзывы о магазине
Цены на ламинат прям порадовали, так что здесь я его и купила по итогу. За рамки планируемого бюджета не вышла. Качество ламината отличное, а это самое главное, как я считаю. Вопросов не имею
Хороший выбор ламината, приятные цены, доставка имеется.\nВот основные плюсы этого магазина. Покупала, знаю!
Качество!
Хорошая компания с честными ценами сделали скидку так держать!!!!!!
Купила ламинат в этом магазине и не пожалела! Приятные цены и большой ассортимент. Доставка была оперативной, а работники вежливы и отзывчивы. Теперь рекомендую всем своим знакомым!