Taikonaut Limited
  Top » Catalog » Advanced Search » Search Results My Account  |  Cart Contents  |  My Wishlist  |  Checkout   
Quick Find
 
Advanced Search



Range price search
Lenses
Style of Frame
Shape of frame
Select Material
For Progressive
Reading Glasses
Designer outlet
Japan Designer
Accessory
Clearance
Brand Name
Promotion
See more...
Advertisment
Come to See...
What's New? more
Defect Sale (DAM0812SB-15XL) Storage Box for 12 Pairs Oversize Sunglasses
Defect Sale (DAM0812SB-15XL) Storage Box for 12 Pairs Oversize Sunglasses
54.99
(US$72.40)

---------
(B101207-04) Belstaff Aviator BV87 Light Weight Designer Eyeglasses Frame
(B101207-04) Belstaff Aviator BV87 Light Weight Designer Eyeglasses Frame
39.99
(US$52.65)

---------
(B101207-03) Belstaff Aviator BV87 Light Weight Designer Eyeglasses Frame
(B101207-03) Belstaff Aviator BV87 Light Weight Designer Eyeglasses Frame
39.99
(US$52.65)

---------
(B110102-12) Evisu for Eyes EVH-8193 Thick Acetate Designer Frame Box Set
(B110102-12) Evisu for Eyes EVH-8193 Thick Acetate Designer Frame Box Set
99.99
(US$131.65)

---------
(B110102-13) Evisu for Eyes EVH-8193 Thick Acetate Designer Frame Box Set
(B110102-13) Evisu for Eyes EVH-8193 Thick Acetate Designer Frame Box Set
99.99
(US$131.65)

---------
(B110303-07) Evisu for Eyes EVH-8005 Japan Designer Frame Box Set
(B110303-07) Evisu for Eyes EVH-8005 Japan Designer Frame Box Set
99.99
(US$131.65)

---------
(B110303-12) Evisu for Eyes EVH-8180 Japan Designer Frame Box Set
(B110303-12) Evisu for Eyes EVH-8180 Japan Designer Frame Box Set
99.99
(US$131.65)

---------
(B101207-13) Unlike Demark M902A Semi-Rimless Progressive Large Frame
(B101207-13) Unlike Demark M902A Semi-Rimless Progressive Large Frame
29.99
(US$39.49)

---------
(B101204-15) NXTFLEX 102862 Extreme Slim light Flim Style Designer Frame
(B101204-15) NXTFLEX 102862 Extreme Slim light Flim Style Designer Frame
49.99
(US$65.82)

---------
(BJ101206-04) MAPLE M106 Handmade Acetate Japan Designer Frame
(BJ101206-04) MAPLE M106 Handmade Acetate Japan Designer Frame
39.99
(US$52.65)

---------
(B101204-08) Retro Eyes by Carlottas Village CV0003 Designer Frame
(B101204-08) Retro Eyes by Carlottas Village CV0003 Designer Frame
49.99
(US$65.82)

---------
(BJ110301-15) MAPLE M104 Piano Black + Pin Designer 6mm Frame
(BJ110301-15) MAPLE M104 Piano Black + Pin Designer 6mm Frame
42.99
(US$56.60)

---------
(BJ110301-13) MAPLE M104 Black+Checker Pattern Designer 6mm Frame
(BJ110301-13) MAPLE M104 Black+Checker Pattern Designer 6mm Frame
42.99
(US$56.60)

---------
(BJ110301-12) MAPLE M101 Piano Black & White Designer 6mm Frame
(BJ110301-12) MAPLE M101 Piano Black & White Designer 6mm Frame
42.99
(US$56.60)

---------
(B110105-03) Thierry Mugler TM99-2001 Wrap Around Rhinestone Designer Frame
(B110105-03) Thierry Mugler TM99-2001 Wrap Around Rhinestone Designer Frame
59.99
(US$78.99)

---------
(B110105-02) Thierry Mugler TM99-2001 Wrap Around Rhinestone Designer Frame
(B110105-02) Thierry Mugler TM99-2001 Wrap Around Rhinestone Designer Frame
59.99
(US$78.99)

