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=128)AND (((p.amount_onplace>0) OR (p.amount_onwarehouse>0)) AND disable<>1 )AND (p._brand='118')AND s.disabled=0 GROUP BY p.id ORDER BY p.price
Produkta numurs: 20552772
PANASONIC DMP-BD84EG-K
3.56 / mēnesī
99,48 EUR 86.50 EUR
Produkta numurs: 20552773
PANASONIC DMP-BD84EG-S
3.56 / mēnesī
99,48 EUR 86.50 EUR
Produkta numurs: 20463308
Panasonic DMP-BDT167 DVD player 3D Black DMPBDT167EG
3.83 / mēnesī
107,18 EUR 93.20 EUR
Produkta numurs: 20475274
Panasonic DMP-BDT168EG DVD/Blu-Ray player 3D Silver DMPBDT168EG
3.83 / mēnesī
107,18 EUR 93.20 EUR
Produkta numurs: 20552774
PANASONIC DMP-BDT167EG
3.91 / mēnesī
109,25 EUR 95.00 EUR
Produkta numurs: 20552786
PANASONIC DMP-BDT168EG
3.91 / mēnesī
109,25 EUR 95.00 EUR
Produkta numurs: 20475276
Panasonic DMP-BDT185EG DVD/Blu-Ray player 3D Silver DMPBDT185EG
4.34 / mēnesī
121,44 EUR 105.60 EUR
Produkta numurs: 20463309
Panasonic DMP-BDT184EG DVD/Blu-Ray player 3D Black DMPBDT184EG
4.52 / mēnesī
126,50 EUR 110.00 EUR
Produkta numurs: 20552775
PANASONIC DMP-BDT180EG
4.6 / mēnesī
128,80 EUR 112.00 EUR
Produkta numurs: 20552776
PANASONIC DMP-BDT181EG
4.6 / mēnesī
128,80 EUR 112.00 EUR
Produkta numurs: 20416424
Panasonic DMP-BDT385EG DVD/Blu-Ray player 3D Silver DMPBDT385EG
5.82 / mēnesī
162,84 EUR 141.60 EUR
Produkta numurs: 20552778
PANASONIC DMP-BDT281EG
6.18 / mēnesī
172,85 EUR 150.30 EUR