posts_join – Hook | Developer.WordPress.org
Filters the JOIN clause of the query.
codex.wordpress.org