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=2834)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: 20361683
DashCam OV-CAMROAD 2.5 OV-CAMROAD 2.5
27,95 EUR 24.30 EUR
Produkta numurs: 20314915
Qoltec IP Camera| HD | IR | WiFi | night/day 50226
31,51 EUR 27.40 EUR
Produkta numurs: 20173087
GoPro Rezerves akumulators HERO5 hero6 Hero7 Black kamerai
35,42 EUR 30.80 EUR
Produkta numurs: 20314916
Qoltec CAR RECORDER Full HD | G-SENSOR | Monitoring | LCD 2.7'' 50224
36,11 EUR 31.40 EUR
Produkta numurs: 20135706
GoXtreme Rebel 20149
40,02 EUR 34.80 EUR
Produkta numurs: 20323691
Bresser Action Cam LED Lamp 8785201 8785201
43,24 EUR 37.60 EUR
Produkta numurs: 20173761
GoXtreme Rebel 20149 20149
47,84 EUR 41.60 EUR
Produkta numurs: 20314914
Qoltec Outdoor IP camera | HD | IR | WiFi | night/day 50227
47,84 EUR 41.60 EUR
Produkta numurs: 20469404
Acme Action camera VR04 140 °, 720 pixels, 30 fps, Built-in speaker(s), Built-in display, Built-in microphone, VR04
48,07 EUR 41.80 EUR
Produkta numurs: 20354529
Easypix Panox Champion action sports camera HD 56103
48,30 EUR 42.00 EUR
Produkta numurs: 20199292
DashCam OV-CAMROAD Mirror 2.0 OV-CAMROAD Mirror 2.0
54,74 EUR 47.60 EUR
Produkta numurs: 20314917
Waterproof Sports Camera Full HD Qoltec 2'' | 4K | black 50223
2.18 / mēnesī
60,84 EUR 52.90 EUR