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=1098)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: 20522592
1/3" Mono-focal Lens 12mm. IR CUT M12IR12
17,02 EUR 14.80 EUR
Produkta numurs: 20522593
1/3" Mono-focal Lens 3.6mm. CUT M12CUT36
17,02 EUR 14.80 EUR
Produkta numurs: 20522594
1/3" Mono-focal  Lens 8mm. IR CUT M12CUT8
17,02 EUR 14.80 EUR
Produkta numurs: 20522596
1/3" Mono-focal   Lens 3.6mm. IR M12IR36
17,02 EUR 14.80 EUR
Produkta numurs: 20522695
1/3" Mono-focal  Lens 6mm. IR CUT M12CUT6
17,02 EUR 14.80 EUR
Produkta numurs: 20522679
CCTV lens HD 1/2,7" 2.8-12mm XD02812GMP
29,33 EUR 25.50 EUR
Produkta numurs: 20513716
4 MegaPixel Lens 2.7-12mm
2.09 / mēnesī
58,54 EUR 50.90 EUR
Produkta numurs: 20443681
3 MegaPixel Lens 2.7-12mm
2.14 / mēnesī
59,92 EUR 52.10 EUR
Produkta numurs: 20522745
1/3" Fisheye lens 1,25mm MP IR M12IR125F
2.62 / mēnesī
73,37 EUR 63.80 EUR
Produkta numurs: 20493936
CCTV lens HD 1/3"  2.8-12mm XD-3M2812A
3.67 / mēnesī
102,70 EUR 89.30 EUR
Produkta numurs: 20522700
3 MegaPixel Lens 5-50mm
4.03 / mēnesī
112,82 EUR 98.10 EUR
Produkta numurs: 20435884
CCTV LENS MEGAPIXEL 3-8MM/A.IRIS M13VG308 TAMRON M13VG308
4.17 / mēnesī
116,73 EUR 101.50 EUR