| 1234567891011 |
- SELECT count(temp01.member_id) AS "member_count", temp01.member_id
- FROM
- (MATCH (company:/apoc/company)
- -[:company_member_info_rel*1..1]->
- (member:/apoc/member_info WHERE member_term_start <= '2026-03-30' AND member_term_end >= '2026-03-30')
- RETURN member.member_id_no AS "member_id", company.unified_social_credit_code AS "company_code") temp01
- GROUP BY temp01."member_id" HAVING count(DISTINCT temp01."company_code") > 1
- LIMIT 0, 20000 WITH TIMEOUT = 6m
|
