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=37)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: 20360846
Denver ACT-1303 yellow
31,28 EUR 27.20 EUR
Produkta numurs: 20134478
Denver ACT-1015
31,40 EUR 27.30 EUR
Produkta numurs: 20372744
Denver ACT-1301 black
32,89 EUR 28.60 EUR
Produkta numurs: 20193196
Denver ACT-5050W
34,16 EUR 29.70 EUR
Produkta numurs: 20351548
Panox Champion
38,41 EUR 33.40 EUR
Produkta numurs: 20372746
Denver AC-5000W MK2 silver
44,39 EUR 38.60 EUR
Produkta numurs: 20393953
Gembird Full HD WiFi action camera with waterproof case ACAM-003 ACAM-003
51,98 EUR 45.20 EUR
Produkta numurs: 20393952
Gembird Full HD waterproof action camera with wifi ACAM-W-01
52,79 EUR 45.90 EUR
Produkta numurs: 20372748
Denver ACT-5020TWC
52,90 EUR 46.00 EUR
Produkta numurs: 20372740
Denver ACT-5040W black
53,36 EUR 46.40 EUR
Produkta numurs: 20179221
Denver WCT-5001
54,40 EUR 47.30 EUR
Produkta numurs: 20372750
Denver ACK-8058W black
55,20 EUR 48.00 EUR