[TuiGirl 推女郎] No.001-No.070 无圣光套图合辑打包下载[XP/13.29G]

sisem · 发表于 2020-12-23 02:13:14

啥也不说了，感谢楼主分享哇！

nicky666 · 发表于 2020-12-29 03:28:46

hlmzr · 发表于 2020-12-31 22:04:35

with person_name as ( select c.id, array_to_string(array_agg(distinct p.c_name), ' , ') as p_name from biz_notification_config c join biz_notification_person p on p.id = any (string_to_array(c.persons, ',')::int[]) group by c.id ), group_name as ( select c.id, array_to_string(array_agg(distinct g.c_name), ' , ') as g_name from biz_notification_config c join biz_notification_group g on g.id = any (string_to_array(c.c_groups, ',')::int[]) group by c.id ) select config.*, person_name.p_name, group_name.g_name from biz_notification_config config left join person_name on config.id = person_name.id left join group_name on config.id = group_name.id;