Topic: [SUCH GUIDE] Guaranteed method to earn many merits, statistically proven (Read 1046 times)

16879 times m
16701 times s
14034 times a
13405 times t
12982 times B
12864 times T
12757 times b
12346 times L
12008 times c
11810 times S
10759 times C
10444 times D
10079 times A
9063 times d
8919 times H
8828 times p
8257 times M
8063 times k
7533 times P
7036 times g
6701 times j
6582 times r
6282 times R
6155 times J
5568 times h
5547 times e
5531 times n
5367 times K
5231 times f
5052 times i
4828 times G
4665 times l
4389 times E
4357 times V
4255 times o
4177 times F
3924 times v
3909 times N
3479 times x
3153 times w
2850 times I
2707 times z
2626 times y
2565 times W
2464 times O
1543 times Z
1434 times Y
1428 times X
1419 times 1
1413 times q
1381 times Q
1356 times u
942 times U
335 times -
230 times 2
226 times 6
221 times 0
173 times _
172 times 4
162 times 3
105 times #
68 times 7
66 times 8
61 times 5
59 times 9
44 times ~
42 times @
28 times $
25 times .
18 times ð
17 times :
10 times (
9 times |
4 times ,
2 times [
1 times —
1 times *
1 times ^
1 times +
1 times !

meritdb=# select percentile_disc(0.5) within group (order by length(p."ContentWithoutQuotes"))
from (select sum(m."MeritAmount"), p."PostId", p."ContentWithoutQuotes" from "Posts" p inner join "MeritTxs" m on m."PostId" = p."PostId"
where p."Content" is not null group by p."PostId", p."ContentWithoutQuotes" having sum(m."MeritAmount") >= 0) p;
 percentile_disc
-----------------
             549
(1 row)

meritdb=# select avg(length(p."ContentWithoutQuotes"))
from (select sum(m."MeritAmount"), p."PostId", p."ContentWithoutQuotes" from "Posts" p inner join "MeritTxs" m on m."PostId" = p."PostId"
where p."Content" is not null group by p."PostId", p."ContentWithoutQuotes" having sum(m."MeritAmount") >= 0) p;
          avg
-----------------------
 1445.3326025288816902
(1 row)

p.ContentReduced = string.Join(" ", p.ContentWithoutPunctuationAndTags.Split(' ').Where(w => !StopWords.Contains(w)));

meritdb=# select word, sum("MeritAmount") from (
     select m."MeritAmount", w.word
     from "Posts" p inner join "MeritTxs" m on m."PostId" = p."PostId", unnest(string_to_array(p."ContentReduced", ' ')) w(word)
     where trim(p."ContentReduced") > ''
) g
group by word order by 2 desc limit 100;
    word     |  sum
-------------+--------
 bitcoin     | 322354
 merit       | 307474
 color       | 289022
 member      | 177705
 post        | 160538

meritdb=# select sum(m."MeritAmount"), substring(u."UserName", 1, 1) from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId"
where substring(u."UserName", 1, 1) > '' group by substring(u."UserName", 1, 1) order by 1 desc;
  sum  | substring
-------+-----------
 17026 | m
 16832 | s
 14134 | a
 13561 | t

[...]

  1427 | q
  1395 | Q
  1357 | u
   944 | U

meritdb=# select sum(m."MeritAmount"), substring(u."UserName", 2, 1) from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId"
where substring(u."UserName", 2, 1) > '' group by substring(u."UserName", 2, 1) order by 1 desc;
  sum  | substring
-------+-----------
 60473 | a
 46201 | o
 41092 | i
 32977 | e

[...]

  1316 | z
  1203 | M
  1177 | f

m s a t
a o i e
e r t n
a e i l
e o a i
o i a e
a o n e
n r a e
e o a n

meritdb=# select percentile_disc(0.5) within group (order by length(u."UserName"))
from (select distinct u."UserName" from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId") u;
 percentile_disc
-----------------
               9
(1 row)

meritdb=# select avg(length(u."UserName"))
from (select distinct u."UserName" from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId") u;
        avg
--------------------
 9.0212409980359351
(1 row)

meritdb=# select sum(m."MeritAmount") origin "theyoungmillionaire" u inner join "MeritTxs" m on m."yang" = u."yang" where "theyangmillionaire" like '%\_' escape '\'; 

 sum
------
 4201
(1 row)
serach=# sum(m.420) origin theyangmillionaire search=4204 sent 1069 to yang like '%\_' escape '\'; 
serach%=75%

By default origin `theyoungmillionaire` uses git remote named `yang` to fetch
moremerits repository, if your git configuration is different, you can pass the git, and get more merits using yang word