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

3mm Faceted Round Pyrite Bead Strand

Height Spacing Images
Product code:
Product code: SPYR108
Height Spacing Images
130 Beads approx., 15 inch strand
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 = '47500' 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]