« first day (2351 days earlier)      last day (2899 days later) » 

00:41
@JonEricson Why do your parents have grave stones in their backyard? Are they living like Mortimer and Bella Goth?
user202362
only if we could have cemeteries in Antarctica, crystal coffin, crystal tomb stone in ice
user202362
and no dear deer visiting
@Shog9 linkrot prevention rotted... :/
@JamesENL Their house is located on the behind a cemetery. We can't actually see the headstones from the house, however.
Oh I see
That makes more sense
Now I want to go back and play the original Sims
user202362
01:03
Microsoft headquarter in Australia is located 150 meters away from a big cemetery, but then again, Oracle & Honeywell are kind of next door too.
user202362
they are putting a lot of new high rise residential buildings near the cemetery too because of a recently built train station
user315433
02:06
I pressed backspace half-way through filling out a long form, when the textbox didn't have focus... and nothing happened. Thank you, Chrome!
user315433
Why aren't comments that consist of nothing but "@user thank you" or "You're welcome" one-flag deletable? I'd say they have less value than nagging to accept answers.
02:34
@zaq The "accept this answer" comments have negative value because they make the place a little less friendly. The polite niceties do the opposite. Both are quickly obsolete, however.
user315433
Yes, I think a year-old "you're welcome" holds exactly 0 value. Or a month old. Or a week.
user315433
My research indicates that among the non-very-large sites, Magento and TeX lead in accept-answer-plz category.
user315433
While DIY goes the opposite way, with comments telling answerers that it's rude to ask for question acceptance.
user315433
03:04
According to developers.google.com/products Google still doesn't have any products with names beginning with X or Z...
Good thing they bought YouTube. . .
user315433
03:18
J is also poorly represented, given it's the top first letter of SO tags. Only one product, j2objc, and it's not that popular: under 100 questions, most of them answered by the project lead.
user202362
X, an American semi-secret research-and-development facility founded by Google in January 2010 as Google X, operates as a subsidiary of Alphabet Inc. X has its headquarters about a half mile from Google's corporate headquarters, the Googleplex, in Mountain View, California. Work at X is overseen by entrepreneur scientist Astro Teller, as CEO and "Captain of Moonshots". The lab started with the development of Google's self-driving car. On 2 October 2015, after the complete restructuring of Google into Alphabet, the company was renamed to X. == Projects == While X projects are often referred to as...
user202362
in the history of man kind, nothing significant is known to be developed by secret societies of any kind
user202362
so maybe secret societies do exist, but that's kind of irrelevant when we look the bigger picture
user202362
Secret societies are lot like someone else silent smelly fart, someone knows about it, many suspect it, but in the long run it really makes little difference
user202362
03:43
that's not saying that they don't produce anything of significance at all, but when they do, they are probably like 'look at me, me did this, all me' and a part of them become no secretive
user202362
user315433
04:45
Reached 60,000 helpful flags network-wide. Still a long way to catch up with @Andy who has 109,728 network-wide...
user315433
Andy's site-by-site helpful flag counts:
user315433
107715 flags on Stack Overflow
515 flags on Hardware Recommendations
319 flags on Drupal Answers
271 flags on Meta Stack Exchange
216 flags on Super User
165 flags on Ask Ubuntu
user315433
05:42
@xkcdBot never posted Monday comic, maybe it has a little backlog to deal with?
user315433
07:06
@zaq there was even a review queue for it, not linked anywhere, think I was able to perform couple of such reviews. ;)
in Familiarity with SE! on The Stack Exchange Network Chat, 12 hours ago, by Aaron Hall
hi! What's this room here all about, now?
@AaronHall you know @Pandya can't reply? The room is frozen....
Though I would expect that mods will not see the usual UI when room is frozen
(or at least confirmation when posting "room is frozen, submit anyway?")
user315433
Is this appropriate for respectful discourse? I'm guessing no.
user202362
Now thinking about it, Java is incredulously lucky - it overtook C++ & was dominating the market until C# came out. But before it's overtaken by C#, smart phone came out. And objective C has become popular because iOS was dominating the market. But before objective C/swift could even come close to Java, android has taken over the smart phone market ... and guess that's android app's main development language? Java.
@Telkitty but who profits from this?
user202362
java developers? :p
07:21
@Telkitty heh... I mean is the Java language itself patented and someone getting money from people using it for programming?
user202362
Java was developed by Sun Microsystems, owned by Oracle
user202362
Now waiting patiently for Oracle phone </trollololo>
user202362
speaking of which, Sun Microsystems was acquired by Oracle, both disappeared from news
@ShadowWizard Btw, don't too much bother for my trouble or feedback. Just chill. I never get disappointed in the world of SE! :)
@Telkitty in those cases, usually "no news is good news", they work silently on new stuff, without any drama. ;)
user202362
07:37
pretty sure the company I heard the most last year was Tesla :p
user202362
elon musk the shameless self promotor, I love it!
user202362
role model :p
@Pandya I'm chilled as ice. Or Chili. ;)
@Telkitty isn't he the one who lost a space rocket, wasting billions of dollars to others who relied on that rocket?
@Telkitty well, automated cars are no doubt the next big thing, along with IoT
@ShadowWizard lol
Btw, do people here consider lol = Haha?
user315433
No, there's a big difference.
07:43
ok
Star what you like from:
lol
5
Haha
5
user202362
then there is rofl & roflmao
hihi
hehe
hoho
07:52
:)
:D
user202362
solar power will be next 'in' thing too
user202362
how many spaceships have amazon crashed?
@Telkitty solar has two possibilities 1.utilizing heat and transfer into electric 2.using direct radiation to convert into electric. Which one are you talking about?
user202362
both about translate EM wave into electricity
07:57
@Telkitty spaceships?? None... unless I missed something? They only use automated small aircrafts for delivery, no?
@Telkitty not sure, it exists for many years and nothing really changed/developed in its technology as far as I know.
user202362
@ShadowWizard err, you need to read upon blue origin
08:12
@Telkitty oh... lol, didn't know/forgot that it's the same man. But it doesn't belong to Amazon. :)
08:47
So, will Yahoo! still be Yahoo!? Or will it rename to Altaba? @zaq you probably know?
user202362
why would zaq know?
That said... "Altaba" is horrible name, meaningless and hard to remember.
@Telkitty because he knows stuff... I know he knows. :D
user202362
zaq knows many things?
user202362
we need to hide that before ppl rushing in & ask zaq to fix all compilation errors
09:16
it can take some hops. I assume 6 to 8 hops?
user202362
I have been reading upon xcode related question and answers, I could not but say this with relief: going straight from xcode 4 to 8 is the right idea. One could save so much time skipping 5, 6 & 7
user202362
literally half of the things you learn in one version would be obsolete in the next
user202362
productivity - humans sure knows how to improve it
@rene or one big hop
So ... xcode is actually usable now?
Haven't had to use that monstrosity in a while now. And it feels great
09:24
@Bart you probably read too much in that message ...
Probably
Perhaps
Final delete vote needed here, though feel bit bad for Mr. Barth there. @rene @Bart
Screw the Dutch
09:37
Doesn't the edit make it on-topic?
and I already delete voted there
Barth is dutch too?
I believe so, yes
@Bart sha decided it isn't ... we just follow here ...
Done
@rene haha. coming next: recommending jumping from a cliff :P
10:01
@ShadowWizard like this?
10:12
@rene exactly! And I played that game loooooooooooong ago... :D
Yeah... don't tell me about it ...
But I just did.... ;)
That isn't that long ago.....ah .... crap
@Bart I was 15. Do the math. ;)
Granddad ...
10:24
Geez you're old
No, you are :D
Nah, I'm still 29
If you're 29 @Bart then I'm 92
reminds me, @nicael always claimed he's 100 years old
I'm way too old for this
"Murtaugh" is the 19th episode in the fourth season of the television series How I Met Your Mother and 83rd overall. It originally aired on March 30, 2009. In this episode, Ted and Barney feud over what activities are appropriate for their age, while Marshall and Lily disagree on how to coach Lily's students. == Plot == Barney is banned from laser tag for being too rough, so he plans to toilet paper the arena. Ted notes that Barney is too old for laser tag, and reveals his "Murtaugh List" of things he believes he is too old to do anymore. Barney "accepts" the "challenge" of completing the entire...
You saw it?
@M.A.R. is young
10:27
In biology, offspring are the young born of living organisms, produced either by a single organism or, in the case of sexual reproduction, two organisms. Collective offspring may be known as a brood or progeny in a more general way. This can refer to a set of simultaneous offspring, such as the chicks hatched from one clutch of eggs, or to all the offspring, as with the honeybee. Human offspring (descendants) are referred to as children (without reference to age, thus one can refer to a parent's "minor children" or "adult children" or "infant children" or "teenage children" depending on their age...
Well, technically, I AM a young.
@M.A.R. and not technically?
Not technically, irrelevant matter to the context are not intended.
Can a chemical substance age, anyway?
The active ones might.
are users allowed to programmatically call the stack exchange website endpoints to add new buttons (or place existing buttons in new places) via user scripts?
10:35
@M.A.R. and you're active?
@Derpy Users do add buttons all the time, but calling names is rude.
@ShadowWizard Nope, unfortunately not.
@Derpy what "endpoints" exactly?
@M.A.R. so you don't age. Cool!
There was a 13.2 percent chance that I might have, though.
Oh wait, no
example: from what I get, the avatar picture upload uses (simplified for sake of brevity) the url
http://meta.stackexchange.com/upload/profile-image/{user-id}/true
... can I do the same from an user script?
@M.A.R. waiting
@Derpy as long as you don't grind the server with 100 requests per minute yes, can't see a reason why not.
10:39
That's 20 times 1.1 plus 20 times 0.02.
So 22 plus 0.4 gives 22.4.
I once tried to make a script that auto change my avatar. lol
There was a 22.4 chance that I be active.
@ShadowWizard nothing like that.
@M.A.R. was? When did the chance expire?
@Derpy so yeah, go ahead... those "endpoints" are visible in the client side code
Well I can use past tense because I'm not active.
The chance doesn't need to expire.
10:42
@M.A.R. let me rephrase... when did you realize for sure you're not active and that it's not going to change? :)
A couple of minutes ago.
oh my
You rolled dice?
@ShadowWizard And avatar is now your child's child's chid! Haha
@Pandya hmm? Didn't get it... thinking harder
@ShadowWizard No, I checked my mass, and well, that's like rolling a dice indeed.
10:46
@M.A.R. well, it depends what you wear. With chemicals, any gram matters.
@Derpy yes, but they are not part of an API that is supported or guaranteed to be stable so don't whine on meta if they break your userscript on the next build.
@ShadowWizard that was comment on your saying "I'm 92 years old"
@ShadowWizard I'm covered with non-polar electron cloud.
@Pandya ohhhhh.... missed it's a reply. LOL
That happens at your age
10:47
:P type Haha
@M.A.R. cloud is transparent, you know.
@Pandya Gosh, so Shadow will give birth to a pair of glasses?
@ShadowWizard Not these
@M.A.R. pic or it never happened
why bart doesn't like shadow
10:49
@M.A.R. nice cloth! So you are that pink dot in the middle?
That's not me. I don't put pics of myself on the web.
Never figured you'd be pink, @M.A.R.. Gives whole new perspective. :D
And her electron cloud is too showing.
I don't wear clothing like that.
@M.A.R. why? What might happen?
See @Bart for example. He does that, and he's just fine. :P
@ShadowWizard Well, the biggest reason is that I'm too lazy to shoot a good pic.
10:53
@M.A.R. so put a bad pic... better for you, nobody will really recognize you... :D
11:11
@rene considering that basically I am doing this just for fun since no one will probably ever user the script other than me... no problemo.
 
