A printed version of the article

Added by: sCRiPTz-TEAM.iNFO Mon, 16 August 2010

They are ordered by submissions, but the query itself is ordered by the index file_submitter.

//-----------------------------------------
		// Top 10 submitters
		//-----------------------------------------
		
		$this->DB->build( array(
									'select'	=> 'COUNT(file_id) as submissions, MAX(file_id) as last_id, file_submitter',
									'from'		=> 'downloads_files',
									'group'		=> 'file_submitter',
									'limit'		=> array( 10 )
							)		);

Should be

//-----------------------------------------
		// Top 10 submitters
		//-----------------------------------------
		
		$this->DB->build( array(
									'select'	=> 'COUNT(file_id) as submissions, MAX(file_id) as last_id, file_submitter',
									'from'		=> 'downloads_files',
									'group'		=> 'file_submitter',
									'order'		=> 'submissions DESC',
									'limit'		=> array( 10 )
							)		);

Source: http://community.invisionpower.com/tracker/issue-24831-top-10-submissions-statistics-not-ordered/