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=2833)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: 20160222
8level ALRM-RC-1 remote control ALRM-RC-1
7,25 EUR 6.30 EUR
Produkta numurs: 20432031
Personal Safety Alarm 110 dB SAS-APA30
8,28 EUR 7.20 EUR
Produkta numurs: 20158922
König dummy indoor dome camera SAS-DUMMYCAM50
9,78 EUR 8.50 EUR
Produkta numurs: 20559843
König dummy indoor dome camera IR flashing LED SAS-DUMMYCAM60
10,35 EUR 9.00 EUR
Produkta numurs: 20551671
König dummy alarm system motion sensor SAS-DUMMYMS10
12,08 EUR 10.50 EUR
Produkta numurs: 20160223
8level ALRM-MS-1 wireless motion sensor external antenna ALRM-MS-1
12,88 EUR 11.20 EUR
Produkta numurs: 20432032
Personal Safety Alarm 130 dB SAS-AMM30
13,00 EUR 11.30 EUR
Produkta numurs: 20432033
Contact Alarm 115 dB SAS-ADS30
13,92 EUR 12.10 EUR
Produkta numurs: 20401811
Konig Car Audio Kit 800 W KNKB28910V
14,95 EUR 13.00 EUR
Produkta numurs: 20187684
XIAOMI Mi Temperature and Humidity Monitor NUN4019TY
16,10 EUR 14.00 EUR
Produkta numurs: 20587042
Ārējā GSM antena
22,43 EUR 19.50 EUR
Produkta numurs: 20401810
Konig Car Audio Kit 1200 W KNKB28920V
24,04 EUR 20.90 EUR