SELECT z.barva,z.bratsklad,z.part,bt.nazev,b.typ,b.cb,b.typ_web,b.hex,b.hex,SUM(zs.pocet) spocet FROM zbozi z
JOIN barvy b ON(z.barva=b.typ AND b.typ!='MIX' AND b.typ!='MULTICOLOR')
LEFT JOIN barvy_t bt ON(bt.cis=b.ser AND bt.lang=2) LEFT JOIN zbozi_sklad zs ON(zs.part=z.part)
WHERE z.skupina=647 AND NOT EXISTS(SELECT * FROM potisk_zak_barvy zb WHERE zb.potisk=1224 AND zb.barva=b.ser) AND zs.sklad IN ('SK2')
GROUP BY z.barva ORDER BY b.trid
You can have this product with your own design!
For more information, see the section Custom made UAX!
Material: 100% polyester
Parameters: 340x280x140mm
Made in the CZECH REPUBLIC. Local product.
Size inside pocket: 330x240x40mm
Notebook bag is a combination of original design and the specific cut, offers not only a safe haven for the laptop, but also comfortable to wear. Laptop bag is made of waterproof material and is perfectly kortexin padded way to protect your laptop.
Notebook bag is a combination of original design and the specific cut, offers not only a safe haven for the laptop, but also comfortable to wear. Laptop bag is made of waterproof material and is perfectly kortexin padded way to protect your laptop.UAX s.r.o.
Bernartice nad Odrou 131
741 01 Czech republic
ID: 25874977
TAX ID: CZ25874977