Transitional Style

FOR THOSE WITH AN OPEN MIND.

The beauty of Danze transitional styles is they can work in almost with almost any decorating scheme. So they give you the freedom to create virtually any environment you can dream up. Especially once you see all the differ-ent looks and finishes we have to offer.

select pd.base_sku,  pd.sku,pd.collectionID as collectionID , style.tagname as styletagname , midgroup.tagname as midgrouptagname ,  grp.tagname as grouptagname , grp.groupID , collect.tagname as collectiontagname , (select name 		from tblcaption where type=7  and languageId = 1  and captionID = pd.productID) as capproduct , (select name 		from tblcaption where type=8  and languageId = 1  and groupid= 2 and captionID = style.styleID) as capstylename, (select description  from tblcaption where type=8  and languageId = 1  and groupid= 2 and captionID = style.styleID) as capstyledesc, (select concat(name,html_code) from tblcaption where type=2 and languageId = 1 and groupid= 2 and captionID = pd.collectionID) as capcollection, (select name 		from tblcaption where type=4  and languageId = 1  and captionID = pd.fitId) as capfit , (select name 		from tblcaption where type=3  and languageId = 1  and captionID = pd.finishId) as capfinish ,  (select name 		from tblcaption where type=17 and languageId = 1  and captionID = pd.subcollectionID) as capSubcollection, (select name 		from tblcaption where type=1  and languageId = 1  and captionID = pd.categoryID ) as capcategory, (select name 		from tblcaption where type=11 and languageId = 1  and groupid= 2 and captionID = midgroup.midgroupID ) as capmidgroup from tblproduct pd    Left  join  tblproduct_style pdstyle  ON pd.productID = pdstyle.productID  	   Left  join  tblstyle style            ON style.styleId = pdstyle.styleID  				   Inner join  tblproduct_midgroup pdmid ON pd.productID = pdmid.productID  	   Inner join  tblmidgroup midgroup      ON pdmid.midgroupID = midgroup.midgroupID    Inner join  tblgroup grp  			  ON grp.groupID  = midgroup.groupID   Inner join  tblcollection collect     ON pd.collectionID = collect.collectionID  where   style.styleID= 1 and grp.groupID= 2 and collect.active = 1 and pd.active = 1 and pd.discontinued = 0  GROUP By pd.collectionID order by capcollection

Product Search

Register/Login

Search Bathroom

Transitional Style

FOR THOSE WITH AN OPEN MIND.