Inicio > COMPONENTES Y REPUESTOS > Capacitores
STOCK
ULTIMAS UNIDADES
  Disponible para envio gratis  
$ 6.370
O 6 cuotas de $ 1.062
Precio sin IVA: $ 5.264
$ 5.415 (Transferencia/Depósito)
Max Vta: 100000
DETALLES
MarcaUNIVERSAL
Descripción del producto
23 -

select distinct p.products_image, p.orden, pd.products_name as products_name_catalog, pd.url_amigable as url_amigable, p.products_model as products_code_catalog, p.new_date_from, p.new_date_to, p.show_price_kg, p.products_weight, p.show_other_currency, p.products_price_2, p.products_price_3, p.products_price_4, p.products_price_5, p.products_price_6, p.products_price_7, p.products_price_8, p.products_price_9, p.products_price_10, p.product_grouper_id, p.order_group as order_group, p.order_mobile_group as order_mobile_group, p.products_min_stock_to_sell, p.products_last_modified, p.products_auxiliar_code, p.gtin, p.sku, p.manufacturers_id, p.products_ignore_stock, p.products_min_stock, p.products_tax_class_id, p.products_qty_vta_min, p.products_qty_vta_max, p.products_other_tax_1 as products_other_tax, 0 as package_other_tax, 0 as package_qty_other_tax, p.order_in_grouper, p.products_tag, p.installment_view, p.only_show, p.hide_price, p.show_price_tag, IF(s.status && 0 > 0, 0, NULL) as offer_package, IF(s.status && 0 > 0, 0, NULL) as offer_package_qty, p.products_price as products_price, p.products_other_tax_5 as other_tax_del , If(p.products_unit > 0, p.products_unit, 1) as products_unidad_compra, p.products_unidad_compra as products_unidad_compra_label, p.products_cant_package_discount, p.products_unit, p.products_bulk_type, p.products_purchase_equivalence, p.order_in_configurable, p.free_shipping, p.discount_id, p.custom_id, IF(IF(s.status && s.specials_new_products_price > 0, s.specials_new_products_price, p.products_price) < IF(mcpp.configurable_prices_new_products_price > 0, mcpp.configurable_prices_new_products_price, p.products_price), IF(s.status && s.specials_new_products_price > 0, s.specials_new_products_price, p.products_price) ,IF(mcpp.configurable_prices_new_products_price > 0, mcpp.configurable_prices_new_products_price, p.products_price)) as final_price, IF(s.status && s.specials_new_products_price > 0, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_price as without_discount_price, p.products_id, p.mg_rubro, IF(p.product_grouper_id, CONCAT("g_", p.product_grouper_id), p.products_id) as p_group_id, CAST((p.products_quantity - IF(p.products_min_stock_to_sell IS NULL,0,p.products_min_stock_to_sell)) AS DOUBLE) as products_quantity, p.products_quantity_future, CONCAT (c.categories_id) AS categories_id, (p.product_grouper_id IS NOT NULL) as is_grouped, IF(p.product_grouper_id && mpg.code != "" , mpg.code, p.products_model) as products_model , IF(p.product_grouper_id, mpg.name, pd.products_name) as products_name, p.products_date_added as pdate_added, p.products_image from products p inner join products_description pd on p.products_id = pd.products_id and pd.language_id inner join products_to_categories p2c on p.products_id = p2c.products_id inner join categories c on c.categories_id = p2c.categories_id left join specials s on p.products_id = s.products_id and s.status = 1 and (s.expires_date is null or DATE(s.expires_date) = "0000-00-00" or DATE(CURDATE()) <= DATE(s.expires_date) ) and ( s.start_date is null or DATE(CURDATE()) >= DATE(s.start_date) ) left join mods_configurable_products_prices mcpp on p.products_id = mcpp.products_id left join mods_product_groupers mpg on p.product_grouper_id = mpg.id AND mpg.is_rentable = 0 left join manufacturers m on p.manufacturers_id = m.manufacturers_id inner join products_xsell xsell on xsell.xsell_id = p.products_id where c.categories_id in ( SELECT t1.categories_id FROM products_to_categories pc JOIN categories t1 ON pc.categories_id = t1.categories_id left JOIN categories AS t2 ON t2.categories_id = t1.parent_id left JOIN categories AS t3 ON t3.categories_id = t2.parent_id left JOIN categories AS t4 ON t4.categories_id = t3.parent_id left JOIN categories AS t5 ON t5.categories_id = t4.parent_id WHERE products_id = p.products_id AND t1.categories_status = 1 AND (t2.categories_id IS NULL OR t2.categories_status = 1) AND (t3.categories_id IS NULL OR t3.categories_status = 1) AND (t4.categories_id IS NULL OR t4.categories_status = 1) AND (t4.categories_id IS NULL OR t4.categories_status = 1) GROUP BY t1.categories_id ) and c.categories_status = 1 and p.products_status = 1 and p.is_rentable = 0 and (p.products_price > 0 or p.show_priceless = 1) and ((p.products_quantity - IF(p.products_min_stock_to_sell IS NULL,0,p.products_min_stock_to_sell)) > 0 or p.products_ignore_stock = 1) and p.configurable_products_only = 0 AND (m.manufacturers_id is null OR m.manufacturers_status = 1) and xsell.products_id = 284 group by products_id order by IF((p.products_quantity - IF(p.products_min_stock_to_sell IS NULL,0,p.products_min_stock_to_sell)) > 0, 1, 0) desc, p.order_in_grouper asc, p.products_price asc, CASE WHEN (p.products_quantity - IF(p.products_min_stock_to_sell IS NULL,0,p.products_min_stock_to_sell)) < 1 THEN -1 WHEN (p.products_quantity - IF(p.products_min_stock_to_sell IS NULL,0,p.products_min_stock_to_sell)) >= 0 THEN -2 ELSE 1 END asc

[TEP STOP]