A query to list all uploaded media to a room in particular

query_media_from_room.sql

select 
       event_json.json::json->'content'->>'body' as filename,
       event_json.json::json->'content'->>'url' as url
from events 
left outer join event_json on 
    events.event_id=event_json.event_id
left outer join room_stats_state on 
    room_stats_state.room_id=events.room_id
where event_json.json::json->'content'->>'url'<>'' and events.room_id='ROOM ID' limit 1000;