A huge hug  🤗 and a little bit of !BEER 🍻 from @amico! 
___
Un caro abbraccio 🤗 e un po' di BEER 🍻 da @amico!

Good trick to SUBSTRINGify the url to find the post author.

But when dealing with dates, you should use ANSI date format (YYYY-MM-DD) because you do not know the locale of the server. Would it be a different date format than US (MM/DD/YYYY), or change to a different format, your query will fail.

By replacing `created > '03/20/2020 15:00:00'` with `created > '2020-03-20 15:00:00'`, your query will **never** fail, whatever the locale of the server.

Add to this that the latest format is more "universal" and is less confusing. 

I think the 'outreach' engagement is a good idea. While I tend to view and comment on several post a day, I do realize that most of my comments go to the same grouping of people, so I know I need to reach out more.

It has been quite some time since the last League update, and this could be a nice metric to add.

> And if so, do you think this type of 'outreach' engagement, should be scored higher than engaging on your own posts?

I think engagement is meant to be both ways. Your post and other people's post.  This will help in discovering people with good content too.


New users have to comment on other posts to get seen unlike the big boys who know themselves already. You might then notice that there are constant people on most of the posts done by the orcas ... 
Well this criterion will make things tougher on the engagement league.

 ~ I didn't post and spent most of my day replying to comments on my on blog, and whilst this makes my numbers look good in the table below, I do feel that my engagement on the posts of others has not been anything special.~
I have thought about doing one day of only reading and commenting. but i am here to post, i am the girl with the ideas and love to make a blog. 
I think if someone spent a moment or even two to comment on a masterpiece blog you did the least you can do is be nice and answer back just as in real life.

That said, it will take away time to spend to comment outside your own blog. 

~ Do you think it is worth looking at comments made outside of own posts, and number of different people spoken to outside of your own posts? ~ 
well yes, your are the list guy, and this could provide a whole different look on the list and might be interesting. Or a separate league. In the past there were tow leagues aswell remember. And there are sponsors enough.

That ‘outreach' engagement, could be scored higher than engaging on your own posts, and make total engagement better in numbers i guess. 

But i am a fan of the list on sunday but maybe it need a few new rows, as i said could be interesting ! More work for you less biking though

We could also tie our sweet orca at the number 1 place to a chair ( Janton style) without his computer and see what happens to the numbers hahahahah, they will be different i tell ya,

Oh and dont tell him i want to tie him to a chair please,
B

So with 319 comments on different author is actually good for me, can be better. Interesting case study.

Oh my it's so cool you can make all of these statistics and show it to us. There are some serious heavy weight champions in here haha

Those are some impressive numbers and the number of different people visited is truly remarkable.

Hey mate, some interesting stats. Showing  commenting statistics *outside of ones own posts* would be a good addition to the EL I think. It will show who is spreading the engagement around and who is commenting with a small select group. 

I was pleased to see my nearly 50/50 split although a little disappointed to see my *unique users commented on* being a little lower. I considered why this may be. 

I think, for me, it is because I focus on supporting people through engagement and that process takes time to develop. Hence my commenting is less widespread, but penetrates much deeper. 

Me spreading 620 comments a week between 620 accounts would provide no value to those 620 accounts...Follow up commenting and engagement is required, not simply *drop and run* commenting. 

Engaging to me doesn't mean dropping as many comments as possible, but getting involved, conversing. That's my idea of it, and I think the comment count, split between within and without my posts and character count demonstrates that. 

This is a good post, and interesting statistics, although the code did my head in. (I'm a dumb bastard so don't understand it.) I hope people can see patterns here, and that they can see the benefit of engaging for effect, not just engaging to make it up the list on the EL.

Aww thank you for the shoutout!
Not at all surprised to see trincowski and ryivhnn :D I've got a lot to learn from them xD

>The final list shows the accounts who have commented on the most unique accounts' posts on Hive (since 3 pm 20th March 2020)

That's a really good addition :D

Unfortunately I don't understand any of the code part, but your compilations and stats are easy to understand (I think haha) Actually most of those posting a lot are also diversifying :D

I had a week off in this period. That must really have dented my stats!!

I do try to comment on other posts, I am not a fan of those who only ever reply but there are a lot of those kind of authors.

I have joined a table to itself before, usually when you make the table as an alias and nested selects. It isn't the most graceful. 

select * from comments com1 
where blah in (select * from blah)
And blah in/not in etc

But fuck it, yours works!! :0D

I'm quite thrilled to see that I made it on your sample lists! A great way for me to reach out is by using Communities! If I comment on all the posts in #FeatheredFriends, #ShadowHunters and then go to @barbara-orenya's #FeelGood Community it provides me with more posts to comment on than I can manage in a day! I really hope that we see communities being supported and utilized more and more! A lot of the Redfish that post into Shadowhunters could use more encouragement! 

Wow you took your time to do all these? This is huge and really helpful. Well its good to post but interacting with others is also a key part to be relevant on the blockchain.

This shows another picture very different from your last statistics, could be good info for the engagement league, sincerely I didn't expect so drastic changes in the data, some of the users on the list are veterans from the engagement league also but including this possibly they will be better ranked, I'm happy for trinkowski and brittandjosie two users that I appreciate a lot because they do a fantastic job in Hive engaging with others.

Excellent work abh12345.  

I would bet my "engagement" outside of my own posts must be way higher. Not because I'm not replying and engaging enough with the commenters of my posts. But because there don't seem to be many kamikazes here who dare to comment on my articles. LoL

I know I am super appreciative of the comments given to me and I do make an effort to leave at least a few comments a day on the posts of others but I have to admit that it is among my circle of friends. Although, I upvote a wider circle. Time is always the factor. Another factor that might be interesting to study is the length and original content in each comment. I get a lot of 'nice picture(s)' on posts that were more than just a picture. Should we consider qualitative measures of comments as well as quantitative?

I would find it helpful to separate replies to comments on the author's own posts from comments made on other authors' posts.
They're both important so I wouldn't rank either one higher than the other.
I guess a minimum five word/20 character threshold could eliminate lots of the "nice picture" comments, but on the other hand it could also knock out the little riffs of repartee which are such a joy to read :)
I found it useful, when I was new, to get the feedback that the Engagment League provides: I'm always more or less in the shallows, so I felt that my engagement was about right for the time I had available and what I wanted to do.
Is there still a redfish league? I thought this was really good for smaller accounts, as there may be too much competition for them to appear in the Engagement League, but the redfish league would still provide them with some feedback.
Thank you for this - all really interesting :)