SELECT p.id, p.name_lat as name, p.present_lat as present, p.price, p.price2, p.on_stock, p.amount_onplace, p.amount_onwarehouse, p.manufacturer_link, p.added_time, GROUP_CONCAT(i.id ORDER BY i.ord ASC) as image_names FROM products p LEFT JOIN categories c ON (p._categ = c.id) LEFT JOIN suppliers as s ON s.id=p.supplier_id LEFT JOIN xmllink_images_2 as i ON i.XML_ID = p.XML_ID WHERE (p._categ=92)AND (((p.amount_onplace>0) OR (p.amount_onwarehouse>0)) AND disable<>1 )AND s.disabled=0 GROUP BY p.id ORDER BY p.price
Produkta numurs: 20486492
ATEN KVM Cable (HD15-SVGA, USB, USB) - 1.2m 2L-5201U
9,32 EUR 8.10 EUR
Produkta numurs: 20399225
Gembird HDMI interface switch, 3 ports DSW-HDMI-34
10,24 EUR 8.90 EUR
Produkta numurs: 20384515
Gembird HDMI interface switch, 3 ports, built-in cable DSW-HDMI-35
10,47 EUR 9.10 EUR
Produkta numurs: 20160216
Gembird HDMI repeater 40M DRP-HDMI-02
10,93 EUR 9.50 EUR
Produkta numurs: 20511898
ATEN KVM Cable (HD15-SVGA, USB, USB) - 2m 2L-5202U
11,39 EUR 9.90 EUR
Produkta numurs: 20540337
ATEN KVM Cable (HD15-SVGA, PS/2, PS/2) - 2m 2L-5202P
13,00 EUR 11.30 EUR
Produkta numurs: 20399285
Gembird HDMI Splitter, 2 PORTS, DSP-2PH4-03 DSP-2PH4-03
14,61 EUR 12.70 EUR
Produkta numurs: 20389408
Gembird HDMI interface switch, 5 ports DSW-HDMI-53
14,95 EUR 13.00 EUR
Produkta numurs: 20544356
ATEN KVM Cable (HD15-SVGA, USB, USB) - 3m 2L-5203U
15,07 EUR 13.10 EUR
Produkta numurs: 20557166
Gembird conwerter HDMI -> VGA + AUDIO 3.5MM JACK DSC-HDMI-VGA-001
15,53 EUR 13.50 EUR
Produkta numurs: 20165823
ATEN KVM PSU EU 230V DC 5V 2.6A 0AD6-1005-26EG
15,64 EUR 13.60 EUR
Produkta numurs: 20542373
ATEN KVM Cable (HD15-SVGA, USB, USB, Audio) - 1.8m 2L-5302U
17,25 EUR 15.00 EUR