Bitcoin Forum

m
a
e
a
e
o
a
n
e

bitcoin
merit
color
member
post
users
new
btc
thread
people
like
time
yang
wallet
url
forum
get
use
trust
code
see
coin
size
make
link
good
mining
bounty
first
blockchain
address
even
need
account
crypto
think
many
list
know
signature
system
network
full
campaign
want
block
bitcointalk
using
miner
work

meritdb=# select sum(m."MeritAmount") from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId" where "UserName" like '%\_' escape '\';
 sum
------
 1884
(1 row)

meritdb=# select sum(m."MeritAmount") from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId" where "UserName" not like '%\_' escape '\';
  sum
--------
 350477
(1 row)

meritdb=# select avg(m."MeritAmount") from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId" where "UserName" like '%\_' escape '\';
        avg
--------------------
 1.9686520376175549
(1 row)

meritdb=# select avg(m."MeritAmount") from "Users" u inner join "MeritTxs" m on m."ToUserId" = u."UserId" where "UserName" not like '%\_' escape '\';
        avg
--------------------
 2.0444798338641746
(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

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"), 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(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

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 !