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 vote316 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
3 votes299 views1 answer
Make a field auto_increment mysql
SQL
93 votes438 views4 answers
Create database postgres
SQL
6 votes338 views1 answer
Postgresql add enum value
SQL
1 vote312 views2 answers
Oracle list partitioned tables
SQL
0 vote307 views1 answer
Get server date mysql
SQL
0 vote300 views4 answers
Mysql replace regex
SQL
-1 vote371 views1 answer
Difference berween database and data base management system
SQL
6 votes365 views2 answers
How to get last element sql
SQL
1 vote303 views2 answers
End mysql command
SQL