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=1715)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: 20473899
DeTeWe Outdoor 4000 two-way radio 8 channels 446 MHz Black,Orange 208092
33,70 EUR 29.30 EUR
Produkta numurs: 20415465
Motorola TLKR-T41 two-way radio 8 channels 446 MHz Green 188042
38,41 EUR 33.40 EUR
Produkta numurs: 20572302
Motorola TLKR-T41 two-way radio 8 channels 446 MHz 188036
38,41 EUR 33.40 EUR
Produkta numurs: 20573050
Motorola TLKR-T41 two-way radio 8 channels 446 MHz 188035
38,41 EUR 33.40 EUR
Produkta numurs: 20573340
Motorola TLKR T41 two-way radio 8 channels 446 MHz Pink 188041
38,41 EUR 33.40 EUR
Produkta numurs: 20573712
Motorola T40 Walkie Talkie two-way radio 8 channels 0.0125 MHz Black,Red 188028
38,41 EUR 33.40 EUR
Produkta numurs: 20476727
Motorola T41 short-wave radio, 4km, black-blue P14MAA03A1BH
39,22 EUR 34.10 EUR
Produkta numurs: 20500935
Motorola T40 short-wave radio, 4km, black-red P14MAA03A1BB
39,22 EUR 34.10 EUR
Produkta numurs: 20476726
Motorola T41 short-wave radio, 4km, Pink MotoT41pink
39,68 EUR 34.50 EUR
Produkta numurs: 20502106
Motorola T41 short-wave radio, 4km, black-orange P14MAA03A1BJ
39,68 EUR 34.50 EUR
Produkta numurs: 20577483
Audioline PMR 23 901028 901028
41,63 EUR 36.20 EUR
Produkta numurs: 20159631
Motorola T42 short-wave radio, 4km, Blue T42Blue
42,21 EUR 36.70 EUR