Charcoal HQ

Ah, righto

Paul Stenne

@M.A.R.ಠ_ಠ My human costume has been yep. Ukrainian sweets...

12:48 AM

@ArtOfCode How's MS #350 going?

Look at this comment by MS, it seems there's code formatting...?

@iBug this shouldn't be done on the MS side

we do those kind of substitutions on the Smokey side when generating the search link usually

...also that's not doing a regex search right now anyways

it's just LIKE

o.O

only SQL LIKE clause on MS side?

oops

oOoOoOps

SFTP

1:48 AM

!!/report stackoverflow.com/a/49441088

[ SmokeDetector | MS ] Manually reported answer: Can anyone help me with setting the prototype of an object in javascript? by shadowstalker75 on stackoverflow.com

1:59 AM

tpu- by Makyen

2:39 AM

[ SmokeDetector | MS ] Pattern-matching website in body: that it plays out the basic limit that is to by Syb btj on apple.SE

zzz

tpu- by Catija

3:13 AM

sd k

@iBug [:43572456] That message is not a report.

!!/test power-max-extra

> Would not be caught as a post, title or username.

!!/watch power\W?max\W?extra

@iBug Added power\W?max\W?extra to watchlist

3:14 AM

!!/blacklist-website-force supplements2017\.com

@iBug Already blacklisted on line 804 of blacklisted_websites.txt

hey you!

[ SmokeDetector ] SmokeDetector started at rev bc3cd35 (SmokeDetector: Auto watch of power\W?max\W?extra by iBug --autopull) (running on teward/Solar Flare)

Restart: API quota is 13647.

charcoal test is eating the CI messages

:/

eating the CI messages?

3:17 AM

it doesn't wait for the queue to empty before restarting

it has time to send to charcoal test but not here

it's unordered so

Looks like I can panic before going forward to implementing the message throttling.

yeah that's not going to work by the way

aside from the Markdown stuff

not being able to prune individual messages and instead having it as one big block is not really good

The problem with the rate limiting is just because it's posting to two rooms now. Turning off ActionCable to charcoal test has quashed that

now if we really wanted to we could chuck the CE rate limiting mechanism out the window entirely

replace the message queue with a priority queue, come up with a scheme from that

but eh

