Is there a limit of complexity for a query using SQL ARI TABLE?
For a simple query I have a result but for a complex query, nothing appears

regards

Could you provide your SQL query? Did you try to run your query in a SQL manager, is it work without problems?

Regards,
ARI Soft

I try to run this request in a SQL manager and it works.
I attach a .txt file to see my query.

I put this query in this structure:
{arisqltable}
{ariconnectionstring dbHost="localhost" dbName="joomla" dbUser="user" dbPass="pass" dbType="mysqli" persistent="false"}
{arisqltablequery}
my_query
{/arisqltablequery}
{/arisqltable}

I test the ariconnectionstring parameters with a simple query and it works.

See you tomorrow.

Regards

Could you also provide SQL dump of tables that are used in your query? It requires that we can reproduce this issue on our test server.

Regards,
ARI Soft

I attach a file to this message with sql tables but no corresponding data. I can not. I hope that's enough.

I think I put all the tables corresponding to my query

regards

Check your mail, please.

Regards,
ARI Soft