SELECT COUNT(*) FROM 
(SELECT users.uid AS uid 
FROM ac_users users 
LEFT JOIN ac_profile_values profile_values_profile_partner_interest_rolereg0 ON users.uid = profile_values_profile_partner_interest_rolereg0.uid AND profile_values_profile_partner_interest_rolereg0.fid = '77' 
LEFT JOIN ac_profile_values profile_values_profile_first_name ON users.uid = profile_values_profile_first_name.uid AND profile_values_profile_first_name.fid = '1' 
LEFT JOIN ac_profile_values profile_values_profile_last_name ON users.uid = profile_values_profile_last_name.uid AND profile_values_profile_last_name.fid = '2' 
LEFT JOIN ac_profile_values profile_values_profile_company_website ON users.uid = profile_values_profile_company_website.uid AND profile_values_profile_company_website.fid = '19' 
LEFT JOIN ac_profile_values profile_values_profile_country ON users.uid = profile_values_profile_country.uid AND profile_values_profile_country.fid = '27' 
WHERE profile_values_profile_partner_interest_rolereg0.value <> '0') AS foo