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=133)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: 20433814
Adapter SCART to 3x RCA OEM ADSCART3XRCA
0,12 EUR 0.10 EUR
Produkta numurs: 20525492
Msonic MM3610K MicroSD MP3 atskaņotājs melns
4,72 EUR 4.10 EUR
Produkta numurs: 20525493
Msonic MM3610B MicroSD MP3 atskaņotājs zils
4,72 EUR 4.10 EUR
Produkta numurs: 20525494
Msonic MM3610A MicroSD MP3 atskaņotājs sudraba
4,72 EUR 4.10 EUR
Produkta numurs: 20525495
Msonic MM3610P MicroSD MP3 atskaņotājs sarkans
4,72 EUR 4.10 EUR
Produkta numurs: 20361699
UGO MP3 player UMP-1023 (Micro SD) Yellow UMP-1023
4,83 EUR 4.20 EUR
Produkta numurs: 20577286
Esperanza EP124B Bluetooth, Handfree bezvadu ūdens izturīgs IPX4 skaļruņi, zils
6,10 EUR 5.30 EUR
Produkta numurs: 20586640
Esperanza EP124K Bluetooth, Handfree bezvadu ūdens izturīgs IPX4 skaļruņi, melns
6,10 EUR 5.30 EUR
Produkta numurs: 20586641
Esperanza EP124R Bluetooth, Handfree bezvadu ūdens izturīgs IPX4 skaļruņi, sarkans
6,10 EUR 5.30 EUR
Produkta numurs: 20589873
FM Transmitter T-01 LED USB+SD BULK
7,36 EUR 6.40 EUR
Produkta numurs: 20577284
Esperanza EP115B MicroSD MP3 Bluetooth + FM bezvadu skaļruņi, zils
7,94 EUR 6.90 EUR
Produkta numurs: 20577285
Esperanza EP115C MicroSD MP3 Bluetooth + FM bezvadu skaļruņi, sarkans
7,94 EUR 6.90 EUR