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=199)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: 20343038
Denver DM-24
18,86 EUR 16.40 EUR
Produkta numurs: 20343037
Denver DM-25C
20,70 EUR 18.00 EUR
Produkta numurs: 20297085
Denver DTB-133
23,12 EUR 20.10 EUR
Produkta numurs: 20166098
Denver DTB-138
28,29 EUR 24.60 EUR
Produkta numurs: 20343036
Denver DMP-389
29,67 EUR 25.80 EUR
Produkta numurs: 20360157
Denver DTB-136H UK/DE/ES/HR/SI/IT
32,66 EUR 28.40 EUR
Produkta numurs: 20150959
Vivolink IR kit for VL120004 VL120004 IR KIT
43,01 EUR 37.40 EUR
Produkta numurs: 20297095
Denver VPL-118 brown
49,34 EUR 42.90 EUR
Produkta numurs: 20297096
Denver VPL-118 red
49,34 EUR 42.90 EUR
Produkta numurs: 20297097
Denver VPL-118 black
49,34 EUR 42.90 EUR
Produkta numurs: 20342746
Denver VPL-120 Blue
51,98 EUR 45.20 EUR
Produkta numurs: 20374283
Gramofon z odtwarzaczem kaset magnetofonowych CR1154 CR1154
55,32 EUR 48.10 EUR