Table vispp2008 contains fields: [id] [regdate] [firstname] [lastname] [status] [status2] [sex] [institution] [position] [position_spec] [interests] [laptop] [diet] [visa] [email] [webpage] [address] [country] [phone] [fax] [fee] [bus] [comment] [vispp2008] [title] [abstract]
SELECT country, CONCAT(firstname,' ',lastname) AS fullname, institution, position FROM vispp2008 WHERE status = 'Submitted' ORDER BY country,institution,lastname
Show result in: table or comma-separated row
In 1 2 3 columns