Accuity Online My Account  Cart Contents  Checkout  
  Home » Specials Register  |  Log In  |  Cart Contents  |  Checkout   
Products
 ACUVUE Contact Lenses
 AIR OPTIX Contact Lenses
 BIOFINITY Contact Lenses
 BIOMEDICS Contact Lenses
 FOCUS Contact Lenses
 FREQUENCY Contact Lenses
 PROCLEAR Contact Lenses
 PUREVISION Contact Lenses
 SOFLENS Contact Lenses
 DAILY Contact Lenses
 2 WEEKLY Contact Lenses
 MONTHLY Contact Lenses
 TORIC Contact Lenses
 EXTENDED WEAR Lenses
 MULTIFOCAL Lenses
 COLOURED Lenses
 CONVENTIONAL (VIAL) Lenses
 SOLUTIONS
 READY READERS
 SPORTS & LEISURE
 NIKE RX Eyewear
 OAKLEY RX Eyewear
 OAKLEY RX Sunglasses
 MAUI JIM Rx Sunglasses
 RAY BAN Rx Sunglasses
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Manufacturers
Advanced Eyecar..
Alcon
AMO
Bausch & Lomb
Ciba Vision
Coopervision
David Thomas
Daysoft
Hydrogel Vision..
Johnson & Johns..
Maui Jim
Nike
Oakley Eyewear
Ray-Ban
Rudy Project
Speedo
Ultravision
Information
Shipping & Returns
Privacy Notice
Conditions of Use
FAQ
Gift Voucher FAQ
Site Map
Contact Us
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]