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 catalog DESCSELECT * 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 catalog DESC LIMIT 0, 15SELECT * 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 catalog 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 '%"767"%' OR category LIKE '%"775"%') AND (param = 1) ORDER BY price DESC LIMIT 0,1SELECT (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 Kaviarne a reštaurácie | Furniture-nabytok.sk
Filtrácia

Kaviarne a reštaurácie

Filtrácia

Šírka

58
240

Hĺbka

59
210

Výška

45
121

Cenové rozpätie

0 €

Doba dodania

Kaviarne a reštaurácie

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/hosting/furniture-nabytok.sk/templates_c/267d16cc846c5b2ff7820215cb67de004cb27b50_0.file.products_all_item.tpl.php on line 42

Kategorie neobsahuje žádné produkty