Fediver

CREATE OR REPLACE FUNCTION public.timestamp_to_aid(t timestamptz) RETURNS text AS $$
DECLARE
    time_part text;
    num bigint;
BEGIN
	num := extract(epoch from t) * 1000 + mod(extract(millisecond from t),1000)::integer - 946684800000;
    time_part := '00';
    FOR i IN 1..8 LOOP
		time_part := substring('0123456789abcdefghijklmnopqrstuvwxyz', (1 + mod(num, 36))::integer, 1) || time_part;
		num := num / 36;
    END LOOP;
    RETURN time_part;
END;
$$ LANGUAGE plpgsql;

select n.* from "note" n
where
	not exists (select 1 from note reply where reply."replyId" = n.id)
	and not exists (select 1 from note renote where renote."renoteId" = n.id)
	and not exists (select 1 from note_favorite nf where nf."noteId" = n.id )
	and n."clippedCount" =0
	and id < timestamp_to_aid(current_date - 56)
order by id desc;

-----BEGIN PGP MESSAGE-----

hF4DEb0ZYSOJ9pESAQdAVsxizRy8BAyJpcLf3mRdaAL2IwwZgw82twlG1N3YhBIw
zGT8Gvq6AYOiEUnWewdGBQ/JWuLq8uMJQSG01N59Wv9apDsrylsrIm7bxJq4dPwh
1FQBCQIQTyvDL0Sg3diueG6uZySBnQAi/VglRhCSjahTNd9K79oV7VRVJFYNYAEj
zBl6t3GUGPnJeD19ibxPV8bTErMrubwnG/JtKXcIx5mc5wgTwfM=
=XBb3
-----END PGP MESSAGE-----

BEGIN KEYBASE SALTPACK SIGNED MESSAGE.
kXR7VktZdyH7rvq v5weRa0zkPZQnc6 0CKhkaUcy2eIGv2
W3EgzeLuxh0JtdV NnZhX30gmrAxblh RGS6CSH9VVBRqek
E7pqPevJnkF6EEP Ymakwls9troqOYi Kp0Ak1MtaiwLvLy
uXMbEvLveaI9rBX a5UGdOAWG2dcEH8 XaKlOcWNFNgzowi
PAAtGFnlV6TG9u5 PogUXgDnWPxb80C jW3s3NzZrlyAo3B
KPzxxcirCSvRsEF bbAnHXsXpCH6oqJ I6SMZdieIP8q3lN
51rFCiREoirC02F KpKck2Ib9d49Otu aBKvVqVLG120fmb MBNC2.
END KEYBASE SALTPACK SIGNED MESSAGE.

I took the driver license examination :-)
The announcement of results is to begin at 14:45.
I hope that I pass it🔥🔥🔥