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 '%"767"%' OR category LIKE '%"775"%') AND (param = 1) ORDER BY quantity DESC LIMIT 15, 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 '%"767"%' OR category LIKE '%"775"%') AND (param = 1) ORDER BY quantity DESC LIMIT 15, 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 '%"767"%' OR category LIKE '%"775"%') AND (param = 1) ORDER BY price DESC LIMIT 0,1 Luxusný drevený nábytok. Spálňa z masívu Bratislava. Masívny nábytok. Nábytok z masívu | Furniture-nabytok.sk
info@furniture-nabytok.sk
+420 601 372 249
Košík
Je prázdny
Filtrácia

Kavárny a restaurace

Filtrácia

Odtiene skladom

Šírka

60
240

Hĺbka

56
105

Výška

56
113

Cenové rozpätie

0 €
€

Doba dodania

Luxusný drevený nábytok. Nábytok z masívu Bratislava. Masívny nábytok. Nábytok z masívu. Masívny nábytok Bratislava.

Zobrazit popis
Názov
Cena
Najhľadanejšie
Najpredávanejšie

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

Kategorie neobsahuje žádné produkty