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=207)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: 20350992
Connector barrel F LB0034 LIBOX LB0034
1,38 EUR 1.20 EUR
Produkta numurs: 20350989
Metal antenna plug F LB0035 LIBOX LB0035
1,50 EUR 1.30 EUR
Produkta numurs: 20353787
Antenna connector metal for F LB0033 LIBOX LB0033
1,61 EUR 1.40 EUR
Produkta numurs: 20353835
Cable Jack 3,5-Jack 3,5 1,5m HQ LB0025 LIBOX LB0025
2,65 EUR 2.30 EUR
Produkta numurs: 20353799
Aerial cable RG6 5m PCC05 LIBOX PCC05
2,88 EUR 2.50 EUR
Produkta numurs: 20353824
Cable USB-USB 1,8m LB0013 LIBOX LB0013
2,88 EUR 2.50 EUR
Produkta numurs: 20353830
Cable USB micro USB 1,8m LB0011 LIBOX LB0011
2,88 EUR 2.50 EUR
Produkta numurs: 20350993
Cable Jack 3,5-Jack 3,5 3,0m HQ LB0026 LIBOX LB0026
2,99 EUR 2.60 EUR
Produkta numurs: 20353820
USB extension cable wt.-gn. 1,8m LB0015 LIBOX LB0015
2,99 EUR 2.60 EUR
Produkta numurs: 20583332
TechniSat Metal angel connector 0000/3346
2,99 EUR 2.60 EUR
Produkta numurs: 20353785
Signal Splitter 2 WAYS Power Pass LB0037 LIBOX LB0037
3,11 EUR 2.70 EUR
Produkta numurs: 20363133
HAMA Puzzle Cable Wrap set of 2 00020565
3,11 EUR 2.70 EUR