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=2825)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
Kategorijas
Produkta numurs: 20554939
Elektriskā urbjmašīna Bort BSM-540 98296556
28,75 EUR 25.00 EUR
Produkta numurs: 20450929
Elektriskā urbjmašīna BORT BSM-250x2 98296648
33,35 EUR 29.00 EUR
Produkta numurs: 20487618
Akumulatora urbjmašīna Bort BAB-10.8-P 91270016
36,80 EUR 32.00 EUR
Produkta numurs: 20304810
Akumulatora urbjmašīna Bort BAB-10,8X 91272560
39,10 EUR 34.00 EUR
Produkta numurs: 20556018
Akumulatora urbjmašīna Defort  DCD-14N-1 98299885
39,10 EUR 34.00 EUR
Produkta numurs: 20556017
Akumulatora urbjmašīna Defort  DCD-14N-7-BDK 98299793
49,45 EUR 43.00 EUR
Produkta numurs: 20159880
Akumulatora urbjmašīna Bort BAB-12U-DK 93723989
57,50 EUR 50.00 EUR
Produkta numurs: 20554979
Akumulatora urbjmašīna Defort  DCD-12Nx2D 98292114
2.14 / mēnesī
59,80 EUR 52.00 EUR
Produkta numurs: 20444903
Akumulatoru urbjmašīna BORT BAB-10,8-Px2D 91270948
2.18 / mēnesī
60,95 EUR 53.00 EUR
Produkta numurs: 20540400
Akumulatora urbjmašīna Defort  DCD-14Nx2D 98295603
2.3 / mēnesī
64,40 EUR 56.00 EUR
Produkta numurs: 20293854
Akumulatoru urbjmašīna BAB-12x2Li-FDK 91276056
2.71 / mēnesī
75,90 EUR 66.00 EUR
Produkta numurs: 20554980
Akumulatora urbjmašīna Bort BAB-10.8N-LiD 98292268
2.75 / mēnesī
77,05 EUR 67.00 EUR