Ranking based on Merit received by distinct users + stats requested by users.

[r1s2g3]

I saw lot of  user in this forum has  interest  in reading the merited post only but I do not think it is not a correct solution because this option is not available as well is it will break the coherency of the discussion.

Some people have suggestion to read the most merited post but I guess some of the ANN threads merited with 50 merits by a single user is skewing the statistics of both the thread and user.

I think instead of just looking in the Merits only data of a poster, we should combine it with the number of user that merited that poster to achieve that rank . Poster merited with by multiple user should be worthy of reading instead of somebody getting merits with multiple by few users.

So with the help of the Piggy Sql Tool, I created a list of posters who are atleast merited by 50 distinct users. Theymos is at top with 565 distinct user meriting Theymos. Overall only 166 postersexists in this list that are merited by 50 or more user of this forum.

Code:

Rank	UserName	count (distinct m.fromid)
1	theymos	565
2	LoyceV	232
3	Vod	201
4	explorder	192
5	Jet Cash	187
6	DdmrDdmr	158
7	The Pharmacist	156
8	hilariousetc	150
9	bill gator	147
10	suchmoon	147
11	yahoo62278	145
12	satoshi	144
13	Lutpin	141
14	TMAN	141
15	iasenko	136
16	ui_zakharchenko	133
17	nullius	132
18	TheQuin	131
19	bitmover	127
20	xtraelv	124
21	OgNasty	121
22	Last of the V8s	120
23	Lauda	117
24	gentlemand	115
25	o_e_l_e_o	115
26	DarkStar_	114
27	tvplus006	114
28	LeGaulois	113
29	Piggy	113
30	qwk	112
31	TryNinja	111
32	HCP	109
33	achow101	109
34	marlboroza	109
35	BTCforJoe	108
36	JayJuanGee	108
37	theyoungmillionaire	108
38	Smart man	104
39	coinlocket$	103
40	krogothmanhattan	103
41	Coolcryptovator	101
42	joniboini	99
43	kirreev070	98
44	mdayonliner	98
45	franky1	96
46	stompix	96
47	Hhampuz	95
48	micgoossens	94
49	pugman	94
50	QuestionAuthority	92
51	pooya87	92
52	HairyMaclairy	91
53	DannyHamilton	90
54	hilariousandco	90
55	sncc	89
56	xhomerx10	89
57	Ranyar	88
58	hugeblack	88
59	HeRetiK	87
60	zentdex	87
61	BobLawblaw	86
62	Torque	84
63	d5000	84
64	infofront	84
65	killyou72	84
66	actmyname	83
67	pandukelana2712	83
68	AlyattesLydia	82
69	Welsh	82
70	Carlton Banks	81
71	Silent26	81
72	athanz88	81
73	mocacinno	79
74	deeperx	78
75	jojo69	78
76	Elwar	77
77	SFR10	77
78	cellard	77
79	mfort312	77
80	mjglqw	77
81	bob123	76
82	buwaytress	76
83	1Referee	75
84	crypmike	75
85	vit05	75
86	Xynerise	74
87	Kakmakr	73
88	Mitchell	73
89	philipma1957	73
90	DooMAD	72
91	dbshck	72
92	Matthias9515	71
93	Steamtyme	71
94	Flying Hellfish	70
95	lemonrabid	69
96	ETFbitcoin	68
97	vlad230	68
98	EcuaMobi	67
99	Heisenberg_Hunter	67
100	AdolfinWolf	66
101	Samarkand	66
102	BitCryptex	65
103	GameKyuubi	65
104	TERA2	65
105	amishmanish	65
106	PHI1618	64
107	paxmao	64
108	Hakamura	62
109	Hydrogen	62
110	ToTheMoon_XOM9IK	62
111	Toxic2040	62
112	OmegaStarScream	61
113	PavelRostov	61
114	bones261	61
115	mindrust	61
116	nc50lc	61
117	shorena	61
118	600watt	60
119	Joel_Jantsen	60
120	bolshojkush	60
121	finaleshot2016	60
122	ibminer	60
123	Co1n	58
124	Goran_	58
125	Husna QA	58
126	LFC_Bitcoin	58
127	Sylon	58
128	odolvlobo	58
129	pitipawn	58
130	Trofo	57
131	numanoid	57
132	shahzadafzal	57
133	Coin-1	56
134	figmentofmyass	56
135	mithrim	56
136	Ariem	55
137	squatter	55
138	tonych	55
139	Anon136	54
140	BrewMaster	54
141	gmaxwell	54
142	hirozaki faraday	54
143	poptop	54
144	r1s2g3	54
145	taikuri13	54
146	Quickseller	53
147	Speculatoross	53
148	aTriz	53
149	roycilik	53
150	sapta	53
151	BitcoinTurk	52
152	Raja_MBZ	52
153	jseverson	52
154	mu_enrico	52
155	EFS	51
156	MagicSmoker	51
157	Wind_FURY	51
158	chimk	51
159	eternalgloom	51
160	mole0815	51
161	sabotag3x	51
162	Claymore	50
163	Daboy_Lyle	50
164	butka	50
165	cAPSLOCK	50
166	kaar	50

Link to spreadsheet : https://docs.google.com/spreadsheets/d/1e4jPEvdWsJItPmnFKLBK7VmUzM1ONdrFyR_-rDaDtao/edit?usp=sharing

Query used for this data (I used 50 in query, you can increase or decrease the number)

Code:

select u.username,count (distinct m.fromid)  from userdata u,meritdata m where u.userid=m.toid 
group by u.username having count (distinct m.fromid) >=50  order by count (distinct m.fromid) desc ;

Now if you are interested about the distributions of merits received by the poster by different users  , then you can use the below query to see the distribution. I used "theymos"  and data shows that "Foxpup" is top merit sender to "theymos". Make sure to use the exact forum name because data in database is case-sensitive.

Query used:

Code:

select A.sum_merits,f.* from 
(select sum(m.merit) sum_merits ,m.fromid fid from userdata u,meritdata m where u.userid=m.toid and u.username='theymos' group by m.fromid ) A,userdata f where f.userid=A.fid
order by A.sum_merits desc;

theymos Merit sender

Code:

