SELECT pd.ftid, pd.cid, n.nid AS issue_id, n.title AS issue_title, n.uid, pi.pid, pi.rid, f.filepath AS patch_url, p.title AS project, u.name AS submitter$select
FROM {pift_data} pd
INNER JOIN {project_issues} pi
  ON pd.nid = pi.nid
INNER JOIN {files} f
  ON pd.fid = f.fid
INNER JOIN {node} n
  ON n.nid = pi.nid
INNER JOIN {node} p
  ON p.nid = pi.pid
INNER JOIN {users} u
  ON u.uid = pd.uid$join
WHERE ((pd.status = %d AND pd.timestamp < %d)
  OR (pd.status = %d AND pd.timestamp < %d))
  AND pd.cid = %d$where)
UNION
(SELECT pd.ftid, pd.cid, n.nid AS issue_id, n.title AS issue_title, n.uid, pi.pid, pi.rid, cu.filepath AS patch_url, p.title AS project, u.name AS submitter$select
FROM {pift_data} pd
INNER JOIN {project_issues} pi
  ON pd.nid = pi.nid
INNER JOIN {comment_upload_files} cu
  ON pd.fid = cu.fid
INNER JOIN {node} n
  ON n.nid = pi.nid
INNER JOIN {node} p
  ON p.nid = pi.pid
INNER JOIN {users} u
  ON u.uid = pd.uid$join
WHERE ((pd.status = %d AND pd.timestamp < %d)
  OR (pd.status = %d AND pd.timestamp < %d))
AND pd.cid <> %d$where)
ORDER BY ftid", $args, 0, PIFT_SEND_LIMIT);