I want to ask about the Prophet (alanbia:as mohamed, loot,) not under the sin effect. I read about (each of adams sons is a sinner).
Praise be to Allah, the Lord of the Worlds; and may His blessings and peace be upon our Prophet Muhammad and upon all his Family and Companions.
Know that the Prophets are infallible as far as major sins are concerned. None of them ever committed a major sin.
Despite that, if one of them commited a minor sin, Allah did not approve of his act. Rather, He warned them of that and informed them of the type of violation they did.
Then Allah guided them to repent from it without delay. When they repented they became better than before.
Allah knows best
You can search for fatwa through many choices