SELECT SQL_CALC_FOUND_ROWS u.*, c.name as company_name, count(p.position_id) as current_jobs, count(rp.recruiter_position_id) as engaged_count
FROM tbl_user u
LEFT OUTER JOIN tbl_company c
ON u.company_id = c.company_id
LEFT OUTER JOIN tbl_position p
ON u.user_id = p.user_id AND p.deleted = 'show'
LEFT OUTER JOIN tbl_recruiter_position rp
ON u.user_id = rp.recruiter_user_id AND rp.engagement_action_code = 'ACCEPTASSOCIATION'
GROUP BY user_id