<commit_before>-- Validation compares piid and/or program parent_award_id
SELECT
    ap.row_number,
    ap.piid,
    ap.parent_award_id
FROM award_procurement AS ap
WHERE ap.submission_id = {}
    AND COALESCE(ap.federal_action_obligation, 0) <> 0
    AND ap.piid IS NOT NULL
    AND ((ap.parent_award_id IS NULL
          AND NOT EXISTS (
              SELECT 1
              FROM award_financial AS af
              WHERE af.submission_id = ap.submission_id
                  AND af.piid = ap.piid)
         )
         OR (ap.parent_award_id IS NOT NULL
             AND NOT EXISTS (
                 SELECT 1
                 FROM award_financial AS af
                 WHERE af.submission_id = ap.submission_id
                     AND af.piid = ap.piid
                     AND af.parent_award_id IS NOT DISTINCT FROM ap.parent_award_id)
	       )
	  )
  AND NOT EXISTS (
	    SELECT af.transaction_obligated_amou
	    FROM award_financial AS af
	    WHERE af.transaction_obligated_amou IS NULL
	)<commit_msg>Fix more indentations<commit_after>-- Validation compares piid and/or program parent_award_id
SELECT
    ap.row_number,
    ap.piid,
    ap.parent_award_id
FROM award_procurement AS ap
WHERE ap.submission_id = {}
    AND COALESCE(ap.federal_action_obligation, 0) <> 0
    AND ap.piid IS NOT NULL
    AND ((ap.parent_award_id IS NULL
          AND NOT EXISTS (
              SELECT 1
              FROM award_financial AS af
              WHERE af.submission_id = ap.submission_id
                  AND af.piid = ap.piid)
         )
         OR (ap.parent_award_id IS NOT NULL
             AND NOT EXISTS (
                 SELECT 1
                 FROM award_financial AS af
                 WHERE af.submission_id = ap.submission_id
                     AND af.piid = ap.piid
                     AND af.parent_award_id IS NOT DISTINCT FROM ap.parent_award_id)
         )
    )
    AND NOT EXISTS (
        SELECT af.transaction_obligated_amou
        FROM award_financial AS af
        WHERE af.transaction_obligated_amou IS NULL
    )
{'fraction_non_alphanumeric': 0.050682261208576995, 'fraction_numerical': 0.003898635477582846, 'mean_word_length': 1.719205298013245, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4621326', 'n_tokens_mistral': 665, 'n_tokens_neox': 620, 'n_words': 172}