arse ended

adj.

The state of being drunk and reduced to the inferior end of every arrangement, including the queue.

Sparky was arse ended, last into the taxi and first to lose the receipt.

Source: Wiktionary