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=2191)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: 20331778
Sharp LC-24CHF4012E  24" (60 cm), HD Ready, 1366 x 768 pixels, DVB-T/C/S, Black LC-24CHF4012E
5.13 / mēnesī
143,41 EUR 124.70 EUR
Produkta numurs: 20309567
Philips 22PFS5303/12 22" (55 cm), Full HD Ultra Slim LED, 1920 x 1080 pixels, DVB T/C/T2/T2-HD/S/S2, Black 22PFS5303/12
5.23 / mēnesī
146,17 EUR 127.10 EUR
Produkta numurs: 20339745
Muse Portable LCD TV M-335TV 10″ (26 cm), TFT LCD, 800 x 400 pixels, Black M-335TV
5.37 / mēnesī
150,19 EUR 130.60 EUR
Produkta numurs: 20165225
Sharp LC-32HI3122E 32" (81 cm), HD Ready, 1368 x 720 pixels, DVB-T/T2/C/S/S2, Black LC-32HI3122E
6.58 / mēnesī
184,12 EUR 160.10 EUR
Produkta numurs: 20311840
Philips 32PHS4503/12 32" (80 cm) LED TV Philips 32PHS4503/12
6.69 / mēnesī
186,99 EUR 162.60 EUR
Produkta numurs: 20299270
Sharp LC-32HI5012E 32" (82 cm) HD Ready, Smart TV Sharp LC-32HI5012E
7.64 / mēnesī
213,67 EUR 185.80 EUR
Produkta numurs: 20094270
Philips 32PFS5603/12 32" (81 cm), Full HD Ultra Slim LED, 1920 x 1080 pixels, DVB T/C/T2/T2-HD/S/S2, White 32PFS5603/12
8.24 / mēnesī
230,58 EUR 200.50 EUR
Produkta numurs: 20147386
Philips 32PFS5803/12 32" (81 cm), Full HD Ultra Slim LED, 1920 x 1080 pixels, DVB T/C/T2/T2-HD/S/S2, Black 32PFS5803/12
8.84 / mēnesī
247,37 EUR 215.10 EUR
Produkta numurs: 20600441
Sharp LC-40FI3522E 40" (102 cm) Full HD TV LC-40FI3522E
8.9 / mēnesī
248,86 EUR 216.40 EUR
Produkta numurs: 20096750
LG 32LK6100PLB 32" (81 cm), Smart TV, Full HD LED, 1920 x 1080 pixels, Wi-Fi, DVB-T2/C/S2, Black 32LK6100PLB
9.85 / mēnesī
275,54 EUR 239.60 EUR
Produkta numurs: 20299269
Sharp LC-40FI5442E 40" (102 cm) FullHD Smart TV LC-40FI5442E
10.1 / mēnesī
282,56 EUR 245.70 EUR
Produkta numurs: 20094269
Philips 43PFS5503/12 43" (108 cm), Full HD  Slim LED, 1920 x 1080 pixels, DVB T/C/T2/T2-HD/S/S2, Black 43PFS5503/12
10.65 / mēnesī
297,97 EUR 259.10 EUR