SELECT SQL_CALC_FOUND_ROWS `wp_users` . * FROM `wp_users` WHERE ? = ? AND `wp_users` . `ID` IN ( SELECT DISTINCTROW `wp_posts` . `post_author` FROM `wp_posts` WHERE `wp_posts` . `post_status` = ? AND `wp_posts` . `post_type` IN (...) ) ORDER BY `display_name` ASC LIMIT ?, ... 