title: SQL Query to Get Users With Role Subscriber
body: <p>I haven't got any luck with my SQL query to get users with role subscriber:</p>
  
  <pre><code>SELECT 
        ID, 
        display_name 
  FROM 'wp_users' 
  INNER JOIN 'wp_usermeta' ON 'wp_users'.ID = 'wp_usermeta'.user_id 
  WHERE 'wp_usermeta'.meta_key = 'wp_capabilities' 
  AND ('wp_usermeta'.meta_value LIKE 'subscriber') ORDER BY display_name
  </code></pre>
  
  <p>Can any body help me?</p>