Kategorien

SELECT cat.id, cat.parentid, cat.cat, cat.cat_img, COUNT(1) as total_products_in_category FROM products pk INNER JOIN categories cat ON cat.id = pk.category WHERE cat.parentid = '128701' GROUP by cat.id ORDER BY `cat`.`cat` ASC;SELECT cat.id, cat.parentid, cat.cat, cat.cat_img, COUNT(1) as total_products_in_category FROM products pk INNER JOIN categories cat ON cat.id = pk.category WHERE cat.parentid = '100353523' GROUP by cat.id ORDER BY `cat`.`cat` ASC;SELECT cat.id, cat.parentid, cat.cat, cat.cat_img, COUNT(1) as total_products_in_category FROM products pk INNER JOIN categories cat ON cat.id = pk.category WHERE cat.parentid = '100565313' GROUP by cat.id ORDER BY `cat`.`cat` ASC;

Food & Grocery

Home > Home & Furniture > Home Furniture > Sofas & Armchairs

uno Ecksofa Mikrofaser Isabeli ¦ grau ¦ Maße (cm): B: 299 H: 72 T: 21

1.149,00 EUR

Beschreibung

Unser Produkt uno Ecksofa Mikrofaser Isabeli gibt es in den Farben: grau Der Hersteller uno ist bekannt für die hohe Qualität der verwendeten Materialien. Maße: · Breite: 299 cm · Höhe: 72 cm · Tiefe: 211 cm

Produkte, die Ihnen gefallen könnten.