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=1107)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: 20522794
8 Channel  standalone Hybrid
3.04 / mēnesī
84,99 EUR 73.90 EUR
Produkta numurs: 20151093
DVR 4CH HDCVI PENTABRID/XVR4104C-S2 DAHUA DHI-XVR4104C-S2
4.02 / mēnesī
112,47 EUR 97.80 EUR
Produkta numurs: 20343443
DVR 4CH HDCVI PENTABRID/XVR4104HS-S2 DAHUA DHI-XVR4104HS-S2
4.13 / mēnesī
115,46 EUR 100.40 EUR
Produkta numurs: 20351900
DVR 4CH HDCVI PENTABRID/XVR5104HS-S2 DAHUA DHI-XVR5104HS-S2
4.77 / mēnesī
133,52 EUR 116.10 EUR
Produkta numurs: 20490379
DVR 8CH HDCVI PENTABRID/XVR4108C-B DAHUA DHI-XVR4108C-B
4.77 / mēnesī
133,52 EUR 116.10 EUR
Produkta numurs: 20360913
DVR 4CH HDCVI PENTABRID/XVR5104C-S2 DAHUA DHI-XVR5104C-S2
5.23 / mēnesī
146,17 EUR 127.10 EUR
Produkta numurs: 20361062
DVR 4CH HDCVI PENTABRID/XVR5104H-S2 DAHUA DHI-XVR5104H-S2
5.78 / mēnesī
161,69 EUR 140.60 EUR
Produkta numurs: 20522796
8 Channel  standalone DVR 0804HFSE
5.97 / mēnesī
166,98 EUR 145.20 EUR
Produkta numurs: 20371796
DVR 4CH HDCVI PENTABRID/XVR5104C-4M DAHUA XVR5104C-4M
7.34 / mēnesī
205,28 EUR 178.50 EUR
Produkta numurs: 20371795
DVR 4CH HDCVI PENTABRID/XVR5104H-4M DAHUA XVR5104H-4M
7.89 / mēnesī
220,69 EUR 191.90 EUR
Produkta numurs: 20351909
DVR 8CH HDCVI PENTABRID/XVR5108C-S2 DAHUA DHI-XVR5108C-S2
8.04 / mēnesī
224,94 EUR 195.60 EUR
Produkta numurs: 20490323
DVR 4CH HDCVI TRIBRID 4MP/HCVR7104H-4M DAHUA DH-HCVR7104H-4M
9.35 / mēnesī
261,51 EUR 227.40 EUR