Utopist
MF veteraan
SQL error: Can't create/write to file '/tmp/MYvuKr0b' (Errcode: 13) SELECT topic.topic, topic.icon, topic.title, topic.last, start, topic.reply, view, sticky, topic.hide, announce, closed, user.name, topic.user, forum.name AS forum, private, forum.forum AS forumid, abbreviation, lastusertbl.name AS lastpostusername FROM topic LEFT JOIN forum USING (forum) LEFT JOIN user ON user.user=topic.user LEFT JOIN user AS lastusertbl ON lastusertbl.user=topic.lastuser WHERE topic.forum='1' AND last>UNIX_TIMESTAMP()-(showdays*86400) OR (topic.sticky <> 'N' AND topic.forum = '1') ORDER BY REPLACE(REPLACE(REPLACE(sticky, 'N', '0'), 'F', '1'), 'Y', '2') DESC, REPLACE(REPLACE(closed, 'N', '0'),'Y', '1') ASC, last DESC