What is the stance of Ahlus-Sunnah wal-Jama'ah regarding the historical figure known as 'the Sufyani,' who some say will appear at the end of times? And what is the stance of Ahlus-Sunnah wal-Jama'ah regarding the group that killed Al-Husayn ibn Ali (may Allah be pleased with them), particularly those who directly committed the killing, severed his head, and killed members of his family?
Most of the narrations about the signs of the Hour concerning the Sufyani, who is said to appear before the Mahdi, indicate that he is the leader of the army that will invade the Kaaba, and Allah will cause the earth to swallow them. We disassociate ourselves before Allah from those who killed Al-Husayn Ibn Ali (may Allah be pleased with them), supported his killing, or encouraged it, whether openly or secretly. The inner matters are left to Allah alone. And Allah The Almighty Knows Best.
I wish to Pray at the Mosque, but I couldn't because I am a Woman. How can I get such a Reward?
All perfect praise be to Allah The Lord of The Worlds, and may His peace and blessings be upon our Prophet Muhammad and upon all of his family and companions Abdullah Ibn Masood (May Allah be Pleased with him) reported that the Prophet (PBUH) said: "Her prayer inside her home is better than its courtyard, and her prayer in her own bedroom is better than inside her home." [Abu Dawood]. Her staying at home, and not going to the mosque in obedience to Allah`s injunctions entails a great reward similar to that bestowed on a man for going to the mosque since the Mercy and Blessings of Allah Prevails. And Allah Knows Best.
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 it permissible to offer Istikhara prayer (seeking guidance) after Witr Prayer (A confirmed Sunnah which is offered after Isha prayer and before Fajir prayer with a minimum of 3 Rak`as and a maximum of 11)?
It is permissible to offer Istikhara before and after Witr prayer as it is permissible at any time except that in which prayer is disliked. And Allah Knows Best.