@j @shitpisscum @lanodan @hj select split_part(upload->>'href','/', 5) from (select jsonb_array_elements(data->'url') as upload from objects where data->>'actor' = (select ap_id from users where nickname = 'CHANGEME')) where upload->>'type' = 'Link';