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 |