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=1109)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: 20443812
MIfare1 Key Tag Card MF-3802K
1,38 EUR 1.20 EUR
Produkta numurs: 20443813
Mifare 1 Card MF-3802B
1,38 EUR 1.20 EUR
Produkta numurs: 20436400
PROXIMITY CARD MIFARE RFID/IC CARD MIFARE DAHUA ICCARDMIFARE
2,88 EUR 2.50 EUR
Produkta numurs: 20452005
PROXIMITY CARD /INTEGRA /ACCO/125KHZ KT-STD-1 SATEL KT-STD-1
4,83 EUR 4.20 EUR
Produkta numurs: 20363909
PROXIMITY CARD EM-MARIN/9134165E 2N 9134165E
5,18 EUR 4.50 EUR
Produkta numurs: 20390782
Ubiquiti Networks mFi-DS MFI-DS
9,55 EUR 8.30 EUR
Produkta numurs: 20363880
ENTRY PANEL IP EXTENSION CABLE/1M 9155050 2N 9155050
23,00 EUR 20.00 EUR
Produkta numurs: 20363883
ENTRY PANEL IP VERSO BLIND/BUTTON 9155051 2N 9155051
23,00 EUR 20.00 EUR
Produkta numurs: 20363887
ENTRY PANEL IP EXTENSION CABLE/3M 9155054 2N 9155054
33,24 EUR 28.90 EUR
Produkta numurs: 20490774
CARD READER /INTEGRA/ACCO/CZ-EMM SATEL CZ-EMM
36,34 EUR 31.60 EUR
Produkta numurs: 20363874
ENTRY PANEL FLUSH MOUNT BOX/IP SOLO 9155017 2N 9155017
38,41 EUR 33.40 EUR
Produkta numurs: 20363892
ENTRY PANEL FLUSH MOUNT BOX/HELIOS IP VERSO 9155014 2N 9155014
38,41 EUR 33.40 EUR