| |
Could not query recent pics information
DEBUG MODE
SQL Error : 1030 Got error 134 from storage engine
SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
FROM bb_album AS p
LEFT JOIN bb_users AS u ON p.pic_user_id = u.user_id
LEFT JOIN bb_album_cat AS ct ON p.pic_cat_id = ct.cat_id
LEFT JOIN bb_album_rate AS r ON p.pic_id = r.rate_pic_id
LEFT JOIN bb_album_comment AS c ON p.pic_id = c.comment_pic_id
WHERE p.pic_cat_id IN (1,49,2,3,4,5,226,42,53,57,64,74,75,85,87,91,101,103,106,108,110,115,116,127,130,133,138,141,291,149,157,168,179,183,192,195,209,215,219,232,233,238,246,247,255,261,267,268,269,290,300,306,313,316,322,323,327,334,342,348,355,356,360,367) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 )
GROUP BY p.pic_id
ORDER BY pic_time DESC
LIMIT 12
Line : 1171 File : album_hierarchy_sql.php |
| |
|