Select all wordpress subscribers in pure SQL
SELECT SQL_CALC_FOUND_ROWS wp_users.*
FROM wp_users INNER JOIN wp_usermeta ON (wp_users.ID = wp_usermeta.user_id)
WHERE 1=1 AND ( (wp_usermeta.meta_key = 'wp_capabilities' AND CAST(wp_usermeta.meta_value AS CHAR) LIKE '%\"Subscriber\"%') )
ORDER BY user_login ASC LIMIT 10