Re: confirm unsubscribe to mysql@lists.mysql.com

2007-03-22 Thread Julius Junghans
On Thursday 22 March 2007 18:14, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > removed from the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/u/mysql/4602b972c92bc308/julius.junghans=gmx.de > > This confirmation serves

GROUP_CONCAT() use on query

2006-04-29 Thread julius Junghans
SELECT * , GROUP_CONCAT(DISTINCT language.language SEPARATOR ', ') AS Sprachen FROM item_all_language LEFT JOIN item ON itemitem_identity = item.item_identity LEFT JOIN language ON languagelanguage_identity = language.language_identity GROUP BY item.titel; SELECT * , GROUP_CONCAT(CONCAT( author.s