We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script:
Query:
SELECT p.id,p.user,p.userid,p.cat,p.storecat,p.date,p.title,p.description,p.ismature,p.keywords,p.bigimage,p.width,p.height,p.filesize,
p.views,p.medwidth,p.medheight,p.medsize,p.approved,p.rating,p.votes,p.allowprint,p.numcom,p.lastposter,
(case when (p.cat=509) then p.disporder else 99999 end) disporder, p.lastpost, p.is_serial, p.publish_date, p.hideowner
FROM gallery_photos p
LEFT JOIN gallery_categories c ON c.id=p.cat
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=509
UNION
SELECT p.id,p.user,p.userid,p.cat,p.storecat,p.date,p.title,p.description,p.ismature,p.keywords,p.bigimage,p.width,p.height,p.filesize,
p.views,p.medwidth,p.medheight,p.medsize,p.approved,p.rating,p.votes,p.allowprint,p.numcom,p.lastposter,
(case when (p.cat=509) then p.disporder else 99999 end) disporder, p.lastpost, p.is_serial, p.publish_date, p.hideowner
FROM gallery_photos p
JOIN gallery_refcats r ON r.photoid=p.id AND r.catid=509
JOIN gallery_categories c ON c.id=p.cat
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 */
)
ORDER BY disporder,date DESC
LIMIT 50, 25
Result: Out of resources when opening file '/var/tmp/#sql_5a4_7.MAD' (Errcode: 24)
|
|