Mysql count with two joins

select
  t.Topic,
  t.Title,
  s.StarCount,
  m.UserCount,
  m.MessageCount
from
  Topics t
  left join (
    select 
      Topic, 
      count(distinct User) as UserCount,
      count(*) as MessageCount
    from Messages
    group by Topic
  ) m ON m.Topic = t.Topic
  left join (
    select
      Topic, 
      count(*) as StarCount
    from Stars_Given 
    group by Topic
  ) s ON s.Topic = t.Topic

Source: stackoverflow.com

Similar codes

0 vote259 views1 answer
How to create an SQL save method in ruby
SQL
2 votes269 views1 answer
Compare date in sql
SQL
2 votes284 views1 answer
How to find table table in stored procedure sql server
SQL
1 vote293 views1 answer
Set id count mysql
SQL
1 vote275 views2 answers
Mysql between
SQL
0 vote272 views1 answer
Mysql 1 hour ago
SQL
4 votes244 views2 answers
What is table in sql
SQL
0 vote257 views1 answer
Call function sql oracle
SQL
0 vote283 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote323 views2 answers
How to check if a column exists in a SQL Server table?
SQL