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 votes151 views2 answers
Oracle apex view logs
SQL
0 vote146 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote146 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote147 views1 answer
Mysql change timestamp on update
SQL
3 votes131 views1 answer
Uppercase and lowercase in sql
SQL
0 vote137 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote137 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote131 views1 answer
Set column width in sqlplus
SQL
0 vote141 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote138 views1 answer
Selects all the columns from the sailors table
SQL