pgProduct::get [988985] sql select p.products_price, p.products_price2, if((length(p.Typ_opisu)=0 || p.Typ_opisu is null),'notebook',p.Typ_opisu) typ_opisu, p.shop_id1, p.products_model, p.Kod_kreskowy, p.Kod_dystrybutora, p.products_el1, p.products_el2, p.products_el3, p.products_el4,p.products_el5, p.products_image, p.cena_allegro, p.cena_porownywarki, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_weight, p.products_status, p.products_tax_class_id, p.products_ordered, p.products_discount, p.tech_data_id, p.abc_data_id, p.zakup_netto, p.grupaA, p.grupaB, ifnull(p.unit, 'piece') unit, p.model, p.shop_id2, p.shop_id3, p.shop_id4, p.uwagi, p.products_image2, p.products_bonus, p.products_part_nr, (select count(*) as total from products_attributes patrib left join products_options popt on patrib.options_id = popt.products_options_id where patrib.products_id=p.products_id and popt.language_id = pd.language_id) attributes, ifnull((select f.pochodzenie from flaga_produktow f where f.products_model = p.products_model), 0) origin, if((length(p.products_part_nr) > 0), (select min(prd.products_id) from products prd use index (products_part_nr) where prd.products_part_nr = p.products_part_nr and prd.products_price = (select min(prd1.products_price) from products prd1 use index (products_part_nr) where prd1.products_part_nr = p.products_part_nr) ), p.products_id) cheapest, p.Wycofany, p.shop_id10, p.Dostawa, p.nrrej, p.link_allegro, p.link_ceneo, p.link_skapiec, p.Aktywacja, p.dod_info, p.shop_id12, p.rem_zat, p.pm_wyr, p.wyr_w, p.id_partnera, p.ceneo_10g, p.products_quantity, p.manufacturers_id, (select count(wz.Id) from wz use index (products_id) where wz.orders_id = 0 and (wz.products_id = p.products_id or wz.products_id = p.products_el1)) as wz_quantity ,ifnull((select sum(h.qty) from products_quantity_hurt h where h.products_id = p.products_id or h.products_id = p.products_el1),0) as hurt_quantity, (select m.manufacturers_name from manufacturers m where m.manufacturers_id = p.manufacturers_id) manufacturer, (select t.tax_rate from tax_rates t where t.tax_class_id = p.products_tax_class_id) tax_rate, (select if((cd.categories_description is not null and locate('pis pojawi', cd.categories_description) = 0), cd.categories_description, null) from categories_description cd where cd.categories_id = p2c.categories_id and cd.language_id = pd.language_id) category_description, c.categories_id, (select cd1.categories_name from categories_description cd1 where cd1.language_id = pd.language_id and cd1.categories_id = c.categories_id) category_name, c.categories_image, c.p2image_1, c.p2image_2, c.p2image_3,c.p2image_4, c.p2image_5, c.p2image_6,c.p2image_7, c.p2image_8, c.parent_id, c.categories_bonus, z.image1, z.image2,z.image3,z.image4,z.image5,z.image6,z.image7,z.image8, pd.products_name, if((pd.products_description is not null and locate('pis pojawi', pd.products_description) = 0) ,pd.products_description, null) products_description, (select count(x.products_id) from produkty_xml x where x.products_id = p.products_id) INXML, (if((length(trim(p.products_el1)) > 0), (select count(x.products_id) from produkty_xml x where x.products_id = p.products_el1) ,0)) INXML_PART, ifnull((select count(1) from products_parents pts where pts.parent_id = p.products_id), 0) kits, if((p.products_el1 = 0), 0, ifnull((select pts.parent_id from products_parents pts where pts.kit_id = p.products_id),0)) parent, p.* from products p left join products_description pd on pd.products_id = p.products_id left join products_to_categories p2c on p2c.products_id = p.products_id left join categories c on c.categories_id = p2c.categories_id left join zdjecia_produktu z on z.products_id = p.products_id where pd.language_id = 1 and p.products_status = 1 and p.wycofany = 0 and p.products_id = 988985 pgProduct::get [2705] products_model ----KZZALZ500LX3000[17] id 988985 pgProduct::get [2705] model ----KZZALZ500LX3000[17] id 988985 Zasilacz ZM500-LX3 Decamax 500W
kuplaptopa.pl Dell-PartnerDirect
0

Zalman KZZALZ500LX3000

Zalman Zasilacz ZM500-LX3 Decamax 500W
  • Zalman
  • ZM500-LX3
  • 8809213764066
  • szczegóły u handlowca
ilość
- +
Dodaj do koszyka
Dostawa w 48h
cena 150, 97 PLN 122,74 PLN netto