Closed happy-river closed 4 years ago
The joins in load_user were producing multiple rows with duplicate Notification.ids and then, fn.Count was counting total rows not unique rows, leading to the multiplication effect. Fix by counting with nested selects instead of joins.
load_user
Notification.id
fn.Count
The joins in
load_userwere producing multiple rows with duplicateNotification.ids and then,fn.Countwas counting total rows not unique rows, leading to the multiplication effect. Fix by counting with nested selects instead of joins.