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