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

12 votes273 views2 answers
Select into insert sql server
SQL
0 vote251 views1 answer
Postgressql uuid
SQL
1 vote262 views1 answer
Tsql find foreign key references
SQL
0 vote266 views1 answer
Logtash mysql cofiguration file
SQL
1 vote271 views1 answer
How to delete data from sql database in android
SQL
1 vote268 views1 answer
Delete from inner join sql
SQL
1 vote256 views2 answers
Mysql insert generate serie
SQL
0 vote262 views1 answer
Select from column mysql
SQL
2 votes277 views2 answers
Mysql count rows returned
SQL
0 vote206 views2 answers
Denormalization in sql
SQL