active accounts with Persona but not github credentials

gistfile1.sql

SELECT DISTINCT `auth_user`.`email`, `auth_user`.`first_name`, `auth_user`.`last_name`
FROM 
(SELECT * 
FROM `socialaccount_socialaccount`
WHERE `socialaccount_socialaccount`.`provider`="persona") A
LEFT JOIN 
(SELECT * 
FROM `socialaccount_socialaccount`
WHERE `socialaccount_socialaccount`.`provider`="github") B
ON A.`user_id` = B.`user_id`
JOIN `auth_user` ON `auth_user`.`id` = A.`user_id`
WHERE B.`user_id` IS NULL
AND `auth_user`.`is_active` = 1