SELECT reputation, bio_text, COUNT(krit.id) as kritCount FROM ukritic_members AS mem LEFT JOIN ukritic_members_profile AS member ON member.memberID = mem.id LEFT JOIN ukritic_krits AS krit ON member.memberID = krit.memberID AND krit.approved = '1' WHERE (member.memberID = '9')

SQL Error:In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'ukritic_master.mem.reputation'; this is incompatible with sql_mode=only_full_group_by