ESI processing not enabled
ESI processing not enabled ESI processing not enabled
Back to overview

Halskette Pisa

Artikelnummer: 040E3-NE3165-M16
(0)
470,00 €

inkl. Gesetzlicher MwSt

zzgl. Versandkosten: versandkostenfrei

Versand in: 6-7 Werktage

  • Kundenhotline: 0371/ 243 581 32**
  • Geprüfter Online-Shop
  • Viele Zahlarten: PayPal, Sofortüberweisung, Kreditkarte, Vorkasse, Rechnung

Beschreibung

Zart umarmt von der zurückhaltenden Krappenfassung ist dieser 0,50 Karat große Edelstein ein absoluter Schmuckklassiker. Dieser Charme verzaubert schon seit Jahrzehnten reihenweise die Frauen. Genießen Sie diesen wunderschönen Anhänger in unterschiedlichen Karatzahlen und wählen Sie bei 21Diamonds zwischen 0,15, 0,20, 0,25, 0,30, 0,45, 0,50 und 0,60 Karat. * *Die Karatangaben beziehen sich auf Diamanten.

Haupt-Edelstein: blauer Topas

Reinheit: AA

Farbe: Blau

Gesamtkarat: 0,5 ct

Schliff: Brillant

Anzahl Steine: 1

Metall: 585 Rotgold

Gewicht: ~ 0.58g

inkl.luxusetui und Geschenkbox

Kundenbewertungen

Deine Kundenbewertung

SELECT `e`.*, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, `cat_index`.`position` AS `cat_index_position`, `vd`.`vendor_display_market_place` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '89') AND `at_status_default`.`store_id` = 0
 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '89') AND (`at_status`.`store_id` = 1)
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
 INNER JOIN `sm_vendor` AS `vd` ON vd.vendor_id = e.sm_product_vendor_id WHERE (`e`.`entity_id` IN('436228', '436229', '436230', '437785', '437793', '438037', '438041')) AND (`e`.`entity_id` NOT IN('436231')) AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (vendor_display_market_place) LIMIT 28

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.sm_product_vendor_id' in 'on clause'

#0 /home/schmuckladen/jajuma-market/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/schmuckladen/jajuma-market/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/schmuckladen/jajuma-market/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/schmuckladen/jajuma-market/app/code/local/Zend/Db/Adapter/Pdo/Abstract.php(240): Zend_Db_Adapter_Abstract->query('SELECT `e`.*, I...', Array)
#4 /home/schmuckladen/jajuma-market/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.*, I...', Array)
#5 /home/schmuckladen/jajuma-market/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `e`.*, I...', Array)
#6 /home/schmuckladen/jajuma-market/lib/Varien/Data/Collection/Db.php(740): Zend_Db_Adapter_Abstract->fetchAll('SELECT `e`.*, I...', Array)
#7 /home/schmuckladen/jajuma-market/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1047): Varien_Data_Collection_Db->_fetchAll('SELECT `e`.*, I...')
#8 /home/schmuckladen/jajuma-market/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#9 /home/schmuckladen/jajuma-market/app/code/local/Ecommage/Xrecommendation/Block/Catalog/Product/Slider/Related/Product.php(37): Mage_Eav_Model_Entity_Collection_Abstract->load()
#10 /home/schmuckladen/jajuma-market/app/design/frontend/jajuma/schmuckladen/template/recommendation/catalog/product/slider/relatedproduct.phtml(2): Ecommage_Xrecommendation_Block_Catalog_Product_Slider_Related_Product->getProductList()
#11 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Template.php(241): include('/home/schmuckla...')
#12 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/jajuma...')
#13 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#14 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#15 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#16 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('xrecommendation...', true)
#17 /home/schmuckladen/jajuma-market/app/design/frontend/jajuma/schmuckladen/template/catalog/product/view.phtml(757): Mage_Core_Block_Abstract->getChildHtml('xrecommendation...')
#18 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Template.php(241): include('/home/schmuckla...')
#19 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/jajuma...')
#20 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#21 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#22 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#23 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml()
#24 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#25 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#26 /home/schmuckladen/jajuma-market/app/design/frontend/jajuma/schmuckladen/template/page/1column.phtml(91): Mage_Core_Block_Abstract->getChildHtml('content')
#27 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Template.php(241): include('/home/schmuckla...')
#28 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/jajuma...')
#29 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#30 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#31 /home/schmuckladen/jajuma-market/app/code/local/Inchoo/PHP7/Model/Layout.php(15): Mage_Core_Block_Abstract->toHtml()
#32 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Inchoo_PHP7_Model_Layout->getOutput()
#33 /home/schmuckladen/jajuma-market/app/code/core/Mage/Catalog/Helper/Product/View.php(147): Mage_Core_Controller_Varien_Action->renderLayout()
#34 /home/schmuckladen/jajuma-market/app/code/core/Mage/Catalog/controllers/ProductController.php(132): Mage_Catalog_Helper_Product_View->prepareAndRender(436231, Object(Mage_Catalog_ProductController), Object(Varien_Object))
#35 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_ProductController->viewAction()
#36 /home/schmuckladen/jajuma-market/app/code/local/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view')
#37 /home/schmuckladen/jajuma-market/app/code/local/SM/Vendors/Controller/Router/Vendor.php(171): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#38 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Controller/Varien/Front.php(172): SM_Vendors_Controller_Router_Vendor->match(Object(Mage_Core_Controller_Request_Http))
#39 /home/schmuckladen/jajuma-market/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#40 /home/schmuckladen/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#41 /home/schmuckladen/jajuma-market/index.php(89): Mage::run('default', 'store')
#42 {main}