gistfile1.sql

SELECT
	(
		SELECT
			COUNT(DISTINCT id)
		FROM
			messages
		WHERE
			nickname = '" . $_GET['nickname'] . "'
		AND
			is_question = 1
	) AS questions,
	(
		SELECT
			COUNT(DISTINCT id)
		FROM
			messages
		WHERE
			nickname = '" . $_GET['nickname'] . "'
		AND
			is_docbot IS NOT NULL
	) AS docbot,
	(
		SELECT
			COUNT(DISTINCT id)
		FROM
			messages
		WHERE
			is_appreciation LIKE ('%" . $_GET['nickname'] . "%')
	) AS appreciation
FROM
	messages
LIMIT 1