From 9fbc6ff48867b6125b6ae34520c399376573f8dc Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 11 Jan 2017 13:40:26 +0100 Subject: [PATCH] =?utf8?q?Form::create=5Flinks:=20=C3=BCberfl=C3=BCssige?= =?utf8?q?=20Kommentare=20entfernt?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/Form.pm | 7 ------- 1 file changed, 7 deletions(-) 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 -- 2.20.1