SELECT ${group},
    COUNT(*) AS leads_pf,
    SUM(CASE WHEN lp.origination_date IS NOT NULL THEN 1 ELSE 0 END) AS originations,
    SUM(CASE WHEN lp.fund_date IS NOT NULL THEN 1 ELSE 0 END) AS funded,
    SUM(CASE WHEN lp.trimerge_date IS NOT NULL THEN 1 ELSE 0 END) AS credit_pulls,
    SUM(CASE WHEN lp.loan_number IS NOT NULL THEN 1 ELSE 0 END) AS call_connections,
    SUM(CASE WHEN current_loan_status IN (
      'Approved',
      'Initial Disc Sent',
      'Purchased by Investor',
      'STP',
      'Funded',
      'Docs Back',
      'Docs Ordered',
      'Docs Out',
      'File Rcvd',
      'Restructure',
      'Sub. to UW',
      'Suspended') THEN 1 ELSE 0 END) AS applications,
    SUM(CASE WHEN lp.trimerge_date = lp.lead_received_date
       THEN 1 ELSE 0 END) AS prd_method1_count,
    SUM(CASE WHEN lp.origination_date IS NOT NULL THEN
      CASE WHEN DATE_PART('day', now() - lp.lead_received_date::timestamp) >= 7 THEN
        CASE WHEN DATE_PART('day', lp.origination_date::timestamp - lp.lead_received_date::timestamp) <= 6
        THEN 1 ELSE 0 END
      END
    ELSE 0 END) AS prd_method2_7day_count,
    SUM(CASE WHEN lp.origination_date IS NOT NULL THEN
      CASE WHEN DATE_PART('day', now() - lp.lead_received_date::timestamp) < 7
        AND DATE_PART('day', now() - lp.lead_received_date::timestamp) > 1 THEN
        CASE WHEN DATE_PART('day', lp.origination_date::timestamp - lp.lead_received_date::timestamp) <= 1
        THEN 1 ELSE 0 END
      END
    ELSE 0 END) AS prd_method2_2day_count,
    SUM(CASE WHEN lp.origination_date IS NOT NULL THEN
      CASE WHEN DATE_PART('day', now() - lp.lead_received_date::timestamp) <= 1 THEN
        CASE WHEN DATE_PART('day', lp.origination_date::timestamp - lp.lead_received_date::timestamp) = 0
        THEN 1 ELSE 0 END
      END
    ELSE 0 END) AS prd_method2_1day_count,
    SUM(mortgage_balance) AS loan_sum,
    SUM(CASE WHEN mortgage_balance IS NOT NULL THEN 1 ELSE 0 END) AS loan_count,
    0 AS leads_pl,
    0 AS flat
  FROM sources AS src
    JOIN leads AS le USING(lead_id)
    JOIN leads_perf AS lp USING(lead_id)
    ${joinSoldLeads}
  WHERE le.created_on >= '${dateFrom}'
  AND le.created_on <= '${dateTo}'
  AND le.affiliate_id <> 3
  AND le.campaign_id IN (SELECT campaign_id FROM campaigns WHERE selected = true)
  ${offerIDСondition}
  ${whereFlatLeads}
  GROUP BY ${group}
  ORDER BY ${group}