Boven de alle forumonderwerpen
-->dus boven het woorde ONDERWERPEN
staat nu dit ;HERESELECT topic.FORUMID, topic.TOPICID, topic.SUBJECT, topic.USERID, topic.STATUS, topic.SUBFORUMID, topic.STICKY, topic.LSTAMP, topic.CSTAMP AS TOPIC_CSTAMP, 1073602800 - topic.CSTAMP AS TOPIC_DIFFSTAMP, topic.MSGCNT, topic.OK_MSGCNT,if(LENGTH(lastposter.NICK) > 8,CONCAT(SUBSTRING(lastposter.NICK,1,
,"..."),lastposter.NICK) AS LUSER_NICK,lastposter.NICK AS FULL_LUSER_NICK,LUSERID,topic.FORUMID,forum.SHORT,topic.FORUMID IN (1,2,3,4,5,6,7,8,9,11,12,14,17,18,20,21,22,25,28,29,666) AS IS_ACCESSIBLE,0 AS CONNECT_PARTYID, connect.ID AS HAS_CONNECT, connect.PARTYID AS CONNECT_PARTYID, connect.VALIDATED FROM topic RIGHT JOIN topicsubscription ON topicsubscription.TOPICID=topic.TOPICID LEFT JOIN user AS lastposter ON lastposter.USERID = topic.LUSERID LEFT JOIN forum ON forum.FORUMID = topic.FORUMID LEFT JOIN connect ON connect.TYPE="topic" AND connect.ID=topic.TOPICID WHERE topicsubscription.USERID=14008 AND topic.MSGCNT!=0

-->dus boven het woorde ONDERWERPEN
staat nu dit ;HERESELECT topic.FORUMID, topic.TOPICID, topic.SUBJECT, topic.USERID, topic.STATUS, topic.SUBFORUMID, topic.STICKY, topic.LSTAMP, topic.CSTAMP AS TOPIC_CSTAMP, 1073602800 - topic.CSTAMP AS TOPIC_DIFFSTAMP, topic.MSGCNT, topic.OK_MSGCNT,if(LENGTH(lastposter.NICK) > 8,CONCAT(SUBSTRING(lastposter.NICK,1,











