I am using the mail table set in YQL and noticing a strange issue that seems to be the result of how the fid is URL encoded.

Here is the select that I am performing.

select messageInfo.receivedDate, messageInfo.mid, folder.folderInfo.fid from ymail.messages where fid in (select folder.folderInfo.fid from ymail.folders where folder.total > 0)  

Normally, this works just fine. But if I have created a folder in Yahoo that is anything but alphanumeric - for instance I make a folder named "Test 1" (no quotes) - then the messages in that folder are excluded from the result set. My guess is that this is a result of how the actual fid on the folder gets url encoded to "Test%201" when selected.

Is there some way to ensure that this join works even if the folder fid is some form of url encoded name?