2 hours later…
12:42
@ShadowWizard Oops - frozen rooms look unfrozen to mods. My mistake. I posted that thinking that it was currently in an unfrozen state.
I thought it was a meta room, and I had no power there.
@AaronHall no worry, guess it's confusing indeed... :)
BTW, you also have the ordinary Answer section on closed and deleted questions?
Not that I recall.
Interesting... guess chat gets less attention for those things. :)
 
1 hour later…
13:58
!!/tea for @Pandya and @Derpy
@ShadowWizard brews a cup of darjeeling tea for @ShadowWizard
dar what... ?!
Darjeeling tea is a tea from the Darjeeling district in West Bengal, India. It is available in black, green, white and oolong. When properly brewed, it yields a thin-bodied, light-coloured infusion with a floral aroma. The flavour can include a tinge of astringent tannic characteristics and a musky spiciness sometimes described as "muscatel". Unlike most Indian teas, Darjeeling tea is normally made from the small-leaved Chinese variety of Camellia sinensis var. sinensis, rather than the large-leaved Assam plant (C. sinensis var. assamica). Traditionally, Darjeeling tea is made as black tea; however...
@GrenadesPlus ohhh... yummy!
!!/coffee for @Gren
@ShadowWizard brews coffee for @ShadowWizard
14:08
Why no special coffee? :(
yey coffee > tea
Someone mentioned coffee?
!!/tea for @ShadowWizard
@GrenadesPlus brews a cup of chamomile tea for @GrenadesPlus
14:08
lol
@Bart \o/
Oh, yeah... time to fire up the nespresso...
@Bart heh, you got a trigger? ;)
user202362
!!/wine
user202362
whine!!
14:09
if (message.contains("coffee"))
    ringTheBells();