sum_merits	UserId	UserName	Rank
136	55384	Foxpup	Legendary
96	51173	mprep	Global Moderator
74	30747	Vod	Legendary
66	158505	roslinpl	Legendary
50	6822	Scorpion	Hero Member
50	81995	peloso	Legendary
50	140584	EFS	Staff
50	183495	otrkid70	Legendary
50	340026	sofu	Legendary
50	346731	minerjones	Copper Member
50	406631	Kiritsugu	Legendary
50	662288	Palider	Hero Member
39	234771	suchmoon	Legendary
35	18321	OgNasty	Donator
35	459836	LoyceV	Legendary
33	553678	rickbig41	Global Moderator
32	358020	Quickseller	Copper Member
32	880238	Angelo Santos	Sr. Member
32	914465	crwth	Sr. Member
30	76847	notaek	Legendary
29	915303	TheDistrictsProject	Sr. Member
28	164822	hilariousandco	Global Moderator
25	81419	ny2cafuse	Legendary
25	175302	Avirunes	Copper Member
25	390370	keesdewit	Copper Member
25	548195	Topknotbam	Legendary
25	558519	socks435	Legendary
22	402366	Betwrong	Legendary
21	521899	SFR10	Legendary
20	214323	ltcrstrbrt	Legendary
20	808310	batang_bitcoin	Hero Member
19	23092	malevolent	Staff
18	211419	redsn0w	Legendary
18	527272	Wapinter	Copper Member
18	747519	Sponsoredby15	Sr. Member
16	325061	pugman	Legendary
16	355846	yahoo62278	Legendary
16	525058	InvoKing	Legendary
15	140827	yogg	Legendary
15	219961	--Encrypted--	Copper Member
15	381705	cellard	Legendary
15	507936	DarkStar_	Legendary
15	755235	arwin100	Hero Member
15	836384	Frenk Best	Hero Member
15	1192397	paxmao	Sr. Member
14	153634	dbshck	Staff
13	359658	hahay	Legendary
13	875360	BicolIsarog	Sr. Member
13	1291828	iasenko	Sr. Member
12	364070	bitbollo	Legendary
12	884853	BlackMambaPH	Hero Member
11	397611	Jeremycoin	Legendary
11	885934	SamReomo	Sr. Member
10	55122	DiamondCardz	Legendary
10	97213	deadley	Legendary
10	125554	mishax1	Legendary
10	129114	xIIImaL	Legendary
10	197395	fearcoka	Hero Member
10	334527	izanagi narukami	Legendary
10	359716	ETFbitcoin	Legendary
10	369699	grandFX	Legendary
10	458393	harizen	Legendary
10	539350	crairezx20	Legendary
10	557413	chichidori	Legendary
10	561804	JanpriX	Hero Member
10	661339	Zocadas	Hero Member
10	810882	BALIK	Copper Member
10	826292	carlisle1	Hero Member
10	851885	jerald125	Hero Member
10	947291	Polar91	Sr. Member
10	969327	Anon11073	Staff
10	986141	Vishnu.Reang	Sr. Member
10	1003345	ChipMixer	Full Member
9	78147	Cyrus	Administrator
9	84866	ibminer	Legendary
9	697888	Script3d	Hero Member
9	976210	nullius	Copper Member
8	24140	qwk	Donator
8	151761	CoinCube	Legendary
8	249495	Cøbra	Member
8	452769	bones261	Legendary
8	543626	jackg	Copper Member
8	765632	bL4nkcode	Copper Member
7	5797	grue	Legendary
7	20174	fcmatt	Legendary
7	176777	mindrust	Legendary
7	379487	LFC_Bitcoin	Copper Member
7	410218	ashmodeus	Hero Member
7	543848	newinbtc	Legendary
7	806776	digaran	Hero Member
7	897509	xtraelv	Sr. Member
7	1059021	Arteezy.rtx	Copper Member
6	98986	TMAN	Hero Member
6	133846	monbux	Legendary
6	317618	nutildah	Legendary
6	333524	numanoid	Legendary
6	372359	krishnapramod	Legendary
6	465017	actmyname	Copper Member
6	553037	jhenfelipe	Hero Member
6	782831	akamit	Hero Member
6	841337	shield132	Hero Member
6	884600	Dahman El_Harrachi	Hero Member
6	971594	centralbanksequalsbombs	Sr. Member
6	1000199	krogothmanhattan	Hero Member
6	1188543	o_e_l_e_o	Sr. Member
5	554	Elwar	Legendary
5	21178	MintCondition	Legendary
5	68448	KonstantinosM	Hero Member
5	71414	mnightwaffle	Hero Member
5	84521	Welsh	Staff
5	85981	Abdussamad	Legendary
5	113670	Mitchell	Staff
5	137541	twbt	Legendary
5	140736	nydiacaskey01	Legendary
5	156391	abel1337	Legendary
5	161390	Cloudpost	Hero Member
5	173873	xxxgoodgirls	Legendary
5	252510	JayJuanGee	Legendary
5	372697	Punggawa	Legendary
5	393354	julian071	Hero Member
5	397737	hilariousetc	Legendary
5	462517	Landak	Hero Member
5	516752	DaddyMonsi	Legendary
5	519783	asu	Hero Member
5	535215	ralle14	Legendary
5	553066	BlockEye	Legendary
5	579628	bob123	Hero Member
5	698159	Jet Cash	Legendary
5	757564	Bitcoinsummoner	Hero Member
5	805497	CREATIVE_Life	Hero Member
5	809963	Wowcoin	Hero Member
5	838716	bubblebit	Sr. Member
5	849178	Mapagmahal	Copper Member
5	857883	Yatsan	Hero Member
5	888861	merlyn22	Hero Member
5	894829	0t3p0t	Sr. Member
5	895005	Cacingkemi	Hero Member
5	897586	OculusMan	Hero Member
5	909116	Blake_Last	Sr. Member
5	916507	liviux	Full Member
5	925386	ReLieD	Sr. Member
5	932714	BCTBF	Sr. Member
5	954930	hirokazu	Sr. Member
5	961494	theunbeatable	Sr. Member
5	1011165	rjbtc2017	Sr. Member
5	1109214	f150	Full Member
5	1135453	Revenant 02	Full Member
5	1202061	chimk	Full Member
5	1359124	sister1001	Member
4	3079	chris200x9	Legendary
4	6706	RodeoX	Legendary
4	99837	HeRetiK	Hero Member
4	114848	Financisto	Hero Member
4	370611	bill gator	Copper Member
4	392456	twicezeroiszero	Hero Member
4	458761	vizito	Legendary
4	546617	npredtorch	Legendary
4	560412	Joel_Jantsen	Legendary
4	798632	Woshib	Hero Member
4	799123	Getcoinsite	Sr. Member
4	805820	Lafu	Hero Member
4	844914	Wind_FURY	Hero Member
4	919736	FlamingFingers	Sr. Member
4	935741	cissrawk	Sr. Member
4	988740	frodocooper	Staff
4	1053456	Ben271286	Full Member
4	1105948	patz22	Full Member
4	1582324	DdmrDdmr	Sr. Member
3	11425	gmaxwell	Staff
3	23067	FractalUniverse	Hero Member
3	138637	btcton	Legendary
3	163641	eternalgloom	Legendary
3	172217	Matt9301	Legendary
3	182468	RGBKey	Hero Member
3	183781	pawel7777	Legendary
3	257071	NeuroticFish	Legendary
3	306338	dothebeats	Legendary
3	350580	irfan_pak10	Copper Member
3	379147	pooya87	Legendary
3	501333	jtipt	Hero Member
3	523235	knuckey	Sr. Member
3	525056	BitMaxz	Legendary
3	717272	trecore4	Sr. Member
3	729995	SparkyU	Hero Member
3	813715	thisappointed	Hero Member
3	821995	hatshepsut93	Hero Member
3	876572	limmousine	Sr. Member
3	950662	julerz12	Sr. Member
3	967277	speem28	Sr. Member
3	1059032	cuo	Full Member
3	1066674	yojodojo21	Full Member
3	1079049	Jessy Mediola	Full Member
3	1086882	tweetbit	Full Member
3	1117058	kier010	Full Member
3	1147936	rommelzkie	Full Member
3	1180530	theyoungmillionaire	Full Member
2	33156	vapourminer	Legendary
2	62358	Gyrsur	Legendary
2	74719	fruit	Legendary
2	123417	digit	Legendary
2	157691	piebeyb	Legendary
2	178657	fr4nkthetank	Legendary
2	186520	Initscri	Hero Member
2	194811	vit05	Sr. Member
2	223994	Hexah	Sr. Member
2	252402	TheStuhlman	Legendary
2	313016	owlcatz	Legendary
2	314792	examplens	Legendary
2	322667	tobeaj2mer01	Legendary
2	334783	seoincorporation	Legendary
2	337097	iluvbitcoins	Legendary
2	346449	botany	Legendary
2	347141	sapta	Staff
2	358787	Dudeperfect	Hero Member
2	373425	dinda22	Legendary
2	396906	bitcoinmasterlord	Legendary
2	398485	xdrpx	Hero Member
2	479624	Last of the V8s	Legendary
2	511899	RoomBot	Legendary
2	533583	Lucius	Legendary
2	535846	Aleister Crowley	Hero Member
2	544972	yolanda222	Legendary
2	554429	Indrawan77	Hero Member
2	554812	DeathAngel	Legendary
2	556382	TheGodFather	Hero Member
2	580327	eddie13	Hero Member
2	599866	eye4bd	Hero Member
2	640554	Strongkored	Legendary
2	688810	Tyrantt	Hero Member
2	757107	Bakemat	Sr. Member
2	787736	marlboroza	Hero Member
2	816788	gandame	Hero Member
2	818704	Soranith	Hero Member
2	818934	coinmenace	Hero Member
2	820936	aliashraf	Sr. Member
2	854798	Oceat	Sr. Member
2	862738	Astvile	Sr. Member
2	877396	AdolfinWolf	Hero Member
2	881564	BlackRock	Sr. Member
2	894862	DaftAjax	Sr. Member
2	917908	Rooster101	Sr. Member
2	926641	seven2smoke1	Full Member
2	947337	Xenrise	Sr. Member
2	955917	tanghere02	Sr. Member
2	958159	onecall123	Sr. Member
2	959979	creepyjas	Sr. Member
2	960511	nullCoiner	Sr. Member
2	969551	SoulBargain	Full Member
2	970256	btc_angela	Sr. Member
2	984212	llyfee4u	Full Member
2	986243	7jaka7	Sr. Member
2	989138	Maykl	Sr. Member
2	1000368	LouVandetta	Sr. Member
2	1013536	Be_Happy	Sr. Member
2	1017434	richminded	Sr. Member
2	1020285	Rebisco	Full Member
2	1047996	bluefirecorp_	Member
2	1091163	Silent26	Sr. Member
2	1100851	katinko	Full Member
2	1107844	amishmanish	Sr. Member
2	1109403	BenOnceAgain	Member
2	1180810	rodmanqs	Full Member
2	1214159	Crypto Capital	Member
2	1560793	sncc	Sr. Member
2	1574226	mu_enrico	Copper Member
2	1605387	cabalism13	Member
2	1649515	hakka	Member
2	1701092	Husires	Member
2	1938519	butka	Full Member
2	2049993	DoriangrayTW	Member
1	13544	hdclover	Hero Member
1	16392	RakelA96	Member
1	17501	iCEBREAKER	Legendary
1	18700	Pipesnake	Legendary
1	28719	jbreher	Legendary
1	32419	linkme	Sr. Member
1	34692	fronti	Legendary
1	35501	cAPSLOCK	Legendary
1	47593	ajqjjj	Hero Member
1	51285	NaXxow	Hero Member
1	54791	Dabs	Staff
1	58607	FuzzyBear	Legendary
1	61202	AmDD	Legendary
1	64748	flynn	Hero Member
1	65716	CoinEraser	Hero Member
1	73389	dave111223	Legendary
1	80810	solosequenosenada	Sr. Member
1	85033	d5000	Legendary
1	87229	yefi	Legendary
1	87449	pangu	Hero Member
1	88912	600watt	Legendary
1	100591	veleten	Legendary
1	101872	Lauda	Legendary
1	110785	AGD	Legendary
1	113838	itod	Legendary
1	120694	xhomerx10	Legendary
1	122077	AngelSky	Hero Member
1	125747	Taras	Legendary
1	131361	Timelord2067	Legendary
1	131686	HarHarHar9965	Hero Member
1	135920	aTriz	Hero Member
1	136484	figmentofmyass	Hero Member
1	152666	Mountaingoat	Hero Member
1	153644	tyz	Legendary
1	154742	anirgu	Legendary
1	154816	cagrund	Legendary
1	162290	bitcoinblog	Sr. Member
1	162680	squatter	Hero Member
1	163318	Torque	Legendary
1	164749	stompix	Hero Member
1	172868	Gelbstich	Hero Member
1	174480	MadZ	Hero Member
1	177723	hopenotlate	Legendary
1	179437	w0lf0.	Hero Member
1	183392	undeadbitcoiner	Sr. Member
1	186337	itsonlikedonkeykong	Sr. Member
1	192825	_Miracle	Hero Member
1	195140	Xtar	Hero Member
1	206368	cryptonit	Legendary
1	208580	pol5	Legendary
1	231127	adjiadjo	Legendary
1	233431	john1010	Hero Member
1	239406	Toxic2040	Sr. Member
1	240233	funsponge	Hero Member
1	242809	kimamaxgreen	Member
1	255065	ebliever	Legendary
1	262695	OROBTC	Legendary
1	289817	NotFuzzyWarm	Legendary
1	303026	Velkro	Legendary
1	311045	hodlcoins	Legendary
1	315016	djangocoin	Sr. Member
1	318891	Jocuserious	Sr. Member
1	320412	5tift	Hero Member
1	325680	HI-TEC99	Legendary
1	325777	lite	Legendary
1	330633	s1ng	Legendary
1	336203	penoze	Legendary
1	338580	CrazyCraig	Sr. Member
1	339978	bozo333	Sr. Member
1	340795	vanobe	Member
1	341170	free-bit.co.in	Hero Member
1	344995	saddampbuh	Legendary
1	348185	HagssFIN	Legendary
1	352642	fitraok09	Hero Member
1	353493	Dread Pirate Roberts	Copper Member
1	358471	jesoa	Member
1	362644	wanispwnz	Full Member
1	362982	KuromaYoichi	Sr. Member
1	366549	max2000irc	Hero Member
1	368438	ccsang	Full Member
1	368837	r1d1	Hero Member
1	369212	zazarb	Legendary
1	372249	bitcoin revo	Legendary
1	374061	Kakmakr	Legendary
1	374598	codenamethisNutz	Sr. Member
1	375981	OmegaStarScream	Staff
1	378130	andycarrol	Hero Member
1	378257	FrueGreads	Legendary
1	385855	Patatas	Legendary
1	386072	Salmen	Legendary
1	387544	oHnK	Hero Member
1	389271	Limx Dev	Copper Member
1	391624	sonerbo	Copper Member
1	393142	stingers	Legendary
1	396526	ezeminer	Legendary
1	397256	Bitfort	Sr. Member
1	401307	zork	Legendary
1	405032	rozee	Legendary
1	408246	YuTü.Co.in	Sr. Member
1	408367	killyou72	Copper Member
1	430390	psycodad	Hero Member
1	497745	RealPhotoshoper	Legendary
1	508748	Zeroxal	Hero Member
1	509986	Emperor of Man	Hero Member
1	510707	hanifhadzar	Sr. Member
1	514956	freedoge.co	Hero Member
1	516369	kamvreto	Legendary
1	533006	richardsNY	Legendary
1	545598	Isildur (official)	Hero Member
1	557798	TryNinja	Hero Member
1	569455	BobLawblaw	Legendary
1	598528	debutant	Hero Member
1	623643	johhnyUA	Hero Member
1	643028	Greaves7	Hero Member
1	662310	Kolder	Hero Member
1	662570	HabBear	Hero Member
1	669141	Xavofat	Hero Member
1	675302	leonix007	Sr. Member
1	703997	mrcash02	Hero Member
1	704626	moamin77	Full Member
1	735878	apoorvlathey	Hero Member
1	741872	poptok1	Hero Member
1	765554	Quidat	Sr. Member
1	771962	Raja_MBZ	Hero Member
1	782621	alisafidel58	Full Member
1	808881	eaLiTy	Hero Member
1	816300	Jelly0621	Sr. Member
1	816537	ankit10	Sr. Member
1	816896	sunsilk	Hero Member
1	817592	IeSua	Hero Member
1	819957	prettybuds	Full Member
1	824455	nkarm1	Full Member
1	828352	Immor108	Hero Member
1	834384	mrjoy15	Hero Member
1	838362	JayCue	Full Member
1	843526	bitcoinsforall	Hero Member
1	849797	Loganota	Hero Member
1	853829	Adbitco	Sr. Member
1	854519	entrepmind23	Sr. Member
1	864005	kaicrypzen	Hero Member
1	864332	Hassan02	Hero Member
1	870895	darklus123	Hero Member
1	874477	8Habits	Sr. Member
1	876001	SamsungBitcoin	Sr. Member
1	876156	Kaznachej123	Hero Member
1	879277	Coding Enthusiast	Sr. Member
1	887277	snowyNNN	Sr. Member
1	888099	finaleshot2016	Sr. Member
1	897423	spov	Full Member
1	902263	carcassone	Sr. Member
1	905157	anorganix	Copper Member
1	908236	digitalgame4life	Full Member
1	908376	MrCrank	Sr. Member
1	910477	PHPSELLER	Sr. Member
1	914868	ThatRandom8543	Sr. Member
1	919220	Renji Abarai	Full Member
1	919836	AlcatelBravo	Full Member
1	920544	Tara11	Sr. Member
1	924222	HEWRA	Full Member
1	925907	okissabam	Sr. Member
1	928004	kurbeks	Sr. Member
1	928111	Live.me	Full Member
1	932735	Akash1243	Sr. Member
1	937706	iamqw	Member
1	938170	Cobalt9317	Copper Member
1	938265	kidsuzudn	Full Member
1	952464	scum	Member
1	961738	Tesorex	Full Member
1	964169	nix_7878	Member
1	969459	Velogin	Jr. Member
1	970591	jakirtanvir	Full Member
1	971496	necromastery	Sr. Member
1	973054	NewStar	Sr. Member
1	973996	Chris314	Sr. Member
1	974425	shadowdio	Sr. Member
1	978539	revenant2017	Sr. Member
1	984384	Baofeng	Sr. Member
1	987982	kissmarx	Sr. Member
1	995487	Kawasanz	Sr. Member
1	995655	Gekkoo	Sr. Member
1	998621	mrcastelo	Full Member
1	1004188	Bagaji	Sr. Member
1	1006408	caneca	Full Member
1	1006592	nioschka	Full Member
1	1009071	vinc3	Sr. Member
1	1010389	L1544	Full Member
1	1014315	Mungurul	Sr. Member
1	1016829	edgycorner	Full Member
1	1016958	Fujiati	Full Member
1	1018532	sekapai	Member
1	1019229	axiline	Full Member
1	1020270	GeniusAko	Full Member
1	1025090	DU18	Full Member
1	1025104	bbcolex	Full Member
1	1026915	Squishy01	Member
1	1035145	Delphinus	Full Member
1	1035841	josephpogi	Full Member
1	1037063	Butchick	Full Member
1	1045345	jatin729	Full Member
1	1045367	kurian	Full Member
1	1047959	pinoyden	Full Member
1	1048361	YouShallNotPass	Full Member
1	1052329	Mahirap	Full Member
1	1054592	Aventhe	Full Member
1	1061824	Chrystora123	Full Member
1	1062153	btc78	Full Member
1	1065054	Piratte	Full Member
1	1067333	micgoossens	Sr. Member
1	1076800	1020kingz	Full Member
1	1081647	friends1980	Full Member
1	1083030	Wingo	Full Member
1	1086501	ModaFuka1994	Member
1	1095532	blacksky	Full Member
1	1098120	TheKeyLongThumbI	Full Member
1	1099214	Gracechen17	Full Member
1	1100191	shesheboy	Full Member
1	1100242	hothot	Member
1	1101238	Highspeed123	Full Member
1	1106178	wiredideas	Full Member
1	1109297	Valentina N	Full Member
1	1116762	imstillthebest	Full Member
1	1118386	NedShift	Member
1	1119424	NoMar02	Full Member
1	1121336	shoreno	Full Member
1	1122795	jhongzjhong	Full Member
1	1126497	Crumple Cat	Full Member
1	1127008	NavI_027	Full Member
1	1127855	xXLimbXx	Full Member
1	1129436	dirgayeah	Full Member
1	1132169	felipe04	Full Member
1	1132999	Zastria	Full Member
1	1137497	Kpmaline	Jr. Member
1	1138034	dameh2100	Full Member
1	1142832	nioctiB#1	Full Member
1	1143164	LogitechMouse	Full Member
1	1143460	mak2017	Full Member
1	1143867	cepedacharles29	Full Member
1	1147321	Fazlurkhan.kz	Full Member
1	1148377	Tristan1337	Member
1	1156114	orionluckyse7en	Full Member
1	1158586	DRAWDE_3691	Full Member
1	1159221	ferrybitcoin.1996	Full Member
1	1162741	dr.cheema	Full Member
1	1171091	Shiroxx	Member
1	1178098	nanna	Full Member
1	1179651	sheenshane	Full Member
1	1189098	sneeze11	Full Member
1	1194201	farhan28	Full Member
1	1196880	aervin11	Full Member
1	1203847	Deathgamer	Member
1	1207215	cryptovagas	Member
1	1232224	zenrol28	Copper Member
1	1246658	pranazzs	Member
1	1249182	Godric-Gryffindor	Member
1	1254896	mazdafunsun	Member
1	1257516	Rosewater Foundation	Full Member
1	1261329	chamika888	Member
1	1276985	WUWARAOLUOXIANG	Member
1	1280710	Stamil	Member
1	1289764	spiderm4n15	Member
1	1295824	cpmcgrat	Member
1	1305518	akashark	Member
1	1308233	peach56	Member
1	1311953	t1Zona	Member
1	1318827	dxbcoin	Member
1	1329214	kingjackoin	Member
1	1337707	EnterTheLight	Member
1	1341921	krishnaverma	Member
1	1346246	orkoso	Member
1	1348516	Pantoflascrypt017	Member
1	1369827	tesla80	Member
1	1374659	mightwalker	Jr. Member
1	1383162	OlgaAmraie	Jr. Member
1	1413633	OWZ1337	Member
1	1427952	snowblack	Member
1	1432468	mdayonliner	Sr. Member
1	1435147	zenman0	Member
1	1554927	bitmover	Sr. Member
1	1634314	shahzadafzal	Copper Member
1	1644225	unabomber	Newbie
1	1645049	BitExalt	Copper Member
1	1781008	Daboy_Lyle	Member
1	1825672	morvillz7z	Full Member
1	1837238	crypmike	Full Member
1	1867995	roda00	Jr. Member
1	1878246	abhiseshakana	Full Member
1	1920386	as9ardia	Member
1	1980983	Coolcryptovator	Copper Member
1	2003859	DireWolfM14	Member
1	2124069	vphasitha01	Full Member
1	2132794	IgorKiselev	Jr. Member
1	2307759	TheArchaeologist	Member
1	2363935	YOSHIE	Jr. Member
1	2391740	Dont trust for money	Newbie
1	2423416	S_Therapist	Newbie

