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=3020)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: 20546033
Back Case 0,3 iPad Mini 4 transparent
6,33 EUR 5.50 EUR
Produkta numurs: 20598845
Back Case 0,3 iPad Mini 2/3 transparent
6,33 EUR 5.50 EUR
Produkta numurs: 20598840
Samsung Book Cover EF-BN510BW for Tablet N5100 Galaxy Note 8.0 White
6,90 EUR 6.00 EUR
Produkta numurs: 20598841
Samsung Book Cover EF-BN510BP for Tablet N5100 Galaxy Note 8.0 Pink
6,90 EUR 6.00 EUR
Produkta numurs: 20598842
Samsung Book Cover EF-BN510BG for Tablet N5100 Galaxy Note 8.0 Lemon
6,90 EUR 6.00 EUR
Produkta numurs: 20598843
Universal BOOK NEO Case for Tablets 7" DESIGN 1 VIOLET
8,63 EUR 7.50 EUR
Produkta numurs: 20598850
Universal BOOK Case for Tablets 10" DESIGN 1 GRAY
8,63 EUR 7.50 EUR
Produkta numurs: 20598852
Samsung Protective Cover EF-PT280CB for Galaxy TAB A 7.0" Black
8,63 EUR 7.50 EUR
Produkta numurs: 20598844
Universal BOOK NEO Case for Tablets 8,4" (TAB4) DESIGN 1 VIOLET
9,20 EUR 8.00 EUR
Produkta numurs: 20598846
Universal BOOK NEO Case for Tablets 8" DESIGN 1 BLACK
9,20 EUR 8.00 EUR
Produkta numurs: 20598848
Universal BOOK NEO Case for Tablets 9.7" DESIGN 1 BLACK
9,20 EUR 8.00 EUR
Produkta numurs: 20598849
Book Rotated Case SAMSUNG T330 GALAXY 8.0 TAB 4 BLACK
9,20 EUR 8.00 EUR