$query = "SELECT *
        FROM `{$wpdb->prefix}wti_like_post` L
        JOIN `{$wpdb->prefix}posts` P1 ON L.post_id = P1.ID
        JOIN `{$wpdb->prefix}postmeta` P2 ON L.post_id = P2.post_id
        JOIN `{$wpdb->prefix}users` U ON P1.post_author = U.ID
        WHERE value > 0
        GROUP BY L.post_id
        ORDER BY SUM(value) DESC, post_title
        LIMIT 10";