Answers.Body: <p>If you have access to a Chess Query Language tool you can use that, albeit I'm not familiar with it. SCID is free and more easily available : <a href="http://scid.sourceforge.net/" rel="nofollow">http://scid.sourceforge.net/</a></p>
  
  <p>1)Open your pgn file </p>
  
  <p>2)Search header rating differences white - black = 200 - 40000</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-23T15:33:24.510Z
Answers.LastActivityDate: 2016-05-23T15:33:24.510Z
Answers.UserDisplayName: Sorin Lascu
Body: <p>I want  to run a query on a chess games collection which would give me games played by strong players vs weak players, let's say games from the first round of Open tournaments (Swiss system) where grandmasters face amateurs, so basically a query for games where rating difference is bigger than x.</p>
  
  <p>What tools would you suggest? what method?  </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-12T06:35:20.970Z
Comments.Text: Chessbase MegaDatabase? Add rating as filter?
Comments.UserDisplayName: SmallChess
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-12T14:57:37.517Z
Comments.Text: @Student T have you tried to run such a query? can you demonstrate how?  from that what I have I don't think it is not possible to build the query in I mean in this tool.  ELO filter under CTRL F window  gives only those 4 options  Elo range  for one/none/both/average.
Comments.UserDisplayName: Michal
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-12T16:05:07.940Z
Comments.Text: What is the games collection format? PGN?
Comments.UserDisplayName: GloriaVictis
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-12T16:18:25.797Z
Comments.Text: A primitive "solution" would be to use chessbase mega database, add rating floor of 2500 for one player, and then sort the results according to rating for one of the players. The games highest/lowest, depending on sorting order, will have big rating differences. However, I'm not sure that this is what you're looking for.
Comments.UserDisplayName: Scounged
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-12T22:10:00.693Z
Comments.Text: @Scounged that would do the trick
Comments.UserDisplayName: Michal
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-15T23:05:23.330Z
Comments.Text: The solution proposed by Scounged does the trick somehow however it returns many unwanted results like "one player above 2500 + second player with a rating close to the first player" or "both above 2500". Does anybody have a better idea?
Comments.UserDisplayName: Michal
Tags: <software><database><programming>
Title: Query for games where the difference of player ratings was big
ThreadText: # Query for games where the difference of player ratings was big
  
  (Asked by: username_0 on 2016-05-11)
  
  I want to run a query on a chess games collection which would give me games played by strong players vs weak players, let's say games from the first round of Open tournaments (Swiss system) where grandmasters face amateurs, so basically a query for games where rating difference is bigger than x.
  
  What tools would you suggest? what method?
  
  **Tags:** software, database, programming
  
  > **Comments:**
  > **username_1**: Chessbase MegaDatabase? Add rating as filter?  
  > **username_0**: @Student T have you tried to run such a query? can you demonstrate how?  from that what I have I don't think it is not possible to build the query in I mean in this tool.  ELO filter under CTRL F window  gives only those 4 options  Elo range  for one/none/both/average.  
  > **username_2**: What is the games collection format? PGN?  
  > **username_3**: A primitive "solution" would be to use chessbase mega database, add rating floor of 2500 for one player, and then sort the results according to rating for one of the players. The games highest/lowest, depending on sorting order, will have big rating differences. However, I'm not sure that this is what you're looking for.  
  > **username_0**: @username_3 that would do the trick  
  > **username_0**: The solution proposed by username_3 does the trick somehow however it returns many unwanted results like "one player above 2500 + second player with a rating close to the first player" or "both above 2500". Does anybody have a better idea?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_4 on 2016-05-23. Score: 3 | Accepted answer
  
  If you have access to a Chess Query Language tool you can use that, albeit I'm not familiar with it. SCID is free and more easily available : <http://scid.sourceforge.net/>
  
  1)Open your pgn file
  
  2)Search header rating differences white - black = 200 - 40000
  
  
  ---
  
  