remus

Badges

OG100 Contributions1,000 Contributions10,000 Contributions100,000 Contributions10 Posts100 Posts

Contributions

Posts

1 Day

172

7 Days

2012

4 Weeks

6318

All Time

166668

Current Streak

58

Longest Streak

181

Top Contributions

Name Type # Changes Last Updated First Updated
1 https://www.youtube.com/watch?v=kpbCmJGkKHE media 108 14th July 2024 14th July 2024
2 https://www.instagram.com/p/DF5XgLjMdJu/ media 74 21st February 2026 10th February 2025
3 https://www.instagram.com/p/DSTP2Z8ANtI/ media 72 1st April 2026 16th December 2025
4 Hard Rock list 67 19th August 2025 27th July 2024
5 https://www.instagram.com/p/DGD2HHVM4yn/ media 65 21st February 2026 14th February 2025
6 Remus Knowles climber 56 8th April 2026 30th March 2024
7 https://www.instagram.com/p/DVi7bJmjNhO/ media 55 16th March 2026 6th March 2026
8 Will Stanhope climber 51 6th May 2026 24th January 2021
9 https://open.spotify.com/episode/0cHKL3jWvp8A4QcZ1LS0YM media 51 6th October 2024 10th April 2024
10 https://www.instagram.com/p/BcX-gR8llwj/ media 48 23rd January 2026 24th January 2024

Recent Contributions

Date Time User Type Name Attribute
1 18th May 2026 21:32:55 UTC remus list Podcast Library Progress list_definition
Before
None
After
with podcast_stats as ( select pf.podcast_name ,case when lim.library_item_meta_id is not null then 1 else 0 end as in_library ,case when p.last_download_error is not null and lim.library_item_meta_id is null then 1 else 0 end as errored ,case when li.transcription is not null then 1 else 0 end as transcribed ,case when dur.library_item_meta_id is not null then 1 else 0 end as has_audio_meta from podcasts p inner join podcast_feeds pf on p.podcast_feed_id = pf.podcast_feed_id left join library_item_meta lim on lim.library_item_meta_key_id = 22 and lim.value::int = p.podcast_id left join library_items li on li.library_item_id = lim.library_item_id and li.deleted_on is null left join library_item_meta dur on dur.library_item_id = li.library_item_id and dur.library_item_meta_key_id = 30 ) ,agg as ( select podcast_name ,0 as sort_order ,count(*) as total ,sum(in_library) as in_library ,sum(errored) as errored ,count(*) - sum(in_library) - sum(errored) as remaining ,sum(transcribed) as transcribed ,sum(has_audio_meta) as has_audio_meta from podcast_stats group by podcast_name union all select 'All Podcasts' ,1 ,count(*) ,sum(in_library) ,sum(errored) ,count(*) - sum(in_library) - sum(errored) ,sum(transcribed) ,sum(has_audio_meta) from podcast_stats ) select podcast_name as "Podcast" ,total as "Total" ,in_library || ' (' || round(in_library * 100.0 / nullif(total, 0), 1) || '%)' as "In Library" ,errored || ' (' || round(errored * 100.0 / nullif(total, 0), 1) || '%)' as "Errored" ,remaining || ' (' || round(remaining * 100.0 / nullif(total, 0), 1) || '%)' as "Remaining" ,coalesce(transcribed || ' (' || round(transcribed * 100.0 / nullif(in_library, 0), 1) || '%)', '0') as "Transcribed" ,coalesce(has_audio_meta || ' (' || round(has_audio_meta * 100.0 / nullif(in_library, 0), 1) || '%)', '0') as "Audio Meta" from agg order by sort_order ,total desc
Diff
--- before

+++ after

@@ -1 +1,70 @@

