Instrumentele de scris Diplomat sunt fabricate in Germania din 1922. Va prezentam cu mandrie o gama diversificata de instrumente de scris cu un stil unic. Finisajele de inalta calitate, lacuirea in mai multe straturi, carcasele metalice cat si accesoriile placate cu metale pretioase confera acestor instrumente de scris durabilitate, stil si eleganta fiind sunt testate special pentru a asigura un stil elegant, echilibru perfect, finete si confort excelent in scris.
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(relevanta_option_value_t2.value_id IS NULL, relevanta_option_value_t1.value, relevanta_option_value_t2.value) AS `relevanta` FROM `catalog_product_entity` AS `e`
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='234'
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `catalog_product_entity_int` AS `relevanta_t1` ON e.entity_id=relevanta_t1.entity_id AND relevanta_t1.attribute_id='586' AND relevanta_t1.store_id=0
LEFT JOIN `catalog_product_entity_int` AS `relevanta_t2` ON e.entity_id=relevanta_t2.entity_id AND relevanta_t2.attribute_id='586' AND relevanta_t2.store_id='1'
LEFT JOIN `eav_attribute_option_value` AS `relevanta_option_value_t1` ON relevanta_option_value_t1.option_id=IF(relevanta_t2.value_id > 0, relevanta_t2.value, relevanta_t1.value) AND relevanta_option_value_t1.store_id=0
LEFT JOIN `eav_attribute_option_value` AS `relevanta_option_value_t2` ON relevanta_option_value_t2.option_id=IF(relevanta_t2.value_id > 0, relevanta_t2.value, relevanta_t1.value) AND relevanta_option_value_t2.store_id=1 ORDER BY `relevanta` ASC
LIMIT 24
