Query failed: <pre>SELECT 
                    

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.authorid,
                    e.trackbacks,
                    e.isdraft,
                    e.allow_comments,
                    e.last_modified,

                    a.realname AS author,
                    a.username AS loginname,
                    a.email
                     , e.body, e.extended
                     
                FROM
                    csg_entries AS e
                    LEFT JOIN csg_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN csg_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN csg_category c
                        ON ec.categoryid = c.categoryid
                    
                     WHERE e.timestamp &gt;= 1185940800 AND e.timestamp &lt;= 1188619199 AND isdraft = 'false' AND e.timestamp &lt;= 1732254300
                     GROUP BY e.id
                     
                     ORDER BY timestamp DESC
                      LIMIT 50, 25</pre> / Out of resources when opening file '/tmp/#sql_41de_141.MYI' (Errcode: 24)