| |
Couldn't obtain post rating information
DEBUG MODE
SQL Error : 1054 Unknown column 'r.user_id' in 'on clause'
SELECT t.topic_title, t.rating_rank_id AS topic_rating, p.rating_rank_id AS post_rating, t.topic_id, u.username, u.user_id, r.rating_time, ro.label, ro.points AS label2, f.forum_id, p.post_id, f.forum_name, ROUND(AVG(ro.points),1) AS points FROM tp_rating r, tp_topics t, tp_users u, tp_posts p, tp_forums f, tp_users u2, tp_rating_option ro, tp_rating_rank rt LEFT JOIN tp_rating_bias i ON i.user_id = -1 AND r.user_id = i.target_user WHERE r.post_id = p.post_id
AND p.poster_id = u.user_id
AND r.user_id = u2.user_id
AND p.topic_id = t.topic_id
AND t.topic_status = 0
AND t.forum_id = f.forum_id
AND f.auth_view <= 0
AND f.auth_read <= 0
AND r.option_id = ro.option_id AND p.rating_rank_id = rt.rating_rank_id AND (i.bias_status IS NULL OR i.bias_status != 1) GROUP BY p.post_id ORDER BY points DESC, rt.average_threshold DESC LIMIT 60
Line : 299
File : ratings.php |
| |
|
