How to make selection of various records from various tables on time?

Question

MySQL

Hello
There are several types of posts on the page (pictures and videos). They are stored in various plates and are described by various models. There is a common field - the timestamp of the time when the record was added, according to which you need to select records together and display them on the page. Depending on the record type - output in different views. (Pagination, of course, is also needed).
What is the best way to implement this?
Thank you.

Answer 1

Good evening.
It is possible through communications between tables.
Write connections, make a choice through these connections, and set time through where.
Although it would be better not to navigate by time, but by id, primary key.