get_col(" SELECT user_id FROM wp_usermeta WHERE meta_key = 'wp_capabilities' AND meta_value RLIKE '[[:<:]]author[[:>:]]' ORDER BY user_id DESC; "); ?> get_var("SELECT ID FROM $wpdb->posts WHERE post_status = 'publish' AND post_author = '$author_id'"); ?> get_var("SELECT user_nicename FROM $wpdb->users WHERE ID = '$author_id'"); $authorname = $wpdb->get_var("SELECT display_name FROM $wpdb->users WHERE ID = '$author_id'"); ?>