Oh, that's a significant change in the XF2 approach for avatars, as my query works fine for XF1. Thanks for explaining in details!
And yes, I wanted to use the "Finder" system for my query, but it is, as you said, a bit of nuanced and I think Finder can't do something like
Code:
substring_index(group_concat(xf_user_field_value.field_id order by xf_user_field_value.field_value desc), ',', 1) as event_name
Still, I'll think about ways to simplify the query and use "Finder" system later sometime, but for the moment I am very happy as the Avatars (and a stable release of XF2) are the only remainings before I convert my 20k-post forum to XF2

.
I'll try this avatar thing tonight and let you know the result. Once again, thanks a ton for awesome support in your busy schedule!