Why are there duplicate values ​​when inserting into a table with foreign keys?

Question

MySQL

And the values ​​are also duplicated with a certain selection from this database:
Why is the selection occurring twice in a SQL query?

Answer 1

With such a formulation of the question and the lack of specifics, there is only one answer - crooked hands.