- $query = qq|SELECT c.id, c.accno, c.description, c.charttype, c.gifi_accno,
- c.category, c.link
- FROM chart c
- ORDER BY accno|;
+ $query = qq|
+
+ SELECT c.id,
+ c.accno,
+ c.description,
+ c.charttype,
+ c.gifi_accno,
+ c.category,
+ c.link,
+ c.pos_ustva,
+ c.pos_bwa,
+ c.pos_bilanz,
+ c.pos_eur,
+ c.valid_from,
+ c.datevautomatik,
+-- ( SELECT comma(taxkey_id)
+-- FROM taxkeys tk
+-- WHERE tk.chart_id = c.id
+-- AND c.taxkey_id = tk.taxkey_id
+-- ORDER BY c.id
+-- ) AS taxkey_id,
+
+ ( SELECT comma(taxkey)
+ FROM tax tx
+ WHERE tx.id in (
+ SELECT tk.tax_id from taxkeys tk
+ WHERE tk.chart_id = c.id
+ )
+ ORDER BY c.accno
+ ) AS taxkey,
+
+ ( SELECT comma(taxdescription)
+ FROM tax tx
+ WHERE tx.id in (
+ SELECT tk.tax_id from taxkeys tk
+ WHERE tk.chart_id = c.id
+ )
+ ORDER BY c.accno
+ ) AS taxdescription,
+
+ ( SELECT comma(taxnumber)
+ FROM tax tx
+ WHERE tx.id in (
+ SELECT tk.tax_id from taxkeys tk
+ WHERE tk.chart_id = c.id
+ )
+ ORDER BY c.accno
+ ) AS taxaccount,
+
+ ( SELECT comma(tk.pos_ustva)
+ FROM taxkeys tk
+ WHERE tk.chart_id = c.id
+ AND c.taxkey_id = tk.taxkey_id
+ ORDER BY c.id
+ ) AS tk_ustva,
+
+ ( SELECT comma(startdate)
+ FROM taxkeys tk
+ WHERE tk.chart_id = c.id
+ AND c.taxkey_id = tk.taxkey_id
+ ORDER BY c.id
+ ) AS startdate,
+
+ ( SELECT accno
+ FROM chart c2
+ WHERE c2.id = c.id
+ ) AS new_account
+ FROM chart c
+ ORDER BY accno
+ |;
+