Could not obtain search results
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 f1.file_id IN (3, 4) AND c.cat_id = f1.file_catid AND f1.file_approved = '1' GROUP BY f1.file_id ORDER BY file_time DESC LIMIT 20
Line : 508
File : pa_search.php