@Shog9 Not a dupe. That one asks to change the text "by the author"; the other one asks for a totally new feature.

it's a duplicate of a previous request

not the other one you posted

@Shog9 You mean this one? You can close it however you like, but I recommend closing this one as a dupe of the above one, because this one doesn't quote or screenshot the instructions.

Yes, you're right, it is a dupe.

@Ano Never mind, it does, actually

If anyone's around and interested in solving this mystery for me... I'd be curious: meta.stackexchange.com/questions/306852/… (10K).

@Catija Maybe I'd know...screenshot please?

No, you won't.

I don't think you can look at the database to see why a question that isn't featured appeared in the featured on meta box.

@Shog9 ^^

I appreciate that you're trying to help me... but it's not an urgent issue. If it was, I wouldn't have deleted the question.

@Catija How was I supposed to know it was your question?

That's irrelevant. The point is, that we've spent a good chunk of time trying to get you to stop pinging CMs... and now you're pinging them when other people intentionally choose not to do so.

@Catija Shog said he's OK with it in certain cases

You have a much looser concept of "certain cases" than I do and I would appreciate it if you wouldn't ping CMs on my behalf... particularly not on a Saturday night.

@Catija I don't ping him with cases of questions that need to be closed or deleted, and if you notice my recent history, I've just posted questions here or on MSE without pinging rather than jumping straight to pinging Shog here. That said, I won't ping CMs on your behalf.

@Catija You don't happen to still be involved in casting, right?

@if.... was?

@Ano

@JourneymanGeek What?

(this is what getting pinged on a saturday night feels like ;p)

I'm sure shog has, beer to drink and tomatos to grow ;p

@JourneymanGeek I always check the "last seen" time before pinging someone, and only ping them if they were last seen in seconds (or 1-2 minutes). Shog was seen in seconds at the time, so I pinged him.

@JourneymanGeek Um...what?

[ SmokeDetector | MS ] URL-only title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, blacklisted website in body, +4 more: australiafitness.com.au/reducelant/ by user793829 on askubuntu.com

Can someone please check my major edit to the answer to the proposed FAQ on merging questions? Also, there are some places where there is missing information.

@TelautonomousKitty We were eating a snack at the San Diego Zoo once, and a peacock stole our food.

Also, we were somewhere in India once, and a chicken had gotten in to our snack bag. We only found out because I tried to pick up the bag only for the chicken to frantically jump out immediately after I lifted it.

(Yes, they let peacocks roam free about the zoo, rather than putting them into enclosures. Most of them just lurk, some put on feather shows for human audiences (and peahens), and some attack for food, just like Indian monkeys.)

In India, at the same place, a monkey aggressively stole a sealed tin full of sweets. But he struggled with trying to open it and just gave up after a while.

@TelautonomousKitty Which campsite?

@TelautonomousKitty Kangaroos nearby?

@TelautonomousKitty Is it true that there are twice as many kangaroos as there are people in Australia?

hm?

@if.... ah

@TelautonomousKitty erm, where did I say that?

oh. SORRY!

@TelautonomousKitty Jeff Atwood left

[ SmokeDetector | MS ] Bad keyword in answer: Do fast copy programs work? by Vikas Khandola on superuser.com

[ SmokeDetector | MS ] Manually reported answer: What determines if the Wardrobe works or not? by Dick bandit on scifi.SE

@SmokeDetector fp-

@Catija I see that old featured question right now on pages served to me. The featured question are kept in some weird acting cache component that is known to not evict stale items from it. Each of the webservers has this cache and if some of them went out of sync you get this awesome effect of sometimes seeing stale items and sometimes not, some users can repro, some users not.

If it annoys me enough I ping a dev or Shog9 who has buttons he can push to force those caches to behave

see also chat.meta.stackexchange.com/transcript/message/4319645#4319645 for earlier incidents of the same issue.

