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=13)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: 20597639
Vakoss PD-70 Peles paliktnis
1,15 EUR 1.00 EUR
Produkta numurs: 20598049
*Pele datora MUSOPTI-SU USB balta Gembird
1,73 EUR 1.50 EUR
Produkta numurs: 20099910
Extreme XM102W White 1000dpi Optiskā datorpele
2,30 EUR 2.00 EUR
Produkta numurs: 20099911
Extreme XM102G Green 1000dpi Optiskā datorpele
2,30 EUR 2.00 EUR
Produkta numurs: 20099912
Extreme XM102B Blue 1000dpi Optiskā datorpele
2,30 EUR 2.00 EUR
Produkta numurs: 20099913
Extreme XM102R Red 1000dpi Optiskā datorpele
2,30 EUR 2.00 EUR
Produkta numurs: 20583349
Extreme XM102K Black 1000dpi Optiskā datorpele
2,30 EUR 2.00 EUR
Produkta numurs: 20598194
*Pele datora GG GOA-6S(Aloha Splash)zila
2,65 EUR 2.30 EUR
Produkta numurs: 20453392
Pele datora USB melna 1000dpi Omega OM07VB
3,45 EUR 3.00 EUR
Produkta numurs: 20296896
DEFENDER Wired optical Сyber MB-560L 52560
3,68 EUR 3.20 EUR
Produkta numurs: 20346158
Mouse wired optical TRACER Neptun USB TRAMYS45906
3,80 EUR 3.30 EUR
Produkta numurs: 20352986
EXTREME XM102K CAMILLE - Wired USB Optical Mouse 3D | 1000 DPI | Black XM102K - 5901299903476
3,80 EUR 3.30 EUR