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 (p._brand='120')AND s.disabled=0 GROUP BY p.id ORDER BY p.price
Produkta numurs: 20599832
Battery Samsung EB494358VU ORIGINAL
8,05 EUR 7.00 EUR
Produkta numurs: 20599802
Battery Samsung EB425161LU ORIGINAL
9,78 EUR 8.50 EUR
Produkta numurs: 20599736
Battery Samsung EB-F1A2GBU ORIGINAL
10,93 EUR 9.50 EUR
Produkta numurs: 20453406
Battery Samsung EB-B220AC ORIGINAL (OEM) 2600 mAh Galaxy Grand 2
11,27 EUR 9.80 EUR
Produkta numurs: 20599823
Battery SAMSUNG EB615268VU ORIGINAL Galaxy Note N7000
11,50 EUR 10.00 EUR
Produkta numurs: 20599871
BAT. SAMSUNG EB484659VU ORIGINAL
11,50 EUR 10.00 EUR
Produkta numurs: 20599765
Battery SAMSUNG EB535151VU, ORIGINAL
12,08 EUR 10.50 EUR
Produkta numurs: 20599870
Battery SAMSUNG EB-F1M7FLU, ORIGINAL
12,08 EUR 10.50 EUR
Produkta numurs: 20599757
Battery Samsung EB-B500BE ORIGINAL
12,65 EUR 11.00 EUR
Produkta numurs: 20599863
Battery Samsung EB-B600 ORIGINAL
12,65 EUR 11.00 EUR
Produkta numurs: 20501823
Battery SAMSUNG EB-L1G6LLU, ORIGINAL
13,23 EUR 11.50 EUR
Produkta numurs: 20546045
Battery SAMSUNG EB-B800 ORIGINAL Galaxy Note 3 N9005
13,23 EUR 11.50 EUR