File indexing completed on 2025-08-03 08:15:33
0001 SELECT runnumber
0002 FROM filelist
0003 WHERE filename LIKE '%dryrun/dryrun_intt%'
0004 AND filename LIKE '%.evt'
0005 GROUP BY runnumber
0006 HAVING
0007 COUNT(DISTINCT CASE WHEN filename LIKE '%0000.evt' THEN SUBSTRING(filename FROM 'dryrun_intt(\d+)') END) = 8
0008 AND
0009 COUNT(*) = SUM(CASE WHEN transferred_to_sdcc THEN 1 ELSE 0 END)
0010 ORDER BY runnumber;
0011
0012 SELECT COUNT(*) AS total_good_runs FROM (
0013 SELECT runnumber
0014 FROM filelist
0015 WHERE filename LIKE '%dryrun/dryrun_intt%'
0016 AND filename LIKE '%.evt'
0017 GROUP BY runnumber
0018 HAVING
0019 COUNT(DISTINCT CASE WHEN filename LIKE '%0000.evt' THEN SUBSTRING(filename FROM 'dryrun_intt(\d+)') END) = 8
0020 AND COUNT(*) = SUM(CASE WHEN transferred_to_sdcc THEN 1 ELSE 0 END)
0021 ) AS good_runs;
0022
