That's a long chain of references. I believe it ends at table t0CombinedEntities. Normalization is missing in that table and the references are so deep I might mess up the entire thing. But if it's always changing only the first record, I suspect the query returns multiple results, which means the record involved is not referencing a unique Id. Try to reference a unique Id for the procedure that changes the price.