Erreur Générale |
|
Couldnt Query category info for parent categories
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, c.cat_allow_ratings, c.cat_allow_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
WHERE c.cat_id = f1.file_catid
AND f1.file_approved = '1'
GROUP BY f1.file_id
ORDER BY file_dls DESC
LIMIT 0, 10
Line : 470 File : pa_toplist.php |
|
|
|
|
|