I have a blog posts table and a blog post tags table. One post has many tags. I first did this with a call to posts then a loop and call the tags table, but this resulted in 9 queries per page just to get the posts. I have rewritten this to use a join, but it returns duplicate blog posts rows.  SELECT p.timestamp      , p.title      , p.postcontent      , p.siteid      , t.tag    FROM user_blogposts p   LEFT    JOIN user_blogposttags t     ON t.postid = p.id   WHERE p.userid = 1   LIMIT 8   This query returns the data I want, but if there are 5 tags per post, each post will be duplicated 5 times with only the tag field being different. I can't use GROUP BY as this will return 1 row with 1 tag for each post and break the one to many connection.  Is there a way to return an array for the many join so that I only get 1 row for the post and then the tag column is an array or comma delimited string for me to work with rather than having to filter out all of the duplicate data.
Using MySQL, I can do something like:  SELECT hobbies FROM peoples_hobbies WHERE person_id = 5;   My Output:  shopping fishing coding   but instead I just want 1 row, 1 col:  Expected Output:  shopping, fishing, coding   The reason is that I'm selecting multiple values from multiple tables, and after all the joins I've got a lot more rows than I'd like.  I've looked for a function on  and it doesn't look like the CONCAT or CONCAT_WS functions accept result sets.  So does anyone here know how to do this?
Why can't I connect to Pokemon Go via mobile data? I have an external USB 3 disk drive (2TB capacity) that is most likely going to be moved from machine to machine. The disk has a GUID partition table and an ext4 partition. I am unable to write to the disk unless I elevate the process (sudo).  As of now I am thinking of trying one or both of the following and would like to know the cons of each -   chmod 777 /mnt/externalDrive chown nobody:nogroup /mnt/externalDrive   If I give 777 permission and user1 (UID:1005) writes to it and I later move the disk to another computer where user7 is UID:1005, what happens? Does user7 become the owner of the file on that computer? It seems to me that I will periodically have to run chown -R nobody:nogroup /mnt/externalDrive on the disk.  Is any of what I am considering an obvious bad practice? The disk will most likely contain videos, music and pictures none of it need to be protected like some financial data. Eigen-Decomposition of Householder operator How to install Python 3.6? There are infinitely many prime numbers $p$ for which $p + 2$ and $p + 4$ are also prime numbers I need help with this question: There are infinitely many prime numbers $p$ for which $p + 2$ and $p + 4$ are also primes.  Where should I start? what proof techniques will be useful?  Any input will be very useful to me. How do the Flashes breathe utilizing their super speed? The air pressure would be extreme. Do they run in a pressurized bubble? My work has decided to issue their own  (CA) to handle different aspects of our work securely without paying for certificates.   Cryptographically sign emails Encrypt email contents Make access to things like the company  client-certificate based. Revoke the keys of former employees automatically   They sent me a .pem file, and I'm not sure how to add it to my Ubuntu install. The instructions sent were: "Double-clicking on it on a Mac should install it."&nbsp;  How do I proceed? Do I need to do something with  to create a .key, .csr, or .crt file? No sound in Ubuntu except at log in I installed Ubuntu 12.04 a month ago and am using it till now. I failed to notice that all this time there was no sound at all while running Ubuntu, even while playing a game in Wine. The weird thing is that only the startup sound comes when I log in (Indian/African drum tone), then comes the utter silence.  I tested both Digital Output (S/PDIF) and the speakers in the sound settings but can hear nothing.  Any help? Thermodynamics of supercooled water Now that it's been freezing outside for the last few days, I experimented a bit with supercooling. I've left a bottle of clean water outside for a few hours, and behold, when I shook the bottle, the liquid began to freeze rapidly, as expected.   However, not all of the water froze, only about half of it. This got me thinking.  I reasoned that happens because freezing releases heat, and that heat raises the temperature of the ice and remaning water to 0$^\circ$C, at which point the freezing stops.  To try to quantify this, set   $H_f = 334000 \frac{J}{kg}$, the "freezing heat" (enthalpy of fusion) of ice, $c_i = 2110 \frac{J}{kg\cdot K}$, specific heat of ice, $c_w = 4181 \frac{J}{kg\cdot K}$, specific heat of water, $M$, initial mass of supercooled water, $T_0$, initial temperature of supercooled water, $m$, mass of ice at a given moment, $T$, temperature at a given moment.   We suppose that the energy released by the freezing of a $\textrm dm$ mass of ice is used up by raising the temperature of both the already frozen ice ($m$) and the remaining water ($M-m$):  $$ \textrm dm \cdot H_f = c_i m \cdot\textrm dT + (M-m)c_w \cdot\textrm dT$$  By rearranging we get a linear differential equation for $m(T)$:  $$\frac{\textrm dm}{\textrm dT}+\frac{c_w-c_i}{H_f}m = \frac{c_w}{H_f}M$$  The solution of this equation, using the initial condition that at $T=T_0$, $m=0$:  $$ m = M \frac{c_w}{c_w-c_i}\left[ 1-e^{-\frac{c_w-c_i}{H_f}(T-T_0)} \right]$$  This looks neat, however, plugging in the actual values of the constants, $T = 0^\circ$C and $T_0 = -6^\circ$C, I get that little more than 7% of the water should freeze - as opposed to more than half, as I've observed. What's worse, the formula can be used to calculate the starting temperature required to freeze all the supercooled water: $$T_{all} = \frac{H_f \log\frac{c_w}{c_i}}{c_i-c_w}=-110.26^\circ \textrm C$$ which seems absurd.  Where is the error in the calculation above?  I've made a number of assumptions which may or may not hold:   the constants are really constant. I think this is a good approximation for $c_w$, a not that good but still acceptable approximation for $c_i$, and I suppose it holds to $H_f$ to some extent as well. there is no heat transfer with the environment, i.e. the bottle is a closed system. The process seemed fast enough (a few seconds at most) for this to be a good approximation. the system is in a thermal equilibrium at all times and the heat released by the freezing of the ice is distributed evenly in the emerging ice-water mixture. Now this is where I have doubts. Precisely because of the process happening so fast, this might not be true at all. However, acknowledging the presence of temperature variations makes the problem order of magnitudes harder: one has to solve a system of partial differential equations that take heat transfer, the shape of the bottle and \$deity knows what else into account. If an astronaut had stationed in International Space Station for the duration of mission, 17 years, would he be older? Today the NASA International Space Station started the 100000 orbit after 17 years in the space. I just wonder if there were a team of astronauts which were in the Lab for all the duration of last 17 years, how much older they would be due to the combination of Einstein's especial theory of relativity and general theory of relativity?   Here is the link to NASA's youtube video. How to add context menu item for files in general, in Windows? in order to add context menu for directories and explorer background, one can follow instructions .   To add context menu for specific file extensions, one can follow instructions   but I can't seem to find a way to add context menu items for all files? As you are all most likely aware already all domain registrars ask for your personal information.   Such personal information includes:   Forename and surname Address information Email address Telephone number   Personal information via WHOIS  Depending on the domain type such as  or  this information may become immediately available after the registration of the domain via a simple whois. If you do not want that (and in most cases you certainly don't) they offer a service where you can remove this information from the whois service but of course hiding your personal information adds yearly costs to the domain  purchase.  What happens if I use fake details when registering a domain? Is there a closed form solution for the following series? (Without Using Gamma Function): $$ S=\sum _{i=1}^{n-1} \frac{1}{(i+1)!} $$ Inline math equation Point size How to change all equations point size(inline and display equations) globally, point size worked in within \begin{array}...\end{array} but not changed for $....$?  Please find MWE file:  \documentclass{book} \usepackage{amsmath,array} \usepackage{stix}  \everydisplay{\fontsize{15pt}{18pt}\selectfont} \everymath{\fontsize{15pt}{18pt}\selectfont}  \parindent0pt \begin{document}  Use the alternative calculation described above. In comparing the two values, you want to consider fluctuations in inventory over time. Use the alternative calculation described above. In comparing the two values, you want to consider fluctuations in inventory over time.  $\alpha\beta\gamma\delta\epsilon0123456789+-$ \bigskip  $\begin{array}{@{}l}\alpha\beta\gamma\delta\epsilon0123456789+-\end{array}$   \begin{align*} \alpha\beta\gamma\delta\epsilon0123456789+- \end{align*}  \end{document} Is using Gravatar a security risk? This has been . It is unfortunate the accepted answer is so far from reality.   There are some facts:    's MD5 hash is an unsalted MD5 hash of an email address. A 3rd party could harvest every MD5 hash for every user's email on Stack Overflow.  The 3rd party could store all the hashes in a lookup table Email addresses are usually of a very particular format The attacker could start with a brute force of @gmail.com followed by @yahoo.com, etc. The attacker has the advantage that he/she could attack a huge set of emails in one go. So instead of needing to brute force every email individually the attacker can brute force in bulk.   The algorithm is quite simple, calculate a "random" MD5, look it up in the lookup table.       Is Gravatar a big enough security risk to warrant caching images locally?     Examples:    Someone could harvest about 50k email addresses quite easily and shoot off a bogus promotion from Stack Overflow to all the users. A spammer/stalker/generic evil guy can tie you identity to all the rest of the sites that use Gravatar. 20GB of Temporary Files, Only 50MB in Temp Folder I recently discovered that the Settings app is showing around 20GB of space used by temporary files. But when I go to remove them I can only remove about 28MB. When I open the temp folder by using Run and then %temp% it only shows around 40-50MB of files right after boot. How can I remove these 20GB of invisible files? I only have a 240GB SSD so space is quite scarce. Here are a few photos:    I run Windows 10 Home Activated. I have tried Disk Cleanup but this removed only around 30MB of files.  UPDATE: After turning on hidden items I found a folder name WINDOWS-BT, after doing some research it turned out to be a folder for the previous windows version. I deleted it using TakeOwnerShip pro and this removed around 12GB of temporary files, but 8GB still remain. I am currently downloading TreeSize free to find out where the other 8GB is.  UPDATE 2: Hi, I downloaded TreeSizeFree and I didn't really find anything there.   The biggest folder is 87GB of Program Files which mainly consists of my GTA V install. The Program Files (x86) folder was mainly made up of my Steam games (CS:GO, Besiege, etc). The 5.5GB [3 Files] location was noted as being my pagefile.    The Windows folder shows up as 25GB when in Settings it is only 18GB, this could explain where the other 8GB are coming from. What are some things I should look for in there?  FINAL UPDATE: After deleting the Windows-BT folder it reappeared a few hours later. I decided to check from system updates and surely enough one was downloaded and pending to be installed. After installing the update the Windows-BT folder disappeared on it's own and a new folder taking up 20GB called Windows.old was created. I then followed this  to remove the .old folder and I had all my disk space back! NOTE: Disk Cleanup wasn't able to find the Windows.old folder, this is why I had to delete it from the settings app. Let $A$ and $B$ be two constant matrices and let $x$ and $ y$ be two random vectors, what is the general formula for $Var(Ax+By)$? I know the formula for when $x$ and $y$ are scalar random variables and $A$ and $B$ are constants, but what about the matrix case? Context  In one of his most popular books , Terry Pratchett makes an entropy joke:     Knowledge equals Power, which equals Energy, which equals Mass   Pratchett is a fantasy comedian and every third phrase in his book is a joke, therefore there is no good reason to believe it.  Pratchett uses that madness to make up that a huge library has a tremendous gravitational push.  The question  I work with computers and mostly with encryption.  My work colleagues believe Terry Pratchett's statement because of entropy.  On the other hand, I believe, it is incorrect since entropy of information is a different entropy than the one used in thermodynamics.  Am I correct?  And if so, why do use the same name (entropy) to mean two different things?  Also, what would be a good way to explain that these two "entropies" are different things to non-scientists (i.e. people without a chemistry or physics background)? Which words in a title should be capitalized? Are there any concrete rules that say which words (parts of speech) in a title should start with a capital letter? What would be a correct capitalization for the title of this question? Prove there are k consecutive non-squarefree integers So, I've got a question for class that asks me to prove the existence of arbitrarily long runs of consecutive integers where $\mu(n)$ is zero.   I've started the proof, but I need a bit of help midway through.  Assume there exists a run of length n, which we currently assume is the longest possible chain.  If we induct on n, we can assume there is a run of the form $m_1p_1^2, m_2p_2^2, ..., m_np_n^2$ (where each of the $p_i$ are prime).  If I add $M =  lcm(m_1p_1^2, m_2p_2^2, ..., m_np_n^2)$ to each number, I get another run of length n.  So here's where the issue starts. When I talked to my advisor about it, he referenced a theorem where there exists a prime $p$ congruent to $1\ mod\ M$.  I am unfamiliar with this theorem, so I'm not sure how to use this information. Any chance I can get some help? Or else is there a simpler way to go about this problem?