[IMP]account:use left join for grouping records and use grouped field for grouping or not