Re: IS THE MERIT SYSTEM being used correctly by a small clique of individuals here

Quote from: cryptohunter on November 09, 2018, 12:21:43 PM

I would also like to see which boards get the most merit action. This is very important too.

Edit: These are the top merit receivers by local section / non-local section:

For any local section:

Code:

Total Merit Local board
574 Bahasa Indonesia (Indonesian)
420 Deutsch (German)
371 Pyccкий (Russian)
339 Türkçe (Turkish)
246 Português (Portuguese)
184 Français
153 Hrvatski (Croatian)
144 Español (Spanish)
137 Italiano (Italian)
132 Philippines
120 中文 (Chinese)
100 日本語 (Japanese)
77 Nederlands (Dutch)
75 العربية (Arabic)
66 한국어 (Korean)
63 Other languages/locations
42 Eλληνικά (Greek)
37 Română (Romanian)
34 Polski
30 India
2 Skandinavisk

For any non-local section:

Code:

Total Merit Non-Local board
2418 Meta
1263 Bitcoin Discussion
1067 Beginners & Help
951 Economics
692 Development & Technical Discussion
553 Marketplace
392
365 Announcements (Altcoins)
313 Bitcoin Technical Support
299 Off-topic
290 Trading Discussion
271 Mining (Altcoins)
247 Marketplace (Altcoins)
242 Mining
192 Altcoin Discussion
135 Project Development
132 Serious discussion
128 Politics & Society
125 Archival
123 Speculation (Altcoins)

Credits to Piggy for his SQL Merit search tool.

Query used for the non-local section:

Code:

SELECT MAX(result.total) as "Total Merit", result.SubBoard as "Non-Local board" FROM (
SELECT toid, SubBoard, SUM(Merit) AS total
FROM meritdata as m
WHERE m.Board in (SELECT Board FROM meritdata Where Board not like "Local%" GROUP BY Board)
GROUP BY toid, Board
ORDER BY Board,total Desc) AS result
GROUP BY SubBoard
ORDER BY result.total Desc

Query used for the local section:

Quote from: Piggy on June 27, 2018, 07:31:57 AM

We can easily get the Top Receiver for any local section simply using this:

Code:

SELECT MAX(result.total) as "Total Merit", result.toid as "Top merit receiver", result.SubBoard as "Local board" FROM (
SELECT toid, SubBoard, SUM(Merit) AS total
FROM meritdata as m
WHERE m.Board in (SELECT Board FROM meritdata Where Board like "Local%" GROUP BY Board)
GROUP BY toid, Board
ORDER BY Board,total Desc) AS result
GROUP BY SubBoard
ORDER BY result.total Desc

EDIT:
This seems to be the correct query, the queries above refer to the top merit receivers by subboard.

Code:

SELECT SUM(Merit) as "Total Merit", board, subboard from MeritData
Group by SubBoard
order by SUM(merit) desc

Code:

Total Merit Board SubBoard
31067 Local Pyccкий (Russian)
30475 Alternate cryptocurrencies Announcements (Altcoins)
26075 Other Meta
20590 Economy Economics
16800 Economy Marketplace
14432 Local Türkçe (Turkish)
12787 Alternate cryptocurrencies Altcoin Discussion
12266 Bitcoin Bitcoin Discussion
11083 Message DELETED!
9769 Local Bahasa Indonesia (Indonesian)
7905 Economy Trading Discussion
7423 Local Deutsch (German)
7110 Bitcoin Development & Technical Discussion
6273 Alternate cryptocurrencies Marketplace (Altcoins)
5275 Alternate cryptocurrencies Mining (Altcoins)
4738 Other Beginners & Help
3584 Local Français
3283 Bitcoin Mining
3065 Other Off-topic
3016 Alternate cryptocurrencies Speculation (Altcoins)
2677 Other Politics & Society
2658 Other Serious discussion
2624 Local Italiano (Italian)
2381 Local 中文 (Chinese)
2197 Local Español (Spanish)
2141 Local Philippines
1826 Local Português (Portuguese)
1757 Bitcoin Bitcoin Technical Support
1727 Local Hrvatski (Croatian)
954 Bitcoin Project Development
660 Local العربية (Arabic)
563 Local Other languages/locations
544 Local Eλληνικά (Greek)
512 Local 日本語 (Japanese)
349 Local Nederlands (Dutch)
337 Local Polski
247 Other Archival
198 Local India
139 Local Română (Romanian)
100 Local 한국어 (Korean)
2 Local Skandinavisk

Query for cross-checking with the total merit query:

Code:

SELECT SUM("Total Merit") from (
SELECT SUM(Merit) as "Total Merit", board, subboard from MeritData
Group by SubBoard
order by SUM(merit) desc)

--> Seems good now:

Code:

SUM("Total Merit")
261609

Code:

SELECT SUM(Merit) from MeritData

Total Merit:

Code:

SUM(Merit)
261609