SELECT Apps.Description, Apps.HumanVersion, Apps.AppName, Apps.ID, AppCat.DisplayName,
                    Apps.ApkSize, Apps.Downloads, ratings.Rating AS UserRating, ratings.Comment AS UserComment,
                    (SELECT AVG(rating) FROM ratings WHERE ratings.AID = Apps.ID) AS AppRating,
                    CASE WHEN appDownloads.AID > 0 THEN 1 ELSE 0 END AS AppDownloaded, Apps.Package,
                    Apps.SS1, Apps.SS2, Apps.compVersion AS versionCode
                FROM applications Apps
                    INNER JOIN applicationcategory AppCat ON Apps.ApplicationCategoryID = AppCat.ID
                    LEFT JOIN ratings ON ratings.AID = Apps.ID AND ratings.uid = #login.uid#
                    LEFT JOIN appDownloads ON appDownloads.AID = Apps.ID AND appDownloads.UID = #login.uid#
                WHERE Apps.Active = 1
                    AND Apps.ID =