WaterFiltersForLess.com  
 Categories
 What's New? more
SWC1350
SWC1350
 $99.15 
 Quick Find more
 

Advanced Search

View All Items
Home Refrigerator Water Filters Home Refrigerator Water FiltersOur refrigerator filters include the industry standard compression brass fittings. They can be easily installed in minutes with either copper or plastic tubing. It's that simple and no expensive filter head to buy. We are so confident that our refrigerator filters are manufactured with the highest quality that we guarantee them for ONE YEAR!
Displaying 1 to 3 (of 3 products)
Results/Page:
View as ListView as List
View as GridView as Grid
Page: 1 
Sort Order:
1030 - Got error 28 from storage engine

select distinct p.products_id, p.products_model, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, p.products_ordered, pd.products_short, p.manufacturers_id, p.products_msrp, p.products_price, p.products_tax_class_id, p.products_featured, p.products_quantity, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c left join categories c using(categories_id) where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '51' and find_in_set('0', p.products_hide_from_groups) = 0 order by pd.products_name limit 0, 20

[TEP STOP]