We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script:
Query:
SELECT p.id, p.date, p.bigimage, p.cat, p.userid, p.approved, p.storecat, p.height, p.width,
p.ismature, p.is_serial, p.publish_date, p.title
FROM gallery_photos p
WHERE 0=0 AND (p.id>=92365) AND p.cat=514 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 */
)
UNION
SELECT p.id, p.date, p.bigimage, p.cat, p.userid, p.approved, p.storecat, p.height, p.width,
p.ismature, p.is_serial, p.publish_date, p.title
FROM gallery_refcats r
JOIN gallery_photos p ON p.id=r.photoid
WHERE 0=0 AND r.catid=514 AND p.id>=92365 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 */
) ORDER BY id
LIMIT 6
Result: Out of resources when opening file '/var/tmp/#sql_5a4_7.MAD' (Errcode: 24)
|
|