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=94)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: 20468064
Hikvision Switch mode power supply adapter  12 W, DC adapter, 12 V MB1.0/12
5,06 EUR 4.40 EUR
Produkta numurs: 20192267
Kronšteinas kamerai, DS-1280ZJ-DM21, LUBINIS (tinka KRDS1280ZJ-DM21
12,08 EUR 10.50 EUR
Produkta numurs: 20335934
Gembird HD smart WiFi camera 3.6mm/F2.0, H.264, Micro SD, Max.64GB ICAM-WHD-02
27,72 EUR 24.10 EUR
Produkta numurs: 20385373
WRL CAMERA IP HD SMART/ICAM-WHD-02 GEMBIRD ICAM-WHD-02
31,51 EUR 27.40 EUR
Produkta numurs: 20314607
Kamera IP | HD | WiFi | IR | Dzień/noc 50226
33,47 EUR 29.10 EUR
Produkta numurs: 20352407
WRL CAMERA IP HD SMART/ROTATING ICAM-WRHD-01 GEMBIRD ICAM-WRHD-01
37,95 EUR 33.00 EUR
Produkta numurs: 20326044
ZYXEL ZYXEL ALARM BEEPER & POE FOR AURORA CAM
45,31 EUR 39.40 EUR
Produkta numurs: 20410859
KAMERA IP WEWNĘTRZNA CAMSPOT 3.3 BIAŁA OV-CAMSPOT 3.3 WHITE
46,35 EUR 40.30 EUR
Produkta numurs: 20603454
Smart kamera IP Wi-Fi HD 1080p 740245
47,73 EUR 41.50 EUR
Produkta numurs: 20553776
INDOOR SECURECAM HD -  Indoor, rotating IP camera able to record in 720p, WIFI MT4051
48,76 EUR 42.40 EUR
Produkta numurs: 20325124
CLOUD SECURECAM OBROTOWA KAMERA SIECIOWA WIFI IP MT4097
49,57 EUR 43.10 EUR
Produkta numurs: 20510422
Outdoor Securecam HD Kamera sieciowa WiFi IP do monitorinu wideo (na zewnatrz) MT4052 MT4052
50,03 EUR 43.50 EUR