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 vote176 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote193 views1 answer
Drop unique
SQL
0 vote185 views1 answer
TSQL function split string
SQL
0 vote242 views1 answer
Sql query for login with email or username
SQL
3 votes190 views1 answer
Apex set debug level
SQL
11 votes192 views2 answers
Set default column value sql
SQL
0 vote208 views1 answer
Mysql sql.gz
SQL
0 vote203 views1 answer
Open postgresql.conf in centos
SQL
6 votes187 views3 answers
Mysql change auto_increment start value
SQL
0 vote202 views2 answers
Nested query
SQL