+ (t.id =
+ (SELECT tk.tax_id
+ FROM taxkeys tk
+ WHERE (tk.taxkey_id = a.taxkey) AND
+ ((CASE WHEN a.chart_id IN
+ (SELECT chart_id FROM taxkeys WHERE taxkey_id = a.taxkey)
+ THEN tk.chart_id = a.chart_id
+ ELSE 1 = 1
+ END)
+ OR (c.link LIKE '%tax%'))
+ AND (startdate <= a.transdate)
+ ORDER BY startdate DESC LIMIT 1))