Unnamed

            $query = mysql_query("
                SELECT d.identifier, d.title, dd.description
                FROM downloadfiles AS d
                LEFT JOIN downloadfiles_downloadsubcategories AS dfds
                ON d.id = dfds.downloadfiles_id
                LEFT JOIN downloadsubcategories AS ds
                ON dfds.downloadsubcategories_id = ds.id
                LEFT JOIN downloadcategories AS dc
                ON ds.downloadcategories_id = dc.id
                LEFT JOIN downloadfiles_descriptions dd
                ON dd.file_id=d.id
                LEFT JOIN downloadcategoriestitles AS dct
                ON dc.id = dct.downloadcategories_id
                LEFT JOIN downloadsubcategoriestitles AS dst
                ON dsc.id = dst.downloadsubcategories_id
                WHERE dct.sitelanguages_id = '{$pageInfo['languageId']}'
                AND dst.sitelanguages_id = '{$pageInfo['languageId']}'
                $conditions
                GROUP BY d.id
                ORDER BY d.numDownloads DESC LIMIT 1
            ");