menu::get [2249] sql select t.menu_id, t.parent, t.category_id, t.text, ifnull(t.icon, (select c.icon from categories c where c.categories_id = t.category_id)) icon, ifnull(t.icon_image, (select c.icon_image from categories c where c.categories_id = t.category_id)) icon_image, t.ord, (select c.czy_pokazac from categories c where c.categories_id = t.category_id) view, (select count(1) from categories_to_menu tt where tt.parent = t.menu_id) kids,if( ((select count(1) from categories_to_menu tt where tt.parent = t.menu_id) = 0), (select count(1) from products p inner join products_to_categories pc on pc.products_id = p.products_id where pc.categories_id = t.category_id and p.wycofany = 0 and p.products_status = 1), 0) prods from categories_to_menu t where t.parent = 0 and t.language_id = 1 and t.menu_version = 2 and t.id_partnera = 0 order by t.ord Projektor ZenBeam L2 Portable LED 960L-1080p-400:1-HDMI-USB-C-DP-10Watt speaker-USB-A
kuplaptopa.pl Dell-PartnerDirect

ASUS URASUDHL2000000

ASUS Projektor ZenBeam L2 Portable LED 960L/1080p/400:1/HDMI/USB-C/DP/10Watt speaker/USB-A
  • ASUS
  • 90LJ00I5-B01070
  • 4711081970712
  • szczegóły u handlowca
ilość
- +
Dostawa w 48h
cena 2 989, 03 PLN 2 430,11 PLN netto