Need help searching tickets by requestor custom field

Hello,

I’ve defined a custom field on Users

I now need to search for Tickets requested by the Users with certain values within that custom field

I’d like to know the way to do this with TicketSQL because I’m going to be writing it into a portlet

thanks
al;