In a hoop

adj.

Heard in Tipperary, Wicklow and Mayo

In a terrible state, usually incapacitated or paralytic from drink.

In use

He was in a hoop last nite and fell asleep upside down in a ditch.

Posh English

He was considerably inebriated last night and fell asleep inverted within a ditch.

Same phrase, other counties