The merged ticket problem

Had a technician email come to me asking 'why can't i find this ticket - I know I emailed this person'?

After hours of searching it was due to the ticket being merged.

We need a better way to find all the merged tickets - a grid or something similar to the tasks grid? Something better than a two column report.

I know there is this report below but it only shows parent and merged request, no created date (ordered by most recent) no hyper link to the request, no subject, requester, date merged, created date, etc. I have over 12,000 merged requests so looking through a two column unordered report is useless when trying find a 'missing' merged request. It gives me no real way to find a 'missing' merged request. The request should also have a big 'MERGED WITH REQUEST ##' logo/image after its is merged on the ticket itself (not only in the history).

select Workorderid "Parent Request" , (SELECT STUFF((SELECT cast(Child_woid as varchar) + char(10) FROM conversation co where conversation.Workorderid=co.Workorderid FOR XML PATH ('')), 1, 0, '')) "Merged Request" from conversation where Child_woid is not NULL group by Workorderid