SCHÖNER WOHNEN Sale

-65 %
Wandleuchte-1-x-E14-40-Watt-Kia-grau-für-Wohn-und-Esszimmer-830237-1
40 €
14,00 €
14,00 €
40 €
In den Warenkorb
-63 %
-63 %
-64 %
SELECT p.ID as ID FROM products AS p INNER JOIN shop_allocations as sh_al ON sh_al.object_id=p.ID INNER JOIN category_relationships as cr_pc ON cr_pc.object_id=p.ID WHERE p.deleted=0 AND p.is_available=1 AND p.status=0 AND p.image_id!=0 AND sh_al.object_class='Product' AND sh_al.shop_id=5 AND p.product_overview=1 AND cr_pc.category_class='Product_Category' AND cr_pc.category_id=5454 AND cr_pc.object_class='Product' GROUP BY p.ID LIMIT 0, 6