Tavern on the Meta

RPi Awesomeness

00:10

I have a question for the more Stack Exchange knowledgable.

Frank

@RPiAwesomeness Shoot.

Not that I'm any expert...

RPi Awesomeness

Is there a way that I can get the exact number (no names needed) of followers per tag?

hichris123

@RPiAwesomeness Ask it upon thy great and noble Tavern, and thy shall reap the rewards!

... okay, whatever that meant. :P

RPi Awesomeness

:)

hichris123

@RPiAwesomeness Meaning for all tags?

RPi Awesomeness

00:12

No, sorry. Meant the number per a specific tag

hichris123

Ah.

Isn't that just on the tag's info page?

RPi Awesomeness

I'm creating a a graph (or attempting to) similar to this:

except for SO

Frank

@RPiAwesomeness Hover your cursor over the tag.

RPi Awesomeness

@hichris123 Yes, but it's not exact AFAIK

It's only the nearest thousand

hichris123

@RPiAwesomeness The tooltip is.

RPi Awesomeness

00:14

PSUEDO-SQL: SELECT followerCount FROM Tags WHERE TagName = 'soandsotag'

hichris123

@RPiAwesomeness ^

RPi Awesomeness

Ah

Thank you!

I hadn't tried that

hichris123

@RPiAwesomeness No problem. @Frank actually made me think of that. ;P

RPi Awesomeness

But there's no way to do a batch lookup (eg. SEDE)?

hichris123

Tags
Id
int
TagName
nvarchar (25)
Count
int
ExcerptPostId
int
WikiPostId
int

That looks like a no.

Frank

00:17

Or for a GL tag...

hichris123

Maybe it's in the API?

RPi Awesomeness

bother

Frank

RPi Awesomeness

Is it something a CM or dmod could do?

hichris123

Possibly.

Looks like the API doesn't show that info: api.stackexchange.com/docs/…

RPi Awesomeness

00:19

NBD, I now know how to do it manually. Thanks for the help!

hichris123

Have fun scraping pages! :P

RPi Awesomeness

Would be a handy feature though

:P

Braiam

I remember there's a generic response for these metaQ? meta.unix.stackexchange.com/q/3190/41104

hichris123

-1

Q: I am applying for college credit

Design Patents are only worth a lot of money for rich men, poor people who don't have engineering degrees who designed this patent cannot benefit from the patents, but I am still angry about citation I am applying for hardware design university credit right now with Harvard Corporation. Sean D. ...

us8109579

wut

@Braiam One of which is meta.stackexchange.com/questions/207697/…. :P

Anna Lear

@RPiAwesomeness Diamonds, no. CM (or dev), yes. Takes a DB query. If you want a one-time snapshot of stuff for now, I can get it for you (email me the tags and site(s) - [email protected]). beyond that... I'm not sure aggregate counts are really private info, but we don't currently expose it as far as I know. I'd make a feature-request on meta if you need them on an ongoing basis.

Frank

00:25

@hichris123 looks like ot or vlq.

RPi Awesomeness

00:42

@AnnaLear Thanks! Yeah, this is going to be a one-time thing. I'll email you soon with a list.

@AnnaLear Sent

hichris123

The spammers on my blog haven't caught on yet that I've blocked the keyword "ugg".

RPi Awesomeness

@YiJiang I have a suggestion to add to the wheel of blame. @Seth is a d-mod on Ask Ubuntu and I think he deserves this honor

hichris123

ahahah.

RPi Awesomeness

@hichris123 :P Spammers

Anna Lear

01:02

@rpi Cool. I'll get those to you tomorrow morning at the latest. Just the follower count per tag, yeah?

Gotta grab some dinner before I SQL. :)

Braiam

