## Can the frightened condition stack if it’s caused by the same source?

Say Faendal the Fallen Aasimar Paladin uses his Necrotic Shroud racial ability (Charisma saving throw, an affected creature can repeat the saving throw on subsequent turns to end the effect), and a target fails the saving throw and is frightened. On his next turn, while the target is still frightened, Faendal uses Wrathful Smite, which also causes the frightened condition, on the same target and they fail the saving throw (Wisdom saving throw, an affected creature can make a Wisdom check to end the effect).

Does this mean that the target must succed on both the Charisma saving throw and the Wisdom check to end the effect on their turn? Meaning that should one of them fail, the target is still frightened?

## Does Devil’s Sight counter the Blinded condition in D&D 5e?

Devil’s Sight says “You can see normally in darkness, both magical and nonmagical, to a distance of 120 feet.”

Does this mean that if you are blinded, casting darkness on yourself (or otherwise removing all light) will let you ignore the blinded condition?

## Why does the Sentinel Feat include this condition? [duplicate]

In D&D 5e, the last part of the Sentinel feat contains this text:

When a creature within 5 feet of you makes an attack against a target other than you (and that target doesn’t have this feat), you can use your reaction to make a melee weapon attack against the attacking creature

1. Thematically, why shouldn’t you get the opportunity attack if the target has Sentinel? I can’t think of any flavor/narrative reasons why your ally having an ability would prevent you from using your own ability.

2. If that clause was included strictly to prohibit combos among fellow sentinels, is there an official source that says as much?

## What is the highest value a condition could reach?

I’m making a Pathfinder 2e character sheet on Google sheet to automate as much number-crunching as possible. Currently, I’m making a dropdown list for conditions, as well as formulas for calculating their penalties.

I find adding conditions with pre-determined values much simpler than conditions with fillable values. For example, instead of clumsy and a blank slot for its value, the dropdown list will have clumsy 1, clumsy 2, clumsy 3, and so on. It’s ugly, but it greatly simplifies the formula. However, if a condition’s value could reach a really high number, then it will be too cumbersome to use.

The highest I have found is stupefied 4 from feeblemind and unfathomable song. I’m also pretty sure I’ve seen an ancestry/heritage/feat which could increase the maximum value of dying to 5.

So what is the highest value/penalty a condition could reach? For the supremely meticulous: what is the highest value each condition could reach?

## Longest common sub sequences with a condition

Consider a sequences if called good if it contains at least one pair one adjacent numbers which are equal.A good sub-sequence of a array is a sub sequence of that array which is good and has its length is highest.Now you are given two array $$S$$ and $$T$$ with integers,you need to find sub sequences with is common to both arrays and has maximum length and is a good sub sequence.

This is a pure dynamic programming problem,in which states are $$dp[i][j]$$ is answer for $$S[1:i]$$ and $$T[1:j]$$ ($$A[1:i]$$ means subarray of $$A$$ from $$1$$ to $$i$$). But i could not find transition between states,could anyone help me.

## Search for range in continuous function satisfying some condition

I am attempting to define an optimization for the following problem: given two graphs find (the largest possible) areas where some condition holds.

Interesting portions are where the Red graph is above the Green one. All, or part, of such areas may satisfy the condition.

Googling for optimization algorithms, e.g. ones mentioned in Scipy’s optimization tutorial, returns results focusing on finding a single point, usually the min/max of some condition. I am having trouble finding algorithms that search for ranges.

The graphsR and G are KDEs generated with Gaussian functions. I can find the intersections of the graphs (e.g. with brentq and between each pair calculate P and S (the conditions). The blue vertical lines are the intersections; blue horizontal lines with text are shown only when the conditions were met for the whole range.

In many cases a subset of the range satisfies the condition as can be seen in black. Those are results from a ML algorithm which I want to replace with a numerical calculation.

Example 1: ML algo found better solution on the right section, neither found the left one interesting.

Example 2: on the right you can see the ML algo suggesting a range not quite between the blue lines. I am OK with the new algo clipping the portion on the left. Example 3: showing that there may be more than one interesting range per marked section. Example 4: ML algo missed the leftmost range

## SQL: CASE WHEN having AVG() as condition not giving right output

I have a table of unique users that each has a "rating" column (it’s an average rating they give out of all their ratings given in a different table of reviews). I want to add another column to my table, which specifies either them giving a rating that is above the average of all ratings of all users (hence I use the AVG() function), below or at average (I call it "bias"). In other words, I want to see whether each user gives on average higher or lower ratings than the total average. I understand the limitedness of this query, and ideally I would include an interval (i.e. within 0.5 points below or above average still counts as average) but I can’t seem to make even the simplest query work.

I’ve been using the Yelp dataset from a Coursera course, but I tried to create a sample that produces the same result that I do not want – just one row. I want to have this categorization for each row, hence it should return 3 rows in this example, "below average" in the first two and "above average" in the third. However, the code below produces just one row. I have been working with R and this seems like I am using incorrect syntax, but after 30 minutes of searching the web I cannot find a solution.

I am working in and want to use SQLite syntax as part of the course in Coursera

CREATE TABLE test      (      id integer primary key,       rating integer     );  INSERT INTO test (id, rating) VALUES (1, 1);  INSERT INTO test (id, rating) VALUES (2, 3);  INSERT INTO test (id, rating) VALUES (3, 8);  SELECT id, rating,   CASE     WHEN rating > AVG(rating) THEN "above average"     WHEN rating < AVG(rating) THEN "below average"     ELSE "no bias"    END AS "bias" FROM test 

# What does this expression mean?

## Normal distribution with condition

I am reading a research paper and found the following expression (Eq.28 in the paper below).

It means a Gaussian distribution, but the mean component seems conditional probability-like expression $$\it{\bf{s}}_t | \it{\bf{m}}_{b, t, m}^{(j)}$$. I have never seen this expression before and cannot find any info about it.

The variables $$\it{\bf{s}}_t$$ and $$\it{\bf{m}}_{b, t, m}^{(j)}$$ are both vectors and $$\bf{\Sigma}_{b}$$ is a covariance matrix.

Does anybody have an idea of what this expression means?

## Original paper where the expression is.

The original paper can be found here: https://eprints.soton.ac.uk/437941/1/08340823.pdf

## Does hp fall to 0 if a creature is knocked unconscious from failing a save, and if not, how does the unconscious condition end?

I was looking at the Prismatic Beetle Swarm, and it says that "In bright light, a creature within 30 feet that looks at the prismatic beetle swarm must make a successful DC 13 Wisdom saving throw or be blinded until the end of its next turn. If the saving throw fails by 5 or more, the target is also knocked unconscious."

If a creature in range falls unconscious from the dazzling light of the swarm, do their hitpoints automatically drop to 0? It doesn’t say so specifically, like it does for drowning rules and other things, nor does it say so in the actual unconscious condition. And spells like Catnap and Sleep don’t make hp drop to 0, although I feel like unconsciousness from falling asleep is different from falling unconscious in this manner.

If their hp does not drop to 0, how does the unconscious condition end? Does the unconscious creature still need healing?

## What counts as a “debilitating condition”?

In the discern health spell it talks about the ability to identify a debilitating condition.

The name of the creature’s debilitating condition (ability drained, confused, fatigued, etc.).

What would be classified as a debilitating condition? Would any other detrimental effect (eg. Dominate person, charm person, disease, poison) be identifiable by this spell?