Is it permissible to repeat the Istikhara (seeking guidance) prayer, and is it a condition that one should sleep after offering it?
All perfect praise be to Allah,The Lord of The Worlds Istikhara is offered once, but it is permissible to repeat it, and sleeping after offering it is not a condition for its validity. And Allah Knows Best.
Does offering Udhiyah (Offering a Sacrificial animal at Aid Al-Adha) avails from offering Aqiqa?
Offering an Udhiyah doesn't avail a person from offering Aqiqa because each of which is a different act of worship. And Allah Knows Best.
Ruling when Husband Utters Divorce Jokingly, or in the State of Intoxication or Anger
All perfect praise be to Allah the Lord of the Worlds. May Allah`s peace and blessings be upon our Prophet Mohammad and upon all his family and companions.
The man who utters divorce while in the state of anger, his divorce doesn`t take place and the same ruling applies to the man who is forced to utter divorce because he is threatened to be killed or one of his organs cut off, in addition to other matters that scholars have mentioned in this regard. However, the man who utters divorce jokingly or while having intentionally drunk alcohol, his divorce takes place. And Allah The Almighty Knows Best.
Is prayer mandatory on a dying person who goes through a state of unconsciousness, then wakes up?
If he wakes up and was conscious, then he should pray the way/manner he could, but if he wasn't, then he is exempted from obligatory prayer as Allah Says in this regard (What means): "On no soul doth God Place a burden greater than it can bear." [Al-Baqarah/286].