Preferred Taxon Queries do not include Taxa without a Preferred Taxon

[alesan99]

Describe the bug
If you make a Taxon Query with Preferred Taxon it sometimes does not display the Taxa without a defined 'Preferred Taxon'

To Reproduce
Steps to reproduce the behavior:

1. Ensure you have a Taxon without a Preferred Taxon and one that does have one.

2. Make a new Query matching the screenshots below OR import one of these:
   SynonymizedTaxaSwitch.json
   prefTaxon.json

3. Run the Query and look at the results

4. Switch the order of the Query field lines

5. Run the Query and see if the results changed

Expected behavior
The query results should still show Taxa without any Preferred Taxon, regardless of the order of the Query fields.
Specify 6 handles this well.

Screenshots
Undesired result:

Switching the order fixes it

Results on Specify 6 (Using the order from the first screenshot):

Please, also fill out the following information manually:

• OS: Windows 11
• Browser: Chrome
• Specify 7 Version: edge
• Database Name: kubirds_8_25_23
• User Name: spbirdadmin

[combs-a]

It's specifically when the Preferred Taxon query is of a specific rank. (any rank) seems to work as normal.

i.e. when a query has (any rank) -> Preferred Taxon -> Rank -> etc...

[emenslin]

Can recreate in edge (7.9.6)

[lexiclevenger]

Eyal from hujinnhc reported that Determination queries with Taxon and Preferred Taxon also return results for rank fullName incorrectly. The results for EITHER the Taxon OR Preferred Taxon table will appear in both columns depending on which table appears first in the mapping.

Specify 7 results:

Specify 6 results:

[grantfitzsimmons]

This is causing another issue for Purdue Herbarium: the Host Family is not displayed if the current Det's Family is first, and vice versa. This means they cannot display both on their label at the same time.

Screen.Recording.2025-01-17.at.4.13.36.PM.mov