Most referenced threads and posts

[LoyceV]

I like your list much batter than Loyce's, who claimed I wasn't even in the top 100.  

Interesting, I found these results:

"<a href="https://bitcointalk.org/index.php?topic=577765" occurs 275 times
"<a href="https://bitcointalk.org/index.php?topic=577765.msg6311902#msg6311902" occurs 168 times

Even though I didn't include the most recent posts, and "only" searched the first 53M posts. the difference shouldn't be so large.
I'll run a new search for just "https://bitcointalk.org/index.php?topic=577765" and "https://bitcointalk.org/index.php?topic=577765.msg6311902#msg6311902" without "<a href=" (and without quotes).

To be continued......

[1714864981]

1714864981

[1714864981]

1714864981

[1714864981]

1714864981

[suchmoon]

It looks like perhaps I should exclude the bounty board... links there are likely to be some sort of spam, e.g. a campaign asking to post in their main thread and post proof. That's against the rules but it may have happened with a few of those threads with weirdly high scores. Plus the Arabic translation threads.

Aside from that, I don't want to start excluding individual posts/threads as that's prone to bias. If there are ~20 or so "undeserving" posts in the top 100 that's not a big deal. Perhaps it can help someone to improve their mod report stats

I can try to run a similar list for a certain timeframe, e.g. last month or last 12 months if there is interest.

Same user. I didn't expect another of his thread. Well, he himself is the referrer of all these three threads.

I'll double-check this. It shouldn't have happened - user's own posts should not count.

[Vod]

<a href="https://bitcointalk.org/index.php?topic=577765.msg6311902#msg6311902" occurs 168 times

[/quote]

The link is https://bitcointalk.org/index.php?topic=577765.msg6311902
The # is just an anchor.

[1miau]

I wonder if it's also possible to have a dedicated list for local boards like the German local board?

Don't worry, if it's too much work, just skip my comment, I don't want to make any trouble. 

[LoyceV]

The link is https://bitcointalk.org/index.php?topic=577765.msg6311902
The # is just an anchor.

I'll try one more time In the first 53M posts, I found:

• https://bitcointalk.org/index.php?topic=577765 3825 times
• https://bitcointalk.org/index.php?topic=577765.msg6311902#msg6311902 1445 times
• https://bitcointalk.org/index.php?topic=577765.msg6311902 1445 times

This no doubt includes double counting.

[suchmoon]

This no doubt includes double counting.

This looks about right. Try searching for {space}href="{url}" or <a{space}class="ul"{space}href="{url}" and include all three variations of the URL (thread, thread with .0, and post).

[LoyceV]

This looks about right. Try searching for {space}href="{url}" or <a{space}class="ul"{space}href="{url}" and include all three variations of the URL (thread, thread with .0, and post).

I've given up on this, AWS ran out of CPU credits already

[suchmoon]

Attempt #3. I have fixed a bug and updated the list in the OP accordingly. In some cases I was incorrectly identifying the first post in the thread and consequently not eliminating user's own references. This fix reduced the spammy threads a little bit.

There are still some oddities, for example:

https://bitcointalk.org/index.php?topic=1715457.msg17196904#msg17196904

BADecker links to his own posts(s). Someone quotes him. Now BADecker's links count as "referenced" because technically someone else posted them. I could try eliminating links inside quotes and perhaps nested quotes but that might be unfair. If I post a link and someone reposts it by quoting me it's looks like a new independent reference that other users could potentially click on etc.

Also it'd be a lot of work but I can't admit that, can I.

[suchmoon]

I wonder if it's also possible to have a dedicated list for local boards like the German local board?

Don't worry, if it's too much work, just skip my comment, I don't want to make any trouble. 

I'm sorry it took a while but here is the list for German board. The following board IDs are included - let me know if I missed anything: 16, 35, 36, 60, 61, 62, 63, 64, 139, 140, 141, 152, 269, 270. All links are counted, i.e. if a German thread is referenced from a non-German post it will be included in the count.