---------
(BJ110301-09) Sagawa Fujii 72468 Piano Black Japan Designer Frame
(BJ110301-09) Sagawa Fujii 72468 Piano Black Japan Designer Frame
72.99
(US$96.10)

---------
(BJ110301-07) Sagawa Fujii 7095 Imitated Wood Japan Designer Frame
(BJ110301-07) Sagawa Fujii 7095 Imitated Wood Japan Designer Frame
72.99
(US$96.10)

---------
(BJ110301-06) Sagawa Fujii 71578 Thunder Pin Black Japan Designer 6mm Frame
(BJ110301-06) Sagawa Fujii 71578 Thunder Pin Black Japan Designer 6mm Frame
72.99
(US$96.10)

---------
(BJ110301-05) Sagawa Fujii 71808 Cross Pin Black Japan Designer Frame
(BJ110301-05) Sagawa Fujii 71808 Cross Pin Black Japan Designer Frame
72.99
(US$96.10)

---------
(BJ110301-04) Sagawa Fujii 71718 Cross Pin Black Japan Designer Frame
(BJ110301-04) Sagawa Fujii 71718 Cross Pin Black Japan Designer Frame
72.99
(US$96.10)

---------
(BJ110301-03) Sagawa Fujii 71718 Cross Pin Matte Black Designer Frame
(BJ110301-03) Sagawa Fujii 71718 Cross Pin Matte Black Designer Frame
72.99
(US$96.10)

---------
(BJ110301-02) Sagawa Fujii 71928 Piano Black Japan Designer 6mm Frame
(BJ110301-02) Sagawa Fujii 71928 Piano Black Japan Designer 6mm Frame
72.99
(US$96.10)

---------
(BJ110301-01) Sagawa Fujii 71558 Oversize Aviator Japan Designer Frame
(BJ110301-01) Sagawa Fujii 71558 Oversize Aviator Japan Designer Frame
72.99
(US$96.10)

---------
(B110101-13) Guess GU1501A Business TV Shape Black Acetate Designer Frame
(B110101-13) Guess GU1501A Business TV Shape Black Acetate Designer Frame
42.99
(US$56.60)

---------
Wholesale Partners
Wholesale Inquiries
Information
Shipping & Returns
Privacy Notice
How to Order
Methods of Payment
Contact Us
Site Map
Leave Feedback
Useful Information & Links
Useful Information
Products meeting the search criteria Products meeting the search criteria
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 'limit 0, 20' at line 1

select distinct p.products_image, p.products_model, p.products_quantity, p.products_status, 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 , SUM(tr.tax_rate) as tax_rate from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '96') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '0'), products_description pd, categories c, products_to_categories p2c where 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 ( ( (pd.products_name like '%len%' or p.products_model like '%len%' or m.manufacturers_name like '%len%' or pd.products_description like '%len%') and (pd.products_name like '%height%' or p.products_model like '%height%' or m.manufacturers_name like '%height%' or pd.products_description like '%height%') and (pd.products_name like '%over%' or p.products_model like '%over%' or m.manufacturers_name like '%over%' or pd.products_description like '%over%') and (pd.products_name like '%28mm%' or p.products_model like '%28mm%' or m.manufacturers_name like '%28mm%' or pd.products_description like '%28mm%') and (pd.products_name like '%also%' or p.products_model like '%also%' or m.manufacturers_name like '%also%' or pd.products_description like '%also%') and (pd.products_name like '%suitable%' or p.products_model like '%suitable%' or m.manufacturers_name like '%suitable%' or pd.products_description like '%suitable%') and (pd.products_name like '%for%' or p.products_model like '%for%' or m.manufacturers_name like '%for%' or pd.products_description like '%for%') and (pd.products_name like '%progressive%' or p.products_model like '%progressive%' or m.manufacturers_name like '%progressive%' or pd.products_description like '%progressive%') and (pd.products_name like '%len%' or p.products_model like '%len%' or m.manufacturers_name like '%len%' or pd.products_description like '%len%') ) ) and (IF(s.status, s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) >= 19.99) and (IF(s.status, s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= 99.99) group by p.products_id, tr.tax_priority order by limit 0, 20

[TEP STOP]