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=1647)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: 20333561
Bvlgari Man (EDT,Men,5ml)
7,13 EUR 6.20 EUR
Produkta numurs: 20138221
Tigi Catwalk Session Series Salt Spray (Woman,270ml) (Damaged Box)
8,74 EUR 7.60 EUR
Produkta numurs: 20360093
Ducati Trace Me (EDT,Men,100ml)
10,47 EUR 9.10 EUR
Produkta numurs: 20339289
Jil Sander Ultrasense (EDT,Men,40ml)
14,26 EUR 12.40 EUR
Produkta numurs: 20360091
Esprit Man (EDT,Men,30ml)
14,61 EUR 12.70 EUR
Produkta numurs: 20331495
Ferrari Scuderia Red (EDT,Men,TESTER,125ml)
14,95 EUR 13.00 EUR
Produkta numurs: 20331496
Ferrari Scuderia Black (EDT,Men,TESTER,125ml)
14,95 EUR 13.00 EUR
Produkta numurs: 20371963
Ferrari Scuderia Club (EDT,Men,125ml)
18,17 EUR 15.80 EUR
Produkta numurs: 20360130
Nino Cerruti Cerruti 1881 (EDT,Men,100ml)
18,98 EUR 16.50 EUR
Produkta numurs: 20383005
James Bond 007 Seven (EDT,Men,50ml)
20,13 EUR 17.50 EUR
Produkta numurs: 20372121
Burberry Weekend for Men (EDT,Men,TESTER,100ml)
22,66 EUR 19.70 EUR
Produkta numurs: 20373282
Burberry Brit (EDT,Men,TESTER,100ml)
23,46 EUR 20.40 EUR