nextcloud / server

			->innerJoin('m', 'external_applicable', 'a', $builder->expr()->eq('m.mount_id', 'a.mount_id'))

			->where($builder->expr()->eq('a.type', $builder->createNamedParameter($type, IQueryBuilder::PARAM_INT)));

		if (is_null($value)) {

			$query = $query->andWhere($builder->expr()->isNull('a.value'));

		} else {

			$query = $query->andWhere($builder->expr()->eq('a.value', $builder->createNamedParameter($value)));

		}

		return $query;

	}

			->where($builder->expr()->eq('mount_id', $builder->createNamedParameter($mountId, IQueryBuilder::PARAM_INT)))

			->andWhere($builder->expr()->eq('type', $builder->createNamedParameter($type, IQueryBuilder::PARAM_INT)));

		if (is_null($value)) {

			$query = $query->andWhere($builder->expr()->isNull('value'));

		} else {

			$query = $query->andWhere($builder->expr()->eq('value', $builder->createNamedParameter($value, IQueryBuilder::PARAM_STR)));

		}

		$query->execute();

	}