Downloads

				SELECT
					Items.ID AS AID,
					Items.Type AS Type,
					Items.Author AS UID,
					Items.Title AS Title,
					Items.Summary AS Description,
					Users.Name AS Author,
					UNIX_TIMESTAMP(Items.Created) AS Created,
					UNIX_TIMESTAMP(Items.Updated) AS Updated,
					UNIX_TIMESTAMP(Items.LastComment) AS LastComment,
					Items.Rating AS Rating,
					Items.Votes AS Votes,
					Items.Category AS CID,
					Categories.Name AS Category,
					Items.Level AS Level,
					GROUP_CONCAT(
						Games.ID ORDER BY Games.ID ASC SEPARATOR ';'
					) AS Games,
					GROUP_CONCAT(
						Games.Name ORDER BY Games.ID ASC SEPARATOR ';'
					) AS GameNames,
					COUNT(ItemGames.Game) AS GamesCount,
					Items.IsPriority As IsPriority,
					Items.Trashed AS Trashed,
					Items.Visible AS Visible
				FROM
					Items LEFT JOIN ItemGames ON
					(ItemGames.Item = Items.ID)
					LEFT JOIN Games ON
					(ItemGames.Game = Games.ID)
					LEFT JOIN Categories ON
					(Items.Category = Categories.ID)
					LEFT JOIN Users ON
					(Users.ID = Items.Author)
				WHERE
				Items.Trashed = FALSE AND Items.Visible = TRUE
				 AND Items.Type = 3 AND Items.Category = 1
				GROUP BY
					AID, Type, UID, Title, Description, Author, Created, Updated, LastComment, Rating, Votes, CID, Category, Level, Trashed, Visible
				
				ORDER BY
					Trashed DESC, Visible ASC, Type ASC, Category ASC, Items.Created DESC, Items.Updated DESC