WHERE do SQL returns unwanted values

Question

SELECT x, y, z, f , g , h 
FROM torrents
INNER JOIN w ON w = x
WHERE y =  '2' OR y =  '7'
AND  f =  '1'
AND h < 4294967296

I named the f = '1' in the where so that he returns to me only the values with f = 1 only it returns values with 0 and also returns values with the larger size.

Ex:

Answer 1

If the OR is only in the Y, needs parentheses, if any y = 2 returns, regardless of the values of f and h.

Other than that, you have to see if JOIN is correct, it would be better not to use equal names in fields and tables.

Possible solution (correct the tabela1.w for the name of the right field):

SELECT x, y, z, f , g , h 
FROM torrents AS tabela1
INNER JOIN w  AS tabela2
           ON tabela1.w = tabela2.x
WHERE ( y =  '2' OR y =  '7' )
AND  f =  '1'
AND h < 4294967296

If you want to make it a little more elegant, you can use IN and remove the quotation marks:

SELECT x, y, z, f , g , h 
FROM torrents
INNER JOIN w ON w = x
WHERE y IN ( 2, 7 )
      AND f = 1
      AND h < 4294967296