/* ApplicationName=DataGrip 2022.2.4 */ select a.userId, a.productId, a.groupId, b.assistantId from dwd_user_group_l a left join dwd_assistant_group_l b on a.productId = b.productId and a.groupId = b.groupId
where a.status = 0 and a.userId not like ‘qa%’ and a.userId not like ‘%test%’ order by a.joinGroupTime desc limit 100000