Code: Select all
Query failed:
SELECT
ep_sticky.value AS orderkey,
e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.author,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,
a.realname AS author,
a.email
FROM
blog_entries AS e
LEFT JOIN blog_authors a
ON e.authorid = a.authorid
LEFT JOIN blog_entrycat ec
ON e.id = ec.entryid
LEFT JOIN blog_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN blog_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN blog_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1))
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 0, 12
/ Got error 28 from table handler-M