I'm trying to use a YQL query to fetch players and have them sorted when returned. I've been testing my queries in the console, but no matter what sort conditions I add to the where clause, the returned players are always the same and in the same order. Here is an example of a query I have tried:
SELECT * FROM fantasysports.players WHERE league_key="<league_key>" and sort_type="AR" and sort_season="2010"
I think this should return the top 25 players from last season sorted by rank, however it does not. Can someone help me figure out what I am doing wrong?