Custom wpdb query – how to sort post by another table meta_count

<?php
 $querystr = "SELECT {$wpdb->posts}.ID,
                     {$wpdb->posts}.post_title,
                     {$wpdb->prefix}stt2_meta.meta_count
        FROM {$wpdb->posts}, {$wpdb->prefix}stt2_meta
        WHERE {$wpdb->posts}.post_type="post"
          AND {$wpdb->posts}.post_status="publish"
          AND {$wpdb->posts}.ID IN ( SELECT post_id FROM {$wpdb->prefix}stt2_meta )
        ORDER BY {$wpdb->prefix}stt2_meta.meta_count DESC
        LIMIT 10;";
 $pageposts = $wpdb->get_results($querystr, OBJECT);
?>