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: 20599728
Battery ATX PLATINUM SAMSUNG S6500 1500 mAh (EB464358VU)
5,18 EUR 4.50 EUR
Produkta numurs: 20599729
Battery ATX PLATINUM Sony-Ericsson NEO V 1500mAh (BA700)
5,18 EUR 4.50 EUR
Produkta numurs: 20599733
Battery ATX PLATINUM SAMSUNG Z400 1050 mAh (AB803443BA)
5,18 EUR 4.50 EUR
Produkta numurs: 20599737
Battery ATX PLATINUM NOKIA 5800 1500mAh(BL-5J)
5,18 EUR 4.50 EUR
Produkta numurs: 20599741
Battery ATX PLATINUM SONY-ERICSSON YARI 1200 mAh (BST-43)
5,18 EUR 4.50 EUR
Produkta numurs: 20599743
Battery ATX PLATINUM NOKIA LUMIA 820 1400mAh (BP-5T)
5,18 EUR 4.50 EUR
Produkta numurs: 20599746
Battery ATX PLATINUM Nokia 2630 1100 mAh(BL-4B)
5,18 EUR 4.50 EUR
Produkta numurs: 20599752
Battery ATX PLATINUM Nokia 6610 1400mAh (BLD-3)
5,18 EUR 4.50 EUR
Produkta numurs: 20599755
Battery ATX PLATINUM Sony-Ericsson K850 1100 mAh (BST-38)
5,18 EUR 4.50 EUR
Produkta numurs: 20599759
Battery ATX PLATINUM Samsung J600 1000mAh (AB483640BU)
5,18 EUR 4.50 EUR
Produkta numurs: 20599762
Battery ATX PLATINUM SAMSUNG S8300 1000 mAh (AB533640BE)
5,18 EUR 4.50 EUR
Produkta numurs: 20599805
Battery ATX PLATINUM SAMSUNG U600 1000 mAh (AB423643CE)
5,18 EUR 4.50 EUR