SQL query that extracts your watched episodes from the mediatomb db

mediatomb.sql

SELECT
  (SELECT location 
	 FROM mt_cds_object 
	 WHERE id = m.ref_id)  as episode_path
FROM mt_cds_object m 
WHERE ref_id is not null 
	AND episode_path LIKE "%/pi/Queue/%" 
	AND flags != 1 
ORDER BY episode_path;