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=1110)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: 20360203
Denver ASA-50 (Wireless PIR motion sensor)
16,91 EUR 14.70 EUR
Produkta numurs: 20390791
Ubiquiti Networks Wall Mount Motion Sensor MFI-MSW
20,70 EUR 18.00 EUR
Produkta numurs: 20360204
Denver ASA-40 (Wireless pet immune PIR motion sensor)
25,19 EUR 21.90 EUR
Produkta numurs: 20521451
IR Judesio daviklis ADP1010
27,83 EUR 24.20 EUR
Produkta numurs: 20461025
DETECTOR WATER FLOOD/FD-1 SATEL FD-1
28,87 EUR 25.10 EUR
Produkta numurs: 20391019
Ubiquiti Networks Ceiling Mount Motion Sensor MFI-MSC
29,67 EUR 25.80 EUR
Produkta numurs: 20436139
DETECTOR DOOR/WIN. OPENING WRL/MICRA MMD-300 SATEL MMD-300
31,05 EUR 27.00 EUR
Produkta numurs: 20537242
DETECTOR SMOKE FIRE TEMP./TSD-1 SATEL TSD-1
31,97 EUR 27.80 EUR
Produkta numurs: 20339667
DETECTOR VIBRATION WIRELESS/VD-1 SATEL VD-1
33,93 EUR 29.50 EUR
Produkta numurs: 20542717
DETECTOR PIR MOTION + GLASS/BREAK NAVY SATEL NAVY
35,77 EUR 31.10 EUR
Produkta numurs: 20351912
DETECTOR SMOKE/FAD201A DAHUA FAD201A
41,63 EUR 36.20 EUR
Produkta numurs: 20521464
IR Judesio daviklis ADP1200
47,15 EUR 41.00 EUR