Mysql select and count left join

select
  t.Topic,
  t.Title,
  count(distinct s.starID) as StarCount,
  count(distinct m.User) as UserCount,
  count(distinct m.messageID) as MessageCount
from
  Topics t
  left join Messages m ON m.Topic = t.Topic
  left join Stars_Given s ON s.Topic = t.Topic
group by
  t.Topic,
  t.Title

Source: stackoverflow.com

Similar codes

0 vote128 views1 answer
Rabbitmq ui not working
SQL
0 vote122 views1 answer
Mysqldump ignore table
SQL
0 vote125 views1 answer
GROUP BY postgres
SQL
0 vote123 views1 answer
Sql get count without group by
SQL
0 vote141 views1 answer
Postgresql inline table
SQL
0 vote134 views1 answer
How to run mysql on terminal mac
SQL
1 vote75 views1 answer
Postgresql last element of array
SQL
0 vote124 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote132 views1 answer
Oracle string substitution
SQL
2 votes123 views1 answer
Sql find missing values between two tables
SQL