Group Titles 4.x

[NathanR]

Where can I find the g_title in 4.x of IP.Board?  Doesn't seem to live in the core_groups table any longer.

[NathanR]

Found it in the core_sys_lang_words, but not seeing which fields to join that to core_groups ID.

[Daniel F]

The title is saved as language string because of the multi lang support. All the titles have a core_group_ prefix followed by the group id

[NathanR]

Thanks Daniel, got it worked out now.  If anyone needs help with the query went with this.

select g_id, word_default
from core_sys_lang_words cs
inner join core_groups g on replace(cs.word_key,'core_group_','') = g.g_id
where word_key like 'core_group_%'
order by g.g_id asc