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.

Welcome to the section of assorted wholesale lot packages, here we bring you wholesale combo packs for all categories of jewelry which includes necklaces, bracelets, pendants, rings & earrings. Quality is the hallmark of our jewelry, we manufacture our jewelry in bulk quantities & look forward for bulk order from wholesalers across the world. We present our customers a unique & trendy range of fashion jewelry at best wholesale prices.
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 40, 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 = '1' order by p.products_visible_sm desc, if(p.products_quantity=0,2,1), limit 40, 20

[TEP STOP]