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=2906)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: 20582397
Pioneer SE-CL501
13,00 EUR 11.30 EUR
Produkta numurs: 20582394
Pioneer SE-CL711
23,00 EUR 20.00 EUR
Produkta numurs: 20582396
SE-CL501T
24,61 EUR 21.40 EUR
Produkta numurs: 20582369
Pioneer SE-A611
26,45 EUR 23.00 EUR
Produkta numurs: 20582392
Pioneer DM-DV10
30,82 EUR 26.80 EUR
Produkta numurs: 20582374
Pioneer SE-MJ512-R
34,27 EUR 29.80 EUR
Produkta numurs: 20582395
Pioneer SE-CL522
34,39 EUR 29.90 EUR
Produkta numurs: 20582368
Pioneer SE-M521
34,50 EUR 30.00 EUR
Produkta numurs: 20582366
Pioneer SE-CL721
35,42 EUR 30.80 EUR
Produkta numurs: 20582373
Pioneer SE-MJ521-K
42,55 EUR 37.00 EUR
Produkta numurs: 20582367
Pioneer SE-CL331-H
44,28 EUR 38.50 EUR
Produkta numurs: 20582371
Pioneer SE-M531
44,85 EUR 39.00 EUR