How return list with inner list in SQL? I prepared following SQL statement: SELECT tasks.name, profiles.email, types.specification,     tasks.description, tasks.attachment_link, tasks.priority,     assigned_tasks.progress_details, assigned_tasks.activation_date,     assigned_tasks.expired_date   FROM profiles, types, tasks, assigned_tasks  WHERE profiles.id = assigned_tasks.profile_id  AND assigned_tasks.task_id = tasks.id  AND types.id = tasks.type_id ORDER BY tasks.name;  I want show in view gruped tasks with assigned email. Something like this:   I see records with single assignments, task names are duplicated. I want to show e-mail list in owner cell in table - it is possible? Python return touples: ('Backend', 'agnieszka.lasota1@gmail.com', 'Database managment', 'Create serwer full backend and copy data to SSD 1TB', 'NULL', 2, 'to do - 0% progress', datetime.datetime(2021, 6, 1, 10, 18, 36), None) ('call to customer', 'wolnygosc@interia.pl', 'IT online support', 'answer for questions about cloud', 'https://dianet.pl/cloud/index.html', 1, 'TO DO', datetime.datetime(2021, 6, 1, 14, 57, 23), None)  I want something like that: ('Backend', ('agnieszka.lasota1@gmail.com', 'wolnygosc@interia.pl'), 'Database managment', 'Create serwer full backend and copy data to SSD 1TB', 'NULL', 2, 'to do - 0% progress', datetime.datetime(2021, 6, 1, 10, 18, 36), None)  Two users might be assign to one task I want show it in HTML table. How split records ?
How to merge records for query set We have a question related to a DB query :   CREATE TABLE `Action` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `emp_Id` int(10) unsigned NOT NULL,   `name` varchar(60) NOT NULL,   `updated_action_at` datetime(3) DEFAULT NULL,   `created_At` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,   `notes` varchar(400) DEFAULT NULL,   PRIMARY KEY (`id`),    KEY `action_empId_fk` (`emp_Id`),    CONSTRAINT `action_empId_fk` FOREIGN KEY (`emp_Id`) REFERENCES `Employee` (`id`) ON DELETE CASCADE,  ) ENGINE=InnoDB AUTO_INCREMENT=502004 DEFAULT CHARSET=latin1   CREATE TABLE `ActionAssignedTo` (   `action_Id` int(10) unsigned DEFAULT NULL,   `emp_Id` int(10) unsigned DEFAULT NULL,   KEY `actionassignedto_emp_id_foreign` (`emp_Id`),   KEY `actionassignedto_action_id_foreign` (`action_Id`),   CONSTRAINT `ActionAssignedTo_ibfk_1` FOREIGN KEY (`emp_Id`) REFERENCES `Employee` (`id`) ON DELETE CASCADE,   CONSTRAINT `ActionAssignedTo_ibfk_2` FOREIGN KEY (`action_Id`) REFERENCES `Action` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1  CREATE TABLE `Employee` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `vendor_Id` int(10) unsigned DEFAULT NULL,   `name` varchar(40) NOT NULL,   `mobile_Number` varchar(15) NOT NULL,   `active` tinyint(1) DEFAULT '1',   `updated_At` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,   `created_At` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,   PRIMARY KEY (`id`),   KEY `employee_vendor_id_foreign` (`vendor_Id`),   CONSTRAINT `employee_vendor_id_foreign` FOREIGN KEY (`vendor_Id`) REFERENCES `Vendor` (`vendor_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=511 DEFAULT CHARSET=latin1   We want to find the action created by employee with Action.empId = 4 along with the list of Assignee (an action can be assigned to multiple people)  We have the following query :   Select     notes,             Action.id,             AssigneeName.name,             ActionAssignedTo.emp_Id  from       Employee inner join Action  on         (Action.emp_Id = Employee.id  and        Action.emp_Id in (select Employee.id                               from Employee                               where Employee.vendor_Id = 1)) inner      join ActionAssignedTo  on         Action.id =  ActionAssignedTo.action_Id inner join Employee as AssigneeName  on         ActionAssignedTo.emp_Id =  AssigneeName.id where      Action.emp_Id = 4   Now, lets say if Action with id = 10 was assigned to 2 people : John (empId : 2) And Jack (empId : 5) --> the above query returns following results :  (columns from the query)  notes                       | Action.id | AssigneeName.name | ActionAssignedTo.emp_Id 1. Finish Designing Queries | 10        | John              | 2 2. Finish Designing Queries | 10        | Jack              | 5   If we observe the above results the first 2 columns get repeated for the Assignees for SAME ACTION ID  --> is there a way we can merge them something like   1. Finish Designing Queries |10         | { John : 2  , Jack  : 5}   Basically records being merged into one.
I just realized I can't unrar .rar files on my Ubuntu machine!  What's the easiest way to accomplish this fundamental task? If possible I'd love something like 7Zip that I can just right Click, and extract and have the program worry about how to do it regardless if it's a .zip, a .rar or a .foo compressed file. What "allocation unit size" should I use for a drive with a single NTFS partition? I'm formatting a 1TB external hard drive as a single NTFS partition.  This drive is mainly meant for storing media.  Should I choose something other than the default allocation unit size?  The options range from 512 bytes to 64K.  Are there any guidelines that I should use with partitions storing other data?  Should I stop poking around and just leave it at "default"? I need to create a request for a web page delivered to our web sites, but I need to be able to set the host header information too.  I have tried this using HttpWebRequest, but the Header information is read only (Or at least the Host part of it is).  I need to do this because we want to perform the initial request for a page before the user can.  We have 10 web server which are load balanced, so we need to request the file from each of the web servers.    I have tried the following:  HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://192.168.1.5/filename.htm"); request.Headers.Set("Host", "www.mywebsite.com"); WebResponse response = request.GetResponse();   Obviously this does not work, as I can't update the header, and I don't know if this is indeed the right way to do it. I want to construct a complex power series with the radius of convergence $R=1$ that diverges in:  1) $k$ points on the circle $\{|z|=1\}$.  2) countable number of points on the circle  I have already crafted series that converges on the whole circle and diverges on the whole circle.  Can anybody help with the problem?  Update: I have googled a series $\sum{\frac{z^{kn}}{kn}}$ that is an answer for 1). Though I still need help for the countable case. OS X has this really nice feature when you have 3+ keyboard input sources (languages) and press Cmd + Space you switch between only two of them.  If you want to switch to another (third) language you just hold Cmd and press Space to choose from the list of input sources available.  How can I have similar functionality on Windows 10? I have 3 input sources and looping through them to get to the one I need is really annoying. What is the square root of $i^4$? What is the $\sqrt{i^4}$?   $i^4$ = $(i^2)^2$ So is $\sqrt{i^4}$ = $\sqrt{(i^2)^2}$ = $i^2$ = $-1$?  Or is $\sqrt{i^4}$ = $\sqrt{1}$ = $1$?  When I plug it into my TI-89 Titanium, I get $1$.  Edit: I now see why $i^4 \neq -1$. $$\sqrt{x^2} = \left|{x}\right| $$ So$$\sqrt{(i^2)^2} = \left|i^2\right| = \left|-1\right| = 1$$ C++ vectors (instead of arrays) Calculating Latitude/Longitude X miles from point? I am wanting to find a latitude and longitude point given a bearing, a distance, and a starting latitude and longitude.  This appears to be the opposite of this question ().  I have already looked into the haversine formula and think it's approximation of the world is probably close enough.  I am assuming that I need to solve the haversine formula for my unknown lat/long, is this correct? Are there any good websites that talk about this sort of thing? It seems like it would be common, but my googling has only turned up questions similar to the one above.  What I am really looking for is just a formula for this. I'd like to give it a starting lat/lng, a bearing, and a distance (miles or kilometers) and I would like to get out of it a lat/lng pair that represent where one would have ended up had they traveled along that route. Every once in a while I see users having issues to update due to errors like this:  E:Type 'ain' is not known on line 1 in source list /etc/apt/sources.list.d/some-ppa.list'   with varying types/line numbers/source list files (often after removing a PPA).  How can such an error be fixed? workspace switching via ctrl + alt + arrow not working after upgrade to 13.04, how to fix this? I read in a book &quot;Physics - Resnik and Halliday&quot; the explanation of Type-I Superconductors {cold ones} that:  The Electrons that make up current at super-cool temperatures move in coordinated pairs. One of the electrons in a pair may electrically distort the molecular structure of the superconducting material as it moves through, creating  nearby short-lived regions of positive charge.the other electron in the the pair may be attracted to the positive spot. According to the theory the coordination would prevent them from colliding with the molecules of the material and thus would eliminate electrical resistance  Is this the only explanation or can somebody give me a more intuitive explanation that also takes into the problem of defect scattering as in the case of resistance and also explains the Type-II superconductors {hot ones} P.S. What are &quot;coordinated pairs&quot;? Custom Cursor Image CSS I have a number of heroshot images, that have a modal popup when clicked.  I'm trying to get my cursor to turn into  magnifying glass whenever it is moved over the image. The following CSS does not appear to work even though my magnify.cur is present in the right location.  a.heroshot img {   cursor:url(/img/magnify.cur), pointer; }   Has anyone ever done anything similar? I don't mind a JavaScript solution if one exists.  EDIT: It works in Safari, but not in Firefox. Excel How to make Text Qualifier editable or add a new entry in the existing list? Change all file type associations from one program to another How to call gdal_translate from Python code? Is it possible to use some gdal API to call gdal_translate from Python code? I do not mean simply executing the gdal_translate.exe from the file system, but rather call it somehow in code so I do not need to know the exact directory the gdal_translate executable is in? Is openssl rand command cryptographically secure? I'm wondering if the openssl rand command produces cryptographically secure random bytes. For example when in need for a random password or token:  openssl rand -hex 32   The man page unfortunately does neither state it's cryptographically secure, nor that it's not.  On the one hand, I think this is openssl, its sole purpose is to do cryptography. On the other hand, the man page states something about reading and writing seed data instead of directly querying a CSPRNG.  So it is somewhat unclear for the end user. Does someone know? How can PPAs be removed? Why are effect size estimates (such as $R^2$) difficult in mixed-effects models? In the United States, we say that someone lives on a street, whereas I've noticed that British people say in. For instance:     Bubba lives on Washington Street.   Colin lives in Cavendish Avenue.   I believe we both would use at when a number is given. For instance:     Bubba lives at 16 Washington Street.   Colin lives at 7 Cavendish Avenue.   I don't think it matters if it's a road, avenue, street, circle, or lane — as far as I know, in America, we always live on a street. Does it vary in British English, or is it always in? If it varies, what are the rules? We know that $12^2 = 144$ and that $38^2 = 1444$. Are there any other perfect squares in the form of $\frac{13}{9} (10^n - 1) + 1$ (i.e. $1$ followed by $n$ $4$'s), and how would we prove it?