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=3024)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: 20599554
Screen Protector Exclusive Line IPAD MINI 3
2,88 EUR 2.50 EUR
Produkta numurs: 20599555
Screen Protector Exclusive Line IPAD MINI 2
2,88 EUR 2.50 EUR
Produkta numurs: 20599556
Screen Protector Exclusive Line IPAD MINI
2,88 EUR 2.50 EUR
Produkta numurs: 20599546
Screen Protector Exclusive Line SAMSUNG T900 GALAXY TAB PRO (12.2")
3,22 EUR 2.80 EUR
Produkta numurs: 20599547
Screen Protector Exclusive Line SAMSUNG T705 GALAXY TAB S (8,4")
3,22 EUR 2.80 EUR
Produkta numurs: 20599548
Screen Protector Exclusive Line SAMSUNG T530 GALAXY TAB 4 WIFI (10.1")
3,22 EUR 2.80 EUR
Produkta numurs: 20599549
Screen Protector Exclusive Line SAMSUNG T520 GALAXY TAB PRO (10.1")
3,22 EUR 2.80 EUR
Produkta numurs: 20599550
Screen Protector Exclusive Line SAMSUNG T320 GALAXY TAB PRO (8.4")
3,22 EUR 2.80 EUR
Produkta numurs: 20599551
Screen Protector Exclusive Line SAMSUNG T311 GALAXY TAB 3 (8.0")
3,22 EUR 2.80 EUR
Produkta numurs: 20599552
Screen Protector Exclusive Line SAMSUNG T230 GALAXY TAB 4 WIFI (7.0")
3,22 EUR 2.80 EUR
Produkta numurs: 20599553
Screen Protector Exclusive Line SAMSUNG T210 GALAXY TAB 3 (7.0")
3,22 EUR 2.80 EUR
Produkta numurs: 20546011
SCREEN PROTECTOR SONY Z TABLET
3,45 EUR 3.00 EUR