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=197)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: 20604124
Gembird SPK-103 Black, 2 W, Portable speakers, SPK-103
11,27 EUR 9.80 EUR
Produkta numurs: 20604122
Gembird SPK-103-W White, Portable Speaker, 2 W SPK-103-W
11,73 EUR 10.20 EUR
Produkta numurs: 20604123
Gembird SPK-103-B Blue, Portable speakers, 2 W SPK-103-B
11,73 EUR 10.20 EUR
Produkta numurs: 20602735
Energy Sistem Fabric Box 1+ Pocket 3 W, Portable, Wireless connection, Cherry, Bluetooth 446490
18,98 EUR 16.50 EUR
Produkta numurs: 20602739
Energy Sistem Fabric Box 1+ Pocket 3 W, Portable, Wireless connection, Grape, Bluetooth 446445
18,98 EUR 16.50 EUR
Produkta numurs: 20181124
Gembird Bluetooth speaker with LED light effects Bluetooth, Portable, Black SPK-BT-05
24,73 EUR 21.50 EUR
Produkta numurs: 20602736
Energy Sistem Fabric Box 1+ Pocket 3 W, Wireless connection, Kiwi, Bluetooth 446483
24,84 EUR 21.60 EUR
Produkta numurs: 20602737
Energy Sistem Fabric Box 1+ Pocket 3 W, Portable, Wireless connection, Blueberry, Bluetooth 446469
24,84 EUR 21.60 EUR
Produkta numurs: 20602717
Energy Sistem Music Box B2 6 W, Portable, Wireless connection, Mint, Bluetooth 426690
31,17 EUR 27.10 EUR
Produkta numurs: 20602754
Energy Sistem Earphones 1 In-ear/Ear-hook, Bluetooth, Wireless, Bluetooth, Red, Blue, Built-in microphone 428410
31,17 EUR 27.10 EUR
Produkta numurs: 20296192
Gembird Power bank Bluetooth speaker Grey SPK-BT-06-GR
32,66 EUR 28.40 EUR
Produkta numurs: 20604103
Gembird Speaker with powerbank function SPK-BT-06 Bluetooth, Portable, Wireless connection, Black SPK-BT-06
32,66 EUR 28.40 EUR