s_labor20_repeat

Nobody has claimed this yet.

``` sql
SET @prov_c := '14';
SET @id := '4f7d8042fb0a064b25f29a48f6ccd23f';
SET @b_year:='2017';
SET @start_d:=concat(@b_year-1,'1001');
SET @end_d:=concat(@b_year,'0930');

CREATE TABLE IF NOT EXISTS s_labor20_repeate(
id varchar(32) NOT NULL,
hospcode varchar(5) NOT NULL,
areacode varchar(8) NOT NULL,
flag_sent varchar(1) NOT NULL,
date_com varchar(14) NOT NULL,
b_year varchar(4) NOT NULL,
target int(9) DEFAULT 0,
result10 int(9) DEFAULT 0,
result11 int(9) DEFAULT 0,
result12 int(9) DEFAULT 0,
result1 int(9) DEFAULT 0,
result2 int(9) DEFAULT 0,
result3 int(9) DEFAULT 0,
result4 int(9) DEFAULT 0,
result5 int(9) DEFAULT 0,
result6 int(9) DEFAULT 0,
result7 int(9) DEFAULT 0,
result8 int(9) DEFAULT 0,
result9 int(9) DEFAULT 0,
target10 int(10) DEFAULT 0,
target11 int(10) DEFAULT 0,
target12 int(10) DEFAULT 0,
target1 int(10) DEFAULT 0,
target2 int(10) DEFAULT 0,
target3 int(10) DEFAULT 0,
target4 int(10) DEFAULT 0,
target5 int(10) DEFAULT 0,
target6 int(10) DEFAULT 0,
target7 int(10) DEFAULT 0,
target8 int(10) DEFAULT 0,
target9 int(10) DEFAULT 0,
PRIMARY KEY (id,hospcode,areacode,b_year),
KEY (hospcode),
KEY (areacode),
KEY (b_year)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DELETE FROM s_labor20_repeate WHERE id=@id AND b_year=(@b_year+543);

INSERT IGNORE INTO s_labor20_repeate
(
SELECT @id,h.hoscode,concat(h.provcode,SUBSTR(CONCAT('00',h.distcode),-2),SUBSTR(CONCAT('00',h.subdistcode),-2),SUBSTR(CONCAT('00',h.mu),-2)) as areacode
,@send,DATE_FORMAT(now(),'%Y%m%d%H%i') as d_com,@b_year+543
,COUNT(DISTINCT CONCAT(l.cid,'-',l.bdate)) traget
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(10), CONCAT(l.cid,'-',l.bdate),NULL )) r10
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(11), CONCAT(l.cid,'-',l.bdate),NULL )) r11
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(12), CONCAT(l.cid,'-',l.bdate),NULL )) r12
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(1), CONCAT(l.cid,'-',l.bdate),NULL )) r1
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(2), CONCAT(l.cid,'-',l.bdate),NULL )) r2
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(3), CONCAT(l.cid,'-',l.bdate),NULL )) r3
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(4), CONCAT(l.cid,'-',l.bdate),NULL )) r4
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(5), CONCAT(l.cid,'-',l.bdate),NULL )) r5
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(6), CONCAT(l.cid,'-',l.bdate),NULL )) r6
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(7), CONCAT(l.cid,'-',l.bdate),NULL )) r7
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(8), CONCAT(l.cid,'-',l.bdate),NULL )) r8
,COUNT(DISTINCT IF(l.gravida >1 AND DATE_FORMAT(l.bdate,'%m') IN(9), CONCAT(l.cid,'-',l.bdate),NULL )) r9
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(10), CONCAT(l.cid,'-',l.bdate),NULL)) traget10
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(11), CONCAT(l.cid,'-',l.bdate),NULL)) traget11
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(12), CONCAT(l.cid,'-',l.bdate),NULL)) traget12
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(1), CONCAT(l.cid,'-',l.bdate),NULL)) traget1
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(2), CONCAT(l.cid,'-',l.bdate),NULL)) traget2
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(3), CONCAT(l.cid,'-',l.bdate),NULL)) traget3
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(4), CONCAT(l.cid,'-',l.bdate),NULL)) traget4
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(5), CONCAT(l.cid,'-',l.bdate),NULL)) traget5
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(6), CONCAT(l.cid,'-',l.bdate),NULL)) traget6
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(7), CONCAT(l.cid,'-',l.bdate),NULL)) traget7
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(8), CONCAT(l.cid,'-',l.bdate),NULL)) traget8
,COUNT(DISTINCT IF(DATE_FORMAT(l.bdate,'%m') IN(9), CONCAT(l.cid,'-',l.bdate),NULL)) traget9
FROM t_labor l INNER JOIN chospital h ON l.bhosp=h.hoscode AND hostype in(5,6,7,11,12,15) AND h.provcode in(@prov_c)
INNER JOIN t_person_cid p ON l.cid=p.cid
WHERE TIMESTAMPDIFF(YEAR,p.birth,BDATE) < 20 AND l.BDATE BETWEEN @start_d AND @end_d
AND p.nation in(99)
GROUP BY HOSCODE
);

The issue contains only a MySQL SQL script and names no repository files, tests, or entry points. First determine the intended change and where this query belongs in the project; completion cannot be defined from the issue text alone.

Written by the indexing model from the issue text.