facebook mattca
Cautare avansata

Nu ai niciun produs in cos

  1. Pagina principala
  2. Mame, bebe si copii
  3. Transport
  4. Scaune auto si accesorii
  5. Alte branduri

Alte branduri

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 = '2629' 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 338 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 = '2629' 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 338 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