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=1721)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: 20147506
LogiLink Security Camera Dome Fake SC0202
15,07 EUR 13.10 EUR
Produkta numurs: 20194476
Incipio Wall Mount for Google Home GG-036-WHT
25,76 EUR 22.40 EUR
Produkta numurs: 20515276
Veho TA-1 4 Port USB VAA-200-TA1
38,07 EUR 33.10 EUR
Produkta numurs: 20199535
Nonda ZUS Car Key Finder ZUKFBKMCC
50,37 EUR 43.80 EUR
Produkta numurs: 20199552
Nonda ZUS Smart Car Charger ZU33BKRN
56,12 EUR 48.80 EUR
Produkta numurs: 20422505
Veho X-Lapse Time Lapse Accessory VCC-100-XL
56,12 EUR 48.80 EUR
Produkta numurs: 20199537
Nonda ZUS Universal HD Car Audio ZUMABKSAV
2.18 / mēnesī
61,07 EUR 53.10 EUR
Produkta numurs: 20295761
Noname Miele Toy Kitchen Petit Gourme 4009847090904
2.35 / mēnesī
65,67 EUR 57.10 EUR
Produkta numurs: 20316867
Noname Cars 3 Playset 30188
2.4 / mēnesī
67,16 EUR 58.40 EUR
Produkta numurs: 20421978
Noname Mercedes AMG GT3  Perf 1:14 207331
2.48 / mēnesī
69,23 EUR 60.20 EUR
Produkta numurs: 20295383
Noname Playmobil Swat Truck 4008789093608
2.86 / mēnesī
79,93 EUR 69.50 EUR
Produkta numurs: 20155333
Brennenstuhl Walkie Talkie PMR TRX 3500 1290940
2.88 / mēnesī
80,62 EUR 70.10 EUR