[ SmokeDetector ] SmokeDetector started in reverted mode at rev 762c04b (metasmoke: Merge pull request #1709 from Charcoal-SE/auto-blacklist-1520839439.4114435 --autopull) (running on NobodyNada/Raspberry Pi)

Restart: API quota is 18881.

NobodyNada

Ugh...

!!/failover NobodyNada

@NobodyNada No such command 'failover'.

NobodyNada

3:30 AM

!!/pull

[ SmokeDetector ] SmokeDetector started at rev bc3cd35 (SmokeDetector: Auto watch of power\W?max\W?extra by iBug --autopull) (running on teward/Solar Flare)

Restart: API quota is 13572.

[ SmokeDetector ] SmokeDetector started at rev bc3cd35 (SmokeDetector: Auto watch of power\W?max\W?extra by iBug --autopull) (running on NobodyNada/Raspberry Pi)

Restart: API quota is 18875.

NobodyNada

!!/standby NobodyNada

[ SmokeDetector ] SmokeDetector started in standby mode at rev bc3cd35 (SmokeDetector: Auto watch of power\W?max\W?extra by iBug --autopull) (running on NobodyNada/Raspberry Pi)

3:46 AM

\o\ /o/ \o\ my smokey mug has a tracking # /o/ \o\ /o/

4:08 AM

@ArtOfCode Thank you very much! I've (not literally) picked up the system and run with it. (I got your letter today)

[ SmokeDetector | MS ] Link at end of body, pattern-matching website in body: Ost To Pst Conversion by Ronald Gibson on askubuntu.com

@SmokeDetector k

is MS down?

@K.Dᴀᴠɪs No

tpu- by K.Dᴀᴠɪs

4:10 AM

@SmokeDetector tpu-

there we go. Late feedback FTW.

@K.Dᴀᴠɪs You could have just replied, like I just did

I like to do things the hard way

[ SmokeDetector | MS ] Bad keyword in body, blacklisted website in body, link at end of body, repeated URL at end of long post: one of the dangers that you will encounter regardless? by hoytsybil on askubuntu.com

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, blacklisted website in body, blacklisted website in title, +2 more: platinumcleanserinfo.com/nutripath-garcinia/ by youwikshe on puzzling.SE (@Mithrandir @micsthepick)

tpu- by PeterJ on one of the dangers that you will encounter regardless? [MS]

tpu- by PeterJ

4:25 AM

[ SmokeDetector | MS ] URL in title, blacklisted website in body, blacklisted website in title, pattern-matching website in body, pattern-matching website in title: wellnessdietsolution.com/xr-nutrition-clarity/ by kolj on puzzling.SE (@Mithrandir @micsthepick)

tpu- by PeterJ

[ SmokeDetector | MS ] URL-only title, bad keyword in body, bad keyword in title, blacklisted website in body, blacklisted website in title, +2 more: juvalifegermanyhelp.com/vortaxel/ by osephHiles on askubuntu.com

tpu- by K.Dᴀᴠɪs

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, pattern-matching website in body, pattern-matching website in title: dermaessencecreamblog.com/cerebral-x/ by Joelhoud on english.SE

tpu- by PeterJ

SFTP

4:46 AM

!!/report wordpress.stackexchange.com/a/298659

[ SmokeDetector | MS ] Manually reported answer: Positioning the “Lost your password?” and “← Back to Site” by Patricia on wordpress.SE

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, blacklisted website in body, blacklisted website in title, +2 more: gojixtremesitebrazil.com/mega-forte-brazil/ by psmlxhsvaw on puzzling.SE (@Mithrandir @micsthepick)

tpu- by PeterJ on Positioning the “Lost your password?” and “← Back to Site” [MS]

tpu- by PeterJ

!!/watch d\Wr\W_\Wm\Wa\Wc\Wk\W*@\Wy\Wa\Wh\Wo\Wo\W*\.\Wc\Wo\Wm

@K.Dᴀᴠɪs You don't have code privileges, but I've created PR#1805 for you.

ugh I hate formatting sometimes

I don't think that regex does what you want.

paper1111

4:51 AM

I don't think you always need such complicated regexes actually...

Indeed. \W is any 'word' character. For example, d\Wr will match der, but not dr

@paper1111 when they make their email complicated

@Rob \W is a not-word character. \w is a word character.

Oh, whoops - my bad

(goes to show how long it's been since I've really used regex expressions)

ugh now I have to find someone who knows regex to vote for....

:p

4:54 AM

;)

aaaaaaaanyways... How the - do I escape asterisks when using !!/watch?

What are you trying to do with all the <i> and </i>?

@Makyen that was all the asterisks formatting it to <i>

which is why I asked the question above yours :)

paper1111

!!/blacklist-keyword dr\W?mack

