If you wish to find all of the orphaned run entities for a project then you can run the following query:


SELECT rn_test_id FROM <PROJECT>.run WHERE rn_test_id NOT IN (SELECT ts_test_id FROM <PROJECT>.test);