| |
Couldnt Query stat info
DEBUG MODE
SQL Error : 1054 Unknown column 'f1.file_id' in 'on clause'
SELECT f1.*, AVG(r.rate_point) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username, c.cat_id, c.cat_name, COUNT(cm.comments_id) AS total_comments
FROM phpbb_pa_files AS f1, phpbb_pa_cat AS c
LEFT JOIN phpbb_pa_votes AS r ON f1.file_id = r.votes_file
LEFT JOIN phpbb_users AS u ON f1.user_id = u.user_id
LEFT JOIN phpbb_pa_comments AS cm ON f1.file_id = cm.file_id
WHERE c.cat_id = f1.file_catid
AND f1.file_id IN (7488)
AND f1.file_approved = '1'
GROUP BY f1.file_id
ORDER BY file_time DESC Line : 221 File : pa_toplist.php |
| |
|