X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FForm.pm;h=7cea6a2128851fd67afd1878e24bcbe1f2c851c0;hb=9fbc6ff48867b6125b6ae34520c399376573f8dc;hp=4c8f3d702c583dabccd89cd33391dcefad3dbb3f;hpb=77807bf531a9c3f945b2de1fc970439be5e95e70;p=kivitendo-erp.git diff --git a/SL/Form.pm b/SL/Form.pm index 4c8f3d702..7cea6a212 100644 --- a/SL/Form.pm +++ b/SL/Form.pm @@ -2663,13 +2663,6 @@ sub create_links { } # now get the account numbers -# $query = qq|SELECT c.accno, c.description, c.link, c.taxkey_id, tk.tax_id -# FROM chart c, taxkeys tk -# WHERE (c.link LIKE ?) AND (c.id = tk.chart_id) AND tk.id = -# (SELECT id FROM taxkeys WHERE (taxkeys.chart_id = c.id) AND (startdate <= $transdate) ORDER BY startdate DESC LIMIT 1) -# ORDER BY c.accno|; - -# same query as above, but without expensive subquery for each row. about 80% faster $query = qq| SELECT c.accno, c.description, c.link, c.taxkey_id, tk2.tax_id FROM chart c