+with podcast_stats as (
+ select
+ pf.podcast_name
+ ,case when lim.library_item_meta_id is not null then 1 else 0 end as in_library
+ ,case when p.last_download_error is not null and lim.library_item_meta_id is null then 1 else 0 end as errored
+ ,case when li.transcription is not null then 1 else 0 end as transcribed
+ ,case when dur.library_item_meta_id is not null then 1 else 0 end as has_audio_meta

+ from
+ podcasts p
+ inner join podcast_feeds pf
+ on p.podcast_feed_id = pf.podcast_feed_id
+ left join library_item_meta lim
+ on lim.library_item_meta_key_id = 22
+ and lim.value::int = p.podcast_id
+ left join library_items li
+ on li.library_item_id = lim.library_item_id
+ and li.deleted_on is null
+ left join library_item_meta dur
+ on dur.library_item_id = li.library_item_id
+ and dur.library_item_meta_key_id = 30
+)
+,agg as (
+ select
+ podcast_name
+ ,0 as sort_order
+ ,count(*) as total
+ ,sum(in_library) as in_library
+ ,sum(errored) as errored
+ ,count(*) - sum(in_library) - sum(errored) as remaining
+ ,sum(transcribed) as transcribed
+ ,sum(has_audio_meta) as has_audio_meta
+
+ from
+ podcast_stats
+
+ group by
+ podcast_name
+
+ union all
+
+ select
+ 'All Podcasts'
+ ,1
+ ,count(*)
+ ,sum(in_library)
+ ,sum(errored)
+ ,count(*) - sum(in_library) - sum(errored)
+ ,sum(transcribed)
+ ,sum(has_audio_meta)
+
+ from
+ podcast_stats
+)
+
+select
+ podcast_name as "Podcast"
+ ,total as "Total"
+ ,in_library || ' (' || round(in_library * 100.0 / nullif(total, 0), 1) || '%)' as "In Library"
+ ,errored || ' (' || round(errored * 100.0 / nullif(total, 0), 1) || '%)' as "Errored"
+ ,remaining || ' (' || round(remaining * 100.0 / nullif(total, 0), 1) || '%)' as "Remaining"
+ ,coalesce(transcribed || ' (' || round(transcribed * 100.0 / nullif(in_library, 0), 1) || '%)', '0') as "Transcribed"
+ ,coalesce(has_audio_meta || ' (' || round(has_audio_meta * 100.0 / nullif(in_library, 0), 1) || '%)', '0') as "Audio Meta"
+
+from
+ agg
+
+order by
+ sort_order
+ ,total desc
2 18th May 2026 21:32:55 UTC remus list Podcast Library Progress list_type_id
Before
None
After
6
3 18th May 2026 21:32:55 UTC remus list Podcast Library Progress list_name
Before
None
After
Podcast Library Progress
4 18th May 2026 21:32:55 UTC remus list Podcast Library Progress list_description
Before
None
After
Progress tracking for converting podcast episodes into library items, transcribing them and extracting audio meta. Per-feed breakdown with an 'All Podcasts' total row. Errored = episodes whose last download attempt failed; Transcribed/Audio Meta percentages are relative to episodes already in the library.
Diff
--- before

+++ after

@@ -1 +1 @@

-
+Progress tracking for converting podcast episodes into library items, transcribing them and extracting audio meta. Per-feed breakdown with an 'All Podcasts' total row. Errored = episodes whose last download attempt failed; Transcribed/Audio Meta percentages are relative to episodes already in the library.
5 18th May 2026 21:32:55 UTC remus list Podcast Library Progress list_type_name
Before
None
After
Admin
6 18th May 2026 19:20:16 UTC remus ascent Andrea Chelleris's ascent of Mandanga Total ascent_dt_end
Before
None
After
2024-11-04
7 18th May 2026 19:20:16 UTC remus ascent Andrea Chelleris's ascent of Mandanga Total climb_id
Before
None
After
7730
8 18th May 2026 19:20:16 UTC remus ascent Andrea Chelleris's ascent of Mandanga Total ascent_dt_start
Before
None
After
2024-11-04
9 18th May 2026 19:20:16 UTC remus ascent Andrea Chelleris's ascent of Mandanga Total ascent_style_id
Before
None
After
1
10 18th May 2026 19:20:16 UTC remus ascent Andrea Chelleris's ascent of Mandanga Total ascent_type_id
Before
None
After
1
11 18th May 2026 19:20:16 UTC remus ascent Andrea Chelleris's ascent of Mandanga Total climber_id
Before
None
After
2850
12 18th May 2026 19:19:26 UTC remus ascent Carlos Jimenez Munoz's ascent of Mandanga Total Ascent #
Before
None
After
1
13 18th May 2026 19:19:25 UTC remus ascent Carlos Jimenez Munoz's ascent of Mandanga Total ascent_dt_end
Before
None
After
2015-09-22
14 18th May 2026 19:19:25 UTC remus ascent Carlos Jimenez Munoz's ascent of Mandanga Total ascent_type_id
Before
None
After
1
15 18th May 2026 19:19:25 UTC remus ascent Carlos Jimenez Munoz's ascent of Mandanga Total ascent_dt_start
Before
None
After
2015-09-22
16 18th May 2026 19:19:25 UTC remus ascent Carlos Jimenez Munoz's ascent of Mandanga Total climb_id
Before
None
After
7730
17 18th May 2026 19:19:25 UTC remus ascent Carlos Jimenez Munoz's ascent of Mandanga Total ascent_style_id
Before
None
After
1
18 18th May 2026 19:19:25 UTC remus ascent Carlos Jimenez Munoz's ascent of Mandanga Total climber_id
Before
None
After
4061
19 18th May 2026 19:19:07 UTC remus climber Carlos Jimenez Munoz eight_a_nu_url
Before
None
After
https://www.8a.nu/user/carlos-jimenez-munoz
20 18th May 2026 19:19:00 UTC remus climber Carlos Jimenez Munoz country_flag
Before
None
After
🇪🇸

Page 1 >