Table A (users)  id     | name   | ip 52433    Yashas   1.1.1.1 512      Admin    5.6.7.8   Table B (admin_record)  id    | admin | time    | date    | reason | action  52433   512     2312352   1213213   Test     WARN   id is FOREIGN key  Table B keeps a log of all actions an administrator takes on his users. And the table A stores the account information of the users &amp; administrators.  I am trying to display a list of actions taken by a administrators on a user.   I want to write a query which gets me all the rows of table B where id = fixed number.  Here is what I want to display:  "Administrator1 [Name]" took action on "User Name" for "[Note]" on XX/XX/XXXX. "Administrator2 [Name]" took action on "User Name" for "[Note]" on XX/XX/XXXX. "Administrator3 [Name]" took action on "User Name" for "[Note]" on XX/XX/XXXX.   All I have is the user's id using which I need to obtain all the entries in the log along with the administrator names. I need to obtain the admin's name, users name and all the contents of table B related to a particular user in one single query. If possible, I want the to change the field name(not literally change, but want the SQL server to send the data with new field names to separate admin name &amp; user name) of the admin's name to admin_name and user's name as . I mean something like this  SELECT users.name AS admin_name WHERE users.id = %i  AND SELECT users.name AS user_name WHERE users.id = %i   (the query isn't correct,it us just an example to show what I am trying)  Progress so far:   SELECT player.name, player.ip, admin.name, record.date, record.time, record.action, record.reason FROM admin_record AS record JOIN users AS player ON player.id = record.id JOIN users AS admin ON admin.id = record.admin WHERE player.id=%i   where admin_record is table B &amp; users is table A.
I have two tables A &amp; B. Table A id | name | num  Table B id | date | roll  id in table B is a foreign key which relates to the id in table A. I want to get the contents of table B where id is given and also along with that data, I need the name whose id is given from table A. NOTE: cannot use multiple queries separated by commas; need to do both the SELECTs in one query.
What do brokers do with bad stock? Blender 2.8 - AWS EC2 command line EEVEE render I have been trying to get this to work for a couple days now. I have an EC2 P2 instance with NVIDIA CUDA configured by default, its a Deep learning Ubuntu AMI. This OS does not have a GUI so everything is via terminal.  I downloaded Blender's 2.8 TAR file for Linux and set it up on the EC2 instance. And ran the following command from the directory where the TAR file is extracted:   ./blender -b -noaudio /home/ubuntu/file.blend --render-output . --engine BLENDER_EEVEE --render-format PNG --verbose 4   All I see in the output is this:  Blender 2.80 (sub 75) (hash f6cb5f54494e built 2019-07-29 17:17:04) found bundled python: /mnt/blender/blender-2.80-linux-glibc217-  x86_64/2.80/python Read blend: /home/ubuntu/file.blend  Blender quit   Don't know why its quitting but I am unable to debug this any further. Any help would be appreciated.  UPDATE: As per @rjg's recommendation, ran the following command:  ./blender -b -noaudio /home/ubuntu/file.blend --render-output . --engine BLENDER_EEVEE --render-format PNG -f 1 --verbose 4   Got the following error:  Blender 2.80 (sub 75) (hash f6cb5f54494e built 2019-07-29 17:17:04) found bundled python: /home/ubuntu/blender/blender-2.80-linux-glibc217-  x86_64/2.80/python Read blend: /home/ubuntu/file.blend Unable to open a display Aborted (core dumped) If $aRb \land bRc$ never occurs, is a relation considered transitive? Custom Button on Lightning Experience I created a custom button Send Email in Lightning Experience. The problem is that button in visible in feed section layout, but I want to put it in the upper right corner of page layouts near Edit, Clone, Delete ecc....  How Can I do that? Thanks  I add an image that explain the situation.    EDIT: I would like to explain you better my problem.  I have created three custom quick action:   I have added them to the case page Layout as you can see    I would like to understand the reason why I don’t see these three custom action in the Page Layout in the section in the top right Map matrix element to string Social Login adoption vs Traditional Login I have implemented  on my website. I am wondering how important it is to include a traditional login (email/password) system.  I believe there may be a significant percentage of potential users that are either uncomfortable or unfamiliar with social login. These users may not sign up for my site if social login is the only option.  Does anyone know of any data comparing social login vs traditional login and the corresponding adoption rate?  Is there a current best practice? Do I need to give the user an option to sign up using username/password? Or is facebook/google/openID/twitter/MS/Yahoo enough? Could I replace headphones NIMH battery with Lithium Ion phone battery of the same voltage? Integral $ \int_{-\infty}^{\infty}\frac{x^{2}}{\cosh\left(x\right)}\,{\rm d}x $ I need to compute the improper integral $$ \int_{-\infty}^{\infty}\frac{x^{2}}{\cosh\left(x\right)}\,{\rm d}x $$ using contour integration and possibly principal values.  Trying to approach this as I would normally approach evaluating an improper integral using contour integration doesn't work here, and doesn't really give me any clues as to how I should do it. This normal approach is namely evaluating the contour integral $$ \oint_{C}{\frac{z^2}{\cosh\left(z\right)}\mathrm{d}z} $$ using a semicircle in the upper-half plane centered at the origin, but the semicircular part of this contour integral does not vanish since $\cosh\left(z\right)$ has period $2\pi\mathrm{i}$ and there are infinitely-many poles of the integrand along the imaginary axis given by $-\pi\mathrm{i}/2 + 2n\pi\mathrm{i}$ and $\pi\mathrm{i}/2 + 2n\pi\mathrm{i}$ for $n \in \mathbb{Z}$. The residues of the integrand at these simple poles are $-\frac{1}{4}\mathrm{i}\pi^{2}\left(1 - 4n\right)^{2}$ and $\frac{1}{4}\mathrm{i}\left(4\pi n + \pi\right)^{2}$, so that even when we add up all of the poles, we have the sum $4\pi^{2}\mathrm{i}\sum_{n = 0}^{\infty}\,n$, which clearly diverges.  Any hints would be greatly appreciated. Which is more idiomatic in a bash script: `|| true` or `|| :`? I don't do terribly much shell scripting, so I was a little surprised when I was reading  and I saw the syntax they used in this documentation:     A non-zero return from the command in any submodule causes the processing to terminate. This can be overridden by adding || : to the end of the command.   I had to look up that || : was a shorthand for forcing a command to exit successfully.  Anytime I've had to make a command exit successfully, I used || true.  Is || : considered to be more idiomatic? How can I securely format a solid-state drive? Changing the size of the mouse pointer in Ubuntu MATE 18.04 does not work I have Ubuntu 18.04 with the gnome-desktop  and parallel the Ubuntu MATE desktop installed. While I can easily change the size of the mouse pointer (DMZ-White) in the Gnome3 desktop , this does not work on the MATE desktop. I use for this the dconf-editor.  Maybe someone knows a solution?  Thanks a lot. Biblatex 3.3 name formatting I would like to create a custom format for citing authors' names in the text, let's call it "newformat". One option I can think of is creating a new bibmacro for names where the parameters are changed to my liking, such as   \documentclass{article}    \usepackage{filecontents}   \usepackage[backend=biber]{biblatex}[2016/01/01] %the latest version of biblatex?   % biber is version 2.4; the latest?  \begin{filecontents}{\jobname.bib} @misc{Doe12,   author = {Doe, John},   year = {2012},   title = {A macro for formatting names}, } \end{filecontents}  \addbibresource{\jobname.bib} \nocite{*}  \newbibmacro{name:newformat}{\printnames{authors}} \DeclareNameFormat{newformat}{%   \usebibmacro{name:newformat}{\textbf{#1}}{\textbf{#3}}{#5}{#7}%   \usebibmacro{name:andothers}% }  \begin{document}    \section*{Testing the format here}    I am citing   \citename{Doe12}[newformat]{author}    \printbibliography % to make sure that the .bib file is properly formated.  \end{document}   Here, I just used \textbf for the sake of the example, but I ultimately want to use other functions, say upper case or palindrome!  However, I get this weird error message:  ! Illegal parameter number in definition of \blx@defformat@d. &lt;to be read again&gt;                     3 l.20   \usebibmacro{name:last}{#1}{#3                                      }{#5}{#7}%   which seems to indicate that the second option {#3} is not expected. I am a bit at a lost here; I checked the biblatex package and \usebibmacro{name:last} must be given 4 parameters, isn't it? Please advise. What algorithm is used by computers to calculate logarithms? What should I do when Ubuntu freezes? What does ':' (colon) do in JavaScript? Determine device (iPhone, iPod Touch) with iOS Is there a way to determine the device running an application. I want to distinguish between iPhone and iPod Touch, if possible. I downloaded Ubuntu 14.04 (64 bit) lts. I made a bootable usb stick. But I keep receiving this error message upon booting:  SYSLINUX 4.04 EDD 20110518 Copyright (C) 1994-2011 H. Peter Anvin et al Unknown keyword in configuration file: gfxboot.c32: not a COM32R image At some point, the filesystem on my digital audio player has become read-only. I cannot copy files into it or remove files on it.  Are there some possible reasons for the player's file system to change permissions in this way?  I tried using chmod:  $ sudo chmod a+rw SGTL\ MSCN/  chmod: changing permissions of `SGTL MSCN/': Read-only file system   SGTL MSCN is the mount point of the digital audio player.  What else can I try to make it writeable? What is this sand covered insect? I have found in a wooden house, in the mountains of central Spain this very curious insect:    I was wondering if that was its skin or whether it's decomposition or sand or saw-dust.  That particular region of Spain does have stink-bugs ... but this one doesn't look like anything I've seen before.  A google image search returns mostly arachnids ... but it seems to have only 6 legs. I'm creating a model for a 3D game that will eventually be exported using a custom Python script. This model makes heavy use of UV textures.  However, the project now references a bunch of images that are not used by any objects in the project. Example:    I don't want the first two, or the red_bubble.png image. However, I have no idea how to remove them from the project. Selecting one of them reveals that there are "2 users of the data" although I am not using it anywhere.  How can I get rid of these excess images?