If you are further interested in breakup of the posts in which poster received merits then use the  below query. Replace r.username with the poster forum username , In my case I used theymos and replace u.username with the senders username,in my case it is Foxpup.
 Make sure to use the exact forum name because data in database is case-sensitive.

Query used:

Code:

select A.username MeritGiver,A.Date,A.Merit,A.msg,r.username MeritReciever,A.board,a.subboard,a.titlethread from (select * from userdata u ,meritdata m where u.username='Foxpup' and u.userid=m.fromid) A, userdata r where a.toid=r.userid 
and r.username='theymos';

 

Distribution of data:

Code:

MeritGiver	Date	Merit	Msg	MeritReciever	Board	SubBoard	TitleThread
Foxpup	2018-10-18T12:26:26	4	5047729.msg46740675	theymos	Bitcoin	Development & Technical Discussion	How is bitcoind “shy” when exchanging `version` packets?
Foxpup	2018-10-18T12:25:56	4	4659296.msg46290617	theymos	Other	Politics & Society	Supreme Court pick Brett Kavanaugh
Foxpup	2018-09-29T03:07:28	2	5035303.msg46042843	theymos	Other	Meta	Growing Blackmarket for Merit trading 
Foxpup	2018-09-22T09:17:17	9	5035144.msg46014777	theymos	Bitcoin	Development & Technical Discussion	The duplicate input vulnerability shouldn*t be forgotten
Foxpup	2018-09-20T11:35:58	4	5031079.msg45923426	theymos	Bitcoin	Development & Technical Discussion	Flaws in LN (Lightning Network).
Foxpup	2018-09-20T05:11:43	4	5032980.msg45922658	theymos	Bitcoin	Development & Technical Discussion	When Schnorr will be added?
Foxpup	2018-09-20T05:10:47	3	5032980.msg45920204	theymos	Bitcoin	Development & Technical Discussion	When Schnorr will be added?
Foxpup	2018-09-18T04:29:09	1	5030366.msg45823950	theymos	Other	Meta	Enhanced newbie restrictions & requirements
Foxpup	2018-09-18T04:06:47	2	5030366.msg45814117	theymos	Other	Meta	Enhanced newbie restrictions & requirements
Foxpup	2018-09-18T04:04:16	5	2818350.msg45849233	theymos	Other	Meta	Merit & new rank requirements
Foxpup	2018-09-18T03:57:23	4	5030366.msg45810953	theymos	Other	Meta	Enhanced newbie restrictions & requirements
Foxpup	2018-09-18T03:56:13	15	5030366.msg45810047	theymos	Other	Meta	Enhanced newbie restrictions & requirements
Foxpup	2018-08-29T03:40:45	2	4967555.msg44845552	theymos	Other	Meta	FAO MODS: Why not charge a fee to recover hacked accounts?
Foxpup	2018-08-16T10:05:51	3	4905191.msg44172369	theymos	Other	Serious discussion	What would the top coins be if people were sane?
Foxpup	2018-08-16T03:53:12	1	4897173.msg44101782	theymos	Other	Meta	Can we get whoever the mod is who did this banned?
Foxpup	2018-08-05T17:05:29	4	2260983.msg43473905	theymos	Bitcoin	Development & Technical Discussion	Creating private key from 2 different RNG:s?
Foxpup	2018-08-05T17:05:28	3	2260983.msg43445376	theymos	Bitcoin	Development & Technical Discussion	Creating private key from 2 different RNG:s?
Foxpup	2018-07-16T02:07:15	2	4675898.msg42257358	theymos	Other	Meta	Anunymint ban
Foxpup	2018-07-13T07:08:26	4	4659296.msg42066357	theymos	Other	Politics & Society	Supreme Court pick Brett Kavanaugh
Foxpup	2018-07-06T14:23:51	6	4609442.msg41610959	theymos	Other	Meta	Idea: Courses
Foxpup	2018-05-20T04:48:26	15	3920469.msg37611040	theymos	Alternate cryptocurrencies	Announcements (Altcoins)	[ANN][PRE-ICO]HoweyCoins: the only BitcoinTalk-endorsed ICO - GUARANTEED PROFIT
Foxpup	2018-05-10T02:17:26	1	3683184.msg36818653	theymos	Other	Meta	Report to the moderator -Deserve some rewards  
Foxpup	2018-05-05T03:29:22	1	3540892.msg36329486	theymos	Other	Meta	Image caching
Foxpup	2018-05-01T03:49:39	3	3432369.msg35976937	theymos	Other	Meta	Banned Account Question 
Foxpup	2018-04-21T03:42:30	6	3341237.msg34961604	theymos	Other	Politics & Society	Anacyclosis - cycles of society/government
Foxpup	2018-03-16T07:13:03	3	2945878.msg32334739	theymos	Other	Meta	overwhelming consensus excludes Lauda, remains in DT2, went in2 buz w sold act  
Foxpup	2018-03-13T04:08:28	3	2986106.msg32186049	theymos	Other	Meta	Newbie, Jr Members, Members suffering from merit-phobia: Explanations and Advice
Foxpup	2018-03-07T07:06:12	6	1469099.msg14823618	theymos	Bitcoin	Bitcoin Discussion	Theymos: “Bitcoins Belonging to Satoshi Should Be Destroyed”
Foxpup	2018-03-07T07:05:55	1	1469099.msg14823504	theymos	Bitcoin	Bitcoin Discussion	Theymos: “Bitcoins Belonging to Satoshi Should Be Destroyed”
Foxpup	2018-02-27T15:33:38	3	3030477.msg31180145	theymos	Bitcoin	Development & Technical Discussion	Thoughts on the early bugs discovered by Peter Todd in LN?
Foxpup	2018-02-04T01:55:44	6	2818350.msg29540717	theymos	Other	Meta	Merit & new rank requirements
Foxpup	2018-01-25T03:09:51	6	2818350.msg28856522	theymos	Other	Meta	Merit & new rank requirements

