${if(TYPE=="write","select distinct PERSON_INDEX from MFG_PERSON_JOBTYPE 
WHERE 1=1","select distinct personno from MFG_PERSON_CLASSID WHERE 1=1 ")}

${if(len(CLASSID) == 0,"","and CLASSID = '" +CLASSID + "'")}

${if(len(CATEGORYID) == 0,"","and CATEGORYID = '" +CATEGORYID + "'")}


${if(len(WORKDATE) == 0,"","and WORKDATE = '" +WORKDATE + "'")}

${if(TYPE=="write","order by PERSON_INDEX","order by PERSONno")}