How to get the id of a child resource by the name (id) of the category?

Question

MariaDB

There is the following structure.

How can I get all the children Documents and Options while in the Home?
All resources match the same template. into which chunks are inserted that collect data from tv fields

Answer 1

INSERT cannot be a subquery

Answer 2

getResources snippet, with where=`isfolder:0` (where the resource is not a folder), I could have made a mistake in the correct spelling, but the principle is this