@AnnaLear that should be in the data dump :(

sometimes I find it useful for nifty stuff

Anna Lear

I'm not sure why we don't include it. Could be oversight, could be technical reasons. Dunno. Feature request it... can't hurt to ask. :)

Frank

^^

RPi Awesomeness

@AnnaLear Yup, just need the exact number of followers per tag. Don't want names, just the exact number.

@AnnaLear To give you an idea of what I'm doing w. them:

I'm attempting to re-create that, albeit using SO tag follows

hichris123

@AnnaLear Gotta ask... dinner at 9 PM?

ɥʇǝS

01:17

What did I do? ;P

Anna Lear

@rpi Gotcha.

@hichris123 9pm is actually almost early for me. Welcome to NYC life. ;) I usually start work around 10:30-11, leave the office around 8-8:30, get home around 9... then cook, etc.

RPi Awesomeness

@ɥʇǝS uh.. Why are you upside down?

hichris123

@AnnaLear Huh, working 10-8 must be nicer than 8-5. :)

ɥʇǝS

@RPiAwesomeness meta. waves hands mysteriously

RPi Awesomeness

@ɥʇǝS Have you been inhaling upside-down gas again?

5

hichris123

01:20

Hmm, need a word here: this situation can be ___ to the present day.

applied? better word for that?

Transposed?

ɥʇǝS

@RPiAwesomeness I think it's just meta's atmosphere. Well.. it used to be :/

RPi Awesomeness

@ɥʇǝS Ah

Frank

@AnnaLear Wow. I get up at 5:30 am, work until 3:00-6:30 pm (unless there's rain), then home. :) I eat earlier than you, antway.

ɥʇǝS

applied works. Transposed.. not so much.

Anna Lear

@hichris Definitely. :) I'm trying to shift my hours to a slightly more normal schedule now that I'm not single, but it's slow going. 40-minute commute and getting up early are the worst.

bjb568

01:22

@hichris123 Because of thisnthat you can see this situation is still relevant to today.

@hichris123 Applied works.

Anna Lear

@frank 3-6:30? that's quite a wide spread.

hichris123

@ɥʇǝS Anything fancier you can think of?

Frank

@AnnaLear I am self-employed, so it's whenever I finish up.

RPi Awesomeness

@ɥʇǝS ˙˙˙ooʇ ǝɯ uo ƃuᴉʞɹoʍ s,ʇᴉ ʞuᴉɥʇ I

hichris123

@AnnaLear How do you commute around NYC? Public transit?

bjb568

01:23

I eat at 10:30 and 15:30-0. That's a range. I am constantly eating.

@RPiAwesomeness 5af0b20c5154e5096766d5f396ca0d46

Anna Lear

yeah, trains and walking.

ɥʇǝS

@hichris123 I'm trying... :/

@RPiAwesomeness :O

RPi Awesomeness

@bjb568 lol, it's upside down text

bjb568

@RPiAwesomeness So?

RPi Awesomeness

@bjb568 Your PC isn't reading it correctly?

Frank

01:24

@bjb568 Hmm, I sometimes forget to eat. But then, I get laughed at for how much I eat at times, especially the time I ate 43 slices of french toast at one sitting.

RPi Awesomeness

@Frank Oh my

bjb568

@RPiAwesomeness I USE A MAC! My message is an md5.

RPi Awesomeness

Oh :)

hichris123

@bjb568 resists urge to comment on Macs

RPi Awesomeness

@bjb568 So...you see those values instead of the upside-down text?

hichris123

01:26

:)

bjb568

Conveniently built into duckduckgo too! ("md5 somethingtoconverttomd5")

ɥʇǝS

md5 has nothing to do with macs..

Frank

@RPiAwesomeness Yep. You can only do that healthily if you are 6' 3" tall, and do lots of physical labor.

bjb568

@RPiAwesomeness No. I just responded with an md5.

RPi Awesomeness

@bjb568 Oh :)

bjb568

01:26

@ɥʇǝS I know. The mac comment was about how I couldn't see it wrong.

RPi Awesomeness

@bjb568 What's it say?

ɥʇǝS

I was searching for a way to brute force it.

RPi Awesomeness

@ɥʇǝS Wouldn't that take a long time?

bjb568

