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 vote157 views1 answer
T sql check active deadlock
SQL
6 votes154 views2 answers
Foreign key sqlite3 python
SQL
0 vote159 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote144 views1 answer
How many columns can be used for creating index?
SQL
2 votes176 views2 answers
Install postgresql
SQL
0 vote186 views2 answers
Search stored procedures by name
SQL
25 votes150 views6 answers
Modify column name in mysql
SQL
36 votes148 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote145 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote104 views1 answer
Print sum of values sql
SQL