Excluded some rubbish.
SELECT [Time], [Query] FROM
(SELECT deqs.last_execution_time AS [Time], dest.text AS [Query]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest) a
WHERE [Query] NOT LIKE '%execution_count%'
AND [Query] NOT LIKE '%last_execution%'
AND [Query] NOT LIKE '%firewall_rules_table%'
AND [Query] NOT LIKE '%XmlDocumentConstrain%'
AND [Query] NOT LIKE '%smudf.definition%'
AND [Query] NOT LIKE '%tbl.schema_id%'
AND [Query] NOT LIKE '%sys.schemas%'
AND [Query] NOT LIKE '%select xp.name, cast%'
AND [Query] != 'SELECT * FROM sys.dm_exec_query_stats'
ORDER BY [Time] DESC