limit left join to 1 record

[h2ojunkie]

Maybe I'm going about this all wrong, but basically I'm trying to add to showthread_query to check if the user has any public albums so I can check for the albums using a conditional in the postbit.

I was trying to just LEFT JOIN, but if the user has more than one public album, I end up with too many results.

I need to limit the result to just the 1st public album for that user or else I end up with posts duplicating on showthread

This is far as I can get

For: showthread_query $hook_query_fields

,album.userid AS hasalbums

And for: showthread_query $hook_query_joins

LEFT JOIN " . TABLE_PREFIX . "album AS album ON(album.userid = post.userid AND album.state = 'public')

How would I limit the join to one result?

Or is there a better way to just fine out if the user has any public albums. I don't really need the albumid..i just need to establish if they have any public albums at all.