title: Avoid SQL WHERE NOT IN Clause
body: <p>I have 3 tables listed below:</p>
  
  <pre><code>Blog    BlogArticle  Article
  ----    -----------  -------
          id
  id------blog_id      -id
  title   article_id__/ title
  </code></pre>
  
  <p>This SQL describe what I want:</p>
  
  <pre><code>SELECT * 
  FROM  `article` 
  WHERE  `article`.`id` NOT IN (
          SELECT CONCAT(`blog_article`.`article_id`) 
          FROM  `blog_article` 
          WHERE  `blog_article`.`blog_id` = 1 -- example value
         )
  </code></pre>
  
  <p>The problem is, I have a big NOT IN values in that case, and as far as i know it will impact to server performance (I'm not sure since I've never try to benchmark or Google it). Any suggestion?</p>