Articole scolare cu licenta

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='691' 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

17%

Cod: HKRS1503-5 UM: Buc
Ghiozdan, clasele 1-4, buline, Hello Kitty

Pret: Pret Normal 144,25 Lei 171,66 Lei Pret: Pret Redus 119,99 Lei 142,79 Lei

26%

Cod: HKRS1510-5 UM: Buc
Geanta de umar Hello Kitty

Pret: Pret Normal 81,15 Lei 96,57 Lei Pret: Pret Redus 59,99 Lei 71,39 Lei

26%

Cod: HKRS1424-1 UM: Buc
Geanta de umar black Hello Kitty

Pret: Pret Normal 81,15 Lei 96,57 Lei Pret: Pret Redus 59,99 Lei 71,39 Lei

21%

Cod: HKPE1402-1 UM: Buc
Penar neechipat 2 fermoare Hello Kitty

Pret: Pret Normal 31,57 Lei 37,57 Lei Pret: Pret Redus 24,99 Lei 29,74 Lei

21%

Cod: HKPE1501-2 UM: Buc
Penar neechipat Hello Kitty Music

Pret: Pret Normal 31,57 Lei 37,57 Lei Pret: Pret Redus 24,99 Lei 29,74 Lei

21%

Cod: HKPE1402-2 UM: Buc
Penar neechipat negru Hello Kitty

Pret: Pret Normal 37,88 Lei 45,08 Lei Pret: Pret Redus 29,99 Lei 35,69 Lei

Cod: HKBL99 UM: Set
Set scolar stilou + 2 rezerve Hello Kitty

Pret: 8,50 Lei 10,12 Lei Incepand de la 6,80 Lei
- Cantitate Discount Pret fara TVA
- 2 10% 7,65 Lei
- 3 20% 6,80 Lei

Cod: HKBL22 UM: Set
Set scolar stilou penita + corector Hello Kitty

Pret: 13,89 Lei 16,53 Lei Incepand de la 10,47 Lei
- Cantitate Discount Pret fara TVA
- 2 15% 11,78 Lei
- 3 25% 10,47 Lei

31%

Cod: HKBL18 UM: Set
Blister 4 creioane cu piatra Hello Kitty Pigna

Pret: Pret Normal 5,78 Lei 6,88 Lei Pret: Pret Redus 3,99 Lei 4,75 Lei

Cod: HKET11 UM: Set
Etichete autoadezive scolare Hello Kitty

Pret: 2,83 Lei 3,37 Lei Incepand de la 2,25 Lei
- Cantitate Discount Pret fara TVA
- 2 11% 2,53 Lei
- 3 21% 2,25 Lei

Cod: SMRS1414-1 UM: Buc
Ghiozdan gradinita Spiderman

Pret: 96,73 Lei 115,11 Lei

Cod: SMPE1401-2 UM: Buc
Penar Neechipat 1 fermoar rosu cu albastru Spiderman

Pret: 30,79 Lei 36,64 Lei

Cod: SMRG02 UM: Buc
Rigla 30 cm Spiderman

Pret: 1,64 Lei 1,95 Lei

Cod: 4342 UM: Buc
Geanta de umar, mica, Michael Jackson

Pret: 56,59 Lei 67,34 Lei

Cod: 11438801 UM: Buc
Necessaire Color Splash Lemon Herlitz

Pret: 26,83 Lei 31,93 Lei

Cod: 11438462 UM: Buc
Necessaire rotund baieti mix II, decoruri asortate, Herlitz

Pret: 8,51 Lei 10,13 Lei

Cod: 11412707 UM: Buc
Necessaire rotund, Smiley World Fancy Herlitz

Pret: 20,55 Lei 24,45 Lei

Cod: 11412061 UM: Buc
Penar echipat, 19 piese, EX fete mix II, decoruri asortate, Herlitz

Pret: 23,24 Lei 27,66 Lei

Cod: 11438264 UM: Buc
Penar neechipat, motiv fete mix II, decoruri asortate, Herlitz

Pret: 12,38 Lei 14,73 Lei

23%
Cod: SLCO01 UM: Buc
Coperta A5 Soy Luna

Pret: Pret Normal 1,38 Lei 1,64 Lei Pret: Pret Redus 1,06 Lei 1,26 Lei Incepand de la 0,95 Lei
- Cantitate Discount Pret fara TVA
- 50 6% 1,00 Lei
- 100 10% 0,95 Lei

Cod: PR-TP224SL UM: Buc
Caiet A5, tip 2, 24 file, Soy Luna

Pret: 0,99 Lei 1,18 Lei Incepand de la 0,84 Lei
- Cantitate Discount Pret fara TVA
- 10 10% 0,89 Lei
- 20 15% 0,84 Lei