[TYPO3-dev] Get more efficient queries

[Tapio Markula]

Hi

I should create more efficient queries deleting mm_relations

http://t3test.xetpoint.com/media/development/delete_mm_relations.txt

I use loops, which is bad but for lost relations (local_uid has not 
related uid in the main table) I can't see another way.

But Fr.Holzinger wrote

You can use exec_SELECT_queryArray($queryParts) and get an array of the 
uids.
Then you can select the mm table by ... WHERE uid_local IN (...uids 
comma separated )
This is only one SQL QUERY oder DELETE

that could fit for records, which are marked as deleted.

But I don't figure how to build $queryParts