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=2182)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: 20445862
Lion 20"
21,05 EUR 18.30 EUR
Produkta numurs: 20436878
Buffy Junior 2017 lilac
23,58 EUR 20.50 EUR
Produkta numurs: 20436879
Buffy Junior 2017 black
23,58 EUR 20.50 EUR
Produkta numurs: 20436891
Buffy Junior 2017 orange
23,58 EUR 20.50 EUR
Produkta numurs: 20436897
Street Boss D
29,90 EUR 26.00 EUR
Produkta numurs: 20190563
Razor Jetts Electric Heel Wheels  Purple 25073250
31,40 EUR 27.30 EUR
Produkta numurs: 20445807
City A
37,61 EUR 32.70 EUR
Produkta numurs: 20445878
Super People 31''
39,68 EUR 34.50 EUR
Produkta numurs: 20190555
Razor S Scooter - Red 13073058
44,05 EUR 38.30 EUR
Produkta numurs: 20297565
Razor S Scooter - Green 13073031
44,05 EUR 38.30 EUR
Produkta numurs: 20297566
Razor A125 Scooter - Red 13010360
44,05 EUR 38.30 EUR
Produkta numurs: 20600244
Razor S Scooter - Pink 13073051
44,05 EUR 38.30 EUR