AllMyQueries

/* Creating user */
INSERT INTO dbo.releaseUser (username, passHash, imgLocation, salt) VALUES ();

/* Checking for all releases if followed */
SELECT releaseName, CASE WHEN User_Release.userId = 5 THEN 1 ELSE 0 END AS isFollowed
FROM Dbo.Release
LEFT JOIN dbo.User_Release ON User_Release.releaseId = Release.id


/*
SELECT *, username, releaseUser.imgLocation as userImage
                FROM(
                SELECT Release.CategoryName, Category.imgLocation as categoryImage, release.id as releaseId, releaseName, releaseDescription, dbo.Release.imgLocation as ReleaseImage, releaseDate, creationDate, followerCount, ownerId
                FROM Release
                LEFT JOIN Category ON Release.categoryName = Category.categoryName)
                 as R
                LEFT JOIN releaseUser ON releaseUser.id = R.ownerId; */


/*
SELECT *, CASE WHEN User_Release.userId = 5 THEN 1 ELSE 0 END AS isFollowed
FROM Dbo.Release
LEFT JOIN dbo.User_Release ON User_Release.releaseId = Release.id
LEFT JOIN dbo.releaseUser ON dbo.releaseUser.id = Release.ownerId
LEFT JOIN dbo.Category ON dbo.Category.categoryName = Release.categoryName*/

/* Geting the follower count */ /*
SELECT dbo.Release.releaseName, count(*) as followerCount
FROM dbo.Release, User_Release
WHERE Id = User_Release.releaseId
GROUP BY dbo.Release.releaseName */

/* High point of my career (only still needs followercount)*/
SELECT releaseUser.username, releaseUser.imgLocation AS userImage,
Release.CategoryName, Release.id AS releaseId, Release.releaseName, Release.releaseDescription, Release.imgLocation AS ReleaseImage, Release.releaseDate, Release.creationDate, Release.followerCount, Release.ownerId,
Category.imgLocation AS categoryImage, CASE WHEN release.id IN ( SELECT releaseId
FROM dbo.User_Release
WHERE dbo.User_Release.userId = 5
) THEN 1 ELSE 0 END AS isFollowed
FROM Dbo.Release
LEFT JOIN dbo.releaseUser ON dbo.releaseUser.id = Release.ownerId
LEFT JOIN dbo.Category ON dbo.Category.categoryName = Release.categoryName


/* Adding default value to column */


/* My beauty */
    SELECT F.followCount,
    U.username, U.imgLocation AS userImage,
    R.CategoryName, R.id AS releaseId, R.name AS releaseName, R.description, R.imgLocation AS ReleaseImage, R.releaseDate, R.creationDate, R.ownerId,
    C.imgLocation AS categoryImage, CASE WHEN R.id IN ( SELECT releaseId
    FROM dbo.User_Release UR
    WHERE UR.userId = @UserId
    ) THEN 1 ELSE 0 END AS isFollowed
    FROM Dbo.Release R
    LEFT JOIN (SELECT dbo.Release.id, COUNT(User_Release.releaseId) AS followCount
    FROM  dbo.Release
    LEFT JOIN dbo.User_Release ON dbo.User_Release.releaseId = Release.id
    GROUP BY release.id) AS F ON F.id = R.id
    LEFT JOIN dbo.releaseUser U ON U.id = R.ownerId
    LEFT JOIN dbo.Category C ON C.name = R.categoryName;

SELECT R.id, CASE WHEN R.id IN ( SELECT releaseId
    FROM dbo.User_Release UR
    WHERE UR.userId = @userId
    ) THEN 1 ELSE 0 END AS isFollowed
    FROM dbo.Release R

/* Deleting top N releases */
DELETE FROM dbo.Release WHERE id = (SELECT top(1) id FROM dbo.Release ORDER BY creationDate DESC);