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 vote224 views2 answers
What is rownum in oracle
SQL
4 votes200 views2 answers
Postgresql default value
SQL
0 vote209 views1 answer
Mysql change timestamp on update
SQL
0 vote199 views1 answer
Oracle last connection
SQL
0 vote203 views1 answer
Postpresql relation not found
SQL
0 vote229 views1 answer
Virtuoso sql query tutorial
SQL
22 votes244 views1 answer
Mysql workbench
SQL
9 votes201 views3 answers
Oracle undo usage by session
SQL
0 vote188 views1 answer
Oracle list proxy users
SQL
16 votes223 views3 answers
Get count of duplicate records
SQL