All the queries were executed in Piggy's database on Nov 10 2018.

[1714078303]

1714078303

[1714078303]

1714078303

[1714078303]

1714078303

[1714078303]

1714078303

[1714078303]

1714078303

[1714078303]

1714078303

[Kopyleft]

I think instead of just looking in the Merits only data of a poster, we should combine it with the number of user that merited that poster to achieve that rank . Poster merited with multiple user should be worthy of reading instead of somebody getting merits with multiple users.

Are you suggesting we create another parameter added to users profiles that would display the number unique members who have merited them?

Of course users who have received merits from multiple users are given credits, but a lot of statistics affect that.
Including when the user joined, as some members have gone inactive, who would have otherwise merited them.
And I don't see why we should place extra attention on it.

I would also have a 100% record by the way. as I have only received merits from unique members. 

[Jet Cash]

That's an interesting ranking, and thanks for creating it. I was surprised to see that I was number 5, and I take this as meaning that my merit awarding and posting has a general appeal in the forum, I'd be interested to see a break down for members based on awards by Legendaries. A count of the number of legendaries that have awarded individual members would provide an indication of the opinion of the admins, mods and other seniors.

I like to consider these rankings, as it gives me some feedback on my activities here.

[r1s2g3]

I think instead of just looking in the Merits only data of a poster, we should combine it with the number of user that merited that poster to achieve that rank . Poster merited with by multiple user should be worthy of reading instead of somebody getting merits with multiple by few users.

