The posts_join_paged filter allows you to add join(s) to the posts query in paginated contexts.

It is evaluated in the WP_Query::get_posts() method in the wp-includes/query.php file.

Example:

This filter needs an example! Have an idea? Submit some code.