|
Could not query pic information
DEBUG MODE
SQL Error : 1055 'c0charterforum.p.pic_filename' isn't in GROUP BY
SELECT p.*, ac.*, u.user_id, u.username, u.user_rank, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT( DISTINCT c.comment_id) AS comments_count
FROM german_album_cat AS ac, german_album AS p
LEFT JOIN german_users AS u ON p.pic_user_id = u.user_id
LEFT JOIN german_album_comment AS c ON p.pic_id = c.comment_pic_id
LEFT JOIN german_album_rate AS r ON p.pic_id = r.rate_pic_id
WHERE pic_id = '364'
AND ac.cat_id = p.pic_cat_id
GROUP BY p.pic_id
LIMIT 1
Line : 433 File : album_showpage.php |
|
|