HI Crisotech,
Thank you for your purchase.

Unfortunately if you take a look at our documentation you will see this notice

Please note that this tool is not an ultimate query generator, it just constructs a suggestion of a query. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated the query is, the higher is the chance that it will not return exactly what you need. So play around with the resulting query.

So when you have queries like this our suggestion is to make a VIEW in phpmyadmin or any other database management system and see if the query is returning the right result. If the result is good you can use that query as an input when creating tables with add from data source option.

Hope this can help.

Best regards.