| 0.0003 |
SELECT member_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '1'
AND `donate_kind` = 'F'
AND `donate_type` = 'P'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0002 |
SELECT company_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '1'
AND `donate_kind` = 'F'
AND `donate_type` = 'C'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0002 |
SELECT member_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '1'
AND `donate_kind` = 'O'
AND `donate_type` = 'P'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0002 |
SELECT company_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '1'
AND `donate_kind` = 'O'
AND `donate_type` = 'C'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0002 |
SELECT member_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '2'
AND `donate_kind` = 'F'
AND `donate_type` = 'P'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0001 |
SELECT company_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '2'
AND `donate_kind` = 'F'
AND `donate_type` = 'C'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0001 |
SELECT member_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '2'
AND `donate_kind` = 'O'
AND `donate_type` = 'P'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0002 |
SELECT company_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '2'
AND `donate_kind` = 'O'
AND `donate_type` = 'C'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0001 |
SELECT member_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '3'
AND `donate_kind` = 'F'
AND `donate_type` = 'P'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0002 |
SELECT company_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '3'
AND `donate_kind` = 'F'
AND `donate_type` = 'C'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0001 |
SELECT member_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '3'
AND `donate_kind` = 'O'
AND `donate_type` = 'P'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0002 |
SELECT company_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '3'
AND `donate_kind` = 'O'
AND `donate_type` = 'C'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0002 |
SELECT member_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '4'
AND `donate_kind` = 'F'
AND `donate_type` = 'P'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0001 |
SELECT company_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '4'
AND `donate_kind` = 'F'
AND `donate_type` = 'C'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0001 |
SELECT member_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '4'
AND `donate_kind` = 'O'
AND `donate_type` = 'P'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
| 0.0001 |
SELECT company_name, member_id, count(*) as cnt
FROM `tb_donate_summary` `A`
WHERE `donate_year` = '2025'
AND `donate_branch` = '4'
AND `donate_kind` = 'O'
AND `donate_type` = 'C'
GROUP BY `A`.`member_id`
ORDER BY `A`.`regist_date`
|
