My Cart

Cannot get product attribute listSELECT distinct p.FilterLevel1 FROM products p WHERE p.deleted=0 AND p.FilterLevel1<>'' AND ( p.CategoryID1 IN (6,7,14,12,3,9,4,5,11,10,13) OR p.CategoryID2 IN (6,7,14,12,3,9,4,5,11,10,13) ) AND 1 AND p.Visible=1 AND p.ProductVisibleCache=1 AND ( p.CategoryID1 IN (6,7,14,12,3,9,4,5,11,10,13) OR p.CategoryID2 IN (6,7,14,12,3,9,4,5,11,10,13) ) AND (p.CategoryID1 IN (3) OR p.CategoryID2 IN (3)) AND p.Visible=1