In a complex filtersetting,
when using field Content: Node operations bulk form somehow checkboxes are missing for some entries. This can be solved by selecting Distinct in the query settings.
On the other hand this causes a SQLSTATE[HY000]: General error: 3065 when ordering the entries. This seems to be related to
https://www.drupal.org/project/advanced_forum/issues/2638760 →
Closed: works as designed
9.5
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
AS #9 points out, more information is needed here in order to understand the problem and then to write tests. That has not been provided in 6 months. Combined with no other reports related to this, I think it is time to close this, works as designed seems best.
For information, the line changed in the patch here was changed in #3185231: Use combination SQL modes instead of explicit modes → .