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=3072)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: 20546018
POWER BANK ATX PB01 2600mAh, black
5,75 EUR 5.00 EUR
Produkta numurs: 20598275
POWER BANK ATX PB01 2600mAh, green
5,75 EUR 5.00 EUR
Produkta numurs: 20598281
POWER BANK ATX PB01 2600mAh, blue
5,75 EUR 5.00 EUR
Produkta numurs: 20598288
POWER BANK ATX PB01 2600mAh, yellow
5,75 EUR 5.00 EUR
Produkta numurs: 20598293
Original Power Bank NOKIA DC-18 WHITE 1720mAh BLISTER
10,35 EUR 9.00 EUR
Produkta numurs: 20598294
Power bank Microsoft DC-32 5200 mAh black
17,25 EUR 15.00 EUR
Produkta numurs: 20598274
VENNUS Power Bank 6000mAh DP662 BLACK
17,83 EUR 15.50 EUR
Produkta numurs: 20598282
VENNUS Power Bank 6000mAh DP662 BEIGE
17,83 EUR 15.50 EUR
Produkta numurs: 20598286
VENNUS Power Bank 6000mAh DP662 MINT
17,83 EUR 15.50 EUR
Produkta numurs: 20598276
Power Bank 8600mAh
18,98 EUR 16.50 EUR
Produkta numurs: 20598277
Power Bank Solar 10000mAh waterproof red/black
18,98 EUR 16.50 EUR
Produkta numurs: 20598285
REMAX Power Bank - Linon Pro Power - 10000mAh RPP-53 WHITE
19,32 EUR 16.80 EUR