#   count post     
--- ----- -----------
  1   172 Bitcoin & die Steuer - FAQ  
  2   109 Sicheres Adressverzeichnis   
  3    85 .   
  4    61 Der Aktuelle Kursverlauf
  5    61 welche bountys signaturen lohnen sich am meisten??? 
  6    55 Übersetzungs-Spam gefunden? Hier könnt ihr ihn berichten  
  7    55  [Launched] [XMG] Magi   1st POS-II   Fair Distr   Tor   M7M CPU 
  8    52 IOTA - Erste blockchainlose Kryptowährung designed für das Internet der Dinge     
  9    50 [GB] USB ASIC miner - closed and completed     
 10    49 [ANN][BOUNTY][AIRDROP] Merit Sugar Daddy
 11    46 Hot Coins  
 12    44 Inoffizielle Bitcointalk.org Regeln/Richtlinien/FAQ  
 13    42 [Neue Auswertungen] Wir deutschsprachigen und die Merits ...    
 14    42 Transaktion hängt fest? Was tun wenns klemmt. 
 15    42 Wette 600Watt/elrippo BTC ATH 2017 €4000
 16    41 An alle: Vorsicht Blase - Eine kleine Erinnerung an die Realität
 17    39 [ANN] [AIRDROP] [CROWDSALE LIVE!] [BOUNTY]FAITHCOIN- Faith Powered ERC20 Token    
 18    39 [ANN]PECULIUM - Erste Krypto-Spareinlagen Plattform basierend auf KI  
 19    38 ✅ [ANN] DeepOnion ONION 🌍 Private Digitale Währung 🌍 DeepVault App Released ✅   
 20    36 CoinTracking - Gewinn/Verlust Portfolio und Steuer Reporting für digitale Coins    
 21    35 [PRE-ANN] WAVES. Ultimative Crypto-Token Blockchain Plattform.  
 22    32 de.CoinGate.com - Bitcoin Zahlungen akzeptieren. Kaufen / verfaufen von Bitcoins  
 23    31 Erstes richtiges BLUTBAD 2018 – Wo ist der Boden ?! 
 24    31 Altcoinspekulant.wordpress.com --> Deutscher Altcoin-Blog  
 25    30 Re: [Diskussion] DeepOnion TOR integrated Coin
 26    30 ⚡ [ANN] ⚡ DeepOnion TOR Integriert ⚡ Kein ICO 🚀 FREE Airdrops 🚀 Runde 3 von 40  
 27    29 Kraken Now Open for Germany  
 28    29 🌟🌟[ANN   Bounty]  DIGITIZECOIN - Mach Coins aus deinem Wechselgeld! 🌟🌟  
 29    28 «Envion» Höchste ROI-Krypto-Infrastruktur   $2M Bounty verfügbar!     
 30    28 [ANN][LISK] Lisk   ICO   Dezentrale Anwendungen & Sidechain Plattform 
 31    28 Avalon    UPDATE LESEN    Gemeinschaftsprojekt 255 Ghash   
 32    28 Bitcointalk-Guide: FAQ & Foren-Etikette - 01/2019   
 33    28 🚀[ANN][PoSToken]Erster Smart Contract Token mit Proof-of-Stake[Lending Platform] 
 34    27 [ANN][ICO] «Envion» Profitabelste selbstexpandierende Crypto-Infrastruktur  
 35    26 Steuerberater in Deutschland mit "Bitcoin-Kompetenz" (Liste)    
 36    26 BFL Sammelbestellung mit Hosting   
 37    25 Angebot: BTC (2-aus-3) Multisig Escrow (Treuhandabwicklung)
 38    24 Warum Anonymität bei Coins vielen so wichtig ist?   
 39    23 www.bitpanda.com - Offizieller deutscher BitPanda Support Thread
 40    22 [ANN][ICO][DAR] Darcrus   Blockchain Datenbank Startup - Enterprise, Everywhere   
 41    22 NON-GERMAN SPEAKERS : No Google Translate (or similar) Announcements allowed.
 42    22 [NAS] Mach mit beim grossen Giveaway - Gratis NAS für alle. Nimm teil!!
 43    22 [ANN][LYM]Lympo - Monetarisierung von Sport- und Gesundheitsdaten via Blockchain  
 44    22 15% Rabatt auf amazon.de Bestellungen bis 1.000 €   
 45    21 ★ ★ ★ ★ DigiByte [DGB] - Ein Berufs Cryptocurrency ✈ jetzt gestartet!! ✔     
 46    21 Antizyklisches Handeln 
 47    21 [ANN][ICO]Das erste dezentralisierte, selbstgelenkte Investment-Ökosystem   
 48    20 [ANN][PRESALE IS ON]⭐LIVE STARS 🚀 Revolutionierung der Erwachsenenunterhalt
 49    20 Aktuelle Airdrops     
 50    20 [ANN][ICO 19 JULI] AVENTUS - ANTI-BETRUG U. SCHWARZMARKT TICKETING AUF ETHEREUM   
 51    20 [PRE-ANN] WINGS - Wo DAO Einhörner geboren werden   
 52    20 [PRE-ANN]FOME - AUS ÜBERZEUGUNG POS - 90% AIRDROP - 10 RUNDEN- SEI BEREIT   
 53    20 [PRE-ANN][RISE] Rise   ICO am 10. Mai   TESTNET ist LIVE   RE   DAPPS 
 54    19 ------     
 55    19 Biete Treuhandservice an... 
 56    19 💠 DIW 💠 [ANN] [Pre-ICO] 💠 DIWtoken.com 💠 Dezentrale Sicherheit    
 57    19 [PRE-ANN] ICONOMI - Fund Management Platform  
 58    19 Re: 🔶🚀🔶【ANN】【ICO】📈FOX TRADING📈ERHALTE SIGNALE+TRADING POOL+AUTOTRADING 
 59    19 [ANN] PayPro startet den ersten wirklichen dezentralisierten Marktplatz     
 60    19 [ANN][pre-ICO NOW]CREDITS - Neue Blockchain für Finanz-Industrie[10 Nov-15 Dec]   
 61    19 Banana Node- Unterstütze das Netzwerk!   
 62    18 [Bitte MrDJ kontakiterien] 20% Rabatt auf amazon.de Bestellungen ab 1000€   
 63    18 Gruppenkauf Yesminer M10 / M20    
 64    18 [Gruppenkauf] Avalon ASIC Chips (SebastianJu) Batch 6 bestellt (geschlossen) 
 65    18 [SMC] SMARTCOIN • Block Belohnung von 64 auf 16 SMC ab Block 120.000!!!
 66    18 del 
 67    18 [ANN][SEM] Semux - Deutscher Thread     
 68    18 Die Default Trust wurde geändert !      
 69    18 [ANN] Obyte: komplett neuer Konsens-Algorithmus und private Zahlungen 
 70    17 Re: IOTA - Erste blockchainlose Kryptowährung 
 71    17 [ANN] [BLTZ] [IPO Hybrid] BlitzCoin   proof of concept coin   Pure Spekulation     
 72    17 Nun auch in Deutsch! Gewinnspiel: Wo steht BTC am Ende des 3. Quartals 2019?
 73    17 Re: Sicheres Adressverzeichnis     
 74    17 [DeM] Deutsche eMark (v1.4) - ein deutscher Cryptocoin     
 75    17 [ANN] Bowhead Health: Persönliche Gesundheits-Plattform   
 76    17 [ANN][ KICKICO ] OFFIZIELLER BOUNTY KAMPAGNEN THREAD
 77    17 GB 15x KNCminer Jupiter - 10 im Hosting aktiv - ROI erreicht     
 78    17 Steuer auf Altcoins - Kompakte Einschätzung?   
 79    16 [ANN][ICO] Minexcoin - Eine neue Ära des Bezahlens  
 80    16 Liste volkstümlicher Bitcoin Irrtümer - FAQ   
 81    16 Inhaltsverzeichnis / Linkliste zum Thema Steuern     
 82    16 UMFRAGE: Neues SUB Forum für die ganzen ANN/ICO/AIRDROP/PRE irgendwas ....  
 83    16 Hinweise/Regeln/Beschränkungen für neue User + Anmeldeformular(deutsch)
 84    16 Re: ◄🔵 [ANN] vreo.io   ICO   [BOUNTY >soon<] 🔵►   
 85    16 [ANN][MCC - ICO] [Ger]Eisbrecher der mobilen Gaming Industrie - ICO Aug 20  
 86    16 Infinity Economics Scam?    
 87    16 [ANN] [ICO] LOCI Thinking Better. Together.   
 88    16 Activity, Merit und Ranganforderungen im Forum
 89    16 [ANN]GPLAY-Dezentralisierter Gaming Marktplatz POS⚡ Kein ICO Kostenlose Airdrops  
 90    16 Die ewige Shitcoinliste     
 91    16 Offizieller Thread zu Yesminers und den Bitcoin-Minern M10 und M20   ProTact
 92    15 HOT COINS [Long Term]  
 93    15 [ANN] [KTK] Krypt Koin   100% PoS   Update 1.5.1.0 Released   Reddit Giveaway
 94    15 Re: Die Default Trust wurde geändert !  
 95    15 [ANN][MARKTPLATZ] WCX – Preiswerter Krypto Marktplatz von Apple & Wall St Team    
 96    15  [ANN][PRE-ICO][GIO] [GERMAN] GRAVIO Ökosystem- Alles ist verbunden.  
 97    15 [ANN] ⭐ Llitenett ⭐ - Das erste Netzwerk mit dezentralem Zahlungssystem ⭐   
 98    15 [ANN] Bitcore- BTX - SEGWIT - BLOOM - ONLINE - Virtueller Fork 1:0.5 vom  BTC     
 99    15 🔹🔹🔹[ANN][BSD] BitSend - Xevan - Segwit- Bittrex- Litebit.eu  
100    15 [ANN][ICO LIVE!] 💠 FORTY SEVEN BANK 💠 – Verbindet Finanzwelten

[mole0815]

Very nice list thank you
Had considered to bring the original version into the German subforum but since 1miau already asked for a special version he might want to do it?
In any case interesting to see which threads are the most important ones.

[suchmoon]

I added a "users" column to the OP. It shows the number of users who posted each link. This can give an additional insight as to which threads are more widely referenced as opposed to threads promoted by small groups of users.

[1miau]

I wonder if it's also possible to have a dedicated list for local boards like the German local board?

Don't worry, if it's too much work, just skip my comment, I don't want to make any trouble. 

I'm sorry it took a while but here is the list for German board.

No problem, much appreciated to have your list. It is already shared to our local German board: https://bitcointalk.org/index.php?topic=5214456.msg55367892#msg55367892

It's a bit surprising we have so many shitcoin ANNs included, I guess it happens most likely when shitposters quote the official, international ANN where translations to local ANNs are linked.