Portokal

Contact: 0730 650 316

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

comenzi@portokal.ro; online@portokal.ro

Articole de birou

Articole de birou

Portokal va ofera o gama variata de Articole pentru birou, precum: ace gamalie, agrafe si pioneze, benzi adezive, caiete mecanice, dosare din plastic si carton, capsatoare, capse, decapsatoare si perforatoare, adezivi si lipiciuri, stampile si accesorii, mape din plastic sau carton.
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`, `e`.`name`, `e`.`short_description`, `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`.`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`, `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(price_index.final_price < price_index.price, "0", "1") AS `promos` 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 = '207' 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) 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 `promos` asc, `at_inventory_in_stock`.`is_in_stock` DESC, `e`.`name` ASC LIMIT 20

Seteaza descrescator
  1. 01
  2. 02
  3. 03
  4. ...
  5. 18
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`, `e`.`name`, `e`.`short_description`, `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`.`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`, `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(price_index.final_price < price_index.price, "0", "1") AS `promos` 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 = '207' 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) 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 `promos` asc, `at_inventory_in_stock`.`is_in_stock` DESC, `e`.`name` ASC LIMIT 20

Seteaza descrescator
  1. 01
  2. 02
  3. 03
  4. ...
  5. 18
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: