facebook mattca
Cautare avansata

Nu ai niciun produs in cos

  1. Pagina principala
  2. Mame, bebe si copii
  3. Jucarii
  4. Saltele si centre de activitati

Saltele si centre de activitati

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `at_price`.`value` AS `price`, ((at_price.value - final_price) / at_price.value) AS `discount_percent_value`, `e`.`strict_out_of_stock`, `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`.`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`.`simptome`, `e`.`afectiune`, `e`.`celmaimicpret`, `e`.`tip_rama`, `e`.`material_rama`, `e`.`culoare_lentila`, `e`.`in_stoc_furnizor`, `e`.`stil_ochelari`, `e`.`tip_lentila`, `e`.`dimensiune`, `e`.`filtru_uv`, `e`.`culoare_rama`, `e`.`culoare_rama_value`, `e`.`promo_icon`, `e`.`promo_categorie`, `e`.`strict_out_of_stock`, `e`.`culori_disponibile`, `e`.`afectiune_populara`, `e`.`afectiune_populara_value`, `e`.`sex`, `e`.`sex_value`, `e`.`stil_de_viata`, `e`.`stil_de_viata_value`, `e`.`adaos_pret_achizitie`, `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`, `e`.`strict_out_of_stock`, IF(`price_index`.price, ((`price_index`.price - IF(`price_index`.tier_price IS NOT NULL, LEAST(`price_index`.min_price, `price_index`.tier_price), `price_index`.min_price)) * 100 / `price_index`.price), 0) AS `saving` 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 = '2528' 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) AND (e.strict_out_of_stock = '0') ORDER BY `e`.`name` ASC, `e`.`strict_out_of_stock` ASC, `e`.`product_order_catalog_value` DESC LIMIT 12
Afiseaza filtre

12 din 71 produse

  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `at_price`.`value` AS `price`, ((at_price.value - final_price) / at_price.value) AS `discount_percent_value`, `e`.`strict_out_of_stock`, `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`.`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`.`simptome`, `e`.`afectiune`, `e`.`celmaimicpret`, `e`.`tip_rama`, `e`.`material_rama`, `e`.`culoare_lentila`, `e`.`in_stoc_furnizor`, `e`.`stil_ochelari`, `e`.`tip_lentila`, `e`.`dimensiune`, `e`.`filtru_uv`, `e`.`culoare_rama`, `e`.`culoare_rama_value`, `e`.`promo_icon`, `e`.`promo_categorie`, `e`.`strict_out_of_stock`, `e`.`culori_disponibile`, `e`.`afectiune_populara`, `e`.`afectiune_populara_value`, `e`.`sex`, `e`.`sex_value`, `e`.`stil_de_viata`, `e`.`stil_de_viata_value`, `e`.`adaos_pret_achizitie`, `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`, `e`.`strict_out_of_stock`, IF(`price_index`.price, ((`price_index`.price - IF(`price_index`.tier_price IS NOT NULL, LEAST(`price_index`.min_price, `price_index`.tier_price), `price_index`.min_price)) * 100 / `price_index`.price), 0) AS `saving` 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 = '2528' 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) AND (e.strict_out_of_stock = '0') ORDER BY `e`.`name` ASC, `e`.`strict_out_of_stock` ASC, `e`.`product_order_catalog_value` DESC LIMIT 12

12 din 71 produse

  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
Pentru informaţii detaliate despre celelalte programe cofinanţate de Uniunea Europeană, vă invităm să vizitaţi www.fonduri-ue.ro

fonduri eu