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=1099)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: 20589881
CONTROL PANEL 10-30ZONES/VERSA10 SATEL VERSA10
2.33 / mēnesī
65,09 EUR 56.60 EUR
Produkta numurs: 20392502
CONTROL PANEL 32 ZONES WRL/ALARM HUB ARC2000B-W DAHUA ARC2000B-W
3.8 / mēnesī
106,26 EUR 92.40 EUR
Produkta numurs: 20490778
CONTROL PANEL ADVANCED/8-32ZONES INTEGRA32 SATEL INTEGRA32
4.06 / mēnesī
113,62 EUR 98.80 EUR
Produkta numurs: 20461029
CONTROL PANEL ADVANCED/16-64ZONES INTEGRA64 SATEL INTEGRA64
5.83 / mēnesī
163,19 EUR 141.90 EUR
Produkta numurs: 20546443
CONTROL PANEL ADVANCED/16-128ZONES INTEGRA128 SATEL INTEGRA128
6.57 / mēnesī
183,66 EUR 159.70 EUR
Produkta numurs: 20536744
CONTROL PANEL GRADE 3/INTEGRA64 PLUS SATEL INTEGRA64PLUS
7.29 / mēnesī
203,90 EUR 177.30 EUR
Produkta numurs: 20436428
CONTROL PANEL 8-16ZONES/SET PERFECTA 16-WRL/A SATEL SETPERFECTA16-WRL/A
7.36 / mēnesī
205,97 EUR 179.10 EUR
Produkta numurs: 20537243
CONTROL PANEL GRADE 3/INTEGRA128 PLUS SATEL INTEGRA128PLUS
7.96 / mēnesī
222,64 EUR 193.60 EUR
Produkta numurs: 20371811
CONTROL PANEL 34 ZONES LCD/WI-FI ARC5402A-GW DAHUA ARC5402A-GW
13.57 / mēnesī
379,50 EUR 330.00 EUR