Are you suggesting we create another parameter added to users profiles that would display the number unique members who have merited them?

Of course users who have received merits from multiple users are given credits, but a lot of statistics affect that.
Including when the user joined, as some members have gone inactive, who would have otherwise merited them.
And I don't see why we should place extra attention on it.

I would also have a 100% record by the way. as I have only received merits from unique members.  

Fixed the typo in my OP.
I am not saying to add anything and I am just pointing that when the user gathered 100+ merits it is interesting to see this data. This data actually points if user is really popular or just received few big transactions from some individual. I have encountered an example where user become "Full Member" by just 3 incoming Merit transaction.  This statistics will filter them out.

I only recognize "pitipawn" as Merit abuser who has made up in this list.

--snip--

I guess, in other words it is index of "Proof of Acceptability".

[virendarnagpal]

Interesting data presented. 
Really glad to see following members got 100% merits from different Merit senders (1 merit from each merit sender)
162   Claymore   50
163   Daboy_Lyle   50
164   butka   50
165   cAPSLOCK   50
166   kaar   50

[r1s2g3]

Interesting data presented. 
Really glad to see following members got 100% merits from different Merit senders (1 merit from each merit sender)
162   Claymore   50
163   Daboy_Lyle   50
164   butka   50
165   cAPSLOCK   50
166   kaar   50

 

This simply means that they are merited by 50 distinct users in this forum. It does not mean that there total merits are 50.

[Infinixhot1996]

I'll have to agree with you, and I think it counts for much if a user is merited by distinct/different/multiple users on the forum,its not like it changes anything
It simply shows that such users posts is widely appreciated and accepted by a wider audience on the forum...

50 merits from 50 different users is no small feat,and it simply shows consistency in quality posting

[vit05]

Could someone combine this with the other statistics about users who received merits in most different sections?

[cryptohunter]

This is very interesting

Can you show me what this top 50 list looks like if you subtract  merits from those that are currently on that list and then currently top 200 merit holders.

Even better can you find out

What % of merit given out by the top 100 goes to others that are not in the top 100

what % of merit given out by the top 200 goes to others that are not in the top 200

[r1s2g3]

Could someone combine this with the other statistics about users who received merits in most different sections?

You just need the minor modification in the first query to get this result . This result set is interesting because "theymos" is not the leader now.

From the data of sub boards "Suchmoon" is clearly at top, being merited at 15 subboard.

Query used:

Code:

select u.username,count (distinct m.subboard)  from userdata u,meritdata m where u.userid=m.toid 
group by u.username having count (distinct m.subboard) >=5  order by count (distinct m.subboard) desc

Result set:

Code:

