From 9,243 students reviews

  • #
  • Region
  • University (Reviews)
  • Star Rating
  • Score
  • Save
  • Recommended
SELECT ROUND(SUM(univ_course_quality + accomodation_area + emp_placement + sports_nightlife)/4, 2) AS r, p.*, ucsite_posts.ID FROM `univ_rating` p INNER JOIN `ucsite_posts` ON (`p`.`post_id` = `ucsite_posts`.`ID`) inner join ucsite_postmeta as cu ON (`ucsite_posts`.ID = cu.post_id and cu.meta_key = 'enable_hogwarts') WHERE (cu.meta_value NOT like '%Enable Hogwarts%') and total_reviews>24 GROUP BY ucsite_posts.ID ORDER BY DESC