global $wpdb, $user_ID;
$rating_userid = intval($user_ID);
// Check User ID From IP Logging Database
//$get_rated = $wpdb->get_results(“SELECT wids.ID FROM (SELECT $wpdb->posts.ID FROM $wpdb->posts WHERE $wpdb->posts.post_parent = ’0′ AND $wpdb->posts.post_type=’post’ AND $wpdb->posts.ID NOT IN (SELECT $wpdb->ratings.rating_postid FROM $wpdb->ratings WHERE rating_userid = rating_userid)) wids LEFT JOIN $wpdb->postmeta ON (wids.ID=$wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key=’ratings_average’) ORDER BY $wpdb->postmeta.meta_value DESC”);

/*$get_rated = $wpdb->get_results(“SELECT ID FROM (SELECT $wpdb->posts.ID FROM $wpdb->posts WHERE $wpdb->posts.post_parent = ’0′ AND $wpdb->posts.post_type=’post’ AND $wpdb->posts.ID NOT IN (SELECT $wpdb->ratings.rating_postid FROM $wpdb->ratings WHERE rating_userid = $rating_userid)) LEFT JOIN $wpdb->postmeta ON “);*/

$get_rated = $wpdb->get_results(“SELECT $wpdb->posts.ID FROM $wpdb->posts WHERE $wpdb->posts.post_parent = ’0′ AND $wpdb->posts.post_type=’post’ AND $wpdb->posts.post_status=’publish’ AND $wpdb->posts.ID NOT IN (SELECT $wpdb->ratings.rating_postid FROM $wpdb->ratings WHERE rating_userid = $rating_userid) ORDER BY $wpdb->posts.post_date DESC”);

global $id;
$temp = $id;
foreach ($get_rated as $get_rateds) {

$id = $get_rateds->ID;
$post_id_7 = get_post($id, ARRAY_A);
$title = $post_id_7['post_title'];
$linke= get_permalink($id);
$values = get_post_custom_values(“resim”);
if ($values[0]!=”"){
$values = get_post_custom_values(“resim”);
echo ““;
}

echo ““.$title.”” ;
if(function_exists(‘the_ratings’)) { the_ratings(); }
echo “

“;

}
$id=$temp;

?>