Motherlode 2009
But it gives me this error:
General Error
Couldnt Query file info
DEBUG MODE
SQL Error : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
SELECT f.*, AVG(r.rate_point) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username, COUNT(c.comments_id) as total_comments FROM phpbb_pa_files AS f LEFT JOIN phpbb_pa_votes AS r ON f.file_id = r.votes_file LEFT JOIN phpbb_users AS u ON f.user_id = u.user_id LEFT JOIN phpbb_pa_comments AS c ON f.file_id = c.file_id WHERE f.file_id = 59 AND f.file_approved = 1 GROUP BY f.file_id
Line : 64
File : pa_file.php
