Is it permissible for someone to make a supplication to Allah to marry an already married, or an engaged woman?
No, it isn`t, and the person who does so is sinful before Allah, The Almighty.
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].
What are the conditions of the Aqeeqah?
The animals that are acceptable to be slaughtered for 'Aqeeqah are the same which are acceptable to be slaughtered for the sacrifice of 'Eed in terms of their age and lack of defects. The sheep should be one year old, and its teeth should have fallen off. As for goats and cows, they should have finished two years of age and entered into the third. The Aqeeqah should be free of any defects as regards meat, or price value.
I suffer from absentmindedness and constant worries during prayer, what should I do?
You should take refuge in Allah from the whispers of the devil and life worries. You should also seek Allah`s help and offer a lot of Istigfar (seeking the forgiveness of Allah). And Allah Knows Best.