nJ0zU80r

1$create_table_query = "CREATE TABLE IF NOT EXISTS " . $wpdb->prefix . "mr_ratings (
2    `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
3    `meta_id` bigint(20),
4    `user_id` bigint(20),
5    `rating` tinyint(1) DEFAULT 0 NOT NULL,
6    `voted` tinyint(1) DEFAULT 0 NOT NULL,
7    `r_comment` text,
8    `rated_date`  DATETIME DEFAULT CURRENT_TIMESTAMP
9    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
10	
11$sql = "SELECT meta_id, COUNT(voted) AS votes FROM ". $wpdb->prefix . "mr_ratings GROUP BY meta_id ORDER BY votes DESC LIMIT 5";