<commit_before>SELECT t.FOLLOWUPID,
       t.PAYEENAME,
       t.TRANSDATE,
       t.TRANSAMOUNT,
       t.TRANSAMOUNT * IFNULL(CH.CURRVALUE, c.BASECONVRATE) AS BaseAmount,
       c.PFX_SYMBOL,
       c.SFX_SYMBOL,
       (
           SELECT inf.infovalue
             FROM infotable_V1 AS inf
            WHERE inf.infoname = 'USER_COLOR' || CAST (t.followupid AS TEXT)
       )
       AS FOLLOWCOLOR,
t.transid as transid
  FROM (
           SELECT  (CASE WHEN c1.TRANSCODE = 'Transfer' THEN ' < ' ELSE '' END) || p.PAYEENAME AS PAYEENAME,
                  c1.TRANSDATE AS TRANSDATE,
                  c1.FOLLOWUPID AS FOLLOWUPID,
                  (CASE WHEN c1.TRANSCODE = 'Deposit' THEN c1.TRANSAMOUNT ELSE -c1.TRANSAMOUNT END) AS TRANSAMOUNT,
                  a1.CURRENCYID AS CURRENCYID,
		c1.TRANSID
             FROM CHECKINGACCOUNT_V1 AS c1
                  INNER JOIN
                  PAYEE_V1 AS p ON p.PAYEEID = c1.PAYEEID
                  INNER JOIN
                  ACCOUNTLIST_V1 AS a1 ON a1.ACCOUNTID = c1.ACCOUNTID
           UNION ALL
           SELECT ' > ' || a2.ACCOUNTNAME AS PAYEENAME,
                  c2.TRANSDATE,
                  c2.FOLLOWUPID,
                  c2.TOTRANSAMOUNT,
                  a2.CURRENCYID,
c2.TRANSID
             FROM CHECKINGACCOUNT_V1 AS c2
                  INNER JOIN
                  ACCOUNTLIST_V1 AS a2 ON a2.ACCOUNTID = c2.TOACCOUNTID
            WHERE TRANSCODE = 'Transfer'
       )
       AS t
       INNER JOIN
       CURRENCYFORMATS_V1 AS c ON t.CURRENCYID = c.CURRENCYID
       LEFT JOIN
       CURRENCYHISTORY_V1 AS CH ON CH.CURRENCYID = c.CURRENCYID AND
                                   CH.CURRDATE = (
                                                     SELECT MAX(CRHST.CURRDATE)
                                                       FROM CURRENCYHISTORY_V1 AS CRHST
                                                      WHERE CRHST.CURRENCYID = c.CURRENCYID
                                                 )
 WHERE t.FOLLOWUPID > 0
 ORDER BY t.FOLLOWUPID ASC,
          t.PAYEENAME ASC,
          t.TRANSDATE ASC;ß<commit_msg>Bug fix, characters after ; removed.<commit_after>SELECT t.FOLLOWUPID,
       t.PAYEENAME,
       t.TRANSDATE,
       t.TRANSAMOUNT,
       t.TRANSAMOUNT * IFNULL(CH.CURRVALUE, c.BASECONVRATE) AS BaseAmount,
       c.PFX_SYMBOL,
       c.SFX_SYMBOL,
       (
           SELECT inf.infovalue
             FROM infotable_V1 AS inf
            WHERE inf.infoname = 'USER_COLOR' || CAST (t.followupid AS TEXT)
       )
       AS FOLLOWCOLOR,
t.transid as transid
  FROM (
           SELECT  (CASE WHEN c1.TRANSCODE = 'Transfer' THEN ' < ' ELSE '' END) || p.PAYEENAME AS PAYEENAME,
                  c1.TRANSDATE AS TRANSDATE,
                  c1.FOLLOWUPID AS FOLLOWUPID,
                  (CASE WHEN c1.TRANSCODE = 'Deposit' THEN c1.TRANSAMOUNT ELSE -c1.TRANSAMOUNT END) AS TRANSAMOUNT,
                  a1.CURRENCYID AS CURRENCYID,
		c1.TRANSID
             FROM CHECKINGACCOUNT_V1 AS c1
                  INNER JOIN
                  PAYEE_V1 AS p ON p.PAYEEID = c1.PAYEEID
                  INNER JOIN
                  ACCOUNTLIST_V1 AS a1 ON a1.ACCOUNTID = c1.ACCOUNTID
           UNION ALL
           SELECT ' > ' || a2.ACCOUNTNAME AS PAYEENAME,
                  c2.TRANSDATE,
                  c2.FOLLOWUPID,
                  c2.TOTRANSAMOUNT,
                  a2.CURRENCYID,
c2.TRANSID
             FROM CHECKINGACCOUNT_V1 AS c2
                  INNER JOIN
                  ACCOUNTLIST_V1 AS a2 ON a2.ACCOUNTID = c2.TOACCOUNTID
            WHERE TRANSCODE = 'Transfer'
       )
       AS t
       INNER JOIN
       CURRENCYFORMATS_V1 AS c ON t.CURRENCYID = c.CURRENCYID
       LEFT JOIN
       CURRENCYHISTORY_V1 AS CH ON CH.CURRENCYID = c.CURRENCYID AND
                                   CH.CURRDATE = (
                                                     SELECT MAX(CRHST.CURRDATE)
                                                       FROM CURRENCYHISTORY_V1 AS CRHST
                                                      WHERE CRHST.CURRENCYID = c.CURRENCYID
                                                 )
 WHERE t.FOLLOWUPID > 0
 ORDER BY t.FOLLOWUPID ASC,
          t.PAYEENAME ASC,
          t.TRANSDATE ASC;
{'fraction_non_alphanumeric': 0.05864342910975035, 'fraction_numerical': 0.015544041450777202, 'mean_word_length': 1.2016588906169, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 18, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1068172', 'n_tokens_mistral': 1445, 'n_tokens_neox': 1345, 'n_words': 301}