How to find search history and associated tag history for a given tag?

Problem

I suspect that some search from the search history was deleted. Is there a way we can find search history for a given tag?

Resolution

The following query will provide the tag history and associated search history if available for the documents that were tagged as the given tag.

select tl.*, sh.*
from tbl_ex_tag TAG
inner join tbl_Ex_TagActionLog TL on TAG.TagID =TL.TagID
inner join tbl_pj_userinfo UI on UI.UserID = TL.TagOrUntaggedBy
left join tbl_ex_searchlog sh on sh.SearchID = tl.SearchID
where TAG.TagName = 'TAG_NAME' --Please replace with the desired tag name. For example 'Responsive'