Screw Eyes & Cup Hooks

Wholesale prices for everyone on brass & silver screw eyes and brass cup hooks! We stock a variety of brass screw eyes, silver screw eye, brass cup hook, silver cup hook, brass screw hook and silver screw hooks. Our zinc plated silver screw eye and brass screw eye are available in numerous sizes. With such a large selection we are sure to have the brass & silver screw eye or brass cup hook for you!

Displaying 1 to 16 (of 16 products)

Result Pages:  1

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, 40' at line 1

select p.products_image, p.products_model, pd.products_description, pd.products_name, pd.products_description, pd.products_description, p.products_quantity, p.products_piece_price, p.products_id, p.manufacturers_id, p.products_price, p.products_master, p.products_master_status, 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 from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c left join categories c on c.categories_id = p2c.categories_id where c.categories_status = '1' and p.products_status = '1' and p.products_listing_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 = '262' and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', c.categories_hide_from_groups) = 0 order by limit 0, 40

[TEP STOP]