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=1096)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: 20362910
CONTROL PANEL ENCLOSURE/INSERTS OMI-5 PI SATEL OMI-5PI
11,73 EUR 10.20 EUR
Produkta numurs: 20537248
CONTROL PANEL CASE PLASTIC/OPU-4P SATEL OPU-4P
27,72 EUR 24.10 EUR
Produkta numurs: 20303800
CONTROL PANEL CASE PLASTIC/FLUSH MOUNT OPU-4PW SATEL OPU-4PW
29,67 EUR 25.80 EUR
Produkta numurs: 20537241
PROGRAMMING CABLE KIT/USB-RS SATEL USB-RS
38,87 EUR 33.80 EUR
Produkta numurs: 20461026
CONTROL PANEL CASE PLASTIC/OPU-3P SATEL OPU-3P
47,15 EUR 41.00 EUR
Produkta numurs: 20362909
CONTROL PANEL ENCLOSURE METAL/OMI-5 SATEL OMI-5
2.46 / mēnesī
68,89 EUR 59.90 EUR
Produkta numurs: 20587476
CONTROL PANEL CASE METAL/OMI-3 SATEL OMI-3
3.22 / mēnesī
90,16 EUR 78.40 EUR