Ziga Zaga® Collection

EXPRESS YOUR PERSONALITY.
IN ONE CONCISE, DECLARATIVE SENTENCE.

Design is like language. You can use it to communicate so much about yourself. So why settle for décor that mumbles when you can share your take on the world in crisp, decisive prose? That’s precisely why Danze created the new Ziga Zaga® Collection. The clean lines and boldly assertive geometric shapes speak with a refined sense of style and sophistication. Each element punctuates the look while working seamlessly together to create a bathroom environment where everything is as it should be. Exactly.

ONE FLUSH PERFORMANCE.
Find out how many golf balls (and other foreign objects) a Danze toilet can flush with this cool interactive feature. Don't try this at home.
Click to flush away

SELECT prod.name as prodname, col.html_code as trade,col.name as ColName, subcol.name as SubColName,subcol.html_code as strade,col.description, tblcollection.tagname as coltag, pd.base_sku,colgroup.name as colgroupname ,tblgroup.tagname as grouptag,pd.sku , pd.listprice , pd.seq_order,

tblmidgroup.tagname as midgrouptag,colmid.name as midgroupname,tblmidgroup.midgroupID  from tblproduct pd  INNER JOIN tblproduct_midgroup ON  pd.productID = tblproduct_midgroup.productID

INNER JOIN tblmidgroup   ON tblmidgroup.midgroupID = tblproduct_midgroup.midgroupID

INNER JOIN tblgroup   ON  tblgroup.groupID = tblmidgroup.groupID

INNER JOIN tblcaption colmid ON colmid.captionID = tblmidgroup.midgroupID and colmid.type = 11 and colmid.groupID = 3

INNER JOIN tblcollection ON pd.collectionID = tblcollection.collectionID

LEFT JOIN tblcaption subcol ON pd.subcollectionID = subcol.captionID and subcol.type = 17 and subcol.languageID= 1

INNER JOIN tblcaption prod ON prod.captionID = pd.productID  AND prod.type=7 and prod.languageID= 1

INNER JOIN tblcaption col ON col.captionID = tblcollection.collectionID AND col.groupID = 3 AND col.type=2  and col.languageID=1

INNER JOIN tblcaption colgroup ON colgroup.captionID = tblgroup.groupID  AND colgroup.type=10  and colgroup.languageID= 1

WHERE pd.collectionID= 34 and pd.active=1 and pd.discontinued=0 and tblcollection.active=1 AND tblmidgroup.groupID= 3

group by base_sku    order by pd.seq_order

Product Search

Register/Login

Search Room Solutions

Ziga Zaga® Collection

EXPRESS YOUR PERSONALITY.
IN ONE CONCISE, DECLARATIVE SENTENCE.

Product Search

Register/Login

Search Room Solutions

Ziga Zaga® Collection

EXPRESS YOUR PERSONALITY.IN ONE CONCISE, DECLARATIVE SENTENCE.

EXPRESS YOUR PERSONALITY.
IN ONE CONCISE, DECLARATIVE SENTENCE.