UserName	count (distinct m.subboard)
suchmoon	15
NeuroticFish	14
hugeblack	14
theymos	14
LeGaulois	13
LoyceV	13
bill gator	13
bitmover	13
gentlemand	13
vit05	13
ETFbitcoin	12
Heisenberg_Hunter	12
Lauda	12
Leteravian	12
OgNasty	12
OmegaStarScream	12
Quickseller	12
Steamtyme	12
iasenko	12
nc50lc	12
seoincorporation	12
xtraelv	12
DarkStar_	11
Direwolve735	11
HeRetiK	11
Jet Cash	11
The Pharmacist	11
TheQuin	11
aleksej996	11
eternalgloom	11
jhenfelipe	11
mdayonliner	11
mocacinno	11
o_e_l_e_o	11
BitCryptex	10
HCP	10
Parodium	10
TryNinja	10
Vod	10
amishmanish	10
butka	10
coinlocket$	10
franky1	10
joniboini	10
marlboroza	10
mjglqw	10
shahzadafzal	10
stompix	10
vlad230	10
xhomerx10	10
BTCforJoe	9
DireWolfM14	9
Don Pedro Dinero	9
European Central Bank	9
Gleb Gamow	9
Lafu	9
Samarkand	9
Seetheummerallyeah	9
Thirdspace	9
Trofo	9
bitperson	9
bones261	9
cryptothief	9
d5000	9
mindrust	9
odolvlobo	9
r1s2g3	9
steve_rogers	9
theyoungmillionaire	9
tmfp	9
AverageGlabella	8
BitcoinTurk	8
ChiBitCTy	8
DannyHamilton	8
DaveF	8
DdmrDdmr	8
DooMAD	8
EcuaMobi	8
Flying Hellfish	8
Foxpup	8
Kate Beckett	8
KingScorpio	8
LTU_btc	8
Last of the V8s	8
LastJedi	8
LogitechMouse	8
Raja_MBZ	8
RivAngE	8
RodeoX	8
Sellingaccs	8
Thekool1s	8
adaseb	8
alani123	8
alia	8
aoluain	8
athanz88	8
atrocityx	8
buwaytress	8
edgycorner	8
guybrushthreepwood	8
harizen	8
iluvbitcoins	8
legendster	8
nullius	8
pawel7777	8
paxmao	8
philipma1957	8
pooya87	8
shield132	8
shorena	8
squatter	8
wwzsocki	8
AdolfinWolf	7
Anon136	7
BitMaxz	7
Bonakid	7
Branko	7
CarlosCorreia	7
Carlton Banks	7
Crypto Girl	7
Daboy_Lyle	7
Elwar	7
EthanB	7
Gummybear67	7
Hueristic	7
Kakmakr	7
Kemarit	7
Lucius	7
MadGamer	7
Makkara	7
Mpamaegbu	7
Nestade	7
OriginTrain	7
Paractor	7
Piggy	7
Pursuer	7
RGBKey	7
Slow death	7
Speculatoross	7
TMAN	7
Theb	7
Welsh	7
Wind_FURY	7
Wipro	7
YuTü.Co.in	7
asche	7
audaciousbeing	7
big_daddy	7
bob123	7
cellard	7
criptix	7
denis-z12	7
digaran	7
dooglus	7
eddie13	7
figmentofmyass	7
green547	7
hilariousandco	7
hilariousetc	7
ibminer	7
jackg	7
kenzawak	7
khufuking	7
macartem	7
mithrim	7
nngella	7
orkoso	7
poptok1	7
ranman09	7
spirali	7
sud	7
vapourminer	7
vphasitha01	7
yojodojo21	7
1Referee	6
ACVinegar	6
AngelSky	6
ArkiCrypto	6
Astargath	6
Avirunes	6
BTCMILLIONAIRE	6
Baofeng	6
Baoo	6
BayAreaCoins	6
Beerwizzard	6
BenOnceAgain	6
BillyBobZorton	6
BitcoinFX	6
Bitfort	6
BlockEye	6
Blue Tyrant	6
BobLawblaw	6
BrewMaster	6
CoinEraser	6
Dabs	6
Dread Pirate Roberts	6
Fazlurkhan.kz	6
Flodner	6
FrueGreads	6
Furgon Chino	6
Harlot	6
Hhampuz	6
Hydrogen	6
Jating	6
JayJuanGee	6
Joel_Jantsen	6
Kevin77	6
Kprawn	6
LFC_Bitcoin	6
Liza Soberano	6
LtMotioN	6
Lutpin	6
Neelix	6
Pleione527	6
Pmalek	6
QuestionAuthority	6
SFR10	6
Searing	6
Silent26	6
TECSHARE	6
Taras	6
TeQuiero	6
ThePunisher49X	6
Upgrade00	6
Zandar	6
Zwei	6
achow101	6
ahmad21	6
allahabadi	6
ausbit	6
bbc.reporter	6
bitChipper	6
bitart	6
bitbunnny	6
cissrawk	6
coin8coin8	6
crairezx20	6
crwth	6
crypmike	6
cryptohunter	6
cynical	6
dado7	6
darkangel11	6
dreamax25	6
finaleshot2016	6
friends1980	6
fxstrike	6
haroldtee	6
jseverson	6
jtipt	6
julerz12	6
killyou72	6
kirreev070	6
leea-1334	6
levyashin	6
lolchina	6
maarx	6
markj113	6
mattcode	6
mrcash02	6
mu_enrico	6
nutildah	6
pvk444	6
qwk	6
reflector	6
richardsNY	6
roll on	6
shasan	6
siddartha1492	6
squatz1	6
veleten	6
vladimirhf	6
1993jochico	5
2112	5
8Habits	5
AGD	5
Aikidoka	5
Ale88	5
Altcoindealer	5
Aura	5
BTCHadzija	5
BTCLovingDude	5
BTCeminjas	5
BTRIC	5
Barcode_	5
BitPotus	5
BitcoinHodler	5
BitcoinSupremo	5
Bushrat Jahan	5
Cobalt9317	5
Cocojam0610	5
Coding Enthusiast	5
CoinClarity	5
Coin_trader	5
Coolcryptovator	5
CryptoBry	5
CryptopreneurBrainboss	5
DimaS1574	5
F2b	5
Febo	5
Gavin Andresen	5
Globb0	5
Guvn0r	5
HabBear	5
Hazaki	5
Helana	5
Heyyyrenz	5
Initscri	5
InvoKing	5
JohnUser	5
JollyGood	5
Jrashid	5
Juggy777	5
JungleOnion	5
Karartma1	5
Klara_karlovna	5
KonstantinosM	5
Lovecove	5
MagicSmoker	5
Mardoker135	5
Mind Control	5
Minnie1928	5
MoonIsBlue	5
Moxivuki	5
NadiaHel	5
Naida_BR	5
Patatas	5
Protected101	5
PsylockReborn	5
Red-Apple	5
S3cco	5
STT	5
SaltySpitoon	5
SergiuDemerji	5
Squishy01	5
Sutters Mill	5
SyGambler	5
TheArchaeologist	5
TheNewAnon135246	5
TheUltraElite	5
Timelord2067	5
TimtheYoutuber	5
TitanAI	5
Titus Maximus	5
TravelMug	5
Traxo	5
Tszunami98	5
Tyrantt	5
Whosdaddy	5
Xynerise	5
Yantoaja	5
Zapo	5
aTriz	5
ace4549	5
actmyname	5
aencarnaci	5
aliashraf	5
allohha	5
alyssa85	5
angel55	5
anjho.ace	5
apoorvlathey	5
bL4nkcode	5
bakasabo	5
baricuri	5
batang_bitcoin	5
botany	5
btc_angela	5
btcltcdigger	5
celtic99	5
coly20032003	5
coolws	5
cry4crypto	5
crypto mania	5
cryptoaddictchie	5
deevan	5
dogtana	5
dothebeats	5
dumbtool45	5
examplens	5
fillippone	5
gmaxwell	5
gunhell16	5
hase0278	5
hous26	5
hubballi	5
hurry_hore	5
iambakov	5
infofront	5
iqlimasyadiqa	5
irfan_pak10	5
jemarleon	5
jjeeppeerrxx	5
jojo69	5
jonemil24	5
jossiel	5
jvdp	5
k0er	5
kiemnhieutien	5
kjnfmplm	5
klaaas	5
knight20	5
kpcian	5
krishnapramod	5
krogothmanhattan	5
kzv	5
leowonderful	5
loicuagio1979	5
magneto	5
magpie_lover	5
malikusama	5
max2607	5
mazdafunsun	5
mharz	5
mikeywith	5
mikfresh	5
minerjones	5
mprep	5
nafantc	5
onrise	5
owlcatz	5
pixie85	5
psycodad	5
pugman	5
qiwoman2	5
rajurathod18	5
ralle14	5
ranochigo	5
raske	5
rhamzter	5
sapta	5
silent17	5
sirazimuth	5
slaman29	5
sluppy	5
sncc	5
solarion	5
ss890	5
starmyc	5
stomachgrowls	5
supermine	5
swogerino	5
tactac	5
target	5
tbct_mt2	5
thehun	5
timoshani	5
togoshigekata	5
tomahawk9	5
tvplus006	5
tylerderden	5
tyz	5
upsidedown75	5
vella85	5
vlom	5
vv181	5
xdrpx	5
yahoo62278	5
zazarb	5
zickle	5

Edited  the query, and result set. (Actually Discrepancy caused due to deleted messages)
Even for boards, theymos is not the winner and couple bunch of users tying the spot , being merited in 6 5 Boards. Some of users here getting benefit of posting in Local board.

Query used

Code:

select u.username,count (distinct m.board)  from userdata u,meritdata m where u.userid=m.toid and m.board not in ('Message DELETED!')
group by u.username having count (distinct m.board) >=4  order by count (distinct m.board) desc;

Result set:

Code:

