Como™ Collection

SQUEAKY CLEAN DESIGN.

The best art often uses a variation on a theme. Like Monet’s haystacks or jazz improvisation. The Como collection carries on this tradition, combining the angular look of our Sirius collection with a gracefully round spout. It’s high-end style at a not-so-high-end price.

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 = 1

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 = 1 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= 8 and pd.active=1 and pd.discontinued=0 and tblcollection.active=1 AND tblmidgroup.groupID= 1

group by base_sku

Product Search

Register/Login

Search Kitchen

Como™ Collection

SQUEAKY CLEAN DESIGN.