Jobs used SQL, right when shared to the SQL headache of silver

Select T.*, t.rowid from T_dept_type T Department
Select T.*, T.rowid from T_company t Company
Select T.*, t.rowid from T_employees t employees

Select
A.departmentid,
A.userid,
A.datecreated,
A.calltime
From Cbssys. Dailphone_callback A
Left join Cbssys. Dailphone_callauth b
On A.callsid=b.allcallsid
where a.compayid= ' 1 ' ORDER by a.datecreated DESC

Select
(select T.dept_type_name from T_dept_type t where T.dept_type_id=a.departmentid),
(select E.emp_name from T_employees e where E.emp_id=a.userid),
A.datecreated,
A.calltime
From Cbssys. Dailphone_callback A
Left join Cbssys. Dailphone_callauth b
On A.callsid=b.allcallsid
where a.compayid= ' 1 ' and a.userid= ' 1 ' ORDER by a.datecreated DESC

Select
(select T.dept_type_name from T_dept_type t where T.dept_type_id=a.departmentid),
(select E.emp_name from T_employees e where E.emp_id=a.userid),
A.datecreated,
A.calltime
From Cbssys. Dailphone_callback A
Left join Cbssys. Dailphone_callauth b
On A.callsid=b.allcallsid
where a.compayid= ' 1 '
and a.userid= ' 1 '
ORDER BY a.datecreated DESC
Select
(select T.dept_type_name from T_dept_type t where T.dept_type_id=a.departmentid) depart,
(select E.emp_name from T_employees e where E.emp_id=a.userid) Euser,
A.datecreated,
A.calltime
From Cbssys. Dailphone_callback A
Left join Cbssys. Dailphone_callauth b
On A.callsid=b.allcallsid
where a.compayid= ' 1 '
ORDER BY a.datecreated DESC

Callrecords Custell

#{userid,jdbctype=numeric}

Jobs used SQL, right when shared to the SQL headache of silver