Use (crop name)


Database error : Invalid SQL: Select Concat(g.vitis_genus,' ',g.vitis_art,' ',g.autor_art) as species, p.leitname, p.kenn_nr, p.landescode, l.land, a.acc_leitname, a.accenumb, a.stempel as astempel, z.zuechtername, g.subtaxa, g.subtauthor, s.sampstat, s.storage, s.collnumb, s.collcode_id, s.landescode as s_landescode, s.collsite, s.longitude, s.elevation, s.collsrc, s.donornumb, s.colldate, s.collsrc, s.donornumb, s.othernumb, s.duplsite_id, s.remarks, s.acceurl, w.wiews_code, p.b_farbe as pb_farbe, p.abstammung, p.kreuzungsjahr, p.selektionsjahr, p.zulassung, p.verwendung_wine_grape, p.verwendung_table_grape, p.verwendung_raisin_grape, p.verwendung_rootstock, p.verwendung_ornamental_grape, p.verwendung_wild_grape, case when p.b_farbe = 'green' then 'GREEN' when p.b_farbe = 'grey' then 'GREY' when p.b_farbe = 'rose' then 'ROSE' when p.b_farbe = 'red' then 'RED' when p.b_farbe = 'black' then 'BLACK' when p.b_farbe = 'green-grey' then 'GREEN-GREY' when p.b_farbe = 'grey-rose' then 'GREY-ROSE' when p.b_farbe = 'green-black' then 'GREEN-BLACK' when p.b_farbe = 'black-red' then 'BLACK-RED' when p.b_farbe = 'black-grey' then 'BLACK-GREY' when p.b_farbe = 'green-red' then 'GREEN-RED' when p.b_farbe = 'red-violet' then 'RED-VIOLET' when p.b_farbe = 'green-rose' then 'GREEN-ROSE' else '' end AS b_farbe, 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 ' , ''), if (p.verwendung_ornamental_grape = 'true', ' ORNAMENTAL-GRAPE ' , ''), if (p.verwendung_wild_grape = 'true', ' WILD-GRAPE' , '') ) AS verwendung from akzessionen as a left outer join passport as p on p.kenn_nr = a.kenn_nr left outer join gattung as g using(gattung_id) left outer join wiews_code as w on w.wiews_id = a.wiews_id left outer join zuechter as z on z.zuechter_id = p.zuechter_id left outer join land as l on p.landescode = l.landescode left outer join sammlung as s on s.accenumb = a.accenumb where p.kenn_nr >= 200000 and a.accenumb not like 'ARCHIV%' 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 41)

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 :
Search result :     (  0  --  0  )

Back to search formPrevious page

|  First  |  Back  |  Next  |  Last  |  


Search result : 0

EU.Vitis - Copyright JKI  © 2007