get_others_unpublished_posts( int $user_id, string $type = 'any' ): array

694function get_others_unpublished_posts( $user_id, $type = 'any' ) {695	_deprecated_function( __FUNCTION__, '3.1.0' );696 697	global $wpdb;698 699	$editable = get_editable_user_ids( $user_id );700 701	if ( in_array($type, array('draft', 'pending')) )702		$type_sql = " post_status = '$type' ";703	else704		$type_sql = " ( post_status = 'draft' OR post_status = 'pending' ) ";705 706	$dir = ( 'pending' == $type ) ? 'ASC' : 'DESC';707 708	if ( !$editable ) {709		$other_unpubs = '';710	} else {711		$editable = join(',', $editable);712		$other_unpubs = $wpdb->get_results( $wpdb->prepare("SELECT ID, post_title, post_author FROM $wpdb->posts WHERE post_type = 'post' AND $type_sql AND post_author IN ($editable) AND post_author != %d ORDER BY post_modified $dir", $user_id) );713	}714 715	return apply_filters('get_others_drafts', $other_unpubs);716}