As it is currently, the dashboard report does include deleted likes, so adding AND pa.deleted IS NULL would change how this query is matching up with the dashboard report.
Modifying the underlying dashboard report to not include deleted likes could be a good change to consider making to the report though.