I have a query which returns the count of a status that needs some very complex work to calculate. The user wants to drill down into that list, and I thought the easiest way would be to get the ids using GROUP_CONCAT.
Unfortunately, the result from GROUP_CONCAT is being truncated to 1024 (?!) characters.
Is it possible to get more than 1024 characters, or am I going about this the wrong way?