JavaScript seems to be disabled in your browser.

You must have JavaScript enabled in your browser to utilize the functionality of this website. Click here for instructions on enabling javascript in your browser.

With passion for excellence, we have evolved ourselves as a leading Manufacturer and Exporter of a wide range of quality Rings. We assure and promise to provide the best quality at the best wholesale prices. Elaborately crafted and elegantly designed, our rings collection is beautifully handcrafted by our skilled craftsmen. Available in variety of designs and combinations, these rings add a beauty to ones identity.
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 'order by final_price desc, pd.products_name limit 0, 20' at line 1

select pd.products_name, p.products_image, p.products_id, SUBSTRING_INDEX(pd.products_description, ' ', 20) as products_description, p.manufacturers_id, 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, p.products_quantity as in_stock from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c 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 = '6' order by p.products_visible_sm desc, if(p.products_quantity=0,2,1), order by final_price desc, pd.products_name limit 0, 20

[TEP STOP]