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=2323)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: 20427583
NAGA Metal holder for markers and accessories 23956
10,93 EUR 9.50 EUR
Produkta numurs: 20319959
Nobo Diamond Glass Board 1904100
22,43 EUR 19.50 EUR
Produkta numurs: 20167101
Nobo Diamond Glass Desktop Pad 1905174
32,32 EUR 28.10 EUR
Produkta numurs: 20489962
Vivolink Glass Board White VLGB46W
2.64 / mēnesī
73,95 EUR 64.30 EUR
Produkta numurs: 20595124
NOBO Classic Steel Tripod Magnetic Flipchart Easel 4TNF02
3.96 / mēnesī
110,75 EUR 96.30 EUR
Produkta numurs: 20318754
Nobo Diamond Glass Board 1905176
4.43 / mēnesī
123,86 EUR 107.70 EUR
Produkta numurs: 20601493
Nobo Diamond Glass Board with 1905191
5.29 / mēnesī
147,89 EUR 128.60 EUR
Produkta numurs: 20195499
Digitus TFT holder Manhattan Universal DA-90370
6.21 / mēnesī
173,77 EUR 151.10 EUR
Produkta numurs: 20601538
Ergotron TILTING WALLMOUNT 61-143-003
6.6 / mēnesī
184,69 EUR 160.60 EUR
Produkta numurs: 20315847
Nobo Diamond Glass Board 1905177
6.74 / mēnesī
188,60 EUR 164.00 EUR
Produkta numurs: 20489804
Vivolink Vivolink Flipchart Mobile VLFCM
6.98 / mēnesī
195,16 EUR 169.70 EUR
Produkta numurs: 20425306
Vivolink Glass Board White VLGB68W
7 / mēnesī
195,85 EUR 170.30 EUR