What hands does a player take to showdown?

Loyal Poker Copilot customer Regan asks,

Is there a way in Poker Copilot’s SQL database console to search for a player’s showdown hands?

Here’s the answer. This returns all hands I (‘stevoski111’) took to showdown in the last 10 days in ring games:

select  playerid, playername, handtype
from gameplayersummary
where starttime>sysdate-10 -- returns data for last 10 days
and isplaymoney=false
and istournament=false
and wenttoshowdown=true
and playername = 'stevoski111'