You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
21 lines
895 B
21 lines
895 B
/* During cleanup or testing, it occasionally happens that we get multiple |
|
entries corresponding to the same log. The following query provides a |
|
convenient way to look at them, for manual cleanup. */ |
|
|
|
-- How often was that log found in total? |
|
select howoften, |
|
-- How many rows correspond to that setup_id? |
|
(select count(*) from rawdata where rawdata.setup_id = setup.setup_id) howmany, |
|
-- General info |
|
setup_id, logging_start_time, distance, duration, upload_time |
|
from setup |
|
-- Subtable to count how many times each logging start time occurs |
|
join (select count(*) howoften, logging_start_time starttime |
|
from setup |
|
group by logging_start_time |
|
-- Logs occuring only once aren't interesting to us here |
|
having count(*) > 1 |
|
) overlogged |
|
on logging_start_time = starttime |
|
-- To make it visually easier to compare the ones belonging together |
|
order by logging_start_time;
|
|
|