$threads in FORUMDISPLAY and DISTINCT ?

[VBDev]

So, I made modifications for a hack and I need 2 more fields I'd like to get with this query :

PHP Code:

        SELECT $votequery $previewfield
            thread.threadid, thread.title AS threadtitle, lastpost, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
            lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach
            " . iif($vboptions['threadsubscribed'] AND $bbuserinfo['userid'], ", NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed") . "
            " . iif(!$deljoin, ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, 
                deletionlog.username AS del_username, deletionlog.reason AS del_reason") . "
        FROM " . TABLE_PREFIX . "thread AS thread
        " . iif(!$deljoin, " LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')") . "
        " . iif($vboptions['threadsubscribed'] AND $bbuserinfo['userid'], " LEFT JOIN " . TABLE_PREFIX . "subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = $bbuserinfo[userid])") . "
        $previewjoin
        WHERE thread.threadid IN (0$ids)
        ORDER BY sticky DESC, $sqlsortfield $sqlsortorde 


I need these fields : nb_install and userid from tables hacks and hacksinstall, so I modify to have :

PHP Code:

        SELECT $votequery $previewfield
            thread.threadid, thread.title AS threadtitle, lastpost, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
            lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach
            " . iif($vboptions['threadsubscribed'] AND $bbuserinfo['userid'], ", NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed") . "
            " . iif(!$deljoin, ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, hacks.nb_install, i.userid,
                deletionlog.username AS del_username, deletionlog.reason AS del_reason") . "
        FROM " . TABLE_PREFIX . "thread AS thread
        " . iif(!$deljoin, " LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')") . "
        " . iif($vboptions['threadsubscribed'] AND $bbuserinfo['userid'], " LEFT JOIN " . TABLE_PREFIX . "subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = $bbuserinfo[userid])") . "
        LEFT JOIN " . TABLE_PREFIX . "hacks AS hacks ON(hacks.threadid=thread.threadid)
        LEFT JOIN ". TABLE_PREFIX ."hacks_install AS i ON (i.userid=$bbuserinfo[userid])
        $previewjoin
        WHERE thread.threadid IN (0$ids)
        ORDER BY sticky DESC, $sqlsortfield $sqlsortorder 


The problem is that I get back each thread twice :ermm:

How to do so that I get back them only once ?
Thanks by advance

[filburt1]

You answered your own question in the subject: use SELECT DISTINCT instead of SELECT to avoid duplicate rows, although often the solution lies in refining the query itself.

[VBDev]

Ok, I'll try using a DISTINCT on threadid so