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: 20599783
Battery ATX PLATINUM NOKIA 112 1450mAh(BL-6C)
4,60 EUR 4.00 EUR
Produkta numurs: 20599790
Battery ATX PLATINUM NOKIA 6280 1250mAh (BP-6M)
4,60 EUR 4.00 EUR
Produkta numurs: 20599798
Battery ATX PLATINUM NOKIA 3220 1150mAh(BL-5B)
4,60 EUR 4.00 EUR
Produkta numurs: 20599801
Battery ATX PLATINUM NOKIA 6300 1200mAh (BL-4C)
4,60 EUR 4.00 EUR
Produkta numurs: 20599806
Tel1 Battery NOKIA 1208/1209 (BL-5CA) 1200mAh Li-ion
4,60 EUR 4.00 EUR
Produkta numurs: 20599820
Battery ATX PLATINUM NOKIA E52 1500mAh (BP-4L)
4,60 EUR 4.00 EUR
Produkta numurs: 20599839
Battery ATX PLATINUM SAMSUNG S3350 CH@T 1250mAh (EB424255VA, EB424255VU)
4,60 EUR 4.00 EUR
Produkta numurs: 20599840
Battery ATX PLATINUM LG KU990 1300mAh(LGIP-580A)
4,60 EUR 4.00 EUR
Produkta numurs: 20599842
Battery ATX PLATINUM NOKIA 5310 1200mAh(BL-4CT)
4,60 EUR 4.00 EUR
Produkta numurs: 20599843
Battery ATX PLATINUM NOKIA 3510 1450mAh(BLC-2)
4,60 EUR 4.00 EUR
Produkta numurs: 20599856
Battery ATX PLATINUM Sony-Ericsson K510 1000 mAh (BST-36)
4,60 EUR 4.00 EUR
Produkta numurs: 20599866
Battery ATX PLATINUM Samsung D900 1400mAh (AB503442CU)
4,60 EUR 4.00 EUR