Re: ordered list of titles, with fallback if title is only available in another language

2008-06-04 Thread Sebastian Mendel
Jack Bates schrieb: Given columns a, b, and c, where I GROUP BY a, how do I get the value of column b in each group which corresponds to the maximum value of column c? http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html -- Sebastian Mendel -- MySQL General Mailing Lis

ordered list of titles, with fallback if title is only available in another language

2008-06-04 Thread Jack Bates
Given columns a, b, and c, where I GROUP BY a, how do I get the value of column b in each group which corresponds to the maximum value of column c? I have a table which contains some translated records. Column a is the record id, column b is a translated field e.g. the title, and column c is a lan