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 Where $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);