[Konstantinos]

An example of selecting all the players (their name only) that are inactive for 1 or more years:

pawn Код:

SELECT name FROM players WHERE TIMESTAMPDIFF(YEAR, last_login, NOW()) >= 1;