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=103)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: 20561745
Intenso Photo Agent Plus digital photo frame 17.8 cm (7") Black 3906801
47,73 EUR 41.50 EUR
Produkta numurs: 20475829
Braun Photo Technik DigiFrame 709 digital photo frame 17.8 cm (7") Pink 21203
53,02 EUR 46.10 EUR
Produkta numurs: 20569047
Braun Photo Technik DigiFrame 709 digital photo frame 17.8 cm (7") Blue 21202
53,02 EUR 46.10 EUR
Produkta numurs: 20569055
Braun DigiFrame 7060 black 17,8cm (7 ) 21199 21199
2.06 / mēnesī
57,62 EUR 50.10 EUR
Produkta numurs: 20416298
Rollei Pissarro DPF-82 digital photo frame 20.3 cm (8") White 30240
2.15 / mēnesī
60,26 EUR 52.40 EUR
Produkta numurs: 20416299
Rollei Pissarro DPF-82 digital photo frame 20.3 cm (8") Black 30239
2.15 / mēnesī
60,26 EUR 52.40 EUR
Produkta numurs: 20393727
Rollei Degas DPF-800 Black digital photo frame 20.3 cm (8") 30242
2.16 / mēnesī
60,38 EUR 52.50 EUR
Produkta numurs: 20394162
Rollei Degas DPF-800 White digital photo frame 20.3 cm (8") 30243
2.16 / mēnesī
60,38 EUR 52.50 EUR
Produkta numurs: 20499669
Intenso Digital Photo Frame 8 '' PhotoBase 3914800
2.17 / mēnesī
60,61 EUR 52.70 EUR
Produkta numurs: 20416302
Braun Photo Technik 21222 digital photo frame 17.8 cm (7") Yellow 21222
2.18 / mēnesī
60,84 EUR 52.90 EUR
Produkta numurs: 20416303
Braun DigiFrame 711 white 21221 21221
2.18 / mēnesī
60,84 EUR 52.90 EUR
Produkta numurs: 20451014
UN3091/DPF-8SL B Steel
2.21 / mēnesī
61,76 EUR 53.70 EUR