Anonymous

$stmt = '
SELECT 
	`df`.`id`, 
	`df`.`full_name`, 
	`df`.`filesize`, 
	`df`.`hits`, 
	ROUND(SUM(`dr`.`rating`) / COUNT(`dr`.`id`), 2) AS `rating` 
FROM 
	`downloads_files` AS `df` 
LEFT JOIN 
	`downloads_ratings` AS `dr` ON `dr`.`file_id` = `df`.`id`
WHERE 
	`df`.`path`   = "' . $subdir . '" AND
	`df`.`system` = "' . $system . '"';

if ( !empty($sorting['region']) && $sorting['region'] != 'All' )
{
	$stmt .= '
		AND `df`.`language` = "(' . $sorting['region'] . ')"';
}

if ( $sorting['filter'] == '#' )
{
	$stmt .= '
		 AND `df`.`filename` RLIKE "^[0-9].*"';
}
else
	if ( $sorting['filter'] != 'All' )
	{
		$stmt .= '
		 AND SUBSTR(`df`.`filename`, 1, 1) = "' . $sorting['filter'] . '"';
	}

$stmt .= '
GROUP BY 
	`df`.`id`
ORDER BY 
	`' . $sorting['by'] . '` ' . $sorting['type'] . ', `df`.`filename` ASC
LIMIT 
	' . ( int )$offset * $this->files_to_fetch . ', ' . $this->files_to_fetch;