@K.Dᴀᴠɪs Ahhh... OK.. (Yeah, I'd already written it an hit return prior to reading your message.)

4:56 AM

@paper1111 Blacklisted dr\W?mack

Was going to ask next then, wouldn't \W have the same issue? Though it appears like the chat has just mangled the expression

Well does *come out italics*?

yeah chat f'd it up pretty good. Gotta love markdown formatting

@Makyen Nope

[ SmokeDetector ] SmokeDetector started at rev 371f8ce (SmokeDetector: Auto blacklist of dr\W?mack by paper1111 --autopull) (running on teward/Solar Flare)

4:58 AM

I thought by hitting a hard return at the end of my line would prevent formatting
*like such*

Restart: API quota is 13100.

But it didn't take my hard return since it was empty

@K.Dᴀᴠɪs You can try it with \ escaping each *.

A J

morning all!

Testing: d\W*r\W*

4:59 AM

so \W*

Yeah, seems to work

hmmm

d\W*r\W*_\W*m\W*a\W*c\W*k\W*@\W*y\W*a\W*h\W*o\W*o\W*\.\W*c\W*o\W*‌m

Nice!

Not quite, but close.

oh wait

the end there

So, don't escape the last one

@K.Dᴀᴠɪs The raw message doesn't contain a \ at the end, so you may have just missed it. This formatting concept working will depend on how SD is picking up the command information. It appears to be getting it as HTML, so you'll need to test.

5:15 AM

[ SmokeDetector | MS ] Mostly non-Latin answer: Hive on Spark NoSuchFileException hive-exec-x.y.z.jar by yanbo sun on stackoverflow.com

naa- by PeterJ

SFTP

!!/report webmasters.stackexchange.com/a/113805

[ SmokeDetector | MS ] Manually reported answer: How could Google identify if a video is duplicate? SEO duplicate content theme by The Loudspeaker on webmasters.SE

tpu- by PeterJ

5:30 AM

[ SmokeDetector | MS ] Bad keyword in body, bad pattern in URL body, blacklisted website in body, link at end of body, pattern-matching product name in body: This product is suitable for a person above the age of 18 years simplest by akkqghkzxnwjur on askubuntu.com

tpu- by K.Dᴀᴠɪs

[ SmokeDetector | MS ] URL in title, bad keyword in title, pattern-matching website in body, pattern-matching website in title: www.facts4supplement.org/fxx-testosterone/ by SadiHill on graphicdesign.SE

tpu- by K.Dᴀᴠɪs

5:54 AM

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, blacklisted website in body, pattern-matching website in body: Testosteroxn: Boost your Stamina and Performance by testostero on superuser.com

tpu- by John Dvorak

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, blacklisted website in body, link at end of body, pattern-matching product name in body, +1 more: suppliers is prudent to look forertretret When starting a by hightqjerry on superuser.com

tpu- by PeterJ

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, blacklisted website in body: item may help repair existing tissue by swhevj on apple.SE

tpu- by PeterJ

Restart: API quota is 12733.

6:17 AM

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, blacklisted website in body, link at end of body, +1 more: Revyve Skin: best skincare for all skin types by mertromony on meta.SE

tpu- by K.Dᴀᴠɪs

6:34 AM

[ SmokeDetector | MS ] Bad keyword in body, bad pattern in URL body, blacklisted website in body, link at end of body, pattern-matching website in body: length, but from its dimension, a by luchibuchix on askubuntu.com

[ SmokeDetector | MS ] URL in title, blacklisted website in body, blacklisted website in title, link at end of body, pattern-matching website in body, +1 more: order4healthsupplement.com/bellamia-renew/? by AnnetteCarr on drupal.SE

tpu- by PeterJ on length, but from its dimension, a [MS]

tpu- by PeterJ

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, bad keyword in username, blacklisted website in body, +2 more: Vortaxel : Removes all the dark spots and blemishes by vortaxel on graphicdesign.SE

tpu- by Makyen

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, blacklisted website in body, blacklisted website in title, +3 more: visit site:realcoloncleansingworks.com/zylix-plus-male-enhancement/ by johnston on astronomy.SE

tpu- by K.Dᴀᴠɪs

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, bad keyword in username, blacklisted website in body, pattern-matching product name in body, +1 more: HOw To USe SteelRX Male Enhancement? by Steelrx Male Enhancement on astronomy.SE

tpu- by PeterJ

!!/scan hinduism.stackexchange.com/questions/26168

@NogShine Cannot find data for this post in the API. It may have already been deleted.

You missed it. It was a spam website for tour holidays.

Do you happen to have the linked website so we can !!/watch it?

@Glorfindel Yes globaltravelsandholidays.com/category/ramayana-tour-packages

6:49 AM

!!/watch globaltravelsandholidays\.com

thanks!

@Glorfindel Added globaltravelsandholidays\.com to watchlist

!!/blacklist-keyword bellamia

@tripleee Blacklisted bellamia

This is the screenshot of the post. User name same as the website. ^

[ SmokeDetector ] SmokeDetector started at rev a6c0007 (SmokeDetector: Auto blacklist of bellamia by tripleee --autopull) (running on teward/Solar Flare)

6:51 AM

@K.Dᴀᴠɪs in a regex, \* or [*] matches a literal asterisk

Restart: API quota is 12412.

but the formatting is rendered as HTML so you don't actually have those in the post that is being presented to Smokey

Yes

@K.Dᴀᴠɪs github.com/Charcoal-SE/SmokeDetector/pull/…

!!/watch mega\W?forte

@tripleee Added mega\W?forte to watchlist

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, blacklisted website in body, blacklisted website in title, +1 more: purelifegreencoffeebeanadvice.com/pantothen/ by Savanmessz on puzzling.SE (@Mithrandir @micsthepick)

tpu- by tripleee

[ SmokeDetector | MS ] Blacklisted website in answer, pattern-matching website in answer, blacklisted user: Two Gnome window managers w different displays? by Sophia Joseph on askubuntu.com

tpu- by tripleee

[ SmokeDetector ] SmokeDetector started at rev 89e3fe1 (SmokeDetector: Auto watch of mega\W?forte by tripleee --autopull) (running on teward/Solar Flare)

Restart: API quota is 12356.

6:59 AM

!!/blacklist-website-force cheapassignmenthelp\.com

@tripleee Blacklisted cheapassignmenthelp\.com

(pattern matched so far; just wishing to mark it as "known")

[ SmokeDetector ] SmokeDetector started at rev 6822d8f (SmokeDetector: Auto blacklist of cheapassignmenthelp\.com by tripleee --autopull) (running on teward/Solar Flare)

Restart: API quota is 12341.

tpu- by rene

[ SmokeDetector | MS ] Bad keyword in body, link following arrow in body, pattern-matching website in body: Nuts So Brain Functions by Pxkoreszb on puzzling.SE (@Mithrandir @micsthepick)

tpu- by tripleee

morning

Mithrandir

@SmokeDetector k

7:06 AM

[ SmokeDetector | MS ] URL in title, bad keyword in body, blacklisted website in body, blacklisted website in title, pattern-matching website in body, +1 more: wellnessdietsolution.com/xr-nutrition-clarity/ by ThomWalk on puzzling.SE (@Mithrandir @micsthepick)

Mithrandir

@SmokeDetector k

tpu- by tripleee

Any userscript wizards here?

Is it possible to make a US to flag a post from a user's "reputation" tab?

in SO Close Vote Reviewers on Stack Overflow Chat, 10 mins ago, by SmokeDetector

[ SmokeDetector | MS ] Blacklisted website in answer: How to mailto to office 365? by stefnie kayelle on stackoverflow.com

^ I don't think this was reported here? still open

M.A.R. ಠ_ಠ

@tripleee nopes

@tripleee K

7:12 AM

Something like just placing the flag link behind or under a post in someone's reputation tab

M.A.R. ಠ_ಠ

@SmokeDetector K

@SmokeDetector k

@SmokeDetector K

Mithrandir

@SmokeDetector k

tpu by MAR on How to mailto to office 365? [MS]

A J

@tripleee gone

!!/report travel.stackexchange.com/a/111724/11329

7:14 AM

[ SmokeDetector | MS ] Manually reported answer: How to extend a single-entry Indian tourist visa? by sushma on travel.SE

tpu- by tripleee

!!/watch indianetouristvisa\.co\.in

@tripleee Added indianetouristvisa\.co\.in to watchlist

!!/pull

@gparyani CI build is still pending, wait until the build has finished and then pull again.

CI on 58a00f4 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 58a00f4 (SmokeDetector: Auto watch of indianetouristvisa\.co\.in by tripleee --autopull) (running on teward/Solar Flare)

Restart: API quota is 12257.

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, blacklisted website in body: CBD Hemp Oil Maracuja is a ardour fruit extract by kristyrholguin on graphicdesign.SE

@SmokeDetector k

7:19 AM

@SmokeDetector tpu-

@mag can you query find someone who dv'd 3 posts back to back?

@K.Dᴀᴠɪs not really no

[ SmokeDetector | MS ] Bad keyword in link text in body: How Can The Top IT Managed Services Help You Grow Your Business Result? by Guardian tech on superuser.com

@K.Dᴀᴠɪs I can confess, I did that recently (actually 10)

7:34 AM

tpu- by tripleee

!!/watch guardiantech\.com\.gh

@tripleee I am trying to modify his serial UV query xD

@tripleee Added guardiantech\.com\.gh to watchlist

I am not very query-minded though.

Is vote ID 1 a DV?

CI on 53f0b02 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 53f0b02 (SmokeDetector: Auto watch of guardiantech\.com\.gh by tripleee --autopull) (running on teward/Solar Flare)

Restart: API quota is 12113.

7:37 AM

@K.Dᴀᴠɪs maybe refer to an existing query, this one looks pertinent data.stackexchange.com/stackoverflow/query/777461/…

@tripleee Yeah, no... Not looking for delete votes :P

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, bad keyword in title, bad keyword in username, link at end of body, +3 more: For what reason Do You Need Phytolast? by Phytolast on superuser.com

tpu- by ByteCommander

@K.Dᴀᴠɪs dv is downvote?

yes

sorry, I guess I wasn't clear on that

Byte Commander

!!/report askubuntu.com/q/1018467/367990

7:40 AM

[ SmokeDetector | MS ] Manually reported question: What do You Mena by Thoraxin ? by Thoraxin on askubuntu.com

[ SmokeDetector | MS ] Username similar to website in answer, blacklisted user: Converting Batches of PSDs OR JPEGs to PDFs by SKOTechLearn on graphicdesign.SE

tpu- by tripleee on What do You Mena by Thoraxin ? [MS]

tpu- by tripleee

!!/blacklist-keyword xr\W?nutrition\W?clarity

@tripleee Blacklisted xr\W?nutrition\W?clarity

CI on f82b525 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev f82b525 (SmokeDetector: Auto blacklist of xr\W?nutrition\W?clarity by tripleee --autopull) (running on teward/Solar Flare)

Restart: API quota is 12048.

[ SmokeDetector | MS ] Pattern-matching website in answer: Mini keyboard has no home/end keys; how to type them? by Ben on superuser.com

fp- by ByteCommander

7:55 AM

[ SmokeDetector | MS ] URL-only title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: getbetterskincare.com/keto-trim/ by fraaytrna on askubuntu.com

tpu- by K.Dᴀᴠɪs

!!/blacklist-website phytolastreviews\.com

@tripleee That pattern looks like it's already caught by Bad ns for domain in body, Pattern-matching website in body, Bad ns for domain in answer, and Pattern-matching website in answer; append -force if you really want to do that.

!!/blacklist-website-force phytolastreviews\.com

@tripleee Blacklisted phytolastreviews\.com

[ SmokeDetector ] SmokeDetector started at rev a225fba (SmokeDetector: Auto blacklist of phytolastreviews\.com by tripleee --autopull) (running on teward/Solar Flare)

Restart: API quota is 11904.

[ SmokeDetector | MS ] Link at end of body: China 4 Door Wardrobe suppliersdddf by momu124 on askubuntu.com

tpu- by Glorfindel

!!/watch aureolefurniture\.com

8:08 AM

@Glorfindel Added aureolefurniture\.com to watchlist

CI on ef56ceb succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev ef56ceb (SmokeDetector: Auto watch of aureolefurniture\.com by Glorfindel --autopull) (running on teward/Solar Flare)

Restart: API quota is 11866.

I'm trying to figure out how to add the SQL data explorer to the Metasmoke Tools menu in github.com/Charcoal-SE/metasmoke/blob/master/app/views/layouts/… but unlike the other things in the menu, the Blazer doesn't have an explicit controller class in controllers/*.rb ... what should I link to instead?

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +4 more: getbetterskincare.com/keto-trim/ by fraaytrna on apple.SE

tpu- by K.Dᴀᴠɪs

... also tangentially why does it look like there are two Core checkboxes in the user permissions? is something misaligned?

[ SmokeDetector | MS ] Bad keyword in body, blacklisted website in body, pattern-matching website in body: Rapid Speedily Weight Burning by relyorris on graphicdesign.SE

tpu- by K.Dᴀᴠɪs

!!/report mathoverflow.net/q/295946/70594

8:22 AM

[ SmokeDetector | MS ] Manually reported question: What is a business consultant? by user121572 on mathoverflow.net

tpu- by PeterJ

!!/watch smebusinessonline\.com

@Glorfindel Added smebusinessonline\.com to watchlist

@tripleee Inside the sql explorer it has a pinned field, maybe that is the reason for the extra checkbox (speculation)

CI on 7cad929 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 7cad929 (SmokeDetector: Auto watch of smebusinessonline\.com by Glorfindel --autopull) (running on teward/Solar Flare)

Restart: API quota is 11775.

Mar 8 at 10:45, by ArtOfCode

Okay, I added pinnable core roles to metasmoke

8:31 AM

I made a user script that matches

^https?:\/\/\w*.?(stackoverflow|stackexchange|serverfault|superuser|askubuntu|s‌tackapps).com\/users\/\w*.?\/.*\?tab=reputation

But somehow it's not triggering on user's reputation pages

Anyone know why?

What is your @include line? The regex must(?) be enclosed by two forward slashes

@Glorfindel ahh that was it

thanks

:)

Writing userscripts is hard >_>

@Glorfindel right, thanks!

8:47 AM

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: getbetterskincare.com/keto-trim/ by mgmumgmu on apple.SE

tpu- by Ferrybig

is there any way to make the SQL columns narrower? this is very wide metasmoke.erwaysoftware.com/data/sql/queries/16-hits-per-domain

@tripleee Its made to automatically fit all the text, however 1 domain is just

Zyntix%20Male%20Enhancement%20enables%20a%20great%20proportion%20of%20Zyntix%20‌sexual%20performance%20with%20the%20supportive%20natural%20ingredients%20which%20‌can%20simply%20enhance%20your%20libido%20

, what is really long for a value. You should filter out invalid values beforehand

ah thanks

or truncate the field, I suppose ...?

That would also work, but all domains above length 100 are invalid domains at the moment

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, pattern-matching website in body, pattern-matching website in title: dermaessencecreamblog.com/cerebral-x/ by lliamoran on graphicdesign.SE

tpu- by Glorfindel

9:01 AM

@Ferrybig thanks, updated the query ... prefer including the invalid data in case it would turn out to be interesting somehow

[ SmokeDetector | MS ] URL-only title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: getbetterskincare.com/keto-trim/ by tervsluteen on askubuntu.com

tpu- by Ferrybig

Successfully made the userscript

@Magisch wow, congratulations!

Only pain point left is that it's a terrible prompt() and alert() for entering the flag text

any SQL wizard advice on how to fix this? metasmoke.erwaysoftware.com/data/sql/queries/…

9:11 AM

Normally, with MySQL, you can add the EXPLAIN keyword in fon of the query, but we don't have the required privileges for that

It times out after less than 10 seconds. That's rather short, I'm not sure if the query is to blame.

[ SmokeDetector | MS ] Few unique characters in answer: Support with Logic Gate Simulation program in Python by Daniel Donovan on stackoverflow.com

tpu- by Glorfindel

@tripleee timeout's too short

I refactored it into this:

SELECT
dom.id AS "Domain ID",
dom.domain AS "Domain",
(SELECT COUNT(DISTINCT p.post_id) FROM p_posts_spam_domains AS p WHERE p.spam_domain_id = dom.id) AS "Post Count",
(SELECT COUNT(DISTINCT t.domain_tag_id) FROM p_domain_tags_spam_domains AS t WHERE t.spam_domain_id = dom.id) AS "Tag Count"

FROM p_spam_domains AS dom;

And it still times out

9:32 AM

[ SmokeDetector | MS ] Username similar to website in answer: Have the Tree Lounge Advantage patents expired? by rohit on patents.SE

tpu- by Yvette

!!/watch ttconsultants\.com

@tripleee Added ttconsultants\.com to watchlist

[ SmokeDetector | MS ] Manually reported answer: HTML / CSS table with GRIDLINES by noneofyourfingbeeswax simon on stackoverflow.com

Yvette Colomb

@SmokeDetector tpu-

[ SmokeDetector ] SmokeDetector started at rev 3a0989d (SmokeDetector: Auto watch of ttconsultants\.com by tripleee --autopull) (running on teward/Solar Flare)

Restart: API quota is 11118.

[ SmokeDetector | MS ] Link at end of answer: java - equals function wont work by Gloria Tyler on stackoverflow.com

tpu- by Glorfindel

!!/watch grammarchecker\.net

9:37 AM

@Glorfindel Added grammarchecker\.net to watchlist

[ SmokeDetector ] SmokeDetector started at rev 00498a6 (SmokeDetector: Auto watch of grammarchecker\.net by Glorfindel --autopull) (running on teward/Solar Flare)

Restart: API quota is 11078.

[ SmokeDetector | MS ] Bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, blacklisted website in body, +5 more: check outwww.muscle4supplement.com/nitronemax/ by user886807 on superuser.com

tpu- by Glorfindel

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, blacklisted website in body, link at end of body, pattern-matching website in body: than you are acquainted with by Helenechida on superuser.com

tpu- by PeterJ

[ SmokeDetector | MS ] Misleading link: Which data to use for evaluating merged summary, tensorflow by Santiago on stackoverflow.com

JAD

9:55 AM

@SmokeDetector f

[ SmokeDetector | MS ] Bad keyword in body, bad keyword in title, blacklisted website in body, link following arrow in body: Keto Trim This propelled equation by Dorothyapke on graphicdesign.SE

tpu- by Glorfindel

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, blacklisted website in body, pattern-matching website in body: Javascript to write a custom function for by Sww bdj on apple.SE

tpu- by PeterJ

10:10 AM

!!/report meta.stackexchange.com/q/308277/295232

[ SmokeDetector | MS ] Manually reported question: Which is the best online mobile repair shop in oxford? by user386700 on meta.SE

(spam seed)

Are you sure it's spam?

tpu- by tripleee

@NogShine What is the best {business} shop in {town}? is classical setup for a SEO boost spam post

10:13 AM

!!/report meta.stackexchange.com/q/308278/295232

[ SmokeDetector | MS ] Manually reported question: Get Free Amazon Gift Card Working by user386704 on meta.SE

tpu- by tripleee

!!/test-q lnkclik.com/6pBf

> Would not be caught as a question.

!!/watch lnkclik\.com

@tripleee Added lnkclik\.com to watchlist

PeterJ

10:15 AM

!!/report apple.stackexchange.com/q/320132

[ SmokeDetector ] SmokeDetector started at rev 3631ea9 (SmokeDetector: Auto watch of lnkclik\.com by tripleee --autopull) (running on teward/Solar Flare)

Restart: API quota is 10671.

M.A.R. ಠ_ಠ

@PeterJ I like how Tetsujin doesn't VTC spam, but tells people not to

@PeterJ try again?

PeterJ

!!/report apple.stackexchange.com/q/320132

[ SmokeDetector | MS ] Manually reported question: How Do You Choose The Best On the web On line casino For Poker? by PippaMetcalf on apple.SE

tpu- by Glorfindel

10:17 AM

@SmokeDetector k

!!/watch motopoker\.club

@Glorfindel Added motopoker\.club to watchlist

!!/test-q bloggerrama.com

> Potentially bad keyword in body
----------
Body - Position 1-16: bloggerrama.com

[ SmokeDetector ] SmokeDetector started at rev 4ff41bd (SmokeDetector: Auto watch of motopoker\.club by Glorfindel --autopull) (running on teward/Solar Flare)

Restart: API quota is 10640.

Cai

!!/report meta.stackexchange.com/q/308279/307988

10:24 AM

[ SmokeDetector | MS ] Manually reported question: How to choose an efficient Middle ware to suite your system integration needs? by user386686 on meta.SE

tpu- by A J

[ SmokeDetector | MS ] Username similar to website in answer: How do I collect information about my website's visitors? by Kalyan Developers on stackoverflow.com

tpu- by Magisch

!!/watch kalyandevelopers\.com

@tripleee Added kalyandevelopers\.com to watchlist

!!/watch massiltechnologies\.com

@tripleee Added massiltechnologies\.com to watchlist

[ SmokeDetector ] SmokeDetector started at rev 4dfc8af (SmokeDetector: Auto watch of massiltechnologies\.com by tripleee --autopull) (running on teward/Solar Flare)

Restart: API quota is 10447.

10:42 AM

Have we turned on GitHubs vulnerability scanner on MS?

cc @ArtOfCode

@CalvT븃 my impression is that this was Github's own initiative

@tripleee So is it "always on", or a feature that has to be activated?

blog.github.com/… says "we’ve taken an active role in alerting project maintainers of known-vulnerable libraries in RubyGems for Ruby and npm for Javascript"

Yeah just reading that now (found out initially through spiceworks)

Looks like they'd should up here for Art and Undo

tpu by chade_ on Which is the best online mobile repair shop in oxford? [MS]

10:49 AM

@CalvT븃 I was also included on the emails, and I guess Angus and Andy

Yeah ok - that's pretty good on GHs part I've got to say

Guess they email all the owners of the organisation