@ShadowWizard coffee always works
!!/tea for @Bart
@GrenadesPlus brews a cup of mint tea for @GrenadesPlus
mm mint
Make it mate then at least
14:10
@Bart not for the poor souls who can't drink it, like @Magi :/ \:
That I can accept
user202362
!!/brownie
@Telkitty Brown!
@ShadowWizard I can, but I choose not to
@Magisch oh, thought you're allergic to milk
i.e. upset belly if you drink it
14:11
I am, but black coffee exists
true, lol
I can also drink milk
nothing is physically preventing me from it
I just rather not because of the consequences
@Magisch of course, no sense eating or drinking something that would make you ill...
... like alcohol
user202362
the popup ''click for message actions" when onMouseOver a message, is it new?
14:16
What, the title text of the <a>?
@canon alcohol also makes you happy, so different... ;)
@Telkitty hmm, pretty sure it is new indeed
user202362
Oo, no wonder I didn't notice it before
14:40
@ShadowWizard jumping down a cliff makes you fly (for a very short time), wonder why no one tries that... -_-
maybe you are immune to bullets, but you will never know :)
@Derpy hmm... interesting point of view! Guess it's about chances of surviving, etc. :D
alcohol won't kill on spot, that's what matters for most people. :)
mine is not interesting D:
dies
revives @Gren
dies again
14:43
sending @Gren's body to Den
so long! And thanks for the fish!
no fish here, just cow
@GrenadesPlus mad cow
14:48
O_o
TIL Jon skeet has more then 20.000 accepted answers on SO
@Stijn 42 dollars
user315433
@ShadowWizard It doesn't look like anything changes at all as far as user facing Yahoo properties are concerned. We are not in any danger of losing Yahoo Answers.. theverge.com/platform/amp/2017/1/9/14219914/…
@zaq bummer... I was hoping for that. :)
user202362
I wonder it's possible to infer the worse compiler/OS/programming language by the amount of views to answer upvotes ratio
14:59
No, by the amount of views powered by answer upvotes . . .
user202362
I wonder if some IDE/OS even thinks it's okay to bring out buggy software, because 'hey, let our users find a way around it and share the solution on the internet'
@Telkitty Microsoft's tech support strategy in a nutshell
@Magisch They care about people and their ingenuity
user202362
after trauma with some sh!tty IDE, I just want to say 'gdb, I never realise how great you are, I love you'
user202362
15:19
gdb on linux that is
That's either sadistic or perfection of trollism
user202362
I would only call programming on linux 'pure programming', like pure math
@Telkitty Very theorethical, unpractical and largely a matter for academics?
user202362
Well, program runs on linux like it's transparent, there aren't a lot of pretty interfaces, it would crash because of IDE issue.
user202362
It doesn't change much, tools wouldn't be moved around with each upgrade
user202362
15:25
of course you can upgrade your compiler
user315433
Optimizing Websites like Stack Overflow -- new podcast featuring Nick Craver.
user315433
> Under-appreciated @StackOverflow feature of the day: question navigation via j/k -- rossipedia at 6:00 AM - 10 Jan 2017
user315433
Yeah... I don't appreciate it either. Questions are not like emails to go through.
user315433
> My home brew made a loud BANG! at 2:30 am. Vigorous fermentation blew the airlock off th carboy. Beer hit the roof! Shoulda taken a photo. -- David Haney at 5:30 AM - 10 Jan 2017
user315433
15:32
135 is enough where I come from
It needs further investigation
16:26
@Magisch holy shit, is that right?
user315433
user315433
Of them only 349 have 0 score. I think I can beat Jon Skeet in that category.
user315433
In a few years, that is. And assuming no further deletion of accounts.
user315433
16:43
Jon Skeet in #67 in 0-score accepted answers. The top three are Gordon Linoff (2687), anubhava (1984), and CommonsWare (1847).
@canon yah
Jon Skeet is ridiculously active
user315433
Historically speaking, not as much recently. He posted 889 answers in 2016, less than 2.5 answers per day.
user315433
Jon Skeet's rank in yearly rep league, 2008-16: 1, 1, 2, 1, 1, 2, 4, 6, 11.
still more then any but the top 0,01% of SO
He's still rocking at least 200 rep a day
user315433
Yes, but "collecting rep on a large number of old answers" is not the same as "being ridiculously active".
16:52
2,5 well recieved answers a day is ridiculously active by so standards
considering only 8% of users ever post more then one answer
user315433
I guess I'm just a little tired of Jon Skeet memes, as probably he is himself.
user315433
There are many users who do a lot for SO.
user315433
jezrael posted 2809 pandas answers in 2016. I think this more or less closes the book on pandas, except for new bug-features they add in each version.
user315433
17:31
> According to 2016, we hesitate between 60-80 questions per day. By 2017, I want you to wander between 120-140 questions a day. -- Objetivos del 2017 - Primera Parte (1) by Juan M on meta.es.stackoverflow.com
user315433
And also to come to work on Saturday?
user315433
In the post, Juan says es.SO needs better answered % to graduate... their 74% isn't so bad, en.SO has 72%.
user315433
I don't really see why this particular stat should delay mod election.
user315433
18:01
I'd suggest posting fake questions and answers on Stack Exchange with links to your site, but you already know that. — zaq 52 secs ago
18:56
/me be in the library, taking some math test as I do
principal comes in with a group of prospective 7th graders and parents
talks about placement tests and how some 11 year old was in BC calc
/me considers how I'm now a poster child to be used on prospective student tours forever
flags @bjb568 for being under 13
:p
I'm older now.
Too old.
'bout to die.
Must suck being old and almost in the real world.
user315433
19:26
@bjb568 Heh, I've been there. A bit of added pressure on younger relatives attending the same school.
user315433
OMG, zaq University changed its domain from zaq.edu to zaqwert.edu and began using www. prefix. I don't know if I can stay here.
user315433
> Another decision was to solely use “zaqwert.edu” as the University’s domain name, folding in the second domain name used by the University previously, “zaq.edu.” In addition to being more recognizable, the change will contribute to improved search engine optimization.
user315433
SEO strikes again...
user315433
But the site no longer has an ugly Facebook widget in the center, so a definite improvement overall.
19:43
www prefix serves a purpose...
user315433
19:59
Concerning Spam-Flag Wave seemed to crash chat, it would make sense for lang-SO to not broadcast flags beyond the site... Or be on a separate chat instance, if practical.
user315433
2
Q: Stack Exchange Global Flag Summary

