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 vote186 views1 answer
Mysql take number in string
SQL
1 vote188 views2 answers
Check if word is in column sql
SQL
1 vote213 views1 answer
Join to find results not in another table
SQL
0 vote226 views1 answer
Sql server current time without date
SQL
4 votes185 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote203 views2 answers
Plpgsql
SQL
2 votes305 views2 answers
MySql FULL OUTER JOIN
SQL
15 votes177 views1 answer
Mysql int range
SQL
0 vote184 views2 answers
Py sqlite if entry exists
SQL
2 votes180 views1 answer
Update trigger
SQL