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=2894)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: 20302369
03/24-F Basket Trekking Lite
5,52 EUR 4.80 EUR
Produkta numurs: 20357531
Stride Light FLS SMU 100
29,67 EUR 25.80 EUR
Produkta numurs: 20357525
Stride Light FLS SMU 130
29,79 EUR 25.90 EUR
Produkta numurs: 20357526
Stride Light FLS SMU 125
29,79 EUR 25.90 EUR
Produkta numurs: 20357527
Stride Light FLS SMU 120
29,79 EUR 25.90 EUR
Produkta numurs: 20357900
Stride Light NCS 100cm. 100
42,21 EUR 36.70 EUR
Produkta numurs: 20447217
Light NCS 130cm. 130
48,19 EUR 41.90 EUR
Produkta numurs: 20447216
Light NCS 125cm. 125
48,30 EUR 42.00 EUR
Produkta numurs: 20447213
Light NCS 105cm. 105
48,53 EUR 42.20 EUR
Produkta numurs: 20357635
Mont Blanc red
52,44 EUR 45.60 EUR
Produkta numurs: 20447209
Stride FX-75 snake carbon 100
4.26 / mēnesī
119,26 EUR 103.70 EUR
Produkta numurs: 20357968
Stride FX-75 snake carbon 110
4.3 / mēnesī
120,18 EUR 104.50 EUR