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.
22 lines
895 B
22 lines
895 B
2 years ago
|
/* 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;
|