LostCore
7/27/2014 - 8:52 PM

Select all wordpress subscribers in pure SQL

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