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=1104)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: 20442437
Back cover   for VTO1210C-X
15,41 EUR 13.40 EUR
Produkta numurs: 20505463
Power source 24V DS-65LSI-19
22,31 EUR 19.40 EUR
Produkta numurs: 20367724
DNT VRCAM720 webcam 2 MP 1920 x 1080 pixels USB 3.0 Black,White 52174
24,73 EUR 21.50 EUR
Produkta numurs: 20505453
Back cover   VTOB111
33,47 EUR 29.10 EUR
Produkta numurs: 20523803
Bracket DH-VTOB108
33,47 EUR 29.10 EUR
Produkta numurs: 20360194
Denver IPC-1020 white
36,00 EUR 31.30 EUR
Produkta numurs: 20134474
Denver IPC-1031
37,84 EUR 32.90 EUR
Produkta numurs: 20351800
ZHEJIANG DAHUA VISION TECHNOLOGY CO., LTD Blank module VTO2000A-E
38,99 EUR 33.90 EUR
Produkta numurs: 20505454
Back cover   VTOB112
38,99 EUR 33.90 EUR
Produkta numurs: 20523799
Back cover  for VTOB107
38,99 EUR 33.90 EUR
Produkta numurs: 20360191
Denver IPC-330 white
40,02 EUR 34.80 EUR
Produkta numurs: 20360192
Denver IPO-1320 black
46,46 EUR 40.40 EUR