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

10 votes309 views3 answers
Sql check double value
SQL
0 vote313 views1 answer
Copy value from one column to another postgres
SQL
0 vote298 views1 answer
Update using case in mysql
SQL
0 vote347 views1 answer
PostgreSQL types and C# types
SQL
6 votes331 views4 answers
Mysql update set
SQL
0 vote305 views2 answers
Sql searching via key word
SQL
8 votes327 views1 answer
Oracle search text in all packages
SQL
2 votes303 views2 answers
Postgres select duplicate columns
SQL
0 vote304 views1 answer
Mysql workbench view
SQL
3 votes374 views1 answer
Oracle list invalid password logon denied
SQL