หากลุ่มเป้าหมาย 9,18,30,42 ด. รายเดือน

การหากลุ่ม 9,18,30,42เดือน เพื่อคีย์ความครอบคลุมและเก็บไว้เป็นผลงานรายเดือน
ให้ รันเป็นเดือนๆ ไป
ตัวอย่าง :หากมี "ช่องว่าง"... (1) และ (2) >> แสดงว่า นู๋ลืมบันทึกนะจ๊ะ

.......................................
1.scpt เดือน ตุลาคม 2559  ตามนี้
............................................................
SELECT s.pcucode,s.pid,s.idcard,s.titlename 'คำนำหน้า',s.fname 'ชื่อ'
,s.lname 'สกุล',s.birth 'วดป.เกิด',s.age 'อายุปี',s.hno 'เลขที่',s.villcode 'หมู่ที่',s.interSc 'ช่วงวันที่ที่ต้องคัดกรอง',t.dateserv 'วันที่คัดกรองครั้งแรก',t.codePP 'รหัสคัดกรอง'
FROM ((SELECT p.pcucodeperson AS pcucode ,p.pid ,p.idcard ,ct.titlename ,p.fname ,p.lname
,p.birth ,h.hno ,Right(h.villcode,2) AS villcode ,getagemonth(p.birth,'2016-10-01')AS age
,IF((p.birth BETWEEN '2013-03-01'AND'2013-03-31'),CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2014-03-01'AND '2014-03-31',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2015-03-01'AND '2015-03-31',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2015-12-01'AND '2015-12-31',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '9' MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '9' MONTH),INTERVAL '30' DAY))),''))))AS interSc FROM person p INNER JOIN house h ON p.hcode = h.hcode INNER JOIN ctitle ct ON p.prename=ct.titlecode INNER JOIN visit vt ON p.pcucodeperson=vt.pcucodeperson AND p.pid=vt.pid WHERE p.typelive IN ('1','3') AND((p.birth BETWEEN '2013-03-01'AND'2013-03-31')OR (p.birth BETWEEN '2014-03-01'AND '2014-03-31')OR (p.birth BETWEEN '2015-03-01'AND '2015-03-31')OR (p.birth BETWEEN '2015-12-01'AND '2015-12-31'))
GROUP BY vt.pid ORDER BY p.pid,p.birth) AS s LEFT JOIN (SELECT f43pp.pcucodeperson pcucode,f43pp.pid,IF(f43pp.dateserv IS null,'',f43pp.dateserv)AS dateserv,
getagemonth(p.birth,f43pp.dateserv) AS ageScreen,IF(f43pp.ppspecial IS NULL,'',GROUP_CONCAT(f43pp.ppspecial))AS codePP FROM f43specialpp AS f43pp
INNER JOIN person AS p ON f43pp.pid = p.pid AND f43pp.pcucodeperson = p.pcucodeperson
WHERE f43pp.dateserv BETWEEN '2016-09-01' AND '2016-10-30'
AND p.typelive IN ('1','3') AND f43pp.ppspecial LIKE '1B2%' AND((p.birth BETWEEN '2013-03-01'AND'2013-03-31') OR (p.birth BETWEEN '2014-03-01'AND '2014-03-31')OR
(p.birth BETWEEN '2015-03-01'AND '2015-05-31')OR (p.birth BETWEEN '2015-12-01'AND '2015-12-31')) AND p.pid NOT IN (SELECT persondeath.pid FROM persondeath)
GROUP BY f43pp.pid ORDER BY f43pp.dateserv DESC) as t ON s.pid=t.pid );
...........................................................
2.scpt เดือน พฤศจิกายน  2559  ตามนี้
..........................................................
SELECT s.pcucode,s.pid,s.idcard,s.titlename 'คำนำหน้า',s.fname 'ชื่อ'
,s.lname 'สกุล',s.birth 'วดป.เกิด',s.age 'อายุปี',s.hno 'เลขที่',s.villcode 'หมู่ที่',
s.interSc 'ช่วงวันที่ที่ต้องคัดกรอง',t.dateserv 'วันที่คัดกรองครั้งแรก',t.codePP 'รหัสคัดกรอง'
FROM ((SELECT p.pcucodeperson AS pcucode ,p.pid ,p.idcard ,ct.titlename ,p.fname ,p.lname
,p.birth ,h.hno ,Right(h.villcode,2) AS villcode ,getagemonth(p.birth,'2016-11-01')AS age
,IF((p.birth BETWEEN '2013-04-01'AND'2013-05-01'),CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2014-04-01'AND '2014-05-01',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2015-04-01'AND '2015-05-01',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2016-01-01'AND '2016-01-31',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '9' MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '9' MONTH),INTERVAL '30' DAY))),''))))AS interSc FROM person p INNER JOIN house h ON p.hcode = h.hcode INNER JOIN ctitle ct ON p.prename=ct.titlecode INNER JOIN visit vt ON p.pcucodeperson=vt.pcucodeperson AND p.pid=vt.pid WHERE p.typelive IN ('1','3') AND((p.birth BETWEEN '2013-04-01'AND'2013-05-01')OR (p.birth BETWEEN '2014-04-01'AND '2014-05-01')OR (p.birth BETWEEN '2015-04-01'AND '2015-05-01')OR (p.birth BETWEEN '2016-01-01'AND '2016-01-31'))
GROUP BY vt.pid ORDER BY p.pid,p.birth) AS s LEFT JOIN (SELECT
f43pp.pcucodeperson pcucode,f43pp.pid,IF(f43pp.dateserv IS null,'',f43pp.dateserv)AS dateserv,
getagemonth(p.birth,f43pp.dateserv) AS ageScreen,IF(f43pp.ppspecial IS NULL,'',GROUP_CONCAT(f43pp.ppspecial))AS codePP
FROM f43specialpp AS f43pp INNER JOIN person AS p ON f43pp.pid = p.pid AND f43pp.pcucodeperson = p.pcucodeperson WHERE f43pp.dateserv BETWEEN '2016-10-01' AND '2016-11-30' AND p.typelive IN ('1','3') AND f43pp.ppspecial LIKE '1B2%'
AND((p.birth BETWEEN '2013-04-01'AND'2013-05-01')OR
(p.birth BETWEEN '2014-04-01'AND '2014-05-01')OR
(p.birth BETWEEN '2015-04-01'AND '2015-05-01')OR
(p.birth BETWEEN '2016-01-01'AND '2016-01-31'))
AND p.pid NOT IN (SELECT persondeath.pid FROM persondeath)
GROUP BY f43pp.pid ORDER BY f43pp.dateserv DESC) as t 
ON s.pid=t.pid );
.....................................................
2.scpt เดือน ธันวาคม  2559  ตามนี้
..........................................................

SELECT s.pcucode,s.pid,s.idcard,s.titlename 'คำนำหน้า',s.fname 'ชื่อ'
,s.lname 'สกุล',s.birth 'วดป.เกิด',s.age 'อายุปี',s.hno 'เลขที่',s.villcode 'หมู่ที่',
s.interSc 'ช่วงวันที่ที่ต้องคัดกรอง',t.dateserv 'วันที่คัดกรองครั้งแรก',t.codePP 'รหัสคัดกรอง'
FROM ((SELECT p.pcucodeperson AS pcucode ,p.pid ,p.idcard ,ct.titlename ,p.fname ,p.lname
,p.birth ,h.hno ,Right(h.villcode,2) AS villcode ,getagemonth(p.birth,'2016-12-01')AS age
,IF((p.birth BETWEEN '2013-05-01'AND'2013-06-01'),CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2014-05-01'AND '2014-06-01',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2015-05-01'AND '2015-06-01',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2016-02-01'AND '2016-02-28',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '9' MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '9' MONTH),INTERVAL '30' DAY))),''))))AS interSc FROM 
person p INNER JOIN house h ON p.hcode = h.hcode INNER JOIN ctitle ct ON p.prename=ct.titlecode INNER JOIN visit vt ON p.pcucodeperson=vt.pcucodeperson AND p.pid=vt.pid WHERE p.typelive IN ('1','3') 
AND((p.birth BETWEEN '2013-05-01'AND'2013-06-01')OR (p.birth BETWEEN '2014-05-01'AND '2014-06-01')
OR (p.birth BETWEEN '2015-05-01'AND '2015-06-01')OR (p.birth BETWEEN '2016-02-01'AND '2016-02-28'))
GROUP BY vt.pid ORDER BY p.pid,p.birth) AS s LEFT JOIN (SELECT
f43pp.pcucodeperson pcucode,f43pp.pid,IF(f43pp.dateserv IS null,'',f43pp.dateserv)AS dateserv,
getagemonth(p.birth,f43pp.dateserv) AS ageScreen,IF(f43pp.ppspecial IS NULL,'',GROUP_CONCAT(f43pp.ppspecial))AS codePP
FROM f43specialpp AS f43pp INNER JOIN person AS p ON f43pp.pid = p.pid 
AND f43pp.pcucodeperson = p.pcucodeperson WHERE f43pp.dateserv 
BETWEEN '2016-11-01' AND '2016-12-30' AND p.typelive IN ('1','3') AND f43pp.ppspecial LIKE '1B2%'
AND((p.birth BETWEEN '2013-05-01'AND'2013-06-01')OR
(p.birth BETWEEN '2014-05-01'AND '2014-06-01')OR
(p.birth BETWEEN '2015-05-01'AND '2015-06-01')OR
(p.birth BETWEEN '2016-02-01'AND '2016-02-28'))
AND p.pid NOT IN (SELECT persondeath.pid FROM persondeath)
GROUP BY f43pp.pid ORDER BY f43pp.dateserv DESC) as t 
ON s.pid=t.pid );
..........................................................
2.scpt เดือน มกราคม  2560  ตามนี้
........................................................
SELECT s.pcucode,s.pid,s.idcard,s.titlename 'คำนำหน้า',s.fname 'ชื่อ'
,s.lname 'สกุล',s.birth 'วดป.เกิด',s.age 'อายุปี',s.hno 'เลขที่',s.villcode 'หมู่ที่',
s.interSc 'ช่วงวันที่ที่ต้องคัดกรอง',t.dateserv 'วันที่คัดกรองครั้งแรก',t.codePP 'รหัสคัดกรอง'
FROM ((SELECT p.pcucodeperson AS pcucode ,p.pid ,p.idcard ,ct.titlename ,p.fname ,p.lname
,p.birth ,h.hno ,Right(h.villcode,2) AS villcode ,getagemonth(p.birth,'2017-01-01')AS age
,IF((p.birth BETWEEN '2013-06-01'AND'2013-07-01'),CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2014-06-01'AND '2014-07-01',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2015-06-01'AND '2015-07-01',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2016-03-01'AND '2016-03-31',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '9' MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '9' MONTH),INTERVAL '30' DAY))),''))))AS interSc FROM 
person p INNER JOIN house h ON p.hcode = h.hcode INNER JOIN ctitle ct 
ON p.prename=ct.titlecode INNER JOIN visit vt ON p.pcucodeperson=vt.pcucodeperson 
AND p.pid=vt.pid WHERE p.typelive IN ('1','3') 
AND((p.birth BETWEEN '2013-06-01'AND'2013-07-01')OR (p.birth BETWEEN '2014-06-01'AND '2014-07-01')
OR (p.birth BETWEEN '2015-06-01'AND '2015-07-01')OR (p.birth BETWEEN '2016-03-01'AND '2016-03-31'))
GROUP BY vt.pid ORDER BY p.pid,p.birth) AS s LEFT JOIN (SELECT
f43pp.pcucodeperson pcucode,f43pp.pid,IF(f43pp.dateserv IS null,'',f43pp.dateserv)AS dateserv,
getagemonth(p.birth,f43pp.dateserv) AS ageScreen,IF(f43pp.ppspecial IS NULL,'',GROUP_CONCAT(f43pp.ppspecial))AS codePP
FROM f43specialpp AS f43pp INNER JOIN person AS p ON f43pp.pid = p.pid 
AND f43pp.pcucodeperson = p.pcucodeperson WHERE f43pp.dateserv 
BETWEEN '2016-12-01' AND '2017-01-31' AND p.typelive IN ('1','3') AND f43pp.ppspecial LIKE '1B2%'
AND((p.birth BETWEEN '2013-06-01'AND'2013-07-01')OR
(p.birth BETWEEN '2014-06-01'AND '2014-07-01')OR
(p.birth BETWEEN '2015-06-01'AND '2015-07-01')OR
(p.birth BETWEEN '2016-03-01'AND '2016-03-31'))
AND p.pid NOT IN (SELECT persondeath.pid FROM persondeath)
GROUP BY f43pp.pid ORDER BY f43pp.dateserv DESC) as t 
ON s.pid=t.pid );
.....................................................
5.scpt เดือน กุมภาพันธ์  2560  ตามนี้
........................................................

SELECT s.pcucode,s.pid,s.idcard,s.titlename 'คำนำหน้า',s.fname 'ชื่อ'
,s.lname 'สกุล',s.birth 'วดป.เกิด',s.age 'อายุปี',s.hno 'เลขที่',s.villcode 'หมู่ที่',
s.interSc 'ช่วงวันที่ที่ต้องคัดกรอง',t.dateserv 'วันที่คัดกรองครั้งแรก',t.codePP 'รหัสคัดกรอง'
FROM ((SELECT p.pcucodeperson AS pcucode ,p.pid ,p.idcard ,ct.titlename ,p.fname ,p.lname
,p.birth ,h.hno ,Right(h.villcode,2) AS villcode ,getagemonth(p.birth,'2017-02-01')AS age
,IF((p.birth BETWEEN '2013-07-01'AND'2013-08-01'),CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2014-07-01'AND '2014-08-01',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2015-07-01'AND '2015-08-01',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2016-04-01'AND '2016-04-30',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '9' MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '9' MONTH),INTERVAL '30' DAY))),''))))AS interSc FROM 
person p INNER JOIN house h ON p.hcode = h.hcode INNER JOIN ctitle ct ON p.prename=ct.titlecode INNER JOIN visit vt ON p.pcucodeperson=vt.pcucodeperson AND p.pid=vt.pid WHERE p.typelive IN ('1','3') 
AND((p.birth BETWEEN '2013-07-01'AND'2013-08-01')OR (p.birth BETWEEN '2014-07-01'AND '2014-08-01')
OR (p.birth BETWEEN '2015-07-01'AND '2015-08-01')OR (p.birth BETWEEN '2016-04-01'AND '2016-04-30'))
GROUP BY vt.pid ORDER BY p.pid,p.birth) AS s LEFT JOIN (SELECT
f43pp.pcucodeperson pcucode,f43pp.pid,IF(f43pp.dateserv IS null,'',f43pp.dateserv)AS dateserv,
getagemonth(p.birth,f43pp.dateserv) AS ageScreen,IF(f43pp.ppspecial IS NULL,'',GROUP_CONCAT(f43pp.ppspecial))AS codePP
FROM f43specialpp AS f43pp INNER JOIN person AS p ON f43pp.pid = p.pid 
AND f43pp.pcucodeperson = p.pcucodeperson WHERE f43pp.dateserv 
BETWEEN '2017-01-01' AND '2017-02-28' AND p.typelive IN ('1','3') AND f43pp.ppspecial LIKE '1B2%'
AND((p.birth BETWEEN '2013-07-01'AND'2013-08-01')OR
(p.birth BETWEEN '2014-07-01'AND '2014-08-01')OR
(p.birth BETWEEN '2015-07-01'AND '2015-08-01')OR
(p.birth BETWEEN '2016-04-01'AND '2016-04-30'))
AND p.pid NOT IN (SELECT persondeath.pid FROM persondeath)
GROUP BY f43pp.pid ORDER BY f43pp.dateserv DESC) as t 
ON s.pid=t.pid );
........................................................

ุ6.scpt เดือน มีนาคม  2560  ตามนี้
........................................................

SELECT s.pcucode,s.pid,s.idcard,s.titlename 'คำนำหน้า',s.fname 'ชื่อ'
,s.lname 'สกุล',s.birth 'วดป.เกิด',s.age 'อายุปี',s.hno 'เลขที่',s.villcode 'หมู่ที่',
s.interSc 'ช่วงวันที่ที่ต้องคัดกรอง',t.dateserv 'วันที่คัดกรองครั้งแรก',t.codePP 'รหัสคัดกรอง'
FROM ((SELECT p.pcucodeperson AS pcucode ,p.pid ,p.idcard ,ct.titlename ,p.fname ,p.lname
,p.birth ,h.hno ,Right(h.villcode,2) AS villcode ,getagemonth(p.birth,'2017-03-01')AS age
,IF((p.birth BETWEEN '2013-08-01'AND'2013-09-01'),CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '3 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2014-08-01'AND '2014-09-01',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '2 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2015-08-01'AND '2015-09-01',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '1 6' YEAR_MONTH),INTERVAL '30' DAY))),
IF(p.birth BETWEEN '2016-05-01'AND '2016-05-31',CONCAT_WS('-',(DATE_ADD(p.birth,INTERVAL '9' MONTH)),
(DATE_ADD(DATE_ADD(p.birth,INTERVAL '9' MONTH),INTERVAL '30' DAY))),''))))AS interSc FROM 
person p INNER JOIN house h ON p.hcode = h.hcode INNER JOIN ctitle ct ON p.prename=ct.titlecode INNER JOIN visit vt ON p.pcucodeperson=vt.pcucodeperson AND p.pid=vt.pid WHERE p.typelive IN ('1','3') 
AND((p.birth BETWEEN '2013-08-01'AND'2013-09-01')OR (p.birth BETWEEN '2014-08-01'AND '2014-09-01')
OR (p.birth BETWEEN '2015-08-01'AND '2015-09-01')OR (p.birth BETWEEN '2016-05-01'AND '2016-05-31'))
GROUP BY vt.pid ORDER BY p.pid,p.birth) AS s LEFT JOIN (SELECT
f43pp.pcucodeperson pcucode,f43pp.pid,IF(f43pp.dateserv IS null,'',f43pp.dateserv)AS dateserv,
getagemonth(p.birth,f43pp.dateserv) AS ageScreen,IF(f43pp.ppspecial IS NULL,'',GROUP_CONCAT(f43pp.ppspecial))AS codePP
FROM f43specialpp AS f43pp INNER JOIN person AS p ON f43pp.pid = p.pid 
AND f43pp.pcucodeperson = p.pcucodeperson WHERE f43pp.dateserv 
BETWEEN '2017-02-01' AND '2017-03-31' AND p.typelive IN ('1','3') AND f43pp.ppspecial LIKE '1B2%'
AND((p.birth BETWEEN '2013-08-01'AND'2013-09-01')OR
(p.birth BETWEEN '2014-08-01'AND '2014-09-01')OR
(p.birth BETWEEN '2015-08-01'AND '2015-09-01')OR
(p.birth BETWEEN '2016-05-01'AND '2016-05-31'))
AND p.pid NOT IN (SELECT persondeath.pid FROM persondeath)
GROUP BY f43pp.pid ORDER BY f43pp.dateserv DESC) as t 
ON s.pid=t.pid );
.......................................................



ไม่มีความคิดเห็น:

https://www.blogs

 kllgnsgkj[jtlm'oahd bfldkb'pdojgaojp mfigjdo;sjgaij misjgo;sjagijwo;