single query to fetch rows from mysql table using count(*) of two coloumns
single query to print all the rows whose count is greater than 10
What is the value of lim$_{n\to \infty} a_n$ if $\lim_{n \to \infty}\left|a_n+ 3\left(\frac{n-2}{n}\right)^n \right|^{\frac{1}{n}}=\frac{3}{5}$? Let $\{a_n\}$ be a sequence of real numbers such that $$\lim_{n \to \infty}\left|a_n+ 3\left(\frac{n-2}{n}\right)^n \right|^{\frac{1}{n}}=\frac{3}{5}.$$  What is the value of $\lim_{n\to \infty} a_n$? How do I inspect the view hierarchy in iOS? How can I install MonoDevelop v4 on 12.04? I am using Ubuntu 12.04. I can install v2.8.6.3 of Monodevelop from software center but I need at least v3 to use Monogame v3 or higher. Can anyone point me in the right direction please?   Thanks Does Airplane Mode allow GPS location to pass through? This is what I saw when my plane was taxing to the runway at CDG:     Airplane mode was on and all other transmissions (except Location), including WiFi, mobile data, NFC and Bluetooth were off.  Location was not manually turned on by me, after I enabled Airplane Mode. It remained turned on.  What am I missing? Is GPS now so widely accepted on-board planes that Android changed its configuration to let this kind of signal/communication to pass through Airplane mode "block"?  I believe that  isn't a duplicate, because at that time (2016) Location was generally "included" in Airplane mode and was turned off by enabling it. Is there any hint of of the first Wizarding War being an international event? Why isn’t singular ‘they’ used with 3Sg verb forms? There are many (duplicate) questions about the acceptance, popularity and history of singular they (and their, them and themself) around here, it even got a tag of its own. If I didn’t miss anything, however, the proper verb form hasn’t been questioned yet.  As we all know, English third person singular pronouns (it, she, he and one, +body), names (Alice, Bob, …) and nouns (student, teacher, …) demand the +(e)s suffix be added to the finite verb form in simple present, where some auxiliary verbs have a “special” form (is &lt; *bes / *ares and has &lt; *haves). All other subjects don’t, including plural third person pronoun they.  When the plural you replaced thou (with thee, thy / thine), the other marked verb form that had remained in English – i.e. suffix +(e)st or +t – vanished, too. The first and second persons only ever appear as pronouns (I, we; you), not names or nouns, so there was no strong inclination to keep the verbal inflection.  The second person precedent would suggest that singular they be used with uninflected verb forms which is how it’s usually encountered in the wild. Assuming that they someday replaces he and she (and maybe it) it would lead to disagreement with the words the pronoun stands in for:        Alice         goes to her   place  by herself.   Bob           goes to his   place  by himself.   Alice and Bob go   to their place  by themselves. – (common)   Alice and Bob go   to their places by themselves. – (separate)                  She  goes to her   place  by herself.   He   goes to his   place  by himself.   They go   to their place  by themselves.   They go   to their places by themselves.                  They ?goes to their place  by themself.   ditto   They  go   to their place  by themselves.   They  go   to their places by themselves.                  They ?go to their place  by ?themselves.   ditto   They  go to their place  by  themselves.   They  go to their places by  themselves.      So why doesn’t singular they afford s on present-tense verbs like all other third person singular subjects do?   I learned about singular they only long after I had been taught English as a second language in school. That’s why it’s still a conscious decision to use it and hence I could easily adapt to use s forms with it, but would that sound and look funny / strange / wrong to native speakers? Change the passphrase of an ecryptfs directory Say I have a variable named choice it is equal to 2. How would I access the name of the variable? Something equivalent to  In [53]: namestr(choice) Out[53]: 'choice'   for use in making a dictionary. There's a good way to do this and I'm just missing it.  EDIT:  The reason to do this is thus. I am running some data analysis stuff where I call the program with multiple parameters that I would like to tweak, or not tweak, at runtime. I read in the parameters I used in the last run from a .config file formated as  filename no_sig_resonance.dat  mass_peak 700  choice 1,2,3   When prompted for values, the previously used is displayed and an empty string input will use the previously used value.  My question comes about because when it comes to writing the dictionary that these values have been scanned into. If a parameter is needed I run get_param which accesses the file and finds the parameter.   I think I will avoid the problem all together by reading the .config file once and producing a dictionary from that. I avoided that originally for... reasons I no longer remember. Perfect situation to update my code! Approximating $\arctan x$ for large $|x|$ Why am I getting shopping trolley notifications about local store savings? I am getting "Shopping Trolley" notifications appearing regularly. The notification looks like this:   The notification is about "Store savings" at a local supermarket and that is it!   Is this notification from Google Maps or another application like Google Assistant? I'm struggling to find the specific setting to disable the notification.  I am also interested to know if this notification could in any way be targeted advertising generated by the store. My marketing preferences with the store are opt-out and this strikes me as very dumb advertising. Surely Google isn't doing this? Is there a means that a store can generate notifications like this? Could it be targeted if they have my email address?  These are pain and I want to understand why they are spamming me and disable them without disabling everything else.  I can see various options under Google Maps, settings, notifications. Which setting would apply? Could it be "New on maps, Get occasional updates about new features in your area"? I can't see what setting to suppress!  Thanks for all help. I 'had' better get going (Why 'had'??) Parallel universe: in every universe, you are presented with a different decision. Does that mean there are an infinite amount of parallel universes? I.e., if in one universe I choose to go left, I am then presented with different choices vs if i choose right, and that creates more universes with more decisions to be made.  Or does it mean that in the end of one's life we end up in the same place, meaning that its just one parallel universe that eventually collides with the other. If you cast Polymorph on a non beast creature then cast Awaken on their beast form how much carries over after polymorph ends?  Polymorph does not give any explicit information on what happens to your statistics when the polymorph ends:     The transformation lasts for the duration, or [drops to 0 hp]. [...] The target's game statistics, including mental ability scores, are replaced by the statistics of the chosen beast.  (Basic Rules, pg. 266)   So this leaves ambiguity when game statistics are altered during polymorph,   The charm effect of Awaken seems pretty clear from the  and reinforced by the specific wording referring to the target as a beast or plant during effects and a creature afterwards:     The awakened beast or plant is charmed by you [longer than polymorph.] When the charmed condition ends, the awakened creature chooses [...] (Basic Rules, pg. 216)   The other two effects of awakening (other than making a plant mobile) are less clear-cut:     The target gains an Intelligence of 10. The target also gains the ability to speak one language you know.  (Basic Rules, pg. 216)   I would guess the modification to intelligence would apply to the beast's stats and therefore end with polymorph.     as being independent of creature statistics and act more as the character's experience. I'd argue the experience of a stranger turning you into a mouse, then gifting you the ability - as a mouse - to speak a language you have never used before would be an experience you couldn't lose I'm not sure if the language and intelligence granted from awakening should remain linked.    These are two examples I can see this having significant impact on my campaign:   Meet an NPC I don't share a language with, Polymorph them then Awaken their beast form so they can speak my language. Can I now communicate with them when they turn back?  If their original intelligence was higher then 10 is it reduced to 10? Say I use find familiar to get an owl (classified as a fey) familiar, then polymorph it to an owl (classified as a beast) so my druid friend can cast Awaken on it, does my familiar keep an intelligence of 10 and/or the ability to speak?   So after reverting from an awoken polymorphed state would you keep the 10 intelligence and a new language, only the new language, or not keep either? How to Async.AwaitTask on plain Task (not Task)? I am currently writing my bachelor thesis and I am using LyX as my standard writing program (because I am not familiar with LaTeX at all).  For my bibliographystyle I use JabRef and the citation style needs to be Journal of Finance.  Now, I found this .bst file for the Journal of Finance style online () which is actually really good. But the problem is, that I need it in German. There must be an "und" instead of "and" and all the umlauts don't work as well. Basically I need everything in German.  Do you know a website with a German .bst file? Or can I change something in the settings in LyX or JabRef and everything would be fixed? Remove application from Google Launcher More options when flagging for migration Every time Windows 10 runs updates (which I see no way to control), it updates my graphics driver.  I like the old one because it is faster.  So, I have to reinstall it.  This is getting to be a pain.  Is there any way to stop Windows 10 from updating it again? Do particles in a sound wave ever move transversally? I'm trying to visualize how sound waves work and I was curious about something.   So sound moves in longitudinal waves, which I think I understand.  There is a really good  explaining this.  In the video the air particles are depicted as moving from left to right (longitudinally). But do they ever move up and down even a little bit? Are they on some kind of fixed axis where they can only move longitudinally and never move even the slightest bit in a vertical direction? \pause in tikzpicture breaks footline I've discovered that you can \pause within a tikzpicture, which works well until I switched the theme to one with a footline.  I've created a "test case" that illustrates the problem.  \documentclass{beamer} \providecommand\thispdfpagelabel[1]{} % Not sure what this does but our installation requires it. \usepackage{tikz} \usetheme{Madrid} % Has a footline.  \begin{document}   \begin{frame}     \frametitle{test}     \begin{tikzpicture}       \node at (0, 1) {Hello};       \pause       \node at (0, 0) {World};     \end{tikzpicture}   \end{frame} \end{document}   This creates two slides, but the footline is only drawn on the second (the headline/title appears on both). Is there anything I can do about this?