select ccode, pcode, year, month, dataval from dotm
where ccode in (111,112,132,134,136,138,142,144,146,156,158,172,184,
122,174,178,182,128,
213,193,223,534,273,293,199,542,578,186,228,196,564) and 
pcode in (111,112,132,134,136,138,142,144,146,156,158,172,184,
122,174,178,182,128,
213,193,223,534,273,293,199,542,578,186,228,196,564)
and year between 1980 and 2010 and ncode=1 order by 1,2,3,4 ;
