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=198)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: 20507954
Kabatas radio SM 2000
7,71 EUR 6.70 EUR
Produkta numurs: 20339692
SENCOR Kabatas radiouztvērējs SRD 1100 B
10,01 EUR 8.70 EUR
Produkta numurs: 20146772
Leitz Sound Pen Holder 53630095
10,93 EUR 9.50 EUR
Produkta numurs: 20438429
FIRST Kabatas radio. AM/ FM uztvērējs. FA 2314 1 GR
12,88 EUR 11.20 EUR
Produkta numurs: 20502648
Muse M-030R Black, 2-band portable radio M-030R
14,61 EUR 12.70 EUR
Produkta numurs: 20513530
ADLER Pārnēsājams radio uztvērējs AD 1119
15,87 EUR 13.80 EUR
Produkta numurs: 20352634
Muse Sing-A-Long Tower M-1020 KDB Bluetooth, AUX in M-1020KDB
16,79 EUR 14.60 EUR
Produkta numurs: 20300844
Muse M-187CLG Dual Alarm Clock Radio M-187CLG
17,02 EUR 14.80 EUR
Produkta numurs: 20170765
Muse CR138 Projectiion Clock Radio CR138
18,17 EUR 15.80 EUR
Produkta numurs: 20374042
Muse M-167KDB Image, Alarm function, AUX in, Projection Clock Radio PLL M-167KDB
19,32 EUR 16.80 EUR
Produkta numurs: 20388214
Muse Portable Radio M-051RW White, AUX in M-051RW
20,59 EUR 17.90 EUR
Produkta numurs: 20458369
Muse M-051R Black, 2-band portable radio, M-051R
20,59 EUR 17.90 EUR