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=1932)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: 20159863
EOS 4000D 18-55 III Black
12.53 / mēnesī
350,41 EUR 304.70 EUR
Produkta numurs: 20323580
Canon EOS 4000D 18-55 III EU26 SLR Camera Kit, Megapixel 18 MP, Image stabilizer, ISO 12800, Display diagonal 2.7 ", Wi-Fi, Video recording, APS-C, Black 3011C003
14.14 / mēnesī
395,37 EUR 343.80 EUR
Produkta numurs: 20179266
Canon EOS 2000D Kit EF-S 18-55 IS II
14.44 / mēnesī
404,00 EUR 351.30 EUR
Produkta numurs: 20139701
CANON D.CAMERA EOS 4000D + EF-S 18-55 3011C003
14.58 / mēnesī
407,91 EUR 354.70 EUR
Produkta numurs: 20327454
Canon EOS 4000D SLR Camera Body 18 MP 5184 x 3456 pixels Black 3011C001
15.14 / mēnesī
423,43 EUR 368.20 EUR
Produkta numurs: 20306843
Canon EOS 2000D 18-55 III EU26 SLR Camera Kit, Megapixel 24.1 MP, Image stabilizer, ISO 12800, Display diagonal 3.0 ", Wi-Fi, Video recording, APS-C, Black 2728C002
16 / mēnesī
447,58 EUR 389.20 EUR
Produkta numurs: 20327452
Canon EOS 2000D BK BODY EU26 SLR Camera Body 24.1 MP CMOS 6000 x 4000 pixels Black 2728C001
17.29 / mēnesī
483,46 EUR 420.40 EUR
Produkta numurs: 20133149
CAMERA DSLR EOS 1500D KIT/18-55 IS II CANON EOS1500KIT1855ISII
17.42 / mēnesī
487,37 EUR 423.80 EUR
Produkta numurs: 20196854
Nikon D3500 + AF-P 18-55 VR
18.18 / mēnesī
508,53 EUR 442.20 EUR
Produkta numurs: 20435930
CAMERA DSLR 24MP D3400 BLK KIT/W/18-55MM VR VBA490K001 NIKON VBA490K001
18.22 / mēnesī
509,68 EUR 443.20 EUR
Produkta numurs: 20139700
CANON EOS 2000D BK 18-55 III EU26 2728C002
18.57 / mēnesī
519,34 EUR 451.60 EUR
Produkta numurs: 20159861
EOS M100 BK M15-45 S White
18.6 / mēnesī
520,15 EUR 452.30 EUR