Comment to How to find accounts without profiles?
-
Is there a regular expression that I can use with the search box?
No, another way is to search manually in the database.
-
Alex, how to identify an account that does not have a profile because in the sys_accounts table an account that does not have a profile seems to still have a profile_id.
How are you doing then? -
You can use the following query to get all emails which don't have any person or org profile associated with it:
SELECT `email` FROM `sys_accounts` AS `a` LEFT JOIN `sys_profiles` AS `p` ON ( `p`.`account_id` = `a`.`id` AND `p`.`type` != 'system' ) WHERE `p`.`id` IS NULL
-
Thank you Alex, it helps, but like DeDiary, I hope a more user-friendly solution and secondly it is not a solution for turnkey solutions that you propose to avoid this kind of manipulation.
-