Perforator de arhiva - diverse modele si culori || RIK.ro

SELECT DISTINCT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`weight`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`um`, `e`.`um_value`, `e`.`cod_furnizor`, `e`.`links_exist`, `e`.`product_video`, `e`.`categorie_discount`, `e`.`categorie_discount_value`, `e`.`culoare`, `e`.`culoare_value`, `e`.`latime_cotor`, `e`.`latime_cotor_value`, `e`.`gramaj`, `e`.`gramaj_value`, `e`.`format`, `e`.`format_value`, `e`.`nr_file`, `e`.`nr_file_value`, `e`.`capacitate_perforare`, `e`.`capacitate_perforare_value`, `e`.`grosime`, `e`.`grosime_value`, `e`.`lungime`, `e`.`lungime_value`, `e`.`latime`, `e`.`latime_value`, `e`.`grupa`, `e`.`grupa_value`, `e`.`tip`, `e`.`tip_value`, `e`.`grosime_varf`, `e`.`grosime_varf_value`, `e`.`material`, `e`.`material_value`, `e`.`capacitate`, `e`.`capacitate_value`, `e`.`inaltime`, `e`.`inaltime_value`, `e`.`diametru`, `e`.`diametru_value`, `e`.`dimensiuni`, `e`.`dimensiuni_value`, `e`.`gama`, `e`.`gama_value`, `e`.`adancime_capsare`, `e`.`adancime_capsare_value`, `e`.`lipire`, `e`.`lipire_value`, `e`.`clapa`, `e`.`clapa_value`, `e`.`rezistenta`, `e`.`rezistenta_value`, `e`.`actionare`, `e`.`actionare_value`, `e`.`presare`, `e`.`presare_value`, `e`.`lungime_taiere`, `e`.`lungime_taiere_value`, `e`.`capacitate_legare`, `e`.`capacitate_legare_value`, `e`.`licenta`, `e`.`licenta_value`, `e`.`categorie_varsta`, `e`.`categorie_varsta_value`, `e`.`pentru`, `e`.`pentru_value`, `e`.`nivel_securitate`, `e`.`nivel_securitate_value`, `e`.`varf`, `e`.`varf_value`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`is_imported`, `e`.`color`, `e`.`color_value`, `e`.`swatch_image`, `e`.`capacitate_indosariere`, `e`.`capacitate_indosariere_value`, `e`.`ambalare`, `e`.`ambalare_value`, `e`.`cod_ean`, `e`.`model_penita`, `e`.`model_penita_value`, `e`.`duritate_mina`, `e`.`duritate_mina_value`, `e`.`idneom`, `e`.`tip_mina`, `e`.`tip_mina_value`, `e`.`model_eticheta`, `e`.`model_eticheta_value`, `e`.`tematica`, `e`.`tematica_value`, `e`.`liniatura`, `e`.`liniatura_value`, `e`.`caracteristici`, `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` FROM `catalog_product_flat_1` 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='199' 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 ORDER BY `e`.`relevanta_value` ASC LIMIT 24

Cod: 6249 UM: Buc
Perforator Leitz 5182 de mare capacitate, 250 coli

Pret: 1.735,29 Lei 2.065,00 Lei Incepand de la 1.388,23 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 1.561,76 Lei
- 3 20% 1.388,23 Lei

Cod: 1563 UM: Set
Burghiu de rezerva Leitz, pentru perforatorul 5182

Pret: 583,99 Lei 694,95 Lei Incepand de la 467,19 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 525,59 Lei
- 3 20% 467,19 Lei

Cod: 5995 UM: Buc
Perforat Leitz 5022, pentru 4 perforatii, 16 coli

Pret: 226,01 Lei 268,95 Lei Incepand de la 180,81 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 203,41 Lei
- 3 20% 180,81 Lei

Cod: 5084 UM: Buc
Perforator Leitz 5132, pentru 4 perforatii, 40 coli

Pret: 428,53 Lei 509,95 Lei Incepand de la 342,82 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 385,68 Lei
- 3 20% 342,82 Lei

Cod: 1801 UM: Buc
Perforator Leitz 5114, 4 perforatii, distante reglabile, 30 coli

Pret: 785,71 Lei 934,99 Lei Incepand de la 628,57 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 707,14 Lei
- 3 20% 628,57 Lei

Cod: 0200 UM: Buc
Element de perforare pentru Leitz 5114, 6 mm

Pret: 70,55 Lei 83,95 Lei Incepand de la 56,44 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 63,50 Lei
- 3 20% 56,44 Lei

Cod: 7494 UM: Buc
Element de perforare pentru Leitz 5114, 8 mm

Pret: 83,15 Lei 98,95 Lei Incepand de la 66,52 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 74,84 Lei
- 3 20% 66,52 Lei

Cod: 0665 UM: Buc
Perforator 290 coli, HDP-2320, Kangaro

Pret: 468,74 Lei 557,80 Lei

Cod: 5077 UM: Buc
Perforator 150 coli, Fashion HDC150 , Rapid

Pret: 724,33 Lei 861,95 Lei Incepand de la 579,46 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 651,90 Lei
- 3 20% 579,46 Lei

Cod: 4111 UM: Buc
Perforator 150 coli, Fashion HDC150/4, Rapid

Pret: 1.398,28 Lei 1.663,95 Lei Incepand de la 1.118,62 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 1.258,45 Lei
- 3 20% 1.118,62 Lei

Cod: 1893 UM: Set
Platane plastic pt perforator HDC 150 si 150/4, Rapid

Pret: 46,18 Lei 54,95 Lei Incepand de la 36,94 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 41,56 Lei
- 3 20% 36,94 Lei

Cod: 3715 UM: Set
Burghie pt perforatorul HDC 150 si 150/4, Rapid

Pret: 220,97 Lei 262,95 Lei Incepand de la 176,78 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 198,87 Lei
- 3 20% 176,78 Lei

Cod: 6881 UM: Set
Platane plastic pt perforator HDC 300, Rapid

Pret: 48,70 Lei 57,95 Lei Incepand de la 38,96 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 43,83 Lei
- 3 20% 38,96 Lei

Cod: 6882 UM: Set
Burghie pt perforatorul HDC 300, Rapid

Pret: 589,87 Lei 701,95 Lei Incepand de la 471,90 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 530,88 Lei
- 3 20% 471,90 Lei

Cod: 5694 UM: Buc
Perforator 30 coli, Supreme SP34, Rapid

Pret: 247,86 Lei 294,95 Lei Incepand de la 198,29 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 223,07 Lei
- 3 20% 198,29 Lei