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=3009)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: 20299442
Xiaomi Yeelight Remote Control white (YLYK01YL)
8,97 EUR 7.80 EUR
Produkta numurs: 20353259
Fibaro FGB-002 Dimmer Bypass 2 5902020528555
9,89 EUR 8.60 EUR
Produkta numurs: 20299441
Xiaomi Yeelight Motion Sensor Night Light (YLYD01YL)
16,22 EUR 14.10 EUR
Produkta numurs: 20299443
Xiaomi Yeelight Smart LED Bulb (Tunable White) (YLDP05YL)
24,15 EUR 21.00 EUR
Produkta numurs: 20166442
Xiaomi Yeelight Smart LED Bulb (Color) (YLDP06YL)
25,19 EUR 21.90 EUR
Produkta numurs: 20299444
Xiaomi Mi LED Smart Bulb (White and Color) (MJDP02YL)
25,76 EUR 22.40 EUR
Produkta numurs: 20472116
Netgear VMA1000 Mount VMA1000-10000S
26,91 EUR 23.40 EUR
Produkta numurs: 20461607
Netgear VMA1000B Mount VMA1000B-10000S
27,60 EUR 24.00 EUR
Produkta numurs: 20166439
Xiaomi Yeelight LED Table Lamp white (YLTD01YL)
29,67 EUR 25.80 EUR
Produkta numurs: 20166440
Xiaomi Yeelight Smart Light Strip RGB (YLDD01YL)
38,41 EUR 33.40 EUR
Produkta numurs: 20353248
Fibaro FGDW-002-1 Door / Window Sensor (WHITE) 5902701700348
50,60 EUR 44.00 EUR
Produkta numurs: 20353249
Fibaro FGDW-002-3 Door / Window Sensor (BLACK) 5902701700362
50,60 EUR 44.00 EUR