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, p.link_to_kenn_nr,
a.acc_leitname, a.accenumb, a.stempel as astempel, z.zuechtername,
a.acqdate, a.donor_wiews_id, w.curator,
s.subtaxa, s.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,
ssr.vvs2codedallele1, ssr.vvs2codedallele2,
ssr.vvmd5codedallele1, ssr.vvmd5codedallele2,
ssr.vvmd7codedallele1, ssr.vvmd7codedallele2,
ssr.vvmd27codedallele1, ssr.vvmd27codedallele2,
ssr.vrzag62codedallele1, ssr.vrzag62codedallele2,
ssr.vrzag79codedallele1, ssr.vrzag79codedallele2,
ssr.vvmd25codedallele1, ssr.vvmd25codedallele2,
ssr.vvmd28codedallele1, ssr.vvmd28codedallele2,
ssr.vvmd32codedallele1, ssr.vvmd32codedallele2
from eva_sample as esam
inner join akzessionen as a on a.akzession_id = esam.eva_sample_PKValue
inner join eva_analysis_ssrmarker as ssr on ssr.eva_analysis_Code = esam.eva_analysis_Code
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 esam.eva_experiment_Code = 'ssr-marker' and esam.eva_sample_PKValue = '4630' MySQL error : 1054 (Unknown column 's.subtaxa' in 'field list')
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
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/www.eu-vitis.de/includes/dbMySql.inc.php on line 59
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/www.eu-vitis.de/includes/dbMySql.inc.php on line 65