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: 20599807
Battery ATX PLATINUM Sony-Ericsson J132 1300mAh (BST-42)
5,18 EUR 4.50 EUR
Produkta numurs: 20599813
Battery ATX PLATINUM SAMSUNG S8500 1500 mAh (EB504465VU, EB504465VA)
5,18 EUR 4.50 EUR
Produkta numurs: 20599826
Battery ATX PLATINUM SAMSUNG U900 1100 mAh (AB653039CE)
5,18 EUR 4.50 EUR
Produkta numurs: 20599828
Battery ATX PLATINUM SAMSUNG U700 1050 mAh Z720/Z560/Z370 (AB553443CE)
5,18 EUR 4.50 EUR
Produkta numurs: 20599833
Battery ATX PLATINUM Samsung J400 1150mAh (AB533640CU)
5,18 EUR 4.50 EUR
Produkta numurs: 20599834
Battery ATX PLATINUM SAMSUNG S5200 1000mAh (EB504239HU)
5,18 EUR 4.50 EUR
Produkta numurs: 20599837
Battery ATX PLATINUM Sony-Ericsson W910 1200 mAh (BST-39)
5,18 EUR 4.50 EUR
Produkta numurs: 20599847
Battery ATX PLATINUM NOKIA 6303 1350mAh (BL-5CT)
5,18 EUR 4.50 EUR
Produkta numurs: 20599857
Battery ATX PLATINUM SAMSUNG S5230 1200mAh (AB603443CE)
5,18 EUR 4.50 EUR
Produkta numurs: 20599859
Battery ATX PLATINUM SONY Xperia U/ST25I 1500mAh (BA600)
5,18 EUR 4.50 EUR
Produkta numurs: 20599861
Battery ATX PLATINUM SAMSUNG S3650 1200mAh (AB463651BE, AB463651BU)
5,18 EUR 4.50 EUR
Produkta numurs: 20599864
Battery ATX PLATINUM Sony-Ericsson T610 1300 mAh (BST-25)
5,18 EUR 4.50 EUR