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

4 votes267 views2 answers
Error loading MySQLdb module.
SQL
1 vote268 views1 answer
Index a database column sql
SQL
1 vote283 views1 answer
Oracle turn off constraint
SQL
0 vote268 views1 answer
Sql describe
SQL
6 votes274 views2 answers
Where clause in sql
SQL
3 votes274 views1 answer
Mssql remove column
SQL
0 vote296 views1 answer
Get last three characters in mysql column
SQL
3 votes299 views4 answers
Ubuntu stop mysql
SQL
15 votes275 views2 answers
Select Options
SQL
0 vote245 views1 answer
Grant owner postgresql
SQL