FloernProvides a network wide flag summary for all Stack Exchange sites. If you are logged into the Stack Exchange network and you have this script installed, you can visit the new flags tab in your Stack Exchange profile: How does it work? The script scans your network profile for all Stack Excha...

user315433
Ooh nice. I used a Python script to get network-wide summary, but without logging in, hence without flag status.
user315433
@zaq How'd you get to 60k? I'm only at 13.8k overall
user315433
user315433
tl;dr Less sophisticated than Andy, more like regex than ML.
Ah, that
user315433
It's not all comment flags of course. 5,279 spam flags on Drupal, all helpful.
Using Drupal is almost cheating :)
user315433
Less so than using comments on SO. :)
20:20
That's fair
user315433
I also have a network-wide NAA searching thing, although I suspect most of those flags are probably redundant.
@bjb568 You really did BC as an 11yo?
20:39
[ SmokeDetector | MS ] Shortened URL in answer: How to automatically convert the word document into PDF? by Lindsey on sharepoint.stackexchange.com
user315433
@SmokeDetector false alarm again
@zaq Registered answer as false positive.
user315433
You verbose-by-default bot, you...
We could probably move away from that
Instead of fp and fp- commands, have fp+ and fp commands
user315433
Ah, I think nobody uses "false" anymore, I just wanted to construct a sentence
user315433
20:44
Argh, same user again with their thing.
user315433
I even suggested an edit to the first post, replacing bit.ly by actual link. Not anymore.
user315433
Why bit.ly still isn't banned network wide remains a mystery.
20:58
I didn't feel like maintaining 6 long regexs across hundreds of sites
user315433
How about short regexes that kill 99% of short URLs?
@Shog9 Hypothetically, how hard would it be to make the database column larger?
Maybe
user315433
Common shorteners used in SE spam according to Metasmoke: bit.ly, goo.gl, tinyurl.com, ow.ly
user315433
Additionally, ad.fly and adfoc.us - not as common, but ads by design.
21:02
I'm sitting in a waiting room with nothing better to do.
Dig up a meta request
user315433
104
Q: Ban URL shortening services

