From
COM_COMMUNITY_EMAIL_REGISTRATION_COMPLETED_REQUIRES_ACTIVATION="Hello %1$s,\n\nThank you for registering at %2$s. Your account is created and must be activated before you can log in.\nTo activate the account, click on the following link or copy-&amp;-paste it in your browser:\n\t<a href='%3$s'>%3$s</a>\n\nAfter activation you may login to %4$s using your username and password."

To
COM_COMMUNITY_EMAIL_REGISTRATION_COMPLETED_REQUIRES_ACTIVATION="Hello %1$s,\n\nThank you for registering at %2$s. Your account is created and must be activated before you can log in.\nTo activate the account, click on the following link or copy-&amp;-paste it in your browser:\n\n%3$s\n\nAfter activation you may login to %4$s using your username and password."

From
$query = 'SELECT SUM(CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('Male') . ' THEN 1 ELSE 0 END) as Male, ' . 'SUM(CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('Female') . ' THEN 1 ELSE 0 END) as Female ' .

To
$query = 'SELECT SUM(CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('Male') . ' THEN 1 ELSE 0 END OR CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('COM_COMMUNITY_MALE') . ' THEN 1 ELSE 0 END) as Male, ' . 'SUM(CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('Female') . ' THEN 1 ELSE 0 END OR CASE ' . $db->quoteName('value') . ' WHEN ' . $db->Quote('COM_COMMUNITY_FEMALE') . ' THEN 1 ELSE 0 END) as Female ' .