The Messenger of Allah ﷺ said, "A prayer in this mosque of mine is better than a thousand prayers in any other mosque, except for the Sacred Mosque."
حدثنا الأنصاري حدثنا معن حدثنا مالك ح و حدثنا قتيبة عن مالك عن زيد بن رباح وعبيد الله بن أبي عبد الله الأغر عن أبي عبد الله الأغر
أن رسول الله ﷺ قال صلاة في مسجدي هذا خير من ألف صلاة فيما سواه إلا المسجد الحرام
Agreed upon by Bukhari and Muslim. Bukhari transmitted it in "The Virtue of Prayer in the Masjid of Makkah and Madinah," section (1), no. 1190, from the hadith of Malik. Muslim transmitted it, no. 1394, from the hadith of Ubaydullah Al-Aghar, on his authority. It is also in the Muwatta (1/196, Yahya's recension).There are also reports on this topic from Ali [Harith bin Abu Usama, as found in Matalib Aliyah, no. 1259], Maymuna [Muslim, no. 1396], Abu Saeed [coming up, no. 326], Jubayr bin Mutim [Ahmad, 4/80], Abdullah bin Zubayr [Ahmad, 5/4], Ibn Umar [Muslim, no. 1395], and Abu Dharr [Tabarani in Al-Awsat, 7/495, no. 6979].