I'm trying to get all of the players named "Justin" in a given league.

Using YQL Console I use the statement:

select * from fantasysports.players where league_key='238.l.1785' and search='Justin'

Also, I am going to want to limit and offset this, but put appears as though limit = 10 does not work, not does limit = 10, offset = 10