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 = 1