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 vote355 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote336 views1 answer
Oracle merge insert if not exists
SQL
0 vote342 views1 answer
Multiple tricky query in sql server
SQL
0 vote358 views1 answer
Order by with where clause in mysql
SQL
2 votes344 views1 answer
Oracle drop sequence if exists
SQL
0 vote377 views1 answer
Plsql check how much space all databases are consuming
SQL
14 votes402 views6 answers
Finding duplicate rows mysql
SQL
0 vote333 views1 answer
Sql find table by name
SQL
0 vote335 views1 answer
Sql server inner join convert collation
SQL
0 vote333 views1 answer
Replace multiple string in query sql
SQL