Warning Warning: I am able to write to the configuration file: /home/ambercom/public_html/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.
  Catalog » Amber pendants
Amber Braceletes (8)
Amber brooches (5)
Amber cuff links (1)
Amber earrings (8)
Amber necklaces (6)
Amber pendants (8)
  Silver with amber (5)
  Silver with amber and turquoise (3)
  Silver with turquise
Amber rings (3)


Brooch B19G
Brooch B19G
6.90EUR
 
Use keywords to find the product you are looking for.
Advanced Search
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Categories

Silver with amber

Silver with amber and turquoise

Silver with turquise
New Products For March
Pendant P122MIX
Pendant P122MIX
12.16EUR
Buy 1 'Pendant P122MIX' now
Pendant P118
Pendant P118
9.39EUR
Buy 1 'Pendant P118' now
Pendant P118MIX
Pendant P118MIX
9.39EUR
Buy 1 'Pendant P118MIX' now
Pendant P101
Pendant P101
8.28EUR
Buy 1 'Pendant P101' now
Pendant P101T
Pendant P101T
8.28EUR
Buy 1 'Pendant P101T' now
Pendant P81T
Pendant P81T
13.82EUR
Buy 1 'Pendant P81T' now
1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '28' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 2

[TEP STOP]