t_ageing

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

DROP TABLE IF EXISTS t_ageing;
CREATE TABLE IF NOT EXISTS t_ageing(
hospcode VARCHAR(5) NOT NULL,
pid VARCHAR(15) NOT NULL,
cid VARCHAR(13) NOT NULL,
seq VARCHAR(16) NOT NULL,
date_serv date,
SERVPLACE char(1) NOT NULL,
PPSPECIAL varchar(6) NOT NULL,
PPSPLACE varchar(5) DEFAULT NULL,
PROVIDER varchar(15) DEFAULT NULL,
D_UPDATE datetime NOT NULL,
BIRTH date,
SEX varchar(1) NOT NULL,
NATION varchar(3) DEFAULT NULL,
quarter_m int(1) DEFAULT 0,
PRIMARY KEY (hospcode,pid,quarter_m)
) ENGINE MyISAM DEFAULT CHARACTER SET=utf8;

INSERT IGNORE INTO t_ageing
(
SELECT n.HOSPCODE,n.PID,p.cid,n.SEQ,n.DATE_SERV,n.SERVPLACE,n.PPSPECIAL,n.PPSPLACE,n.PROVIDER,n.D_UPDATE
,p.BIRTH,p.SEX,p.NATION, IF(DATE_FORMAT(n.DATE_SERV,'%m') IN(10,11,12,1,2,3),1,
IF(DATE_FORMAT(n.DATE_SERV,'%m') IN(4,5,6,7,8,9),2,0
)) as quarter_m
FROM
specialpp n INNER JOIN person p ON n.HOSPCODE=p.HOSPCODE AND n.PID=p.PID
WHERE n.DATE_SERV >= p.birth
AND n.DATE_SERV BETWEEN @start_d AND @end_d
AND p.NATION in(99) AND TIMESTAMPDIFF(year,p.BIRTH,n.DATE_SERV) >=60
AND n.PPSPECIAL in('1B1280','1B1281','1B1282')
ORDER BY n.HOSPCODE ASC ,n.PID ASC ,n.DATE_SERV DESC
);
```

No file, test, or entry point is named; start by reviewing the SQL block for the intended t_ageing workflow and clarify the expected output with the repository maintainer. Done should be defined as a validated SQL script that creates and populates t_ageing with the required ageing records.

Written by the indexing model from the issue text.