| | |
|---|
| | | m.employment_time, |
|---|
| | | DATE_FORMAT( NOW(), '%Y-%m-%d' )) as partyAge |
|---|
| | | from com_pb_member as m |
|---|
| | | LEFT JOIN sys_user u ON m.id_card = u.id_card and u.type = 1 |
|---|
| | | LEFT JOIN (select user_id,phone from sys_user where type = 1 and app_id = "wx118de8a734d269f0") u ON m.phone = u.phone |
|---|
| | | LEFT JOIN com_pb_org as cpo on cpo.id = m.org_id |
|---|
| | | LEFT JOIN com_pb_check_unit as cpcu ON m.check_unit_id = cpcu.id |
|---|
| | | LEFT JOIN (select t1.user_id,sum(t.duration) as partyTime,sum(t1.award) as partyInterval from com_act_activity t LEFT JOIN com_act_act_regist t1 on t.id = t1.activity_id where t1.sign_identity = 2 |
|---|
