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=3071)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: 20599876
Battery ATX PLATINUM NOKIA 6500s 1150mAh (BP-5M)
4,60 EUR 4.00 EUR
Produkta numurs: 20456386
Battery ATX PLATINUM SAMSUNG S5330 1350 mAh (EB494353VU)
5,18 EUR 4.50 EUR
Produkta numurs: 20538014
Battery ATX PLATINUM SAMSUNG S8600 1600mAh (EB484659VU )
5,18 EUR 4.50 EUR
Produkta numurs: 20545960
Battery ATX PLATINUM SAMSUNG S3850 1250 mAh(EB424255VA, EB424255VU)
5,18 EUR 4.50 EUR
Produkta numurs: 20545966
Battery ATX PLATINUM SAMSUNG F480 1400mAh (AB553446CE)
5,18 EUR 4.50 EUR
Produkta numurs: 20545967
Battery ATX PLATINUM SAMSUNG E590 850mAh (AB403450BU)
5,18 EUR 4.50 EUR
Produkta numurs: 20545969
Battery ATX PLATINUM SAMSUNG D880 1300mAh (AB553850DE)
5,18 EUR 4.50 EUR
Produkta numurs: 20545970
Battery ATX PLATINUM SAMSUNG C100 1000mAh (BST1807DE)
5,18 EUR 4.50 EUR
Produkta numurs: 20545973
Battery ATX PLATINUM NOKIA С5 1350mAh (BL-5CT)
5,18 EUR 4.50 EUR
Produkta numurs: 20546047
Battery ATX PLATINUM NOKIA 2680s 1100 mAh (BL-4S)
5,18 EUR 4.50 EUR
Produkta numurs: 20546059
Battery ATX PLATINUM LG KG240 900mAh KG248/KG245/KG130/C3600(LGIP-G830)
5,18 EUR 4.50 EUR
Produkta numurs: 20546076
Battery ATX PLATINUM SAMSUNG I5700 1500mAh  (EB504465VU, EB504465VA)
5,18 EUR 4.50 EUR