[hazem_aliraqi]

Originally Posted by MarkFL

This is the query:

PHP Code:

    $myfeatured = $vbulletin->db->query_first("
        SELECT COUNT(*) AS thread_count, thread.postuserid
        FROM " . TABLE_PREFIX . "thread AS thread
        INNER JOIN " . TABLE_PREFIX . "featuredthreads AS featuredthreads
        ON thread.threadid = featuredthreads.threadid
        WHERE thread.postuserid = " . $post['userid']
    ); 


I use "COUNT" all the time without a "GROUP BY" clause. What MySQL version are you using?

version 5.0.51