title: Query not workin
body: <p>I have this query,</p>
  
  <pre><code>SELECT DISTINCT username, publishedapp
  FROM tbl_name
  WHERE username in
  (
    SELECT username
    FROM tbl_name
    WHERE publishedapp = \"Mencap@Work2-1\"
  )
    AND publishedapp  NOT LIKE \"%Desktop%\"
    AND publishedapp  NOT LIKE \"%RDP%\"
  GROUP BY username
  HAVING COUNT(DISTINCT publishedapp) &gt; 1
  </code></pre>
  
  <p>which works perfectly on a db,table but not in another, the DBs have the same type of content just the one which doesn't work on has more row as it has been gathering information for longer time.</p>
  
  <p>on the newer table im getting 0 as result to the query, the table definitely has content as I've seen the rows and columns on PHPMyadmin and also have user run this query</p>
  
  <pre><code>SELECT username, publishedapp
  FROM tbl_name
  ORDER BY username
  </code></pre>
  
  <p>The original table
  <a href="https://i.stack.imgur.com/0Ll6z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0Ll6z.png" alt="enter image description here"></a></p>
  
  <p>The new table
  <a href="https://i.stack.imgur.com/veoA5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/veoA5.png" alt="enter image description here"></a></p>
  
  <p>Im specting something like this coming out
  <a href="https://i.stack.imgur.com/VYcYF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VYcYF.png" alt="enter image description here"></a></p>
  
  <p>Any ideas what could this be?</p>