Abdullah bin Amr bin As reported,

The Messenger of Allah ﷺ said, "Whoever drinks wine and becomes intoxicated, his prayer will not be accepted for forty mornings, and if he dies, he will enter the Fire. If he repents, Allah will accept his repentance. If he returns and drinks again and becomes intoxicated, his prayer will not be accepted for forty mornings, and if he dies, he will enter the Fire. If he repents, Allah will accept his repentance. If he returns and drinks again and becomes intoxicated, his prayer will not be accepted for forty mornings, and if he dies, he will enter the Fire. If he repents, Allah will accept his repentance. But if he returns yet again, it is binding upon Allah to give him to drink from the Radghat al-Khabal on the Day of Resurrection."They asked, "Messenger of Allah, what is Radghat al-Khabal?"He replied, "The pus of the people of the Fire."

Azami 7006

Sahih

عن عبد الله بن عمرو بن العاص قال

قال رسول الله ﷺ: من شرب الخمر وسكر لم تقبل له صلاة أربعين صباحا، وإن مات دخل النار، فإن تاب تاب الله عليه وإن عاد فشرب فسكر لم تقبل له صلاة أربعين صباحا، فإن مات دخل النار، فإن تاب تاب الله عليه. وإن عاد فشرب فسكر لم تقبل له صلاة أربعين صباحا، فإن مات دخل النار، فإن تاب تاب الله عليه. وإن عاد كان حقا على الله أن يسقيه من ردغة الخبال يوم القيامة قالوا: يا رسول الله، وما ردغة الخبال؟ قال: عصارة أهل النار.

الأعظمي 7006صحيح
Contents
Reference
Commentary
Ayat
Collection
Jami al-Kamil
Book
Legal punishments
Chapter
Drinking wine and the hadd punishment for it
Section
Discouragement from drinking wine
Numbering
Jami al-Kamil 7006 (2nd edition)
Azami 7006