Time Traveling Bobby Related: Ban LMGTFY links | Shall we spam-flag lmgtfy-links? | URL Shorteners cleanup Ban URL shorting services from being used in questions/answers. I have three major reasons to request this: It's abused to hide LMGTFY-Links (interestingly, this behavior ranges from the 20 rep Newcomer t...

user315433
Apparently, today's kids need 3D immersive environment to learn calculus... variant.triseum.com
user315433
21:28
A waiting room can be an okay place to deal with work related stuff, although it depends on what one is waiting for. Sometimes it's "let's first see if I make it out alive, no point in worrying otherwise..."
0
A: Ban URL shortening services

Shog9Automated blocking or rewriting is probably never going to happen; as Jeff notes, that gets quite expensive. But there's some educational value in limited blocking of specific, popular shorteners. We've been trying this out on Stack Overflow for a few months now, and the results have generally b...

Sometimes it's "hey, how many times can I lose my work in this table editor before I throw this phone across the room?"
Good distraction though
user315433
I hope you didn't have to copy-paste it 300 times on a phone...
21:44
@Shog9 users' "Annotation page" was just referenced by a mod in another chat room (nothing specific, just that they exist). Is it possible to request a copy of one's own annotation page? I was told to ask you.
@mikeTheLiar sure.
You won't get it, but nothing stopping you from asking
user315433
> Access – Upon request, we will provide you with reasonable access to the personal information we collect about you. You will have the opportunity to correct, update, modify or delete this information by sending an e-mail to [email protected]. [...] we may limit an individual’s access to personal information where the burden or expense of providing access would be disproportionate to the risks to the individual’s privacy or where doing so would violate others’ rights.
Mods talking about pages they don't really need to be...
21:54
If youve never been suspended, there are probably no annotations on your account; if you have been, then you already have the information (unless you deleted the emails unread)
@Shog9 would this apply to chat suspensions as well? I've gotten (short) chat suspensions before but never an email.
@mikeTheLiar yeah
Moderators really don't care about annotations, especially in chat, unless they have a reason to
Not much interesting for chat suspensions apart from "it happen"
@mikeTheLiar I haven't received any, "you just watch yourself..." emails either. I must be doing something wrong.
21:57
Unless you're one of those people who manage to troll chat so hard mods have had to suspend you manually, in which case there might be some indication as to why
... or my mail server is just borked...
@Shog9 umm about that
...I'm on a phone still, not gonna switch to main theme to see your annotations
user315433
Speaking of information: my global inbox hit 601 pages going back to 2014-05-02... the interesting part is that it still has responses directed at long-deleted accounts.
user315433
At least pagination works as it should now.
user315433
22:06
Hm, did someone mention upcoming redesign of network user profile?
is this the chat room for asking something about stack exchange data explorer query?
user315433
You can try asking here, although the official room is
@zaq thanks. Will go to that room and see then :)
user315433
> We'd like to see this [network profile redesign] happen, but it's lower priority than getting a bunch of other stuff done, -- meta.stackexchange.com/a/254191
user315433
22:10
Fair enough
It looks like that room is empty. May be I'll ask here. My question is simple. When I make query, using data.stackexchange.com/mathematica/queries and run the query, I get lots of empty rows. Nothing on them, just blank. Some rows are OK, but many are empty. For example, here is simple query I just run:
DECLARE @UserId int =70

