XF 1.5 Query to count total likes of thread starter


Well-known member
I have downloaded my forum DB and imported it into a BI tool, and I'm having tons of fun creating lots of statistics.

One thing I am yet to figure out, is how do I count the total likes a thread starter has received for ALL his messages in each of his threads. I will then use that to sort the results as "threads by total likes for thread starter".

Any ideas?