Wont show up with "Recent Threads On Index"

[ollie2015]

Quote:$query = $db->query("
            SELECT t.*, u.username AS userusername, u.usergroup, u.displaygroup, u.avatar as threadavatar, u.avatardimensions as threaddimensions, lp.usergroup AS lastusergroup, lp.avatar as lastavatar, lp.avatardimensions as lastdimensions, lp.displaygroup as lastdisplaygroup
            FROM ".TABLE_PREFIX."threads t
            LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)
            LEFT JOIN ".TABLE_PREFIX."users lp ON (t.lastposteruid=lp.uid)
            WHERE 1=1 $where AND t.visible > {$approved} {$unsearchableforumssql} {$ignoreforums}
            ORDER BY t.lastpost DESC
            LIMIT $threadlimit
        ");

how can the custom plugin call the data? from which table?

cheers