We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script:
Query: SELECT c.id,
c.username, c.userid, c.date, c.comment, c.rating, c.photo, p.cat, c.approved, c.votes, c.ipaddress, c.hidden,
p.bigimage, c1.catname, p.approved papproved, p.storecat, p.title, p.userid puserid, p.width, p.height, p.date pdate,
p.filesize, p.rating prating, p.views pviews, p.user puser, 0 as hasnotify
FROM
### select from select ###
( SELECT c.id cid
FROM gallery_comments c
JOIN gallery_photos p ON p.id=c.photo
WHERE 0=0
AND p.serialid=0 AND ( /* (!) p.serialid+0 - ignore index */
(p.approved<>0 AND (p.publish_date <> 0 OR p.is_serial=0)) /* typical user */
OR ((p.publish_date<>0 OR p.is_serial=0) AND 0=1) /* admin */
OR 0=p.userid /* user-owner */
) AND p.cat in (510)
AND c.hidden+0=0
ORDER BY c.id DESC
LIMIT 1160, 20 ) as ds
JOIN gallery_comments c ON c.id=ds.cid
JOIN gallery_photos p ON p.id=c.photo
JOIN gallery_categories c1 ON c1.id=p.cat
ORDER BY c.id DESC
Result: Out of resources when opening file '/var/tmp/#sql_5a4_13.MAD' (Errcode: 24)
|
|