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 vote146 views1 answer
Postgre query date
SQL
8 votes127 views1 answer
Unique vs primary key
SQL
0 vote134 views1 answer
Sql select by content lenght
SQL
0 vote137 views1 answer
How to put value in parameters in mysqldataadapter
SQL
6 votes126 views1 answer
Oracle list primary key
SQL
2 votes163 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote152 views1 answer
Sqlalchemy query join many to many
SQL
0 vote154 views1 answer
Kill mysqld_safe process mariadb
SQL
13 votes136 views1 answer
Views in sql
SQL
1 vote155 views1 answer
Oracle select row max date
SQL