Please keep in mind that you need to translate your SysFolder to use this feature!!!!!! Otherwise you need to go the hard way …

Insert these lines after the root entry of the DS:
[sourcecode lang=“xml“]

1

…
[/sourcecode]

Hey … it’s very simple to get the last sql statement. Before the execution of the statement write this:

$GLOBALS['TYPO3_DB']->store_lastBuiltQuery = 1;

Then execute the statement. After that you can query the sql string with:

echo $GLOBALS['TYPO3_DB']->debug_lastBuiltQuery;