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: 20599796
Battery ATX PLATINUM SAMSUNG L760 750 mAh Iic (AB553443DU)
4,03 EUR 3.50 EUR
Produkta numurs: 20545974
Battery ATX PLATINUM NOKIA 6100 1150mAh (BL-4C)
4,37 EUR 3.80 EUR
Produkta numurs: 20501820
Battery ATX PLATINUM NOKIA 3100 1250mAh(BL-5C)
4,60 EUR 4.00 EUR
Produkta numurs: 20545102
Battery ATX PLATINUM SAMSUNG E250 1050mAh (AB463446BU)
4,60 EUR 4.00 EUR
Produkta numurs: 20545968
Battery ATX PLATINUM SAMSUNG E350 700mAh Iic (BST4208)
4,60 EUR 4.00 EUR
Produkta numurs: 20545971
Battery ATX PLATINUM NOKIA N95 1200mAh (BL-5F)
4,60 EUR 4.00 EUR
Produkta numurs: 20545972
Battery ATX PLATINUM NOKIA E66 1250mAh (BL-4U)
4,60 EUR 4.00 EUR
Produkta numurs: 20599730
Battery ATX PLATINUM Sony-Ericsson K800 1200 mAh (BST-33)
4,60 EUR 4.00 EUR
Produkta numurs: 20599732
Battery ATX PLATINUM Sony-Ericsson C902 1100 mAh (BST-38)
4,60 EUR 4.00 EUR
Produkta numurs: 20599747
Battery ATX PLATINUM Sony-Ericsson K750 1200 mAh (BST-37)
4,60 EUR 4.00 EUR
Produkta numurs: 20599773
Battery ATX PLATINUM NOKIA E51 1350mAh (BP-6MT)
4,60 EUR 4.00 EUR
Produkta numurs: 20599778
Battery ATX PLATINUM Sony-Ericsson K700 1150 mAh (BST-30)
4,60 EUR 4.00 EUR