Minions

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`.`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`.`idneom`, `e`.`tip_mina`, `e`.`tip_mina_value`, `e`.`model_eticheta`, `e`.`model_eticheta_value`, `e`.`tematica`, `e`.`tematica_value`, `e`.`garantie`, `e`.`garantie_value`, `e`.`liniatura`, `e`.`liniatura_value`, `e`.`caracteristici`, `e`.`modul_de_operare`, `e`.`modul_de_operare_value`, `e`.`materiale_distrugere`, `e`.`volum_cosi`, `e`.`volum_cosi_value`, `e`.`embosaj`, `e`.`embosaj_value`, `e`.`model_capsa`, `e`.`model_capsa_value`, `e`.`test`, `e`.`test_value`, `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='1065' INNER 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 WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 24

Cod: MIRS1728-2 UM: Buc
Mini-ghiozdan gradinita, verde, Minions

Pret: 37,13 Lei 44,18 Lei

Cod: MIRS1741-1 UM: Buc
Ghiozdan gradinita, mov, Minions

Pret: 70,95 Lei 84,43 Lei

Cod: MIRS1742-2 UM: Buc
Ghiozdan clasa, verde, Minions

Pret: 89,10 Lei 106,03 Lei

Cod: MIRS1703-T UM: Buc
Ghiozdan troller, clasele 1-4, 3D, Minions

Pret: 161,50 Lei 192,19 Lei Incepand de la 129,20 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 145,35 Lei
- 3 20% 129,20 Lei

Cod: MIRS1724-4 UM: Buc
Ghiozdan, clasele 1-4, Minions

Pret: 102,00 Lei 121,38 Lei Incepand de la 81,60 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 91,80 Lei
- 3 20% 81,60 Lei

Cod: MIRS1708-T UM: Buc
Troller ABS, Minions

Pret: 161,50 Lei 192,19 Lei Incepand de la 129,20 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 145,35 Lei
- 3 20% 129,20 Lei

Cod: MIPE1714-4 UM: Buc
Penar tip etui, triunghiular, Minions

Pret: 18,70 Lei 22,25 Lei Incepand de la 14,96 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 16,83 Lei
- 3 20% 14,96 Lei

Cod: MIPE1701-1 UM: Buc
Penar neechipat, 1 fermoar, Minions

Pret: 30,60 Lei 36,41 Lei Incepand de la 24,48 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 27,54 Lei
- 3 20% 24,48 Lei

Cod: MIPE1701-2 UM: Buc
Penar neechipat, 2 extensii, verde, Minions

Pret: 31,85 Lei 37,90 Lei

Cod: MIPE1703-1 UM: Buc
Penar neechipat, 3 fermoare, mov, Minions

Pret: 42,08 Lei 50,08 Lei

Cod: MIBL21 UM: Set
Set scolar stilou+2 rezerve, Minions

Pret: 11,05 Lei 13,15 Lei Incepand de la 8,84 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 9,95 Lei
- 3 20% 8,84 Lei

Cod: MIPC11 UM: Set
Set scolar pic corector, 3buc/set, Minions

Pret: 6,60 Lei 7,85 Lei

Cod: MICA32 UM: cutie
Carioci 12culori/cutie, Minions

Pret: 13,20 Lei 15,71 Lei

Cod: MIBL22 UM: Set
Set scolar stilou+2rezerve+corector, Minions

Pret: 13,70 Lei 16,30 Lei

Cod: MICC12 UM: cutie
Creioane color, corp personalizat, 12culori/cutie, Minions

Pret: 8,25 Lei 9,82 Lei

Cod: PR-A548DMI UM: Buc
Caiet A5, 48file, dictando, Minions

Pret: 2,59 Lei 3,08 Lei

Cod: PR-A548MMI UM: Buc
Caiet A5, 48file, matematica, Minions

Pret: 2,59 Lei 3,08 Lei

Cod: PR-TP124MI UM: Buc
Caiet A5, tip1, 24file, Minions

Pret: 1,35 Lei 1,61 Lei Incepand de la 0,84 Lei
- Cantitate Discount Pret fara TVA
- 10 34% 0,89 Lei
- 20 38% 0,84 Lei

Cod: PR-TP224MI UM: Buc
Caiet A5, tip2, 24file, Minions

Pret: 1,35 Lei 1,61 Lei

Cod: BD-A4166MI UM: Buc
Bloc de desen A4, 16file, 160g/mp, Minions

Pret: 7,69 Lei 9,15 Lei

Cod: PR-BIO24MI UM: Buc
Caiet pentru biologie, 24file, Minions

Pret: 1,44 Lei 1,71 Lei

Cod: PR-GEO24MI UM: Buc
Caiet pentru geografie, 24file, Minions

Pret: 1,44 Lei 1,71 Lei

Cod: PR-MUZ24MI UM: Buc
Caiet pentru muzica, 24file, Minions

Pret: 1,44 Lei 1,71 Lei

Cod: PR-DES16MI UM: Buc
Caiet pentru desen, 16file, Minions

Pret: 1,26 Lei 1,50 Lei Incepand de la 1,06 Lei
- Cantitate Discount Pret fara TVA
- 10 11% 1,12 Lei
- 20 16% 1,06 Lei