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=2801)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: 20153704
Leņķa slīpmašīna Bort BWS-580 91275745
21,85 EUR 19.00 EUR
Produkta numurs: 20444899
Leņķa slīpmašīna BORT BWS-610-P 91271037
27,60 EUR 24.00 EUR
Produkta numurs: 20554925
Leņķa slīpmašīna Bort BWS-500-P 98299946
27,60 EUR 24.00 EUR
Produkta numurs: 20153705
Leņķa slīpmašīna Bort BWS-920-125 91275318
33,35 EUR 29.00 EUR
Produkta numurs: 20294052
Leņķa slīpmašīna BORT BWS-950 98296389
41,40 EUR 36.00 EUR
Produkta numurs: 20556002
Leņķa slīpmašīna Bort BWS-905-R 98290004
46,00 EUR 40.00 EUR
Produkta numurs: 20294050
Daudzfunkcionālais instruments Bort BMW-240X-R 91272607
49,45 EUR 43.00 EUR