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

0 vote342 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
2 votes326 views1 answer
Drop table if exists in postgres
SQL
0 vote402 views1 answer
Pagination with row_number
SQL
8 votes332 views3 answers
Alter table auto_increment
SQL
1 vote337 views2 answers
Copy database mysql
SQL
1 vote351 views1 answer
Get create table query existing table mysql
SQL
0 vote421 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote374 views1 answer
Manage Database in MySQL
SQL
17 votes344 views6 answers
MySQL ORDER BY
SQL
11 votes330 views2 answers
Oracle all source
SQL