TYPO3 Core

That would mean that we'd need to join each related table whose field is visible to the table that is being listed.

I'd set the complexity to somewhere between "hard" and "nightmare" because it'd need a pretty solid rewrite of RecordList :)

I am pretty sure this worked before.

As a temporary "solution" you can - please don't hurt me - do this:

[columns][category][config][foreign_table_where] => 'ORDER BY category.name'

I know it sounds wrong to put your ORDER-BY-string-SQL inside an option that is named something with "_where", but it is even in the official docs. ;-)

Attached you'll find a test extension to easily reproduce the issue. After installing there is a sql file containing a couple of data rows. Just replace the PID in the file with a value suitable for your system.

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/44421

I will abbanden my patch, because it came up, that this is not entirely fixable. I was able to fix it as long as we only deal with internal tables. But at the point somebody infused some addWhere stuff thru TCA (compare Felix coment about "order" in the where clause) without proper namespacing that (tablename.fieldname) it will break. And I see no reasonable way to write a parser that ensures sanitization in all cases.