-
Welcome, Guest
- ( My Account | View Cart | Login )
Shopping Cart Items: 0
Sub-Total :
US$0.00
|
|
| Our Local Time Is 3:01:41 AM. |
| Call us at 818-786-0600. We are here to help! |
 |
Need a new Laboratory Glassware Washer? We got you covered. |
| Laboratory Water Systems | Laboratory Process Filters | Laboratory Equipment | Water Treatment |
select DISTINCTROW top 10 p.CatalogId,p.ccode from products p, prodcategories cc, categories c where cc.intCatalogId=p.CatalogId and cc.intcategoryid=c.categoryid and cc.intcategoryid = 443 and p.hide = 0 and (p.customermatch is null or p.customermatch = '') and (p.loggedin = false or p.loggedin is null) and (c.customermatch is null or c.customermatch = '') and (c.loggedin = false or c.loggedin is null) AND (higherCatalogId is null) order by p.ccode