Many duplicates in Drupal view of CiviCRM contributions
I have a Drupal view configured as shown in the attached screenshot:
This results in lots of duplicate results in the listing, as you can see:
Not every contribution is duplicated, but many are.
Some notes:
- There are 16 total entries for contribution
#1
. 16 is suspiciously a power of 2. - If I decrease the number of address fields shown, the number of duplicates gets cut in half each time.
So I'm guessing there's some poorly-formed SQL join between contributions and addresses, resulting in the Cartesian product of join fields or something like that. Any way to diagnose?
Thanks.