Standings - AAA Junior Boys Basketball Playoffs

Failed Query: SELECT DISTINCT standings.leagueid AS leagueid, schools.schoolid AS schoolid, subschoolid, schoolname, classification, imgurl, websiteurl, points,srank FROM sports, schools, standings, leagues WHERE INSTR(UPPER(sportName), UPPER('Basketball')) > 0 AND sports.sportid = leagues.sportid AND LENGTH(playoffLeague) = 0 AND leagues.leagueid = standings.leagueid AND genderID = '1' AND levelID = '1' AND schools.schoolid = standings.schoolid AND standings.schoolid IN(SELECT schoolid FROM standings WHERE leagueid = 79) AND realschool = 1<br>SQL Error: Unknown column 'srank' in 'field list'