To fetch the posts I have a query which includes several joins and is quite complicated to use through WP_Query. SELECT