Portokal cauta dupa autori Autori
Portokal cauta dupa edituri Edituri

Portokal

Contact: 0730 650 316

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

comenzi@portokal.ro; online@portokal.ro

Cos de cumparaturi 0 produs(e) 0,00 Lei

Nu aveti produse in cos.

Categorii
Contul meu
Cumpara dupa
Categorie
  1. Carti pentru copii si adolescenti 04
  2. Invatamant & Educatie 244
  3. Memorii & Eseistica 02
  4. Stiinte umaniste 01
Pret
Lei Lei
CAUTA DUPA AUTOR
CAUTA DUPA EDITURA
Limba
  1. Engleza 01
  2. Maghiara 01
  3. Romana 250
Data aparitiei
  1. 1992 01
  2. 1998 01
  3. 2004 07
  4. 2005 07
  5. 2006 01
  6. 2007 06
  7. 2008 04
  8. 2009 04
  9. 2010 03
  10. 2011 04
  11. 2012 01
  12. 2012 03
  13. 2013 10
  14. 2014 20
  15. 2015 18
  16. 2016 40
  17. 2017 33
  18. 2018 24
Sedcom libris
Newsletter

Matematica

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 `discount_percent_value`, `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` 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 = '741' 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, ((at_price.value - final_price) / at_price.value) DESC, `e`.`name` ASC LIMIT 20

Seteaza descrescator
  1. 01
  2. 02
  3. 03
  4. ...
  5. 13
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 `discount_percent_value`, `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` 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 = '741' 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, ((at_price.value - final_price) / at_price.value) DESC, `e`.`name` ASC LIMIT 20

Seteaza descrescator
  1. 01
  2. 02
  3. 03
  4. ...
  5. 13

Despre portokal.ro

Suport

Legal

Contact

Achizitii publice prin SEAP
Eu platesc - plata online
Copyright 2015 - 2018 © PORTOKAL
Incarcare...
Va rugam sa asteptati...
Continua10 Vezi cosul de cumparaturi Mergi la favorite
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:
Cumpara acum