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=1095)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: 20589879
BATTERY 12V 7AH VRLA/FGB7-12 EMU FGB7-12
13,46 EUR 11.70 EUR
Produkta numurs: 20486342
BATTERY 12V 5AH VRLA/AM5-12T2 ACUMAX EMU AM5-12T2
15,07 EUR 13.10 EUR
Produkta numurs: 20376859
BATTERY 12V 5.3AH VRLA/EV5.8-12 T2 EUROPOWER EMU EV5.8-12T2
19,09 EUR 16.60 EUR
Produkta numurs: 20509621
BATTERY 12V 7.2AH VRLA/EP7.2-12 T2 EUROPOWER EMU EP7.2-12T2
22,43 EUR 19.50 EUR
Produkta numurs: 20540004
BATTERY 12V 9AH VRLA/EV9-12 T2 EUROPOWER EMU EV9-12T2
24,96 EUR 21.70 EUR
Produkta numurs: 20539386
BATTERY 12V 12AH VRLA/AM12-12 ACUMAX EMU AM12-12
29,21 EUR 25.40 EUR
Produkta numurs: 20553244
BATTERY 12V 17AH VRLA/EP17-12 EUROPOWER EMU EP17-12
51,41 EUR 44.70 EUR