UserOption::getSelectSql

static function getSelectSql(int $userId, int $option): string
{
	$selectSql = '';

	if (!$userId || !static::isOption($option))
	{
		return $selectSql;
	}

	$tableName = UserOptionTable::getTableName();
	$select = "SELECT 'x' FROM {$tableName} WHERE TASK_ID = T.ID AND USER_ID = {$userId} AND OPTION_CODE = {$option}";

	return 'case when EXISTS(' . $select . ') then 'Y' else 'N' end';
}