Silk Scarves

Wholesale silk scarf, Silk made from the larvae cocoons of the mulberry silkworm is a gorgeous, natural protein fiber. After woven together to make a scarf, the result is a gorgeous, shiny, and delicate fabric which will makes you feel like a million bucks. Browse our bevy of silk neck pendant scarves, and shine on, silk scarf beauties! one more ideal selection is go with our pendant accessories which make you look more stylish. So go ahead and take your pick! NY Jewelry Scarf will not let you down!!!
1 Can't create/write to file '/tmp/#sql_5d4_0.MYI' (Errcode: 28)
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id 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 = '13' order by p.products_sort_order, pd.products_name]