Find past executed queries by text in MSSQL

ExecutedQueries.sql

SELECT 
	t.[text], qs.creation_time 
FROM sys.dm_exec_cached_plans AS p 
CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t 
JOIN sys.dm_exec_query_stats qs ON p.plan_handle = qs.plan_handle 
-- WHERE t.[text] LIKE N'%something unique about your query%';
WHERE t.[text] LIKE N'%CTE%' 
-- AND t.text LIKE '%APP-APERTUR%' 
ORDER BY qs.creation_time DESC