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')
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=739
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: 68,4L - 450x430mm
Made in the CZECH REPUBLIC. Local product.
Designes supplement container in a flowerpot with printing. Mix bright colors and prints with an optimistic view of the world. Flowerpot is made of Kortexin (100% polyester fabric (PES) from the reverse side, coated with water-repellent PVC) is water washable. Cover the flowerpot can be used directly as a planter when you need to insert soil in a waterproof bag that will protect against protečením water between the seams.
UAX s.r.o.
Bernartice nad Odrou 131
741 01 Czech republic
ID: 25874977
TAX ID: CZ25874977