Hello Larry

Thank you for your purchase.

Unfortunately, I cannot see the image you shared with me.

I suppose you're using our query constructor to generate this query? If this is true, please note that this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.

Hello again Larry

You can combine multiple database tables through a query, if that's what you meant to ask.

Can you explain to me, step-by-step how I can recreate the issue on your end, and then please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. 

You can write credentials here just check Private Reply so nobody can see them except us.

Hi again Larry

It seems like the views don't accept subqueries (multiple SELECT statements), so you would need to create a new custom query that would pull the data you need.

Unfortunately, writing custom queries is not included in the provided support for the plugin, so I can't help you with that. Would you be able to change the timeout limit, and see if the table will be generated from the query constructor?

If that doesn't help, you'll need to write another query to generate this table.

I can only recommend these services for customization:

https://codeable.io/?ref=l1TW1

https://wpkraken.io/?tms-plugins

They do develop such solutions, so if you need some custom work, could you please contact them?

Hi again Larry

First see what it's set to now. Set it to be at least 300 seconds, but you can go for more. Check with your hosting provider what the best value would be. As for the datetime, you would need to simply change the format in wpDataTables settings, so it's the same as it is in the database (I believe it's MM/DD/YYY by default).