:PARAMETERS SER:='1';
select ORIGREC,SIGNATURE,USERNAME,POSITION,POHONENUMBER,LANGUAGE,EMAIL,CLIENTID,STATE,OFFICE_USER
from X_USERINFORMATION
join X_USER on X_USERINFORMATION.OFFICE_USER = X_USER.OFFICE
where X_USERINFORMATION.CLIENTID = @SER and
X_USERINFORMATION.ORIGREC > 0
select ORIGREC,SIGNATURE,USERNAME,POSITION,POHONENUMBER,LANGUAGE,EMAIL,CLIENTID,STATE,OFFICE_USER
from X_USERINFORMATION
join X_USER on X_USERINFORMATION.OFFICE_USER = X_USER.OFFICE
where X_USERINFORMATION.CLIENTID = @SER and
X_USERINFORMATION.ORIGREC > 0