Comtech Research      Air Purifier Store
    Phone Orders: Toll-Free 1-866-IONIZER (1-866-466-4937)
My Account  Cart Contents  Checkout  
  Information and Help » Catalog » Specials My Account  |  Cart Contents  |  Checkout   
Categories
Room ionizers (5)
Car ionizers (1)
Multi-purpose air purifiers (17)
Central UV-C Systems (19)
Other Fresheners (1)
Ionizer Accessories & Books (5)
Heat Pump Comfort (1)
Information
FAQs & Information
Need help choosing?
Testimonials
Shipping & Returns
Safe Shopping Guarantee
Privacy Notice
Conditions of Use
Warranties
Contact Us
About Us
Site Map
Product Search
 
To search Product Descriptions, click the
Advanced Search
Affiliate Program
Affiliate Information
Affiliate Program FAQ
Affiliate Log In
What's New? more
Dual lamp internal mount E-200 120V
Dual lamp internal mount E-200 120V
$499.00
Get Them While They're Hot! Get Them While They're Hot!
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-9, 9' at line 1

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9

[TEP STOP]