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=192)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: 20355421
Kabelis Gembird 3.5mm Jack - 2x RCA 0.2m CCA-458/0.2
1,84 EUR 1.60 EUR
Produkta numurs: 20355358
Kabelis Gembird 3.5mm Jack - 2x RCA 1.5m CCA-458
1,96 EUR 1.70 EUR
Produkta numurs: 20355377
Kabelis Gembird 3.5 mm stereo audio 1.5m CCA-423
1,96 EUR 1.70 EUR
Produkta numurs: 20355406
Kabelis Gembird 3.5mm Jack - 2xRCA CCA-406
1,96 EUR 1.70 EUR
Produkta numurs: 20355367
Gembird 2 x RCA Male - 2 x RCA Male 1.8m Black CCA-2R2R-6
2,07 EUR 1.80 EUR
Produkta numurs: 20355418
Kabelis Gembird 3.5mm Jack - 2x RCA 2.5m CCA-458-2.5M
2,07 EUR 1.80 EUR
Produkta numurs: 20355420
Gembird 2 x RCA Male - 2 x RCA Male 3m Black CCA-2R2R-10
2,19 EUR 1.90 EUR
Produkta numurs: 20325161
Gembird 3.5 mm Audio Splitter Cable CCA-415-0.1M
2,30 EUR 2.00 EUR
Produkta numurs: 20344331
Gembird 3.5mm Male - 3.5mm Female 2m Black CCA-423-2M
2,30 EUR 2.00 EUR
Produkta numurs: 20355398
Kabelis Gembird 3.5 mm audio splitter CCA-415W
2,30 EUR 2.00 EUR
Produkta numurs: 20355419
Kabelis Gembird 3.5mm Jack -2x RCA 5m CCA-458-5M
2,53 EUR 2.20 EUR
Produkta numurs: 20550511
Philips S-Video kabelis 1.5m SWV 2511 W/10
2,53 EUR 2.20 EUR