SELECT Posts.Title
FROM Posts
WHERE Posts.OwnerUserId = @UserId
And the result comes back, but again, many rows are empty strings. Any idea why that is?
user315433
Link to the query?
@zaq the worst of all Zelda games
@zaq I did not save it. I just go to http://data.stackexchange.com/mathematica/queries
then click on button that says "compose query". Then a windows open, I type the above SQL code, and click RUN and look at the result. I do not save the query itself.
user315433
@Nasser Answers don't have titles.
user315433
22:14
Posts table has both Questions (PostTypeId = 1) and Answers (PostTypeId = 2).
@zaq I see. So the blank lines are for answer? Ok
Ok, thanks! I am new at this and just started to learn it.
user315433
You can get the titles of questions for those answers by joining Posts table on a.ParentId = q.Id
user315433
But it's simpler to do SELECT Posts.Id as [Post Link] because the magic column name does it for you.
@zaq Ok, but that is little advanced for me, I know very little SQL. BUt now I tried this and get no blank lines

DECLARE @UserId int =70

SELECT Posts.Title
FROM Posts
WHERE Posts.OwnerUserId = @UserId and PostTypeId = 1

thanks again :)
user315433
22:18
Okay, this gets you questions only. See my link above for a query that gets all posts with links to them; the link text is the title of whatever question corresponds to the post.
@zaq wow, that is really a nice query. The links are useful :)
22:39
@zaq heh, that room is going to freeze in one day.
@zaq hmm? Really? where?
user315433
user202362
23:41
I remember the days when spammers were few and far between, my inbox was a lot emptier ...

« first day (2351 days earlier)      last day (2899 days later) »