@RPiAwesomeness Sigh. Can't you find a lookup table? Eg crackstation.net

ɥʇǝS

@RPiAwesomeness not md5 :)

"oh noes"

RPi Awesomeness

01:28

Apparently not

@bjb568 Trying to be a l33t h4x0rz are we?

Frank

(: 5dm ton ssenemosewAiPR@

Oops

RPi Awesomeness

lol

bjb568

@RPiAwesomeness It's just an md5…

RPi Awesomeness

@bjb568 Dude. I know :D

bjb568

l33t h4x0rz is an overstatement then. :)

RPi Awesomeness

01:30

@bjb568
751b0f1d79a65361cc18176375a9f0b4734392787541499d856568cb47f73734

hichris123

@ɥʇǝS Why wouldn't transposed work?

> transfer to a different place or context.
"the problems of civilization are transposed into a rustic setting"
synonyms: transfer, shift, relocate, transplant, move, displace
"the themes are transposed from the sphere of love to that of work"

google.com/…

Frank

cy'all later!

RPi Awesomeness

o/

ɥʇǝS

@hichris123 hmm. I didn't say it wouldn't, but (IMHO) it doesn't sound quite right.

bjb568

@RPiAwesomeness What's that?

@hichris123 This idea can be transposed. Not this situation.

hichris123

01:40

@bjb568 Aha. That's why it sounds weird.

> The examples shown are thought provoking as they could be ____ to normal life today.

^ That's my sentence now.

Doorknob

connected?

related?

pertained?

english.stackexchange.com?

hichris123

@Doorknob ELU is not a verb. :P

ɥʇǝS

ah, yes, transposed does sound ok in that sentence.

changed my mind.

bjb568

