Sales & Promotions
Swarovski
Gold Chains
TIERRACAST
Alphabet Beads
Boho, Tribal, Tibetan, Nepalese Jewelry Supplies
Beads
Charms & Pendants
Chain By Foot (Bulk)
Chains (Finished), Bracelets, Rings
European Style Beads & Bracelets
Findings (Jewelry)
Gemstones & Pearls
Gold, Gold-Filled & Vermeil
Rose Gold
Football Beads & Charms Wholesale
Pewter Beads & Components
Micro Pave & Rhinestone Components
Sterling Silver, Silver Filled
Stringing Supplies & Wire
Tools & Supplies
Theme - Birthstones
Theme - Sports
Theme - Wedding
Theme - Yoga, Buddhist, Zen
Miscellaneous
GIFT CERTIFICATES
New Products
free online videos
video

phone(407) 370-2929

18 Amethyst AB 2X - 8mm Swarovski Faceted Bicone Beads

Height Spacing Images
Product code:
Product code: 5301-8AMETab2X
Height Spacing Images
8x8mm, Hole Size 1.02mm 18 gauge
Height Spacing Images
Made in: Austria
Height Spacing Images
Top Background Border Image
Bottom Background Border Image
Facebook Icon Twitter Icon Email Icon Pinterest Icon
Reviews Question
 
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'beadwhol_bwoscnew.xp.sort_order' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_mediumimage from products_xsell xp, products p, products_description pd where xp.products_id = '34196' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' and xp.xsell_type='p' order by sort_order asc limit 4

[TEP STOP]