sql

select sum(cnt) from (SELECT
  COUNT(sli.sid) cnt
FROM
  data_file df
  LEFT JOIN sales_line_item sli ON sli.data_file_sid = df.sid
  and sli.customer_sid=df.customer_sid and   sli.DELETED = 1 AND
  sli.RESUBMITTED = 0
WHERE
  df.SID = :sid and df.customer_sid = :customerSid
group by df.sid
union all
SELECT
  COUNT(sli.sid) cnt
FROM
  data_file df
  LEFT JOIN inv_line_item sli ON sli.data_file_sid = df.sid
  and sli.customer_sid=df.customer_sid and   sli.DELETED = 1 AND
  sli.RESUBMITTED = 0
WHERE
  df.SID = :sid and df.customer_sid = :customerSid
group by df.sid)
;