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=210)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: 20597654
TDK E-30HS
0,69 EUR 0.60 EUR
Produkta numurs: 20597689
TDK VCL-11
1,15 EUR 1.00 EUR
Produkta numurs: 20597688
TDK CLDVM
2,30 EUR 2.00 EUR
Produkta numurs: 20597829
TDK E-180TV
6,10 EUR 5.30 EUR
Produkta numurs: 20597838
TDK DVM-60MEEA
6,33 EUR 5.50 EUR
Produkta numurs: 20587265
GoPro Removable Instrument Mount AMRAD-001
6,56 EUR 5.70 EUR
Produkta numurs: 20142107
Boya Deadcat Windshield BY-B05 (1 gab.)
7,59 EUR 6.60 EUR
Produkta numurs: 20582301
GoPro Bodyboard Mount ABBRD-001
8,40 EUR 7.30 EUR
Produkta numurs: 20141174
DS rokas atbalsts stabilizācijas iekārtām
8,51 EUR 7.40 EUR
Produkta numurs: 20587262
GoPro Lens Replacment Kit for HERO 3 ALNRK-301
9,55 EUR 8.30 EUR
Produkta numurs: 20582300
GoPro Standart Housing BacPac Backdoor kit ASDRK-301
9,66 EUR 8.40 EUR
Produkta numurs: 20587258
GoPro Remote Attachment Keys & Rings AWFKY-001
9,66 EUR 8.40 EUR