@Catija See? This was an OK case. (Just kidding, I know that you don't like me pinging CMs on your behalf.)

!!/report meta.stackexchange.com/a/306865/152859

[ SmokeDetector | MS ] Manually reported answer: Redesigning the /users page by Cyril Anouar Streit on meta.SE

@ShadowWizard sorry for calling you out, I got carried away until I followed back the dupe chain.

@rene hmm? Where?

My amazement was expressed in some strong wording ...

sd f

@rene closed as dupe of something else, and missed your comment...

good, I'm sure you would have flagged it otherwise ;)

Only if you called me "old bag of shadows". Anything else won't offend me coming from you. ;-)

Fine with me, I'm odd

@TimStone in case you missed @rene's comment: meta.stackexchange.com/questions/306838/…

(question deleted, so unless you read the notification, it's gone.)

cv-plz meta.stackexchange.com/questions/306866/c-vending-machine

I love reading some of those aviation answers Don't hit anything. ... awesome advice ...

Took 25 minutes and 13 downvotes for OP to delete their question. sigh

[ SmokeDetector | MS ] Manually reported answer (batch report: post 1 out of 3): A colleague's CV is taking credit for service that I did, and now we're both on the shortlist for a job. Is there anything that I can do? by user87369 on academia.SE

[ SmokeDetector | MS ] Manually reported answer (batch report: post 2 out of 3): Is the phrase "thanks, but no thanks" appropriate in an email sent to a supervisor? by user87369 on academia.SE

[ SmokeDetector | MS ] Manually reported answer (batch report: post 3 out of 3): Is the phrase "thanks, but no thanks" appropriate in an email sent to a supervisor? by user87369 on academia.SE

Apparently I didn't survive today instead...

"tomorrow do thy worst, for I have lived today" tommorrow: HOLD MAH BEER

@SensibleAlexander stomach aching due to that mold?

yeah :(

Any idea why SEDE can't produce an execution plan for my five-line SQL query?

select ParentId as [Post Link], count(Id) as "count"
from Posts
group by ParentId
having count(Id) > 1
order by count(Id) desc, min(CreationDate) desc

NSFW post on MSE

!!/report meta.stackexchange.com/a/306868/241919 meta.stackexchange.com/q/306867/241919

@SensibleAlexander delvote delivered

[ SmokeDetector | MS ] Manually reported answer (batch report: post 2 out of 2): phone#18064106269 by user382285 on meta.SE

[ SmokeDetector | MS ] Username similar to website in answer: How to make Magento 2 development sites fast? by flopstore on magento.SE

@JohnDvorak if it is timing out try SET SHOWPLAN_TEXT ON with a GO

your query might benefit from a where posttypeid = 2

Still times out

I'm not sure how to read the execution plan, but it seems like it wants to do a full scan

I would have expected it to use an index on ParentId

Ultimately I'm trying to find out how common multiple answers per user per question are

@JohnDvorak let me check, hold on

@JohnDvorak get rid of the [Post Link]

It actually runs well enough against other sites

well enough to convince me that my idea wouldn't work

@JohnDvorak yeah, how that magic column stuff works is really resource intensive for SO

ugh, why?

@JohnDvorak this is why: meta.stackexchange.com/questions/284040/…

so, it generates too large of a query? Yay.

@JohnDvorak basically yes. The workaround is to join with Posts yourself to get the title. see: meta.stackexchange.com/a/291783/158100 (although this is for users but the principle is the same)

SQL sadness: Even if you group by a primary key, you can't select a column from that table without using an aggregation function.

Hmm, it seems that Posts is actually a view over PostsWithDeleted. Is that the case?

@JohnDvorak yes

nice

@Ano no. It wasn't. Please just stop trying to justify yourself.

@rene weird. Is there a MSE question around about it? I'm considering undeleting it if not. And asking how to fix it.

I don't have an obvious one.

@Catija this is slightly related on MSO: meta.stackoverflow.com/questions/312035/…

I'm happy to dupe hammer it against caching ... ;)

@Catija you mean the bug where featured questions remain in the Community Bulletin box long after being unfeatured? It's reported already:

The latest swag was there for days after being unfeatured.

It seems really different. This may be related to the historical significance tag?

It was off the box for a week, though. Then randomly popped back in.

I believe this is the same root cause, something there is very buggy in the core. But only SE developer can really look into it. Since it's long months reported without any trace of attention from the team, I doubt this will happen though.

[ SmokeDetector | MS ] Mostly non-Latin body, mostly non-Latin title: Մատրիցի մեջ սյան հետ ոնց գործողություն կատարեմ by ann on ru.stackoverflow.com

@Catija oh wait.... I see it now. I think it happens only when the question is also locked. Somehow this locks the question into the sidebar.

so unlocking it might also cause it to be removed from the sidebar.

Do you want to ping Shog about it? Your call, I'm not @Ano. :)

salting the scold, are we? :P

Scalding the salt

I don't worry, @Ano won't get mad at me.

@ShadowWizard Shog isn't a dev and it's non-urgent.

@Catija well, Shog fixed the logic of the post banners, so he's obviously involved, even if not writing code directly. Sounds like similar issue, with basic logic for what appears in the bulletin sidebar being off. But if you think it's not urgent all good, we can wait. :)

[ SmokeDetector | MS ] Link at end of answer, potentially bad keyword in answer, blacklisted user: How/when will my claymore bmg AMD gpu miner results show up in my wallet with Bitcoin core gold wallet? by Bitcoin Promotion on bitcoin.SE

[ SmokeDetector | MS ] Potentially bad keyword in body, blacklisted user: We are a team of 2 professional traders from Switzerland? by Bitcoin Promotion on bitcoin.SE

@if.... do you know if there were any elections that were cancelled without any candidates nominating?

CS theory was cancelled but they had one candidate: cstheory.stackexchange.com/election/3

0 Candidate, no I don't saw any. But saw few of them cancelled because lack of candidates

Did Data Science have any?

Ah, they had three.

@if.... Ok, then my answer will work for all past elections. Do you happen to know why there are 81 nominations posts in SEDE for SO's 2011-01 election while the election page only states there are 55 nominations?

The votes table or posthistory didn't help me to reduce those 81 to 55.

It only looks like the score on the posts gets reset once nomination is over.

@if.... just edited, I removed the score =0 clause

If you look at mplungjan ( postid= 4730004) there is a SEDE post, but no entry on the election page.

would had been nice if the deletiondate had been no null in that case ...

[ SmokeDetector | MS ] Link at end of body: is it possible to stream a stragers flowplayer in my web site? by Shino Honakazo on superuser.com

[ SmokeDetector | MS ] Link at end of body: How can I bulk shorten many magnet links at once?, services online just do one at a time? by Joe Green on superuser.com

@if.... hey. My nomination was totally half-assed :p

@ShadowWizard What?

@ShadowWizard What?

@Catija I think you missed the part where I said "just kidding".

as a dog owner. Trust in god. Just don't cheap out on medical treatment ;p

@if.... Ah, some people tend to mistakenly liken moderation to censorship.