Maxlife kids digital camera MXKC-100 blue

33,33 €

  • Blagovna znamka:
    MAXLIFE
  • Koda:
    OEM0200442
  • Zaloga:
    Na zalogi
Dodaj v košarico

Specifikacija
Barva gold
Garancija 24,00

Sorodni izdelki

Kategorije

Naj izdelki

0.001 select distinct c.id from Category c, Product p where (p.categoryId=c.id OR p.category2Id=c.id OR p.category3Id=c.id) AND p.active='yes'
0.001 SELECT Product.*, t.name AS tm_name, t.homepage AS tm_homepage, t.garancijskaDoba as tm_garancija, Product.preorder, count(productdiscount.productId)>0 AS hasqdisc FROM Product LEFT JOIN trademark AS t ON t.id=Product.trademarkId LEFT JOIN productdiscount ON Product.id=productdiscount.productId WHERE Product.id=90 GROUP BY Product.id