item with General category in the backend but with another category in the frontend

I do not understand the reason why an item that belongs to the "General" category in the backend and the database appears in another category that depends on another category tree.

Hello

main category
- is used to calculate ACL
- it is the category that Joomla category / article view will use

An Flexicontent item that belongs to multiple categories
will appear in all of them
that is the reason that multi-category assignment was created for

Secondary category do not use any ACL rules
but they still use access levels,
so in your case you can make the secondary categories non-viewable
(if that is what you need)

Access Manager uses user groups. Different groups of users can access a category, but others can not. For that reason, this ACL is not viable for us.

Hello

you can achieve proper viewing access by creating enough access levels and assigning them to desired usergroups

- Just name every Access level appriately
- Assign 1 or more Access levels to desired usergroups

If you cannot achieve the same result as with usergroups,
then it means that you need more fine grain control of access level, meaning you should create more access levels and possibly more usergroups

Hello,

Where could I find the MySQL queries, to add my content filters in the blog category view?

Regads.

sorrybut i don't understand all query are done not ? could yopu explain more ?

I'm sorry I did not explain myself well. The query or MySQL queries I want to obtain are those that identify the items that need to be displayed.

thtat depend what you want  .. we have many filter many function and join ... i don't understand sorry

I am interested in knowing the id of item, to hide articles with certain id. The articles that I want to hide are classified in a category, but in the frontend they are classified in a category that does not belong to the same category tree.

Menu item type: category blog

I have attached a screenshot of how it looks and one of the items I want to hide.

that a link to joomla view not flexicontent we can't provide support too joomla! we already have a big work for free with flexiontent .. sorry
but maybe you can do an override of you category view and display id ?