...
In this case, if macros is set to Truetrue, the inner query executes first, thus, substitution values for directory_id is not available. Therefore, this query is not executed successfully.
...
In this case, if macros is set to Truetrue, the inner query executes first, thus, substitution values for directory_id is not available. Therefore, this query is not executed successfully.