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=47)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: 20183404
Kaspersky Antivirus Renew Atjaunošanas licence 1 gads 1 datoram KL1171XUAFR
11,85 EUR 10.30 EUR
Produkta numurs: 20192566
Trend Micro WD1600AAJB TICIWWM3XLIULNOEM
11,96 EUR 10.40 EUR
Produkta numurs: 20183390
Kaspersky Antivirus Base Pamata licence 1 gads 1 datoram KL1171XUAFS
14,84 EUR 12.90 EUR
Produkta numurs: 20183445
Kaspersky Antivirus Renew Atjaunošanas licence 1 gads 2 datoriem KL1171XUBFR
14,84 EUR 12.90 EUR
Produkta numurs: 20189260
AVG Screenshot Reader 105010022099
15,07 EUR 13.10 EUR
Produkta numurs: 20153375
Kaspersky Internet Security for Android 1 Gerät (2019) KL1091G5AFS-9 KL1091G5AFS-9
16,68 EUR 14.50 EUR
Produkta numurs: 20135222
ESD ABBYY Screenshot Reader ESD 105010022099 105010022099
18,29 EUR 15.90 EUR
Produkta numurs: 20183330
Kaspersky Internet Security Atjaunošanas licence 1 gads 1 datoram KL1941XUAFR
18,52 EUR 16.10 EUR
Produkta numurs: 20183372
Kaspersky Antivirus Base Pamata licence 1 gads 2 datoriem KL1171XUBFS
18,52 EUR 16.10 EUR
Produkta numurs: 20547231
KASPERSKY ESD IS for Android 2U 1Y (DE) KL1091GDBFS
18,63 EUR 16.20 EUR
Produkta numurs: 20189891
BullGuard Internet Security 1-Device BIS1Y1DEV OEM
20,59 EUR 17.90 EUR
Produkta numurs: 20189894
Trend Micro Antivirus Plus 1-Desktop TICBWWM3XLIUZN
20,59 EUR 17.90 EUR