Queries that are recently Run

SELECT deqs.last_execution_time AS LastRun, dest.TEXT AS QueryText, *
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE LEFT(dest.TEXT,8)='SELECT *'
ORDER BY LastRun DESC