Portokal

Contact: 0730 650 316

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

comenzi@portokal.ro; online@portokal.ro

Informatica

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`.`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`.`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 = '738' 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
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`.`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`.`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 = '738' 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
INFORMARE IMPORTANTĂ: În perioada sărbătorilor de iarnă livrarea comenzilor poate dura mai mult. Aceste întârzieri apar datorită numărului foarte mare de comenzi procesate de curieri. Vă mulțumim de înțelegere!
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: