Optimize JOIN query with DISTINCT
Because of filtering on two tables, it is not possible for a single index to handle all the WHERE, to handle the ORDER BY, much less optimize theLIMIT 10`.

The LEFT JOIN seems to be a JOIN.

This link on comments may help:  INDEX(dateAdded, linkId, id) (in that order).

If you want to discuss further, please provide EXPLAIN SELECT ... and EXPLAIN FORMAT=JSON SELECT ...