pre_user_query to edit the actual sql query and it works wonderfully.
Now I'm trying to work with
pre_get_posts and its not at all the same thing. I need to do an INNER JOIN.. In this function it seems to only accept things like
$query->set('meta_query',$meta_query); which is too simple... The setting doesn't allow me to add a JOIN clause and then use it in a WHERE clause.. which is what I need to do.
Am I using the wrong function? Is there a
pre_posts_query that exists instead?? What are others doing here? Any guidance will be super appreciated!