SELECT *
FROM logging
WHERE log_type = "patrol"
AND log_actor IN (SELECT... |
8 months ago |
SELECT *
FROM logging
WHERE log_type = "patrol"
AND actor_id IN (SELECT... |
8 months ago |
SELECT actor_id
FROM actor
WHERE... |
8 months ago |
SELECT *
FROM logging
WHERE log_type = "patrol"
AND actor_id IN (SELECT... |
8 months ago |
WITH actor_ident AS (SELECT actor_id
FROM actor
... |
8 months ago |
SELECT *
FROM logging
JOIN actor ON actor_id = log_actor
WHERE log_type =... |
8 months ago |
SELECT *
FROM logging
WHERE log_type = "patrol"
LIMIT 100 |
8 months ago |