"The examples shown are thought provoking as they could be ____ to normal life today." is useless. Either show me how (and leave it to the reader to infer that it's applicable) or use the idea in a transition (from this is what happened then -> (NOTICE THE SIMILARITIES?!?!?!) this is what happens now (IN CONCLUSION HERE ARE THE SIMILARITIES!!!))

hichris123

@bjb568 This is a transition more of in a conclusion.

bjb568

01:51

@hichris123 I know. So make it a transition. Eg: "The development of cars in the 500s made people like cars. Then everybody use cars. (<-transition) Now we use cars." Not something vague like "this is applicable BECAUSE I SAID IT IS BECAUSE IT'S REQUIRED"

~500s, right? :P

RPi Awesomeness

@bjb568 SHA256 for I am a l33t h4x0rz.

bjb568

@RPiAwesomeness Ah.

RPi Awesomeness

:P

hichris123

@bjb568 My next sentence is a "For instance". :P

Do you guys have to use turnitin?

Doorknob

02:08

Never heard of that.

hichris123

@Doorknob turnitin.com/en_us/home

Doorknob

> What's Wrong with Wikipedia?

Nopenopenope ctrl+W

bjb568

But when somebody elaborates on "this is important now" I think "I don't care go away, stop shoving fabricated information down my throat". You need to prove a *point* (that isn't "this is important now", for that you need a relevant transition) with smooth transitions, not [talk about blah] NOW I'LL TALK ABOUT HOW IT'S RELEVANT TODAY [talk about blah today]. Like [here is history of blah and how it smoothy evolved from then to now]. Or for a single subpoint, "these people making carz n stuffz are kewl cuz they makz ussez think abutz helicooopter (single sentence, not "these people makin ca…

hichris123

@bjb568 ... this is very vague 'cause I don't want to get "caught" plagiarizing off of myself. :P

bjb568

@hichris123 Well, when in doubt replace carz with purple elephants or whatever.

hichris123

02:12

heh

Lynn Crumbling

@bjb568 you mean unicorns, no? :)

bjb568

@LynnCrumbling Too notuselessandboring for a real assignment where you can't plagiarize.

hichris123

@bjb568 Ooh, private gist. gist.githubusercontent.com/hichris1234/87af947077b175000c3e/raw/…

Doorknob

@hichris123 Encoding fail. (at the end :P)

hichris123

@Doorknob Yup. :P

bjb568

02:14

I dont' see an encoding fail… Macs!

hichris123

@Doorknob Fixed. gist.githubusercontent.com/hichris1234/87af947077b175000c3e/raw/…

So thoughts @bjb568?

AstroCB

cv-plz stackoverflow.com/questions/26269221/…

bjb568

@hichris123 Will comment on it.

AstroCB

@hichris123 What did I just read?

hichris123

@AstroCB Conclusion to my paper.

AstroCB

02:18

I see.

You are taking it wrong , i know its my mistake — Imran Rizvi 1 min ago

Santa Claus

Why are we talking about english I do not like english.

SmokeDetector

[ SmokeDetector ] All-caps title: PLEASE HELP, HOW TO WRITE JAVA CODE THAT WILL MAKE PARABOLA / STRAIGHT LINES on stackoverflow.com

APerson

I am now going to shamelessly plug a question I just asked. It includes freehand circles, so I should be fine. Please look athttp://meta.stackexchange.com/questions/240740/confusing-linkification-in-pend‌ing-edit-message

oops meta.stackexchange.com/questions/240740/…‌‌ing-edit-message

bjb568

@hichris123 Comment added.

Oh, it's a conclusion? Then it needs to summarized your points made. What are your points?

How about 0? Line with slope 0 or parabola with a derivative of the same line! It covers most of the assignment. — bjb568 9 secs ago

bjb568

03:14

Night!

Lynn Crumbling

'night

Anna Lear

03:41

@RPiAwesomeness Out of curiosity... do you care about people who signed up for email updates for questions in a tag or just people who marked a tag as interesting/favorite on SO?

I'm starting to see why we don't expose this. A bit more complicated than I'd thought.

@Frank Reasonable. What do you do, if I may ask?

SmokeDetector

04:23

[ SmokeDetector ] All-caps title: A CONTINUOUS ARRAY OF EQUAL SIGNS APPEAR IN ADDRESS BAR on askubuntu.com

[ SmokeDetector ] All-caps title: A CONTINUOUS ARRAY OF EQUAL SIGNS APPEAR IN ADDRESS BAR - UNABLE TO UPDATE TO 14.04 on askubuntu.com

jadarnel27

Hey, some people are trying to sleep in here, SmokeDetector.

Keep it down.

Jan Dvorak

04:52

SPAM drupal.stackexchange.com/questions/132055/…

SPAM drupal.stackexchange.com/questions/132059/no-plastic-surgery

SmokeDetector

[ SmokeDetector ] All-caps title: CONTINOUS STREAM OF EQUAL SIGNS APPEAR IN ADDRESS/SEARCH BAR - UNABLE TO UPDATE TO 14.04 on askubuntu.com

Jan Dvorak

SPAM meta.stackexchange.com/questions/240742/…

!!die

Jan Dvorak

05:05

nuke-pls stackoverflow.com/questions/26270705/…

DroidDev

Morning!

Jan Dvorak

Morning!

Unihedron

Morning!

Jan Dvorak

ot-specific-site meta.stackexchange.com/questions/240743/…

SmokeDetector

[ SmokeDetector ] Offensive title detected: How the phrase 'Holy Shit' is formed? on english.stackexchange.com

SmokeDetector

06:21

[ SmokeDetector ] All-caps title: VANSH TRAVEL A BOOKING POINT on travel.stackexchange.com

Jan Dvorak

SPAM graphicdesign.stackexchange.com/questions/39669/…

SPAM meta.stackexchange.com/questions/240746/a-professional-or-even

Jan Dvorak

07:17

SPAM drupal.stackexchange.com/questions/132072/…

SPAM drupal.stackexchange.com/questions/132073/…

Andrew T.

07:47

drupal meta spam gone

graphic at -8

Bart

08:06

All gone

Andrew T.

!!/alive?

SmokeDetector

@AndrewT. kinda sorta

Jan Dvorak

@AndrewT. *yawn*

Bart

@AndrewT. Ask again after coffee

Andrew T.

(._.")

Unihedron

08:14

This needs to go to Server Vault... stackoverflow.com/q/26250361/3622940

Jan Dvorak

+2? I give up on voting

Unihedron

It is pretty clear.

Jan Dvorak

still a "do x for me"

Unihedron

This is pretty close to entering the commitment: Lifehacks

Vogel612

@Unihedron 10.6% of users also following: Pastafarianism

which is almost as close to commitment...

Unihedron

08:19

Pastafarianism vs Lifehacks, place your bets!

Jan Dvorak

SPAM askubuntu.com/questions/533971/…

SPAM superuser.com/questions/822947/…

Vogel612

both down

Jan Dvorak

08:36

SPAM drupal.stackexchange.com/questions/132080/…

SmokeDetector

[ SmokeDetector ] All-caps title: TP-LINK TF-3200 on askubuntu.com

SmokeDetector

08:51

[ SmokeDetector ] All-caps title: VB.NET CHROME LIKE NEW TAB BUTTON on stackoverflow.com

[ SmokeDetector ] Bad keyword detected: What is procedure of weight loss? on drupal.stackexchange.com

Vogel612

spam......

Jan Dvorak

SPAM askubuntu.com/questions/533983/…

Vogel612

09:07

down

Avinash Raj

09:18

is this feature implemented?

Unihedron

@AvinashRaj Read:

> Preface - nothing is currently planned, I'm just hoping to get some feedback and ideas.

Avinash Raj

too lazy to read

Jan Dvorak

cv-pls stackoverflow.com/questions/1598175/…

Unihedron

0

A: Empowering tag-badge holders part II - let's look at silver?

I have a different suggestion - (to) Allow silver and gold badge holders to downvote answers on questions with the tag without the -1 reputation penalty. Since silver and gold badge holders scores enough to sufficiently prove their knowledge, they should be trusted to be sane enough to cast downv...

Jan Dvorak

09:37

cv-pls stackoverflow.com/questions/26274980/…

Unihedron

One non-other flag needed: stackoverflow.com/questions/24992180/…

Jan Dvorak

@Unihedron which one?

Unihedron

@JanDvorak the comment

Jan Dvorak

other than other than other

Unihedron

obsolete

Jan Dvorak

09:43

meh... but anyways... nuked

Unihedron

\o/

Avinash Raj

@Uni nice meta.stackexchange.com/a/240753/252328

Unihedron

@AvinashRaj Thanks, just my $0.02.

Frank

10:05

@AnnaLear landscape design, installations, maintenance, lawn seeding, care package, mowing, tree pruning, spraying, removal, specialty pruning, etc... The actual list is much longer, but those are some main things.

SmokeDetector

[ SmokeDetector ] All-caps title: DECREASE THE RELEVANCY/WEIGHT OF A PARTICULAR MANAGED PROPERTY IN FAST SEARCH on sharepoint.stackexchange.com

Unihedron

review-pls stackoverflow.com/review/reopen/5956936

Frank

SPAM gardening.stackexchange.com/questions/14330/…

SPAM gardening.stackexchange.com/questions/14328/…

Jan Dvorak

@Frank deja-vu or a recidivist?

Frank

@JanDvorak huh?

Jan Dvorak

10:19

I'm sure I've seen this guy already

and I don't mean the question

Frank

@JanDvorak What guy?

Jan Dvorak

I'm sure I've seen the spammer already

SilentKiller

both spam at -6

SPArchaeologist

Looks around and notices that the ~~sna~~ bird still isn't anywhere to be found

Frank

Why is Zephyr going crazy and posting lots of spam by himself?

@JanDvorak Where?

Jan Dvorak

10:22

@Frank link?

Must've meen deja-vu. This is my first spam flag on a GL answer.

Frank

Low Quality Posts HQ

Home of bots for catching low quality posts (and sometimes spa...

Jan Dvorak

g2g food

::poof::

Frank

@JanDvorak cya

Unihedron

@JanDvorak bye!

Frank

Finally! I was wondering when this was coming... but I seem to have answered 7 out of the 9 questions. Are they picked randomly? — J. Musser 5 mins ago

Unihedron

10:34

@Frank You're asking the bot? Ha?

Frank

@Unihedron Posting a comment, so that people will see it.

I don't generally talk to bots.

Pham, on occasion, but not most bots.

SPAM gardening.stackexchange.com/questions/917/…

two GL spam still there...

hichris123

10:53

@Frank That's still there, the other is dead.

Avinash Raj

cv stackoverflow.com/questions/26276596/…

Jan Dvorak

11:24

@Frank, @Unihedron no goodbye pings after a ::poof::, please

Unihedron

status-rejected

Vogel612

status-who-would-be-so-cruel

SmokeDetector

[ SmokeDetector ] All-caps title: CALL FOR PRIOR ART: EP1668450B1 on patents.stackexchange.com

Jan Dvorak

downvote-pls puzzling.stackexchange.com/a/2711/284

RPi Awesomeness

11:40

@AnnaLear Nope, just need the total number of people marked a tag as interesting/favorite on SO.

@AnnaLear Just wondering, no need to answer if you can't, but what makes it so complicated? I mean, if you're already getting it for the tooltip on the popup, it shouldn't too hard to make it available on SEDE IMO.

Obviously, I've never seen the backend/had access to the full DB, but unless it's stored w. other user info, couldn't you just grant SEDE lookup access for that number?

Jan Dvorak

nuke-pls stackoverflow.com/questions/26277050/…

GreenAsJade

I love the new review "rejection reasons".

Unihedron

@GreenAsJade I don't. :(

GreenAsJade

Heh heh. Well. FWIW, at least someone (me) does. I just popped in to say that :p

Sam

12:01

Hiya

Unihedron

Hiya @Sam!

Jan Dvorak

12:31

SPAM superuser.com/questions/823035/…

SmokeDetector

[ SmokeDetector ] Phone number detected: MySQL replication slave got 2147483647 (INT32_MAX) in a column for time stamp on serverfault.com

Jan Dvorak

cv-pls stackoverflow.com/questions/26278555/…

I'm not offended by your question... — Jan Dvorak 11 secs ago

nuke-pls stackoverflow.com/questions/26278595/…

Sam

SPAM stackoverflow.com/questions/26278481/…

gone

Jan Dvorak

mod-hammered before it even hit the realtime tab

oh - wait. It flew past the realtime tab for a different reason

any more "I'm offended by" jokes? meta.stackexchange.com/questions/240761/…

SPArchaeologist

12:49

@JanDvorak I am thinking of posting a reply that references the categorical imperatives theory from Kant. ^_^

Vogel612

@SPArchaeologist go ahead.

Sam

in Low Quality Posts HQ, 57 secs ago, by Pham

Low Quality A (100%): You provide me rectangular PVC me in jaipur ..., by pankaj, on diy.stackexchange.com.

^ naa plz

Unihedron

@Sam Oops, I flagged VLQ instead by accident.

Sam

:O

Vogel612

status-good-enough

Jan Dvorak

13:07

unclear tex.stackexchange.com/questions/205294/ajouter-le-mot-chapitre

Jan Dvorak

13:21

nuke-pls stackoverflow.com/questions/26279530/…

Andy

13:33

One internet cookie for the person that can find the Meta post about the offensive SE blog that had a picture of a woman on it. If it's a deleted post, another cookie for a screenshot of said post

jadarnel27

What kind of cookie?

Oreo-internet-cookie?

Braiam

@jadarnel27 brown cookies

jadarnel27

@Braiam I better get to searching then.

note to self: @Braiam knows my kryptonite...

Unihedron

13:51

chat.stackexchange.com/rooms/17616/hackoverflow

Low Quality Posts HQ

Transcript for