Showing all post from all post type in admin backstage

You can use a $wpdb->get_results for this. I am not an mySQL expert so I will give you the pseudo code instead

global $wpdb;
$data = $wpdb->get_results(
    SELECT posts.ID ID, posts.post_title title, posts.post_author author, postmeta.isbn isbn
    FROM $wpdb->posts posts
    JOIN $wpdb->postmeta postmeta
        ON posts.ID = postmeta.post_id
    WHERE posts.post_type="post_type_1" OR 'post_type_2' OR 'post_type_3'
    GROUP BY posts.ID
    ORDER BY ".$orderby." ".$order." LIMIT ".$offset.",".$per_page,'ARRAY_A' ); 
)