scrag-ended

adj.

The state of being drunk and reduced to the least elegant portion of the sofa.

Source: Wiktionary