Celiac.com Store     
      
My Account  Newsletters  Shopping Cart  Ready To Checkout  
  Quick Find  
  OR:  Advanced Search  
   » Celiac.com Home » Forum » (Store Home) » Advanced Search » Search Results
Manufacturers
What's New? more
Cereal Killers: Celiac Disease and Gluten-Free A to Z (Paperback)
Cereal Killers: Celiac Disease and Gluten-Free A to Z (Paperback)
$19.95
$11.97
Company Info / Help
Contact Us
About Us
Privacy Notice & Disclaimer
Purchase Policy
Shipping Information
Questions & Answers
Media
Press Releases
Point Program FAQ
Gift Voucher FAQ
Order Tracking
Wholesale & Purchase Orders
Celiac Disease Info
Celiac Information
Celiac Disease Links
Celiac.com Store RSS Feed
Articles
New Articles
All Articles

Affiliate Program
Affiliate Information
Affiliate Program FAQ
Affiliate Log In
Products meeting the search criteria Products meeting the search criteria
Displaying 1 to 17 (of 17 products) Result Pages:  1 
-

select distinct p.cf,p.ef,p.lf,p.sf,p.pf,p.org,p.kos,p.glf,p.frozen,p.sugfr,p.nutfree,p.amounts,p.products_image, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, 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 p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (IF(s.status, s.specials_new_products_price, p.products_price) >= 4) and (IF(s.status, s.specials_new_products_price, p.products_price) <= 5.99) order by limit 0, 20

[TEP STOP]