It's probably worth noting that GROUP_CONCAT is by default limited to 1024 bytes. You can work around this by setting it higher for the duration of your procedure, ie. SET @@group_concat_max_len = 32000;

@Edward 2013-11-13 17:49:55

The comment at the end regarding "max_len" was a lifesaver! Thanks for the tip.