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

3 votes232 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote240 views1 answer
How to check xampp mysql password
SQL
0 vote235 views1 answer
Components/Fields of Internal Table
SQL
5 votes243 views2 answers
Postgres update with if condition query
SQL
4 votes250 views1 answer
Mysql delete last row
SQL
0 vote230 views2 answers
Mysql regexp match word
SQL
0 vote210 views1 answer
Mysql workbench search all tables
SQL
14 votes248 views4 answers
Remove record from table sql
SQL
3 votes277 views1 answer
Mysql group_concat distinct
SQL
9 votes263 views3 answers
Date format in sql
SQL