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=2986)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: 20600301
HP L1910 19 INCH TFT Monitor Silver/Black (1280x1024)/TI/VGA/VESA Refurbished GS918AT
44,28 EUR 38.50 EUR
Produkta numurs: 20600438
Monitor HP L1906 19'' LCD VGA 5:4 (1280x1024)/TI/VGA/VESA  Refurbished 2000519R4 / PX850A
44,28 EUR 38.50 EUR
Produkta numurs: 20600300
Monitor HP L1950G 19''  Rotaiting (1280x1024)/HA/TI/SW/PI/VGA/DVI-D/HDCP/ Refurb 2116610R4/ KR145AT
52,90 EUR 46.00 EUR
Produkta numurs: 20600439
HP LCD 19'' LE1901wi 16:10 (1440x900)/TI/SW/Integr HP Quick Release Black Refurb 2124380R4 / NP447AA
52,90 EUR 46.00 EUR
Produkta numurs: 20600299
HP Monitor LA1905wg 19'' TFT 16:10 (1440x900)/HA/TI/SW/PI/VGA/DVI-D/DP/VESA Refu 2124944R4 / NM360AT
2.2 / mēnesī
61,64 EUR 53.60 EUR
Produkta numurs: 20327782
Monitor HP LA1951G 19'' LCD VGA DVI DP 1000:1 USB 1280 x 1024  Refurbished EM890AT
2.45 / mēnesī
68,54 EUR 59.60 EUR
Produkta numurs: 20196967
HP LCD EliteDisplay E201 20'' LED TN 16:9 5ms 1000:1 VGA DVI DisplayPort Refurb C9V73AA
3.03 / mēnesī
84,87 EUR 73.80 EUR
Produkta numurs: 20296704
Monitor Dell U2212H 21,5'' FHD IPS 16:9  DVI-D/VGA/DP/ 5xUSB Black Refurbished U2212HMC
3.06 / mēnesī
85,56 EUR 74.40 EUR
Produkta numurs: 20197101
Monitor HP Z22i 21,5'' LCD TN 16:9 VGA DVI-D 1920x1080 Black  Refurbished D7Q14A4
3.76 / mēnesī
105,23 EUR 91.50 EUR
Produkta numurs: 20295091
HP LCD 24'' E241i FHD IPS 16:10 8ms 1000:1 VGA DVI-D DisplayPort USB Refurbished F0W81AA
4.98 / mēnesī
139,27 EUR 121.10 EUR