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 votes127 views5 answers
Between keyword in sql
SQL
3 votes195 views1 answer
Sql add two values together
SQL
0 vote125 views1 answer
MySql get primary keys of table
SQL
0 vote141 views1 answer
Mysql value ends with
SQL
0 vote136 views1 answer
Mysql check if lowercase
SQL
0 vote131 views1 answer
Search starting with mysql
SQL
0 vote142 views2 answers
Php convert dbf to mysql
SQL
16 votes119 views1 answer
Mysql mediumint max value
SQL
0 vote100 views0 answer
SQL
0 vote125 views1 answer
How to order result of subquery in select
SQL