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=415)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: 20476802
FRENDO Binoculars Compact, 8 x, 21 mm 701701
22,08 EUR 19.20 EUR
Produkta numurs: 20473164
Bresser Optics 6933000 microscope 100x 6933000
23,69 EUR 20.60 EUR
Produkta numurs: 20503047
Lornetka BRAUN 10x25 czarna  braun10x25cz
23,81 EUR 20.70 EUR
Produkta numurs: 20500486
Lornetka 10x25 tytan braun10x25ty
26,91 EUR 23.40 EUR
Produkta numurs: 20502950
71232 LORNETKA UPCLOSE G2 10X25 ROOF 150674
28,18 EUR 24.50 EUR
Produkta numurs: 20503798
Lornetka 7x50 braun7x50
43,47 EUR 37.80 EUR
Produkta numurs: 20503397
Lornetka 10x50 braun10x50
43,93 EUR 38.20 EUR
Produkta numurs: 20463195
Binoklis Hama 00002804
45,66 EUR 39.70 EUR
Produkta numurs: 20473160
Bresser Optics 8851300CRG000 microscope Optical microscope 640x 8851300CRG000
46,35 EUR 40.30 EUR
Produkta numurs: 20151143
<span>Binoklis Bright 7x50 Focus</span> 005434
45,99 EUR 39.99 EUR
Produkta numurs: 20177565
45,99 EUR 39.99 EUR
Produkta numurs: 20416558
Bresser Optics National Geographic 40-640x Optical microscope 9119501
47,96 EUR 41.70 EUR