Toilets

A THRONE WORTHY OF YOUR CASTLE.

Danze toilets are made to the highest standards, both in terms of aesthetics and modern flushing performance. Each is designed to complement the styles of our powder room collections – right down to the toilet tank lever.

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.name as ColName,colmid.description,  subcol.name as SubColName, col.description as coldesciprion,pd.sku,pd.base_sku,   colgroup.name as colgroupname,grp.tagname as grouptag   ,colmid.name as midgroupname,Concat(collectcaption.name,collectcaption.html_code) as collectName,  collectcaption.captionID as collectionID,md.tagname as midgrouptag from tblproduct pd   INNER JOIN tblproduct_midgroup gp ON pd.productID = gp.productID

INNER JOIN tblmidgroup md ON md.midgroupID = gp.midgroupID

INNER JOIN tblcaption collectcaption ON collectcaption.captionID = pd.collectionID AND collectcaption.type=2 and collectcaption.languageID= 1

INNER JOIN tblgroup grp ON  grp.groupID = md.groupID

INNER JOIN tblcaption colmid ON colmid.captionID = md.midgroupID AND colmid.type=11  and colmid.groupID= 3 and colmid.languageID=1

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.groupID = 3 AND col.type=12  and col.languageID=1

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

AND md.groupID= 3

AND gp.midgroupID= 10

GROUP BY base_sku order by pd.sku

Product Search

Register/Login

Search Room Solutions

Toilets

A THRONE WORTHY OF YOUR CASTLE.