Profile: ScottM9386

Problem:

How to setup SQL query to query many2many relationships that has an intermediary with fields.

Solution:

We don't provide the customize SQL query support, but you can still get the detail SQL query by these:

1) Create many-to-many relationship between two post types

2) Create a view to retrieve the related posts
https://toolset.com/documentation/post-relationships/how-to-display-related-posts-with-toolset/#displaying-many-related-items

OR Use Post relationship API to retrieve the related posts in your website
https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_post_types

3) Dashboard-> Toolset-> Settings-> Front-end Content
Enable option "Enable Views debug mode", and option "Full debug mode",
Run those page/post of step2), then you will be able to get those SQL query in details.

And you can also install other plugins to get the SQL query details, for example:
https://wordpress.org/plugins/search/query+monitor/

Relevant Documentation:

https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_post_types