Contact: 0232 217 900

Program L - V: 08:00 - 21:00

comenzi@portokal.ro; online@portokal.ro

CADOU La fiecare carte cumparata primesti un textmarker!

Cresterea copilului

Portokal va ofera o gama variata de carti cu sfaturi utile pentru tot parcursul sarcinii, sanatate si alimentatia copilului, dar si cresterea si educatia copilului.

Seteaza descrescator
  1. 01
  2. 02
  3. 03
  4. ...
  5. 25
SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `at_inventory_in_stock`.`is_in_stock` AS `inventory_in_stock`, `at_price`.`value` AS `price`, ((at_price.value - final_price) / at_price.value) AS `saving`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`open_amount_min`, `e`.`open_amount_max`, `e`.`colectia`, `e`.`autor`, `e`.`data_aparitiei`, `e`.`categorie_filtru`, `e`.`categorie_filtru_value`, `e`.`grupa_de_varsta`, `e`.`grupa_de_varsta_value`, `e`.`tip_ghiozdan`, `e`.`tip_ghiozdan_value`, `e`.`transport_gratuit`, `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 = '270' LEFT JOIN `cataloginventory_stock_item` AS `at_inventory_in_stock` ON (at_inventory_in_stock.`product_id`=e.entity_id) AND (is_in_stock>=0) LEFT JOIN `catalog_product_entity_decimal` AS `at_price` ON (`at_price`.`entity_id` = `e`.`entity_id`) AND (`at_price`.`attribute_id` = '75') AND (`at_price`.`store_id` = 0) 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 (e.status = 1) ORDER BY `at_inventory_in_stock`.`is_in_stock` DESC, `e`.`name` ASC LIMIT 20

Seteaza descrescator
  1. 01
  2. 02
  3. 03
  4. ...
  5. 25
Incarcare...
Va rugam sa asteptati...
Lei
Inscrie-te la newsletter
5% discount pe care il poti folosi la prima comanda de pe site in termen de 5 zile.
Aboneaza-te
Coupon: