Passport data


Back to search formPrevious page

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_ws(' ',g.vitis_genus,g.vitis_art,g.autor_art,subtaxa,subtauthor) as species, -- 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,z.zuechter_id, 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,geschmack,chlorotyp 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 >= 1 and p.kenn_nr = '1668'
MySQL error : 1146 (Table 'gbvitis.passport' doesn't exist)
State : session halted