It was basically a more complicated version of this: https://stackoverflow.com/questions/68809885/how-to-select-for-update-one-row-from-table-a-and-all-joined-r

It was basically a more complicated version of this: https://stackoverflow.com/questions/68809885/how-to-select-for-update-one-row-from-table-a-and-all-joined-rows-from-table-b-i https://stackoverflow.com/questions/68809885/how-to-select-f...