Update: We rolled back but the LIQL issue persists and whats odd is i can add, and edit new items to the EN category, and have them appear in LIQL, but the other items, that have existed since we went live years ago no longer appear, specific to our EN category only? 

CarolineS , if you roll back, does LIQL still show a issue? 

The Q I'm trying to solve now, is there any setting that can prevent something from appearing in LIQL? As far as I know nothing like that exists? LIQL should return everything based on access of the person requesting and im using admin?

Yay! Thanks for the confirmation CarolineS and the 24.2 edit! 

phoneboy, had a similar issue that we reported to Support. They provided us with an additional LiQL WHERE clause condition: 

AND products.association_type='tag'

Adding that to our products.id queries fixed them.

Yet another example of the inconsistent experience I receive when I need to engage Khoros TAC...I was never offered this workaround!

I ultimately decided to move away from using Products for the purpose I was using them for.
Seems like this functionality was never fully developed and, given the eventual migration to Aurora, it doesn't seem prudent to waste further time attempting to use it.

phoneboy, definitely inconsistent. Sounds like you had a higher level of time sensitivity around a resolution than I did. I imagine that they simply knew more by the time they replied to me.