SELECT * FROM `Cart_products` INNER JOIN (SELECT product_ID, store as paramStore, attr_ID as param FROM Cart_products_attributes WHERE variant_ID = ) param ON param.product_ID = `Cart_products`.ID WHERE disabled = 0 AND (category LIKE '%"822"%') AND (param = 1) ORDER BY quantity DESC LIMIT 0, 15SELECT GROUP_CONCAT(DISTINCT catalog SEPARATOR ',') as IDs FROM `Cart_products` INNER JOIN (SELECT product_ID, store as paramStore, attr_ID as param FROM Cart_products_attributes WHERE variant_ID = ) param ON param.product_ID = `Cart_products`.ID WHERE disabled = 0 AND (category LIKE '%"822"%') AND (param = 1) ORDER BY quantity DESC LIMIT 0, 15SELECT (price*28) as price FROM Cart_products INNER JOIN (SELECT product_ID, store as paramStore, attr_ID as param FROM Cart_products_attributes WHERE variant_ID = ) param ON param.product_ID = `Cart_products`.ID WHERE disabled = 0 AND (category LIKE '%"822"%') AND (param = 1) ORDER BY price DESC LIMIT 0,1 Indický Masivní Nábytek Chesterfield: Kvalita a Elegance pro Vaši Domácnost | Furniture-nabytek.cz
info@furniture-nabytek.cz
+420 601 372 249
Košík
Je prázdný
Filtrace

Kolekce

Filtrace

Odstíny skladem

Šířka

70
240

Hloubka

56
105

Výška

56
113

Cenové rozpětí

0 Kč
Kč

Doba dodání

Chesterfield: Kombinace Luxusu a Kvality v Indickém Masivním Nábytku

Zobrazit popis
Název
Cena
Nejhledanější
Nejprodávanější

Warning: mysqli_fetch_object() expects parameter 1 to be mysqli_result, null given in /var/www/clients/client1/web101/web/templates_c/69232c25cbbfde285069f1990ec70683379242ce_0.file.products_all_item.tpl.php on line 43

Kategorie neobsahuje žádné produkty