Editing Talk:1409: Query

Jump to: navigation, search
Ambox notice.png Please sign your posts with ~~~~

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision Your text
Line 1: Line 1:
  
 
----
 
----
I cant help but notice that the ice cream guy is never selected for any of the queries, so he shouldn't be in the data pool, and thereby shouldnt be deletable.
 
~JustCallMeMOTL
 
:Or alternatively, ice cream guy is, indeed, a person, just one who's <= 30 years of age, hasn't watched porn in the last twelve hours, isn't afraid of flying, and makes less than six figures annually. Which isn't exactly impossible. [[User:Papayaman1000|Papayaman1000]] ([[User talk:Papayaman1000|talk]]) 23:49, 11 June 2017 (UTC)
 
 
 
I assume the Cueball sitting on the box is being accused of being Hairy. I'd say no. [[User:Markhurd|Mark Hurd]] ([[User talk:Markhurd|talk]]) 07:26, 18 August 2014 (UTC)
 
I assume the Cueball sitting on the box is being accused of being Hairy. I'd say no. [[User:Markhurd|Mark Hurd]] ([[User talk:Markhurd|talk]]) 07:26, 18 August 2014 (UTC)
  
actually it *is* hairy, just zoom in. it's just that his hair is really short, but unlike the nearby cueball the top isn't smooth which probably means that he has hair [[User:An user who has no account yet|An user who has no account yet]] ([[User talk:An user who has no account yet|talk]]) 09:14, 7 September 2023 (UTC)
 
  
 
Is there any particular point Randall would be making where 2 females and only one male, out of 5 each, have watch porn in the last half day? [[User:Markhurd|Mark Hurd]] ([[User talk:Markhurd|talk]]) 07:26, 18 August 2014 (UTC)
 
Is there any particular point Randall would be making where 2 females and only one male, out of 5 each, have watch porn in the last half day? [[User:Markhurd|Mark Hurd]] ([[User talk:Markhurd|talk]]) 07:26, 18 August 2014 (UTC)
Line 18: Line 13:
 
:Sitting ponytail, in conference: less than 30yo, not high-earning, flies easily, *recent viewed porn*.  (From the companions and the position, probably high 20s recent graduate relaxing with a long-term social group.)
 
:Sitting ponytail, in conference: less than 30yo, not high-earning, flies easily, *recent viewed porn*.  (From the companions and the position, probably high 20s recent graduate relaxing with a long-term social group.)
 
:Sitting cueball, in conference: *above 30*, not high-earning, flies easily, not a recent porn viewer.  (Another graduate, early 30s, probably exercises in order to find that sitting position relaxing.  Part of the same social group.)
 
