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
Student Experience Awards 2017
From our trusted community of 76,702 students, we've collected thousands of reviews to highlight the excellent experience that higher education offers.