|
Could not query users
DEBUG MODE
SQL Error : 1055 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'allyie_nature.p.pic_title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT u.username, u.user_id, u.user_regdate, COUNT(p.pic_id) AS pics, p.pic_title, p.pic_time, MAX(p.pic_id) AS last_pic
FROM orion_users AS u, orion_album as p
WHERE u.user_id <> -1
AND u.user_id = p.pic_user_id
AND p.pic_cat_id = 0
GROUP BY user_id
ORDER BY last_pic DESC LIMIT 0, 24
Line : 424 File : album.php |