Reopened Calls Report

Hello,

i'm looking to report on reopened calls, is there a query available for this please?
If possible looking to report on following information:

Ticket Ref
Date Created
Date Closed
Closed By
Closing Category
Date Reopened
Reopened By
Reopen Count?

Many thanks
Lisa