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 vote320 views1 answer
Sql query wordpress export post
SQL
1 vote308 views1 answer
Round one decimal place mysql
SQL
0 vote288 views1 answer
Laravel eloquent get generated sql
SQL
1 vote285 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
1 vote298 views1 answer
Mysql current running queries
SQL
1 vote290 views1 answer
Mysql best tutorial for beginners
SQL
0 vote299 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote294 views2 answers
Get top 1 row of each group
SQL
3 votes320 views1 answer
Sql print all names that start with a given letter
SQL
0 vote281 views1 answer
Object Information
SQL