Need Help with modifying MySQL query code

Hi all,
I like to exclude a few users from displaying on the Mod_Topmembers by JomSocial.

Below is the query code. Can someone help me to add a clause where I can exclude Userid = 42,43, etc. ? I appreciate it.

class modTopMembersHelper
{
   function getMembersData( &$params )
   {
      $model   =& CFactory::getModel( 'user' );
      $db    =& JFactory::getDBO();
      
      $limit   = $params->get('count', '5');
      
      $query   = 'SELECT ' . $db->nameQuote( 'userid' ) . ' FROM ' . $db->nameQuote( '#__community_users' ) . ' AS a '
            . ' INNER JOIN ' . $db->nameQuote( '#__users' ) . ' AS b ON a.' . $db->nameQuote('userid').'=b.' . $db->nameQuote('id')
            . ' WHERE ' . $db->nameQuote('thumb') . '!=' . $db->Quote('components/com_community/assets/default_thumb.jpg') . ' '
            . ' AND ' . $db->nameQuote( 'block' ) . '=' . $db->Quote( 0 ) . ' '
            . ' ORDER BY ' . $db->nameQuote( 'points' ) . ' DESC '
            . ' LIMIT ' . $limit;

Code (markup):

 

Below

            . ' AND ' . $db->nameQuote( 'block' ) . '=' . $db->Quote( 0 ) . ' '

PHP:

try adding

            . ' AND ' . $db->nameQuote( 'userid' ) . ' NOT IN (42,43,44,45,46) '

PHP:

Never used Jomsocial/joomla, but i think this should work

 

Thank you so much Basti that works like a charm!

 

Good it worked on the first try

 

Nothing ever works on the first try. What kind of magic do you practice?