I am expecting for only 5 rows based on my query, however, it returns 25 rows. How is this happen? Can anyone help me with my statement. Below is my SQL statement

SELECT subcriteria.id, subcriteria.criteria, subcriteria.percentage, tally.score FROM tally
INNER JOIN subcriteria ON subcriteria.awardid=tally.categoryid WHERE tally.contestantid=1
AND tally.categoryid=1 AND tally.judgeid='1' AND tally.competitionid='00001'