UserName	count (distinct m.board)
Anon136	5
ArkiCrypto	5
Daboy_Lyle	5
DarkStar_	5
Direwolve735	5
DooMAD	5
Dread Pirate Roberts	5
ETFbitcoin	5
Gleb Gamow	5
Gummybear67	5
HCP	5
Heisenberg_Hunter	5
Kate Beckett	5
KingScorpio	5
Lafu	5
Lauda	5
LeGaulois	5
Liza Soberano	5
LogitechMouse	5
Lutpin	5
NeuroticFish	5
OmegaStarScream	5
RivAngE	5
Samarkand	5
Thirdspace	5
Trofo	5
TryNinja	5
anjho.ace	5
bitmover	5
cissrawk	5
coinlocket$	5
crairezx20	5
d5000	5
denis-z12	5
edgycorner	5
fxstrike	5
harizen	5
hugeblack	5
iasenko	5
joniboini	5
macartem	5
marlboroza	5
mdayonliner	5
mindrust	5
nc50lc	5
pawel7777	5
paxmao	5
poptok1	5
ranman09	5
rhamzter	5
roll on	5
seoincorporation	5
shahzadafzal	5
spirali	5
steve_rogers	5
suchmoon	5
sud	5
timoshani	5
tmfp	5
vit05	5
vlad230	5
wwzsocki	5
xtraelv	5
yojodojo21	5
1Referee	4
1miau	4
8Habits	4
AdolfinWolf	4
AlisaWhishie	4
Analyst101	4
AngelSky	4
Aura	4
AverageGlabella	4
Avirunes	4
BTCHadzija	4
Baofeng	4
Barcode_	4
BayAreaCoins	4
Beerwizzard	4
BillyBobZorton	4
BitCryptex	4
BitMaxz	4
BitcoinArsenal	4
BitcoinFX	4
BitcoinTurk	4
BobLawblaw	4
Bonakid	4
CarlosCorreia	4
Cobalt9317	4
Coffee135	4
CoinClarity	4
CoinEraser	4
Coin_trader	4
Crypto Girl	4
CryptoBry	4
CryptoGamblingSites	4
Crypto_Sassy	4
Dabs	4
DaveF	4
DdmrDdmr	4
DimaS1574	4
Don Pedro Dinero	4
EcuaMobi	4
Elwar	4
European Central Bank	4
F2b	4
FlightyPouch	4
Flodner	4
Flying Hellfish	4
FrueGreads	4
GDragon	4
Gordante12	4
HabBear	4
HeRetiK	4
Hueristic	4
Hydrogen	4
Jating	4
JayJuanGee	4
JeremyB	4
Joel_Jantsen	4
Kakmakr	4
Kprawn	4
LTU_btc	4
Last of the V8s	4
LastJedi	4
LoyceV	4
Lucius	4
MadGamer	4
Makkara	4
ManaMan	4
Mc_Moneysack	4
Mind Control	4
Minnie1928	4
Moxivuki	4
Mpamaegbu	4
Mycrypto1222	4
Neelix	4
Neo-Design	4
Nestade	4
OgNasty	4
OriginTrain	4
Paractor	4
Patatas	4
Piggy	4
Pleione527	4
Pmalek	4
ProofOfLambo	4
Protected101	4
PsylockReborn	4
Pursuer	4
Quarantine34	4
Quickseller	4
RGBKey	4
Raja_MBZ	4
RodeoX	4
S3cco	4
SFR10	4
STT	4
Seetheummerallyeah	4
Sellingaccs	4
Silent26	4
Slow death	4
Speculatoross	4
Star_Bucks	4
StartupAnalyst	4
Steamtyme	4
Tankdestroyer	4
Taras	4
Tekno2020	4
The Pharmacist	4
Thekool1s	4
TimtheYoutuber	4
TitanAI	4
ToTheMoon_XOM9IK	4
Traxo	4
Tszunami98	4
Tyr808	4
Upgrade00	4
Urbinklin	4
Vod	4
Wind_FURY	4
Yantoaja	4
Zandar	4
Zebra.Guy	4
ace4549	4
ahmad21	4
aleksej996	4
amishmanish	4
android17	4
aoluain	4
asche	4
athanz88	4
bL4nkcode	4
bakasabo	4
bbc.reporter	4
bill gator	4
bitChipper	4
bitbunnny	4
bitperson	4
blackmagical	4
bob123	4
bones261	4
btc-facebook	4
btcrut2017	4
butka	4
buwaytress	4
cellard	4
codemanX	4
coin8coin	4
coin8coin8	4
coinycoiny	4
coly20032003	4
coolws	4
criptix	4
crwth	4
crypmike	4
cryptohunter	4
cryptothief	4
cynical	4
dado7	4
deadley	4
dooglus	4
electrobit	4
empoy	4
eternalgloom	4
examplens	4
fanatic26	4
fanatic26_	4
fattyforhire	4
fillippone	4
finaleshot2016	4
franky1	4
gentlemand	4
green547	4
hagiyatmaz	4
haroldtee	4
hilariousandco	4
hilariousetc	4
hopenotlate	4
hubballi	4
ibminer	4
icalical	4
iillaa	4
infofront	4
inv_ker	4
jbreher	4
jhenfelipe	4
jhongzjhong	4
jinksters09	4
john1010	4
jojo69	4
jossiel	4
jseverson	4
julerz12	4
jvdp	4
k0er	4
kenzawak	4
kevoh	4
khufuking	4
kjnfmplm	4
kzv	4
leowonderful	4
loicuagio1979	4
lok8nusa	4
lordquanta	4
lovesybitz	4
maarx	4
mattcode	4
metenjean	4
mharz	4
mikeywith	4
mikfresh	4
mimienamphine	4
mithrim	4
mjglqw	4
mocacinno	4
moneyangel	4
mu_enrico	4
nlcars	4
npredtorch	4
nullius	4
o_e_l_e_o	4
odolvlobo	4
onrise	4
orkoso	4
otandelapaz	4
philipma1957	4
pixie85	4
pugman	4
pvk444	4
qwk	4
ralle14	4
rickbig41	4
rillater	4
ruthbabe	4
sapta	4
sham100899	4
shield132	4
shorena	4
shulio	4
sidehack	4
silent17	4
squatz1	4
ss890	4
stompix	4
swogerino	4
tactac	4
target	4
theymos	4
theyoungmillionaire	4
tim-bc	4
tylerderden	4
vapourminer	4
veleten	4
wantjokull	4
waqasniaz007	4
xhomerx10	4
yahoo62278	4
ymemey	4
zenrol28	4
zlatan07	4
zoran.drobnjak	4

[r1s2g3]

This is very interesting
Can you show me what this top 50 list looks like if you subtract  merits from those that are currently on that list and then currently top 200 merit holders.

Query for original top 200 .

Code:

select u1.username, A.toid,A.summerit from userdata u1 ,(select m.toid,sum(m.Merit) summerit from Meritdata m group by m.toid order by sum(m.merit) desc limit 200)A ) and u1.userid=A.toid;

New Top 200 list after removing the Merit given by Top 200  

Code:

select u1.username,sum(r.merit) from Meritdata r, userdata u1 where r.fromid not in ( select A.toid from (select m.toid,sum(m.Merit) from Meritdata m group by m.toid order by sum(m.merit) desc limit 200)A ) and u1.userid=r.toid 
group by u1.username order by sum(r.merit) desc limit 200;

   

Below spreadsheet  contain the list original top 200 and the new top 200 will look like

https://docs.google.com/spreadsheets/d/1SAi_b3umCcFJO2dMoLYjWCjNz1JhOLWrsRHhYQK-nb8/edit?usp=sharing

What % of merit given out by the top 100 goes to others that are not in the top 100

Code:

select sum(A.summerit) from (select sum(m.Merit) summerit  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100) A ; 
48648  total merit recieved by top 100

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 );  
47776  Total merit given by top 100

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 )
and  m1.toid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 ) ;    
15903 is total number of merit given by top 100 to top 100

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 )
and  m1.toid not in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 100 ) ;   
31873 is total number of merit given by top 100 that are not in top 100

so (15093/47776)*100 = 31.59%  of merit top 100 is given to top 100

what % of merit given out by the top 200 goes to others that are not in the top 200

Code:

select sum(A.summerit) from (select sum(m.Merit) summerit  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200) A ;  
69120 is total merit recieved by top 200.

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 );   

65641 total merit given by top 200.


select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 )
and  m1.toid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 ) ;  
29958 is total merit given by top 200 to top 200.

select sum(m1.merit) from Meritdata m1 where m1.fromid in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 )
and  m1.toid not in( select m.toid  from Meritdata m group by m.toid order by sum(m.merit) desc limit 200 ) ;  

35683 is total merit given by top 200 that are not in top 200.

So (29958/65641)*100 =45.63% of merit top 200 is given to top 200

[cryptohunter]

This is very interesting

Can you show me what this top 50 list looks like if you subtract  merits from those that are currently on that list and then currently top 200 merit holders.

Even better can you find out

What % of merit given out by the top 100 goes to others that are not in the top 100

what % of merit given out by the top 200 goes to others that are not in the top 200

Reserved, I definitely work on this stats and edit this post after getting answer to your requirement.

Thanks that would be really great


Thanks for updating your post.

when you say this  So (29958/65641)*100 =45.63% of merit top 200 is given to top 200


this means 45.63% is received by the top 200 from other members of the top 200 right?

but what I really wanted to find out was...

Top 200 send x % out of the top 200 ... is it possible?

So for instance let's say your stat is 50% not 45


So top 200 get total 10,000 merit total.

5000 from outside the top 200

5000 from inside the top 200

What is the top 200 only actually sending 5000 so they are sending 0% outside of the top 200.

Of course this is a crazy proposition I can see many top 200 are sending noobs quite a bit of merit.

But I want to know what exact %  the top 200 sending outside of the top 200% of the total they are sending.  Do you see what I mean and is it possible to even find out?

[r1s2g3]

Top 200 send x % out of the top 200 ... is it possible?

So for instance let's say your stat is 50% not 45


So top 200 get total 10,000 merit total.

5000 from outside the top 200

5000 from inside the top 200

What is the top 200 only actually sending 5000 so they are sending 0% outside of the top 200.

Of course this is a crazy proposition I can see many top 200 are sending noobs quite a bit of merit.

But I want to know what exact %  the top 200 sending outside of the top 200% of the total they are sending.  Do you see what I mean and is it possible to even find out?

That information was also in that answer: (just check again the output of the sqls)

69120 is total merit recieved by top 200.
Receiving 69120 merit enable them to send only 34560 merits but they send 65641  merits (approximately double amount)

Now analyze top 100
48648  total merit received by top 100
Receiving  48648   merit will only enable them to send 24324 merits only  but they sent 47776 merits (approximately double amount)

The reason of top 200 sending much more what they received because many of the "Merit Sources"  lies in this bracket and some is due to airdropped merits..

[cryptohunter]

That information was also in that answer: (just check again the output of the sqls)

69120 is total merit recieved by top 200.
Receiving 69120 merit enable them to send only 34560 merits but they send 65641  merits (approximately double amount)

Now analyze top 100
48648  total merit received by top 100
Receiving  48648   merit will only enable them to send 24324 merits only  but they sent 47776 merits (approximately double amount)

