We who are present not drinking, having no success with wine guide (9)
I believe the answer is:
usherette
'guide' is the definition.
(I know that usherette is a type of guide)
'we who are present not drinking having no success with wine' is the wordplay.
I cannot really see how this works, but
'we' could be 'us' and 'us' is found within the answer.
'present' could be 'here' (both can mean in attendance) and 'here' is located in the answer.
'not drinking' could be 'tt' (short for teetotal) and 'tt' is located in the answer.
A single letter 'e' remains which might be clued in a way I don't see.
This explanation may well be incorrect...
Can you help me to learn more?
(Other definitions for usherette that I've seen before include "Female theatre attendant" , "She shows people to seats" , "Female guide" , "Cinema employee" , "Lady who shows you to your seat in cinema or theatre" .)