Do not join with target table of Many2One for only id clause

Also since 1b31be06c525 there is no need to add an active clause as the active test is disabled by the decorator.

Closes #11841 (closed)