Specials |  Contact Us  | Create an account  |  Customer Login       HOME NEW PRODUCTS MY ACCOUNT MY ORDER CHECKOUT Product search:   You ordered 0 items  Discount Price Levels Price level 1 $200 - $399 Price level 2 $400 - $799 Price level 3 $800 - $1,999 Price level 4 $2,000 - up For info on price levels and discounts please contact us Minimum order is $200 Email: Password: Forgot password? Not registered?   Necklaces   Rings   Earrings   Bracelets   Pendants   Brooches   Crosses   Beads   Diamond Cuts   Cherry Amber   Designs   Amber Museum            Earrings   Pendants   Necklaces   Rings   Brooches   Bracelets Cognac   Bracelets Multicolor Shipping Policy Return Policy Privacy Policy Contact us Care of amber Test of amber Jewelry Show American Amber Association Diamond Cut Earrings Lot Catalog code: Diamond Cut Earrings Lot Price:  $9.00 per piece  12 pcs in Lot  Total: $108.00 Product description Diamond Cut Earrings Lot made from Baltic amber. Bestsellers 01 - Pendant lot 02 - Multicolor Amber Pendants 03 - Cross Pendant 04 - Diamond Cut Earrings Lot 05 - Heart pendants 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total 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 p.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 = '60order by pd.products_name' [TEP STOP]