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 |