My apologies if this question is off-topic here, but it is a discussion about how to use a network-wide tool specific to SE.  The question in its entirety is in the title, really.  How can I use the StackExchange Data Explorer to run a query across all sites in the network?  I cannot seem to find a way to search more than one (set with the drop-down next to Compose Query) – is this  or is there a workaround?
I think it would be useful if we could join across databases in the data-explorer.  For example, I'd like to query up a list of questions that I had a hand in migrating away from SO, and see what percentage of them were subsequently closed or re-migrated.  I realise I could download the various data dumps and do this on my own machine, but it would be nice if it were allowed on the online version.  Is this possible/practical?
Identify this 80's movie about a force-field shaped like a bubble Place each foot on a scale: can you add the two to find your weight? I frequent a blog from a British psychologist, and every Friday he likes to pose an interesting puzzle or riddle. The Monday after that he posts the answer. They're good fun, and IANAP but  made my it-might-not-be-quite-as-simple-as-that detector go off.  My question boils down to this: let's say I have two identical scales, and I stand on the scales with one foot on each scale. The scales read W1 and W2. Does my weight equal W1 + W2? What does the notation like 8.6e-28 mean? What is the 'e' for? I have a problem with the interpretation of a test result in which the p-value is 8.6e-28. How should it be interpreted? What is the e for?  Specifically, I used White's Test for the homoscedasticity assumption of a linear regression:  White's general test statistic :  150.0535  Chi-sq( 9)  P-value =  8.6e-28 How to add new item in existing string array in C#.net?  I need to preserve the existing data. How do we fetch data through REST service which hosted in azure from SharePoint site which in office 365? How do we fetch data through REST service which is hosted in window azure, from SharePoint site which in office 365? Can we need to create app for SharePoint which contain restAPI endpoint or any better solution than this? Let $A$ be a commutative ring and $S$ a multiplicative closed subset of $A$. If $A$ is a PID, show that $S^{-1}A$ is a PID.   I've taken an ideal $I$ of $S^{-1}A$ and I've tried to see that is generated by one element; the ideal $I$ has the form $S^{-1}J$ with $J$ an ideal of $A$. $J$ is generated by one element but I can't see why $I$ has to be generated by one element, maybe I'm wrong. This is probably easier to show than tell...   On the recent question , I see the following:    As you can see, the first five links render properly, but after that, they stop converting.  Unfortunately, this isn't obvious to the person writing the post, which I discovered when I went to edit the post to fix the "broken" links. In the edit window, it renders all of the links just fine:    I understand that this behavior is expected based on balpha's answer :        Links to questions on the same site are unlimited.   Links to other sites are limited to             a) 5 linked-to sites and     b) N questions per target site, where N is 200 on meta sites and 10 on non-metas (this is about the site that the post containing the link is posted on, not the site that is being linked to)         So if this rule is still going to stay in effect, please fix the edit view to also not automatically convert more than five linked-to sites to help people writing posts know that they need to manually title the links to the other questions.  That said, I'd prefer that (at least on MSE) this limitation be removed or raised. Even in the answer, balpha says:     The restrictions are currently as follows, but note that they do look a bit contrived, resulting from the fact that they have grown over time (from single site to cross-site, from "there are no subsites" to "facebook.SO", etc.), so it's not unlikely that we'll revisit them.   So, if it's not hurting performance, can we please increase the limit or remove it? Jawa asked me this  and I didn't know the answer. So I present it to the meta SO community:     [To get the Yearling badge] Do you need to earn the 200 rep within that one year or is it enough to get 200 at some point after being a member for a year? And does 'a year' mean the very first 12 months or the last (sliding window of) 12 months?    I would assume that if you hit 200 reputation after you've already been around for a year, then you would get the Yearling badge. But I don't know. Consider the sentence      E-books are on the rise, but they haven't suppressed paper books though.    This usage seems to be quite common, but when I learned English  I was taught to use "however" where I now read "though". My questions on this use of "though" are:     Is this a new trend? Is it restricted to American English? Is "though"  considered more colloquial than "however" ?    And on a syntactic level: Do you put a comma before "though"? Javascript object members that are prototyped as arrays become shared by all class instances Is there a case where including the same header twice is actually helpful? Derivatives of $ \frac{1}{r} $ and Dirac delta function I am trying to understand the formula \begin{equation} \nabla^2\left(\frac{1}{|{\bf r}-{\bf r}'|}\right) = - 4 \pi \delta(\bf{r}-\bf{r}'), \qquad\qquad {\rm (I)} \end{equation} where ${\bf r}=(x,y,z)$. This is something heavily used in electrostatics and the steps to 'show' this is often the following: The first derivative reads \begin{equation} \nabla \frac{1}{| {\bf r} - {\bf r}' |} = - \frac{ {\bf r} - {\bf r}'}{| {\bf r} - {\bf r}'|^3} \end{equation} And taking the second derivative gives zero, except for the singularity at ${\bf r} = {\bf r'}$. Then from the divergence theorem we have \begin{equation} \int dV \,  \nabla^2 \frac{1}{| {\bf r} - {\bf r'}|} = \int dS  \,\,{\bf n} \cdot ( \nabla\frac{1}{|{\bf r} - {\bf r}'|}) = -4 \pi \end{equation} where the integration is performed over a sphere centered at ${\bf r}'$. Q1: Is there a more direct proof for equation (I)? Then my main question is about the separate second-order differentials. For instance, we can obtain, by direct computation \begin{equation} \partial_x^2 \, \frac{1}{| {\bf r} - {\bf r}'|} = \frac{ 3 (x-x')^2 }{| {\bf r} - {\bf r'} |^5} - \frac{1}{| {\bf r} - {\bf r}'|^3} \end{equation} Q2: Should there be a $\delta$ function on the r.h.s of this equation? $(\Bbb Z\oplus \Bbb Z)[X] \not\cong \Bbb Z[X]\oplus \Bbb Z[X]\,$? Well i tried to prove it but failed. They are both commutative and have the same set of units. So i can't see a property of one ring which the other ring does not possess. Thank you for any help. Analyze a circuit with two diodes and two voltage rails I want to find \$I\$, \$I_{D2}\$ and \$V\$ in this circuit. The diodes are made of Silicium. I'm a beginner and normally I would assume the Diode bias and then apply KVL to see if it is true. However, I've only encountered circuits where the wire forms a loop.    How am I supposed to apply KVL in this case? If voltage is the difference in potential between two points, how can I find the voltage of V if one point is outside of the circuit, therefore, outside of KVL application? "Neither", "none", "no one" + [of them] + verb-s In a comment on English Language &amp; Usage I read the following answer responding to a(n) asker's question: &quot;Neither sound natural.&quot; I have always had more than one doubt on the &quot;neither&quot; usage and I would like understand(ing) the &quot;secrets&quot; to use this word better or, at the best, correctly. So, let us consider the following examples:  1 Neither sound natural. 2 None sound natural. 3 No one sound natural. 4 Neither of them sound natural. 5 None of them sound natural. 6 No one of them sound natural. 7 Neither sounds natural. 8 None sounds natural. 9 No one sounds natural. 10 Neither of them sounds natural. 11 None of them sounds natural. 12 No one of them sounds natural.  Comparing the above sentences (one) with each other, can anybody explain which is grammatical and why? How does one prove the following limit? $$   \lim_{n \to \infty}   \sqrt{1 + 2 \sqrt{1 + 3 \sqrt{1 + \cdots \sqrt{1 + (n - 1) \sqrt{1 + n}}}}} = 3. $$ Create Trigger that updates the same table before (or after ??) the Insert I have just started using triggers and one thing that I would need to do is to create a trigger that updates the same table that's inserting the row.  TABLE:  CREATE TABLE `city` (   `city_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,   `city` varchar(50) NOT NULL,   `country_id` smallint(5) unsigned DEFAULT '0',   `country` varchar(150) DEFAULT NULL,   `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,   PRIMARY KEY (`city_id`),   KEY `idx_fk_country_id` (`country_id`),   CONSTRAINT `city_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `country` (`country_id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=6009 DEFAULT CHARSET=utf8;   Trigger:  DELIMITER $$ CREATE TRIGGER `populate_country_id` BEFORE INSERT ON `city` FOR EACH ROW BEGIN  IF NEW.country_id = 0  THEN     UPDATE city     INNER JOIN country B ON city.country = B.country     SET NEW.country_id = B.country_id;  END IF;  END $$ DELIMITER ;   MySQL is just returning: Can't update table 'city' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.  Is there any way I can make this work?  Thanks everyone! Execution of a command locally after ssh tunneling I have a script file ./run_app.sh which contains of the following:  ssh -L 8888:localhost:8888 ubuntu@address ./run_website.sh   # it should be executed locally   but it tries to run the second line on the remote machine. Actually, I want to run it on my pc. Any idea? A scene I made is not rendering, at all. This grey screen stays the same and nothing changes.  Here are my settings:  [ Hiding axis text in matplotlib plots