What experiment plan a player belongs to, and which trial list s/he is assigned to?
select * from PlayerInfo p where p.playerId='Aria07'; +-----+-----------------+---------------------+---------+----------+-------------------+-------------+----------------+----------------+ | id | currentSeriesNo | date | inBonus | playerId | totalRewardEarned | trialListId | experimentPlan | completionCode | +-----+-----------------+---------------------+---------+----------+-------------------+-------------+----------------+----------------+ | 147 | 0 | 2020-10-12 20:17:42 | | Aria07 | 35 | trial_2 | default | NULL | +-----+-----------------+---------------------+---------+----------+-------------------+-------------+----------------+----------------+ 1 row in set (0.00 sec)
What episodes has this player played so far?