The reason of top 200 sending much more what they received because many of the "Merit Sources"  lies in this bracket and some is due to airdropped merits..

thanks that is all very interesting to look through.

on the chart the output has one small issue that the left column starts at 2 as there was a small out put error but it does not really matter.

to me this is the most important analysis of the merit system so far.

[r1s2g3]

on the chart the output has one small issue that the left column starts at 2 as there was a small out put error but it does not really matter.

Fixed it now. Thanks for bringing it to my attention.

[cryptovigi]

I like the assumption of your ranking I think it shows the worth of poster in much more fair way than the sum of merits alone. What is very important it is partially immune to cheaters - Merit buyers/sellers who are promoted, e.g. to Full Member on two posts like these below:

...
100 merits for 2 posts:
50 for this

   yanlış                   doğru
Yumuklu Sucurta       Sucuklu Yumurta

and another 50 for this

Çin malından uzak durulmalı. Japon malları kalitelidir kafa ağrıtmaz. Evga Coolermaster Corsair FSP güvenerek alabilirsiniz.

translation:

Chinese goods should be avoided. Japanese goods are of good quality. Evga Coolermaster Corsair can rely on FSP.

100 merits - 2x50 for this one:

11de kalıyosa hızınız 16mb dır. Azını verir fazlasını vermez

translation:

Stay at 11, your speed is 16mb. Gives less, no more

...

[r1s2g3]

Bump

If somebody need some statistics, I will like to try .

[r1s2g3]

New list updated as of today:

Code:

Rank	UserName	count (distinct m.fromid)	Previous Value
1	theymos	640	565
2	LoyceV	274	232
3	Vod	229	201
4	Jet Cash	208	187
5	DdmrDdmr	202	158
6	The Pharmacist	196	156
7	explorder	194	192
8	suchmoon	190	147
9	satoshi	171	144
10	TMAN	160	141
11	hilariousetc	159	150
12	o_e_l_e_o	156	115
13	yahoo62278	156	145
14	iasenko	153	136
15	bill gator	150	147
16	bitmover	150	127
17	OgNasty	149	121
18	Lutpin	143	141
19	Last of the V8s	142	120
20	xtraelv	142	124
21	DarkStar_	140	114
22	gentlemand	140	115
23	qwk	138	112
24	Piggy	135	113
25	nullius	135	132
26	micgoossens	134	94
27	Lauda	133	117
28	TheQuin	133	131
29	ui_zakharchenko	133	133
30	TryNinja	130	111
31	Coolcryptovator	129	101
32	marlboroza	129	109
33	coinlocket$	128	103
34	LeGaulois	125	113
35	krogothmanhattan	125	103
36	tvplus006	124	114
37	achow101	123	109
38	HCP	119	109
39	JayJuanGee	116	108
40	franky1	116	96
41	HairyMaclairy	115	91
42	Hhampuz	115	95
43	xhomerx10	114	89
44	pooya87	109	92
45	BTCforJoe	108	108
46	theyoungmillionaire	108	108
47	QuestionAuthority	107	92
48	joniboini	106	99
49	stompix	105	96
50	Smart man	104	104
51	mjglqw	104	77
52	mdayonliner	103	98
53	hilariousandco	100	90
54	Carlton Banks	99	81
55	HeRetiK	98	87
56	kenzawak	98	#N/A
57	kirreev070	98	98
58	BobLawblaw	97	86
59	actmyname	97	83
60	infofront	96	84
61	pugman	95	94
62	hugeblack	94	88
63	Welsh	93	82
64	bones261	92	61
65	DannyHamilton	91	90
66	jojo69	91	78
67	ETFbitcoin	90	68
68	d5000	90	84
69	mocacinno	90	79
70	vit05	90	75
71	sncc	89	89
72	Ranyar	88	88
73	philipma1957	88	73
74	Elwar	87	77
75	Torque	87	84
76	buwaytress	87	76
77	zentdex	87	87
78	Steamtyme	86	71
79	bob123	86	76
80	killyou72	86	84
81	1Referee	85	75
82	DooMAD	85	72
83	pandukelana2712	85	83
84	AlyattesLydia	83	82
85	cellard	83	77
86	SFR10	82	77
87	athanz88	82	81
88	crypmike	82	75
89	LFC_Bitcoin	81	58
90	Silent26	81	81
91	Kakmakr	80	73
92	Mitchell	80	73
93	bitserve	80	#N/A
94	deeperx	79	78
95	mfort312	79	77
96	r1s2g3	79	54
97	Flying Hellfish	78	70
98	Heisenberg_Hunter	78	67
99	Toxic2040	78	62
100	mindrust	77	61
101	GameKyuubi	76	65
102	gmaxwell	76	54
103	BitCryptex	75	65
104	dbshck	75	72
105	OmegaStarScream	74	61
106	Xynerise	74	74
107	AdolfinWolf	73	66
108	EcuaMobi	73	67
109	Coin-1	72	56
110	Matthias9515	72	71
111	eddie13	72	#N/A
112	nutildah	71	#N/A
113	PHI1618	70	64
114	ibminer	70	60
115	lemonrabid	70	69
116	Raja_MBZ	68	52
117	taikuri13	68	54
118	vlad230	68	68
119	paxmao	67	64
120	Samarkand	66	66
121	amishmanish	66	65
122	Foxpup	65	#N/A
123	Goran_	65	58
124	TERA2	65	65
125	asche	65	#N/A
126	chimk	65	51
127	figmentofmyass	65	56
128	ICOEthics	64	#N/A
129	eternalgloom	64	51
130	Hydrogen	63	62
131	mikeywith	63	#N/A
132	odolvlobo	63	58
133	squatter	63	55
134	600watt	62	60
135	Coding Enthusiast	62	#N/A
136	Hakamura	62	62
137	Husna QA	62	58
138	Lafu	62	#N/A
139	ToTheMoon_XOM9IK	62	62
140	mole0815	62	51
141	nc50lc	62	61
142	roycilik	62	53
143	PavelRostov	61	61
144	Trofo	61	57
145	d_eddie	61	#N/A
146	finaleshot2016	61	60
147	hatshepsut93	61	#N/A
148	shahzadafzal	61	57
149	shorena	61	61
150	Alex_Sr	60	#N/A
151	Joel_Jantsen	60	60
152	Lucius	60	#N/A
153	bolshojkush	60	60
154	Pmalek	59	#N/A
155	poptop	59	54
156	Alone055	58	#N/A
157	Ariem	58	55
158	BrewMaster	58	54
159	Co1n	58	58
160	Quickseller	58	53
161	Sylon	58	58
162	mu_enrico	58	52
163	pitipawn	58	58
164	seoincorporation	58	#N/A
165	1miau	57	#N/A
166	cAPSLOCK	57	50
167	numanoid	57	57
168	tmfp	57	#N/A
169	Anon136	56	54
170	Juliya_D	56	#N/A
171	SaltySpitoon	56	#N/A
172	bL4nkcode	56	#N/A
173	esmanthra	56	#N/A
174	mithrim	56	56
175	sabotag3x	56	51
176	tonych	56	55
177	cabalism13	55	#N/A
178	mprep	55	#N/A
179	Paashaas	54	#N/A
180	Pursuer	54	#N/A
181	Veleor	54	#N/A
182	Xal0lex	54	#N/A
183	hirozaki faraday	54	54
184	sapta	54	53
185	xenon131	54	#N/A
186	BitcoinTurk	53	52
187	Daboy_Lyle	53	50
188	Don Pedro Dinero	53	#N/A
189	MagicSmoker	53	51
190	STT	53	#N/A
191	Slow death	53	#N/A
192	Speculatoross	53	53
193	Wind_FURY	53	51
194	aTriz	53	53
195	avikz	53	#N/A
196	butka	53	50
197	morvillz7z	53	#N/A
198	BTCMILLIONAIRE	52	#N/A
199	NeuroticFish	52	#N/A
200	TheUltraElite	52	#N/A
201	Wekkel	52	#N/A
202	jseverson	52	52
203	minerjones	52	#N/A
204	EFS	51	51
205	Ibian	51	#N/A
206	Limx Dev	51	#N/A
207	ocminer	51	#N/A
208	toknormal	51	#N/A
209	Claymore	50	50
210	LTU_btc	50	#N/A
211	S_Therapist	50	#N/A
212	cryptovigi	50	#N/A
213	kaar	50	50
214	kurious	50	#N/A

Link to Spread Sheet

So from past stats, look like 48 more user make up to this list.
As per user is Merited by 100+ user in this forum, number jumped from 41 to 53.

"#N/A" in previous value means that user is included in recent list only, not eligible in previous list.

Anybody want some other stats, I will like to try for it.