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=2929)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: 20098169
Active Watch MT856 MT856
17,48 EUR 15.20 EUR
Produkta numurs: 20166138
Denver BFH-15
19,78 EUR 17.20 EUR
Produkta numurs: 20297106
Denver BFH-240
19,90 EUR 17.30 EUR
Produkta numurs: 20178307
Sponge Move Black
20,70 EUR 18.00 EUR
Produkta numurs: 20600452
SMARTWATCH MA424N MA424N
20,70 EUR 18.00 EUR
Produkta numurs: 20363298
Medisana ViFit 79410
21,39 EUR 18.60 EUR
Produkta numurs: 20193195
Denver BFH-16 Blue
23,35 EUR 20.30 EUR
Produkta numurs: 20500169
OPASKA TOUCH GO OV-TOUCH GO
24,38 EUR 21.20 EUR
Produkta numurs: 20363297
Medisana ViFit With Bluetooth 79415
24,73 EUR 21.50 EUR
Produkta numurs: 20378143
Acme Activity tracker ACT101B Steps and distance monitoring, OLED, Blue, Bluetooth, ACT101B
25,07 EUR 21.80 EUR
Produkta numurs: 20378144
Acme Activity tracker ACT101R Steps and distance monitoring, OLED, Red, Bluetooth, ACT101R
25,07 EUR 21.80 EUR
Produkta numurs: 20386802
Acme Activity tracker ACT101 Steps and distance monitoring, OLED, Black, Bluetooth, ACT101
25,07 EUR 21.80 EUR