How to create a selection for an activity feed in MySQL?

Question

MySQL

Gentlemen, next question.
There are 5 tables, you need to collect information about them together and sort by date.
The problem comes when I join tables like this:

SELECT l . * , f . * 
FROM user t
INNER JOIN likes l ON t.id = l.author
INNER JOIN follow f ON t.id = user_id
WHERE t.id =5
LIMIT 0 , 30

Result:

Cells are repeated. Somehow you can get rid of repetitions and bring it to the form - one cell - one event?

Answer 1

So why do you have INNER at the top and LEFT at the bottom? Use INNER.

Answer 2

If columns are duplicated, then select only the ones you need, and not
In order not to duplicate lines, first do a JOIN instead of Left Join, if there are duplicates anyway, then look for the difference in these lines (it should be, and I suspect that you have jambs with dates there)