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=2473)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: 20153410
PSV Virtua Tennis 4 World Tour Edition
14,84 EUR 12.90 EUR
Produkta numurs: 20331336
PSV Xblaze Code: Embryo
14,84 EUR 12.90 EUR
Produkta numurs: 20571673
PSV LEGO The Hobbit
22,43 EUR 19.50 EUR
Produkta numurs: 20154478
PSV FIFA Football
22,89 EUR 19.90 EUR
Produkta numurs: 20377228
PSV Looney Tunes Galactic Sports
22,89 EUR 19.90 EUR
Produkta numurs: 20505167
PSV LEGO Movie: Videogame
22,89 EUR 19.90 EUR
Produkta numurs: 20305089
PSV Toukiden 2
23,81 EUR 20.70 EUR
Produkta numurs: 20368560
PSV LEGO Harry Potter Years 5-7
23,81 EUR 20.70 EUR
Produkta numurs: 20418793
PSV LEGO Marvel Super Heroes: Universe in Peril
23,81 EUR 20.70 EUR
Produkta numurs: 20457913
PSV Freedom Wars
23,81 EUR 20.70 EUR
Produkta numurs: 20500193
PSV LEGO Ninjago: Nindroids
23,81 EUR 20.70 EUR
Produkta numurs: 20511561
PSV Sonic and All-Stars Racing: Transformed
23,81 EUR 20.70 EUR