I've got a table that saves the rankings for every publish, the table appears like this http://d.pr/YIxL it saves the ID from the publish and also the rating, I have to query the posts according to that table ASC or DSC.

Sorry for my damaged british, Hopefully the reply is obvious. Thanks!

It was the query that have been effective

        $wp_query->request = "
        SELECT $wpdb->posts.* FROM $wpdb->posts
        Left join $ratings_table
        ON $wpdb->posts.ID = $ratings_table.ID
        $wpdb->posts.post_type =  'games' AND $wpdb->posts.post_status =  'publish'
        ORDER BY $ratings_table.points DESC
        LIMIT $ppp OFFSET $offset";

    $pageposts = $wpdb->get_results($wp_query->request, OBJECT);