The time now is Thu 20 Jun, 2013 09:35
Could not query recent pics information
DEBUG MODE
SQL Error : 1030 Got error 28 from storage engine
SELECT p.*, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
FROM ip_album AS p
LEFT JOIN ip_users AS u ON p.pic_user_id = u.user_id
LEFT JOIN ip_album_cat AS ct ON p.pic_cat_id = ct.cat_id
LEFT JOIN ip_album_rate AS r ON p.pic_id = r.rate_pic_id
LEFT JOIN ip_album_comment AS c ON p.pic_id = c.comment_pic_id
WHERE ( p.pic_approval = 1 OR ct.cat_approval = 0 )
GROUP BY p.pic_id
ORDER BY pic_time DESC
LIMIT 4
Line : 1394 File : album_hierarchy_sql.php |
|