select count(*), log_type from logging
where
log_type in ("move",... |
3 months ago |
select count(*) from logging
where
log_type in ("move", "patrol")
and... |
3 months ago |
select count(*) from logging
where
log_type in ("move", "patrol")
and... |
3 months ago |
select * from logging
where
log_type in ("move", "patrol")
and log_timestamp... |
3 months ago |
select * from logging
where
-- log_type = "move"
log_type in ("patrol")
and... |
3 months ago |
select * from logging
where
-- log_type = "move"
log_type = "patrol"
and... |
3 months ago |
select * from logging
where
log_type = "move"
or log_type = "patrol"
and... |
3 months ago |
select * from logging
where
log_type = "move"
or log_type = "patrol"
and... |
3 months ago |
select * from logging
where
log_type = "move"
and log_timestamp >=... |
3 months ago |
select * from logging
where
-- log_type = "move"
log_timestamp >... |
3 months ago |
select * from logging
where
log_type = "move"
and log_timestamp >... |
3 months ago |
select * from logging
where
log_timestamp < 20240720000000
limit 1; |
3 months ago |
select * from logging
where
log_timestamp > 20240720000000
limit 1; |
3 months ago |
select * from logging
where
log_timestamp > 20240720000000
and log_timestamp... |
3 months ago |
select * from logging limit 1; |
3 months ago |
select * from log limit 1; |
3 months ago |
select * from logs limit 1; |
3 months ago |