SELECT count(*)
FROM
  civicrm_contribution a
    -- join to previous contributions with the same contribution recur id which happened before the given one
    LEFT JOIN civicrm_contribution c2 ON c2.contribution_recur_id = a.contribution_recur_id AND
                                         c2.receive_date < a.receive_date
    LEFT JOIN `civicrm_value_1_gift_data_7` Gift_Data
    ON a.id = Gift_Data.entity_id

WHERE `a`.`receive_date` > "20230701000000"
  AND `a`.`contribution_recur_id` > 0
  -- financial type not already of recurring type
  AND `a`.`financial_type_id` NOT IN (31)
  AND `a`.`is_test` = 0
  AND c2.id IS NULL
LIMIT 5000;

SELECT count(*)
  FROM
  civicrm_contribution a
    -- join to previous contributions with the same contribution recur id which happened before the given one
    LEFT JOIN civicrm_contribution c2 ON c2.contribution_recur_id = a.contribution_recur_id
    AND c2.receive_date < a.receive_date
    LEFT JOIN `civicrm_value_1_gift_data_7` Gift_Data
    ON a.id = Gift_Data.entity_id

WHERE `a`.`receive_date` > "20230701000000"
  AND `a`.`contribution_recur_id` > 0
  -- financial type not already of recurring type
  AND `a`.`financial_type_id` NOT IN (32)
  AND `a`.`is_test` = 0
  AND c2.id IS NOT NULL
LIMIT 5000;

SELECT count(*)
FROM
  civicrm_contribution a
    -- join to previous contributions with the same contribution recur id which happened before the given one
    LEFT JOIN civicrm_contribution c2 ON c2.contribution_recur_id = a.contribution_recur_id AND
                                         c2.receive_date < a.receive_date
    LEFT JOIN `civicrm_value_1_gift_data_7` Gift_Data
    ON a.id = Gift_Data.entity_id

WHERE `a`.`receive_date` > "20230701000000"
  AND `a`.`contribution_recur_id` > 0
  -- financial type not already of recurring type
  AND `a`.`financial_type_id` NOT IN (31)
  AND `a`.`is_test` = 0
  AND c2.id IS NULL
LIMIT 5000;