Database query that perform joins, aggregations and sorting - View it on GitHub