Items

Help

2002

Connection refused

				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.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.Author = 42632
				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

There are no items fulfilling the requirements.

Go to top

"One site to rule them all, one site to find them,
one site to host them all, and on the network bind them."

5:44:13

2002	Connection refused
	SELECT ID, Title, Summary FROM Items WHERE Type = 2 AND ID <> 0 AND ID <> 0 AND Trashed = FALSE AND Visible = TRUE ORDER BY RAND() LIMIT 0,1

2002	Connection refused
	SELECT ID, Title, Votes, Rating FROM Items WHERE Type = 1 AND Trashed = FALSE AND Visible = TRUE AND Votes > 0 ORDER BY Rating DESC, Votes DESC, Views DESC LIMIT 0, 10

2002	Connection refused
	SELECT ID, Title, Views FROM Items WHERE Type = 1 AND Trashed = FALSE AND Visible = TRUE ORDER BY Views DESC LIMIT 0, 10

2002	Connection refused
	SELECT ID, Title, UNIX_TIMESTAMP(Created) AS CreatedU FROM Items WHERE Type = 1 AND Trashed = FALSE AND Visible = TRUE ORDER BY Created DESC LIMIT 0, 10

2002	Connection refused
	SELECT ID, Title, UNIX_TIMESTAMP(Updated) AS UpdatedU FROM Items WHERE Type = 1 AND Trashed = FALSE AND Visible = TRUE ORDER BY Updated DESC LIMIT 0, 10

2002	Connection refused
	SELECT ID, Title, UNIX_TIMESTAMP(LastComment) AS LastCommentU FROM Items WHERE Type = 1 AND LastComment > 0 AND Trashed = FALSE AND Visible = TRUE ORDER BY LastComment DESC LIMIT 0, 10

2002	Connection refused
	SELECT ID, Name, Points FROM Users WHERE Points > 0 ORDER BY Points DESC LIMIT 0, 10

2002	Connection refused
	SELECT ID, Name, UNIX_TIMESTAMP(LastActive) AS Active, LastAction FROM Users WHERE LastActive > DATE_SUB(NOW(), INTERVAL 10 MINUTE) ORDER BY LastActive DESC