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 necklaces
Amber Braceletes (8)
Amber brooches (5)
Amber cuff links (1)
Amber earrings (8)
Amber necklaces (6)
  Silver with amber (4)
  Silver with amber and turquoise (2)
Amber pendants (8)
Amber rings (3)


Pendant P101
Pendant P101
8.28EUR
 
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
New Products For March
Necklace N71T
Necklace N71T
15.76EUR
Buy 1 'Necklace N71T' now
Necklace N91MIX
Necklace N91MIX
40.14EUR
Buy 1 'Necklace N91MIX' now
Necklace N91T
Necklace N91T
40.14EUR
Buy 1 'Necklace N91T' now
Necklace N37MIX
Necklace N37MIX
23.52EUR
Buy 1 'Necklace N37MIX' now
Necklace N71MIX
Necklace N71MIX
15.76EUR
Buy 1 'Necklace N71MIX' now
Necklace N24G
Necklace N24G
16.56EUR
Buy 1 'Necklace N24G' 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 = '27' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 2

[TEP STOP]