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=3023)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: 20599470
Forever Tempered Glass Samsung Galaxy Note PRO 12.2 P900
5,75 EUR 5.00 EUR
Produkta numurs: 20542083
Forever Tempered Glass Samsung Galaxy TAB PRO 8.4 (SM-T320 / SM-T325)
8,63 EUR 7.50 EUR
Produkta numurs: 20542106
Tempered Glass Screen Protector ipad mini
9,20 EUR 8.00 EUR
Produkta numurs: 20546073
Tempered Glass 9H PREMIUM HUAWEI MEDIA PAD T1 8.0 LTE
9,78 EUR 8.50 EUR
Produkta numurs: 20599484
3MK FlexibleGlass Samsung T825 Galaxy TAB S3
9,78 EUR 8.50 EUR
Produkta numurs: 20599467
Tempered Glass 9H Apple iPad Air/Air 2
10,35 EUR 9.00 EUR
Produkta numurs: 20599485
Tempered Glass 9H Apple iPad 2/3/4
10,35 EUR 9.00 EUR
Produkta numurs: 20542084
Forever Tempered Glass Samsung Galaxy TAB 4 10.1  (SM-T530)
10,93 EUR 9.50 EUR
Produkta numurs: 20542095
Forever Tempered Glass Samsung Galaxy TAB 3 10.1 (GT-P5200)
10,93 EUR 9.50 EUR
Produkta numurs: 20599466
Tempered Glass 9H iPad Pro 9,7"
10,93 EUR 9.50 EUR
Produkta numurs: 20599468
Tempered Glass SAMSUNG T235 GALAXY TAB 4 LTE (7.0")
10,93 EUR 9.50 EUR
Produkta numurs: 20599482
Tempered Glass Samsung T110 GALAXY TAB 3 LITE WIFI (7,0")
10,93 EUR 9.50 EUR