WIP: optimization on displaying studies list

I got really tired of how slow is the studies display when having so many studies so I started working on https://github.com/biocore/qiita/issues/601. This is the initial optimization of /private/. I want to have some feedback before working on the others. 
Revised SQL, opinions?
SELECT S.study_id, S.study_title, U.name as owner_name, U.email as owner,
       S.metadata_complete, S.number_samples_collected, SP.name as pi_name,
       SP.email as pi_email, count(SRD.raw_data_id) as num_raw_data,
SS.status,
       array_agg(PMID.pmid) as PMIDs, array_agg(SU.email) as shared_with
FROM qiita.study S
     LEFT JOIN qiita.study_status SS ON S.study_status_id =
SS.study_status_id
     LEFT JOIN qiita.study_raw_data SRD ON S.study_id = SRD.study_id
     LEFT JOIN qiita.study_person SP ON
        S.principal_investigator_id = SP.study_person_id
     LEFT JOIN qiita.qiita_user U ON S.email = U.email
     LEFT JOIN qiita.study_pmid PMID ON S.study_id = PMID.study_id
     LEFT JOIN qiita.study_users SU ON S.study_id = SU.study_id
WHERE S.email = 'demo@microbio.me'
GROUP BY S.study_id, S.study_title, owner_name, owner, S.metadata_complete,
        S.number_samples_collected, pi_name, pi_email,  SS.status
ORDER BY S.study_id;