You are viewing a single comment's thread from:

RE: [STEEMSQL] A deep analysis of Steemians gratefulness

in #stats8 years ago

You are doing a great job! THANK YOU! I read all your articles, but I find it difficult to comment on, I do not know much English. But I'm with you!

Sort:  

Unfortunately, I don't speak Russian (yet).
Russian's "thanks" were not taken into account in the top 20 chart. Maybe you had a spot in.
This give me the idea on creating a tutorial on how to manage with other languages than English.
Спасибо!

If I can be useful, let me know in steemit.chat I will be glad!


He he he, was worth checking: you got pole position in the russian chart !
Congrats! Поздравление!

Потрясающе! Я и не думала!
How thrilling! I didn't know!
How you choose Russians?

I used the following query:

SELECT TOP 20
    Author,
    COUNT(*) AS [Post]
FROM
    TxComments
WHERE
    body LIKE '%Спасибо%'
GROUP BY
    Author
ORDER BY
    COUNT(*) DESC

It is less efficient than using CONTAINS() or FREETEXT() but these can't be used as full text search catalog is based on English locale.
If you need more help, please use steemsql channel on steemit.chat

I did not find any word "спасибо" at linkback-bot-v0