No doubt drunk and needing to be sorted out (10)

I believe the answer is:

disorderly

I'm a little stuck... Click here to teach me more about this clue!

'no' is the definition.
Both the definition and answer are adjectives. Perhaps you can see an association between them that I don't see?

I don't understand the remainder of the clue.

Can you help me to learn more?

(Other definitions for disorderly that I've seen before include "confused?" , "a mess" , "Lacking organisation" , "Companion of drunk" , "Unruly" .)

I've seen this clue in the Evening Standard.

Want a hint initially instead of a full solution? Install my app