Ok, so your logic is in MySQL? or do you use another language?

I know MySQL has some distinct differences from SQL Server, but I've worked with both sets of logic before and it's not so different that you can't match things up.

I'm running a similar analysis using SQL Server Management Studio (SSMS), which uses vanilla SQL, and was interested in the proper logic for calculation of payouts (how much goes to the author vs curator and such).

If you could point me in the right direction, or share that part of your code, I'd greatly appreciate it.

Thanks!