[MarkFL]

Originally Posted by hazem_aliraqi

this

PHP Code:

MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number  : 1140 


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?