Correction::getCountSessionsThatNotShown

static function getCountSessionsThatNotShown(): int
{
	$sql = "
		SELECT
			count(*) AS COUNT
		FROM
			 b_imopenlines_session_check,
			 b_imopenlines_session
		WHERE
			0 = (
				SELECT
					count(*)
				FROM
					b_im_relation
				WHERE
					b_im_relation.CHAT_ID = b_imopenlines_session.CHAT_ID AND
					b_im_relation.USER_ID != b_imopenlines_session.USER_ID
			) 
			AND
			0 < (
				SELECT count(*)
				FROM b_imopenlines_session_check
				WHERE b_imopenlines_session_check.SESSION_ID = b_imopenlines_session.ID
			) 
			AND b_imopenlines_session.ID = b_imopenlines_session_check.SESSION_ID 
			AND b_imopenlines_session_check.DATE_QUEUE IS NULL 
			AND b_imopenlines_session.CLOSED != 'Y'
	";

	return (int) Application::getConnection()->queryScalar($sql);
}