There was an SQL error: ERROR: column "ttl2_term" does not exist
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