Grouping data with SQL and PHP
PHP & MYSQL: using group by for categories
Rendering low and res/high res images Is it possible to render in Blender with reduced low res files and then ask Blender to render the final render with 4k high res files? Low and high res files would be numbered identically but would be located in different folders.  Many thanks When do the differences between APS-C and full frame sensors matter, and why? Simple Math Problem A bat and ball cost \$1.10.  The bat costs a dollar more then the ball.  How much does the ball cost?  If this is not the correct place to ask a question like this please tell me and I will remove it :)     The ball costs \$0.05, not \$0.10 Unknown Additional Driver: Processor microcode firmware for Intel CPUs for intel-microcode After upgrading to 15.04, I have one additional driver (it did not appear in 14.10). What is the purpose of this driver and should I enable it? Why are heatmaps on qgis 2.8.1 produced in the wrong CRS? I noticed that the heatmap calculation on the new upgrade version of qgis is given the raster map without any coordinate system.   Have you got the same problem? Using CSS to affect div style inside iframe Show that $A_n=\sum\limits_{k=1}^n \sin k $ is bounded? This is a homework question. $d,n\ge 2$.  Let $L=\{(x_1,...,x_n)\in (\mathbb{R}^d)^n: x_i\in \mathbb{R}^d,  x_i\ne x_j \forall i\ne j\}$.   I tend to think it is not path connected because if you assume $d=1$, this is the case. But I cannot prove for $d\ge 2$.  Any help will be appreciated! :) How can I check if a given number is even or odd in C? To debug a JACK/Pulseaudio issue, I want to understand when and why the pulseaudio daemon is started by systemd (on Fedora).  Using:  $ ps -o'pid,ppid,args' `pgrep pulse`   I see that the pulseaudio daemon is being started by systemd (pid=1)   PID  PPID COMMAND 2738     1 /usr/bin/pulseaudio --start   However, I was unable to find any unit-file on my system containing pulseaudio or even just pulse.  My specific questions are:  A) Is there a way to determine the systemd unit that caused the creation of a specific process (in my example output, process 2738, the PA daemon)?  B) Are there alternative approaches to find out which unit-dependency chain or other settings of systemd resulted in the invocation of /usr/bin/pulseaudio --start? Could someone please check if I'm saying something that make sense? I am trying to check the following:     If $f$ is a measurable function, then $\text{supp}(f)$ is measurable set?   Is it simply because, if we consider $E_1 = (0,\infty)$ and $E_2 = (-\infty,0)$, since they are open, they are measurable. So their union $\mathbb{R}-\{0\}$ is measurable as well. Since $f$ is measurable, then the preimage $f^{-1}(\mathbb{R}-\{0\})$ is measurable. But the preimage is just the support? Inductive proof that there are infinitely many pairs of consecutive powerful integers? My party bypassed a combat encounter. Should they still get XP? Some thug bandits set up a road block on the main road to extract a toll from passersby. It was twilight when my party encountered them. They used the Rogue to scout ahead, and they ultimately decided to bypass them by taking the long way around with some stealth to avoid the bandits.  Is there RAW justification that I should award XP as if they actually fought and killed the bandits? (5 x 1/8 CR) Prove that the following inequality holds   $$a^a b^b c^c\ge (abc)^{\frac{a+b+c}{3}}$$   if $a,b,c$ are positive.   I'm not sure how to handle these kinds of powers. Are there any "famous" but not so advanced inequalities that involve this kinds of expressions?  I was trying to do something like ordering them without lost of generality because it's symmetric, but I get nowhere and I just make the thing even more complicated.  I'm asking for solution rather than hints since this is my first time encountering these kinds of problems. In order to better understand the SQL Server query processor, I've been thinking about how the ORDER BY clause works, and how SQL Server provides results.  It appears SQL Server will provide results in exactly the same order for any given set of data that remains the same and never, ever changes.  Once you introduce any kind of uncertainty such as developers changing something, the order of results can no longer be expected to be the same.  Simply seeing the results in the same order, each time you press F5 does not guarantee the results you expect.  Try this:  USE TempDB; DROP TABLE TestOrderBy; DROP TABLE TestOrderBy2; CREATE TABLE TestOrderBy (     ID INT NOT NULL CONSTRAINT PK_TestOrderBy PRIMARY KEY CLUSTERED IDENTITY(1,1)     , SomeData varchar(255) ); INSERT INTO TestOrderBy (SomeData) VALUES ('E'); INSERT INTO TestOrderBy (SomeData) VALUES ('D'); INSERT INTO TestOrderBy (SomeData) VALUES ('C'); INSERT INTO TestOrderBy (SomeData) VALUES ('B'); INSERT INTO TestOrderBy (SomeData) VALUES ('A');  CREATE TABLE TestOrderBy2 (     ID INT NOT NULL CONSTRAINT PK_TestOrderBy2 PRIMARY KEY CLUSTERED IDENTITY(1,1)     , SomeData varchar(255) ); INSERT INTO TestOrderBy2 (SomeData) VALUES ('E'); INSERT INTO TestOrderBy2 (SomeData) VALUES ('D'); INSERT INTO TestOrderBy2 (SomeData) VALUES ('C'); INSERT INTO TestOrderBy2 (SomeData) VALUES ('B'); INSERT INTO TestOrderBy2 (SomeData) VALUES ('A');  SELECT SomeData  FROM TestOrderBy UNION ALL SELECT SomeData FROM TestOrderBy2;  CREATE INDEX IX_TestOrderBy_SomeData ON TestOrderBy (SomeData); CREATE INDEX IX_TestOrderBy2_SomeData ON TestOrderBy2 (SomeData);  SELECT SomeData  FROM TestOrderBy UNION ALL SELECT SomeData FROM TestOrderBy2;   The results:    As you see, adding a simple index on the fields selected in the query alters the order of the results.  From here on, I'm adding ORDER BY unless I truly don't care. Can you be sued for using publicly used images on a blog without copyright permission? Lets say I write a blog post about the new Batman movie or a the new Grand Theft Auto game and i decide to use the boxart/poster or a wallpaper as the main image for the blog post,  can I be sued for breach of copyright on this image?  Im pretty sure Warner Bros are going to be hunting anyone down even if it is legal, but is this actually legal? If i buy the DVD or Game and take a picture of it, is this my copyright? When a trailer gets released and put on youTube, can i take a screenshot of this video and use this as an image?  It seems people can get rightly screwed for this, so I would like to know where i stand on this sort of thing. How do I fix Outlook only showing the first line of every message? I'm experiencing a strange problem with Outlook 2019. When viewing a message it only shows the first line. On an HTML message, it stops at the first close paragraph tag. On a plaintext message, it stops at the first newline character. This is true if viewing a message in the reading pane as well as if double-clicking the message to open in its own window. I have the preview pane set to show 3 lines and it does show more of the message so it seems like Outlook can see more of the message than it's rendering in the reading pane. If I use View Source, the underlying data seems fine and the whole message is there. I've tried the following:  Deleting and re-creating the user's mail profile Uninstalling &amp; re-installing Office Creating a new Windows account &amp; connecting Outlook to a different Exchange account than the one that originally exhibited the problem Checked for Windows updates Checked for Office updates  Any ideas what might be causing this? I feel like I've tried everything obvious &amp; I'm striking out on Google. How do you check if a JavaScript Object is a DOM Object? I'm trying to get:  document.createElement('div')  //=&gt; true {tagName: 'foobar something'}  //=&gt; false   In my own scripts, I used to just use this since I never needed tagName as a property:  if (!object.tagName) throw ...;   So for the second object, I came up with the following as a quick solution -- which mostly works. ;)  The problem is, it depends on browsers enforcing read-only properties, which not all do.  function isDOM(obj) {   var tag = obj.tagName;   try {     obj.tagName = '';  // Read-only for DOM, should throw exception     obj.tagName = tag; // Restore for normal objects     return false;   } catch (e) {     return true;   } }   Is there a good substitute? In the 1997 film "", the antagonist is attempting to elude some assassins who are after him. When they are pursuing his van, he quickly      pulls the van into a parking garage and washes off the color-changing paint he had earlier painted the van with, thus changing the color of the van.    He then takes a small can and sprays it onto the door handle of the van before taking off. A few minutes later, the assassins      enter the parking garage and notice the dyed water running away from the van. When one of the men goes to open the van using the tainted door handle, he pulls his hand away like it hurt, then starts foaming at the mouth. He immediately has a seizure of some kind and falls down dead.   What was the substance sprayed on the handle, and how could it do this so quickly? I tried to use GNOME Nightlight in Ubuntu 17.04. The settings only allow me to turn it on and adjust the time. Is it possible to adjust the intensity or temperature of the hue? Currently, it's a bit too much.