title: wordpress generated SQL gets me a duplicated posts
body: <p>This question is about SQL, and little bit related to wordpress</p>
  <p>for some reason when i use pagination, the next pages show some posts from the previous page (not always)</p>
  <p>This is the SQL query generated by native wordpress class WP_Query</p>
  <pre><code>SELECT SQL_CALC_FOUND_ROWS  eepir_posts.ID FROM eepir_posts  INNER JOIN eepir_postmeta ON ( eepir_posts.ID = eepir_postmeta.post_id ) WHERE 1=1  AND ( 
    ( eepir_postmeta.meta_key = 'is_english' AND eepir_postmeta.meta_value != '1' )
  ) AND eepir_posts.post_type = 'new' AND (eepir_posts.post_status = 'publish' OR eepir_posts.post_status = 'acf-disabled' OR eepir_posts.post_status = 'private') GROUP BY eepir_posts.ID ORDER BY eepir_posts.post_date DESC LIMIT 12, 4
  </code></pre>
  <p>I took this SQL and run it, and each time i run it, i get different results</p>
  <p><a href="https://snipboard.io/rvoZ7D.jpg" rel="nofollow noreferrer">https://snipboard.io/rvoZ7D.jpg</a></p>
  <p><a href="https://snipboard.io/W4qfid.jpg" rel="nofollow noreferrer">https://snipboard.io/W4qfid.jpg</a></p>
  <p><a href="https://snipboard.io/FCDgoL.jpg" rel="nofollow noreferrer">https://snipboard.io/FCDgoL.jpg</a></p>