Slow Query With Multiple Left Outer Joins
Are there ever two billing addresses for one account?  If not, toss the LEFT JOIN for that address; it has no affect on the COUNT(*).  Ditto for all the other LEFT JOINs.

Even if one of the LEFT JOINs leads to extra rows, get rid of them because of the DISTINCT.

Are there multiple profiles for each user?  If not, then much of the other baggage is wasted.

Then get rid of the nested ("derived") SELECT.

SELECT COUNT(*)   -- or maybe COUNT(DISTINCT profile_id)
    FROM profile AS p
    WHERE P.ORGANIZATION_ID = 1
      AND P.ISANONYMOUS = false 


That should give you the same count as your original query.  If not, please explain where there are 1:many mappings that are not obvious.

If you aren't really asking about COUNT(*), but rather fetching multiple columns, then show us the real query; it may need other optimizations.  Also, provide SHOW CREATE TABLE so we don't waste time recommending indexes you may already have.