:Sitting cueball, in conference: *above 30*, not high-earning, flies easily, not a recent porn viewer.  (Another graduate, early 30s, probably exercises in order to find that sitting position relaxing.  Part of the same social group.)
:Sitting flowinghair, in conference: *above 30*, not high-earning, *fears flying*, *recent viewed porn*.  (''Sex indeterminate'' as that hair could indicate a metrosexual male.  By 30 the look is probably starting to wearing thin, but still not overly embaressing.  It certainly doesn't look like (s)he has settled down in a familial relationship yet, but has quite obviously flown the parental nest and is now with friends from college/university.  Or might have been met on a round-the-world backpacking holiday and discovered they were from his own home city, except for the fear of flying (unless worked passage on ships).  Probably knows all the cool scenes in this city, though, so well worth socialising in the park with.)
+
:Sitting flowinghair, in conference: *above 30*, not high-earning, *fears flying*, *recent viewed porn*.  (''Sex indeterminate'' as that hair could indicate a metrosexual male.  By 30 the look is probably starting to wearing thin, but still not overly embaressing.  It certainly doesn't look like (s)he has settled down in a familial relationship yet, but has quite obviously flown the parental nest and is now with friends from college/university.  Might have been met on that round-the-world backpacking holiday and discovered they were from his own home city, except for the fear of flying (unless worked passage on ships).  Probably knows all the cool scenes in this city, though, so well worth socialising in the park with.)
 
:Perched cueball, with icecream, hanging out: less than 30yo, not high-earning, flies easily, not a recent porn viewer.  (Probably a teenager, with a close-cropped haircut.  Might or might not know the other two behind him, but hard to tell what he thinks except perhaps "I've got an ice-cream! Yay!"  Perhaps after a busy day of not-watching-porn.)
 
:Perched cueball, with icecream, hanging out: less than 30yo, not high-earning, flies easily, not a recent porn viewer.  (Probably a teenager, with a close-cropped haircut.  Might or might not know the other two behind him, but hard to tell what he thinks except perhaps "I've got an ice-cream! Yay!"  Perhaps after a busy day of not-watching-porn.)
 
:Leaning ponytail, with device, hanging out: less than 30yo, not high-earning, *fears flying*, not a recent porn viewer.  (Teenage girl.  Big on social networking.  Probably not so big on face-to-face-talking.)
 
:Leaning ponytail, with device, hanging out: less than 30yo, not high-earning, *fears flying*, not a recent porn viewer.  (Teenage girl.  Big on social networking.  Probably not so big on face-to-face-talking.)
Line 25: Line 20:
  
 
::Thats racism! I mean speciesm. Alien Shapeshifting Lizards are people too! -- [[User:Hkmaly|Hkmaly]] ([[User talk:Hkmaly|talk]]) 10:15, 18 August 2014 (UTC)
 
::Thats racism! I mean speciesm. Alien Shapeshifting Lizards are people too! -- [[User:Hkmaly|Hkmaly]] ([[User talk:Hkmaly|talk]]) 10:15, 18 August 2014 (UTC)
 
::You list a lot of individuals being from college/university, however we have no data from the above image to establish that. People that don't go to university do exist and do have social networks (and outnumber the people who have been to college). Additionally, while I assume it to be out of place for Randall there is the possibility that some of our females/males in this population are transgendered or transvestites (assuming, of course, they're a US population). As well . . . Terminator Units aren't people!? [[Special:Contributions/108.162.237.181|108.162.237.181]] 13:53, 19 August 2014 (UTC)
 
  
 
Sounds a lot like watch_dogs. [[Special:Contributions/108.162.229.201|108.162.229.201]] 07:42, 18 August 2014 (UTC)
 
Sounds a lot like watch_dogs. [[Special:Contributions/108.162.229.201|108.162.229.201]] 07:42, 18 August 2014 (UTC)
Line 36: Line 29:
 
I'm under the impression that Megan is using the device to look for potential mates. The age and income queries point to this, the other two are less common but still make sense in the context of a relationship. Finding no one who matches all of her criteria, she then deletes the list.
 
I'm under the impression that Megan is using the device to look for potential mates. The age and income queries point to this, the other two are less common but still make sense in the context of a relationship. Finding no one who matches all of her criteria, she then deletes the list.
 
[[User:Dromaeosaur|Dromaeosaur]] ([[User talk:Dromaeosaur|talk]]) 10:41, 18 August 2014 (UTC)
 
[[User:Dromaeosaur|Dromaeosaur]] ([[User talk:Dromaeosaur|talk]]) 10:41, 18 August 2014 (UTC)
:Well, there's obviously something to the idea of those directing her choices (for positive ''or'' negative selection purposes - I assume <=30 && >$100k, but would she want someone who shares her fear and would ''never'' suggest a plane trip, or someone who could be reassuring when one ''is'' taken?  And someone who is 'wholesome' or likely to be open-minded about pornography?) but, although it's likely there's no Mr(/Mrs) Right, she finds just proclaims it "neat" and only seems to inadvertently 'tidy up' (albeit too much), rather than doing it in deliberate (if again misjudged) frustration... [[Special:Contributions/141.101.99.7|141.101.99.7]] 11:39, 18 August 2014 (UTC)
 
::I thought the same. I think that when Megan realises that no one matched her queries (so no possible relationship match) she decide to clean the list as she's not interested in them. Doing this she forgets, like most people do, that she's part of the people as well, and so she deletes herself too, accidentally. 
 
  
 
Why does the explanation call it "SQL-esque"? That looks like fully valid SQL to me. --[[Special:Contributions/108.162.230.119|108.162.230.119]] 10:49, 18 August 2014 (UTC)
 
Why does the explanation call it "SQL-esque"? That looks like fully valid SQL to me. --[[Special:Contributions/108.162.230.119|108.162.230.119]] 10:49, 18 August 2014 (UTC)
: I can only guuess that they might call it "SQL-esque" because based upon the fields queried, it does not seem like a backing database would be able to keep a constant record of everyone where the number of hours since watching porn could be CONSTANTLY updated (and thus accurate). This is not a typical database, granted, but that info (as I wondered below, a while back) is something that would be found with comparison between a timestamp and GETDATE() - possibly contained within a function, neither of which is shown in the respective statement (no function call, no datediff). It is still SQL, and SQL can be used verbally to query a fellow human for any information, though you'd get a strange look at best from most people you meet on the street - it's just a language - but the implication is that it is backed by a relational database with static data like most databases out there, so perhaps they're implying that it somehow can't be SQL because such a database can't conceiveably be built(?). Idunno - I'm grasping at straws... -- [[User:Brettpeirce|Brettpeirce]] ([[User talk:Brettpeirce|talk]]) 19:08, 28 January 2015 (UTC)
 
I think the comic is a reference to "Big Data" and the claim I read this morning that one organisation has a file on 10% of the world's population with around 1500 pieces of information on each of them. [[Special:Contributions/141.101.98.194|141.101.98.194]] 12:27, 18 August 2014 (UTC) Dan
 
:It's also possible that the strip is commenting on the notion that the universe may be a hologram and/or a computer simulation.  If that's the case, then it would make sense to have a People table. {{unsigned ip|173.245.48.79}}
 
 
One thing I find interesting is what I see as an implication that <del>5/10</del> (sorry: 6/10) of the people pictured would not have a "device" on them at the time they were dropped with the PEOPLE table - certainly ''more'' than half of people have a device (or at least an ID or set of keys or something)... perhaps being contained within their clothing -- which apparently is dropped along with the associated person -- means THOSE devices were dropped along with the clothing (cascading?); however, being in the hands of the associated person means a certain level of disassociation... idunno... pick pick pick away at the joke! ALSO, seems like the time since someone watched porn would have to be computed (wouldn't be stored in the table as a field itself, but computed from a field like  time_last_watched_porn and datediff... or else some user-defined function)... FINALLY - would have been great to see the result of an INSERT or UPDATE statement prior to dropping... ah well - [[User:Brettpeirce|Brettpeirce]] ([[User talk:Brettpeirce|talk]]) 14:10, 18 August 2014 (UTC)
 
:Just to make is clear. If their devices should be dropped, even if they were in their pockets, then why do you not also expect their clothes to be dropped...? Oh, maybe their clothes did drop, and since this is not visible (they are stick figures...) then their phones is in the pocket, and would not show up anyway. So either the clothes goes along with everything they have on them (but not what they hold in their hands) or else the clothes also drops like everything else that were not a biological part of them. (Man this is a far out discussion ;-) --[[User:Kynde|Kynde]] ([[User talk:Kynde|talk]]) 13:09, 20 April 2015 (UTC)
 
 
See [[327: Exploits of a Mom]]. That is all. [[Special:Contributions/173.245.54.153|173.245.54.153]] 19:04, 18 August 2014 (UTC)
 
:Added it to the explain--[[User:Kynde|Kynde]] ([[User talk:Kynde|talk]]) 13:09, 20 April 2015 (UTC)
 
 
I think it's interesting Megan chooses to Drop Table People right after viewing who's watched porn, much like people who clear their browser cache/history after watching porn to make sure no one else finds out. [[Special:Contributions/108.162.237.179|108.162.237.179]] 00:15, 19 August 2014 (UTC)
 
 
There's a further implication no-one seems to have picked up on here. At the beginning of the strip, Megan finds the device sitting on the ground,presumably lost. At the end of the strip, everyone's disappeared and the device is sitting on the ground, presumably lost. Is this the first time this chain of events has occurred, or has the table been dropped in the past? [[User:Grutness|Grutness]] ([[User talk:Grutness|talk]]) 01:37, 19 August 2014 (UTC)
 
 
What Megan never realized was that Mr 100&thinsp;000 earned his [http://google.com/#q=100000+VND+in+USD earned his income in Vietnam]. —[[User:Jameslucas|jameslucas]] <small>([[User talk:Jameslucas|" "]] / [[Special:Contributions/Jameslucas|+]])</small> 12:24, 19 August 2014 (UTC)
 
 
Isn't dropping the table kinda boring? Think of the possibilities... ''UPDATE PEOPLE SET AFRAID_OF_FLYING=FALSE, ANNUAL_INCOME=120000 WHERE NAME='Megan'''  [[User:KillaBilla|KillaBilla]] ([[User talk:KillaBilla|talk]]) 13:52, 19 August 2014 (UTC)
 
 
:You are selfish. Think of how you can help whole world! ''UPDATE PEOPLE SET ANNUAL_INCOME=10000 WHERE ANNUAL_INCOME < 10000'' ... poverty in Africa solved :-). -- [[User:Hkmaly|Hkmaly]] ([[User talk:Hkmaly|talk]]) 11:24, 20 August 2014 (UTC)
 
:: That would just result in inflation, and nobody would win.
 
:: I'd love to see Black Hat with this device.  23:27, 25 August 2014 (UTC)
 
 
Why would Randall let this comic out on a Sunday. The first entry in the explain history is from the Monday after - the 18th of August. Anyone who can find out if this is the correct date, or just a mistake from when the page was created? --[[User:Kynde|Kynde]] ([[User talk:Kynde|talk]]) 11:18, 20 April 2015 (UTC)
 
 
About the title text, perhaps it is meant to be a method to make the supposedly invisible ghosts visible with that yellow glow around the ones who have been selected. [[Special:Contributions/162.158.238.6|162.158.238.6]] 08:56, 22 March 2023 (UTC)
 
 
if i had that power i'd put "update people set lives_in_a_war=false, country_is_dictatorship=false, is_poor=false where lives_in_a_war=true, country_is_dictatorship=true, is_poor=true" and bam, world peace, no opression on a country's population and poverty worldwide solved. good enough? [[User:An user who has no account yet|An user who has no account yet]] ([[User talk:An user who has no account yet|talk]]) 17:21, 9 September 2023 (UTC)
 

Please note that all contributions to explain xkcd may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see explain xkcd:Copyrights for details). Do not submit copyrighted work without permission!

To protect the wiki against automated edit spam, we kindly ask you to solve the following CAPTCHA:

Cancel | Editing help (opens in new window)

Template used on this page: