title: SQL select count of items that not in other table with additional column check
body: <p>The title doesn't make sense because it's hard to explain what I want in the title, <a href="https://stackoverflow.com/questions/23964041/selecting-if-all-row-ids-exists-in-other-table-with-column-check">you can read this because it was explained and answered here</a></p>
  
  <p>So I have the following query:</p>
  
  <pre><code>SELECT COUNT(*) AS missing
  FROM sites
  WHERE id NOT IN (
               SELECT DISTINCT site_id
               FROM callback_votes
               WHERE ip='84.108.27.143')
  </code></pre>
  
  <p>This returns the amount of sites that haven't been voted on, returns 0 if voted on all. (see the link, it's explained)</p>
  
  <p>But in the database, I have site type that has a column named <code>module</code>, so what I want to do  is, check if sites.module equals to 'none', then count it as NOT IN, like it does in that query.</p>
  
  <p>So let's say you have 2 sites in the db, you never voted for any - this query will return <code>2</code> but with the 'none' check, it will only return <code>1</code> because one of the sites have module set to 'none'. <a href="https://stackoverflow.com/questions/23980350/sql-checking-if-exists-in-other-table-if-not-then-check-its-type">Very similar to what I asked few minutes ago</a>, but it's pretty complex in this case </p>
  
  <p>I tried doing things like this:</p>
  
  <pre><code>SELECT COUNT(*) AS missing
  FROM sites
  WHERE id NOT IN (
               SELECT DISTINCT site_id
               FROM callback_votes
               WHERE ip='84.108.27.143')
           OR module = 'none'
  </code></pre>
  
  <p>But no luck.</p>
  
  <p><strong>Is there a way to do this in this query?</strong></p>