Vitis International Variety Catalogue ( VIVC )
JKI - Institut für Rebenzüchtung Geilweilerhof - Siebeldingen

More information is available via  http://www.vivc.de 


Database error : Invalid SQL: Select p.leitname, p.kenn_nr, p.verwendung_wine_grape, p.verwendung_table_grape, p.verwendung_raisin_grape, p.verwendung_rootstock, p.kenn_nr_e1, p.kenn_nr_e2, case when p.b_farbe = 'green' then 'BLANC' when p.b_farbe = 'grey' then 'GRIS' when p.b_farbe = 'black' then 'NOIR' when p.b_farbe = 'red' then 'ROUGE' when p.b_farbe = 'rose' then 'ROSE' else '' end AS b_farbe, p.kenn_nr, Concat(g.vitis_genus,' ', g.vitis_art,' ', g.autor_art) AS species, p.abstammung, p.landescode, l.land, Concat(l.land,' (',l.landescode,')') as country, z.zuechtername, p.kreuzungsjahr,p.selektionsjahr,p.zulassung,p.stempel,p.notiz,p.kategorie, Concat( if (p.verwendung_wine_grape = 'true', 'WINE-GRAPE' , ''), if (p.verwendung_table_grape = 'true', ' TABLE-GRAPE ' , ''), if (p.verwendung_raisin_grape = 'true', ' RAISIN-GRAPE ' , ''), if (p.verwendung_rootstock = 'true', ' ROOTSTOCK' , '') ) AS verwendung, case when p.samenausbildung = 'complete' then 'COMPLETE' when p.samenausbildung = 'rudimentary' then 'RUDIMENTARY' when p.samenausbildung = 'none' then 'NONE' else '' end AS samenausbildung, case when p.geschlecht = 'male' then 'MALE' when p.geschlecht = '1' then 'MALE' when p.geschlecht = 'female' then 'FEMALE' when p.geschlecht = '5' then 'FEMALE' when p.geschlecht = 'hermaphrodite' then 'HERMAPHRODITE' when p.geschlecht = '3' then 'HERMAPHRODITE' else '' end AS geschlecht from passport AS p left join gattung g on (g.gattung_id = p.gattung_id) left join land l on (l.landescode = p.landescode) left join zuechter z on (z.zuechter_id = p.zuechter_id) where p.kenn_nr <= 70000 and
MySQL error : 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 44)

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/www.eu-vitis.de/includes/dbMySql.inc.php on line 80

Search criteria : Utilization : 
Search result :     (  0  --  0  )

Back to search formPrevious page

|  First  |  Back  |  Next  |  Last  |  


Search result : 0

EU.Vitis - Copyright JKI  © 2007