Counts are off on taxonomy terms

[macaws]

Bug description

There is an issue when using Eloquent for taxonomy terms where all counts appear as the same number:

I've been told by other Discord members that it even seems to break the correct calculation in the frontend when using "entries_count" inside a taxonomy tag.

How to reproduce

Add taxonomies and taxonomy terms to the database

Logs

Environment

Environment
Application Name: {Removed}
Laravel Version: 12.19.3
PHP Version: 8.4.10
Composer Version: 2.8.9
Environment: local
Debug Mode: ENABLED
URL: {removed}.test
Maintenance Mode: OFF
Timezone: UTC
Locale: en

Cache
Config: CACHED
Events: CACHED
Routes: CACHED
Views: CACHED

Drivers
Broadcasting: pusher
Cache: redis
Database: mysql
Logs: stack / single, flare
Mail: smtp
Queue: redis
Scout: meilisearch
Session: database

Storage
public/storage: NOT LINKED

Pulse
Enabled: ENABLED
Version: v1.4.2

Livewire
Livewire: v3.6.3

Spatie Permissions
Features Enabled: Default
Version: 6.20.0

Statamic
Addons: 12
Sites: 1
Stache Watcher: Disabled
Static Caching: half
Version: 5.58.1 PRO

Statamic Addons
aryehraber/statamic-uuid: 2.3.0
edge/powerbi-embed: dev-master
eminos/statamic-set-header-toggle: 1.1.0
eminos/statamic-tabs: 1.2.0
jacksleight/statamic-bard-mutator: 3.0.3
mitydigital/iconamic: 2.2.3
pecotamic/sitemap: 1.4.9
rias/statamic-redirect: 3.11.1
statamic-rad-pack/meilisearch: 3.4.0
statamic-rad-pack/runway: 8.5.1
statamic/eloquent-driver: 4.28.0

Statamic Eloquent Driver
Asset Containers: file
Assets: eloquent
Blueprints: eloquent
Collection Trees: eloquent
Collections: eloquent
Entries: eloquent
Forms: eloquent
Global Sets: eloquent
Global Variables: eloquent
Navigation Trees: eloquent
Navigations: eloquent
Revisions: eloquent
Sites: file
Taxonomies: eloquent
Terms: eloquent
Tokens: eloquent

Additional details

No response

[macaws]

@ryanmitchell if you gave me a few clues on this re: where to look, I could try to figure this out on my own + PR - but I ran out of time that I had allocated for it.

[ryanmitchell]

The issue is that pluck() is being used without get() first here: https://github.com/statamic/cms/blob/f585abd519083f07c9115c68e044cb4394f9e12a/src/Http/Controllers/CP/Taxonomies/TaxonomiesController.php#L37

So we need to add that method to the term query builder as we're wanting to ensure we applyCollectionAndTaxonomyWheres() before we call the parent::pluck. See: #476

I've been told by other Discord members that it even seems to break the correct calculation in the frontend when using "entries_count" inside a taxonomy tag.

Im not seeing that - could do with some verified way of reproducing that as it's a bit vague at the moment, feel free to open a new issue or ask them to. Failing tests are useful if you can supply that.

[K3CK]

Regarding the "entries_count" issue: That was already solved by #438. We had a version running that was fixed with this update.