I've just installed and I got this from showthread
PHP Code:
SELECT a.*, au.*, post.userid, post.postid
FROM new_post AS post
INNER JOIN new_award_user AS au ON (au.userid=post.userid)
INNER JOIN new_award AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,61944)
GROUP BY au.issue_id
ORDER BY au.issue_time DESC;
MySQL Error : Unknown column 'au.award_id' in 'on clause'
Error Number : 1054