I have a IN clause query in which I pass this ID'S (10,19,23,24,28,33,45,46,1,4,7,8,12,16,18,22,29)  My query is,   SELECTpost_jobs.idFROMpost_jobsWHEREidIN(10,19,23,24,28,33,45,46,1,4,7,8,12,16,18,22,29)  It execute correctly and returns result first id likes 1 then 4 then 7 and so on...that is ascending order  My Need is to get first result of id 10 then 19 then 23 as the order of ID that I passed is there any way to get such type of result in output.
Is it possible to do a SELECT statement with a predetermined order, ie. selecting IDs 7,2,5,9 and 8 and returning them in that order, based on nothing more than the ID field?  Both these statements return them in the same order:   SELECT id FROM table WHERE id in (7,2,5,9,8)    SELECT id FROM table WHERE id in (8,2,5,9,7)
When clicking between "Week", "Month", "Quarter", "Year" and "All" on the users page, the name I have typed in to filter on disappears. I feel like it should stay there, so that I can type in my name, and see how I've done in a week/month/etc. What does "Meta" mean? I am fairly new to Stack Overflow and just stumbled across Meta Stack Overflow.  I can't seem to figure out what the purpose of the "Meta" site is. Can someone please explain it to me? Is there a 'rule of thumb' that I can use to estimate depth of field while shooting? I can use a DoF calculator, or crunch the heavy math by hand if I really want to know exactly what my DoF is going to be... but most of the time knowing exactly is actually overkill, and taking the time to pull out a DoF calculator is impractical. I'm wondering if anyone knows of a 'rule of thumb' that is common for quickly figuring out a rough estimate of what my DoF will be when I'm in the field... $(function(){   $('.slider').mobilyslider({     content: '.sliderContent',     children: 'div',     transition: 'horizontal',     animationSpeed: 500,     autoplay: true,     autoplaySpeed: 9000,     pauseOnHover: true,     bullets: true,     arrows: true,     arrowsHide: true,     prev: 'prev',     next: 'next',     animationStart: function(){},     animationComplete: function(){}   });    });   I am integrating the above JavaScript file in a Drupal theme, but it is giving me the "$ is not function" error. I googled it, and changed the code bro the below, but it doesn't work either.  (function($) {   $('.slider').mobilyslider({     content: '.sliderContent',     children: 'div',     transition: 'horizontal',     animationSpeed: 500,     autoplay: true,     autoplaySpeed: 9000,     pauseOnHover: true,     bullets: true,     arrows: true,     arrowsHide: true,     prev: 'prev',     next: 'next',     animationStart: function(){},     animationComplete: function(){}   });    })(jQuery);   The above code gives me following error:     $('.slider').mobilyslider is not a function A virtual file containing the concatenation of other files Is there a way of creating a filesystem object akin to this:  mknod files p cat file1 file2 ... fileN &gt; files   but such that it can be seeked in, as if it were a regular file? What is Uplay? Can I play Ubisoft games without it? Heroes of Might and Magic VI seems to have installed a program called "Uplay", which it uses to launch (in addition to Steam, mind!)  What exactly is Uplay supposed to be? I notice that when I stop playing, it captchalogs the highlights of my past session (achievements earned, etc.) - which is kinda cool, but also kinda creepy and big-brotherish. Given that I value my privacy, is there anyway to play Uplay games without using Uplay?  Is this just Ubisoft's infamous "always-on" DRM? Is it possible for a foreigner to drive through (mainland) China in a foreign-registered car? Is it possible to drive through mainland China, for example for transit from Kazakhstan to Vietnam, as a non-Chinese citizen, in an own car/van/truck?  This is about an European Union citizen, trying to make a tourist trip overland by car from the EU to Vietnam. This is about a special (equipped with sleeping, cooking and other facilities) vehicle, that the owner intends to keep and use in Vietnam, so buying/renting a vehicle inside China and selling it before leaving is not an option - the question is about driving a specific vehicle the owner already has in the EU to Vietnam. getting new licence plates is OK, as long as it is allowed to put back the old ones when the vehicle gets back to the EU.  What legal issues are there with getting in an own car over China, and how to overcome them?  Is it possible to drive a car with EU licence plates through China, or would one have to get something like temporary Chinese plates? Is an EU driving licence valid? Are there any customs issues one has to know about, and how long one can keep a foreign motor vehicle in China without having to pay import taxes on it? What term describes a non-offensive substitute for a swear word?   For example, Battlestar Galactica used frack instead of fuck. Another example is the use of snap instead of shit.  I think I may have heard a single-word term used to describe such alternate non-offensive words before, but I don’t know what it is. Why are my photos not crisp? I use a Canon EOS Rebel T3i (600D) with the kit lens. I have experimented a lot with different settings and modes, but I feel like I have wasted many good shots that could have looked amazing, if only they were a little bit sharper.  I use auto-focus on most of my pictures and make sure to choose the right focus point, but all of my photos are still a little bit out of focus. When I zoom in, I can see that the pixels are not very crisp or well-aligned.  I am not sure if this issue is caused by my equipment or skills. Enqueuing Google Web Fonts the usual way, i.e., using the wp_enqueue_style function like so...  function wpse_google_webfonts() {     wp_enqueue_style( 'google-webfonts', 'http://fonts.googleapis.com/css?family=Ubuntu+Condensed|Open+Sans:400italic,700italic,400,700' ); } add_action( 'wp_enqueue_scripts', 'wpse_google_webfonts' );   ...results in a link tag placed in the header like so:  &lt;link rel='stylesheet' id='google-webfonts-css'  href='http://fonts.googleapis.com/css?family=Ubuntu+Condensed%7COpen+Sans%3A400italic%2C700italic%2C400%2C700&amp;#038;ver=3.5' type='text/css' media='all' /&gt;   As you can see, the resultant URL is encoded.  I am pretty sure it poses no problems, but to keep things clean and clear, I would like to go ahead and ask -- Is there a way to enqueue Google Web Fonts (via functions.php and not a plugin) in a way that the URL output is not encoded?  That's like so:  &lt;link rel='stylesheet' id='google-webfonts-css'  href='http://fonts.googleapis.com/css?family=Ubuntu+Condensed|Open+Sans:400italic,700italic,400,700?ver=3.5' type='text/css' media='all' /&gt;   Reason For Bounty  @webaware's answer is near perfect, especially because it's similar to the method employed in  theme.  The only problem in the output is that it's like this:  &lt;link rel='stylesheet' id='twentytwelve-fonts-css'  href='http://fonts.googleapis.com/css?family=Ubuntu+Condensed|Open+Sans:400italic,700italic,400,700&amp;#038;subset=latin,latin-ext' type='text/css' media='all' /&gt;   Notice the &amp;#038;? It should be &amp;, otherwise the font-files served only have the latin glyphs (i.e. the subset parameter in the URL is neglected unless you use &amp; and NOT its HTML entity).  Anyone who can help modify @webaware's answer so that the output's looks like this...  &lt;link rel='stylesheet' id='twentytwelve-fonts-css'  href='http://fonts.googleapis.com/css?family=Ubuntu+Condensed|Open+Sans:400italic,700italic,400,700&amp;subset=latin,latin-ext' type='text/css' media='all' /&gt;   ...wins the bounty. How to reference the caller object ("this") using attachEvent Proving that if $V$ is an inner product space and $U_1, U_2$ are subsets, then $U_1 \subset U_2$ if and only if $U^{\perp}_2 \subset U^{\perp}_1$ Blender build for Raspberry Pi3? Noether's Theorem: Lie groups vs. Lie algebras; finite vs. infinitesimal symmetries I've had a brief look through similar threads on this topic to see if my question has already been answered, but I didn't find quite what I was looking for, perhaps it is because I'm finding it hard to put words on my question and I hope that you will be able to help me ask it clearly.  I'm trying to link what I know from mathematics to what we are writing in physics for Noether's theorem. If I understand correctly we are looking at the symmetries of the action i.e. under which symmetry groups is it invariant. Noether's theorem allows us to calculate a conserved current in the case of a continuous symmetry (Lie groups), by means of so-called infinitesimal symmetries which I believe to be elements of the Lie algebra (so the tangent space to the neutral element) of the Lie group.  I'm guessing that if the action is invariant under the symmetry then it's "variation" should be 0 when we vary the system (space-time coordinate, or field) using this symmetry; it is exactly this step that I would like to understand better, how can I formalize this step correctly mathematically? How should I understand this variation, and how does it's calculation give rise to the elements of the Lie algebra? Why do some tests have a (nonzero) minimum score? Answers to a  mention that it is illegal for a US citizen to enter/leave their home country on a foreign passport. However this raises the following questions:   What is the maximum prescribed penalty for violating these rules? Are US immigration officials known for actually applying the penalty? E.g. the Cuba embargo banning visits to Cuba was almost never enforced, so it's possible this law is ignored as well. Pokemon Go Supported Devices How to identify the process locking a file? Matrices $B$ that commute with every matrix commuting with $A$ Using wilcox.test() and t.test() in R yielding different p-values