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

1 vote137 views2 answers
Copy database mysql
SQL
0 vote150 views1 answer
Uncheck constraints and delete from table
SQL
0 vote122 views1 answer
Enable outgoing remote MySQL access
SQL
2 votes141 views1 answer
How to show the whole table in sql
SQL
0 vote145 views1 answer
Get create sql of hibernqte entity
SQL
0 vote126 views1 answer
How to find symmetric pairs in sql
SQL
1 vote133 views1 answer
Sql current timestamp
SQL
5 votes143 views1 answer
How to check port number for postgresql
SQL
0 vote154 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
4 votes139 views3 answers
Rename table column postgresql
SQL