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=2931)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: 20315196
Apple iPhone 6 32GB Gray MQ3D2
15.58 / mēnesī
435,85 EUR 379.00 EUR
Produkta numurs: 20534059
iPhone 6s 32GB Gold MN112
21.75 / mēnesī
608,35 EUR 529.00 EUR
Produkta numurs: 20579350
iPhone 6s 32GB Rose Gold MN122
21.75 / mēnesī
608,35 EUR 529.00 EUR
Produkta numurs: 20579351
iPhone 6s 32GB Space Gray MN0W2
21.75 / mēnesī
608,35 EUR 529.00 EUR
Produkta numurs: 20579352
iPhone 6s 32GB Silver MN0X2
21.75 / mēnesī
608,35 EUR 529.00 EUR
Produkta numurs: 20534058
iPhone 6s 128GB Space Gray MKQT2
24.63 / mēnesī
688,85 EUR 599.00 EUR
Produkta numurs: 20559278
Apple iPhone 6s 128GB Rose Gold MKQW2
24.63 / mēnesī
688,85 EUR 599.00 EUR
Produkta numurs: 20559279
Apple iPhone 6s 128GB Gold MKQV2
24.63 / mēnesī
688,85 EUR 599.00 EUR
Produkta numurs: 20579349
Apple iPhone 6s 128GB Silver MKQU2
24.63 / mēnesī
688,85 EUR 599.00 EUR