Ответ

allex_by 03.04.2015 10:11

если я правильно понимаю, то у вам необходимо что-то вроде нижеследующего:

	$tWaiting[^oSQL.table{
		SELECT threadID
		FROM questions AS q
		WHERE
			parentID = 0
			AND (
					SELECT COUNT(id)
					FROM questions
					WHERE
						threadID = q.threadID
						AND parentID <> 0
				) = 0
	}]
	$tAnswered[^oSQL.table{
		SELECT threadID
		FROM questions AS q
		WHERE
			parentID = 0
			AND (
					SELECT COUNT(id)
					FROM questions
					WHERE
						threadID = q.threadID
						AND parentID <> 0
				) > 0	
	}]

а это к вопросу об авторах операторах:

	$tAuthors[^oSQL.table{
		SELECT DISTINCT uID
		FROM questions
		WHERE parentID = 0
	}]
	$tOperators[^oSQL.table{
		SELECT DISTINCT uID
		FROM questions
		WHERE uID NOT IN (^Lib:list[$tAuthors;uID])
	}]

---