How to create nodes inside another node in drupal?

Question

CMS

The bottom line is that, for example, I have a node (some kind of event) and if these events will occur in different places, at different times. That is, there is a node with a description of the event, photos, details ... and sub-nodes with addresses and time. Or maybe there is another way to implement it?

Answer 1

https://www.drupal.org/project/entityreference
create a field with a link to another node.
in the display settings specify the rendered entity

Answer 2

The title of the question somewhat contradicts its content.

Answer 3

Comparing entity_id with 5 values, post_type with 12. A total of 60 comparisons per entry! The optimizer will actually make fewer comparisons, but it's still very inefficient.
It is necessary to understand in detail the nuances and change the business logic.

Answer 4

just figure out how indexes are arranged in MySQL and everything will fall into place, for example, here is an article about the structure of indexes

Answer 5

To get started, throw MySQL in the trash.
If this is the only type of query on the table, make a composite index.
And besides, you need to watch explain

Answer 6

FORCE INDEX(`index_name`)
try adding to query
https://dev.mysql.com/doc/refman/5.7/en/index-hint...