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=8)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: 20345932
Fractal Design PSU Cord CORD-IN2B-EU CORD-IN2B-EU
2,88 EUR 2.50 EUR
Produkta numurs: 20097530
SilverStone Fan grille and filter kit SST-FF122B Black, 120 x 120 x 3 mm SST-FF122B
4,49 EUR 3.90 EUR
Produkta numurs: 20166051
SilverStone Fan grille and filter kit SST-FF141B Black, 140 x 140 x 3 mm SST-FF141B
4,49 EUR 3.90 EUR
Produkta numurs: 20097535
SilverStone Fan grille SST-FF121B Black, 120 x 120 x 4.68 mm SST-FF121B
4,72 EUR 4.10 EUR
Produkta numurs: 20301823
Genesis Fan Case/PSU HYDRION 120 WHITE; LED; 120MM NGF-1169
5,75 EUR 5.00 EUR
Produkta numurs: 20301824
Genesis Fan Case/PSU HYDRION 120 GREEN; LED; 120MM NGF-1168
5,75 EUR 5.00 EUR
Produkta numurs: 20301825
Genesis Fan Case/PSU HYDRION 120 Blue; LED; 120MM NGF-1167
5,75 EUR 5.00 EUR
Produkta numurs: 20301826
Genesis Fan Case/PSU HYDRION 120 RED; LED; 120MM NGF-1166
5,75 EUR 5.00 EUR
Produkta numurs: 20097518
SilverStone Fan filter SST-FF123B 120 x 120 x 1.5 mm SST-FF123B
7,02 EUR 6.10 EUR
Produkta numurs: 20155886
Gembird ATX case, black, ''Fornax 200'' CCC-FC-02-BK
11,62 EUR 10.10 EUR
Produkta numurs: 20137238
Deepcool Motherboard Controlled RGB LED Strip RGB 200 EX DP-LED-RGB200EX
11,73 EUR 10.20 EUR
Produkta numurs: 20142857
be quiet! HDD slot cover for Dark Base 900 / Pure Base 600 cases BGA07
12,19 EUR 10.60 EUR