#20264t3lib_queryGenerator not respecting MM-relation when creating query
Description
At direct mail special query using t3lib_queryGenerator to build the query t3lib_queryGenerator doesn’t respect MM-relation when bulding the query.
Create several address groups e.g.
Mailorder, Party, Common
In direct mail create a recipient list using special query and do a select on one of the addressgroups
In the editor everything look fine as you get the names of the groups correctly. But the compile query is wrong as it doesn’t reflect the join.
Example:
Party has the uid 2 in the adressgroup.
The compiled query:
SELECT uid,pid,deleted FROM tt_address WHERE addressgroup = ‘2’ AND tt_address.deleted=0
But as addressgroup is a MM-relation the value of the field is just the count of realtions.
So performing that query will only return only address with two addressgroups added and NOT with addressgroup=2
(issue imported from #M10826)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.