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=2976)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: 20439475
SAMSUNG Power jack, SAMSUNG RV510
4,95 EUR 4.30 EUR
Produkta numurs: 20439473
SAMSUNG Power jack, SAMSUNG NP-X120
5,52 EUR 4.80 EUR
Produkta numurs: 20439485
SAMSUNG Power jack, SAMSUNG NP 700Z3A Series
5,52 EUR 4.80 EUR
Produkta numurs: 20426147
Qoltec Battery for iPhone 5G/5 | 1440mAh 52034
7,71 EUR 6.70 EUR
Produkta numurs: 20439472
SAMSUNG Power jack with cable, SAMSUNG N128, NP-N128, NP-X120, X120, N140
9,78 EUR 8.50 EUR
Produkta numurs: 20439474
SAMSUNG Power jack with cable, SAMSUNG NP-N128,NP-X120, NP-N140
9,78 EUR 8.50 EUR
Produkta numurs: 20439477
SAMSUNG Power jack with cable, SAMSUNG NP-X420
9,78 EUR 8.50 EUR
Produkta numurs: 20439478
SAMSUNG Power jack with cable, SAMSUNG NP-N130, NP-N135
9,78 EUR 8.50 EUR
Produkta numurs: 20439479
SAMSUNG Power jack with cable, SAMSUNG NP-N310, N310 10" Laptop
9,78 EUR 8.50 EUR
Produkta numurs: 20439480
SAMSUNG Power jack with cable, SAMSUNG NP-N135, NP-N135 NP-N140
9,78 EUR 8.50 EUR
Produkta numurs: 20439482
SAMSUNG Power jack with cable, SAMSUNG NP-R518,NP-R519
9,78 EUR 8.50 EUR
Produkta numurs: 20439483
SAMSUNG Power jack with cable, SAMSUNG 900X
9,78 EUR 8.50 EUR