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=211)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: 20597466
TL-CAT-010 long rubber boot Gembird
0,12 EUR 0.10 EUR
Produkta numurs: 20541115
Konektors RJ45 MP-8P8C Gembird PLUG5SP
0,23 EUR 0.20 EUR
Produkta numurs: 20597946
*Kabelis CC-Audio CD-ROM Gembird
0,23 EUR 0.20 EUR
Produkta numurs: 20597945
*Kabelis IDE 40pin.50sm.CC-IDE-33 Gembird
0,35 EUR 0.30 EUR
Produkta numurs: 20597924
*Kabelis IDE 80pin/ 0.60m Defender
0,46 EUR 0.40 EUR
Produkta numurs: 20597948
*Kabelis IDE 80pin.48sm.CC-IDE-66 Gembird
0,46 EUR 0.40 EUR
Produkta numurs: 20592017
Kabelis AUDIO STEREO 3.5mm. 1.5m. Gembird CCA-458
0,58 EUR 0.50 EUR
Produkta numurs: 20592020
Kabelis AUDIO STEREO 3.5mm. 2.5m. Gembird CCA-458
0,58 EUR 0.50 EUR
Produkta numurs: 20597923
Kabelis USB 2.0 A/B 1.8m.
0,58 EUR 0.50 EUR
Produkta numurs: 20597939
*Pagarin.tastatūraiKE003 DIN5M/DIN5F 1.8m
0,58 EUR 0.50 EUR
Produkta numurs: 20597947
Adapteris tastat.CC-178 MD6M/DIN5F Gembird
0,58 EUR 0.50 EUR
Produkta numurs: 20594526
Kabelis audio 3, 5/3, 5 pagarinātāis 1.5m. Cablexpert CCA-423
0,69 EUR 0.60 EUR