Faunistisch-Floristisches Informationsportal des Saarlandes und der Saar-Mosel-Region
There was an SQL error: FEHLER: Spalte »ttl2_term« existiert nicht LINE 35: ORDER BY "ttl2_term", t.taxonomic_sort_order asc, t.languag... ^ - SELECT t.id as "id", t.taxon_meaning_id as "taxon_meaning_id", t.taxon_list_id as "taxon_list_id", t.language_iso as "language_iso", t.language_iso='lat' as "latin", t.external_key as "taxnummer", case t.language_iso when 'lat' then '' || case t.preferred when 'f' THEN '  Syn: ' ELSE '' END ||replace(replace(t.taxon,' subsp. ',' subsp. '),' var. ',' var. ') || '' || coalesce(' ' || t.authority, '') else t.taxon end as "taxon", t.authority as "author", t.preferred_taxon as "preferred_taxon", t.preferred as "preferred", t.default_common_name as "default_common_name", t.taxon_rank as "rank", t.taxonomic_sort_order as "taxonomic_sort_order", t.family_taxon as "family_taxon", t.taxon_group as "taxon_group", t.taxon_status as "taxon_status", t.description as "description", ttl24.term as "ttl24_term", ttl29.term as "ttl29_term", CASE ttl28.term WHEN 'Besonders hohe Verantwortlichkeit' THEN '!!' WHEN 'Hohe Verantwortlichkeit' THEN '!' ELSE NULL END as "ttl28_term", lower(tr.short_name) as "rank_style", CASE ttl24.term WHEN '0' THEN 'au' WHEN '1' THEN 'va' WHEN '2' THEN 'sg' WHEN '3' THEN 'ge' WHEN '*' THEN 'un' ELSE ttl24.term END as "red_list_cat", '' AS toggle_column from cache_taxa_taxon_lists t left join taxon_ranks tr ON tr.id=t.taxon_rank_id left join taxa_taxon_list_attribute_values ttla24 ON ttla24.taxa_taxon_list_id=t.id AND ttla24.taxa_taxon_list_attribute_id=24 left join cache_termlists_terms ttl24 ON ttl24.id=ttla24.int_value left join taxa_taxon_list_attribute_values ttla28 ON ttla28.taxa_taxon_list_id=t.id AND ttla28.taxa_taxon_list_attribute_id=28 left join cache_termlists_terms ttl28 ON ttl28.id=ttla28.int_value left join taxa_taxon_list_attribute_values ttla29 ON ttla29.taxa_taxon_list_id=t.id AND ttla29.taxa_taxon_list_attribute_id=29 left join cache_termlists_terms ttl29 ON ttl29.id=ttla29.int_value where 1=1 AND t.language_iso='lat' AND t.taxon_list_id=38 ORDER BY "ttl2_term", t.taxonomic_sort_order asc, t.language_iso='lat' desc, preferred desc LIMIT 51