wonderful-baker-81666
04/18/2023, 10:24 AM| SELECT *
FROM (
SELECT (
SELECT MAX(rkv.id) AS id
FROM kine AS rkv), (
SELECT MAX(crkv.prev_revision) AS prev_revision
FROM kine AS crkv
WHERE crkv.name = 'compact_rev_key'), kv.id AS theid, kv.name, kv.created, kv.deleted, kv.create_revision, kv.prev_revision, kv.lease, kv.value, kv.old_value
FROM kine AS kv
JOIN (
SELECT MAX(mkv.id) AS id
FROM kine AS mkv
WHERE
mkv.name LIKE '/registry/leases/kube-system/k3s-cloud-controller-manager'
GROUP BY mkv.name) AS maxkv
ON maxkv.id = kv.id
WHERE
kv.deleted = 0 OR
0
) AS lkv
ORDER BY lkv.theid ASC
creamy-pencil-82913
04/18/2023, 5:02 PMwonderful-baker-81666
04/19/2023, 1:29 PMcreamy-pencil-82913
04/19/2023, 2:24 PM