Sql Query Help
Can you please help me change this query? I want to get rid of the queuedefinition.queuename='Terminations' and replace it with subject contains "Request".
select b.workorderid, ataskid,btaskid from (select workorderid ,count(taskid) ataskid from workordertotaskdetails group by workorderid) a
inner join
(select workordertotaskdetails.workorderid, count(workordertotaskdetails.taskid) btaskid from workordertotaskdetails inner join taskdetails on taskdetails.taskid=workordertotaskdetails.taskid where taskdetails.statusid=3 group by workordertotaskdetails.workorderid ) b on a.workorderid=b.workorderid
inner join workorderstates on b.workorderid=workorderstates.workorderid
inner join statusdefinition on workorderstates.statusid=statusdefinition.statusid
inner join workorder_queue on b.workorderid=workorder_queue.workorderid
inner join queuedefinition on workorder_queue.queueid=queuedefinition.queueid
where ataskid=btaskid and statusdefinition.statusname='open' and queuedefinition.queuename='Terminations'
select b.workorderid, ataskid,btaskid from (select workorderid ,count(taskid) ataskid from workordertotaskdetails group by workorderid) a
inner join
(select workordertotaskdetails.workorderid, count(workordertotaskdetails.taskid) btaskid from workordertotaskdetails inner join taskdetails on taskdetails.taskid=workordertotaskdetails.taskid where taskdetails.statusid=3 group by workordertotaskdetails.workorderid ) b on a.workorderid=b.workorderid
inner join workorderstates on b.workorderid=workorderstates.workorderid
inner join statusdefinition on workorderstates.statusid=statusdefinition.statusid
inner join workorder_queue on b.workorderid=workorder_queue.workorderid
inner join queuedefinition on workorder_queue.queueid=queuedefinition.queueid
where ataskid=btaskid and statusdefinition.statusname='open' and queuedefinition.queuename='Terminations'